Mercurial > sci

annotate sql/init.sql @ 26:7e10cace67a3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: add basic mustache support
author David Demelier <markand@malikania.fr>
date Tue, 02 Aug 2022 13:24:13 +0200
parents dd078aea5d02
children dae2de19ca5d
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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 --
3051ef92173a misc: add license headers
David Demelier <markand@malikania.fr>
parents: 12
diff changeset
4 -- Copyright (c) 2021 David Demelier <markand@malikania.fr>
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
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
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
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
21 `desc` TEXT NOT NULL,
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
22 `url` TEXT NOT NULL,
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
23 `script` TEXT NOT NULL,
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
24 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
25 );
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
26
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
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
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
29 `desc` TEXT NOT NULL,
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
30 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
31 );
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
32
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
33 CREATE TABLE IF NOT EXISTS job(
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
34 `tag` TEXT NOT NULL UNIQUE,
22
dd078aea5d02 misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents: 19
diff changeset
35 `project_name` INTEGER NOT NULL REFERENCES project (name),
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
36 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
37 );
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
38
3
215c0c3b3609 misc: use JSON everywhere (scictl/sciwebd)
David Demelier <markand@malikania.fr>
parents: 1
diff changeset
39 CREATE TABLE IF NOT EXISTS jobresult(
26
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents: 22
diff changeset
40 `job_id` INTEGER NOT NULL REFERENCES job (rowid),
22
dd078aea5d02 misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents: 19
diff changeset
41 `worker_name` INTEGER NOT NULL REFERENCES worker (name),
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
42 `exitcode` INTEGER DEFAULT 0,
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
43 `console` TEXT DEFAULT NULL,
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
44 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
0
f1de39079243 misc: initial import
David Demelier <markand@malikania.fr>
parents:
diff changeset
45 );
16
3051ef92173a misc: add license headers
David Demelier <markand@malikania.fr>
parents: 12
diff changeset
46
3051ef92173a misc: add license headers
David Demelier <markand@malikania.fr>
parents: 12
diff changeset
47 CREATE TABLE IF NOT EXISTS property(
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
48 `key` TEXT PRIMARY KEY NOT NULL,
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
49 `value` TEXT
16
3051ef92173a misc: add license headers
David Demelier <markand@malikania.fr>
parents: 12
diff changeset
50 );