1 files changed, 13 insertions, 0 deletions
diff --git a/migrations/deploy/sessions.sql b/migrations/deploy/sessions.sql
new file mode 100644
index 0000000..6d0122c
--- /dev/null
+++ b/migrations/deploy/sessions.sql
@@ -0,0 +1,13 @@
+-- Deploy byspel:sessions to sqlite
+-- requires: users
+
+BEGIN;
+
+create table sessions(
+  session_id uuid not null primary key,
+  user_id uuid not null,
+  expires timestamp not null,
+  foreign key (user_id) references users(id) on delete cascade
+);
+
+COMMIT;