Mercurial > sci

comparison 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
comparison
equal deleted inserted replaced
25:c40f98360ac9 26:7e10cace67a3
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 (id), 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 `exitcode` INTEGER DEFAULT 0, 42 `exitcode` INTEGER DEFAULT 0,
43 `console` TEXT DEFAULT NULL, 43 `console` TEXT DEFAULT NULL,
44 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) 44 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
45 ); 45 );