diff options
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/deploy/dates_to_load_new_guix_revision_jobs.sql | 12 | ||||
| -rw-r--r-- | sqitch/revert/dates_to_load_new_guix_revision_jobs.sql | 8 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/verify/dates_to_load_new_guix_revision_jobs.sql | 8 |
4 files changed, 29 insertions, 0 deletions
diff --git a/sqitch/deploy/dates_to_load_new_guix_revision_jobs.sql b/sqitch/deploy/dates_to_load_new_guix_revision_jobs.sql new file mode 100644 index 0000000..989c4e5 --- /dev/null +++ b/sqitch/deploy/dates_to_load_new_guix_revision_jobs.sql @@ -0,0 +1,12 @@ +-- Deploy guix-data-service:dates_to_load_new_guix_revision_jobs to pg +-- requires: initial_import + +BEGIN; + +ALTER TABLE load_new_guix_revision_jobs + ADD COLUMN created_at timestamp without time zone DEFAULT clock_timestamp(); + +ALTER TABLE load_new_guix_revision_jobs + ADD COLUMN succeeded_at timestamp without time zone; + +COMMIT; diff --git a/sqitch/revert/dates_to_load_new_guix_revision_jobs.sql b/sqitch/revert/dates_to_load_new_guix_revision_jobs.sql new file mode 100644 index 0000000..614b37f --- /dev/null +++ b/sqitch/revert/dates_to_load_new_guix_revision_jobs.sql @@ -0,0 +1,8 @@ +-- Revert guix-data-service:dates_to_load_new_guix_revision_jobs from pg + +BEGIN; + +ALTER TABLE load_new_guix_revision_jobs DROP COLUMN created_at; +ALTER TABLE load_new_guix_revision_jobs DROP COLUMN succeeded_at; + +COMMIT; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index c8a7529..b4c873d 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -11,3 +11,4 @@ remove_package_metadata_sha1_hash 2019-05-12T10:37:40Z Christopher Baines <mail@ add_location_information 2019-05-12T20:27:48Z Christopher Baines <mail@cbaines.net> # Add locations table and location to package_metadata add_git_repositories_cgit_url_base 2019-05-13T18:45:14Z Christopher Baines <mail@cbaines.net> # Add cgit_url_base to git_repositories license_support 2019-05-13T20:37:40Z Christopher Baines <mail@cbaines.net> # Add support for storing license information +dates_to_load_new_guix_revision_jobs 2019-06-02T07:39:49Z Christopher Baines <mail@cbaines.net> # Add dates to the load_new_guix_revision_jobs table diff --git a/sqitch/verify/dates_to_load_new_guix_revision_jobs.sql b/sqitch/verify/dates_to_load_new_guix_revision_jobs.sql new file mode 100644 index 0000000..71afed2 --- /dev/null +++ b/sqitch/verify/dates_to_load_new_guix_revision_jobs.sql @@ -0,0 +1,8 @@ +-- Verify guix-data-service:dates_to_load_new_guix_revision_jobs on pg + +BEGIN; + +SELECT created_at FROM load_new_guix_revision_jobs WHERE FALSE; +SELECT succeeded_at FROM load_new_guix_revision_jobs WHERE FALSE; + +ROLLBACK; |