From b7e2d4571b61f20a9f4a288f41ba0a30e488eda4 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Mon, 29 Jul 2024 23:52:37 +0900
Subject: feat(backend): add fixture file for local dev

---
 backend/schema.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'backend/schema.sql')

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,
-- 
cgit v1.3.1

