1 files changed, 13 insertions, 0 deletions
diff --git a/src/sqlite/v01.sql b/src/sqlite/v01.sql
new file mode 100644
index 0000000..26869b6
--- /dev/null
+++ b/src/sqlite/v01.sql
@@ -0,0 +1,13 @@
+CREATE TABLE cimple_repositories (
+	id INTEGER PRIMARY KEY,
+	url TEXT NOT NULL UNIQUE
+) STRICT;
+
+CREATE TABLE cimple_runs (
+	id INTEGER PRIMARY KEY,
+	result INTEGER NOT NULL,
+	output BLOB NOT NULL,
+	repo_id INTEGER NOT NULL,
+	FOREIGN KEY (repo_id) REFERENCES cimple_repositories(id)
+		ON DELETE CASCADE ON UPDATE CASCADE
+) STRICT;