From 85357ce9b82d595415f64c9ee3517627d158de2e Mon Sep 17 00:00:00 2001
From: Egor Tensin <Egor.Tensin@gmail.com>
Date: Tue, 11 Apr 2023 02:29:57 +0200
Subject: actually create some tables in SQLite database

---
 src/sqlite/v01.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 src/sqlite/v01.sql

(limited to 'src/sqlite')

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;
-- 
cgit v1.2.3