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

     1  BEGIN;
     2    ALTER TABLE jobs
     3        ALTER COLUMN next_build_id TYPE integer,
     4        ALTER COLUMN latest_completed_build_id TYPE integer,
     5        ALTER COLUMN transition_build_id TYPE integer;
     6  
     7    ALTER TABLE build_pipes
     8        ALTER COLUMN from_build_id TYPE integer,
     9        ALTER COLUMN to_build_id TYPE integer;
    10  
    11    ALTER TABLE build_image_resource_caches
    12        ALTER COLUMN build_id TYPE integer;
    13  
    14    ALTER TABLE build_resource_config_version_inputs
    15        ALTER COLUMN build_id TYPE integer;
    16  
    17    ALTER TABLE build_resource_config_version_outputs
    18        ALTER COLUMN build_id TYPE integer;
    19  
    20    ALTER TABLE containers
    21        ALTER COLUMN build_id TYPE integer;
    22  
    23    ALTER TABLE next_build_pipes
    24        ALTER COLUMN from_build_id TYPE integer;
    25  
    26    ALTER TABLE pipelines
    27        ALTER COLUMN parent_build_id TYPE integer;
    28  
    29    ALTER TABLE resource_cache_uses
    30        ALTER COLUMN build_id TYPE integer;
    31  
    32    ALTER TABLE successful_build_outputs
    33        ALTER COLUMN build_id TYPE integer;
    34  
    35    ALTER TABLE worker_artifacts
    36        ALTER COLUMN build_id TYPE integer;
    37  COMMIT;