vjwM05cZ

1-- Table structure for table `xc_products`
2
3DROP TABLE IF EXISTS `xc_products`;
4CREATE TABLE `xc_products` (
5  `product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
6  `product_class_id` int(10) unsigned DEFAULT NULL,
7  `tax_class_id` int(10) unsigned DEFAULT NULL,
8  `freeShip` tinyint(1) DEFAULT NULL,
9  `freightFixedFee` decimal(14,4) DEFAULT NULL,
10  `participateSale` tinyint(1) NOT NULL,
11  `discountType` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
12  `salePriceValue` decimal(14,4) NOT NULL,
13  `price` decimal(14,4) NOT NULL COMMENT '(DC2Type:money)',
14  `sku` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
15  `enabled` tinyint(1) NOT NULL,
16  `weight` decimal(14,4) NOT NULL,
17  `useSeparateBox` tinyint(1) NOT NULL,
18  `boxWidth` decimal(14,4) NOT NULL,
19  `boxLength` decimal(14,4) NOT NULL,
20  `boxHeight` decimal(14,4) NOT NULL,
21  `itemsPerBox` int(11) NOT NULL,
22  `free_shipping` tinyint(1) NOT NULL,
23  `taxable` tinyint(1) NOT NULL,
24  `javascript` longtext COLLATE utf8_unicode_ci NOT NULL,
25  `arrivalDate` int(11) NOT NULL,
26  `date` int(11) NOT NULL,
27  `updateDate` int(10) unsigned NOT NULL,
28  `needProcess` tinyint(1) NOT NULL,
29  `attrSepTab` tinyint(1) NOT NULL,
30  `metaDescType` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
31  `PPCField` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
32  `ogMeta` longtext COLLATE utf8_unicode_ci,
33  `useCustomOG` tinyint(1) DEFAULT NULL,
34  `sales` int(10) unsigned NOT NULL,
35  `xcPendingExport` tinyint(1) NOT NULL,
36  PRIMARY KEY (`product_id`),
37  KEY `IDX_6EC5B6BD21B06187` (`product_class_id`),
38  KEY `IDX_6EC5B6BDA94AAAE` (`tax_class_id`),
39  KEY `sku` (`sku`),
40  KEY `price` (`price`),
41  KEY `weight` (`weight`),
42  KEY `free_shipping` (`free_shipping`),
43  KEY `customerArea` (`enabled`,`arrivalDate`),
44  CONSTRAINT `FK_6EC5B6BD21B06187` FOREIGN KEY (`product_class_id`) REFERENCES `xc_product_classes` (`id`) ON DELETE SET NULL,
45  CONSTRAINT `FK_6EC5B6BDA94AAAE` FOREIGN KEY (`tax_class_id`) REFERENCES `xc_tax_classes` (`id`) ON DELETE SET NULL
46) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;