Skip to content

Modern Docker Management, Designed for Everyone

834 B
Raw Blame
-- +goose Up
CREATE TABLE global_variables (
    id TEXT PRIMARY KEY,
    created_at TIMESTAMPTZ NOT NULL,
    updated_at TIMESTAMPTZ,
    key TEXT NOT NULL,
    value TEXT NOT NULL DEFAULT '',
    is_secret BOOLEAN NOT NULL DEFAULT FALSE,
    all_environments BOOLEAN NOT NULL DEFAULT TRUE
);

CREATE INDEX idx_global_variables_key ON global_variables(key);

CREATE TABLE global_variable_environments (
    global_variable_id TEXT NOT NULL REFERENCES global_variables(id) ON DELETE CASCADE,
    environment_id TEXT NOT NULL REFERENCES environments(id) ON DELETE CASCADE,
    PRIMARY KEY (global_variable_id, environment_id)
);

CREATE INDEX idx_global_variable_environments_env ON global_variable_environments(environment_id);

-- +goose Down
DROP TABLE IF EXISTS global_variable_environments;
DROP TABLE IF EXISTS global_variables;