github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/migrations/003_chart_values.sql (about) 1 -- +goose Up 2 CREATE TYPE CHART_TYPE AS ENUM ('jupyterhub', 'airflow'); 3 4 CREATE TABLE chart_global_values 5 ( 6 "id" uuid DEFAULT uuid_generate_v4(), 7 "created" TIMESTAMPTZ DEFAULT NOW(), 8 "key" TEXT NOT NULL, 9 "value" TEXT NOT NULL, 10 "chart_type" CHART_TYPE NOT NULL, 11 PRIMARY KEY (id) 12 ); 13 14 CREATE TABLE chart_team_values 15 ( 16 "id" uuid DEFAULT uuid_generate_v4(), 17 "created" TIMESTAMPTZ DEFAULT NOW(), 18 "key" TEXT NOT NULL, 19 "value" TEXT NOT NULL, 20 "chart_type" CHART_TYPE NOT NULL, 21 "team_id" TEXT NOT NULL, 22 PRIMARY KEY (id), 23 CONSTRAINT fk_chart_team_values_team 24 FOREIGN KEY (team_id) 25 REFERENCES teams (id) ON DELETE CASCADE 26 ); 27 28 -- +goose Down 29 DROP TABLE chart_team_values; 30 DROP TABLE chart_global_values; 31 DROP TYPE CHART_TYPE;