From 432baae1b49343ea780793330149a285a53bbdc7 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Fri, 21 Mar 2025 15:11:30 +0900 Subject: wip --- q1.sql | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) (limited to 'q1.sql') 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')); -- cgit v1.2.3-70-g09d2