github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1601993583_add_instancevars_to_pipelines.up.sql (about)

     1  BEGIN;
     2  
     3    ALTER TABLE pipelines ADD COLUMN instance_vars jsonb;
     4  
     5    ALTER TABLE pipelines DROP CONSTRAINT pipelines_name_team_id;
     6  
     7    CREATE UNIQUE INDEX pipelines_name_team_id
     8    ON pipelines (name, team_id)
     9    WHERE instance_vars IS NULL;
    10  
    11    CREATE UNIQUE INDEX pipelines_name_team_id_instance_vars
    12    ON pipelines (name, team_id, instance_vars)
    13    WHERE instance_vars IS NOT NULL;
    14  
    15    ALTER TABLE containers ADD COLUMN meta_pipeline_instance_vars text DEFAULT ''::text NOT NULL;
    16  
    17  COMMIT;