Mercurial > sci

comparison sql/init.sql @ 62:eaebcc612a0d

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