281 lines
19 KiB
SQL
281 lines
19 KiB
SQL
-- DELETE obsolete redirects in order for this to work properly
|
|
DELETE FROM redirects
|
|
WHERE target_uri IN ('int/returns-refunds', 'us/returns-refunds')
|
|
OR source_uri = 'customer-service';
|
|
|
|
INSERT INTO redirects (source_uri, target_uri, market_locale_id)
|
|
VALUES
|
|
('contact-us', 'customer-service/contact-us', 3),
|
|
('contact-us', 'customer-service/contact-us', 6),
|
|
('contact-us', 'customer-service/contact-us', 10),
|
|
('contact-us', 'customer-service/contact-us', 21),
|
|
('contact-us', 'customer-service/contact-us', 23),
|
|
('contact-us', 'customer-service/contact-us', 24),
|
|
('contact-us', 'customer-service/contact-us', 25),
|
|
('kontakt', 'kundenservice/kontakt', 7),
|
|
('kontakt', 'kundenservice/kontakt', 9),
|
|
('kontakt', 'kundenservice/kontakt', 26),
|
|
('contact', 'klantenservice/contact', 8),
|
|
('contact', 'klantenservice/contact', 16),
|
|
('kontakt', 'obsluga-klienta/kontakt', 13),
|
|
('contacto', 'atencion-al-cliente/contacto', 11),
|
|
('nous-contacter', 'service-client/nous-contacter', 12),
|
|
('nous-contacter', 'service-client/nous-contacter', 15),
|
|
('nous-contacter', 'service-client/nous-contacter', 22),
|
|
('nous-contacter', 'service-client/nous-contacter', 27),
|
|
('kontakta-oss', 'kundservice/kontakta-oss', 1),
|
|
('kontakt-oss', 'kundeservice/kontakt-oss', 2),
|
|
('ota-yhteytta', 'asiakaspalvelu/ota-yhteytta', 5),
|
|
('kontakt-os', 'kundeservice/kontakt-os', 4),
|
|
('contattaci', 'servizio-clienti/contattaci', 14),
|
|
('contattaci', 'servizio-clienti/contattaci', 28),
|
|
('delivery-times-shipping-costs', 'customer-service/delivery-times-shipping-costs', 3),
|
|
('delivery-times-shipping-costs', 'customer-service/delivery-times-shipping-costs', 6),
|
|
('delivery-times-shipping-costs', 'customer-service/delivery-times-shipping-costs', 10),
|
|
('delivery-times-shipping-costs', 'customer-service/delivery-times-shipping-costs', 21),
|
|
('delivery-times-shipping-costs', 'customer-service/delivery-times-shipping-costs', 23),
|
|
('delivery-times-shipping-costs', 'customer-service/delivery-times-shipping-costs', 24),
|
|
('delivery-times-shipping-costs', 'customer-service/delivery-times-shipping-costs', 25),
|
|
('lieferzeit-versandkosten', 'kundenservice/lieferzeit-versandkosten', 7),
|
|
('lieferzeit-versandkosten', 'kundenservice/lieferzeit-versandkosten', 9),
|
|
('lieferzeit-versandkosten', 'kundenservice/lieferzeit-versandkosten', 26),
|
|
('levertijd-verzendkosten', 'klantenservice/levertijd-verzendkosten', 8),
|
|
('levertijd-verzendkosten', 'klantenservice/levertijd-verzendkosten', 16),
|
|
('czas-realizacji-dostawy-koszty-wysylki', 'obsluga-klienta/czas-realizacji-dostawy-koszty-wysylki', 13),
|
|
('plazos-de-entrega-gastos-de-envio', 'atencion-al-cliente/plazos-de-entrega-gastos-de-envio', 11),
|
|
('delais-de-livraison-frais-de-port', 'service-client/delais-de-livraison-frais-de-port', 12),
|
|
('delais-de-livraison-frais-de-port', 'service-client/delais-de-livraison-frais-de-port', 15),
|
|
('delais-de-livraison-frais-de-port', 'service-client/delais-de-livraison-frais-de-port', 22),
|
|
('delais-de-livraison-frais-de-port', 'service-client/delais-de-livraison-frais-de-port', 27),
|
|
('leveranstid-fraktpriser', 'kundservice/leveranstid-fraktpriser', 1),
|
|
('leveringstid-fraktpriser', 'kundeservice/leveringstid-fraktpriser', 2),
|
|
('toimitusaika-toimitushinnat', 'asiakaspalvelu/toimitusaika-toimitushinnat', 5),
|
|
('leveringstid-fragtpriser', 'kundeservice/leveringstid-fragtpriser', 4),
|
|
('tempi-di-consegna-e-spese-di-spedizione', 'servizio-clienti/tempi-di-consegna-e-spese-di-spedizione', 14),
|
|
('tempi-di-consegna-e-spese-di-spedizione', 'servizio-clienti/tempi-di-consegna-e-spese-di-spedizione', 28),
|
|
('ordering-payment-methods', 'customer-service/ordering-payment-methods', 3),
|
|
('ordering-payment-methods', 'customer-service/ordering-payment-methods', 6),
|
|
('ordering-payment-methods', 'customer-service/ordering-payment-methods', 10),
|
|
('ordering-payment-methods', 'customer-service/ordering-payment-methods', 21),
|
|
('ordering-payment-methods', 'customer-service/ordering-payment-methods', 23),
|
|
('ordering-payment-methods', 'customer-service/ordering-payment-methods', 24),
|
|
('ordering-payment-methods', 'customer-service/ordering-payment-methods', 25),
|
|
('bestellung-zahlungsmoglichkeiten', 'kundenservice/bestellung-zahlungsmoglichkeiten', 7),
|
|
('bestellung-zahlungsmoglichkeiten', 'kundenservice/bestellung-zahlungsmoglichkeiten', 9),
|
|
('bestellung-zahlungsmoglichkeiten', 'kundenservice/bestellung-zahlungsmoglichkeiten', 26),
|
|
('bestellen-betaalmethoden', 'klantenservice/bestellen-betaalmethoden', 8),
|
|
('bestellen-betaalmethoden', 'klantenservice/bestellen-betaalmethoden', 16),
|
|
('zamowienia-platnosci', 'obsluga-klienta/zamowienia-platnosci', 13),
|
|
('compra-metodos-de-pago', 'atencion-al-cliente/compra-metodos-de-pago', 11),
|
|
('commande-mode-de-paiement', 'service-client/commande-mode-de-paiement', 12),
|
|
('commande-mode-de-paiement', 'service-client/commande-mode-de-paiement', 15),
|
|
('commande-mode-de-paiement', 'service-client/commande-mode-de-paiement', 22),
|
|
('commande-mode-de-paiement', 'service-client/commande-mode-de-paiement', 27),
|
|
('bestallning-betalsatt', 'kundservice/bestallning-betalsatt', 1),
|
|
('bestilling-betaling', 'kundeservice/bestilling-betaling', 2),
|
|
('tilaaminen-maksutavat', 'asiakaspalvelu/tilaaminen-maksutavat', 5),
|
|
('bestilling-betalingsmetoder', 'kundeservice/bestilling-betalingsmetoder', 4),
|
|
('ordine-pagato', 'servizio-clienti/ordine-pagato', 14),
|
|
('ordine-pagato', 'servizio-clienti/ordine-pagato', 28),
|
|
('our-products', 'customer-service/our-products', 3),
|
|
('our-products', 'customer-service/our-products', 6),
|
|
('our-products', 'customer-service/our-products', 10),
|
|
('our-products', 'customer-service/our-products', 21),
|
|
('our-products', 'customer-service/our-products', 23),
|
|
('our-products', 'customer-service/our-products', 24),
|
|
('our-products', 'customer-service/our-products', 25),
|
|
('unsere-produkte', 'kundenservice/unsere-produkte', 7),
|
|
('unsere-produkte', 'kundenservice/unsere-produkte', 9),
|
|
('unsere-produkte', 'kundenservice/unsere-produkte', 26),
|
|
('onze-producten', 'klantenservice/onze-producten', 8),
|
|
('onze-producten', 'klantenservice/onze-producten', 16),
|
|
('nasze-produkty', 'obsluga-klienta/nasze-produkty', 13),
|
|
('nuestros-productos', 'atencion-al-cliente/nuestros-productos', 11),
|
|
('nos-produits', 'service-client/nos-produits', 12),
|
|
('nos-produits', 'service-client/nos-produits', 15),
|
|
('nos-produits', 'service-client/nos-produits', 22),
|
|
('nos-produits', 'service-client/nos-produits', 27),
|
|
('vara-produkter', 'kundservice/vara-produkter', 1),
|
|
('vare-produkter', 'kundeservice/vare-produkter', 2),
|
|
('tuotteet', 'asiakaspalvelu/tuotteet', 5),
|
|
('vores-produkter', 'kundeservice/vores-produkter', 4),
|
|
('i-nostri-prodotti', 'servizio-clienti/i-nostri-prodotti', 14),
|
|
('i-nostri-prodotti', 'servizio-clienti/i-nostri-prodotti', 28),
|
|
('product-information-wallpaper', 'customer-service/product-information-wallpaper', 3),
|
|
('product-information-wallpaper', 'customer-service/product-information-wallpaper', 6),
|
|
('product-information-wallpaper', 'customer-service/product-information-wallpaper', 10),
|
|
('product-information-wallpaper', 'customer-service/product-information-wallpaper', 21),
|
|
('product-information-wallpaper', 'customer-service/product-information-wallpaper', 23),
|
|
('product-information-wallpaper', 'customer-service/product-information-wallpaper', 24),
|
|
('product-information-wallpaper', 'customer-service/product-information-wallpaper', 25),
|
|
('produktinformationen-tapeten', 'kundenservice/produktinformationen-tapeten', 7),
|
|
('produktinformationen-tapeten', 'kundenservice/produktinformationen-tapeten', 9),
|
|
('produktinformationen-tapeten', 'kundenservice/produktinformationen-tapeten', 26),
|
|
('productomschrijving-behang', 'klantenservice/productomschrijving-behang', 8),
|
|
('productomschrijving-behang', 'klantenservice/productomschrijving-behang', 16),
|
|
('informacja-o-produkcie-tapety', 'obsluga-klienta/informacja-o-produkcie-tapety', 13),
|
|
('producto-informacion-papel-pintado', 'atencion-al-cliente/producto-informacion-papel-pintado', 11),
|
|
('papiers-peints-descriptif-produit', 'service-client/papiers-peints-descriptif-produit', 12),
|
|
('papiers-peints-descriptif-produit', 'service-client/papiers-peints-descriptif-produit', 15),
|
|
('papiers-peints-descriptif-produit', 'service-client/papiers-peints-descriptif-produit', 22),
|
|
('papiers-peints-descriptif-produit', 'service-client/papiers-peints-descriptif-produit', 27),
|
|
('produktinformation-tapeter', 'kundservice/produktinformation-tapeter', 1),
|
|
('produktinformasjon-tapeter', 'kundeservice/produktinformasjon-tapeter', 2),
|
|
('tuotetiedot-tapetit', 'asiakaspalvelu/tuotetiedot-tapetit', 5),
|
|
('produktinformation-tapet', 'kundeservice/produktinformation-tapet', 4),
|
|
('informazioni-sul-prodotto-carte-da-parati', 'servizio-clienti/informazioni-sul-prodotto-carte-da-parati', 14),
|
|
('informazioni-sul-prodotto-carte-da-parati', 'servizio-clienti/informazioni-sul-prodotto-carte-da-parati', 28),
|
|
('product-information-canvas-prints', 'customer-service/product-information-canvas-prints', 3),
|
|
('product-information-canvas-prints', 'customer-service/product-information-canvas-prints', 6),
|
|
('product-information-canvas-prints', 'customer-service/product-information-canvas-prints', 10),
|
|
('product-information-canvas-prints', 'customer-service/product-information-canvas-prints', 21),
|
|
('product-information-canvas-prints', 'customer-service/product-information-canvas-prints', 23),
|
|
('product-information-canvas-prints', 'customer-service/product-information-canvas-prints', 24),
|
|
('product-information-canvas-prints', 'customer-service/product-information-canvas-prints', 25),
|
|
('produktinformationen-leinwandbilder', 'kundenservice/produktinformationen-leinwandbilder', 7),
|
|
('produktinformationen-leinwandbilder', 'kundenservice/produktinformationen-leinwandbilder', 9),
|
|
('produktinformationen-leinwandbilder', 'kundenservice/produktinformationen-leinwandbilder', 26),
|
|
('productomschrijving-canvas', 'klantenservice/productomschrijving-canvas', 8),
|
|
('productomschrijving-canvas', 'klantenservice/productomschrijving-canvas', 16),
|
|
('informacja-o-produkcie-obrazy-na-plotnie', 'obsluga-klienta/informacja-o-produkcie-obrazy-na-plotnie', 13),
|
|
('producto-informacion-lienzos', 'atencion-al-cliente/producto-informacion-lienzos', 11),
|
|
('descriptif-produit-impressions-sur-toile', 'service-client/descriptif-produit-impressions-sur-toile', 12),
|
|
('descriptif-produit-impressions-sur-toile', 'service-client/descriptif-produit-impressions-sur-toile', 15),
|
|
('descriptif-produit-impressions-sur-toile', 'service-client/descriptif-produit-impressions-sur-toile', 22),
|
|
('descriptif-produit-impressions-sur-toile', 'service-client/descriptif-produit-impressions-sur-toile', 27),
|
|
('produktinformation-canvastavlor', 'kundservice/produktinformation-canvastavlor', 1),
|
|
('produktinformasjon-lerretsbilder', 'kundeservice/produktinformasjon-lerretsbilder', 2),
|
|
('tuotetiedot-canvastaulu', 'asiakaspalvelu/tuotetiedot-canvastaulu', 5),
|
|
('produktinformation-billeder-pa-laerred', 'kundeservice/produktinformation-billeder-pa-laerred', 4),
|
|
('informazioni-sul-prodotto-stampe-su-tela', 'servizio-clienti/informazioni-sul-prodotto-stampe-su-tela', 14),
|
|
('informazioni-sul-prodotto-stampe-su-tela', 'servizio-clienti/informazioni-sul-prodotto-stampe-su-tela', 28),
|
|
('product-information-posters', 'customer-service/product-information-posters', 3),
|
|
('product-information-posters', 'customer-service/product-information-posters', 6),
|
|
('product-information-posters', 'customer-service/product-information-posters', 10),
|
|
('product-information-posters', 'customer-service/product-information-posters', 21),
|
|
('product-information-posters', 'customer-service/product-information-posters', 23),
|
|
('product-information-posters', 'customer-service/product-information-posters', 24),
|
|
('product-information-posters', 'customer-service/product-information-posters', 25),
|
|
('produktinformationen-poster', 'kundenservice/produktinformationen-poster', 7),
|
|
('produktinformationen-poster', 'kundenservice/produktinformationen-poster', 9),
|
|
('produktinformationen-poster', 'kundenservice/produktinformationen-poster', 26),
|
|
('productomschrijving-posters', 'klantenservice/productomschrijving-posters', 8),
|
|
('productomschrijving-posters', 'klantenservice/productomschrijving-posters', 16),
|
|
('informacja-o-produkcie-plakaty', 'obsluga-klienta/informacja-o-produkcie-plakaty', 13),
|
|
('producto-informacion-posters', 'atencion-al-cliente/producto-informacion-posters', 11),
|
|
('descriptif-produit-affiches', 'service-client/descriptif-produit-affiches', 12),
|
|
('descriptif-produit-affiches', 'service-client/descriptif-produit-affiches', 15),
|
|
('descriptif-produit-affiches', 'service-client/descriptif-produit-affiches', 22),
|
|
('descriptif-produit-affiches', 'service-client/descriptif-produit-affiches', 27),
|
|
('produktinformation-posters', 'kundservice/produktinformation-posters', 1),
|
|
('produktinformasjon-plakater', 'kundeservice/produktinformasjon-plakater', 2),
|
|
('tuotetiedot-julisteet', 'asiakaspalvelu/tuotetiedot-julisteet', 5),
|
|
('produktinformation-plakater', 'kundeservice/produktinformation-plakater', 4),
|
|
('informazioni-sul-prodotto-poster', 'servizio-clienti/informazioni-sul-prodotto-poster', 14),
|
|
('informazioni-sul-prodotto-poster', 'servizio-clienti/informazioni-sul-prodotto-poster', 28),
|
|
('returns', 'customer-service/returns', 3),
|
|
('returns', 'customer-service/returns', 6),
|
|
('returns', 'customer-service/returns', 10),
|
|
('returns', 'customer-service/returns', 21),
|
|
('returns', 'customer-service/returns', 23),
|
|
('returns', 'customer-service/returns', 24),
|
|
('returns', 'customer-service/returns', 25),
|
|
('reklamation', 'kundenservice/reklamation', 7),
|
|
('reklamation', 'kundenservice/reklamation', 9),
|
|
('reklamation', 'kundenservice/reklamation', 26),
|
|
('klachten', 'klantenservice/klachten', 8),
|
|
('klachten', 'klantenservice/klachten', 16),
|
|
('reklamacje', 'obsluga-klienta/reklamacje', 13),
|
|
('reclamaciones', 'atencion-al-cliente/reclamaciones', 11),
|
|
('reclamation', 'service-client/reclamation', 12),
|
|
('reclamation', 'service-client/reclamation', 15),
|
|
('reclamation', 'service-client/reclamation', 22),
|
|
('reclamation', 'service-client/reclamation', 27),
|
|
('reklamation', 'kundservice/reklamation', 1),
|
|
('reklamasjon', 'kundeservice/reklamasjon', 2),
|
|
('reklamaatio', 'asiakaspalvelu/reklamaatio', 5),
|
|
('reklamation', 'kundeservice/reklamation', 4),
|
|
('reclami', 'servizio-clienti/reclami', 14),
|
|
('reclami', 'servizio-clienti/reclami', 28),
|
|
('returns-refunds', 'customer-service/returns-refunds', 3),
|
|
('returns-refunds', 'customer-service/returns-refunds', 6),
|
|
('returns-refunds', 'customer-service/returns-refunds', 10),
|
|
('returns-refunds', 'customer-service/returns-refunds', 21),
|
|
('returns-refunds', 'customer-service/returns-refunds', 23),
|
|
('returns-refunds', 'customer-service/returns-refunds', 24),
|
|
('returns-refunds', 'customer-service/returns-refunds', 25),
|
|
('ruckgabe-widerrufsrecht', 'kundenservice/ruckgabe-widerrufsrecht', 7),
|
|
('ruckgabe-widerrufsrecht', 'kundenservice/ruckgabe-widerrufsrecht', 9),
|
|
('ruckgabe-widerrufsrecht', 'kundenservice/ruckgabe-widerrufsrecht', 26),
|
|
('retourneren', 'klantenservice/retourneren', 8),
|
|
('retourneren', 'klantenservice/retourneren', 16),
|
|
('zwroty-prawo-odstapienia-od-umowy', 'obsluga-klienta/zwroty-prawo-odstapienia-od-umowy', 13),
|
|
('devolucion-reembolso', 'atencion-al-cliente/devolucion-reembolso', 11),
|
|
('retour-remboursement', 'service-client/retour-remboursement', 12),
|
|
('retour-remboursement', 'service-client/retour-remboursement', 15),
|
|
('retour-remboursement', 'service-client/retour-remboursement', 22),
|
|
('retour-remboursement', 'service-client/retour-remboursement', 27),
|
|
('retur-angerratt', 'kundservice/retur-angerratt', 1),
|
|
('retur-angrerett', 'kundeservice/retur-angrerett', 2),
|
|
('palautukset-palautusoikeus', 'asiakaspalvelu/palautukset-palautusoikeus', 5),
|
|
('returnering-fortrydelsesret', 'kundeservice/returnering-fortrydelsesret', 4),
|
|
('diritto-di-reso', 'servizio-clienti/diritto-di-reso', 14),
|
|
('diritto-di-reso', 'servizio-clienti/diritto-di-reso', 28),
|
|
('satisfaction-guarantee', 'customer-service/satisfaction-guarantee', 3),
|
|
('satisfaction-guarantee', 'customer-service/satisfaction-guarantee', 6),
|
|
('satisfaction-guarantee', 'customer-service/satisfaction-guarantee', 10),
|
|
('satisfaction-guarantee', 'customer-service/satisfaction-guarantee', 21),
|
|
('satisfaction-guarantee', 'customer-service/satisfaction-guarantee', 23),
|
|
('satisfaction-guarantee', 'customer-service/satisfaction-guarantee', 24),
|
|
('satisfaction-guarantee', 'customer-service/satisfaction-guarantee', 25),
|
|
('zufriedenheitsgarantie', 'kundenservice/zufriedenheitsgarantie', 7),
|
|
('zufriedenheitsgarantie', 'kundenservice/zufriedenheitsgarantie', 9),
|
|
('zufriedenheitsgarantie', 'kundenservice/zufriedenheitsgarantie', 26),
|
|
('tevredenheidsgarantie', 'klantenservice/tevredenheidsgarantie', 8),
|
|
('tevredenheidsgarantie', 'klantenservice/tevredenheidsgarantie', 16),
|
|
('gwarancja-satysfakcji-klienta', 'obsluga-klienta/gwarancja-satysfakcji-klienta', 13),
|
|
('garantia-de-satisfaccion', 'atencion-al-cliente/garantia-de-satisfaccion', 11),
|
|
('satisfaction-garantie', 'service-client/satisfaction-garantie', 12),
|
|
('satisfaction-garantie', 'service-client/satisfaction-garantie', 15),
|
|
('satisfaction-garantie', 'service-client/satisfaction-garantie', 22),
|
|
('satisfaction-garantie', 'service-client/satisfaction-garantie', 27),
|
|
('nojd-kund-garanti', 'kundservice/nojd-kund-garanti', 1),
|
|
('fornoyd-kunde-garanti', 'kundeservice/fornoyd-kunde-garanti', 2),
|
|
('tyytyvaisyystakuu', 'asiakaspalvelu/tyytyvaisyystakuu', 5),
|
|
('kundetilfredshedsgaranti', 'kundeservice/kundetilfredshedsgaranti', 4),
|
|
('garanzia-cliente-soddisfatto', 'servizio-clienti/garanzia-cliente-soddisfatto', 14),
|
|
('garanzia-cliente-soddisfatto', 'servizio-clienti/garanzia-cliente-soddisfatto', 28),
|
|
('kundservice', 'kundservice/kontakta-oss', 1),
|
|
('customer-service', 'customer-service/contact-us', 3),
|
|
('customer-service', 'customer-service/contact-us', 6),
|
|
('customer-service', 'customer-service/contact-us', 10),
|
|
('customer-service', 'customer-service/contact-us', 21),
|
|
('customer-service', 'customer-service/contact-us', 23),
|
|
('customer-service', 'customer-service/contact-us', 24),
|
|
('customer-service', 'customer-service/contact-us', 25),
|
|
('kundenservice', 'kundenservice/kontakt', 7),
|
|
('kundenservice', 'kundenservice/kontakt', 9),
|
|
('kundenservice', 'kundenservice/kontakt', 26),
|
|
('klantenservice', 'klantenservice/contact', 8),
|
|
('klantenservice', 'klantenservice/contact', 16),
|
|
('obsluga-klienta', 'obsluga-klienta/kontakt', 13),
|
|
('atencion-al-cliente', 'atencion-al-cliente/contacto', 11),
|
|
('service-client', 'service-client/nous-contacter', 12),
|
|
('service-client', 'service-client/nous-contacter', 15),
|
|
('service-client', 'service-client/nous-contacter', 22),
|
|
('service-client', 'service-client/nous-contacter', 27),
|
|
('kundeservice', 'kundeservice/kontakt-oss', 2),
|
|
('asiakaspalvelu', 'asiakaspalvelu/ota-yhteytta', 5),
|
|
('kundeservice', 'kundeservice/kontakt-os', 4),
|
|
('servizio-clienti', 'servizio-clienti/contattaci', 14),
|
|
('servizio-clienti', 'servizio-clienti/contattaci', 28)
|
|
ON CONFLICT DO NOTHING;
|
|
|
|
|
|
-- Replace any text tag placeholders that have been renamed.
|
|
update "i18n-texts_data" set text = replace(text, '{route:contact-us}', '{route:customer-service/contact-us}') where text ilike '%{route:contact-us}%';
|
|
update "i18n-texts_data" set text = replace(text, '{route:ordering-payment-methods}', '{route:customer-service/ordering-payment-methods}') where text ilike '%{route:ordering-payment-methods}%';
|
|
-- For reference, found like this:
|
|
-- I matched all text tags with routes placeholders: select text "i18n-texts_data" where text ilike '%{route:%'
|
|
-- I grepped out the individual routes used: {route:designers}, {route:confidentiality}, {route:contact-us}, {route:magazine}, {route:ordering-payment-methods}, {route:press-room}
|