sqitch/sqlite/deploy/initial_derivation_tables.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

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

BEGIN;

CREATE TABLE derivations (
       name TEXT PRIMARY KEY,
       system TEXT NOT NULL
);

CREATE TABLE derivation_outputs (
       id INTEGER PRIMARY KEY ASC,
       derivation_name TEXT NOT NULL REFERENCES derivations (name),
       name TEXT NOT NULL,
       output TEXT NOT NULL
);

CREATE TABLE derivation_inputs (
       derivation_name TEXT REFERENCES derivations (name),
       derivation_output_id INTEGER REFERENCES derivation_outputs (id),
       PRIMARY KEY (derivation_name, derivation_output_id)
);

COMMIT;