From 668937e3a195ae14d338352a496ec627bee0bf80 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Sun, 16 Mar 2025 01:29:40 +0900
Subject: commit admin queries

---
 q1.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 q1.sql

(limited to 'q1.sql')

diff --git a/q1.sql b/q1.sql
new file mode 100644
index 0000000..e2d24b2
--- /dev/null
+++ b/q1.sql
@@ -0,0 +1,9 @@
+INSERT INTO problems (title, description, sample_code)
+VALUES
+    ('じゃんけん',   '', ''),
+    ('でっかい数字', '', '');
+
+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 = 'でっかい数字'));
-- 
cgit v1.3.1

