INSERT INTO users
(username, display_name, icon_path, is_admin)
VALUES
    ('a', 'TEST A', NULL, FALSE),
    ('b', 'TEST B', NULL, FALSE),
    ('c', 'TEST C', NULL, TRUE);

INSERT INTO user_auths
(user_id, auth_type, password_hash)
VALUES
    (1, 'password', '$2a$10$5FzjoitnZSFFpIPHEqmnXOQkSKWTLwpR.gqPy50iFg5itOZcqARHq'),
    (2, 'password', '$2a$10$4Wl1M4jQs.GwkB4oT32KvuMQtF.EdqKuOc8z8KKOupnuMJRAVk32W'),
    (3, 'password', '$2a$10$F/TePpu1pyJRWgn0e6A14.VL9D/17sRxT/2DyZ2Oi4Eg/lR6n7JcK');

INSERT INTO problems
(title, description, language, sample_code)
VALUES
    ('TEST problem 1', 'This is TEST problem 1', 'php', 'sample code'),
    ('TEST problem 2', 'This is TEST problem 2', 'php', 'sample code'),
    ('TEST problem 3', 'This is TEST problem 3', 'php', 'sample code'),
    ('TEST problem 4', 'This is TEST problem 4', 'php', 'sample code'),
    ('TEST problem 5', 'This is TEST problem 5', 'php', 'sample code'),
    ('TEST problem 6', 'This is TEST problem 6', 'php', 'sample code'),
    ('TEST problem 7', 'This is TEST problem 7', 'php', 'sample code');

INSERT INTO games
(game_type, is_public, display_name, duration_seconds, problem_id)
VALUES
    ('1v1',         true,  'TEST game 1', 180, 1),
    ('1v1',         false, 'TEST game 2', 180, 2),
    ('1v1',         false, 'TEST game 3', 180, 3),
    ('multiplayer', true,  'TEST game 4', 180, 4),
    ('multiplayer', false, 'TEST game 5', 180, 5),
    ('multiplayer', false, 'TEST game 6', 180, 6),
    ('multiplayer', true,  'TEST game 7', 180, 7);

INSERT INTO testcases
(problem_id, stdin, stdout)
VALUES
    (1, '', '42'),
    (2, '', '42'),
    (3, '', '42'),
    (4, '', '42'),
    (5, '', '42'),
    (6, '', '42'),
    (7, '', '42');

-- Tournament: 3 participants, bracket_size=4, num_rounds=2
INSERT INTO tournaments
(display_name, bracket_size, num_rounds)
VALUES
    ('TEST Tournament', 4, 2);

-- Entries: 3 players with seeds 1-3 (seed 4 = bye)
INSERT INTO tournament_entries
(tournament_id, user_id, seed)
VALUES
    (1, 1, 1),
    (1, 2, 2),
    (1, 3, 3);

-- Matches: Round 0 has 2 matches, Round 1 has 1 match (final)
INSERT INTO tournament_matches
(tournament_id, round, position, game_id)
VALUES
    (1, 0, 0, 1),
    (1, 0, 1, 2),
    (1, 1, 0, 3);