diff options
-rw-r--r-- | sqitch/pg/deploy/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
-rw-r--r-- | sqitch/sqlite/deploy/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/revert/build_starts_index.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/build_starts_index.sql | 7 |
7 files changed, 43 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/build_starts_index.sql b/sqitch/pg/deploy/build_starts_index.sql new file mode 100644 index 0000000..cb611c5 --- /dev/null +++ b/sqitch/pg/deploy/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_starts_index to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_starts_index.sql b/sqitch/pg/revert/build_starts_index.sql new file mode 100644 index 0000000..9b1f0e3 --- /dev/null +++ b/sqitch/pg/revert/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_starts_index from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/build_starts_index.sql b/sqitch/pg/verify/build_starts_index.sql new file mode 100644 index 0000000..87c8886 --- /dev/null +++ b/sqitch/pg/verify/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_starts_index on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index c7604f4..cfb5b9d 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -45,3 +45,4 @@ replace_agent_status 2023-03-22T14:17:35Z Chris <chris@felis> # Replace agent_st agent_status_add_processor_count 2023-03-24T09:28:47Z Chris <chris@felis> # Add agent_status.processor_count remove_build_allocation_plan 2023-04-23T19:50:23Z Chris <chris@felis> # Remove build_allocation_plan system_uptime 2023-05-05T18:18:35Z Chris <chris@felis> # Add system uptime +build_starts_index 2023-11-24T16:30:13Z Chris <chris@felis> # build_starts index diff --git a/sqitch/sqlite/deploy/build_starts_index.sql b/sqitch/sqlite/deploy/build_starts_index.sql new file mode 100644 index 0000000..1d4cf2d --- /dev/null +++ b/sqitch/sqlite/deploy/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_starts_index to sqlite + +BEGIN; + +CREATE INDEX build_starts_build_id_idx ON build_starts (build_id); + +COMMIT; diff --git a/sqitch/sqlite/revert/build_starts_index.sql b/sqitch/sqlite/revert/build_starts_index.sql new file mode 100644 index 0000000..6165710 --- /dev/null +++ b/sqitch/sqlite/revert/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_starts_index from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/build_starts_index.sql b/sqitch/sqlite/verify/build_starts_index.sql new file mode 100644 index 0000000..6e99da5 --- /dev/null +++ b/sqitch/sqlite/verify/build_starts_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_starts_index on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |