diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-29 23:52:37 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-30 00:26:09 +0900 |
| commit | b7e2d4571b61f20a9f4a288f41ba0a30e488eda4 (patch) | |
| tree | 71cb6be06a126fb2683c377e16ac0ef5c5af2d31 /backend/schema.sql | |
| parent | 7e2704c90ffba3612bd87ed342d4f310b0de78c0 (diff) | |
| download | phperkaigi-2025-albatross-b7e2d4571b61f20a9f4a288f41ba0a30e488eda4.tar.gz phperkaigi-2025-albatross-b7e2d4571b61f20a9f4a288f41ba0a30e488eda4.tar.zst phperkaigi-2025-albatross-b7e2d4571b61f20a9f4a288f41ba0a30e488eda4.zip | |
feat(backend): add fixture file for local dev
Diffstat (limited to 'backend/schema.sql')
| -rw-r--r-- | backend/schema.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/backend/schema.sql b/backend/schema.sql index 7f98d91..2a92271 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -15,6 +15,12 @@ CREATE TABLE user_auths ( CONSTRAINT fk_user_id FOREIGN KEY(user_id) REFERENCES users(user_id) ); +CREATE TABLE problems ( + problem_id SERIAL PRIMARY KEY, + title VARCHAR(255) NOT NULL, + description TEXT NOT NULL +); + CREATE TABLE games ( game_id SERIAL PRIMARY KEY, state VARCHAR(32) NOT NULL, @@ -34,12 +40,6 @@ CREATE TABLE game_players ( CONSTRAINT fk_user_id FOREIGN KEY(user_id) REFERENCES users(user_id) ); -CREATE TABLE problems ( - problem_id SERIAL PRIMARY KEY, - title VARCHAR(255) NOT NULL, - description TEXT NOT NULL -); - CREATE TABLE testcases ( testcase_id SERIAL PRIMARY KEY, problem_id INT NOT NULL, |