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

     1  BEGIN;
     2    ALTER TABLE resources
     3      ADD COLUMN api_pinned_version jsonb,
     4      ADD COLUMN pin_comment text;
     5  
     6    UPDATE resources
     7    SET (api_pinned_version, pin_comment) =
     8      (resource_pins.version, resource_pins.comment_text)
     9    FROM resource_pins WHERE resources.id = resource_pins.resource_id;
    10  
    11    DROP TABLE resource_pins;
    12  COMMIT;