40 lines
1.5 KiB
SQL
40 lines
1.5 KiB
SQL
-- P5-6333: move text tags to shop category
|
|
|
|
|
|
--delete some duplicated texts
|
|
|
|
delete from "i18n-texts_data" where textid in (
|
|
(select textid from "i18n-texts" where name = 'total' and category = 'checkout2'),
|
|
(select textid from "i18n-texts" where name = 'total' and category = 'global'),
|
|
(select textid from "i18n-texts" where name = 'company' and category = 'checkout2'), --not same
|
|
(select textid from "i18n-texts" where name = 'price' and category = 'global'),
|
|
(select textid from "i18n-texts" where name = 'size' and category = 'global'), --not same
|
|
(select textid from "i18n-texts" where name = 'email' and category = 'global')
|
|
);
|
|
|
|
|
|
delete from "i18n-texts" where textid in (
|
|
(select textid from "i18n-texts" where name = 'total' and category = 'checkout2'),
|
|
(select textid from "i18n-texts" where name = 'total' and category = 'global'),
|
|
(select textid from "i18n-texts" where name = 'company' and category = 'checkout2'), --not same
|
|
(select textid from "i18n-texts" where name = 'price' and category = 'global'),
|
|
(select textid from "i18n-texts" where name = 'size' and category = 'global'), --not same
|
|
(select textid from "i18n-texts" where name = 'email' and category = 'global')
|
|
);
|
|
|
|
|
|
-- change category to shop
|
|
update "i18n-texts" set category = 'shop' where category in (
|
|
'custom',
|
|
'messages',
|
|
'inquiries',
|
|
'global',
|
|
'products',
|
|
'checkout',
|
|
'checkout2',
|
|
'checkout2/deliveryMethods',
|
|
'checkout/step1',
|
|
'checkout/step3',
|
|
'checkout/receipt'
|
|
);
|