sqitch/sqlite/deploy/add_agent_tags.sql


1
2
3
4
5
6
7
8
9
10
11

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

BEGIN;

CREATE TABLE agent_tags (
       agent_id TEXT NOT NULL REFERENCES agents (id),
       tag_id INTEGER NOT NULL REFERENCES tags (id),
       PRIMARY KEY (agent_id, tag_id)
);

COMMIT;