Реклама на нашем сайте

Конвертируем данные из нового Текдока.

Как известно, начиная с 4-го квартала 2016 года был изменен интерфейс ТекДока и методы хранения данных.
Именно поэтому старый способ ковертации ТекДока в MySQL через подключение к ODBC не работает в версиях TecDoc 4Q2016, 1Q2017, 2Q2017 и далее (в обозначениях версии Текдока используется номер квартала и год).
Обратите внимание, что в сети попадаются урезанные версии каталога автозапчастей ТекДок - без картинок. Такая версия имеет размер около 5 Гб и называется урезанной, Lite, кастрированной. Убедитесь, что вы используете полную версию на 4 DVD (размер около 30 Гб)!
Для конвертации данных из нового Текдока необходимо использовать Reflector.

0. Подготовьте сервер MySQL, создайте БД с названием, например TECDOC3Q2017 и создайте в ней следующие таблицы:


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.

 

Модули интернет магазина автозапчастей © 2018