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

     1  BEGIN;
     2    ALTER TABLE resource_configs
     3      ADD COLUMN unique_versions_resource_id integer,
     4      ADD CONSTRAINT resource_configs_unique_versions_resource_id_fkey FOREIGN KEY (unique_versions_resource_id) REFERENCES resources(id) ON DELETE CASCADE,
     5      DROP CONSTRAINT resource_configs_resource_cache_id_so_key,
     6      DROP CONSTRAINT resource_configs_base_resource_type_id_so_key,
     7      ADD CONSTRAINT resource_configs_resource_cache_id_so_unique_versions_resource_id_key UNIQUE (resource_cache_id, source_hash, unique_versions_resource_id),
     8      ADD CONSTRAINT resource_configs_base_resource_type_id_so_unique_versions_resource_id_key UNIQUE (base_resource_type_id, source_hash, unique_versions_resource_id);
     9  
    10    ALTER TABLE base_resource_types
    11      ADD COLUMN unique_version_history boolean NOT NULL DEFAULT false;
    12  COMMIT;