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;