Рубрики

применяемость (1) Api (1) Mysql (1) News (2) Oem2car (1) Suppliers (1) Tecdoc 4_2017 (2) Новости (1) Реклама и маркетинг (1)

Обновления


CREATE TABLE IF NOT EXISTS `all_articles` ( `supplierid` int(11) NOT NULL, `datasupplierarticlenumber` varchar(64) NOT NULL, KEY `all_articles_idx01` (`supplierid`), KEY `all_articles_idx02` (`datasupplierarticlenumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `all_articles_csv` ( `id` int(11) NOT NULL AUTO_INCREMENT, `supplierid` int(11) NOT NULL, `datasupplierarticlenumber` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `all_articles_csv_idx01` (`supplierid`), KEY `all_articles_csv_idx02` (`datasupplierarticlenumber`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `articles` ( `supplierId` int(11) NOT NULL, `DataSupplierArticleNumber` varchar(128) NOT NULL, `ArticleStateDisplayTitle` varchar(128) NOT NULL, `ArticleStateDisplayValue` varchar(128) NOT NULL, `Description` varchar(128) NOT NULL, `FlagAccessory` enum('True','False') NOT NULL, `FlagMaterialCertification` enum('True','False') NOT NULL, `FlagRemanufactured` enum('True','False') NOT NULL, `FlagSelfServicePacking` enum('True','False') NOT NULL, `FoundBy` varchar(128) NOT NULL, `FoundString` varchar(128) NOT NULL, `HasAxle` enum('True','False') NOT NULL, `HasCommercialVehicle` enum('True','False') NOT NULL, `HasCVManuID` enum('True','False') NOT NULL, `HasEngine` enum('True','False') NOT NULL, `HasLinkitems` enum('True','False') NOT NULL, `HasMotorbike` enum('True','False') NOT NULL, `HasPassengerCar` enum('True','False') NOT NULL, `IsValid` enum('True','False') NOT NULL, `LotSize1` varchar(128) NOT NULL, `LotSize2` varchar(128) NOT NULL, `NormalizedDescription` varchar(128) NOT NULL, `PackingUnit` int(11) NOT NULL, `QuantityPerPackingUnit` int(11) NOT NULL, KEY `articles_idx01` (`supplierId`), KEY `articles_idx02` (`DataSupplierArticleNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `articles_csv` ( `id` int(11) NOT NULL AUTO_INCREMENT, `supplierid` int(11) NOT NULL, `datasupplierarticlenumber` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `articles_csv_idx01` (`supplierid`), KEY `articles_csv_idx02` (`datasupplierarticlenumber`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_acc` ( `supplierId` int(11) NOT NULL, `DataSupplierArticleNumber` varchar(64) NOT NULL, `Description` varchar(128) NOT NULL, `AccSupplierId` int(11) NOT NULL, `AccDataSupplierArticleNumber` varchar(64) NOT NULL, KEY `article_acc_idx01` (`supplierId`), KEY `article_acc_idx02` (`DataSupplierArticleNumber`), KEY `article_acc_idx03` (`AccSupplierId`), KEY `article_acc_idx04` (`AccDataSupplierArticleNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_attributes` ( `supplierid` int(11) NOT NULL, `datasupplierarticlenumber` varchar(64) NOT NULL, `id` int(11) NOT NULL, `attributeinformationtype` varchar(64) NOT NULL, `description` varchar(512) DEFAULT NULL, `displaytitle` varchar(512) DEFAULT NULL, `displayvalue` varchar(2048) NOT NULL, KEY `id` (`id`), KEY `supplierid` (`supplierid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_cross` ( `manufacturerId` int(11) NOT NULL, `OENbr` varchar(64) NOT NULL, `SupplierId` int(11) NOT NULL, `PartsDataSupplierArticleNumber` varchar(64) NOT NULL, KEY `article_cross_idx01` (`manufacturerId`), KEY `article_cross_idx02` (`OENbr`), KEY `article_cross_idx03` (`SupplierId`), KEY `article_cross_idx04` (`PartsDataSupplierArticleNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_images` ( `supplierId` int(11) NOT NULL, `DataSupplierArticleNumber` varchar(64) NOT NULL, `AdditionalDescription` varchar(128) NOT NULL, `Description` varchar(64) NOT NULL, `DocumentName` varchar(128) NOT NULL, `DocumentType` varchar(32) NOT NULL, `NormedDescriptionID` int(11) NOT NULL, `PictureName` varchar(64) NOT NULL, `ShowImmediately` enum('True','False') NOT NULL, KEY `article_images_idx01` (`supplierId`), KEY `article_images_idx02` (`DataSupplierArticleNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_inf` ( `supplierId` int(11) NOT NULL, `DataSupplierArticleNumber` varchar(64) NOT NULL, `InformationText` text NOT NULL, `InformationType` varchar(64) NOT NULL, `InformationTypeKey` int(11) NOT NULL, KEY `article_inf_idx01` (`supplierId`), KEY `article_inf_idx02` (`DataSupplierArticleNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_li` ( `supplierId` bigint(20) NOT NULL, `DataSupplierArticleNumber` varchar(128) NOT NULL, `linkageTypeId` varchar(128) NOT NULL, `linkageId` bigint(20) NOT NULL, KEY `article_li_idx01` (`supplierId`), KEY `article_li_idx02` (`DataSupplierArticleNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `article_links` ( `supplierid` bigint(20) NOT NULL, `productid` bigint(20) NOT NULL, `linkagetypeid` bigint(20) NOT NULL, `linkageid` bigint(20) NOT NULL, `datasupplierarticlenumber` varchar(128) DEFAULT NULL, KEY `article_links_idx01` (`supplierid`), KEY `article_links_idx02` (`productid`), KEY `article_links_idx03` (`linkagetypeid`), KEY `article_links_idx04` (`linkageid`), KEY `article_links_idx05` (`datasupplierarticlenumber`), KEY `article_links_idx06` (`linkageid`,`linkagetypeid`,`productid`,`supplierid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `article_nn` ( `supplierid` int(11) NOT NULL, `datasupplierarticlenumber` varchar(64) NOT NULL, `newnbr` varchar(64) NOT NULL, `newsupplierid` int(11) NOT NULL, `newdatasupplierarticlenumber` varchar(64) NOT NULL, KEY `article_nn_idx01` (`supplierid`), KEY `article_nn_idx02` (`datasupplierarticlenumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_oe` ( `supplierid` int(11) NOT NULL, `datasupplierarticlenumber` varchar(64) NOT NULL, `IsAdditive` enum('True','False') NOT NULL, `OENbr` varchar(64) NOT NULL, `manufacturerId` int(11) NOT NULL, KEY `article_oe_idx01` (`supplierid`), KEY `article_oe_idx02` (`datasupplierarticlenumber`), KEY `article_oe_idx03` (`manufacturerId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_parts` ( `supplierId` int(11) NOT NULL, `DataSupplierArticleNumber` varchar(64) NOT NULL, `Quantity` smallint(6) NOT NULL, `PartsSupplierId` int(11) NOT NULL, `PartsDataSupplierArticleNumber` varchar(64) NOT NULL, KEY `article_parts_idx01` (`supplierId`), KEY `article_parts_idx02` (`DataSupplierArticleNumber`), KEY `article_parts_idx03` (`PartsSupplierId`), KEY `article_parts_idx04` (`PartsDataSupplierArticleNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_rn` ( `supplierid` int(11) NOT NULL, `datasupplierarticlenumber` varchar(64) NOT NULL, `replacenbr` varchar(64) NOT NULL, `replacedupplierid` int(11) NOT NULL, `replacedatasupplierarticlenumber` varchar(64) NOT NULL, KEY `article_rn_idx01` (`supplierid`), KEY `article_rn_idx02` (`datasupplierarticlenumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `article_un` ( `supplierid` int(11) NOT NULL, `datasupplierarticlenumber` varchar(64) NOT NULL, `utilityno` varchar(64) NOT NULL, KEY `article_un_idx01` (`supplierid`), KEY `article_un_idx02` (`datasupplierarticlenumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `axles` ( `id` int(11) NOT NULL, `canbedisplayed` enum('True','False') DEFAULT NULL, `constructioninterval` varchar(32) DEFAULT NULL, `description` varchar(64) DEFAULT NULL, `fulldescription` varchar(128) DEFAULT NULL, `haslink` enum('True','False') DEFAULT NULL, `isaxle` enum('True','False') DEFAULT NULL, `iscommercialvehicle` enum('True','False') DEFAULT NULL, `iscvmanufacturerid` enum('True','False') DEFAULT NULL, `isengine` enum('True','False') DEFAULT NULL, `ismotorbike` enum('True','False') DEFAULT NULL, `ispassengercar` enum('True','False') DEFAULT NULL, `istransporter` enum('True','False') DEFAULT NULL, `isvalidforcurrentcountry` enum('True','False') DEFAULT NULL, `linkitemtype` varchar(12) DEFAULT NULL, `modelid` int(11) DEFAULT NULL, KEY `axles_idx01` (`id`), KEY `axles_idx02` (`modelid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `axle_attributes` ( `axleid` int(11) NOT NULL, `attributegroup` varchar(128) DEFAULT NULL, `attributetype` varchar(128) DEFAULT NULL, `displaytitle` varchar(128) DEFAULT NULL, `displayvalue` varchar(512) DEFAULT NULL, KEY `axle_attributes_idx01` (`axleid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `axle_pds` ( `axleid` int(11) NOT NULL, `nodeid` int(11) NOT NULL, `productid` int(11) NOT NULL, `supplierid` int(11) NOT NULL, KEY `axle_pds_idx01` (`axleid`), KEY `axle_pds_idx02` (`nodeid`), KEY `axle_pds_idx03` (`productid`), KEY `axle_pds_idx04` (`supplierid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `axle_prd` ( `id` int(11) NOT NULL, `assemblygroupdescription` varchar(256) NOT NULL, `description` varchar(256) NOT NULL, `normalizeddescription` varchar(256) NOT NULL, `usagedescription` varchar(256) NOT NULL, KEY `axle_prd_idx01` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `axle_qsi` ( `axleid` int(11) NOT NULL, `description` varchar(128) DEFAULT NULL, `quickstarttype` tinyint(4) DEFAULT NULL, `validstate` enum('Valid','Invalid') DEFAULT NULL, KEY `axle_qsi_idx01` (`axleid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `axle_trees` ( `axleid` int(11) NOT NULL, `searchtreeid` int(11) NOT NULL, `id` int(11) NOT NULL, `parentid` int(11) DEFAULT NULL, `description` varchar(128) DEFAULT NULL, KEY `axle_trees_idx01` (`axleid`), KEY `axle_trees_idx02` (`id`), KEY `axle_trees_idx03` (`parentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_driver_cabs` ( `id` int(11) NOT NULL, `drivercabid` int(11) NOT NULL, KEY `commercial_driver_cabs_idx01` (`id`), KEY `commercial_driver_cabs_idx02` (`drivercabid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicles` ( `id` int(11) NOT NULL, `canbedisplayed` enum('True','False') DEFAULT NULL, `constructioninterval` varchar(32) DEFAULT NULL, `description` varchar(64) DEFAULT NULL, `fulldescription` varchar(128) DEFAULT NULL, `haslink` enum('True','False') DEFAULT NULL, `isaxle` enum('True','False') DEFAULT NULL, `iscommercialvehicle` enum('True','False') DEFAULT NULL, `iscvmanufacturerid` enum('True','False') DEFAULT NULL, `isengine` enum('True','False') DEFAULT NULL, `ismotorbike` enum('True','False') DEFAULT NULL, `ispassengercar` enum('True','False') DEFAULT NULL, `istransporter` enum('True','False') DEFAULT NULL, `isvalidforcurrentcountry` enum('True','False') DEFAULT NULL, `linkitemtype` varchar(24) DEFAULT NULL, `modelid` int(11) DEFAULT NULL, KEY `commercial_vehicles_idx01` (`id`), KEY `commercial_vehicles_idx02` (`modelid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicle_attributes` ( `commercialvehicleid` int(11) NOT NULL, `attributegroup` varchar(128) DEFAULT NULL, `attributetype` varchar(128) DEFAULT NULL, `displaytitle` varchar(128) DEFAULT NULL, `displayvalue` varchar(512) DEFAULT NULL, KEY `commercial_vehicle_attributes_idx01` (`commercialvehicleid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicle_axles` ( `id` int(11) NOT NULL, `axleid` int(11) NOT NULL, KEY `commercial_vehicle_axles_idx01` (`id`), KEY `commercial_vehicle_axles_idx02` (`axleid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicle_engines` ( `id` int(11) NOT NULL, `engineid` int(11) NOT NULL, KEY `commercial_vehicle_engines_idx01` (`id`), KEY `commercial_vehicle_engines_idx02` (`engineid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicle_pds` ( `commertialvehicleid` int(11) NOT NULL, `nodeid` int(11) NOT NULL, `productid` int(11) NOT NULL, `supplierid` int(11) NOT NULL, KEY `commercial_vehicle_pds_idx01` (`commertialvehicleid`), KEY `commercial_vehicle_pds_idx02` (`nodeid`), KEY `commercial_vehicle_pds_idx03` (`productid`), KEY `commercial_vehicle_pds_idx04` (`supplierid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicle_prd` ( `id` int(11) NOT NULL, `assemblygroupdescription` varchar(256) NOT NULL, `description` varchar(256) NOT NULL, `normalizeddescription` varchar(256) NOT NULL, `usagedescription` varchar(256) NOT NULL, KEY `commercial_vehicle_prd_idx01` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicle_qsi` ( `commercialvehicleid` int(11) NOT NULL, `description` varchar(128) DEFAULT NULL, `quickstarttype` tinyint(4) DEFAULT NULL, `validstate` enum('Valid','Invalid') DEFAULT NULL, KEY `commercial_vehicle_qsi_idx01` (`commercialvehicleid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicle_sub_types` ( `id` int(11) NOT NULL, `subtypeid` int(11) NOT NULL, KEY `commercial_vehicle_sub_types_idx01` (`id`), KEY `commercial_vehicle_sub_types_idx02` (`subtypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `commercial_vehicle_trees` ( `commercialvehicleid` int(11) NOT NULL, `searchtreeid` int(11) NOT NULL, `id` int(11) NOT NULL, `parentid` int(11) DEFAULT NULL, `description` varchar(256) DEFAULT NULL, KEY `commercial_vehicle_trees_idx01` (`commercialvehicleid`), KEY `commercial_vehicle_trees_idx02` (`id`), KEY `commercial_vehicle_trees_idx03` (`parentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `countries` ( `countrycode` varchar(4) DEFAULT NULL, `currencycode` varchar(4) DEFAULT NULL, `description` varchar(128) DEFAULT NULL, `isgroup` enum('True','False') DEFAULT NULL, `isocode2` varchar(4) DEFAULT NULL, `isocode3` varchar(4) DEFAULT NULL, `isocodeno` smallint(6) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `country_groups` ( `countrycode` varchar(4) DEFAULT NULL, `currencycode` varchar(4) DEFAULT NULL, `description` varchar(128) DEFAULT NULL, `isgroup` enum('True','False') DEFAULT NULL, `isocode2` varchar(4) DEFAULT NULL, `isocode3` varchar(4) DEFAULT NULL, `isocodeno` smallint(6) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `engines` ( `id` int(11) NOT NULL, `canbedisplayed` enum('True','False') DEFAULT NULL, `constructioninterval` varchar(32) DEFAULT NULL, `description` varchar(64) DEFAULT NULL, `fulldescription` varchar(128) DEFAULT NULL, `haslink` enum('True','False') DEFAULT NULL, `haslinkitem` enum('True','False') DEFAULT NULL, `isaxle` enum('True','False') DEFAULT NULL, `iscommercialvehicle` enum('True','False') DEFAULT NULL, `iscvmanufacturerid` enum('True','False') DEFAULT NULL, `isengine` enum('True','False') DEFAULT NULL, `ismotorbike` enum('True','False') DEFAULT NULL, `ispassengercar` enum('True','False') DEFAULT NULL, `istransporter` enum('True','False') DEFAULT NULL, `isvalidforcurrentcountry` enum('True','False') DEFAULT NULL, `linkitemtype` varchar(12) DEFAULT NULL, `manufacturerid` int(11) DEFAULT NULL, `salesdescription` varchar(128) DEFAULT NULL, KEY `engines_idx01` (`id`), KEY `engines_idx02` (`manufacturerid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `engine_attributes` ( `engineid` int(11) NOT NULL, `attributegroup` varchar(128) DEFAULT NULL, `attributetype` varchar(128) DEFAULT NULL, `displaytitle` varchar(128) DEFAULT NULL, `displayvalue` varchar(512) DEFAULT NULL, KEY `engine_attributes_idx01` (`engineid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `engine_pds` ( `engineid` int(11) NOT NULL, `nodeid` int(11) NOT NULL, `productid` int(11) NOT NULL, `supplierid` int(11) NOT NULL, KEY `engine_pds_idx01` (`engineid`), KEY `engine_pds_idx02` (`nodeid`), KEY `engine_pds_idx03` (`productid`), KEY `engine_pds_idx04` (`supplierid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `engine_prd` ( `id` int(11) NOT NULL, `assemblygroupdescription` varchar(256) NOT NULL, `description` varchar(256) NOT NULL, `normalizeddescription` varchar(256) NOT NULL, `usagedescription` varchar(256) NOT NULL, KEY `engine_prd_idx01` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `engine_qsi` ( `engineid` int(11) NOT NULL, `description` varchar(128) DEFAULT NULL, `quickstarttype` tinyint(4) DEFAULT NULL, `validstate` enum('Valid','Invalid') DEFAULT NULL, KEY `engine_qsi_idx01` (`engineid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `engine_trees` ( `engineid` int(11) NOT NULL, `searchtreeid` int(11) NOT NULL, `id` int(11) NOT NULL, `parentid` int(11) DEFAULT NULL, `description` varchar(256) DEFAULT NULL, KEY `engine_trees_idx01` (`engineid`), KEY `engine_trees_idx02` (`id`), KEY `engine_trees_idx03` (`parentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `languages` ( `id` int(11) NOT NULL, `codepage` smallint(6) DEFAULT NULL, `description` varchar(24) DEFAULT NULL, `isocode2` char(2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `isocode2` (`isocode2`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `manufacturers` ( `id` int(11) NOT NULL, `canbedisplayed` enum('True','False') DEFAULT NULL, `description` varchar(64) DEFAULT NULL, `fulldescription` varchar(64) DEFAULT NULL, `haslink` enum('True','False') DEFAULT NULL, `isaxle` enum('True','False') DEFAULT NULL, `iscommercialvehicle` enum('True','False') DEFAULT NULL, `iscvmanufacturerid` enum('True','False') DEFAULT NULL, `isengine` enum('True','False') DEFAULT NULL, `ismotorbike` enum('True','False') DEFAULT NULL, `ispassengercar` enum('True','False') DEFAULT NULL, `istransporter` enum('True','False') DEFAULT NULL, `isvalidforcurrentcountry` enum('True','False') DEFAULT NULL, `isvgl` enum('True','False') DEFAULT NULL, `linkitemtype` varchar(12) DEFAULT NULL, `matchcode` varchar(64) DEFAULT NULL, KEY `manufacturers_idx01` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `models` ( `id` int(11) NOT NULL, `canbedisplayed` enum('True','False') DEFAULT NULL, `constructioninterval` varchar(32) DEFAULT NULL, `description` varchar(64) DEFAULT NULL, `fulldescription` varchar(128) DEFAULT NULL, `haslink` enum('True','False') DEFAULT NULL, `isaxle` enum('True','False') DEFAULT NULL, `iscommercialvehicle` enum('True','False') DEFAULT NULL, `iscvmanufacturerid` enum('True','False') DEFAULT NULL, `isengine` enum('True','False') DEFAULT NULL, `ismotorbike` enum('True','False') DEFAULT NULL, `ispassengercar` enum('True','False') DEFAULT NULL, `istransporter` enum('True','False') DEFAULT NULL, `isvalidforcurrentcountry` enum('True','False') DEFAULT NULL, `linkitemtype` varchar(12) DEFAULT NULL, `manufacturerid` int(11) DEFAULT NULL, KEY `models_idx01` (`id`), KEY `models_idx02` (`manufacturerid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `motorbikes` ( `id` int(11) NOT NULL, `canbedisplayed` enum('True','False') DEFAULT NULL, `constructioninterval` varchar(32) DEFAULT NULL, `description` varchar(64) DEFAULT NULL, `fulldescription` varchar(128) DEFAULT NULL, `haslink` enum('True','False') DEFAULT NULL, `isaxle` enum('True','False') DEFAULT NULL, `iscommercialvehicle` enum('True','False') DEFAULT NULL, `iscvmanufacturerid` enum('True','False') DEFAULT NULL, `isengine` enum('True','False') DEFAULT NULL, `ismotorbike` enum('True','False') DEFAULT NULL, `ispassengercar` enum('True','False') DEFAULT NULL, `istransporter` enum('True','False') DEFAULT NULL, `isvalidforcurrentcountry` enum('True','False') DEFAULT NULL, `linkitemtype` varchar(12) DEFAULT NULL, `modelid` int(11) DEFAULT NULL, KEY `motorbikes_idx01` (`id`), KEY `motorbikes_idx02` (`modelid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `motorbike_attributes` ( `motorbikeid` int(11) NOT NULL, `attributegroup` varchar(128) DEFAULT NULL, `attributetype` varchar(128) DEFAULT NULL, `displaytitle` varchar(128) DEFAULT NULL, `displayvalue` varchar(512) DEFAULT NULL, KEY `motorbike_attributes_idx01` (`motorbikeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `motorbike_pds` ( `motorbikeid` int(11) NOT NULL, `nodeid` int(11) NOT NULL, `productid` int(11) NOT NULL, `supplierid` int(11) NOT NULL, KEY `motorbike_pds_idx01` (`motorbikeid`), KEY `motorbike_pds_idx02` (`nodeid`), KEY `motorbike_pds_idx03` (`productid`), KEY `motorbike_pds_idx04` (`supplierid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `motorbike_prd` ( `id` int(11) NOT NULL, `assemblygroupdescription` varchar(256) NOT NULL, `description` varchar(256) NOT NULL, `normalizeddescription` varchar(256) NOT NULL, `usagedescription` varchar(256) NOT NULL, KEY `motorbike_prd_idx01` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `motorbike_qsi` ( `motorbikeid` int(11) NOT NULL, `description` varchar(128) DEFAULT NULL, `quickstarttype` tinyint(4) DEFAULT NULL, `validstate` enum('Valid','Invalid') DEFAULT NULL, KEY `motorbike_qsi_idx01` (`motorbikeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `motorbike_trees` ( `motorbikeid` int(11) NOT NULL, `searchtreeid` int(11) NOT NULL, `id` int(11) NOT NULL, `parentid` int(11) DEFAULT NULL, `description` varchar(256) DEFAULT NULL, KEY `motorbike_trees_idx01` (`motorbikeid`), KEY `motorbike_trees_idx02` (`id`), KEY `motorbike_trees_idx03` (`parentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `passanger_cars` ( `id` int(11) NOT NULL, `canbedisplayed` enum('True','False') DEFAULT NULL, `constructioninterval` varchar(32) DEFAULT NULL, `description` varchar(64) DEFAULT NULL, `fulldescription` varchar(128) DEFAULT NULL, `haslink` enum('True','False') DEFAULT NULL, `isaxle` enum('True','False') DEFAULT NULL, `iscommercialvehicle` enum('True','False') DEFAULT NULL, `iscvmanufacturerid` enum('True','False') DEFAULT NULL, `isengine` enum('True','False') DEFAULT NULL, `ismotorbike` enum('True','False') DEFAULT NULL, `ispassengercar` enum('True','False') DEFAULT NULL, `istransporter` enum('True','False') DEFAULT NULL, `isvalidforcurrentcountry` enum('True','False') DEFAULT NULL, `linkitemtype` varchar(12) DEFAULT NULL, `modelid` int(11) DEFAULT NULL, KEY `passanger_cars_idx01` (`id`), KEY `passanger_cars_idx02` (`modelid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `passanger_car_attributes` ( `passangercarid` int(11) NOT NULL, `attributegroup` varchar(128) DEFAULT NULL, `attributetype` varchar(128) DEFAULT NULL, `displaytitle` varchar(128) DEFAULT NULL, `displayvalue` varchar(512) DEFAULT NULL, KEY `passanger_car_attributes_idx01` (`passangercarid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `passanger_car_engines` ( `id` int(11) NOT NULL, `engineid` int(11) NOT NULL, KEY `passanger_car_engines_idx01` (`id`), KEY `passanger_car_engines_idx02` (`engineid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `passanger_car_pds` ( `passangercarid` int(11) NOT NULL, `nodeid` int(11) NOT NULL, `productid` int(11) NOT NULL, `supplierid` int(11) NOT NULL, KEY `passanger_car_pds_idx01` (`passangercarid`), KEY `passanger_car_pds_idx02` (`nodeid`), KEY `passanger_car_pds_idx03` (`productid`), KEY `passanger_car_pds_idx04` (`supplierid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `passanger_car_prd` ( `id` int(11) NOT NULL, `assemblygroupdescription` varchar(256) NOT NULL, `description` varchar(256) NOT NULL, `normalizeddescription` varchar(256) NOT NULL, `usagedescription` varchar(256) NOT NULL, KEY `passanger_car_prd_idx01` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `passanger_car_qsi` ( `passangercarid` int(11) NOT NULL, `description` varchar(128) DEFAULT NULL, `quickstarttype` tinyint(4) DEFAULT NULL, `validstate` enum('Valid','Invalid') DEFAULT NULL, KEY `passanger_car_qsi_idx01` (`passangercarid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `passanger_car_trees` ( `passangercarid` int(11) NOT NULL, `searchtreeid` int(11) NOT NULL, `id` int(11) NOT NULL, `parentid` int(11) DEFAULT NULL, `description` varchar(256) DEFAULT NULL, KEY `passanger_car_trees_idx01` (`passangercarid`), KEY `passanger_car_trees_idx02` (`id`), KEY `passanger_car_trees_idx03` (`parentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `prd` ( `id` int(11) NOT NULL, `assemblygroupdescription` varchar(256) NOT NULL, `description` varchar(256) NOT NULL, `normalizeddescription` varchar(256) NOT NULL, `usagedescription` varchar(256) NOT NULL, KEY `prd_idx01` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `suppliers` ( `id` int(11) NOT NULL, `dataversion` varchar(32) DEFAULT NULL, `description` varchar(32) DEFAULT NULL, `matchcode` varchar(32) DEFAULT NULL, `nbrofarticles` varchar(32) DEFAULT NULL, `hasnewversionarticles` enum('True','False') DEFAULT NULL, KEY `suppliers_idx01` (`id`), KEY `suppliers_idx02` (`description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `suppliers_with_nv_articles` ( `id` int(11) NOT NULL, `dataversion` varchar(32) DEFAULT NULL, `description` varchar(32) DEFAULT NULL, `matchcode` varchar(32) DEFAULT NULL, `nbrofarticles` varchar(32) DEFAULT NULL, `hasnewversionarticles` enum('True','False') DEFAULT NULL, KEY `suppliers_with_nv_articles_idx01` (`id`), KEY `suppliers_with_nv_articles_idx02` (`description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `suppliers_with_nv_linkages` ( `id` int(11) NOT NULL, `dataversion` varchar(32) DEFAULT NULL, `description` varchar(32) DEFAULT NULL, `matchcode` varchar(32) DEFAULT NULL, `nbrofarticles` varchar(32) DEFAULT NULL, `hasnewversionarticles` enum('True','False') DEFAULT NULL, KEY `suppliers_with_nv_linkages_idx01` (`id`), KEY `suppliers_with_nv_linkages_idx02` (`description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; CREATE TABLE IF NOT EXISTS `supplier_details` ( `supplierid` int(11) NOT NULL, `addresstype` varchar(32) DEFAULT NULL, `addresstypeid` tinyint(4) DEFAULT NULL, `city1` varchar(64) DEFAULT NULL, `city2` varchar(64) DEFAULT NULL, `countrycode` varchar(32) DEFAULT NULL, `email` varchar(64) DEFAULT NULL, `fax` varchar(32) DEFAULT NULL, `homepage` varchar(64) DEFAULT NULL, `name1` varchar(64) DEFAULT NULL, `name2` varchar(64) DEFAULT NULL, `postalcodecity` varchar(12) DEFAULT NULL, `postalcodepob` varchar(12) DEFAULT NULL, `postalcodewholesaler` varchar(12) DEFAULT NULL, `postalcountrycode` varchar(4) DEFAULT NULL, `postofficebox` varchar(12) DEFAULT NULL, `street1` varchar(128) DEFAULT NULL, `street2` varchar(128) DEFAULT NULL, `telephone` varchar(64) DEFAULT NULL, KEY `supplier_details_idx01` (`supplierid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;