-- Expand ServiceArea enum to cover the entire Philippines (regions + major cities)
ALTER TABLE `WorkerServiceArea` MODIFY `area` ENUM(
  'MANILA',
  'QUEZON_CITY',
  'MAKATI',
  'PASIG',
  'TAGUIG',
  'MANDALUYONG',
  'CALOOCAN',
  'PARANAQUE',
  'LAS_PINAS',
  'MUNTINLUPA',
  'VALENZUELA',
  'MARIKINA',
  'PASAY',
  'BAGUIO',
  'LA_TRINIDAD',
  'LAOAG',
  'VIGAN',
  'DAGUPAN',
  'SAN_FERNANDO_LA_UNION',
  'TUGUEGARAO',
  'SANTIAGO',
  'CAUAYAN',
  'ANGELES',
  'OLONGAPO',
  'SAN_FERNANDO_PAMPANGA',
  'CABANATUAN',
  'MALOLOS',
  'CALAMBA',
  'LUCENA',
  'BATANGAS_CITY',
  'LIPA',
  'ANTIPOLO',
  'TAGAYTAY',
  'PUERTO_PRINCESA',
  'CALAPAN',
  'ROMBLON',
  'LEGAZPI',
  'NAGA',
  'SORSOGON',
  'IRIGA',
  'ILOILO_CITY',
  'BACOLOD',
  'ROXAS_CITY',
  'KALIBO',
  'CEBU_CITY',
  'LAPU_LAPU',
  'MANDAUE',
  'TAGBILARAN',
  'DUMAGUETE',
  'TACLOBAN',
  'ORMOC',
  'CALBAYOG',
  'CATBALOGAN',
  'ZAMBOANGA_CITY',
  'PAGADIAN',
  'DIPOLOG',
  'CAGAYAN_DE_ORO',
  'ILIGAN_CITY',
  'MALAYBALAY',
  'VALENCIA_CITY',
  'OZAMIZ',
  'OROQUIETA',
  'DAVAO_CITY',
  'SAMAL_CITY',
  'PANABO_CITY',
  'SANTO_TOMAS',
  'TAGUM_CITY',
  'NABUNTURAN',
  'DIGOS_CITY',
  'MATI_CITY',
  'MALITA',
  'GENERAL_SANTOS',
  'KORONADAL',
  'KIDAPAWAN',
  'TACURONG',
  'BUTUAN',
  'SURIGAO_CITY',
  'BISLIG',
  'COTABATO_CITY',
  'MARAWI',
  'ENTIRE_PHILIPPINES',
  'ENTIRE_LUZON',
  'ENTIRE_VISAYAS',
  'ENTIRE_MINDANAO',
  'ENTIRE_NCR',
  'ENTIRE_CAR',
  'ENTIRE_ILOCOS',
  'ENTIRE_CAGAYAN_VALLEY',
  'ENTIRE_CENTRAL_LUZON',
  'ENTIRE_CALABARZON',
  'ENTIRE_MIMAROPA',
  'ENTIRE_BICOL',
  'ENTIRE_WESTERN_VISAYAS',
  'ENTIRE_CENTRAL_VISAYAS',
  'ENTIRE_EASTERN_VISAYAS',
  'ENTIRE_ZAMBOANGA_PENINSULA',
  'ENTIRE_NORTHERN_MINDANAO',
  'ENTIRE_DAVAO_REGION',
  'ENTIRE_SOCCSKSARGEN',
  'ENTIRE_CARAGA',
  'ENTIRE_BARMM'
) NOT NULL;