diff options
Diffstat (limited to 'sqitch/deploy/rework_builds.sql')
-rw-r--r-- | sqitch/deploy/rework_builds.sql | 21 |
1 files changed, 21 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; |