-- SportsPulse Seed Data
-- Initial data for sports platform

-- Insert default sports
INSERT INTO `sports` (`name`, `slug`, `icon`, `is_active`, `sort_order`) VALUES
('Football', 'football', 'football', 1, 1),
('Basketball', 'basketball', 'basketball', 1, 2),
('Tennis', 'tennis', 'tennis', 1, 3),
('Cricket', 'cricket', 'cricket', 1, 4),
('Ice Hockey', 'ice-hockey', 'hockey', 1, 5),
('Baseball', 'baseball', 'baseball', 1, 6),
('American Football', 'american-football', 'american-football', 1, 7),
('Rugby', 'rugby', 'rugby', 1, 8),
('Volleyball', 'volleyball', 'volleyball', 1, 9),
('Handball', 'handball', 'handball', 1, 10);

-- Insert major countries
INSERT INTO `countries` (`name`, `slug`, `code`, `is_active`) VALUES
('England', 'england', 'GB-ENG', 1),
('Spain', 'spain', 'ES', 1),
('Germany', 'germany', 'DE', 1),
('Italy', 'italy', 'IT', 1),
('France', 'france', 'FR', 1),
('Netherlands', 'netherlands', 'NL', 1),
('Portugal', 'portugal', 'PT', 1),
('Belgium', 'belgium', 'BE', 1),
('Scotland', 'scotland', 'GB-SCT', 1),
('Turkey', 'turkey', 'TR', 1),
('Greece', 'greece', 'GR', 1),
('Brazil', 'brazil', 'BR', 1),
('Argentina', 'argentina', 'AR', 1),
('USA', 'usa', 'US', 1),
('Mexico', 'mexico', 'MX', 1),
('Japan', 'japan', 'JP', 1),
('South Korea', 'south-korea', 'KR', 1),
('China', 'china', 'CN', 1),
('Australia', 'australia', 'AU', 1),
('Saudi Arabia', 'saudi-arabia', 'SA', 1),
('World', 'world', 'WORLD', 1),
('Europe', 'europe', 'EU', 1);
