Mercurial > sci

comparison sql/init.sql @ 19:de4bf839b565

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc: revamp SQL
author David Demelier <markand@malikania.fr>
date Fri, 15 Jul 2022 11:11:48 +0200
parents 3051ef92173a
children dd078aea5d02
comparison
equal deleted inserted replaced
18:600204c31bf0 19:de4bf839b565
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 id INTEGER PRIMARY KEY AUTOINCREMENT, 20 `name` TEXT NOT NULL UNIQUE,
21 name TEXT NOT NULL UNIQUE, 21 `desc` TEXT NOT NULL,
22 desc TEXT NOT NULL, 22 `url` TEXT NOT NULL,
23 url TEXT NOT NULL, 23 `script` TEXT NOT NULL,
24 script TEXT NOT NULL, 24 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
25 date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
26 ); 25 );
27 26
28 CREATE TABLE IF NOT EXISTS worker( 27 CREATE TABLE IF NOT EXISTS worker(
29 id INTEGER PRIMARY KEY AUTOINCREMENT, 28 `name` TEXT NOT NULL UNIQUE,
30 name TEXT NOT NULL UNIQUE, 29 `desc` TEXT NOT NULL,
31 desc TEXT NOT NULL, 30 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
32 date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
33 ); 31 );
34 32
35 CREATE TABLE IF NOT EXISTS job( 33 CREATE TABLE IF NOT EXISTS job(
36 id INTEGER PRIMARY KEY AUTOINCREMENT, 34 `tag` TEXT NOT NULL UNIQUE,
37 tag TEXT NOT NULL UNIQUE, 35 `project_id` INTEGER NOT NULL REFERENCES project (id),
38 project_id INTEGER NOT NULL REFERENCES project (id), 36 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
39 date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
40 ); 37 );
41 38
42 CREATE TABLE IF NOT EXISTS jobresult( 39 CREATE TABLE IF NOT EXISTS jobresult(
43 id INTEGER PRIMARY KEY AUTOINCREMENT, 40 `job_id` INTEGER NOT NULL REFERENCES job (id),
44 job_id INTEGER NOT NULL REFERENCES job (id), 41 `worker_id` INTEGER NOT NULL REFERENCES worker (id),
45 worker_id INTEGER NOT NULL REFERENCES worker (id), 42 `exitcode` INTEGER DEFAULT 0,
46 exitcode INTEGER DEFAULT 0, 43 `console` TEXT DEFAULT NULL,
47 console TEXT DEFAULT NULL, 44 `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
48 date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
49 ); 45 );
50 46
51 CREATE TABLE IF NOT EXISTS property( 47 CREATE TABLE IF NOT EXISTS property(
52 key TEXT PRIMARY KEY NOT NULL, 48 `key` TEXT PRIMARY KEY NOT NULL,
53 value TEXT 49 `value` TEXT
54 ); 50 );