Add a new table to nars for derivation source files

This will allow serving the nars for derivation source files.

1 files changed, 14 insertions, 0 deletions

diff --git a/sqitch/deploy/add_derivation_source_file_nars.sql b/sqitch/deploy/add_derivation_source_file_nars.sql
new file mode 100644
index 0000000..2690dda
--- /dev/null
+++ b/sqitch/deploy/add_derivation_source_file_nars.sql
@@ -0,0 +1,14 @@
+-- Deploy guix-data-service:add_derivation_source_file_nars to pg
+
+BEGIN;
+
+CREATE TABLE derivation_source_file_nars (
+    derivation_source_file_id integer PRIMARY KEY REFERENCES derivation_source_files (id),
+    compression varchar NOT NULL,
+    hash_algorithm varchar NOT NULL,
+    hash varchar NOT NULL,
+    uncompressed_size integer NOT NULL,
+    data bytea NOT NULL
+);
+
+COMMIT;