diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 23 |
1 files changed, 13 insertions, 10 deletions
@@ -10,18 +10,21 @@ CREATE TABLE depstate ( UNIQUE (source, buildarch, hostarch, version)); CREATE TABLE depcheck ( - architecture TEXT NOT NULL UNIQUE, + buildarch TEXT NOT NULL, + hostarch TEXT NOT NULL, releasetime TIMESTAMP NOT NULL, updatetime TIMESTAMP NOT NULL, - giveback BOOLEAN NOT NULL CHECK (giveback in (0, 1))); -INSERT INTO depcheck (architecture, releasetime, updatetime, giveback) VALUES - ("arm64", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1), - ("armel", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1), - ("armhf", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1), - ("mips64el", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1), - ("mipsel", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1), - ("ppc64el", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1), - ("s390x", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 1); + giveback BOOLEAN NOT NULL CHECK (giveback in (0, 1)), + UNIQUE (buildarch, hostarch)); +INSERT INTO depcheck (buildarch, hostarch, releasetime, updatetime, + giveback) VALUES + ('amd64', 'arm64', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 1), + ('amd64', 'armel', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 1), + ('amd64', 'armhf', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 1), + ('amd64', 'mips64el', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 1), + ('amd64', 'mipsel', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 1), + ('amd64', 'ppc64el', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 1), + ('amd64', 's390x', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 1); CREATE TABLE builds ( source TEXT NOT NULL, |