INSERT INTO users (name, email, username, password_hash, role, parent_id, is_active, created_at, updated_at) VALUES
('Administrador Demo', 'admin@demo.com', 'admin', '$2y$12$H38c/fZ6IAFGWJNzZ45drepq9hPxplh2CjkfT31pKAkqf4OMuqOLO', 'admin', NULL, 1, NOW(), NOW()),
('Revendedor Demo', 'revendedor@demo.com', 'revendedor', '$2y$12$YsFfsfAALddylOHgQveA3ezmHAA2Gy5LY9El3C2kOKPayHyT2sOE.', 'reseller', 1, 1, NOW(), NOW()),
('Cliente Final Demo', 'cliente@demo.com', 'cliente', '$2y$12$oVBhyhsdlPKar5M4dAlFQO9zXfFjRXPaqIkne/269wqtXgSKBPgee', 'client', 2, 1, NOW(), NOW());

INSERT INTO settings (key_name, value, updated_at) VALUES
('account_price', '__ACCOUNT_PRICE__', NOW()),
('sales_whatsapp', '__SALES_WHATSAPP__', NOW());

INSERT INTO activation_codes (user_id, code, is_used, created_at) VALUES
(3, 'CLIENTE-2026-001', 0, NOW());

INSERT INTO qr_tokens (user_id, token, is_active, created_at) VALUES
(3, 'QR-CLIENTE-DEMO-001', 1, NOW());

INSERT INTO account_requests
(reseller_id, client_name, client_email, desired_username, password_hash, requested_price, status, notes, created_at, updated_at)
VALUES
(2, 'Canal Sports Pro', 'canal@example.com', 'canalsports', '$2y$12$iFX/FKL.8DpvXNtvqlFbA.2hR4DmpG2jbTGSlU4F6EmAhCM.iGwby', __ACCOUNT_PRICE__, 'pending', 'Cuenta demo pendiente de aprobación', NOW(), NOW());

INSERT INTO notifications (user_id, type, message, is_read, created_at) VALUES
(1, 'info', 'Nueva solicitud pendiente del revendedor demo.', 0, NOW()),
(2, 'success', 'Tu solicitud demo fue registrada y está pendiente de aprobación.', 0, NOW());

INSERT INTO sports_events
(sport, region, country, league, event_date, event_time_utc, home_name, away_name, venue, status, created_at, updated_at)
VALUES
('Fútbol', 'Sudamérica', 'Uruguay', 'Primera División', '__TODAY__', '__TODAY__ 23:30:00', 'Peñarol', 'Juventud', 'Montevideo', 'scheduled', NOW(), NOW()),
('Fútbol', 'Europa', 'España', 'LaLiga', '__TODAY__', '__TODAY__ 20:00:00', 'Sevilla', 'Valencia', 'Sevilla', 'scheduled', NOW(), NOW()),
('Fútbol', 'Centroamérica', 'México', 'Liga MX', '__TODAY__', '__TODAY__ 02:30:00', 'América', 'Tigres', 'Ciudad de México', 'scheduled', NOW(), NOW()),
('Básquet', 'Norteamérica', 'Estados Unidos', 'NBA', '__TODAY__', '__TODAY__ 23:00:00', 'Lakers', 'Celtics', 'Los Angeles', 'scheduled', NOW(), NOW()),
('Básquet', 'Europa', 'España', 'Liga ACB', '__TODAY__', '__TODAY__ 18:30:00', 'Real Madrid', 'Barcelona', 'Madrid', 'scheduled', NOW(), NOW()),
('Tenis', 'Internacional', 'España', 'ATP Madrid Open', '__TODAY__', '__TODAY__ 14:00:00', 'Carlos Alcaraz', 'Jannik Sinner', 'Madrid', 'scheduled', NOW(), NOW()),
('Tenis', 'Internacional', 'Estados Unidos', 'WTA Miami', '__TOMORROW__', '__TOMORROW__ 16:00:00', 'Iga Swiatek', 'Coco Gauff', 'Miami', 'scheduled', NOW(), NOW());
