-- ============================================
-- VIDEO MANAGEMENT SYSTEM - SAMPLE DATA
-- Compatible with phpMyAdmin
-- ============================================

-- Insert sample arenas with all fields
INSERT INTO arenas (name, description, address, phone, email, is_active) VALUES
    ('Arena Central', 'Arena principal localizada no centro da cidade', 'Rua Principal, 100 - Centro', '(11) 99999-0001', 'contato@arenacentral.com', 1),
    ('Arena Norte', 'Arena moderna na zona norte', 'Av. Norte, 500 - Zona Norte', '(11) 99999-0002', 'contato@arenanorte.com', 1),
    ('Arena Sul', 'Complexo esportivo na zona sul', 'Rua Sul, 200 - Zona Sul', '(11) 99999-0003', 'contato@arenasul.com', 1),
    ('Arena Leste', 'Arena com 4 quadras cobertas', 'Av. Leste, 800 - Zona Leste', '(11) 99999-0004', 'contato@arenaleste.com', 1),
    ('Arena Oeste', 'Arena esportiva completa', 'Rua Oeste, 300 - Zona Oeste', '(11) 99999-0005', 'contato@arenaoeste.com', 1);

-- Insert sample courts for each arena
-- Arena Central (id = 1)
INSERT INTO courts (arena_id, name) VALUES
    (1, 'Quadra 1'),
    (1, 'Quadra 2'),
    (1, 'Quadra 3');

-- Arena Norte (id = 2)
INSERT INTO courts (arena_id, name) VALUES
    (2, 'Quadra A'),
    (2, 'Quadra B');

-- Arena Sul (id = 3)
INSERT INTO courts (arena_id, name) VALUES
    (3, 'Quadra Principal'),
    (3, 'Quadra Secundaria');

-- Arena Leste (id = 4)
INSERT INTO courts (arena_id, name) VALUES
    (4, 'Court 1'),
    (4, 'Court 2'),
    (4, 'Court 3'),
    (4, 'Court 4');

-- Arena Oeste (id = 5)
INSERT INTO courts (arena_id, name) VALUES
    (5, 'Quadra Alpha'),
    (5, 'Quadra Beta');
