Modern Docker Management, Designed for Everyone
Go composecontainer-managementcontainersdockerdocker-composedocker-managementgoself-hostedsveltekittypescriptweb-ui
-- +goose Up
ALTER TABLE environments ADD COLUMN hidden INTEGER NOT NULL DEFAULT 0;
ALTER TABLE environments ADD COLUMN parent_environment_id TEXT;
ALTER TABLE environments ADD COLUMN swarm_node_id TEXT;
CREATE INDEX IF NOT EXISTS idx_environments_hidden ON environments(hidden);
CREATE INDEX IF NOT EXISTS idx_environments_parent_environment_id ON environments(parent_environment_id);
CREATE INDEX IF NOT EXISTS idx_environments_swarm_node_id ON environments(swarm_node_id);
CREATE INDEX IF NOT EXISTS idx_environments_parent_swarm_node ON environments(parent_environment_id, swarm_node_id);
-- +goose Down
DROP INDEX IF EXISTS idx_environments_parent_swarm_node;
DROP INDEX IF EXISTS idx_environments_swarm_node_id;
DROP INDEX IF EXISTS idx_environments_parent_environment_id;
DROP INDEX IF EXISTS idx_environments_hidden;
ALTER TABLE environments DROP COLUMN swarm_node_id;
ALTER TABLE environments DROP COLUMN parent_environment_id;
ALTER TABLE environments DROP COLUMN hidden;