Skip to content

Modern Docker Management, Designed for Everyone

358 B
Raw Blame
-- +goose Up
ALTER TABLE projects ADD COLUMN is_archived BOOLEAN NOT NULL DEFAULT 0;
ALTER TABLE projects ADD COLUMN archived_at DATETIME;
CREATE INDEX idx_projects_is_archived ON projects(is_archived);

-- +goose Down
DROP INDEX IF EXISTS idx_projects_is_archived;
ALTER TABLE projects DROP COLUMN archived_at;
ALTER TABLE projects DROP COLUMN is_archived;