sqitch/sqlite/deploy/create_builds.sql


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

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

BEGIN;

CREATE TABLE builds (
       uuid TEXT PRIMARY KEY,
       derivation_name TEXT NOT NULL REFERENCES derivations (name),
       priority INTEGER NOT NULL,
       processed BOOLEAN NOT NULL DEFAULT 0
);

COMMIT;