sqitch/sqlite/deploy/build_tags.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

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

BEGIN;

CREATE TABLE tags (
       id INTEGER PRIMARY KEY ASC,
       key TEXT NOT NULL,
       value TEXT NOT NULL
);

CREATE TABLE build_tags (
       build_id TEXT NOT NULL REFERENCES builds (uuid),
       tag_id INTEGER NOT NULL REFERENCES tags (id)
);

COMMIT;