diff options
| author | Christopher Baines <mail@cbaines.net> | 2021-03-30 09:23:39 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2021-03-30 09:23:39 +0100 |
| commit | 8ebe604c62acb424f899c01724347bf0f115b73e (patch) | |
| tree | c90d6f9821fa865df422a607e0b6280e75df74aa /sqitch | |
| parent | f8bb56d192923a1a1f5550eff21fb2ab2a4457c9 (diff) | |
| download | build-coordinator-8ebe604c62acb424f899c01724347bf0f115b73e.tar build-coordinator-8ebe604c62acb424f899c01724347bf0f115b73e.tar.gz | |
Fix types in the allocated_builds table
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/pg/deploy/fix_allocated_builds.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/fix_allocated_builds.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/fix_allocated_builds.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/sqlite/deploy/fix_allocated_builds.sql | 14 | ||||
| -rw-r--r-- | sqitch/sqlite/revert/fix_allocated_builds.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/verify/fix_allocated_builds.sql | 7 |
7 files changed, 50 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/fix_allocated_builds.sql b/sqitch/pg/deploy/fix_allocated_builds.sql new file mode 100644 index 0000000..8e44b88 --- /dev/null +++ b/sqitch/pg/deploy/fix_allocated_builds.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:fix_allocated_builds to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/fix_allocated_builds.sql b/sqitch/pg/revert/fix_allocated_builds.sql new file mode 100644 index 0000000..990a63a --- /dev/null +++ b/sqitch/pg/revert/fix_allocated_builds.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:fix_allocated_builds from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/fix_allocated_builds.sql b/sqitch/pg/verify/fix_allocated_builds.sql new file mode 100644 index 0000000..cf4cf57 --- /dev/null +++ b/sqitch/pg/verify/fix_allocated_builds.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:fix_allocated_builds on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index c373470..85b7580 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -29,3 +29,4 @@ add_agent_tags 2021-01-17T11:13:23Z Christopher Baines <mail@cbaines.net> # Add add_agent_names 2021-02-28T14:04:24Z Christopher Baines <mail@cbaines.net> # Add agent.names add_dynamic_auth_tokens 2021-02-28T15:21:24Z Christopher Baines <mail@cbaines.net> # Add dynamic_auth_tokens use_numeric_primary_keys 2021-03-28T09:55:40Z Christopher Baines <mail@cbaines.net> # Use numeric primary keys +fix_allocated_builds 2021-03-30T08:19:18Z Christopher Baines <mail@cbaines.net> # Fix allocated_builds diff --git a/sqitch/sqlite/deploy/fix_allocated_builds.sql b/sqitch/sqlite/deploy/fix_allocated_builds.sql new file mode 100644 index 0000000..8710cf1 --- /dev/null +++ b/sqitch/sqlite/deploy/fix_allocated_builds.sql @@ -0,0 +1,14 @@ +-- Deploy guix-build-coordinator:fix_allocated_builds to sqlite + +BEGIN; + +DROP TABLE build_allocation_plan; + +CREATE TABLE build_allocation_plan ( + build_id INTEGER NOT NULL REFERENCES builds (id), + agent_id TEXT NOT NULL REFERENCES agents (id), + ordering INTEGER NOT NULL, + PRIMARY KEY (agent_id, build_id) +); + +COMMIT; diff --git a/sqitch/sqlite/revert/fix_allocated_builds.sql b/sqitch/sqlite/revert/fix_allocated_builds.sql new file mode 100644 index 0000000..c4bb575 --- /dev/null +++ b/sqitch/sqlite/revert/fix_allocated_builds.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:fix_allocated_builds from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/fix_allocated_builds.sql b/sqitch/sqlite/verify/fix_allocated_builds.sql new file mode 100644 index 0000000..2b83a12 --- /dev/null +++ b/sqitch/sqlite/verify/fix_allocated_builds.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:fix_allocated_builds on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |