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;