1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/deploy/package_derivations_not_null_hash_index.sql b/sqitch/deploy/package_derivations_not_null_hash_index.sql
new file mode 100644
index 0000000..7862ec8
--- /dev/null
+++ b/sqitch/deploy/package_derivations_not_null_hash_index.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-data-service:package_derivations_not_null_hash_index to pg
+
+BEGIN;
+
+CREATE INDEX derivation_output_details_id_hash_not_null_idx ON derivation_output_details (id) WHERE hash IS NOT NULL;
+
+COMMIT;