update schema

1 files changed, 7 insertions, 5 deletions

diff --git a/schema.sql b/schema.sql
index a2a74b1..5fd2c3e 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,10 +1,12 @@
+CREATE TABLE users(
+       id serial PRIMARY KEY,
+       name text,
+       password text);
+
 CREATE TABLE sessions(
+       id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
        created_at timestamp DEFAULT now(),
-       session_id uuid DEFAULT gen_random_uuid(),
+       expire timestamp,
        user_id integer REFERENCES users(id)
 );
 
-CREATE TABLE users(
-       id integer PRIMARY KEY serial,
-       user_name text
-       password text);