ALTER TABLE "Service" ADD COLUMN "icon" TEXT;

UPDATE "Service"
SET "icon" = CASE
  WHEN "slug" = 'electricity' OR "nameAr" = 'كهرباء' THEN '⚡'
  WHEN "slug" = 'plumbing' OR "nameAr" = 'سباكة' THEN '🔧'
  WHEN "slug" = 'painting' OR "nameAr" = 'دهان' THEN '🎨'
  WHEN "slug" = 'furniture-assembly' OR "nameAr" = 'تركيب أثاث' THEN '🛠️'
  WHEN "slug" = 'home-cleaning' OR "nameAr" = 'تنظيف منزلي' THEN '🧹'
  WHEN "slug" = 'carpet-cleaning' OR "nameAr" = 'تنظيف سجاد' THEN '🧽'
  WHEN "slug" = 'garden-design' OR "nameAr" = 'تنسيق حدائق' THEN '🌿'
  WHEN "slug" = 'lawn-mowing' OR "nameAr" = 'قص عشب' THEN '🌱'
  WHEN "slug" = 'haircut' OR "nameAr" = 'حلاقة' THEN '✂️'
  WHEN "slug" = 'massage' OR "nameAr" = 'مساج' THEN '💆'
  WHEN "slug" = 'other' OR "nameAr" = 'غير ذلك' THEN '⋯'
  ELSE "icon"
END
WHERE "icon" IS NULL;