diff options
author | Christopher Baines <mail@cbaines.net> | 2021-11-12 14:08:41 +0000 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2021-11-12 14:08:41 +0000 |
commit | f48e07b0e4b8e739848f8a1fc09b6f1dd4a74bca (patch) | |
tree | a7ccf591b6442b2fb424f448d45c3ae73ffec572 /sqitch/sqlite | |
parent | aa6fe55754f7a7c21e4fb454a641d24ab957a0de (diff) | |
download | build-coordinator-f48e07b0e4b8e739848f8a1fc09b6f1dd4a74bca.tar build-coordinator-f48e07b0e4b8e739848f8a1fc09b6f1dd4a74bca.tar.gz |
Add an active field to the agents table
To allow making agents inactive to stop allocating builds to them.
Diffstat (limited to 'sqitch/sqlite')
-rw-r--r-- | sqitch/sqlite/deploy/add_agents_active.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/revert/add_agents_active.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/add_agents_active.sql | 7 |
3 files changed, 21 insertions, 0 deletions
diff --git a/sqitch/sqlite/deploy/add_agents_active.sql b/sqitch/sqlite/deploy/add_agents_active.sql new file mode 100644 index 0000000..989f22c --- /dev/null +++ b/sqitch/sqlite/deploy/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:add_agents_active to sqlite + +BEGIN; + +ALTER TABLE agents ADD COLUMN active NOT NULL DEFAULT 1; + +COMMIT; diff --git a/sqitch/sqlite/revert/add_agents_active.sql b/sqitch/sqlite/revert/add_agents_active.sql new file mode 100644 index 0000000..58b732a --- /dev/null +++ b/sqitch/sqlite/revert/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:add_agents_active from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/add_agents_active.sql b/sqitch/sqlite/verify/add_agents_active.sql new file mode 100644 index 0000000..dab723c --- /dev/null +++ b/sqitch/sqlite/verify/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:add_agents_active on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |