Как известно, начиная с 4-го квартала 2016 года был изменен интерфейс ТекДока и методы хранения данных.
Именно поэтому старый способ ковертации ТекДока в MySQL через подключение к ODBC не работает в версиях TecDoc 4Q2016, 1Q2017, 2Q2017 и далее (в обозначениях версии Текдока используется номер квартала и год).
Обратите внимание, что в сети попадаются урезанные версии каталога автозапчастей ТекДок - без картинок. Такая версия имеет размер около 5 Гб и называется урезанной, Lite, кастрированной. Убедитесь, что вы используете полную версию на 4 DVD (размер около 30 Гб)!
Для конвертации данных из нового Текдока необходимо использовать Reflector.
0. Подготовьте сервер MySQL, создайте БД с названием, например TECDOC3Q2018 и создайте в ней следующие таблицы:
CREATE TABLE `all_articles` (
`supplierid` bigint(20) NOT NULL,
`datasupplierarticlenumber` varchar(128) NOT NULL,
KEY `all_articles_idx01` (`supplierid`),
KEY `all_articles_idx02` (`datasupplierarticlenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `all_articles_csv` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`supplierid` bigint(20) NOT NULL,
`datasupplierarticlenumber` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `all_articles_csv_idx01` (`supplierid`),
KEY `all_articles_csv_idx02` (`datasupplierarticlenumber`)
) ENGINE=InnoDB AUTO_INCREMENT=4336603 DEFAULT CHARSET=utf8;
CREATE TABLE `article_acc` (
`supplierId` bigint(20) NOT NULL,
`DataSupplierArticleNumber` varchar(128) NOT NULL,
`Description` varchar(128) NOT NULL,
`AccSupplierId` bigint(20) NOT NULL,
`AccDataSupplierArticleNumber` varchar(128) 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;
CREATE TABLE `article_attributes` (
`supplierid` bigint(20) NOT NULL,
`datasupplierarticlenumber` varchar(128) NOT NULL,
`id` bigint(20) NOT NULL,
`attributeinformationtype` varchar(512) NOT NULL,
`description` varchar(512) DEFAULT NULL,
`displaytitle` varchar(512) DEFAULT NULL,
`displayvalue` varchar(4096) NOT NULL,
KEY `article_attributes_idx01` (`supplierid`),
KEY `article_attributes_idx02` (`datasupplierarticlenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `article_cross` (
`manufacturerId` bigint(20) NOT NULL,
`OENbr` varchar(128) NOT NULL,
`SupplierId` bigint(20) NOT NULL,
`PartsDataSupplierArticleNumber` varchar(128) 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;
CREATE TABLE `article_images` (
`supplierId` bigint(20) NOT NULL,
`DataSupplierArticleNumber` varchar(128) NOT NULL,
`AdditionalDescription` varchar(128) NOT NULL,
`Description` varchar(128) NOT NULL,
`DocumentName` varchar(128) NOT NULL,
`DocumentType` varchar(128) NOT NULL,
`NormedDescriptionID` varchar(128) NOT NULL,
`PictureName` varchar(128) NOT NULL,
`ShowImmediately` varchar(128) NOT NULL,
KEY `article_images_idx01` (`supplierId`),
KEY `article_images_idx02` (`DataSupplierArticleNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `article_inf` (
`supplierId` bigint(20) NOT NULL,
`DataSupplierArticleNumber` varchar(128) NOT NULL,
`InformationText` text NOT NULL,
`InformationType` varchar(128) NOT NULL,
`InformationTypeKey` varchar(128) NOT NULL,
KEY `article_inf_idx01` (`supplierId`),
KEY `article_inf_idx02` (`DataSupplierArticleNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `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 `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 `article_nn` (
`supplierid` bigint(20) NOT NULL,
`datasupplierarticlenumber` varchar(128) NOT NULL,
`newnbr` varchar(128) NOT NULL,
`newsupplierid` bigint(20) NOT NULL,
`newdatasupplierarticlenumber` varchar(128) NOT NULL,
KEY `article_nn_idx01` (`supplierid`),
KEY `article_nn_idx02` (`datasupplierarticlenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `article_oe` (
`supplierid` bigint(20) NOT NULL,
`datasupplierarticlenumber` varchar(128) NOT NULL,
`IsAdditive` varchar(128) NOT NULL,
`OENbr` varchar(128) NOT NULL,
`manufacturerId` bigint(20) NOT NULL,
KEY `article_oe_idx01` (`supplierid`),
KEY `article_oe_idx02` (`datasupplierarticlenumber`),
KEY `article_oe_idx03` (`manufacturerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `article_parts` (
`supplierId` bigint(20) NOT NULL,
`DataSupplierArticleNumber` varchar(128) NOT NULL,
`Quantity` varchar(128) NOT NULL,
`PartsSupplierId` bigint(20) NOT NULL,
`PartsDataSupplierArticleNumber` varchar(128) 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;
CREATE TABLE `article_rn` (
`supplierid` bigint(20) NOT NULL,
`datasupplierarticlenumber` varchar(128) NOT NULL,
`replacenbr` varchar(128) NOT NULL,
`replacedupplierid` bigint(20) NOT NULL,
`replacedatasupplierarticlenumber` varchar(128) NOT NULL,
KEY `article_rn_idx01` (`supplierid`),
KEY `article_rn_idx02` (`datasupplierarticlenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `article_un` (
`supplierid` bigint(20) NOT NULL,
`datasupplierarticlenumber` varchar(128) NOT NULL,
`utilityno` varchar(128) NOT NULL,
KEY `article_un_idx01` (`supplierid`),
KEY `article_un_idx02` (`datasupplierarticlenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `articles` (
`supplierId` bigint(20) NOT NULL,
`DataSupplierArticleNumber` varchar(128) NOT NULL,
`ArticleStateDisplayTitle` varchar(128) NOT NULL,
`ArticleStateDisplayValue` varchar(128) NOT NULL,
`Description` varchar(128) NOT NULL,
`FlagAccessory` varchar(128) NOT NULL,
`FlagMaterialCertification` varchar(128) NOT NULL,
`FlagRemanufactured` varchar(128) NOT NULL,
`FlagSelfServicePacking` varchar(128) NOT NULL,
`FoundBy` varchar(128) NOT NULL,
`FoundString` varchar(128) NOT NULL,
`HasAxle` varchar(128) NOT NULL,
`HasCommercialVehicle` varchar(128) NOT NULL,
`HasCVManuID` varchar(128) NOT NULL,
`HasEngine` varchar(128) NOT NULL,
`HasLinkitems` varchar(128) NOT NULL,
`HasMotorbike` varchar(128) NOT NULL,
`HasPassengerCar` varchar(128) NOT NULL,
`IsValid` varchar(128) NOT NULL,
`LotSize1` varchar(128) NOT NULL,
`LotSize2` varchar(128) NOT NULL,
`NormalizedDescription` varchar(128) NOT NULL,
`PackingUnit` varchar(128) NOT NULL,
`QuantityPerPackingUnit` varchar(128) NOT NULL,
KEY `articles_idx01` (`supplierId`),
KEY `articles_idx02` (`DataSupplierArticleNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `articles_csv` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`supplierid` bigint(20) NOT NULL,
`datasupplierarticlenumber` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `articles_csv_idx01` (`supplierid`),
KEY `articles_csv_idx02` (`datasupplierarticlenumber`)
) ENGINE=InnoDB AUTO_INCREMENT=3668292 DEFAULT CHARSET=utf8;
CREATE TABLE `axle_attributes` (
`axleid` bigint(20) NOT NULL,
`attributegroup` varchar(512) DEFAULT NULL,
`attributetype` varchar(512) DEFAULT NULL,
`displaytitle` varchar(512) DEFAULT NULL,
`displayvalue` varchar(2048) DEFAULT NULL,
KEY `axle_attributes_idx01` (`axleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `axle_pds` (
`axleid` bigint(20) NOT NULL,
`nodeid` bigint(20) NOT NULL,
`productid` bigint(20) NOT NULL,
`supplierid` bigint(20) 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;
CREATE TABLE `axle_prd` (
`id` bigint(20) 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;
CREATE TABLE `axle_qsi` (
`axleid` bigint(20) NOT NULL,
`description` varchar(512) DEFAULT NULL,
`quickstarttype` varchar(512) DEFAULT NULL,
`validstate` varchar(512) DEFAULT NULL,
KEY `axle_qsi_idx01` (`axleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `axle_trees` (
`axleid` bigint(20) NOT NULL,
`searchtreeid` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL,
`parentid` bigint(20) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
KEY `axle_trees_idx01` (`axleid`),
KEY `axle_trees_idx02` (`id`),
KEY `axle_trees_idx03` (`parentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `axles` (
`id` bigint(20) NOT NULL,
`canbedisplayed` varchar(512) DEFAULT NULL,
`constructioninterval` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`fulldescription` varchar(512) DEFAULT NULL,
`haslink` varchar(512) DEFAULT NULL,
`isaxle` varchar(512) DEFAULT NULL,
`iscommercialvehicle` varchar(512) DEFAULT NULL,
`iscvmanufacturerid` varchar(512) DEFAULT NULL,
`isengine` varchar(512) DEFAULT NULL,
`ismotorbike` varchar(512) DEFAULT NULL,
`ispassengercar` varchar(512) DEFAULT NULL,
`istransporter` varchar(512) DEFAULT NULL,
`isvalidforcurrentcountry` varchar(512) DEFAULT NULL,
`linkitemtype` varchar(512) DEFAULT NULL,
`modelid` bigint(20) DEFAULT NULL,
KEY `axles_idx01` (`id`),
KEY `axles_idx02` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `commercial_driver_cabs` (
`id` bigint(20) NOT NULL,
`drivercabid` bigint(20) NOT NULL,
KEY `commercial_driver_cabs_idx01` (`id`),
KEY `commercial_driver_cabs_idx02` (`drivercabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `commercial_vehicle_attributes` (
`commercialvehicleid` bigint(20) NOT NULL,
`attributegroup` varchar(512) DEFAULT NULL,
`attributetype` varchar(512) DEFAULT NULL,
`displaytitle` varchar(512) DEFAULT NULL,
`displayvalue` varchar(2048) DEFAULT NULL,
KEY `commercial_vehicle_attributes_idx01` (`commercialvehicleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `commercial_vehicle_axles` (
`id` bigint(20) NOT NULL,
`axleid` bigint(20) NOT NULL,
KEY `commercial_vehicle_axles_idx01` (`id`),
KEY `commercial_vehicle_axles_idx02` (`axleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `commercial_vehicle_engines` (
`id` bigint(20) NOT NULL,
`engineid` bigint(20) NOT NULL,
KEY `commercial_vehicle_engines_idx01` (`id`),
KEY `commercial_vehicle_engines_idx02` (`engineid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `commercial_vehicle_pds` (
`commertialvehicleid` bigint(20) NOT NULL,
`nodeid` bigint(20) NOT NULL,
`productid` bigint(20) NOT NULL,
`supplierid` bigint(20) 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;
CREATE TABLE `commercial_vehicle_prd` (
`id` bigint(20) 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;
CREATE TABLE `commercial_vehicle_qsi` (
`commercialvehicleid` bigint(20) NOT NULL,
`description` varchar(512) DEFAULT NULL,
`quickstarttype` varchar(512) DEFAULT NULL,
`validstate` varchar(512) DEFAULT NULL,
KEY `commercial_vehicle_qsi_idx01` (`commercialvehicleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `commercial_vehicle_sub_types` (
`id` bigint(20) NOT NULL,
`subtypeid` bigint(20) NOT NULL,
KEY `commercial_vehicle_sub_types_idx01` (`id`),
KEY `commercial_vehicle_sub_types_idx02` (`subtypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `commercial_vehicle_trees` (
`commercialvehicleid` bigint(20) NOT NULL,
`searchtreeid` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL,
`parentid` bigint(20) DEFAULT NULL,
`description` varchar(512) 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;
CREATE TABLE `commercial_vehicles` (
`id` bigint(20) NOT NULL,
`canbedisplayed` varchar(512) DEFAULT NULL,
`constructioninterval` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`fulldescription` varchar(512) DEFAULT NULL,
`haslink` varchar(512) DEFAULT NULL,
`isaxle` varchar(512) DEFAULT NULL,
`iscommercialvehicle` varchar(512) DEFAULT NULL,
`iscvmanufacturerid` varchar(512) DEFAULT NULL,
`isengine` varchar(512) DEFAULT NULL,
`ismotorbike` varchar(512) DEFAULT NULL,
`ispassengercar` varchar(512) DEFAULT NULL,
`istransporter` varchar(512) DEFAULT NULL,
`isvalidforcurrentcountry` varchar(512) DEFAULT NULL,
`linkitemtype` varchar(512) DEFAULT NULL,
`modelid` bigint(20) DEFAULT NULL,
KEY `commercial_vehicles_idx01` (`id`),
KEY `commercial_vehicles_idx02` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `countries` (
`countrycode` varchar(512) DEFAULT NULL,
`currencycode` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`isgroup` varchar(512) DEFAULT NULL,
`isocode2` varchar(512) DEFAULT NULL,
`isocode3` varchar(512) DEFAULT NULL,
`isocodeno` varchar(512) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `country_groups` (
`countrycode` varchar(512) DEFAULT NULL,
`currencycode` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`isgroup` varchar(512) DEFAULT NULL,
`isocode2` varchar(512) DEFAULT NULL,
`isocode3` varchar(512) DEFAULT NULL,
`isocodeno` varchar(512) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `engine_attributes` (
`engineid` bigint(20) NOT NULL,
`attributegroup` varchar(512) DEFAULT NULL,
`attributetype` varchar(512) DEFAULT NULL,
`displaytitle` varchar(512) DEFAULT NULL,
`displayvalue` varchar(2048) DEFAULT NULL,
KEY `engine_attributes_idx01` (`engineid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `engine_pds` (
`engineid` bigint(20) NOT NULL,
`nodeid` bigint(20) NOT NULL,
`productid` bigint(20) NOT NULL,
`supplierid` bigint(20) 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;
CREATE TABLE `engine_prd` (
`id` bigint(20) 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;
CREATE TABLE `engine_qsi` (
`engineid` bigint(20) NOT NULL,
`description` varchar(512) DEFAULT NULL,
`quickstarttype` varchar(512) DEFAULT NULL,
`validstate` varchar(512) DEFAULT NULL,
KEY `engine_qsi_idx01` (`engineid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `engine_trees` (
`engineid` bigint(20) NOT NULL,
`searchtreeid` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL,
`parentid` bigint(20) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
KEY `engine_trees_idx01` (`engineid`),
KEY `engine_trees_idx02` (`id`),
KEY `engine_trees_idx03` (`parentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `engines` (
`id` bigint(20) NOT NULL,
`canbedisplayed` varchar(512) DEFAULT NULL,
`constructioninterval` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`fulldescription` varchar(512) DEFAULT NULL,
`haslink` varchar(512) DEFAULT NULL,
`haslinkitem` varchar(512) DEFAULT NULL,
`isaxle` varchar(512) DEFAULT NULL,
`iscommercialvehicle` varchar(512) DEFAULT NULL,
`iscvmanufacturerid` varchar(512) DEFAULT NULL,
`isengine` varchar(512) DEFAULT NULL,
`ismotorbike` varchar(512) DEFAULT NULL,
`ispassengercar` varchar(512) DEFAULT NULL,
`istransporter` varchar(512) DEFAULT NULL,
`isvalidforcurrentcountry` varchar(512) DEFAULT NULL,
`linkitemtype` varchar(512) DEFAULT NULL,
`manufacturerid` bigint(20) DEFAULT NULL,
`salesdescription` varchar(512) DEFAULT NULL,
KEY `engines_idx01` (`id`),
KEY `engines_idx02` (`manufacturerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `languages` (
`id` bigint(20) NOT NULL,
`codepage` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`isocode2` varchar(512) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `manufacturers` (
`id` bigint(20) NOT NULL,
`canbedisplayed` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`fulldescription` varchar(512) DEFAULT NULL,
`haslink` varchar(512) DEFAULT NULL,
`isaxle` varchar(512) DEFAULT NULL,
`iscommercialvehicle` varchar(512) DEFAULT NULL,
`iscvmanufacturerid` varchar(512) DEFAULT NULL,
`isengine` varchar(512) DEFAULT NULL,
`ismotorbike` varchar(512) DEFAULT NULL,
`ispassengercar` varchar(512) DEFAULT NULL,
`istransporter` varchar(512) DEFAULT NULL,
`isvalidforcurrentcountry` varchar(512) DEFAULT NULL,
`isvgl` varchar(512) DEFAULT NULL,
`linkitemtype` varchar(512) DEFAULT NULL,
`matchcode` varchar(512) DEFAULT NULL,
KEY `manufacturers_idx01` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `models` (
`id` bigint(20) NOT NULL,
`canbedisplayed` varchar(512) DEFAULT NULL,
`constructioninterval` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`fulldescription` varchar(512) DEFAULT NULL,
`haslink` varchar(512) DEFAULT NULL,
`isaxle` varchar(512) DEFAULT NULL,
`iscommercialvehicle` varchar(512) DEFAULT NULL,
`iscvmanufacturerid` varchar(512) DEFAULT NULL,
`isengine` varchar(512) DEFAULT NULL,
`ismotorbike` varchar(512) DEFAULT NULL,
`ispassengercar` varchar(512) DEFAULT NULL,
`istransporter` varchar(512) DEFAULT NULL,
`isvalidforcurrentcountry` varchar(512) DEFAULT NULL,
`linkitemtype` varchar(512) DEFAULT NULL,
`manufacturerid` bigint(20) DEFAULT NULL,
KEY `models_idx01` (`id`),
KEY `models_idx02` (`manufacturerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `motorbike_attributes` (
`motorbikeid` bigint(20) NOT NULL,
`attributegroup` varchar(512) DEFAULT NULL,
`attributetype` varchar(512) DEFAULT NULL,
`displaytitle` varchar(512) DEFAULT NULL,
`displayvalue` varchar(2048) DEFAULT NULL,
KEY `motorbike_attributes_idx01` (`motorbikeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `motorbike_pds` (
`motorbikeid` bigint(20) NOT NULL,
`nodeid` bigint(20) NOT NULL,
`productid` bigint(20) NOT NULL,
`supplierid` bigint(20) 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;
CREATE TABLE `motorbike_prd` (
`id` bigint(20) 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;
CREATE TABLE `motorbike_qsi` (
`motorbikeid` bigint(20) NOT NULL,
`description` varchar(512) DEFAULT NULL,
`quickstarttype` varchar(512) DEFAULT NULL,
`validstate` varchar(512) DEFAULT NULL,
KEY `motorbike_qsi_idx01` (`motorbikeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `motorbike_trees` (
`motorbikeid` bigint(20) NOT NULL,
`searchtreeid` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL,
`parentid` bigint(20) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
KEY `motorbike_trees_idx01` (`motorbikeid`),
KEY `motorbike_trees_idx02` (`id`),
KEY `motorbike_trees_idx03` (`parentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `motorbikes` (
`id` bigint(20) NOT NULL,
`canbedisplayed` varchar(512) DEFAULT NULL,
`constructioninterval` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`fulldescription` varchar(512) DEFAULT NULL,
`haslink` varchar(512) DEFAULT NULL,
`isaxle` varchar(512) DEFAULT NULL,
`iscommercialvehicle` varchar(512) DEFAULT NULL,
`iscvmanufacturerid` varchar(512) DEFAULT NULL,
`isengine` varchar(512) DEFAULT NULL,
`ismotorbike` varchar(512) DEFAULT NULL,
`ispassengercar` varchar(512) DEFAULT NULL,
`istransporter` varchar(512) DEFAULT NULL,
`isvalidforcurrentcountry` varchar(512) DEFAULT NULL,
`linkitemtype` varchar(512) DEFAULT NULL,
`modelid` bigint(20) DEFAULT NULL,
KEY `motorbikes_idx01` (`id`),
KEY `motorbikes_idx02` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `passanger_car_attributes` (
`passangercarid` bigint(20) NOT NULL,
`attributegroup` varchar(512) DEFAULT NULL,
`attributetype` varchar(512) DEFAULT NULL,
`displaytitle` varchar(512) DEFAULT NULL,
`displayvalue` varchar(2048) DEFAULT NULL,
KEY `passanger_car_attributes_idx01` (`passangercarid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `passanger_car_engines` (
`id` bigint(20) NOT NULL,
`engineid` bigint(20) NOT NULL,
KEY `passanger_car_engines_idx01` (`id`),
KEY `passanger_car_engines_idx02` (`engineid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `passanger_car_pds` (
`passangercarid` bigint(20) NOT NULL,
`nodeid` bigint(20) NOT NULL,
`productid` bigint(20) NOT NULL,
`supplierid` bigint(20) 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 `passanger_car_prd` (
`id` bigint(20) 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;
CREATE TABLE `passanger_car_qsi` (
`passangercarid` bigint(20) NOT NULL,
`description` varchar(512) DEFAULT NULL,
`quickstarttype` varchar(512) DEFAULT NULL,
`validstate` varchar(512) DEFAULT NULL,
KEY `passanger_car_qsi_idx01` (`passangercarid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `passanger_car_trees` (
`passangercarid` bigint(20) NOT NULL,
`searchtreeid` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL,
`parentid` bigint(20) DEFAULT NULL,
`description` varchar(512) 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;
CREATE TABLE `passanger_cars` (
`id` bigint(20) NOT NULL,
`canbedisplayed` varchar(512) DEFAULT NULL,
`constructioninterval` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`fulldescription` varchar(512) DEFAULT NULL,
`haslink` varchar(512) DEFAULT NULL,
`isaxle` varchar(512) DEFAULT NULL,
`iscommercialvehicle` varchar(512) DEFAULT NULL,
`iscvmanufacturerid` varchar(512) DEFAULT NULL,
`isengine` varchar(512) DEFAULT NULL,
`ismotorbike` varchar(512) DEFAULT NULL,
`ispassengercar` varchar(512) DEFAULT NULL,
`istransporter` varchar(512) DEFAULT NULL,
`isvalidforcurrentcountry` varchar(512) DEFAULT NULL,
`linkitemtype` varchar(512) DEFAULT NULL,
`modelid` bigint(20) DEFAULT NULL,
KEY `passanger_cars_idx01` (`id`),
KEY `passanger_cars_idx02` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `prd` (
`id` bigint(20) 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;
CREATE TABLE `supplier_details` (
`supplierid` bigint(20) NOT NULL,
`addresstype` varchar(512) DEFAULT NULL,
`addresstypeid` varchar(512) DEFAULT NULL,
`city1` varchar(512) DEFAULT NULL,
`city2` varchar(512) DEFAULT NULL,
`countrycode` varchar(512) DEFAULT NULL,
`email` varchar(512) DEFAULT NULL,
`fax` varchar(512) DEFAULT NULL,
`homepage` varchar(512) DEFAULT NULL,
`name1` varchar(512) DEFAULT NULL,
`name2` varchar(512) DEFAULT NULL,
`postalcodecity` varchar(512) DEFAULT NULL,
`postalcodepob` varchar(512) DEFAULT NULL,
`postalcodewholesaler` varchar(512) DEFAULT NULL,
`postalcountrycode` varchar(512) DEFAULT NULL,
`postofficebox` varchar(512) DEFAULT NULL,
`street1` varchar(512) DEFAULT NULL,
`street2` varchar(512) DEFAULT NULL,
`telephone` varchar(512) DEFAULT NULL,
KEY `supplier_details_idx01` (`supplierid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `suppliers` (
`id` bigint(20) NOT NULL,
`dataversion` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`matchcode` varchar(512) DEFAULT NULL,
`nbrofarticles` varchar(512) DEFAULT NULL,
`hasnewversionarticles` varchar(512) DEFAULT NULL,
KEY `suppliers_idx01` (`id`),
KEY `suppliers_idx02` (`description`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `suppliers_with_nv_articles` (
`id` bigint(20) NOT NULL,
`dataversion` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`matchcode` varchar(512) DEFAULT NULL,
`nbrofarticles` varchar(512) DEFAULT NULL,
`hasnewversionarticles` varchar(512) DEFAULT NULL,
KEY `suppliers_with_nv_articles_idx01` (`id`),
KEY `suppliers_with_nv_articles_idx02` (`description`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `suppliers_with_nv_linkages` (
`id` bigint(20) NOT NULL,
`dataversion` varchar(512) DEFAULT NULL,
`description` varchar(512) DEFAULT NULL,
`matchcode` varchar(512) DEFAULT NULL,
`nbrofarticles` varchar(512) DEFAULT NULL,
`hasnewversionarticles` varchar(512) DEFAULT NULL,
KEY `suppliers_with_nv_linkages_idx01` (`id`),
KEY `suppliers_with_nv_linkages_idx02` (`description`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1. Установите оригинальный Текдок 3Q2017 (потребуется около 30 Гб на жестком диске вашего компьютера). Возможно, вам придется использовать эмулятор DVD - рекомендуется к использованию бесплатный эмулятор DAEMON Tools Lite.
2. Установите Reflector.
3. Запустите Reflector, укажите адрес установки каталога автозапчастей ТекДок и проведите конвертацию данных в формат csv.