From af36c59851399194bcbb77a3093d46c2757cb7b4 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Fri, 9 Aug 2024 23:30:10 +0900 Subject: feat: support authentication via fortee --- backend/schema.sql | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'backend/schema.sql') diff --git a/backend/schema.sql b/backend/schema.sql index 64642bc..2779eaf 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -17,6 +17,12 @@ CREATE TABLE user_auths ( ); CREATE INDEX idx_user_auths_user_id ON user_auths(user_id); +CREATE TABLE registration_tokens ( + registration_token_id SERIAL PRIMARY KEY, + token CHAR(16) NOT NULL +); +CREATE INDEX idx_registration_tokens_token ON registration_tokens(token); + CREATE TABLE problems ( problem_id SERIAL PRIMARY KEY, title VARCHAR(255) NOT NULL, -- cgit v1.2.3-70-g09d2