aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--schema.sql10
1 files changed, 10 insertions, 0 deletions
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);