summaryrefslogtreecommitdiff
path: root/server/migrations/20221008120534_init.up.sql
diff options
context:
space:
mode:
authorKjetil Orbekk <kj@orbekk.com>2022-10-08 17:22:48 -0400
committerKjetil Orbekk <kj@orbekk.com>2022-10-08 17:22:48 -0400
commit30102e5da48b53806b33f04041a46bec4c3b2fa3 (patch)
treecf9fd3ce1f8c449cb4cb1b8837015c7b514b916b /server/migrations/20221008120534_init.up.sql
parent1cbf881835fc33859a31645f886c5d3787ed48f8 (diff)
Add token refresh and persist sessions in the db
Diffstat (limited to 'server/migrations/20221008120534_init.up.sql')
-rw-r--r--server/migrations/20221008120534_init.up.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql
index 301d2eb..b3527eb 100644
--- a/server/migrations/20221008120534_init.up.sql
+++ b/server/migrations/20221008120534_init.up.sql
@@ -3,5 +3,6 @@ create table sessions (
id uuid primary key,
access_token varchar(2048) not null,
access_token_expiration timestamp with time zone not null,
- refresh_token varchar(512) not null
+ refresh_token varchar(1024) not null,
+ last_refresh timestamp with time zone not null default now()
);