1 -- SPDX-License-Identifier: GPL-2.0+
3 CREATE TABLE depstate (
6 architecture TEXT NOT NULL,
7 satisfiable BOOLEAN NOT NULL CHECK (satisfiable in (0, 1)),
9 UNIQUE (source, architecture, version));
11 CREATE TABLE depcheck (
12 architecture TEXT NOT NULL UNIQUE,
13 releasetime TIMESTAMP NOT NULL,
14 updatetime TIMESTAMP NOT NULL,
15 giveback BOOLEAN NOT NULL CHECK (giveback in (0, 1)));
16 INSERT INTO depcheck (architecture, releasetime, updatetime, giveback) VALUES
17 ("arm64", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1),
18 ("armel", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1),
19 ("armhf", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1),
20 ("mips", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1),
21 ("mips64el", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1),
22 ("mipsel", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1),
23 ("ppc64el", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1),
24 ("s390x", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1);
28 version TEXT NOT NULL,
29 architecture TEXT NOT NULL,
30 success BOOLEAN NOT NULL CHECK (success in (0, 1)),
31 starttime TIMESTAMP NOT NULL,
32 filename TEXT NOT NULL);
34 CREATE TABLE buildrequests (
35 id INTEGER PRIMARY KEY,
38 requesttime TIMESTAMP NOT NULL,
39 priority INTEGER NOT NULL DEFAULT 0);