Mercurial > sci
annotate sql/init.sql @ 1:5afdb14df924
sci: add support for storing results
| author | David Demelier <markand@malikania.fr> |
|---|---|
| date | Tue, 08 Jun 2021 08:40:01 +0200 |
| parents | f1de39079243 |
| children | 215c0c3b3609 |
| rev | line source |
|---|---|
| 0 | 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), | |
|
1
5afdb14df924
sci: add support for storing results
David Demelier <markand@malikania.fr>
parents:
0
diff
changeset
|
25 status INTEGER DEFAULT 0, |
|
5afdb14df924
sci: add support for storing results
David Demelier <markand@malikania.fr>
parents:
0
diff
changeset
|
26 retcode INTEGER DEFAULT 0, |
|
5afdb14df924
sci: add support for storing results
David Demelier <markand@malikania.fr>
parents:
0
diff
changeset
|
27 console TEXT DEFAULT NULL |
| 0 | 28 ); |