sqitch/sqlite/deploy/agent_status_add_processor_count.sql


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