1 files changed, 13 insertions, 0 deletions
diff --git a/sqitch/deploy/guix_revision_package_derivation_distribution_counts.sql b/sqitch/deploy/guix_revision_package_derivation_distribution_counts.sql
new file mode 100644
index 0000000..58829c5
--- /dev/null
+++ b/sqitch/deploy/guix_revision_package_derivation_distribution_counts.sql
@@ -0,0 +1,13 @@
+-- Deploy guix-data-service:guix_revision_package_derivation_distribution_counts to pg
+
+BEGIN;
+
+CREATE TABLE guix_revision_package_derivation_distribution_counts (
+  guix_revision_id integer NOT NULL REFERENCES guix_revisions (id),
+  system_id integer NOT NULL REFERENCES systems (id),
+  target varchar NOT NULL,
+  level integer NOT NULL,
+  distinct_derivations integer NOT NULL
+);
+
+COMMIT;