SQL script for create 103 tables (tables structure are according documentation Tecdoc) in Mysql database. All fields and tables use description.
Sample query for create table `001`

  CREATE TABLE IF NOT EXISTS `001` (
	`DLNR` smallint(4) NOT NULL COMMENT 'Data Supplier Number Constant (-> 100)',
	`SA` smallint(3) NOT NULL DEFAULT '1' COMMENT 'Data Table Constant = 001	',
	`DATA_RELEASE` smallint(4) NOT NULL COMMENT 'Version (Data Release) in the format xxyy',
	`DATUM` int(8) NOT NULL COMMENT 'Version date in the format YYYYMMDD',
	`KZVOLL` tinyint(1) NOT NULL DEFAULT '0' COMMENT '‘1’ when complete delivery, otherwise ‘0’',
	`KHERNR` mediumint(6) NOT NULL COMMENT 'Vehicle Manufacturer Number	',
	`MARKE` varchar(20) NOT NULL COMMENT 'Brand (specified by TecDoc)',
	`REFERENZDATEN` mediumint(4) NOT NULL COMMENT 'Reference data version in the format xxyy',
	`VORVERSION` mediumint(4) DEFAULT NULL COMMENT 'If a delta-delivery, the Data Release to which the delta refers.',
	`FORMAT` varchar(3) NOT NULL DEFAULT '2.5' COMMENT 'Constant “2.5”',
	`LOSCH_FLAG` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 = Delete all data records of the brand, otherwise ‘0’',
	PRIMARY KEY `DLNR` (`DLNR`),
	KEY `KHERNR` (`KHERNR`),
	KEY `MARKE` (`MARKE`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List suppliers with header stating version and date';

  Kit queries included :
    
  1. Selecting the desired language
  2. Selecting the desired region or country (in case available divided regions in your data)
  3. Work with cars
     3.1. Choosing a manufacturer of car (with the possibility of separation on year, passenger, truck, motocycle and commercial vehicle)
	 3.2. Choosing a model of car
	 3.2. Choosing a type of car
	 3.3. Show info about selected car	 
	 3.4. Searching by Ktype and get Ktype value regarding value KBA, TypeMine, LicensePlate [Swiss, Netherland, Swedish, Austrian] (in case available those tables in your data)
	 3.5. Seraching by code engine (list vehicles where use engine)
	 3.6. Show info about engine
  4. Work with products
	 4.1. Show available suppliers
	 4.2. Search by artnumber - checking name of brands that use this search number
	 4.3. Main info of product
	 4.4. Cryteries of product
	 4.5. Additional info of product
	 4.6. Cross reference for product (own info from supplier)
	 4.7. Cross reference for product (advanced view - searching regarding own oe-numbers for search product and searching other products where use search product)
	 4.8. Applicability to vehicles
	 4.9. Terms of use product for vehicle	 
	 4.10. Images and other links for product
	 4.11. Specification kit products or searching entry into kits
	 4.12. Accessories that need use for product (list products that not included in main product, but products that need or preferably for use parallel) 
  5. Creating catalog
	 5.1. List type of vehicles where use product
	 5.2. List products that use for selected vehicle	
	 5.3. Generate tree categories for selected vehicle
	 5.4. List products according selected category in tree categories for selected vehicle
	 5.5. Generate list trade groups for selected vehicle	 
	 5.6. List products according selected trade group for selected vehicle
  

	SAMPLE QUERY FROM FILE
		
	-- SHOW INFO PASSANGER CAR
	SET @SPRACHNR=4;  -- SELECTED ID LANG (ENGLISH)		
	SET @KTYPNR=23150; -- SELECTED TYPE CAR "VOLVO V70 III (BW) 2.5 T [200708 - 200912]"
		
	SELECT			
		T120.KTYPNR AS `KTYPNR`, 
		GET_LBEZNR(T100.LBEZNR, @SPRACHNR) AS MANUFACTURER,  -- NAME MANUFACTURER
		GET_LBEZNR(T110.LBEZNR, @SPRACHNR) AS MODEL,  -- NAME MODEL
		GET_LBEZNR(T120.LBEZNR, @SPRACHNR) AS TYPE,  -- NAME TYPE					
		T120.BJVON AS `BJVON`, 
		IFNULL(T120.BJBIS, 'to now') AS `BJBIS`, 
		IFNULL(T120.KW, '') AS `KW`, 
		IFNULL(T120.PS, '') AS `PS`, 
		IFNULL(T120.CCMSTEUER, '') AS `CCMSTEUER`, 
		IFNULL(T120.CCMTECH, '') AS `CCMTECH`, 
		IFNULL(T120.LIT, '') AS `LIT`, 
		IFNULL(T120.ZYL, '') AS `ZYL`, 
		IFNULL(T120.TUEREN, '') AS `TUEREN`, 
		IFNULL(T120.TANKINHALT, '') AS `TANKINHALT`, 
		IFNULL(T120.SPANNUNG, '') AS `SPANNUNG`, 
		IFNULL((CASE
				WHEN T120.ABS = 0 THEN 'NO'
				WHEN T120.ABS = 1 THEN 'YES'
				WHEN T120.ABS = 2 THEN 'OPTIONAL'
				WHEN T120.ABS = 9 THEN 'UNKNOWN'
				ELSE NULL
				END), '') AS `ABS`, 
		IFNULL((CASE
				WHEN T120.ASR = 0 THEN 'NO'
				WHEN T120.ASR = 1 THEN 'YES'
				WHEN T120.ASR = 2 THEN 'OPTIONAL'
				WHEN T120.ASR = 9 THEN 'UNKNOWN'
				ELSE NULL
				END), '') AS `ASR`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(80, T120.MOTART, @SPRACHNR), '') AS `MOTART`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(97, T120.KRAFTSTOFFAUFBEREITUNGSPRINZIP, @SPRACHNR), '') AS `KRAFTSTOFFAUFBEREITUNGSPRINZIP`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(82, T120.ANTRART, @SPRACHNR), '') AS `ANTRART`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(83, T120.BREMSART, @SPRACHNR), '') AS `BREMSART`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(84, T120.BREMSSYS, @SPRACHNR), '') AS `BREMSSYS`, 
		IFNULL(T120.VENTILE_BRENNRAUM, '') AS `VENTILE_BRENNRAUM`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(182, T120.KRSTOFFART, @SPRACHNR), '') AS `KRSTOFFART`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(89, T120.KATART, @SPRACHNR), '') AS `KATART`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(85, T120.GETRART, @SPRACHNR), '') AS `GETRART`, 
		IFNULL(GET_BEZNR_FOR_KEY_TABLE(86, T120.AUFBAUART, @SPRACHNR), '') AS `AUFBAUART`,
		IFNULL((SELECT 
					GROUP_CONCAT(DISTINCT T155.MCODE SEPARATOR ', ')
				FROM `125` AS T125
					JOIN `155` AS T155 ON T155.MOTNR = T125.MOTNR
				WHERE T125.KTYPNR = T120.KTYPNR), '') AS LISTENGINES
	FROM `120` AS T120		
		JOIN `110` AS T110 ON T110.KMODNR = T120.KMODNR			
		JOIN `100` AS T100 ON T100.HERNR = T110.HERNR
	WHERE T120.KTYPNR = @KTYPNR;