summaryrefslogtreecommitdiff
path: root/server/migrations
diff options
context:
space:
mode:
authorKjetil Orbekk <kj@orbekk.com>2022-10-08 08:57:30 -0400
committerKjetil Orbekk <kj@orbekk.com>2022-10-08 08:58:47 -0400
commitb727db0d64f4250742b0ebaac0149c1224a0d040 (patch)
tree7d789facb2b3f578e8182034b4cb7f0df5323476 /server/migrations
parent97598e7edfcdc97e665453d6f5cda316bd51291b (diff)
Add db connection to server
Diffstat (limited to 'server/migrations')
-rw-r--r--server/migrations/20221008120534_init.down.sql1
-rw-r--r--server/migrations/20221008120534_init.up.sql3
2 files changed, 2 insertions, 2 deletions
diff --git a/server/migrations/20221008120534_init.down.sql b/server/migrations/20221008120534_init.down.sql
index 3b80b80..c855f63 100644
--- a/server/migrations/20221008120534_init.down.sql
+++ b/server/migrations/20221008120534_init.down.sql
@@ -1,2 +1,3 @@
-- Add down migration script here
drop table if exists users;
+drop table if exists sessions;
diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql
index bcd9c2c..301d2eb 100644
--- a/server/migrations/20221008120534_init.up.sql
+++ b/server/migrations/20221008120534_init.up.sql
@@ -1,7 +1,6 @@
-- Add up migration script here
-create table users (
+create table sessions (
id uuid primary key,
- username varchar(32) not null,
access_token varchar(2048) not null,
access_token_expiration timestamp with time zone not null,
refresh_token varchar(512) not null