aboutsummaryrefslogtreecommitdiffhomepage
path: root/q1.sql
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2025-03-21 19:55:20 +0900
committernsfisis <nsfisis@gmail.com>2025-03-21 19:55:20 +0900
commit7e94e4d2f8ccce36165cd5f2a092a2ba7645d69c (patch)
tree22f2dc53985cf2923663e0463d28847d1fc51bd8 /q1.sql
parent7ba9051c35753c1c987b10cfc926ebf805f270d0 (diff)
downloadphperkaigi-2025-albatross-7e94e4d2f8ccce36165cd5f2a092a2ba7645d69c.tar.gz
phperkaigi-2025-albatross-7e94e4d2f8ccce36165cd5f2a092a2ba7645d69c.tar.zst
phperkaigi-2025-albatross-7e94e4d2f8ccce36165cd5f2a092a2ba7645d69c.zip
remove admin queries
Diffstat (limited to 'q1.sql')
-rw-r--r--q1.sql15
1 files changed, 0 insertions, 15 deletions
diff --git a/q1.sql b/q1.sql
deleted file mode 100644
index 5f188f8..0000000
--- a/q1.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-INSERT INTO problems (title, description, sample_code)
-VALUES
- ('序数', '', ''),
- ('Σ', '', ''),
- ('漢数字', '', ''),
- ('カレンダー', '', ''),
- ('ダイナミックFizzBuzz', '', '');
-
-INSERT INTO games (game_type, is_public, display_name, duration_seconds, problem_id)
-VALUES
- ('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'));