aboutsummaryrefslogtreecommitdiff
path: root/sqitch/revert
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-10-02 20:13:28 +0100
committerChristopher Baines <mail@cbaines.net>2020-10-02 20:15:23 +0100
commite2a7705d3d01c992c0dfed6363388246b5bd69dc (patch)
tree953c0c1d5629733ca56969b3268c3f5cba2374d6 /sqitch/revert
parent71afa939816a3f7d53cce91d00fc1110125f18fe (diff)
downloaddata-service-e2a7705d3d01c992c0dfed6363388246b5bd69dc.tar
data-service-e2a7705d3d01c992c0dfed6363388246b5bd69dc.tar.gz
Add an index for derivation_sources.derivation_source_file_id
As this speeds up deleting derivation_source_files.
Diffstat (limited to 'sqitch/revert')
-rw-r--r--sqitch/revert/add_derivation_sources_derivation_source_file_id_index.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/revert/add_derivation_sources_derivation_source_file_id_index.sql b/sqitch/revert/add_derivation_sources_derivation_source_file_id_index.sql
new file mode 100644
index 0000000..2d7b84f
--- /dev/null
+++ b/sqitch/revert/add_derivation_sources_derivation_source_file_id_index.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:add_derivation_sources_derivation_source_file_id_index from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;