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), |
|
25 status INTEGER NOT NULL, |
|
26 console TEXT NOT NULL |
|
27 ); |