sqitch/sqlite/deploy/fix_allocated_builds_attempt_2.sql


1
2
3
4
5
6
7
8
9
10
11
12

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

BEGIN;

DROP TABLE allocated_builds;

CREATE TABLE allocated_builds (
       build_id INTEGER PRIMARY KEY NOT NULL REFERENCES builds (id),
       agent_id TEXT NOT NULL REFERENCES agents (id)
);

COMMIT;