sqitch/sqlite/deploy/replace_agent_status.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
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;