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

     1  BEGIN;
     2      ALTER TABLE build_inputs
     3        ALTER COLUMN modified_time TYPE timestamp without time zone;
     4  COMMIT;
     5  
     6  BEGIN;
     7      ALTER TABLE build_outputs
     8        ALTER COLUMN modified_time TYPE timestamp without time zone;
     9  COMMIT;
    10  
    11  BEGIN;
    12      ALTER TABLE cache_invalidator
    13        ALTER COLUMN last_invalidated TYPE timestamp without time zone;
    14      ALTER TABLE cache_invalidator
    15        ALTER COLUMN last_invalidated SET DEFAULT '1970-01-01 00:00:00'::timestamp without time zone;
    16  COMMIT;
    17  
    18  BEGIN;
    19      ALTER TABLE containers
    20        ALTER COLUMN best_if_used_by TYPE timestamp without time zone;
    21  COMMIT;
    22  
    23  BEGIN;
    24      ALTER TABLE pipelines
    25        ALTER COLUMN last_scheduled TYPE timestamp without time zone;
    26      ALTER TABLE pipelines
    27        ALTER COLUMN last_scheduled SET DEFAULT '1970-01-01 00:00:00'::timestamp without time zone;
    28  COMMIT;
    29  
    30  BEGIN;
    31      ALTER TABLE resource_types
    32        ALTER COLUMN last_checked TYPE timestamp without time zone;
    33      ALTER TABLE resource_types
    34        ALTER COLUMN last_checked SET DEFAULT '1970-01-01 00:00:00'::timestamp without time zone;
    35  COMMIT;
    36  
    37  BEGIN;
    38      ALTER TABLE resources
    39        ALTER COLUMN last_checked TYPE timestamp without time zone;
    40      ALTER TABLE resources
    41        ALTER COLUMN last_checked SET DEFAULT '1970-01-01 00:00:00'::timestamp without time zone;
    42  COMMIT;
    43  
    44  BEGIN;
    45      ALTER TABLE versioned_resources
    46        ALTER COLUMN modified_time TYPE timestamp without time zone;
    47  COMMIT;