-- Update studios with Google Place IDs, social media links, and GMB profiles
-- Run after migration 008_add_google_place_id.sql

-- 1. Troks Detailing Auto pulēšana
UPDATE studios SET
  google_place_id = 'ChIJVb-o4wPP7kYRqzAqM91QABE'
WHERE name LIKE '%Troks%Detailing%';

-- 2. AZ DETAIL
UPDATE studios SET
  google_place_id = 'ChIJC4jBOgDb7kYRAN0GZkoKtHk',
  google_profile  = 'https://maps.app.goo.gl/9EoeQ42ZUTBeTXp76',
  instagram       = 'https://www.instagram.com/azdetail_lv/'
WHERE name LIKE '%AZ DETAIL%';

-- 3. Level888
UPDATE studios SET
  google_place_id = 'ChIJKcnq4-LP7kYRj7gSTq3L0tg',
  google_profile  = 'https://maps.app.goo.gl/LwaqosCZsZuUvjLJ6',
  instagram       = 'https://www.instagram.com/level888.lv/',
  facebook        = 'https://www.facebook.com/p/Level888-61570258933703/'
WHERE name LIKE '%Level888%';

-- 4. EA WRAP WORKS
UPDATE studios SET
  google_place_id = 'ChIJ_SGOKH7P7kYRd9rBpETWFR8',
  google_profile  = 'https://maps.app.goo.gl/pKqSF9c8yFmF6wge9',
  tiktok          = 'https://www.tiktok.com/discover/ea-wrap-works'
WHERE name LIKE '%EA WRAP%';

-- 5. polirovka.lv
UPDATE studios SET
  google_place_id = 'ChIJJRL38PrN7kYRLkGqujwfRQA',
  google_profile  = 'https://maps.app.goo.gl/iyHvmN8UDyfA7q2MA',
  facebook        = 'https://www.facebook.com/polirovka.lv/'
WHERE name LIKE '%polirovka%';

-- 6. Gold Group
UPDATE studios SET
  google_place_id = 'ChIJWafMjtfP7kYRwdKIb-ibZaY',
  google_profile  = 'https://maps.app.goo.gl/hhvk5y7LenSDsGzz7',
  facebook        = 'https://www.facebook.com/Goldgroup.lv/'
WHERE name LIKE '%Gold Group%';

-- 7. Riga Car Detailing
UPDATE studios SET
  google_place_id = 'ChIJ8dHJagz0h2AR7lmJtQGOiAA',
  google_profile  = 'https://maps.app.goo.gl/ipRwiV834id5iszbA',
  instagram       = 'https://www.instagram.com/riga_car_detailing/'
WHERE name LIKE '%Riga Car Detailing%';

-- 8. Chromiq Riga Detail
UPDATE studios SET
  google_place_id = 'ChIJO0JVEXJoHKoREbD-p8CSU1Y',
  google_profile  = 'https://maps.app.goo.gl/khpSbPUL2ScxJib78',
  instagram       = 'https://www.instagram.com/chromiq_/',
  facebook        = 'https://www.facebook.com/100093615580024/'
WHERE name LIKE '%Chromiq%';

-- 9. NFD detailing studio
UPDATE studios SET
  google_place_id = 'ChIJJUcVLJbP7kYR3UWZy29tXMA',
  google_profile  = 'https://maps.app.goo.gl/ikWb1XKL6hK3ByTGA',
  facebook        = 'https://www.facebook.com/p/NFD-Detailing-studio-100085904742003/',
  instagram       = 'https://www.instagram.com/nfd_studio.lv/'
WHERE name LIKE '%NFD%';

-- 10. Vinylworks
UPDATE studios SET
  google_place_id = 'ChIJdW_1qITP7kYRrFebJCDmAUk',
  google_profile  = 'https://maps.app.goo.gl/nCowMYahtWPeF2NK7',
  facebook        = 'https://www.facebook.com/vinylworks.lv/',
  instagram       = 'https://www.instagram.com/vinylworks.lv/'
WHERE name LIKE '%Vinylworks%';

-- 11. Greenline Auto
UPDATE studios SET
  google_place_id = 'ChIJv_AVqMrP7kYRDjnFv6xX6t8',
  google_profile  = 'https://maps.app.goo.gl/muuYXTkAYz4yD4ACA',
  instagram       = 'https://www.instagram.com/auto365.lv/',
  facebook        = 'https://www.facebook.com/auto365lv',
  youtube         = 'https://www.youtube.com/@Auto365Lv'
WHERE name LIKE '%Greenline%';

-- 12. Baltic Detailing
UPDATE studios SET
  google_place_id = 'ChIJ4yH7EWTO7kYR2CA1m-FZW6s',
  google_profile  = 'https://maps.app.goo.gl/FTSH5K3EGGV3k4Jn6',
  youtube         = 'https://www.youtube.com/@balticdetailing8830',
  instagram       = 'https://www.instagram.com/baltic_detailing/',
  facebook        = 'https://www.facebook.com/balticdetailing'
WHERE name LIKE '%Baltic Detailing%';

-- 13. Caroscar.lv
UPDATE studios SET
  google_place_id = 'ChIJJVVGvG3P7kYRdD_xh4Q20-E',
  google_profile  = 'https://maps.app.goo.gl/beVsZEPMxEuV1zTN8',
  instagram       = 'https://www.instagram.com/caroscar.lv/',
  youtube         = 'https://www.youtube.com/@CAROSCARLV',
  facebook        = 'https://www.facebook.com/caroscar.lv'
WHERE name LIKE '%Caroscar%';

-- 14. AUTO ĶĪMISKĀ TĪRĪTAVA
UPDATE studios SET
  google_place_id = 'ChIJxQJxk0vP7kYRuSQopAZTdsI',
  google_profile  = 'https://maps.app.goo.gl/bUtgztaAf8WuoMYX6'
WHERE name LIKE '%ĶĪMISKĀ TĪRĪTAVA%';

-- 15. DeCar Detailing
UPDATE studios SET
  google_place_id = 'ChIJW4op9jrP7kYRySXf4Dms6L0',
  google_profile  = 'https://maps.app.goo.gl/5zZck8F4CPt8pDxp6',
  instagram       = 'https://www.instagram.com/decar_detailing/',
  facebook        = 'https://www.facebook.com/DeCarDetailing/',
  youtube         = 'https://www.youtube.com/@decardetailing'
WHERE name LIKE '%DeCar%';

-- 16. TonAuto
UPDATE studios SET
  google_place_id = 'ChIJX9MDKtbP7kYRjaKjj7Jg3xc',
  google_profile  = 'https://maps.app.goo.gl/mHFReGSQ9s5e4wTY6',
  instagram       = 'https://www.instagram.com/tonauto.lv/',
  tiktok          = 'https://www.tiktok.com/@tonauto.lv',
  facebook        = 'https://www.facebook.com/www.autotonesana.lv/'
WHERE name LIKE '%TonAuto%';

-- 17. AUTOESTETIKA
UPDATE studios SET
  google_place_id = 'ChIJZc1LsgnQ7kYRjqIscCkMLV0',
  google_profile  = 'https://maps.app.goo.gl/DH4XBzf3KMXzwteh7',
  facebook        = 'https://www.facebook.com/autoestetika.lv',
  instagram       = 'https://www.instagram.com/autoestetika/',
  tiktok          = 'https://www.tiktok.com/@autoestetika'
WHERE name LIKE '%AUTOESTETIKA%';

-- 18. Restyling Workshop Rīga
UPDATE studios SET
  google_place_id = 'ChIJe4wOUvDb7kYRgNkEUJYuB7o',
  google_profile  = 'https://maps.app.goo.gl/8iJaowQzDpwn8HDC6',
  tiktok          = 'https://www.tiktok.com/@restyling.eu',
  instagram       = 'https://www.instagram.com/restyling.eu/',
  facebook        = 'https://www.facebook.com/Restyling.eu/'
WHERE name LIKE '%Restyling%Workshop%';

-- 19. Riga Customs
UPDATE studios SET
  google_place_id = 'ChIJ-eWyaw3S7kYRCXqbbPXHBWQ',
  facebook        = 'https://www.facebook.com/rigacustoms',
  youtube         = 'https://www.youtube.com/@rigacustoms',
  instagram       = 'https://www.instagram.com/rigacustoms/'
WHERE name LIKE '%Riga Customs%';

-- 20. BOLD Car Works Riga
UPDATE studios SET
  google_place_id = 'ChIJJ7jt_3zR7kYRd2VdS4MK2L8',
  google_profile  = 'https://maps.app.goo.gl/rRUHLjyyfUfLKLLV9',
  tiktok          = 'https://www.tiktok.com/@boldcarworksriga',
  facebook        = 'https://www.facebook.com/Boldcarworks',
  instagram       = 'https://www.instagram.com/boldcarworksriga/'
WHERE name LIKE '%BOLD%Car%';

-- 21. Paint Protect
UPDATE studios SET
  google_place_id = 'ChIJLQKENpLP7kYRVWEr_dXf1_I',
  google_profile  = 'https://maps.app.goo.gl/kerCMi6gnKt2gF2m6',
  instagram       = 'https://www.instagram.com/paintprotectlv/',
  facebook        = 'https://www.facebook.com/paintprotectlv'
WHERE name LIKE '%Paint Protect%';

-- 22. CeramicPro Latvia / Carwash Granta
UPDATE studios SET
  google_place_id = 'ChIJbdv1zbjc7kYRIOy5dcgCgA8',
  google_profile  = 'https://maps.app.goo.gl/8PJyuXSNu3p7y28U6',
  tiktok          = 'https://www.tiktok.com/@ceramicprolv1',
  instagram       = 'https://www.instagram.com/ceramicprolatvia/',
  youtube         = 'https://www.youtube.com/c/CeramicProLatvia',
  facebook        = 'https://www.facebook.com/CeramicProLatvia'
WHERE name LIKE '%CeramicPro%' OR name LIKE '%Carwash Granta%';

-- 23. AUTOTONĒŠANA
UPDATE studios SET
  google_place_id = 'ChIJcSFHDcrN7kYRwRPoov0CYi4',
  google_profile  = 'https://maps.app.goo.gl/d7CNtRWyvVA9JVEM9',
  facebook        = 'https://www.facebook.com/www.autotonesana.lv',
  instagram       = 'https://www.instagram.com/autotonesana.lv_tint_service/',
  tiktok          = 'https://www.tiktok.com/@www.autologutonesana.lv',
  twitter         = 'https://x.com/autotonesana_lv'
WHERE name LIKE '%AUTOTONĒŠANA%' OR name LIKE '%AUTOTONESANA%';

-- 24. Green Clean
UPDATE studios SET
  google_place_id = 'ChIJ2afeGgPP7kYRRLbxFH8Qeq0',
  google_profile  = 'https://maps.app.goo.gl/P8vexkr3JMhYfACR8',
  tiktok          = 'https://www.tiktok.com/@greenclean.lv',
  instagram       = 'https://www.instagram.com/greenclean.lv/',
  facebook        = 'https://www.facebook.com/greencleanlatvia/'
WHERE name LIKE '%Green Clean%';

-- 25. NEMO WASH
UPDATE studios SET
  google_place_id = 'ChIJoYmEey7O7kYRr_NPmZKXpQE',
  google_profile  = 'https://maps.app.goo.gl/9EzcvZP5NYy3m1tZ9',
  facebook        = 'https://www.facebook.com/NemoWashRiga/',
  instagram       = 'https://www.instagram.com/nemo_wash'
WHERE name LIKE '%NEMO%WASH%';
