Mercurial > sci
view sql/init.sql @ 1:5afdb14df924
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 |
line wrap: on
line source
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 DEFAULT 0, retcode INTEGER DEFAULT 0, console TEXT DEFAULT NULL );