diff options
Diffstat (limited to 'sqitch/sqlite/deploy/replace_agent_status.sql')
-rw-r--r-- | sqitch/sqlite/deploy/replace_agent_status.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sqitch/sqlite/deploy/replace_agent_status.sql b/sqitch/sqlite/deploy/replace_agent_status.sql new file mode 100644 index 0000000..0d579ef --- /dev/null +++ b/sqitch/sqlite/deploy/replace_agent_status.sql @@ -0,0 +1,14 @@ +-- Deploy guix-build-coordinator:replace_agent_status 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 +); + +COMMIT; |