9f9008bb6e
* Update pouponnière French category texts * Merge Chambre bébé migrations and add v_esales_categorytree_i18n refresh * Insert redirects * Rewrite redirect paths for non-french-french market_locale_id * Fix merge conflicts * Rename to right numbers --------- Co-authored-by: Rikard Bartholf <rikard@bartholf.nu>
47 lines
1.8 KiB
SQL
47 lines
1.8 KiB
SQL
UPDATE public.category_texts
|
|
SET
|
|
wallpaper_name = 'Chambre bébé',
|
|
wallpaper_h1 = 'Chambre bébé',
|
|
canvas_name = 'Chambre bébé',
|
|
canvas_h1 = 'Chambre bébé',
|
|
name = 'Chambre bébé',
|
|
design_wallpaper_h1 = 'Chambre bébé',
|
|
poster_name = 'Chambre bébé',
|
|
poster_h1 = 'Chambre bébé',
|
|
framed_print_name = 'Chambre bébé',
|
|
framed_print_h1 = 'Chambre bébé'
|
|
WHERE category_id IN (272, 1285)
|
|
AND locale_id IN (16, 21, 13, 29, 33);
|
|
|
|
UPDATE public.category_texts
|
|
SET
|
|
wallpaper_name = 'Chambre enfant',
|
|
wallpaper_h1 = 'Chambre enfant',
|
|
canvas_name = 'Chambre enfant',
|
|
canvas_h1 = 'Chambre enfant',
|
|
name = 'Chambre enfant',
|
|
design_wallpaper_h1 = 'Chambre enfant',
|
|
poster_name = 'Chambre enfant',
|
|
poster_h1 = 'Chambre enfant',
|
|
framed_print_name = 'Chambre enfant',
|
|
framed_print_h1 = 'Chambre enfant'
|
|
WHERE category_id IN (275)
|
|
AND locale_id IN (16, 21, 13, 29, 33);
|
|
|
|
UPDATE public.category_texts
|
|
SET
|
|
wallpaper_name = 'Chambre ado',
|
|
wallpaper_h1 = 'Chambre ado',
|
|
canvas_name = 'Chambre ado',
|
|
canvas_h1 = 'Chambre ado',
|
|
name = 'Chambre ado',
|
|
design_wallpaper_h1 = 'Chambre ado',
|
|
poster_name = 'Chambre ado',
|
|
poster_h1 = 'Chambre ado',
|
|
framed_print_name = 'Chambre ado',
|
|
framed_print_h1 = 'Chambre ado'
|
|
WHERE category_id IN (1770)
|
|
AND locale_id IN (16, 21, 13, 29, 33);
|
|
|
|
REFRESH MATERIALIZED VIEW v_esales_categorytree_i18n;
|