github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/migrations/019_move_egress_to_team_values.sql (about) 1 -- +goose Up 2 ALTER TABLE teams DROP COLUMN "restrict_airflow_egress"; 3 4 -- Set up default values for each Airflow already installed 5 insert into chart_team_values (team_id, "key", "value", chart_type) 6 select distinct team_id, 'restrictEgress,omit', 'false', 'airflow'::chart_type from chart_team_values where chart_type = 'airflow'; 7 8 -- +goose Down 9 ALTER TABLE teams ADD COLUMN "restrict_airflow_egress" BOOLEAN NOT NULL DEFAULT false; 10 11 -- Remove restrictEgress,omit key for each installed Airflow 12 delete from chart_team_values where "key" = 'restrictEgress,omit' and chart_type = 'airflow';