1 files changed, 1 insertions, 1 deletions
diff --git a/schema.sql b/schema.sql
index 5fd2c3e..b533685 100644
--- a/schema.sql
+++ b/schema.sql
@@ -7,6 +7,6 @@ CREATE TABLE sessions(
        id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
        created_at timestamp DEFAULT now(),
        expire timestamp,
-       user_id integer REFERENCES users(id)
+       user_id integer REFERENCES users(id) ON DELETE CASCADE
 );