Replace the builds_unprocessed index

With builds_live, for all unprocessed and non canceled builds. This should be
more useful, especially for queries to cancel builds.

1 files changed, 9 insertions, 0 deletions

diff --git a/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql b/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql
new file mode 100644
index 0000000..a404f31
--- /dev/null
+++ b/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql
@@ -0,0 +1,9 @@
+-- Deploy guix-build-coordinator:builds_replace_unprocessed_index to sqlite
+
+BEGIN;
+
+DROP INDEX builds_unprocessed;
+
+CREATE INDEX builds_live ON builds (id) WHERE processed = 0 AND canceled = 0;
+
+COMMIT;