-- Add translated slug columns to service_categories
ALTER TABLE service_categories
ADD COLUMN slug_ru VARCHAR(100) NULL AFTER slug,
ADD COLUMN slug_en VARCHAR(100) NULL AFTER slug_ru;

-- Populate Russian slugs (transliterated from name_ru)
UPDATE service_categories SET slug_ru = 'polirovka-kuzova' WHERE slug = 'auto-polesana';
UPDATE service_categories SET slug_ru = 'polirovka-far' WHERE slug = 'lukturu-polesana';
UPDATE service_categories SET slug_ru = 'khimchistka-salona' WHERE slug = 'kimiska-tirisana';
UPDATE service_categories SET slug_ru = 'okleyka-vinilom' WHERE slug = 'vinila-aplimesana';
UPDATE service_categories SET slug_ru = 'ppf-zaschitnaya-plyonka' WHERE slug = 'ppf-aizsargpleve';
UPDATE service_categories SET slug_ru = 'keramicheskoe-pokrytie' WHERE slug = 'keramiskais-parklajums';
UPDATE service_categories SET slug_ru = 'tonirovka-stekol' WHERE slug = 'tonesana';
UPDATE service_categories SET slug_ru = 'deteyling-moyka' WHERE slug = 'diteilinga-mazgasana';
UPDATE service_categories SET slug_ru = 'udalenie-vmyatin' WHERE slug = 'iespiedumu-labosana';
UPDATE service_categories SET slug_ru = 'remont-kozhi' WHERE slug = 'adas-remonts';
UPDATE service_categories SET slug_ru = 'restayling-avto' WHERE slug = 'auto-restilizacija';
UPDATE service_categories SET slug_ru = 'zaschitnye-pokrytiya' WHERE slug = 'aizsardzibas-parklajumi';

-- Populate English slugs
UPDATE service_categories SET slug_en = 'paint-polishing' WHERE slug = 'auto-polesana';
UPDATE service_categories SET slug_en = 'headlight-polishing' WHERE slug = 'lukturu-polesana';
UPDATE service_categories SET slug_en = 'interior-chemical-cleaning' WHERE slug = 'kimiska-tirisana';
UPDATE service_categories SET slug_en = 'vinyl-wrapping' WHERE slug = 'vinila-aplimesana';
UPDATE service_categories SET slug_en = 'ppf-paint-protection-film' WHERE slug = 'ppf-aizsargpleve';
UPDATE service_categories SET slug_en = 'ceramic-coating' WHERE slug = 'keramiskais-parklajums';
UPDATE service_categories SET slug_en = 'window-tinting' WHERE slug = 'tonesana';
UPDATE service_categories SET slug_en = 'detailing-wash' WHERE slug = 'diteilinga-mazgasana';
UPDATE service_categories SET slug_en = 'paintless-dent-repair' WHERE slug = 'iespiedumu-labosana';
UPDATE service_categories SET slug_en = 'leather-repair' WHERE slug = 'adas-remonts';
UPDATE service_categories SET slug_en = 'car-restyling' WHERE slug = 'auto-restilizacija';
UPDATE service_categories SET slug_en = 'protective-coatings' WHERE slug = 'aizsardzibas-parklajumi';
