7 files changed, 95 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/create_outputs.sql b/sqitch/pg/deploy/create_outputs.sql
new file mode 100644
index 0000000..5b15bc8
--- /dev/null
+++ b/sqitch/pg/deploy/create_outputs.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:create_outputs to pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/revert/create_outputs.sql b/sqitch/pg/revert/create_outputs.sql
new file mode 100644
index 0000000..84e302e
--- /dev/null
+++ b/sqitch/pg/revert/create_outputs.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:create_outputs from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/verify/create_outputs.sql b/sqitch/pg/verify/create_outputs.sql
new file mode 100644
index 0000000..3215509
--- /dev/null
+++ b/sqitch/pg/verify/create_outputs.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:create_outputs on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index f9e28fd..a7fed94 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -32,3 +32,4 @@ use_numeric_primary_keys 2021-03-28T09:55:40Z Christopher Baines <mail@cbaines.n
 fix_allocated_builds 2021-03-30T08:19:18Z Christopher Baines <mail@cbaines.net> # Fix allocated_builds
 fix_allocated_builds_attempt_2 2021-03-30T08:27:18Z Christopher Baines <mail@cbaines.net> # Fix allocated_builds
 fix_setup_failure_missing_inputs 2021-04-08T19:31:49Z Christopher Baines <mail@cbaines.net> # Fix setup_failure_missing_inputs
+create_outputs 2021-05-21T13:37:49Z Christopher Baines <mail@cbaines.net> # Create the outputs table
diff --git a/sqitch/sqlite/deploy/create_outputs.sql b/sqitch/sqlite/deploy/create_outputs.sql
new file mode 100644
index 0000000..03f0b42
--- /dev/null
+++ b/sqitch/sqlite/deploy/create_outputs.sql
@@ -0,0 +1,59 @@
+-- Deploy guix-build-coordinator:create_outputs to sqlite
+
+PRAGMA foreign_keys = OFF;
+
+BEGIN;
+
+CREATE TABLE outputs (
+       id INTEGER PRIMARY KEY NOT NULL,
+       output TEXT NOT NULL
+);
+
+INSERT INTO outputs (output) SELECT DISTINCT output FROM derivation_outputs;
+
+CREATE INDEX outputs_output ON outputs (output);
+
+
+
+
+CREATE TABLE derivation_outputs_new (
+       id INTEGER PRIMARY KEY ASC,
+       derivation_id INTEGER NOT NULL REFERENCES derivations (id),
+       name TEXT NOT NULL,
+       output_id INTEGER NOT NULL REFERENCES outputs (id)
+);
+
+INSERT INTO derivation_outputs_new
+  SELECT derivation_outputs.id, derivation_id, name, outputs.id
+  FROM derivation_outputs
+  INNER JOIN outputs
+    ON derivation_outputs.output = outputs.output;
+
+DROP TABLE derivation_outputs;
+ALTER TABLE derivation_outputs_new RENAME TO derivation_outputs;
+
+CREATE INDEX derivation_outputs_output_id_idx
+  ON derivation_outputs (output_id);
+CREATE UNIQUE INDEX derivation_outputs_unique_idx
+  ON derivation_outputs (derivation_id, name);
+
+
+CREATE TABLE unbuilt_outputs_new (
+  output_id INTEGER PRIMARY KEY REFERENCES outputs (id)
+);
+
+UPDATE unbuilt_outputs_new SET output_id = (
+  SELECT id
+  FROM unbuilt_outputs
+  INNER JOIN outputs
+    ON unbuilt_outputs.output = outputs.output
+);
+
+DROP TABLE unbuilt_outputs;
+ALTER TABLE unbuilt_outputs_new RENAME TO unbuilt_outputs;
+
+PRAGMA foreign_key_check;
+
+COMMIT;
+
+PRAGMA foreign_keys = ON;
diff --git a/sqitch/sqlite/revert/create_outputs.sql b/sqitch/sqlite/revert/create_outputs.sql
new file mode 100644
index 0000000..2fa2cba
--- /dev/null
+++ b/sqitch/sqlite/revert/create_outputs.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:create_outputs from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqlite/verify/create_outputs.sql b/sqitch/sqlite/verify/create_outputs.sql
new file mode 100644
index 0000000..4398410
--- /dev/null
+++ b/sqitch/sqlite/verify/create_outputs.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:create_outputs on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;