From b727db0d64f4250742b0ebaac0149c1224a0d040 Mon Sep 17 00:00:00 2001 From: Kjetil Orbekk Date: Sat, 8 Oct 2022 08:57:30 -0400 Subject: Add db connection to server --- server/migrations/20221008120534_init.down.sql | 1 + server/migrations/20221008120534_init.up.sql | 3 +-- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'server/migrations') 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 -- cgit v1.2.3