github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1548261635_create_table_resource_config_scopes.down.sql (about)

     1  BEGIN;
     2  
     3    ALTER TABLE resources
     4      DROP COLUMN resource_config_scope_id;
     5  
     6    TRUNCATE TABLE resource_config_versions CASCADE;
     7  
     8    ALTER TABLE resource_config_versions
     9      DROP COLUMN resource_config_scope_id,
    10      ADD COLUMN "resource_config_id" integer NOT NULL REFERENCES resource_configs (id) ON DELETE CASCADE,
    11      ADD CONSTRAINT "resource_config_id_and_version_md5_unique" UNIQUE ("resource_config_id", "version_md5");
    12  
    13    DROP TABLE resource_config_scopes;
    14  
    15    DROP INDEX resource_configs_resource_cache_id_so_key;
    16    DROP INDEX resource_configs_base_resource_type_id_so_key;
    17  
    18    ALTER TABLE resource_configs
    19      ADD COLUMN last_checked timestamp with time zone NOT NULL DEFAULT '1970-01-01 00:00:00',
    20      ADD COLUMN unique_versions_resource_id integer,
    21      ADD COLUMN check_error text,
    22      ADD CONSTRAINT resource_configs_unique_versions_resource_id_fkey FOREIGN KEY (unique_versions_resource_id) REFERENCES resources(id) ON DELETE CASCADE,
    23      ADD CONSTRAINT resource_configs_resource_cache_id_so_unique_versions_resource_id_key UNIQUE (resource_cache_id, source_hash, unique_versions_resource_id),
    24      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);
    25  
    26  COMMIT;