sqitch/sqlite/deploy/initial_agent_tables.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

-- Deploy guix-build-coordinator:initial_agent_tables to sqlite

BEGIN;

CREATE TABLE agents (
       id TEXT PRIMARY KEY,
       description TEXT
);

CREATE TABLE agent_passwords (
       id INTEGER PRIMARY KEY ASC,
       agent_id NOT NULL REFERENCES agents (id),
       password TEXT NOT NULL,
       timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE agent_status (
       id INTEGER PRIMARY KEY ASC,
       agent_id NOT NULL REFERENCES agents (id),
       timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
       status TEXT NOT NULL
);

COMMIT;