Modern Docker Management, Designed for Everyone
Go composecontainer-managementcontainersdockerdocker-composedocker-managementgoself-hostedsveltekittypescriptweb-ui
-- +goose Up
-- Rename stacks -> projects
ALTER TABLE IF EXISTS stacks RENAME TO projects;
-- Remove legacy cache table
DROP TABLE IF EXISTS project_cache;
-- +goose Down
-- Recreate legacy cache table
CREATE TABLE IF NOT EXISTS project_cache (
id TEXT PRIMARY KEY,
created_at TIMESTAMPTZ,
updated_at TIMESTAMPTZ,
deleted_at TIMESTAMPTZ,
stack_id TEXT NOT NULL,
name TEXT NOT NULL,
status TEXT NOT NULL,
service_count INTEGER NOT NULL DEFAULT 0,
running_count INTEGER NOT NULL DEFAULT 0,
auto_update BOOLEAN NOT NULL DEFAULT FALSE,
last_modified TIMESTAMPTZ,
compose_hash TEXT NOT NULL DEFAULT '',
cached_at TIMESTAMPTZ
);
CREATE UNIQUE INDEX IF NOT EXISTS idx_project_cache_stack_id ON project_cache(stack_id);
-- Rename projects -> stacks
ALTER TABLE IF EXISTS projects RENAME TO stacks;