sqitch/sqlite/deploy/build_allocation_agent_requested_systems.sql


1
2
3
4
5
6
7
8
9
10
11

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

BEGIN;

CREATE TABLE build_allocation_agent_requested_systems (
       agent_id NOT NULL REFERENCES agents (id),
       system TEXT NOT NULL,
       PRIMARY KEY (agent_id, system)
);

COMMIT;