Mercurial > sci

comparison sql/init.sql @ 1:5afdb14df924

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
sci: add support for storing results
author David Demelier <markand@malikania.fr>
date Tue, 08 Jun 2021 08:40:01 +0200
parents f1de39079243
children 215c0c3b3609
comparison
equal deleted inserted replaced
0:f1de39079243 1:5afdb14df924
20 20
21 CREATE TABLE IF NOT EXISTS job_result( 21 CREATE TABLE IF NOT EXISTS job_result(
22 id INTEGER PRIMARY KEY AUTOINCREMENT, 22 id INTEGER PRIMARY KEY AUTOINCREMENT,
23 job_id INTEGER NOT NULL REFERENCES job (id), 23 job_id INTEGER NOT NULL REFERENCES job (id),
24 worker_id INTEGER NOT NULL REFERENCES worker (id), 24 worker_id INTEGER NOT NULL REFERENCES worker (id),
25 status INTEGER NOT NULL, 25 status INTEGER DEFAULT 0,
26 console TEXT NOT NULL 26 retcode INTEGER DEFAULT 0,
27 console TEXT DEFAULT NULL
27 ); 28 );