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

     1  BEGIN;
     2    CREATE UNIQUE INDEX worker_resource_caches_uniq
     3    ON worker_resource_caches (resource_cache_id, worker_base_resource_type_id);
     4  
     5    CREATE UNIQUE INDEX worker_task_caches_uniq
     6    ON worker_task_caches (job_id, step_name, worker_name, path);
     7  
     8    DELETE FROM worker_resource_config_check_sessions r1
     9    USING worker_resource_config_check_sessions r2
    10    WHERE r1.id < r2.id
    11    AND r1.resource_config_check_session_id = r2.resource_config_check_session_id
    12    AND r1.worker_base_resource_type_id = r2.worker_base_resource_type_id
    13    AND r1.team_id = r2.team_id;
    14  
    15    CREATE UNIQUE INDEX worker_resource_config_check_sessions_uniq
    16    ON worker_resource_config_check_sessions (resource_config_check_session_id, worker_base_resource_type_id, team_id);
    17  COMMIT;