diff options
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/pg/deploy/build_results_result_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/build_results_result_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/build_results_result_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/sqlite/deploy/build_results_result_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/revert/build_results_result_index.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/verify/build_results_result_index.sql | 7 |
7 files changed, 43 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/build_results_result_index.sql b/sqitch/pg/deploy/build_results_result_index.sql new file mode 100644 index 0000000..aa1030e --- /dev/null +++ b/sqitch/pg/deploy/build_results_result_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_results_result_index to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_results_result_index.sql b/sqitch/pg/revert/build_results_result_index.sql new file mode 100644 index 0000000..f92fd22 --- /dev/null +++ b/sqitch/pg/revert/build_results_result_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_results_result_index from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/build_results_result_index.sql b/sqitch/pg/verify/build_results_result_index.sql new file mode 100644 index 0000000..1c19fd1 --- /dev/null +++ b/sqitch/pg/verify/build_results_result_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_results_result_index on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 509802d..20d36dc 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -13,3 +13,4 @@ derivation_outputs_output_index 2020-04-28T17:49:19Z Christopher Baines <mail@cb allocator_related_indexes 2020-04-29T16:59:14Z Christopher Baines <mail@cbaines.net> # Add a few indexes that should speed up build allocation unprocessed_hook_events 2020-05-08T12:55:28Z Christopher Baines <mail@cbaines.net> # Add a new table unprocessed_hook_events derivation_outputs_derivation_name_index 2020-05-10T16:24:05Z Christopher Baines <mail@cbaines.net> # Add an index on derivation_outputs.derivation_name +build_results_result_index 2020-05-10T17:27:00Z Christopher Baines <mail@cbaines.net> # Add an index on build_results.result diff --git a/sqitch/sqlite/deploy/build_results_result_index.sql b/sqitch/sqlite/deploy/build_results_result_index.sql new file mode 100644 index 0000000..00dfe33 --- /dev/null +++ b/sqitch/sqlite/deploy/build_results_result_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_results_result_index to sqlite + +BEGIN; + +CREATE INDEX build_results_result_idx ON build_results (result); + +COMMIT; diff --git a/sqitch/sqlite/revert/build_results_result_index.sql b/sqitch/sqlite/revert/build_results_result_index.sql new file mode 100644 index 0000000..01f8287 --- /dev/null +++ b/sqitch/sqlite/revert/build_results_result_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_results_result_index from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/build_results_result_index.sql b/sqitch/sqlite/verify/build_results_result_index.sql new file mode 100644 index 0000000..40bbbe6 --- /dev/null +++ b/sqitch/sqlite/verify/build_results_result_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_results_result_index on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |