diff options
Diffstat (limited to 'src/guff/migrations.cr')
-rw-r--r-- | src/guff/migrations.cr | 18 |
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 |