-- Update Bill Providers to US Companies
-- Run this migration to update existing databases

-- First, delete old electricity providers (category_id = 3)
DELETE FROM `bill_providers` WHERE `category_id` = 3;

-- Insert US Electricity Providers
INSERT INTO `bill_providers` (`category_id`, `name`, `slug`, `provider_code`) VALUES
(3, 'PG&E', 'pge', 'PGE'),
(3, 'SCE', 'sce', 'SCE'),
(3, 'Duke Energy', 'duke-energy', 'DUKE'),
(3, 'FPL', 'fpl', 'FPL'),
(3, 'Con Edison', 'coned', 'CONED'),
(3, 'ComEd', 'comed', 'COMED');

-- Optional: Update airtime providers to US carriers
-- DELETE FROM `bill_providers` WHERE `category_id` = 1;
-- INSERT INTO `bill_providers` (`category_id`, `name`, `slug`, `provider_code`) VALUES
-- (1, 'AT&T', 'att', 'ATT'),
-- (1, 'Verizon', 'verizon', 'VERIZON'),
-- (1, 'T-Mobile', 'tmobile', 'TMOBILE'),
-- (1, 'Sprint', 'sprint', 'SPRINT');

-- Optional: Update TV providers
-- DELETE FROM `bill_providers` WHERE `category_id` = 4;
-- INSERT INTO `bill_providers` (`category_id`, `name`, `slug`, `provider_code`) VALUES
-- (4, 'DirecTV', 'directv', 'DIRECTV'),
-- (4, 'Dish Network', 'dish', 'DISH'),
-- (4, 'Xfinity', 'xfinity', 'XFINITY');
