diff options
Diffstat (limited to 'sqitch/sqlite')
3 files changed, 29 insertions, 0 deletions
diff --git a/sqitch/sqlite/deploy/agent_status_add_processor_count.sql b/sqitch/sqlite/deploy/agent_status_add_processor_count.sql new file mode 100644 index 0000000..5618809 --- /dev/null +++ b/sqitch/sqlite/deploy/agent_status_add_processor_count.sql @@ -0,0 +1,15 @@ +-- Deploy guix-build-coordinator:agent_status_add_processor_count to sqlite + +BEGIN; + +DROP TABLE agent_status; + +CREATE TABLE agent_status ( + agent_id TEXT PRIMARY KEY ASC REFERENCES agents (id), + timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + status TEXT NOT NULL, + load_average_1min INTEGER, + processor_count INTEGER +); + +COMMIT; diff --git a/sqitch/sqlite/revert/agent_status_add_processor_count.sql b/sqitch/sqlite/revert/agent_status_add_processor_count.sql new file mode 100644 index 0000000..5f94a64 --- /dev/null +++ b/sqitch/sqlite/revert/agent_status_add_processor_count.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:agent_status_add_processor_count from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/agent_status_add_processor_count.sql b/sqitch/sqlite/verify/agent_status_add_processor_count.sql new file mode 100644 index 0000000..f478a17 --- /dev/null +++ b/sqitch/sqlite/verify/agent_status_add_processor_count.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:agent_status_add_processor_count on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |