diff options
Diffstat (limited to 'src/sql/upgrade-12.sql')
-rw-r--r-- | src/sql/upgrade-12.sql | 7 |
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; |