93 lines
1.9 KiB
SQL
93 lines
1.9 KiB
SQL
-- P5-6870: Create canada category texts
|
|
|
|
|
|
-- en_CA
|
|
|
|
delete from category_texts where locale_id = (select id from locales where value = 'en_CA');
|
|
|
|
INSERT INTO category_texts (
|
|
locale_id,
|
|
category_id,
|
|
wallpaper_name,
|
|
wallpaper_h1,
|
|
wallpaper_description,
|
|
canvas_name,
|
|
canvas_h1,
|
|
canvas_description,
|
|
name,
|
|
design_wallpaper_h1,
|
|
design_wallpaper_description,
|
|
poster_name,
|
|
poster_h1,
|
|
poster_description,
|
|
framed_print_name,
|
|
framed_print_h1,
|
|
framed_print_description
|
|
)
|
|
SELECT
|
|
(SELECT id FROM locales WHERE value = 'en_CA'),
|
|
category_id,
|
|
wallpaper_name,
|
|
wallpaper_h1,
|
|
wallpaper_description,
|
|
canvas_name,
|
|
canvas_h1,
|
|
canvas_description,
|
|
name,
|
|
design_wallpaper_h1,
|
|
design_wallpaper_description,
|
|
poster_name,
|
|
poster_h1,
|
|
poster_description,
|
|
framed_print_name,
|
|
framed_print_h1,
|
|
framed_print_description
|
|
FROM category_texts
|
|
WHERE locale_id = (SELECT id FROM locales WHERE value = 'en_US');
|
|
|
|
|
|
|
|
-- fr_CA
|
|
|
|
delete from category_texts where locale_id = (select id from locales where value = 'fr_CA');
|
|
|
|
INSERT INTO category_texts (
|
|
locale_id,
|
|
category_id,
|
|
wallpaper_name,
|
|
wallpaper_h1,
|
|
wallpaper_description,
|
|
canvas_name,
|
|
canvas_h1,
|
|
canvas_description,
|
|
name,
|
|
design_wallpaper_h1,
|
|
design_wallpaper_description,
|
|
poster_name,
|
|
poster_h1,
|
|
poster_description,
|
|
framed_print_name,
|
|
framed_print_h1,
|
|
framed_print_description
|
|
)
|
|
SELECT
|
|
(SELECT id FROM locales WHERE value = 'fr_CA'),
|
|
category_id,
|
|
wallpaper_name,
|
|
wallpaper_h1,
|
|
wallpaper_description,
|
|
canvas_name,
|
|
canvas_h1,
|
|
canvas_description,
|
|
name,
|
|
design_wallpaper_h1,
|
|
design_wallpaper_description,
|
|
poster_name,
|
|
poster_h1,
|
|
poster_description,
|
|
framed_print_name,
|
|
framed_print_h1,
|
|
framed_print_description
|
|
FROM category_texts
|
|
WHERE locale_id = (SELECT id FROM locales WHERE value = 'fr_FR');
|