Modern Docker Management, Designed for Everyone
Go composecontainer-managementcontainersdockerdocker-composedocker-managementgoself-hostedsveltekittypescriptweb-ui
-- +goose NO TRANSACTION
-- +goose Up
ALTER TABLE projects ADD COLUMN compose_project_name TEXT;
-- +goose Down
PRAGMA foreign_keys=OFF;
BEGIN;
CREATE TABLE projects_new (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
dir_name TEXT,
path TEXT NOT NULL,
status TEXT NOT NULL,
service_count INTEGER NOT NULL DEFAULT 0,
running_count INTEGER NOT NULL DEFAULT 0,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME,
status_reason TEXT,
gitops_managed_by TEXT
);
INSERT INTO projects_new (
id, name, dir_name, path, status, service_count, running_count,
created_at, updated_at, status_reason, gitops_managed_by
)
SELECT
id, name, dir_name, path, status, service_count, running_count,
created_at, updated_at, status_reason, gitops_managed_by
FROM projects;
DROP TABLE projects;
ALTER TABLE projects_new RENAME TO projects;
CREATE INDEX IF NOT EXISTS idx_projects_status ON projects(status);
CREATE INDEX IF NOT EXISTS idx_projects_name ON projects(name);
CREATE INDEX IF NOT EXISTS idx_projects_gitops_managed_by ON projects(gitops_managed_by);
CREATE INDEX IF NOT EXISTS idx_projects_dir_name_not_null ON projects(dir_name) WHERE dir_name IS NOT NULL;
CREATE UNIQUE INDEX IF NOT EXISTS idx_projects_path_unique ON projects(path);
COMMIT;
PRAGMA foreign_keys=ON;