Все столбцы и таблица добавлены только для SEO
-- Добавлен столбец для устранения дублей (товару можно задать основную категорию)
ALTER TABLE oc_product_to_category ADD main_category TINYINT(1) NOT NULL DEFAULT '0';
-- Категориям добавлены Title и H1
ALTER TABLE oc_category_description ADD seo_title VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER meta_keyword;
ALTER TABLE oc_category_description ADD seo_h1 VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER seo_title;
-- Товарам добавлены Title и H1
ALTER TABLE oc_product_description ADD seo_title VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER meta_keyword;
ALTER TABLE oc_product_description ADD seo_h1 VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER seo_title;
-- Статьям добавлены Meta Description, Meta Keywords, Title и H1
ALTER TABLE oc_information_description ADD meta_description VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER description;
ALTER TABLE oc_information_description ADD meta_keyword VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER meta_description;
ALTER TABLE oc_information_description ADD seo_title VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER meta_keyword;
ALTER TABLE oc_information_description ADD seo_h1 VARCHAR(255) NOT NULL COLLATE utf8_general_ci AFTER seo_title;
-- Производителям добавлены Description, Meta Description, Meta Keywords, Title и H1
CREATE TABLE IF NOT EXISTS oc_manufacturer_description (
manufacturer_id INT(11) NOT NULL,
language_id INT(11) NOT NULL,
description TEXT NOT NULL COLLATE utf8_general_ci,
meta_description VARCHAR(255) NOT NULL COLLATE utf8_general_ci,
meta_keyword VARCHAR(255) NOT NULL COLLATE utf8_general_ci,
seo_title VARCHAR(255) NOT NULL COLLATE utf8_general_ci,
seo_h1 VARCHAR(255) NOT NULL COLLATE utf8_general_ci,
PRIMARY KEY (manufacturer_id, language_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
Кроме этого используется сравнение utf8_general_ci, а не utf8_bin