aboutsummaryrefslogtreecommitdiffhomepage
path: root/q1.sql
diff options
context:
space:
mode:
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'));