aboutsummaryrefslogtreecommitdiff
path: root/sqitch/sqlite/verify
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-04-28 18:49:38 +0100
committerChristopher Baines <mail@cbaines.net>2020-04-28 18:49:38 +0100
commitb101326b4ebdd1f1a090d4ba14da88747693d949 (patch)
treec9dbb6ae01675dab74f7e89b87d4703f2ccdbe3d /sqitch/sqlite/verify
parentbc3bbb6eadeeaf38243e9edc8272021a8f4f1517 (diff)
downloadbuild-coordinator-b101326b4ebdd1f1a090d4ba14da88747693d949.tar
build-coordinator-b101326b4ebdd1f1a090d4ba14da88747693d949.tar.gz
Create an index on derivation_outputs.output
This is important to speed up looking for derivations that provide an output, that's used in the allocation process.
Diffstat (limited to 'sqitch/sqlite/verify')
-rw-r--r--sqitch/sqlite/verify/derivation_outputs_output_index.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/sqlite/verify/derivation_outputs_output_index.sql b/sqitch/sqlite/verify/derivation_outputs_output_index.sql
new file mode 100644
index 0000000..a693a27
--- /dev/null
+++ b/sqitch/sqlite/verify/derivation_outputs_output_index.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:derivation_outputs_output_index on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;