1.0.7.0.sql

一、修改产品详细页面的附件块 二、添加上浏览历史模块 三、在后台加入自定义首页、自定义页头、自定义页脚内容功能 四、在后台修改网站全局CSS样式文件功能 五、在后台修改每个模块的模板内容功能

/* PHP */
/* PHP:AttributeGroup::cleanDeadCombinations(); */;

/* STRUCTURE */
SET NAMES 'utf8';

/*  CONTENTS */

INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
('LOGO_IMG_NAME', 'logo.png', NOW(), NOW());

DELETE FROM `PREFIX_access` WHERE `id_access` = 4 LIMIT 1;
DELETE FROM `PREFIX_access` WHERE `id_access` = 5 LIMIT 1;
DELETE FROM `PREFIX_product_lang` WHERE id_product = 12 OR id_product = 13;

TRUNCATE TABLE `PREFIX_tab`;
TRUNCATE TABLE `PREFIX_tab_lang`;

INSERT INTO `PREFIX_tab` (`id_tab`, `id_parent`, `class_name`, `position`) VALUES
(1, 0, 'AdminCatalog', 1),
(2, 0, 'AdminCustomers', 2),
(3, 0, 'AdminOrders', 3),
(6, 0, 'AdminStats', 4),
(7, 0, 'AdminModules', 5),
(8, 0, 'AdminPreferences', 7),
(9, 0, 'AdminTools', 6),
(10, 1, 'AdminManufacturers', 1),
(34, 1, 'AdminSuppliers', 2),
(11, 1, 'AdminAttributesGroups', 4),
(36, 1, 'AdminFeatures', 3),
(12, 2, 'AdminAddresses', 1),
(47, 3, 'AdminReturn', 1),
(49, 3, 'AdminSlip', 2),
(13, 3, 'AdminOrdersStates', 3),
(42, 3, 'AdminPrintPDF', 4),
(14, 1, 'AdminDiscounts', 6),
(15, 8, 'AdminCurrencies', 4),
(16, 1, 'AdminTaxes', 5),
(46, 2, 'AdminStates', 3),
(18, 2, 'AdminCountries', 2),
(19, 2, 'AdminZones', 1),
(22, 7, 'AdminModulesPositions', 1),
(39, 8, 'AdminContact', 10),
(38, 8, 'AdminAppearance', 11),
(27, 1, 'AdminPPreferences', 12),
(24, 8, 'AdminEmails', 13),
(26, 8, 'AdminImages', 14),
(23, 8, 'AdminDb', 7),
(48, 8, 'AdminPDF', 8),
(44, 8, 'AdminLocalization', 9),
(28, 9, 'AdminContacts', 4),
(29, 9, 'AdminEmployees', 1),
(30, 9, 'AdminProfiles', 2),
(31, 9, 'AdminAccess', 3),
(32, 9, 'AdminLanguages', 5),
(33, 9, 'AdminTranslations', 6),
(35, 9, 'AdminTabs', 7),
(37, 9, 'AdminQuickAccesses', 8),
(40, 9, 'AdminAliases', 9),
(41, 9, 'AdminImport', 10),
(53, 6, 'AdminMember', 2),
(52, 6, 'AdminMulti', 1),
(54, 6, 'AdminOrder', 3),
(56, 6, 'AdminNsale', 4),
(58, 6, 'AdminPaycarry', 5),
(59, 6, 'AdminPaycarrys', 6),
(60, 7, 'AdminUpModule', 2),
(61, 7, 'AdminHomeM', 3),
(62, 7, 'AdminPaymentM', 4),
(63, 7, 'AdminShippingM', 5),
(64, 7, 'AdminBasicM', 6),
(65, 7, 'AdminPlusM', 7),
(66, 7, 'AdminMarketingM', 8);
    
INSERT INTO `PREFIX_tab_lang` (`id_lang`, `id_tab`, `name`) VALUES
(1, 1, 'Pruducts'),
(1, 2, 'Customers'),
(1, 3, 'Orders'),
(1, 6, 'Stats'),
(1, 7, 'Modules'),
(1, 8, 'Preferences'),
(1, 9, 'Tools'),
(1, 10, 'Manufacturers'),
(1, 11, 'Attributes and groups'),
(1, 12, 'Addresses'),
(1, 13, 'Order statuses'),
(1, 14, 'Discounts'),
(1, 15, 'Currencies'),
(1, 16, 'Taxes'),
(1, 18, 'Countries'),
(1, 19, 'Zones'),
(1, 22, 'Positions'),
(1, 23, 'Database'),
(1, 24, 'Email'),
(1, 26, 'Image set'),
(1, 27, 'Products set'),
(1, 28, 'Contacts'),
(1, 29, 'Employees'),
(1, 30, 'Profiles'),
(1, 31, 'Permissions'),
(1, 32, 'Languages'),
(1, 33, 'Translations'),
(1, 34, 'Suppliers'),
(1, 35, 'Tabs'),
(1, 36, 'Features'),
(1, 37, 'Quick Accesses'),
(1, 38, 'Appearance'),
(1, 39, 'Contact'),
(1, 40, 'Aliases'),
(1, 41, 'Import'),
(1, 42, 'PDF Invoice'),
(1, 44, 'Localization'),
(1, 45, 'Print invoices'),
(1, 46, 'States'),
(1, 47, 'Merchandise return (RMAs)'),
(1, 48, 'PDF'),
(1, 49, 'Credit slips'),
(2, 1, 'Catalogue'),
(2, 2, 'Clients'),
(2, 3, 'Commandes'),
(2, 6, 'Stats'),
(2, 7, 'Modules'),
(2, 8, 'Préférences'),
(2, 9, 'Outils'),
(2, 10, 'Fabricants'),
(2, 11, 'Attributs et groupes'),
(2, 12, 'Adresses'),
(2, 13, 'Statuts des commandes'),
(2, 14, 'Bons de réduction'),
(2, 15, 'Devises'),
(2, 16, 'Taxes'),
(2, 18, 'Pays'),
(2, 19, 'Zones'),
(2, 22, 'Positions'),
(2, 23, 'Base de données'),
(2, 24, 'Emails'),
(2, 26, 'Images'),
(2, 27, 'Produits'),
(2, 28, 'Contacts'),
(2, 29, 'Employés'),
(2, 30, 'Profils'),
(2, 31, 'Permissions'),
(2, 32, 'Langues'),
(2, 33, 'Traductions'),
(2, 34, 'Fournisseurs'),
(2, 35, 'Onglets'),
(2, 36, 'Caractéristiques'),
(2, 37, 'Accès rapide'),
(2, 38, 'Apparence'),
(2, 39, 'Coordonnées'),
(2, 40, 'Alias'),
(2, 41, 'Import'),
(2, 42, 'Facture PDF'),
(2, 44, 'Localisation'),
(2, 45, 'Impression factures'),
(2, 46, 'Etats'),
(2, 47, 'Retours produits'),
(2, 48, 'Paramètres PDF'),
(2, 49, 'Avoirs'),
(3, 1, 'Catalog'),
(4, 1, 'Catalog'),
(5, 1, 'Catalog'),
(6, 1, 'Catalog'),
(7, 1, 'Catalog'),
(8, 1, 'Catalog'),
(9, 1, 'Catalog'),
(10, 1, 'Catalog'),
(11, 1, 'Catalog'),
(12, 1, 'Catalog'),
(13, 1, 'Catalog'),
(14, 1, 'Catalog'),
(15, 1, 'Catalog'),
(16, 1, 'Catalog'),
(17, 1, 'Catalog'),
(18, 1, 'Catalog'),
(19, 1, 'Catalog'),
(20, 1, 'Catalog'),
(21, 1, 'Catalog'),
(3, 2, 'Customers'),
(4, 2, 'Customers'),
(5, 2, 'Customers'),
(6, 2, 'Customers'),
(7, 2, 'Customers'),
(8, 2, 'Customers'),
(9, 2, 'Customers'),
(10, 2, 'Customers'),
(11, 2, 'Customers'),
(12, 2, 'Customers'),
(13, 2, 'Customers'),
(14, 2, 'Customers'),
(15, 2, 'Customers'),
(16, 2, 'Customers'),
(17, 2, 'Customers'),
(18, 2, 'Customers'),
(19, 2, 'Customers'),
(20, 2, 'Customers'),
(21, 2, 'Customers'),
(3, 3, 'Orders'),
(4, 3, 'Orders'),
(5, 3, 'Orders'),
(6, 3, 'Orders'),
(7, 3, 'Orders'),
(8, 3, 'Orders'),
(9, 3, 'Orders'),
(10, 3, 'Orders'),
(11, 3, 'Orders'),
(12, 3, 'Orders'),
(13, 3, 'Orders'),
(14, 3, 'Orders'),
(15, 3, 'Orders'),
(16, 3, 'Orders'),
(17, 3, 'Orders'),
(18, 3, 'Orders'),
(19, 3, 'Orders'),
(20, 3, 'Orders'),
(21, 3, 'Orders'),
(3, 6, 'Stats'),
(4, 6, 'Stats'),
(5, 6, 'Stats'),
(6, 6, 'Stats'),
(7, 6, 'Stats'),
(8, 6, 'Stats'),
(9, 6, 'Stats'),
(10, 6, 'Stats'),
(11, 6, 'Stats'),
(12, 6, 'Stats'),
(13, 6, 'Stats'),
(14, 6, 'Stats'),
(15, 6, 'Stats'),
(16, 6, 'Stats'),
(17, 6, 'Stats'),
(18, 6, 'Stats'),
(19, 6, 'Stats'),
(20, 6, 'Stats'),
(21, 6, 'Stats'),
(3, 7, 'Modules'),
(4, 7, 'Modules'),
(5, 7, 'Modules'),
(6, 7, 'Modules'),
(7, 7, 'Modules'),
(8, 7, 'Modules'),
(9, 7, 'Modules'),
(10, 7, 'Modules'),
(11, 7, 'Modules'),
(12, 7, 'Modules'),
(13, 7, 'Modules'),
(14, 7, 'Modules'),
(15, 7, 'Modules'),
(16, 7, 'Modules'),
(17, 7, 'Modules'),
(18, 7, 'Modules'),
(19, 7, 'Modules'),
(20, 7, 'Modules'),
(21, 7, 'Modules'),
(3, 8, 'Preferences'),
(4, 8, 'Preferences'),
(5, 8, 'Preferences'),
(6, 8, 'Preferences'),
(7, 8, 'Preferences'),
(8, 8, 'Preferences'),
(9, 8, 'Preferences'),
(10, 8, 'Preferences'),
(11, 8, 'Preferences'),
(12, 8, 'Preferences'),
(13, 8, 'Preferences'),
(14, 8, 'Preferences'),
(15, 8, 'Preferences'),
(16, 8, 'Preferences'),
(17, 8, 'Preferences'),
(18, 8, 'Preferences'),
(19, 8, 'Preferences'),
(20, 8, 'Preferences'),
(21, 8, 'Preferences'),
(3, 9, 'Tools'),
(4, 9, 'Tools'),
(5, 9, 'Tools'),
(6, 9, 'Tools'),
(7, 9, 'Tools'),
(8, 9, 'Tools'),
(9, 9, 'Tools'),
(10, 9, 'Tools'),
(11, 9, 'Tools'),
(12, 9, 'Tools'),
(13, 9, 'Tools'),
(14, 9, 'Tools'),
(15, 9, 'Tools'),
(16, 9, 'Tools'),
(17, 9, 'Tools'),
(18, 9, 'Tools'),
(19, 9, 'Tools'),
(20, 9, 'Tools'),
(21, 9, 'Tools'),
(3, 10, 'Manufacturers'),
(4, 10, 'Manufacturers'),
(5, 10, 'Manufacturers'),
(6, 10, 'Manufacturers'),
(7, 10, 'Manufacturers'),
(8, 10, 'Manufacturers'),
(9, 10, 'Manufacturers'),
(10, 10, 'Manufacturers'),
(11, 10, 'Manufacturers'),
(12, 10, 'Manufacturers'),
(13, 10, 'Manufacturers'),
(14, 10, 'Manufacturers'),
(15, 10, 'Manufacturers'),
(16, 10, 'Manufacturers'),
(17, 10, 'Manufacturers'),
(18, 10, 'Manufacturers'),
(19, 10, 'Manufacturers'),
(20, 10, 'Manufacturers'),
(21, 10, 'Manufacturers'),
(3, 34, 'Suppliers'),
(4, 34, 'Suppliers'),
(5, 34, 'Suppliers'),
(6, 34, 'Suppliers'),
(7, 34, 'Suppliers'),
(8, 34, 'Suppliers'),
(9, 34, 'Suppliers'),
(10, 34, 'Suppliers'),
(11, 34, 'Suppliers'),
(12, 34, 'Suppliers'),
(13, 34, 'Suppliers'),
(14, 34, 'Suppliers'),
(15, 34, 'Suppliers'),
(16, 34, 'Suppliers'),
(17, 34, 'Suppliers'),
(18, 34, 'Suppliers'),
(19, 34, 'Suppliers'),
(20, 34, 'Suppliers'),
(21, 34, 'Suppliers'),
(3, 11, 'Attributes and groups'),
(4, 11, 'Attributes and groups'),
(5, 11, 'Attributes and groups'),
(6, 11, 'Attributes and groups'),
(7, 11, 'Attributes and groups'),
(8, 11, 'Attributes and groups'),
(9, 11, 'Attributes and groups'),
(10, 11, 'Attributes and groups'),
(11, 11, 'Attributes and groups'),
(12, 11, 'Attributes and groups'),
(13, 11, 'Attributes and groups'),
(14, 11, 'Attributes and groups'),
(15, 11, 'Attributes and groups'),
(16, 11, 'Attributes and groups'),
(17, 11, 'Attributes and groups'),
(18, 11, 'Attributes and groups'),
(19, 11, 'Attributes and groups'),
(20, 11, 'Attributes and groups'),
(21, 11, 'Attributes and groups'),
(3, 36, 'Features'),
(4, 36, 'Features'),
(5, 36, 'Features'),
(6, 36, 'Features'),
(7, 36, 'Features'),
(8, 36, 'Features'),
(9, 36, 'Features'),
(10, 36, 'Features'),
(11, 36, 'Features'),
(12, 36, 'Features'),
(13, 36, 'Features'),
(14, 36, 'Features'),
(15, 36, 'Features'),
(16, 36, 'Features'),
(17, 36, 'Features'),
(18, 36, 'Features'),
(19, 36, 'Features'),
(20, 36, 'Features'),
(21, 36, 'Features'),
(3, 12, 'Addresses'),
(4, 12, 'Addresses'),
(5, 12, 'Addresses'),
(6, 12, 'Addresses'),
(7, 12, 'Addresses'),
(8, 12, 'Addresses'),
(9, 12, 'Addresses'),
(10, 12, 'Addresses'),
(11, 12, 'Addresses'),
(12, 12, 'Addresses'),
(13, 12, 'Addresses'),
(14, 12, 'Addresses'),
(15, 12, 'Addresses'),
(16, 12, 'Addresses'),
(17, 12, 'Addresses'),
(18, 12, 'Addresses'),
(19, 12, 'Addresses'),
(20, 12, 'Addresses'),
(21, 12, 'Addresses'),
(3, 47, 'Merchandise return (RMAs)'),
(4, 47, 'Merchandise return (RMAs)'),
(5, 47, 'Merchandise return (RMAs)'),
(6, 47, 'Merchandise return (RMAs)'),
(7, 47, 'Merchandise return (RMAs)'),
(8, 47, 'Merchandise return (RMAs)'),
(9, 47, 'Merchandise return (RMAs)'),
(10, 47, 'Merchandise return (RMAs)'),
(11, 47, 'Merchandise return (RMAs)'),
(12, 47, 'Merchandise return (RMAs)'),
(13, 47, 'Merchandise return (RMAs)'),
(14, 47, 'Merchandise return (RMAs)'),
(15, 47, 'Merchandise return (RMAs)'),
(16, 47, 'Merchandise return (RMAs)'),
(17, 47, 'Merchandise return (RMAs)'),
(18, 47, 'Merchandise return (RMAs)'),
(19, 47, 'Merchandise return (RMAs)'),
(20, 47, 'Merchandise return (RMAs)'),
(21, 47, 'Merchandise return (RMAs)'),
(3, 49, 'Credit slips'),
(4, 49, 'Credit slips'),
(5, 49, 'Credit slips'),
(6, 49, 'Credit slips'),
(7, 49, 'Credit slips'),
(8, 49, 'Credit slips'),
(9, 49, 'Credit slips'),
(10, 49, 'Credit slips'),
(11, 49, 'Credit slips'),
(12, 49, 'Credit slips'),
(13, 49, 'Credit slips'),
(14, 49, 'Credit slips'),
(15, 49, 'Credit slips'),
(16, 49, 'Credit slips'),
(17, 49, 'Credit slips'),
(18, 49, 'Credit slips'),
(19, 49, 'Credit slips'),
(20, 49, 'Credit slips'),
(21, 49, 'Credit slips'),
(3, 13, 'Order statuses'),
(4, 13, 'Order statuses'),
(5, 13, 'Order statuses'),
(6, 13, 'Order statuses'),
(7, 13, 'Order statuses'),
(8, 13, 'Order statuses'),
(9, 13, 'Order statuses'),
(10, 13, 'Order statuses'),
(11, 13, 'Order statuses'),
(12, 13, 'Order statuses'),
(13, 13, 'Order statuses'),
(14, 13, 'Order statuses'),
(15, 13, 'Order statuses'),
(16, 13, 'Order statuses'),
(17, 13, 'Order statuses'),
(18, 13, 'Order statuses'),
(19, 13, 'Order statuses'),
(20, 13, 'Order statuses'),
(21, 13, 'Order statuses'),
(3, 42, 'PDF Invoice'),
(4, 42, 'PDF Invoice'),
(5, 42, 'PDF Invoice'),
(6, 42, 'PDF Invoice'),
(7, 42, 'PDF Invoice'),
(8, 42, 'PDF Invoice'),
(9, 42, 'PDF Invoice'),
(10, 42, 'PDF Invoice'),
(11, 42, 'PDF Invoice'),
(12, 42, 'PDF Invoice'),
(13, 42, 'PDF Invoice'),
(14, 42, 'PDF Invoice'),
(15, 42, 'PDF Invoice'),
(16, 42, 'PDF Invoice'),
(17, 42, 'PDF Invoice'),
(18, 42, 'PDF Invoice'),
(19, 42, 'PDF Invoice'),
(20, 42, 'PDF Invoice'),
(21, 42, 'PDF Invoice'),
(3, 14, 'Discounts'),
(4, 14, 'Discounts'),
(5, 14, 'Discounts'),
(6, 14, 'Discounts'),
(7, 14, 'Discounts'),
(8, 14, 'Discounts'),
(9, 14, 'Discounts'),
(10, 14, 'Discounts'),
(11, 14, 'Discounts'),
(12, 14, 'Discounts'),
(13, 14, 'Discounts'),
(14, 14, 'Discounts'),
(15, 14, 'Discounts'),
(16, 14, 'Discounts'),
(17, 14, 'Discounts'),
(18, 14, 'Discounts'),
(19, 14, 'Discounts'),
(20, 14, 'Discounts'),
(21, 14, 'Discounts'),
(3, 15, 'Currencies'),
(4, 15, 'Currencies'),
(5, 15, 'Currencies'),
(6, 15, 'Currencies'),
(7, 15, 'Currencies'),
(8, 15, 'Currencies'),
(9, 15, 'Currencies'),
(10, 15, 'Currencies'),
(11, 15, 'Currencies'),
(12, 15, 'Currencies'),
(13, 15, 'Currencies'),
(14, 15, 'Currencies'),
(15, 15, 'Currencies'),
(16, 15, 'Currencies'),
(17, 15, 'Currencies'),
(18, 15, 'Currencies'),
(19, 15, 'Currencies'),
(20, 15, 'Currencies'),
(21, 15, 'Currencies'),
(3, 16, 'Taxes'),
(4, 16, 'Taxes'),
(5, 16, 'Taxes'),
(6, 16, 'Taxes'),
(7, 16, 'Taxes'),
(8, 16, 'Taxes'),
(9, 16, 'Taxes'),
(10, 16, 'Taxes'),
(11, 16, 'Taxes'),
(12, 16, 'Taxes'),
(13, 16, 'Taxes'),
(14, 16, 'Taxes'),
(15, 16, 'Taxes'),
(16, 16, 'Taxes'),
(17, 16, 'Taxes'),
(18, 16, 'Taxes'),
(19, 16, 'Taxes'),
(20, 16, 'Taxes'),
(21, 16, 'Taxes'),
(3, 46, 'States'),
(4, 46, 'States'),
(5, 46, 'States'),
(6, 46, 'States'),
(7, 46, 'States'),
(8, 46, 'States'),
(9, 46, 'States'),
(10, 46, 'States'),
(11, 46, 'States'),
(12, 46, 'States'),
(13, 46, 'States'),
(14, 46, 'States'),
(15, 46, 'States'),
(16, 46, 'States'),
(17, 46, 'States'),
(18, 46, 'States'),
(19, 46, 'States'),
(20, 46, 'States'),
(21, 46, 'States'),
(3, 18, 'Countries'),
(4, 18, 'Countries'),
(5, 18, 'Countries'),
(6, 18, 'Countries'),
(7, 18, 'Countries'),
(8, 18, 'Countries'),
(9, 18, 'Countries'),
(10, 18, 'Countries'),
(11, 18, 'Countries'),
(12, 18, 'Countries'),
(13, 18, 'Countries'),
(14, 18, 'Countries'),
(15, 18, 'Countries'),
(16, 18, 'Countries'),
(17, 18, 'Countries'),
(18, 18, 'Countries'),
(19, 18, 'Countries'),
(20, 18, 'Countries'),
(21, 18, 'Countries'),
(3, 19, 'Zones'),
(4, 19, 'Zones'),
(5, 19, 'Zones'),
(6, 19, 'Zones'),
(7, 19, 'Zones'),
(8, 19, 'Zones'),
(9, 19, 'Zones'),
(10, 19, 'Zones'),
(11, 19, 'Zones'),
(12, 19, 'Zones'),
(13, 19, 'Zones'),
(14, 19, 'Zones'),
(15, 19, 'Zones'),
(16, 19, 'Zones'),
(17, 19, 'Zones'),
(18, 19, 'Zones'),
(19, 19, 'Zones'),
(20, 19, 'Zones'),
(21, 19, 'Zones'),
(3, 22, 'Positions'),
(4, 22, 'Positions'),
(5, 22, 'Positions'),
(6, 22, 'Positions'),
(7, 22, 'Positions'),
(8, 22, 'Positions'),
(9, 22, 'Positions'),
(10, 22, 'Positions'),
(11, 22, 'Positions'),
(12, 22, 'Positions'),
(13, 22, 'Positions'),
(14, 22, 'Positions'),
(15, 22, 'Positions'),
(16, 22, 'Positions'),
(17, 22, 'Positions'),
(18, 22, 'Positions'),
(19, 22, 'Positions'),
(20, 22, 'Positions'),
(21, 22, 'Positions'),
(3, 39, 'Contact'),
(4, 39, 'Contact'),
(5, 39, 'Contact'),
(6, 39, 'Contact'),
(7, 39, 'Contact'),
(8, 39, 'Contact'),
(9, 39, 'Contact'),
(10, 39, 'Contact'),
(11, 39, 'Contact'),
(12, 39, 'Contact'),
(13, 39, 'Contact'),
(14, 39, 'Contact'),
(15, 39, 'Contact'),
(16, 39, 'Contact'),
(17, 39, 'Contact'),
(18, 39, 'Contact'),
(19, 39, 'Contact'),
(20, 39, 'Contact'),
(21, 39, 'Contact'),
(3, 38, 'Appearance'),
(4, 38, 'Appearance'),
(5, 38, 'Appearance'),
(6, 38, 'Appearance'),
(7, 38, 'Appearance'),
(8, 38, 'Appearance'),
(9, 38, 'Appearance'),
(10, 38, 'Appearance'),