diff options
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/deploy/rework_builds.sql | 21 | ||||
| -rw-r--r-- | sqitch/revert/rework_builds.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/verify/rework_builds.sql | 7 |
4 files changed, 36 insertions, 0 deletions
diff --git a/sqitch/deploy/rework_builds.sql b/sqitch/deploy/rework_builds.sql new file mode 100644 index 0000000..3edfc2d --- /dev/null +++ b/sqitch/deploy/rework_builds.sql @@ -0,0 +1,21 @@ +-- Deploy guix-data-service:rework_builds to pg + +BEGIN; + +DROP TABLE build_status; +DROP TABLE builds; + +CREATE TABLE builds ( + id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY, + build_server_id integer NOT NULL REFERENCES build_servers(id), + derivation_file_name varchar NOT NULL +); + +CREATE TABLE build_status ( + id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY, + build_id integer NOT NULL REFERENCES builds(id), + "timestamp" timestamp without time zone DEFAULT clock_timestamp() NOT NULL, + status guix_data_service.buildstatus NOT NULL +); + +COMMIT; diff --git a/sqitch/revert/rework_builds.sql b/sqitch/revert/rework_builds.sql new file mode 100644 index 0000000..507808d --- /dev/null +++ b/sqitch/revert/rework_builds.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:rework_builds from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index d3d9c7a..5990567 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -28,3 +28,4 @@ remove_guix_revision_duplicates 2019-10-05T08:00:14Z Christopher Baines <mail@cb package_derivations_by_guix_revision_range 2019-11-09T19:09:48Z Christopher Baines <mail@cbaines.net> # Add package_derivations_by_guix_revision_range channel_news_tables 2019-11-15T07:32:07Z Christopher Baines <mail@cbaines.net> # Add tables to store channel news build_server_token_seeds 2019-11-23T09:26:48Z Christopher Baines <mail@cbaines.net> # Add build_server_token_seeds table +rework_builds 2019-11-23T20:41:20Z Christopher Baines <mail@cbaines.net> # Rework the build tables diff --git a/sqitch/verify/rework_builds.sql b/sqitch/verify/rework_builds.sql new file mode 100644 index 0000000..2dd6a15 --- /dev/null +++ b/sqitch/verify/rework_builds.sql @@ -0,0 +1,7 @@ +-- Verify guix-data-service:rework_builds on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |