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,
	date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
);

CREATE TABLE IF NOT EXISTS worker(
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	name TEXT NOT NULL,
	desc TEXT NOT NULL,
	date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
);

CREATE TABLE IF NOT EXISTS job(
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	tag TEXT NOT NULL UNIQUE,
	project_id INTEGER NOT NULL REFERENCES project (id),
	date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
);

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,
	date INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
);