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

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