1.0.7.0.sql

一款C2C的网店程序 我也是在网上下载的

/* 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'),