ALTER TABLE `bewin_orange`.`work_profile` 
ADD COLUMN `hide_work_profile` BIT(1) NULL DEFAULT b'0' AFTER `default_profile`;

ALTER TABLE `bewin_orange`.`service_point` 
ADD COLUMN `color` VARCHAR(45) NULL AFTER `appears_with_ticket`;

-- Colores
UPDATE bewin_orange.service_point 
SET color = CASE 
    WHEN id IN (23, 24, 25, 6, 4, 16, 14) THEN '#ffffa3'
    WHEN id = 17 THEN '#ffcccc'
    WHEN id = 12 THEN '#c2c2c2'
    WHEN id IN (11, 22) THEN '#b2e0c2'
    WHEN id = 9 THEN '#d6d6ff'
    WHEN id = 10 THEN '#ffe6b2'
    ELSE color  -- Mantener el color actual si no coincide
END
WHERE id IN (23, 24, 25, 6, 4, 16, 14, 17, 12, 11, 22, 9, 10);

UPDATE bewin_orange.service_point
SET color = CASE 
    WHEN id IN (35, 37, 48, 27, 29, 32) THEN '#809bce'
    WHEN id IN (34, 36, 38, 40) THEN '#95b8d1'
    WHEN id IN (42, 44, 46, 45, 43, 47) THEN '#b8e0d2'
    WHEN id IN (28, 30, 31, 33) THEN '#d6eadf'
    WHEN id IN (39, 41) THEN '#eac4d5'
END
WHERE id IN (35, 37, 48, 27, 29, 32, 34, 36, 38, 40, 42, 44, 46, 45, 43, 47, 28, 30, 31, 33, 39, 41);