initial session support

1 files changed, 18 insertions, 0 deletions

diff --git a/src/guff/migrations.cr b/src/guff/migrations.cr
index 0e50fdb..c72edde 100644
--- a/src/guff/migrations.cr
+++ b/src/guff/migrations.cr
@@ -126,5 +126,23 @@ module Guff
     }, %{
       CREATE INDEX in_post_tags_post_id ON post_tags(post_id)
     }],
+  }, {
+    id: "5-sessions",
+
+    sql: [%{
+      CREATE TABLE sessions (
+        session_id  TEXT PRIMARY KEY,
+
+        created_at  TIMESTAMP WITH TIME ZONE
+                    NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+        updated_at  TIMESTAMP WITH TIME ZONE
+                    NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+        data        TEXT NOT NULL DEFAULT ''
+      )
+    }, %{
+      CREATE INDEX in_sessions_sid on sessions(session_id)
+    }],
   }]
 end