Mercurial > sci
comparison sql/init.sql @ 0:f1de39079243
misc: initial import
author | David Demelier <markand@malikania.fr> |
---|---|
date | Mon, 07 Jun 2021 09:41:37 +0200 |
parents | |
children | 5afdb14df924 |
comparison
equal
deleted
inserted
replaced
-1:000000000000 | 0:f1de39079243 |
---|---|
1 CREATE TABLE IF NOT EXISTS project( | |
2 id INTEGER PRIMARY KEY AUTOINCREMENT, | |
3 name TEXT NOT NULL, | |
4 desc TEXT NOT NULL, | |
5 url TEXT NOT NULL, | |
6 script TEXT NOT NULL | |
7 ); | |
8 | |
9 CREATE TABLE IF NOT EXISTS worker( | |
10 id INTEGER PRIMARY KEY AUTOINCREMENT, | |
11 name TEXT NOT NULL, | |
12 desc TEXT NOT NULL | |
13 ); | |
14 | |
15 CREATE TABLE IF NOT EXISTS job( | |
16 id INTEGER PRIMARY KEY AUTOINCREMENT, | |
17 tag TEXT NOT NULL UNIQUE, | |
18 project_id INTEGER NOT NULL REFERENCES project (id) | |
19 ); | |
20 | |
21 CREATE TABLE IF NOT EXISTS job_result( | |
22 id INTEGER PRIMARY KEY AUTOINCREMENT, | |
23 job_id INTEGER NOT NULL REFERENCES job (id), | |
24 worker_id INTEGER NOT NULL REFERENCES worker (id), | |
25 status INTEGER NOT NULL, | |
26 console TEXT NOT NULL | |
27 ); |