Merge branch 'feat/local-dev'

2 files changed, 44 insertions, 7 deletions

diff --git a/backend/fixtures/dev.sql b/backend/fixtures/dev.sql
new file mode 100644
index 0000000..3549d86
--- /dev/null
+++ b/backend/fixtures/dev.sql
@@ -0,0 +1,37 @@
+INSERT INTO users
+(username, display_name, icon_path, is_admin)
+VALUES
+    ('a', 'TEST A', NULL, FALSE),
+    ('b', 'TEST B', NULL, FALSE),
+    ('c', 'TEST C', NULL, TRUE);
+
+INSERT INTO user_auths
+(user_id, auth_type)
+VALUES
+    (1, 'bypass'),
+    (2, 'bypass'),
+    (3, 'bypass');
+
+INSERT INTO problems
+(title, description)
+VALUES
+    ('TEST problem 1', 'This is TEST problem 1'),
+    ('TEST problem 2', 'This is TEST problem 2'),
+    ('TEST problem 3', 'This is TEST problem 3');
+
+INSERT INTO games
+(state, display_name, duration_seconds, problem_id)
+VALUES
+    ('waiting_entries', 'TEST game 1', 180, 1),
+    ('closed',          'TEST game 2', 180, 2),
+    ('finished',        'TEST game 3', 180, 3);
+
+INSERT INTO game_players
+(game_id, user_id)
+VALUES
+    (1, 1),
+    (1, 2),
+    (2, 1),
+    (2, 2),
+    (3, 1),
+    (3, 2);
diff --git a/backend/schema.sql b/backend/schema.sql
index 7f98d91..3a4422f 100644
--- a/backend/schema.sql
+++ b/backend/schema.sql
@@ -9,12 +9,18 @@ CREATE TABLE users (
 
 CREATE TABLE user_auths (
     user_auth_id  SERIAL      PRIMARY KEY,
-    user_id       INT         NOT NULL,
+    user_id       INT         NOT NULL UNIQUE,
     auth_type     VARCHAR(16) NOT NULL,
     password_hash VARCHAR(256),
     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,