From f01203650a9b687f292d029864aa3e8283df51d9 Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
Date: Mon, 21 Dec 2020 13:27:35 +0000
Subject: Add an index on build_tags.build_id

This makes fetching the tags for a build faster.
---
 sqitch/pg/verify/add_build_tags_build_id_idx.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 sqitch/pg/verify/add_build_tags_build_id_idx.sql

(limited to 'sqitch/pg/verify/add_build_tags_build_id_idx.sql')

diff --git a/sqitch/pg/verify/add_build_tags_build_id_idx.sql b/sqitch/pg/verify/add_build_tags_build_id_idx.sql
new file mode 100644
index 0000000..6a85f48
--- /dev/null
+++ b/sqitch/pg/verify/add_build_tags_build_id_idx.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_build_tags_build_id_idx on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;
-- 
cgit v1.2.3

