diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-03-21 15:11:30 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-03-21 15:40:40 +0900 |
| commit | 432baae1b49343ea780793330149a285a53bbdc7 (patch) | |
| tree | 3dc84e517910fb7e15f172bab5a803a6379a7c32 /q1.sql | |
| parent | 589d2355910e8fc63eabecad631b16b3d3d6a492 (diff) | |
| download | phperkaigi-2025-albatross-432baae1b49343ea780793330149a285a53bbdc7.tar.gz phperkaigi-2025-albatross-432baae1b49343ea780793330149a285a53bbdc7.tar.zst phperkaigi-2025-albatross-432baae1b49343ea780793330149a285a53bbdc7.zip | |
wip
Diffstat (limited to 'q1.sql')
| -rw-r--r-- | q1.sql | 14 |
1 files changed, 10 insertions, 4 deletions
@@ -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')); |