Mercurial > sci
annotate sql/init.sql @ 85:cf49ab595e2e default tip @
sciworkerd: avoid spawning several tasks
author | David Demelier <markand@malikania.fr> |
---|---|
date | Thu, 09 Mar 2023 10:43:48 +0100 |
parents | 71cd8447e3a4 |
children |
rev | line source |
---|---|
16
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
1 -- |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
2 -- init.sql -- create database |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
3 -- |
80
71cd8447e3a4
misc: update copyright years
David Demelier <markand@malikania.fr>
parents:
62
diff
changeset
|
4 -- Copyright (c) 2021-2023 David Demelier <markand@malikania.fr> |
16
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
5 -- |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
6 -- Permission to use, copy, modify, and/or distribute this software for any |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
7 -- purpose with or without fee is hereby granted, provided that the above |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
8 -- copyright notice and this permission notice appear in all copies. |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
9 -- |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
17 -- |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
18 |
62
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
19 CREATE TABLE IF NOT EXISTS `project`( |
22
dd078aea5d02
misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents:
19
diff
changeset
|
20 `name` TEXT NOT NULL PRIMARY KEY, |
19 | 21 `desc` TEXT NOT NULL, |
22 `url` TEXT NOT NULL, | |
23 `script` TEXT NOT NULL, | |
24 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) | |
0 | 25 ); |
26 | |
62
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
27 CREATE TABLE IF NOT EXISTS `worker`( |
22
dd078aea5d02
misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents:
19
diff
changeset
|
28 `name` TEXT NOT NULL PRIMARY KEY, |
19 | 29 `desc` TEXT NOT NULL, |
30 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) | |
0 | 31 ); |
32 | |
62
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
33 CREATE TABLE IF NOT EXISTS `job`( |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
34 `tag` TEXT NOT NULL, |
62
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
35 `project_name` INTEGER NOT NULL REFERENCES `project` (name), |
19 | 36 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) |
0 | 37 ); |
38 | |
62
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
39 CREATE TABLE IF NOT EXISTS `jobresult`( |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
40 `job_id` INTEGER NOT NULL REFERENCES `job` (rowid), |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
41 `worker_name` INTEGER NOT NULL REFERENCES `worker` (name), |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
42 `console` TEXT DEFAULT NULL, |
19 | 43 `exitcode` INTEGER DEFAULT 0, |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
44 `sigcode` INTEGER DEFAULT 0, |
19 | 45 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) |
0 | 46 ); |
16
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
47 |
62
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
48 CREATE TABLE IF NOT EXISTS `property`( |
19 | 49 `key` TEXT PRIMARY KEY NOT NULL, |
50 `value` TEXT | |
16
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
51 ); |