Record the details of derivation outputs

I believe this will be useful when linking builds to other services, like the
Guix Data Service, since this information might be useful when joining up the
derivation being built to other derivations through the details of the outputs
produced.

3 files changed, 26 insertions, 0 deletions

diff --git a/sqitch/sqlite/deploy/derivation_output_details.sql b/sqitch/sqlite/deploy/derivation_output_details.sql
new file mode 100644
index 0000000..65d5423
--- /dev/null
+++ b/sqitch/sqlite/deploy/derivation_output_details.sql
@@ -0,0 +1,12 @@
+-- Deploy guix-build-coordinator:derivation_output_details to sqlite
+
+BEGIN;
+
+CREATE TABLE derivation_output_details (
+       derivation_output_id INTEGER PRIMARY KEY ASC,
+       hash_algorithm TEXT,
+       hash TEXT,
+       recursive BOOLEAN NOT NULL
+);
+
+COMMIT;
diff --git a/sqitch/sqlite/revert/derivation_output_details.sql b/sqitch/sqlite/revert/derivation_output_details.sql
new file mode 100644
index 0000000..3718ce8
--- /dev/null
+++ b/sqitch/sqlite/revert/derivation_output_details.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:derivation_output_details from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqlite/verify/derivation_output_details.sql b/sqitch/sqlite/verify/derivation_output_details.sql
new file mode 100644
index 0000000..ca9cff8
--- /dev/null
+++ b/sqitch/sqlite/verify/derivation_output_details.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:derivation_output_details on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;