Mercurial > sci

comparison sql/init.sql @ 0:f1de39079243

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 );