From b8b80e0a896433bed8eb331aff3ecd12e00fd4ba Mon Sep 17 00:00:00 2001
From: Guillaume Horel <guillaume.horel@gmail.com>
Date: Thu, 27 Dec 2018 13:15:16 -0500
Subject: add schema

---
 schema.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 schema.sql

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..a2a74b1
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,10 @@
+CREATE TABLE sessions(
+       created_at timestamp DEFAULT now(),
+       session_id uuid DEFAULT gen_random_uuid(),
+       user_id integer REFERENCES users(id)
+);
+
+CREATE TABLE users(
+       id integer PRIMARY KEY serial,
+       user_name text
+       password text);
-- 
cgit v1.2.3-70-g09d2

