aboutsummaryrefslogtreecommitdiffhomepage
path: root/q1.sql
diff options
context:
space:
mode:
Diffstat (limited to 'q1.sql')
-rw-r--r--q1.sql14
1 files changed, 10 insertions, 4 deletions
diff --git a/q1.sql b/q1.sql
index e2d24b2..5f188f8 100644
--- a/q1.sql
+++ b/q1.sql
@@ -1,9 +1,15 @@
INSERT INTO problems (title, description, sample_code)
VALUES
- ('じゃんけん', '', ''),
- ('でっかい数字', '', '');
+ ('序数', '', ''),
+ ('Σ', '', ''),
+ ('漢数字', '', ''),
+ ('カレンダー', '', ''),
+ ('ダイナミックFizzBuzz', '', '');
INSERT INTO games (game_type, is_public, display_name, duration_seconds, problem_id)
VALUES
- ('multiplayer', false, 'オンライン予選1', 86400*5 + 3600*11, (SELECT problem_id FROM problems WHERE title = 'じゃんけん')),
- ('multiplayer', false, 'オンライン予選2', 86400*5 + 3600*11, (SELECT problem_id FROM problems WHERE title = 'でっかい数字'));
+ ('1v1', false, '準々決勝マッチ1', 15*60, (SELECT problem_id FROM problems WHERE title = '序数')),
+ ('1v1', false, '準々決勝マッチ2', 15*60, (SELECT problem_id FROM problems WHERE title = 'Σ')),
+ ('1v1', false, '準決勝マッチ1', 15*60, (SELECT problem_id FROM problems WHERE title = '漢数字')),
+ ('1v1', false, '準決勝マッチ2', 15*60, (SELECT problem_id FROM problems WHERE title = 'カレンダー')),
+ ('1v1', false, '決勝', 15*60, (SELECT problem_id FROM problems WHERE title = 'ダイナミックFizzBuzz'));