

-- Insert default map provider configurations
INSERT INTO map_provider_configs (`provider_name`, `display_name`, `description`, `is_active`, `priority`) VALUES
('mapbox', 'Mapbox', 'Mapbox Maps and Navigation API', true, 100),
('google_maps', 'Google Maps', 'Google Maps Platform API', false, 90),
('openstreetmap', 'OpenStreetMap', 'Open source map data', false, 50)
ON DUPLICATE KEY UPDATE `provider_name` = `provider_name`;

-- Insert default vehicle categories
INSERT INTO vehicle_categories (`name`, `display_name`, `description`, `max_passengers`, `base_fare`, `per_km_rate`, `per_minute_rate`, `minimum_fare`, `icon_url`, `sort_order`) VALUES
('economy', 'Economy', 'Affordable everyday rides', 4, 200, 100, 15, 500, '/icons/economy.png', 1),
('comfort', 'Comfort', 'More space and comfort', 4, 350, 150, 20, 800, '/icons/comfort.png', 2),
('premium', 'Premium', 'Premium vehicles for luxury rides', 4, 500, 250, 35, 1500, '/icons/premium.png', 3),
('suv', 'SUV', 'Spacious SUV for groups', 6, 450, 200, 30, 1200, '/icons/suv.png', 4),
('xl', 'XL', 'Extra large vehicles', 7, 600, 300, 40, 2000, '/icons/xl.png', 5)
ON DUPLICATE KEY UPDATE `name` = `name`;
