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 jobresult(
	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
);