From 30102e5da48b53806b33f04041a46bec4c3b2fa3 Mon Sep 17 00:00:00 2001
From: Kjetil Orbekk <kj@orbekk.com>
Date: Sat, 8 Oct 2022 17:22:48 -0400
Subject: Add token refresh and persist sessions in the db

---
 server/migrations/20221008120534_init.up.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'server/migrations/20221008120534_init.up.sql')

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()
 );
-- 
cgit v1.2.3

