aboutsummaryrefslogtreecommitdiffhomepage
path: root/q1.sql
diff options
context:
space:
mode:
Diffstat (limited to 'q1.sql')
-rw-r--r--q1.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/q1.sql b/q1.sql
new file mode 100644
index 0000000..ca9ee15
--- /dev/null
+++ b/q1.sql
@@ -0,0 +1,17 @@
+INSERT INTO problems (title, description, sample_code)
+VALUES
+ ('練習問題', '', ''),
+ ('九九', '', ''),
+ ('いろは', '', ''),
+ ('グルーピング', '', ''),
+ ('しりとり', '', ''),
+ ('ポップカウント', '', '');
+
+INSERT INTO games (game_type, is_public, display_name, duration_seconds, problem_id)
+VALUES
+ ('multiplayer', true, '練習問題', 900, 21),
+ ('multiplayer', true, '予選ラウンド1', 900, 22),
+ ('multiplayer', true, '予選ラウンド2', 900, 23),
+ ('multiplayer', true, '予選ラウンド3', 900, 24),
+ ('1v1', true, 'エキシビション1', 900, 25),
+ ('1v1', true, 'エキシビション2', 900, 26);