Mercurial > sci
view 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 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 NOT NULL, console TEXT NOT NULL );