Mercurial > sci
diff sql/init.sql @ 0:f1de39079243
misc: initial import
author | David Demelier <markand@malikania.fr> |
---|---|
date | Mon, 07 Jun 2021 09:41:37 +0200 |
parents | |
children | 5afdb14df924 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/init.sql Mon Jun 07 09:41:37 2021 +0200 @@ -0,0 +1,27 @@ +CREATE TABLE IF NOT EXISTS project( + id INTEGER PRIMARY KEY AUTOINCREMENT, + name TEXT NOT NULL, + desc TEXT NOT NULL, + url TEXT NOT NULL, + script TEXT NOT NULL +); + +CREATE TABLE IF NOT EXISTS worker( + id INTEGER PRIMARY KEY AUTOINCREMENT, + name TEXT NOT NULL, + desc TEXT NOT NULL +); + +CREATE TABLE IF NOT EXISTS job( + id INTEGER PRIMARY KEY AUTOINCREMENT, + tag TEXT NOT NULL UNIQUE, + project_id INTEGER NOT NULL REFERENCES project (id) +); + +CREATE TABLE IF NOT EXISTS job_result( + id INTEGER PRIMARY KEY AUTOINCREMENT, + job_id INTEGER NOT NULL REFERENCES job (id), + worker_id INTEGER NOT NULL REFERENCES worker (id), + status INTEGER NOT NULL, + console TEXT NOT NULL +);