Mercurial > sci
comparison sql/init.sql @ 62:eaebcc612a0d
misc: add header in SQL files
author | David Demelier <markand@malikania.fr> |
---|---|
date | Thu, 18 Aug 2022 12:18:12 +0200 |
parents | 081e1c258e64 |
children | 71cd8447e3a4 |
comparison
equal
deleted
inserted
replaced
61:8be8188d61a5 | 62:eaebcc612a0d |
---|---|
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN | 14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN |
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF | 15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF |
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. | 16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. |
17 -- | 17 -- |
18 | 18 |
19 CREATE TABLE IF NOT EXISTS project( | 19 CREATE TABLE IF NOT EXISTS `project`( |
20 `name` TEXT NOT NULL PRIMARY KEY, | 20 `name` TEXT NOT NULL PRIMARY KEY, |
21 `desc` TEXT NOT NULL, | 21 `desc` TEXT NOT NULL, |
22 `url` TEXT NOT NULL, | 22 `url` TEXT NOT NULL, |
23 `script` TEXT NOT NULL, | 23 `script` TEXT NOT NULL, |
24 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) | 24 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) |
25 ); | 25 ); |
26 | 26 |
27 CREATE TABLE IF NOT EXISTS worker( | 27 CREATE TABLE IF NOT EXISTS `worker`( |
28 `name` TEXT NOT NULL PRIMARY KEY, | 28 `name` TEXT NOT NULL PRIMARY KEY, |
29 `desc` TEXT NOT NULL, | 29 `desc` TEXT NOT NULL, |
30 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) | 30 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) |
31 ); | 31 ); |
32 | 32 |
33 CREATE TABLE IF NOT EXISTS job( | 33 CREATE TABLE IF NOT EXISTS `job`( |
34 `tag` TEXT NOT NULL, | 34 `tag` TEXT NOT NULL, |
35 `project_name` INTEGER NOT NULL REFERENCES project (name), | 35 `project_name` INTEGER NOT NULL REFERENCES `project` (name), |
36 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) | 36 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) |
37 ); | 37 ); |
38 | 38 |
39 CREATE TABLE IF NOT EXISTS jobresult( | 39 CREATE TABLE IF NOT EXISTS `jobresult`( |
40 `job_id` INTEGER NOT NULL REFERENCES job (rowid), | 40 `job_id` INTEGER NOT NULL REFERENCES `job` (rowid), |
41 `worker_name` INTEGER NOT NULL REFERENCES worker (name), | 41 `worker_name` INTEGER NOT NULL REFERENCES `worker` (name), |
42 `console` TEXT DEFAULT NULL, | 42 `console` TEXT DEFAULT NULL, |
43 `exitcode` INTEGER DEFAULT 0, | 43 `exitcode` INTEGER DEFAULT 0, |
44 `sigcode` INTEGER DEFAULT 0, | 44 `sigcode` INTEGER DEFAULT 0, |
45 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) | 45 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) |
46 ); | 46 ); |
47 | 47 |
48 CREATE TABLE IF NOT EXISTS property( | 48 CREATE TABLE IF NOT EXISTS `property`( |
49 `key` TEXT PRIMARY KEY NOT NULL, | 49 `key` TEXT PRIMARY KEY NOT NULL, |
50 `value` TEXT | 50 `value` TEXT |
51 ); | 51 ); |