Send over some metadata from the agent for each output

This will hopefully make it easier to create narinfo files for the outputs. I
think all of this information can be derived from the nar, but I'm not sure
how to do that, so maybe this can eventually be removed.

1 files changed, 13 insertions, 0 deletions

diff --git a/sqitch/sqlite/deploy/output_metadata.sql b/sqitch/sqlite/deploy/output_metadata.sql
new file mode 100644
index 0000000..a7c0124
--- /dev/null
+++ b/sqitch/sqlite/deploy/output_metadata.sql
@@ -0,0 +1,13 @@
+-- Deploy guix-build-coordinator:output_metadata to sqlite
+
+BEGIN;
+
+CREATE TABLE output_metadata (
+       build_id TEXT NOT NULL REFERENCES builds (uuid),
+       derivation_output_id INTEGER NOT NULL REFERENCES derivation_outputs (id),
+       hash TEXT NOT NULL,
+       size INTEGER NOT NULL,
+       store_references TEXT NOT NULL
+);
+
+COMMIT;