--- /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
+);