aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'backend/schema.sql')
-rw-r--r--backend/schema.sql6
1 files changed, 6 insertions, 0 deletions
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,