diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-09 23:30:39 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-09 23:30:39 +0900 |
| commit | 41e98f3b0a936f7982434b74a88b919b99fd94ce (patch) | |
| tree | 72e1a3cc00044f9c00dc5f22ef9325124f272401 /backend/schema.sql | |
| parent | 93f2ffc18d1d86bd2999533e8d904c92cb29bc1a (diff) | |
| parent | af36c59851399194bcbb77a3093d46c2757cb7b4 (diff) | |
| download | iosdc-japan-2024-albatross-41e98f3b0a936f7982434b74a88b919b99fd94ce.tar.gz iosdc-japan-2024-albatross-41e98f3b0a936f7982434b74a88b919b99fd94ce.tar.zst iosdc-japan-2024-albatross-41e98f3b0a936f7982434b74a88b919b99fd94ce.zip | |
Merge branch 'feat/auth-fortee'
Diffstat (limited to 'backend/schema.sql')
| -rw-r--r-- | backend/schema.sql | 6 |
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, |