aboutsummaryrefslogtreecommitdiff
path: root/sqitch/sqlite/revert/add_build_tags_build_id_idx.sql
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-12-21 13:27:35 +0000
committerChristopher Baines <mail@cbaines.net>2020-12-21 13:27:35 +0000
commitf01203650a9b687f292d029864aa3e8283df51d9 (patch)
tree3bff7337f08303a5fab0f8d9a77b5b286eb57e50 /sqitch/sqlite/revert/add_build_tags_build_id_idx.sql
parent24d17bf6cfc46bf36c499c883bdf4d726446548e (diff)
downloadbuild-coordinator-f01203650a9b687f292d029864aa3e8283df51d9.tar
build-coordinator-f01203650a9b687f292d029864aa3e8283df51d9.tar.gz
Add an index on build_tags.build_id
This makes fetching the tags for a build faster.
Diffstat (limited to 'sqitch/sqlite/revert/add_build_tags_build_id_idx.sql')
-rw-r--r--sqitch/sqlite/revert/add_build_tags_build_id_idx.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/sqlite/revert/add_build_tags_build_id_idx.sql b/sqitch/sqlite/revert/add_build_tags_build_id_idx.sql
new file mode 100644
index 0000000..c0033a1
--- /dev/null
+++ b/sqitch/sqlite/revert/add_build_tags_build_id_idx.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_build_tags_build_id_idx from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;