summaryrefslogtreecommitdiff
path: root/src/sql/upgrade-12.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/sql/upgrade-12.sql')
-rw-r--r--src/sql/upgrade-12.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/sql/upgrade-12.sql b/src/sql/upgrade-12.sql
new file mode 100644
index 0000000..06aaffe
--- /dev/null
+++ b/src/sql/upgrade-12.sql
@@ -0,0 +1,7 @@
+BEGIN TRANSACTION;
+
+CREATE INDEX Builds_evaluation_index ON Builds (evaluation, status);
+CREATE INDEX Evaluations_status_index ON Evaluations (id, status);
+CREATE INDEX Evaluations_specification_index ON Evaluations (specification, id DESC);
+
+COMMIT;