1 files changed, 11 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..7e3886f
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,11 @@
+CREATE TABLE users (
+	id TEXT PRIMARY KEY NOT NULL,
+	name TEXT,
+	email TEXT
+);
+CREATE TABLE sessions (
+	userid TEXT NOT NULL,
+	cookie TEXT,
+	expr INTEGER,
+	FOREIGN KEY(userid) REFERENCES users(id)
+);