Mercurial > sci

annotate sql/init.sql @ 10:eb76429ce112

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
sciworkerd: improve process destruction
author David Demelier <markand@malikania.fr>
date Tue, 29 Jun 2021 20:40:17 +0200
parents 8c408176d2b1
children be3ec0e6bb8f
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
1 CREATE TABLE IF NOT EXISTS project(
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
2 id INTEGER PRIMARY KEY AUTOINCREMENT,
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
3 name TEXT NOT NULL,
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
4 desc TEXT NOT NULL,
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
5 url TEXT NOT NULL,
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 3
diff changeset
6 script TEXT NOT NULL,
10
eb76429ce112 sciworkerd: improve process destruction
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
7 date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
8 );
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
9
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
10 CREATE TABLE IF NOT EXISTS worker(
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
11 id INTEGER PRIMARY KEY AUTOINCREMENT,
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
12 name TEXT NOT NULL,
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 3
diff changeset
13 desc TEXT NOT NULL,
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 3
diff changeset
14 date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
15 );
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
16
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
17 CREATE TABLE IF NOT EXISTS job(
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
18 id INTEGER PRIMARY KEY AUTOINCREMENT,
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
19 tag TEXT NOT NULL UNIQUE,
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 3
diff changeset
20 project_id INTEGER NOT NULL REFERENCES project (id),
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 3
diff changeset
21 date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
22 );
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
23
3
215c0c3b3609 misc: use JSON everywhere (scictl/sciwebd)
David Demelier <markand@malikania.fr>
parents: 1
diff changeset
24 CREATE TABLE IF NOT EXISTS jobresult(
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
25 id INTEGER PRIMARY KEY AUTOINCREMENT,
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
26 job_id INTEGER NOT NULL REFERENCES job (id),
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
27 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
28 status INTEGER DEFAULT 0,
5afdb14df924 sci: add support for storing results
David Demelier <markand@malikania.fr>
parents: 0
diff changeset
29 retcode INTEGER DEFAULT 0,
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 3
diff changeset
30 console TEXT DEFAULT NULL,
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 3
diff changeset
31 date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
32 );