1 files changed, 13 insertions, 0 deletions
diff --git a/sqitch/deploy/channel_instance_derivations.sql b/sqitch/deploy/channel_instance_derivations.sql
new file mode 100644
index 0000000..bb8e6e3
--- /dev/null
+++ b/sqitch/deploy/channel_instance_derivations.sql
@@ -0,0 +1,13 @@
+-- Deploy guix-data-service:channel_instance_derivations to pg
+
+BEGIN;
+
+CREATE TABLE channel_instances (
+  guix_revision_id integer NOT NULL REFERENCES guix_revisions(id),
+  system varchar NOT NULL,
+  derivation_id integer NOT NULL REFERENCES derivations (id),
+  PRIMARY KEY (guix_revision_id, system),
+  UNIQUE (derivation_id)
+);
+
+COMMIT;