New description file to create tables and sql-queries
Новый файл описания создания таблиц и sql-запросов
http://ttc.bovsoft.com/download/example/democatalog/readme.txt
-------------------------



/*
===========================================================================
=============================== ENGLISH ===================================
===========================================================================
*/

/* This example is used to import the data into the database MySQL.
=====================================================================

1. Create an empty database, for example TTC.
2. Optimization database. Specify the type of database, I recommend using InnoDB. Adjust the optimum size of the buffer and cache for the database.
3. The script creates a table in the database. Select tables will share two options needs:
	=> need only cross-reference (search for analogues of spare parts). Need tables :
		- table brand manufacturers of spare parts and OEM manufacturers [TableBrands]
		- table data spare parts [MainTableParts]
		- table specifications of spare parts [TableSpecificationsParts]
		- table cross-reference code parts [TablePartsCrossReference]
		- table information for spare parts [EXPORTADDITION_ARTINFO]	
		provided that should be displayed the applicability cars for car spare parts, needed additional tables :
		- table data of vehicles  [TableCars]
			- table linking of spare parts [LinkedTableParts] and table linking of vehicles [LinkedTableCars]
			OR
			- table linking EXPORTADDITION_TYPID_ARTID --- > ([TTC_TYP_ID]=>[TTC_ART_ID])
	=> need to create catalog  search parts for the selected vehicle. Need tables :
		- table brand manufacturers of spare parts and OEM manufacturers [TableBrands]
		- table data spare parts [MainTableParts]
		- table specifications of spare parts [TableSpecificationsParts]
		- table cross-reference code parts [TablePartsCrossReference]	
		- table information for spare parts [EXPORTADDITION_ARTINFO]	
		- table data of vehicles [TableCars]
			Catalog  search parts for the selected vehicle have the opportunity to create with :
			- with one group table [TableUsedPartsForCars] or [TableUsedCarsForParts]
			or
			- with help tables of related together (different from the group table smaller total size)	
				- table tree product categories [TableTreeProductGroup]
				- linking of group table parts and groups of vehicles with respect to the category tree [TableLinkGroupsCarsAndParts]
				- table linking of spare parts [LinkedTableParts]
				- table linking of vehicles [LinkedTableCars]
				- table containing condition for application details to the car [EXPORTADDITION_TERMSOFUSE] --- > ([ART_ID]=>[TYP_ID]=>[TERMS OF USE])
				OR with help table :
				- table linking EXPORTADDITION_TYPID_ARTID --- > ([TTC_TYP_ID]=>[TTC_ART_ID])
				- table linking EXPORTADDITION_TYPID_SRTID --- > ([TTC_TYP_ID]=>[STR_ID])
				- table linking EXPORTADDITION_ARTID_SRTID --- > ([TTC_ART_ID]=>[STR_ID])	
				- table containing condition for application details to the car [EXPORTADDITION_TERMSOFUSE] --- > ([ART_ID]=>[TYP_ID]=>[TERMS OF USE])
*/	

/* 
=====================================================================	
Description of the fields table, see :
	[http://ttc.bovsoft.com/download/readme_eng.doc](английский) */
				
/*
===========================================================================
=============================== РУССКИЙ ===================================
===========================================================================
*/	
	
/* Данный пример используется при импорте данных в базу данных MySQL.
=====================================================================

1. Создать пустую базу данных, например TTC.
2. Оптимизация базы. Выберите тип базы, рекомендую использовать InnoDB. Настройте оптимальные размеры буфера и кеша базы.		
3. Скриптом создайте таблицы в базе данных. Выбор таблиц поделяю на два варианты потребности :
	=> потребность только в кроссах (поиск аналогов запчастей). Нужны таблицы :
		- таблица брендов изготовителей запчастей и OEM изготовителей [TableBrands]
		- таблица данных запчастей [MainTableParts]
		- таблица спецификации запчастей [TableSpecificationsParts]
		- таблица кросс переходов [TablePartsCrossReference]
		- таблица дополнительной информации запчасти [EXPORTADDITION_ARTINFO]
		при условии что дополнительно надо отображать применяемость автомобиля к запчасти, дополнительно нужны таблицы :
		- таблица данных автомобилей [TableCars]
			- линковочная таблица запчастей [LinkedTableParts] и линковочная таблица автомобилей [LinkedTableCars]
			ИЛИ
			- линковочная таблица EXPORTADDITION_TYPID_ARTID --- > ([TTC_TYP_ID]=>[TTC_ART_ID])
	=> потребность в создание сервиса поиска запчасти по данным автомобиля. Нужны таблицы :
		- таблица брендов изготовителей запчастей и OEM изготовителей [TableBrands]
		- таблица данных запчастей [MainTableParts]
		- таблица спецификации запчастей [TableSpecificationsParts]
		- таблица кросс переходов [TablePartsCrossReference]
		- таблица дополнительной информации запчасти [EXPORTADDITION_ARTINFO]		
		- таблица данных автомобилей [TableCars]
			Каталог поиска запчасти по данным автомобиля есть возможность создать с помощью :
			- с помощью одной групповой таблицы [TableUsedPartsForCars] или [TableUsedCarsForParts]
			или
			- с помощью таблиц связаних между собой (отличается от групповой таблицы меньшим суммарным размером)	
				- таблица дерева тованых категорий [TableTreeProductGroup]
				- связующая таблица групп запчастей и групп автомобилей относительно дерева категорий [TableLinkGroupsCarsAndParts]
				- линковочная таблица запчастей [LinkedTableParts]
				- линковочная таблица автомобилей [LinkedTableCars]
				- таблица условий использования запчасти на автомобиль [EXPORTADDITION_TERMSOFUSE] --- > ([ART_ID]=>[TYP_ID]=>[TERMS OF USE])
				ИЛИ с помощью таблиц :
				- линковочная таблица EXPORTADDITION_TYPID_ARTID --- > ([TTC_TYP_ID]=>[TTC_ART_ID])
				- линковочная таблица EXPORTADDITION_TYPID_SRTID --- > ([TTC_TYP_ID]=>[STR_ID])
				- линковочная таблица EXPORTADDITION_ARTID_SRTID --- > ([TTC_ART_ID]=>[STR_ID])
				- таблица условий использования запчасти на автомобиль [EXPORTADDITION_TERMSOFUSE] --- > ([ART_ID]=>[TYP_ID]=>[TERMS OF USE])
*/	

/* 
=====================================================================	
Описание полей таблиц смотрите :
	[http://ttc.bovsoft.com/download/readme_rus.doc](русский) */	
	
/* 
ENGLISH
=====================================================================	
Scripts to create the tables. Select the tables that are needed for your needs.
Specify the type of database and CHARSET, for example : 

ENGINE=InnoDB;
CHARSET=utf8;

РУССКИЙ
=====================================================================	
Описание скриптов для создания таблиц. Выберите те таблицы которые нужны для вашей потребности.
Укажите тип базы и CHARSET, для примера : 

ENGINE=InnoDB;
CHARSET=utf8;
*/

/* 
ENGLISH
=====================================================================	
table brand manufacturers of spare parts and OEM manufacturers

РУССКИЙ
=====================================================================	
таблица брендов изготовителей запчастей и OEM изготовителей	  */
	
DROP TABLE IF EXISTS `TABLEBRANDS`;
CREATE TABLE `TABLEBRANDS` (
   `BRAND` varchar(60) NOT NULL, 
   `ADDITIONAL_DATA` text, 
   `TTC_SUP_ID` smallint(6) NOT NULL, 
   `TTC_BRA_ID` smallint(6) NOT NULL, 
   KEY `TTC_BRA_ID` (`TTC_BRA_ID`),
   KEY `BRAND` (`BRAND`),
   KEY `TTC_SUP_ID` (`TTC_SUP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table data of vehicles

РУССКИЙ
=====================================================================
таблица данных автомобилей  */

DROP TABLE IF EXISTS `TABLECARS`;
CREATE TABLE `TABLECARS` (
   `CAR_BRANDS` varchar(60) NOT NULL, 
   `MODEL_CAR` varchar(200) NOT NULL, 
   `TYP_CAR` varchar(200) NOT NULL, 
   `BODY_TYPE` varchar(60) DEFAULT NULL, 
   `OF_THE_YEAR` int(11) DEFAULT NULL, 
   `UP_TO_A_YEAR` int(11) DEFAULT NULL, 
   `KV` int(11) DEFAULT NULL, 
   `PM` int(11) DEFAULT NULL, 
   `CC` int(11) DEFAULT NULL, 
   `TECHNICAL_INFORMATION` text, 
   `TTC_TYP_ID` int(11) NOT NULL, 
   PRIMARY KEY (`TTC_TYP_ID`),
   KEY `CAR_BRANDS` (`CAR_BRANDS`),
   KEY `MODEL_CAR` (`MODEL_CAR`),
   KEY `TYP_CAR` (`TYP_CAR`),
   KEY `OF_THE_YEAR` (`OF_THE_YEAR`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table the criteria of cars in file line by line (criterion name and its value, one per line)

РУССКИЙ
=====================================================================
таблица характеристик (критерии) автомобилей розгруппированных построчно (название критерия и его величина по одному на строку)  */

DROP TABLE IF EXISTS `TABLECARSCRI`;
CREATE TABLE `TABLECARSCRI` (
   `TTC_TYP_ID` int(11) NOT NULL, 
   `CAR_BRANDS` varchar(60) NOT NULL, 
   `MODEL_CAR` varchar(200) NOT NULL, 
   `TYP_CAR` varchar(200) NOT NULL, 
   `NAMECRITERIA` varchar(300) DEFAULT NULL, 
   `VALUECRITERIA` varchar(300) DEFAULT NULL, 
   KEY `TTC_TYP_ID` (`TTC_TYP_ID`),
   KEY `NAMECRITERIA` (`NAMECRITERIA`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table data of spare parts

РУССКИЙ
=====================================================================
таблица данных запчастей  */

DROP TABLE IF EXISTS `MAINTABLEPARTS`;
CREATE TABLE `MAINTABLEPARTS` (
   `NAME_PARTS` varchar(300) NOT NULL, 
   `BRAND` varchar(60) NOT NULL, 
   `CODE_PART` varchar(105) NOT NULL, 
   `CODE_PARTS_ADVANCED` varchar(150) NOT NULL, 
   `EAN` varchar(13) DEFAULT NULL, 
   `STATUSPRODUCT` varchar(300) DEFAULT NULL, 
   `NAME_IMAGE` varchar(300) DEFAULT NULL, 
   `TTC_ART_ID` int(11) NOT NULL, 
   /* `ADDITIONAL_DATA` text, -- if necessary */	
   /* `ART_CROSS` text, -- if necessary */	
   PRIMARY KEY (`TTC_ART_ID`),
   KEY `BRAND` (`BRAND`),
   KEY `CODE_PART` (`CODE_PART`),
   KEY `EAN` (`EAN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table the criteria of spare parts in file line by line (criterion name and its value, one per line)

РУССКИЙ
=====================================================================
таблица характеристик (критерии) запчастей розгруппированных построчно (название критерия и его величина по одному на строку)  */

DROP TABLE IF EXISTS `MAINTABLEPARTSCRI`;
CREATE TABLE `MAINTABLEPARTSCRI` (
   `TTC_ART_ID` int(11) NOT NULL, 
   `BRAND` varchar(60) NOT NULL, 
   `CODE_PART` varchar(105) NOT NULL, 
   `CODE_PARTS_ADVANCED` varchar(150) NOT NULL, 
   `NAMECRITERIA` varchar(300) DEFAULT NULL, 
   `VALUECRITERIA` varchar(300) DEFAULT NULL, 
   KEY `TTC_ART_ID` (`TTC_ART_ID`),
   KEY `NAMECRITERIA` (`NAMECRITERIA`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table specifications of spare parts

РУССКИЙ
=====================================================================
таблица спецификации запчастей  */

DROP TABLE IF EXISTS `TABLESPECIFICATIONSPARTS`;
CREATE TABLE `TABLESPECIFICATIONSPARTS` (
   `mainTTC_ART_ID` int(11) NOT NULL, 
   `mainART_BRANDS` varchar(60) NOT NULL, 
   `mainART_CODE_PARTS` varchar(105) NOT NULL, 
   `TTC_ART_ID` int(11) NOT NULL, 
   `BRANDS` varchar(60) NOT NULL, 
   `CODE_PARTS` varchar(105) NOT NULL, 
   `QUANTITY` smallint(6) DEFAULT 0, 
   PRIMARY KEY (`mainTTC_ART_ID`, `TTC_ART_ID`, `QUANTITY`),
   KEY `mainART_CODE_PARTS` (`mainART_CODE_PARTS`),
   KEY `mainART_BRANDS` (`mainART_BRANDS`),
   KEY `BRANDS` (`BRANDS`),
   KEY `CODE_PARTS` (`CODE_PARTS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table cross-reference code parts

РУССКИЙ
=====================================================================
таблица кросс переходов  */

DROP TABLE IF EXISTS `TABLEPARTSCROSSREFERENCE`;
CREATE TABLE `TABLEPARTSCROSSREFERENCE` (
   /* `NAME_PARTS` varchar(300) NOT NULL,  -- if necessary */	
   `mainART_BRANDS` varchar(60) NOT NULL, 
   `mainART_CODE_PARTS` varchar(105) NOT NULL, 
   `TTC_ART_ID` int(11) NOT NULL, 
   `BRANDS` varchar(60) DEFAULT NULL, 
   `CODE_PARTS` varchar(105) NOT NULL, 
   `CODE_PARTS_ADVANCED` varchar(150) NOT NULL, 
   `KIND` smallint(6) DEFAULT NULL, 
   /* `crossTTC_ART_ID` int(11) DEFAULT NULL,   -- if necessary */	
   /*PRIMARY KEY (`TTC_ART_ID`, `BRANDS`, `CODE_PARTS_ADVANCED`),*/
   /* KEY `mainART_CODE_PARTS` (`mainART_CODE_PARTS`),
   KEY `mainART_BRANDS` (`mainART_BRANDS`), */
   KEY `TTC_ART_ID` (`TTC_ART_ID`),
   KEY `CODE_PARTS` (`CODE_PARTS`),
   KEY `CODE_PARTS_ADVANCED` (`CODE_PARTS_ADVANCED`),
   KEY `BRANDS` (`BRANDS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
replacement table old part numbers to the new [NEW_ART_ID] = [OLD_ART_ID]

РУССКИЙ
=====================================================================
Таблица замен старых торговых номеров на новые [NEW_ART_ID] = [OLD_ART_ID]  */		  
		  
DROP TABLE IF EXISTS `EXPORTADDITION_NEWOLDART`;
CREATE TABLE `EXPORTADDITION_NEWOLDART` (
   `NEW_ART_ID` int(11) NOT NULL, 
   `OLD_ART_ID` int(11) NOT NULL, 
   PRIMARY KEY (`NEW_ART_ID`, `OLD_ART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
          
/* 
ENGLISH
=====================================================================	
table tree product categories

РУССКИЙ
=====================================================================
таблица дерева тованых категорий [TableTreeProductGroup] */		  
		  
DROP TABLE IF EXISTS `TABLETREEPRODUCTGROUP`;
CREATE TABLE `TABLETREEPRODUCTGROUP` (
   `STR_ID` int(11) NOT NULL, 
   `STR_ID_PARENT` int(11) NOT NULL, 
   `STR_TYPE` smallint(6) DEFAULT NULL, 
   `STR_LEVEL` smallint(6) DEFAULT NULL, 
   `STR_TEXT` varchar(300) NOT NULL, 
   PRIMARY KEY (`STR_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
linking of group table parts and groups of vehicles with respect to the category tree

РУССКИЙ
=====================================================================
связующая таблица групп запчастей и групп автомобилей относительно дерева категорий [TableLinkGroupsCarsAndParts] */

DROP TABLE IF EXISTS `TABLELINKGROUPSCARSANDPARTS`;
CREATE TABLE `TABLELINKGROUPSCARSANDPARTS` (
   `LGS_STR_ID` int(11) NOT NULL, 
   `LGS_GA_ID` int(11) NOT NULL, 
   PRIMARY KEY (`LGS_GA_ID`, `LGS_STR_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table linking of spare parts

РУССКИЙ
=====================================================================
линковочная таблица запчастей [LinkedTableParts] */

DROP TABLE IF EXISTS `LINKEDTABLEPARTS`;
CREATE TABLE `LINKEDTABLEPARTS` (
   `LA_ART_ID` int(11) NOT NULL, 
   `LA_ID` int(11) NOT NULL, 
   `LA_GA_ID` int(11) NOT NULL, 
   PRIMARY KEY (`LA_ART_ID`, `LA_GA_ID`, `LA_ID`),
   KEY `LA_ID` (`LA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


/* 
ENGLISH
=====================================================================	
table linking of spare parts to commodity groups

РУССКИЙ
=====================================================================
линковочная таблица запчастей к товарным группам [LINKEDTABLEPARTTOGA] */

DROP TABLE IF EXISTS `LINKEDTABLEPARTTOGA`;
CREATE TABLE `LINKEDTABLEPARTTOGA` (
   `LA_ART_ID` int(11) NOT NULL, 
   `LA_GA_ID` int(11) NOT NULL, 
   PRIMARY KEY (`LA_ART_ID`, `LA_GA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table linking of vehicles

РУССКИЙ
=====================================================================
линковочная таблица автомобилей [LinkedTableCars]	 */

DROP TABLE IF EXISTS `LINKEDTABLECARS`;
CREATE TABLE `LINKEDTABLECARS` (
   `LAT_TYP_ID` int(11) NOT NULL, 
   `LAT_LA_ID` int(11) NOT NULL, 
   `LAT_GA_ID` int(11) NOT NULL, 
   PRIMARY KEY (`LAT_TYP_ID`, `LAT_GA_ID`, `LAT_LA_ID`),
   KEY `LAT_LA_ID` (`LAT_LA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
group table use, relative to the vehicle

РУССКИЙ
=====================================================================
групповая таблица [TableUsedPartsForCars] применяемости, относительно автомобиля
 */

DROP TABLE IF EXISTS `TABLEUSEDPARTSFORCARS`;
CREATE TABLE `TABLEUSEDPARTSFORCARS` (
   `TTC_TYP_ID` int(11) NOT NULL, 
   `CAR_BRAND` varchar(60) NOT NULL, 
   `CAR_MODEL` varchar(200) NOT NULL, 
   `CAR_TYP` varchar(200) NOT NULL, 
   `CAR_BODY` varchar(60) DEFAULT NULL, 
   `CAR_OF_YEAR` int(11) DEFAULT NULL, 
   `CAR_TO_YEAR` int(11) DEFAULT NULL, 
   `CAR_KW` int(11) DEFAULT NULL, 
   `CAR_PM` int(11) DEFAULT NULL, 
   `CAR_CC` int(11) DEFAULT NULL, 
   `CAR_INFO` text, 
   `TTC_ART_ID` int(11) NOT NULL, 
   `ART_NAME` varchar(300) NOT NULL, 
   `ART_BRAND` varchar(60) NOT NULL, 
   `ART_CODE_1` varchar(105) NOT NULL, 
   `ART_CODE_2` varchar(150) NOT NULL, 
   `ART_EAN` varchar(13) DEFAULT NULL, 
   `ART_NAME_IMAGE` varchar(300) DEFAULT NULL, 
   `PARTS_INFO` text, 
   `TERMS_OF_USE` text, 
   `ART_CROSS` text, 
   `TTC_GA_ID` int(11) NOT NULL, 
   `GA_NAME` varchar(500) NOT NULL, 
   `GA_STANDARD` varchar(500) DEFAULT NULL, 
   `GA_ASSEMBLY` varchar(500) DEFAULT NULL, 
   `GA_INTENDED` varchar(500) DEFAULT NULL, 
   PRIMARY KEY (`TTC_TYP_ID`, `TTC_ART_ID`, `TTC_GA_ID`),
   KEY `CAR_BRAND` (`CAR_BRAND`),
   KEY `ART_BRAND` (`ART_BRAND`),
   KEY `ART_CODE_1` (`ART_CODE_1`),
   KEY `GA_NAME` (`GA_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


/* 
ENGLISH
=====================================================================	
group table use, relative to the spare parts

РУССКИЙ
=====================================================================
групповая таблица [TableUsedCarsForParts] применяемости, относительно артикула запчасти
 */

DROP TABLE IF EXISTS `TABLEUSEDCARSFORPARTS`;
CREATE TABLE `TABLEUSEDCARSFORPARTS` (
   `TTC_ART_ID` int(11) NOT NULL, 
   `ART_NAME` varchar(300) NOT NULL, 
   `ART_BRAND` varchar(60) NOT NULL, 
   `ART_CODE_1` varchar(105) NOT NULL, 
   `ART_CODE_2` varchar(150) NOT NULL, 
   `ART_EAN` varchar(13) DEFAULT NULL, 
   `ART_NAME_IMAGE` varchar(300) DEFAULT NULL, 
   `PARTS_INFO` text, 
   `TERMS_OF_USE` text, 
   `ART_CROSS` text, 
   `TTC_TYP_ID` int(11) NOT NULL, 
   `CAR_BRAND` varchar(60) NOT NULL, 
   `CAR_MODEL` varchar(200) NOT NULL, 
   `CAR_TYP` varchar(200) NOT NULL, 
   `CAR_BODY` varchar(60) DEFAULT NULL, 
   `CAR_OF_YEAR` int(11) DEFAULT NULL, 
   `CAR_TO_YEAR` int(11) DEFAULT NULL, 
   `CAR_KW` int(11) DEFAULT NULL, 
   `CAR_PM` int(11) DEFAULT NULL, 
   `CAR_CC` int(11) DEFAULT NULL, 
   `CAR_INFO` text, 
   PRIMARY KEY (`TTC_ART_ID`, `TTC_TYP_ID`),
   KEY `ART_BRAND` (`ART_BRAND`),
   KEY `ART_CODE_1` (`ART_CODE_1`),
   KEY `CAR_BRAND` (`CAR_BRAND`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


/* *****************************************************************************
*******************************************************************************
*******************************************************************************
ENGLISH
=====================================================================	
Additional tables

РУССКИЙ
=====================================================================
Дополнительные таблицы
*******************************************************************************
*******************************************************************************
*******************************************************************************
*/

/* 
ENGLISH
=====================================================================	
Linking table spare parts to the tree commodity groups   [TTC_ART_ID]=>[STR_ID]

РУССКИЙ
=====================================================================
Ликовочная таблица запчастей к дереву сборочной группы   [TTC_ART_ID]=>[STR_ID]  */

DROP TABLE IF EXISTS `EXPORTADDITION_ARTID_SRTID`;
CREATE TABLE `EXPORTADDITION_ARTID_SRTID` (
   `TTC_ART_ID` int(11) NOT NULL, 
   `STR_ID` int(11) NOT NULL, 
   PRIMARY KEY (`TTC_ART_ID`, `STR_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
Linking table cars to the tree commodity groups   [TTC_TYP_ID]=>[STR_ID]

РУССКИЙ
=====================================================================
Ликовочная таблица автомобилей к дереву сборочной группы   [TTC_TYP_ID]=>[STR_ID]  */

DROP TABLE IF EXISTS `EXPORTADDITION_TYPID_SRTID`;
CREATE TABLE `EXPORTADDITION_TYPID_SRTID` (
   `TTC_TYP_ID` int(11) NOT NULL, 
   `STR_ID1` int(11) DEFAULT NULL, 
   `TEXT1` varchar(300) DEFAULT NULL, 
   `STR_ID2` int(11) DEFAULT NULL, 
   `TEXT2` varchar(300) DEFAULT NULL, 
   `STR_ID3` int(11) DEFAULT NULL, 
   `TEXT3` varchar(300) DEFAULT NULL, 
   `STR_ID4` int(11) DEFAULT NULL, 
   `TEXT4` varchar(300) DEFAULT NULL, 
   `STR_ID5` int(11) DEFAULT NULL, 
   `TEXT5` varchar(300) DEFAULT NULL, 
   PRIMARY KEY (`TTC_TYP_ID`, `STR_ID1`, `STR_ID2`, `STR_ID3`, `STR_ID4`, `STR_ID5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
Linking table cars to the article of spare parts   [TTC_TYP_ID]=>[TTC_ART_ID]

РУССКИЙ
=====================================================================
Ликовочная таблица автомобилей к артикулам запчастей   [TTC_TYP_ID]=>[TTC_ART_ID]  */

DROP TABLE IF EXISTS `EXPORTADDITION_TYPID_ARTID`;
CREATE TABLE `EXPORTADDITION_TYPID_ARTID` (
   `TTC_TYP_ID` int(11) NOT NULL, 
   `TTC_ART_ID` int(11) NOT NULL, 
   PRIMARY KEY (`TTC_TYP_ID`, `TTC_ART_ID`),
   KEY `TTC_ART_ID` (`TTC_ART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
Table numbers KBA (Key number), for German [EXPORTADDITION_KBA]

РУССКИЙ
=====================================================================
Таблица номеров ключей KBA (Key number), for German [EXPORTADDITION_KBA]  */

DROP TABLE IF EXISTS `EXPORTADDITION_KBA`;
CREATE TABLE `EXPORTADDITION_KBA` (
   `TTC_TYP_ID` int(11) NOT NULL, 
   `KEYNUMBER` varchar(60) NOT NULL, 
   PRIMARY KEY (`TTC_TYP_ID`, `KEYNUMBER`),
   KEY `KEYNUMBER` (`KEYNUMBER`(12))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
Table numbers Mime types (Cartes Grises), for France [EXPORTADDITION_MIME]

РУССКИЙ
=====================================================================
Таблица номеров ключей Mime types (Cartes Grises), for France [EXPORTADDITION_MIME]  */

DROP TABLE IF EXISTS `EXPORTADDITION_MIME`;
CREATE TABLE `EXPORTADDITION_MIME` (
   `TTC_TYP_ID` int(11) NOT NULL, 
   `KEYNUMBER` varchar(60) NOT NULL, 
   PRIMARY KEY (`TTC_TYP_ID`, `KEYNUMBER`),
   KEY `KEYNUMBER` (`KEYNUMBER`(12))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
Table numbers able numbers NumberPlate [NL], for Netherlands [EXPORTADDITION_NPLATE]

РУССКИЙ
=====================================================================
Таблица номеров ключей able numbers NumberPlate [NL], for Netherlands [EXPORTADDITION_NPLATE]  */

DROP TABLE IF EXISTS `EXPORTADDITION_NPLATE`;
CREATE TABLE `EXPORTADDITION_NPLATE` (
   `TTC_TYP_ID` int(11) NOT NULL, 
   `KEYNUMBER` varchar(60) NOT NULL, 
   PRIMARY KEY (`TTC_TYP_ID`, `KEYNUMBER`),
   KEY `KEYNUMBER` (`KEYNUMBER`(12))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table link [ART_ID]=>[TYP_ID]=>[TERMS OF USE] - Table containing condition for application details to the car.

РУССКИЙ
=====================================================================
Линковочная таблица [ART_ID]=>[TYP_ID]=>[TERMS OF USE] - Таблица условий использования запчасти на автомобиль.  */

DROP TABLE IF EXISTS `EXPORTADDITION_TERMSOFUSE`;
CREATE TABLE `EXPORTADDITION_TERMSOFUSE` (
   `TTC_ART_ID` int(11) NOT NULL, 
   `TTC_TYP_ID` int(11) NOT NULL, 
   `TERMS_OF_USE` text, 
   KEY `TTC_ART_ID` (`TTC_ART_ID`),
   KEY `TTC_TYP_ID` (`TTC_TYP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
table link [ART_ID]=>[TYP_ID]=>[TERMS OF USE] - Table containing condition for application details to the car (data placed in separate columns: name criterion and its value ).

РУССКИЙ
=====================================================================
Линковочная таблица [ART_ID]=>[TYP_ID]=>[TERMS OF USE] - Таблица условий использования запчасти на автомобиль (данные размещены в отдельных колонках : название критерия и его значение).  */

DROP TABLE IF EXISTS `EXPORTADDITION_TERMSOFUSECRI`;
CREATE TABLE `EXPORTADDITION_TERMSOFUSECRI` (
   `TTC_ART_ID` int(11) NOT NULL, 
   `TTC_TYP_ID` int(11) NOT NULL, 
   `NAME_TERMS_OF_USE` varchar(300) DEFAULT NULL, 
   `VALUE_TERMS_OF_USE` varchar(300) DEFAULT NULL,
   KEY `TTC_ART_ID` (`TTC_ART_ID`),
   KEY `TTC_TYP_ID` (`TTC_TYP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
Table information for spare parts.

РУССКИЙ
=====================================================================
Таблица дополнительной информации запчасти.  */

DROP TABLE IF EXISTS `EXPORTADDITION_ARTINFO`;
CREATE TABLE `EXPORTADDITION_ARTINFO` (
   `TTC_ART_ID` int(11) NOT NULL, 
   `ARTINFO` text, 
   KEY `TTC_ART_ID` (`TTC_ART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
Table of names of commodity groups

РУССКИЙ
=====================================================================
Таблица названий торговых групп.  */

DROP TABLE IF EXISTS `EXPORTADDITION_GAINFO`;
CREATE TABLE `EXPORTADDITION_GAINFO` (
   `TTC_GA_ID` int(11) NOT NULL, 
   `GA_NAME` varchar(500) NOT NULL, 
   `GA_STANDARD` varchar(500) DEFAULT NULL, 
   `GA_ASSEMBLY` varchar(500) DEFAULT NULL, 
   `GA_INTENDED` varchar(500) DEFAULT NULL, 
   PRIMARY KEY (`TTC_GA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/* 
ENGLISH
=====================================================================	
This file you can import into the database MySQL (without deleting the descriptions, they will be ignored), in the process, will created the tables described above !!!!!

РУССКИЙ
=====================================================================
Данный файл вы можете импортировать в базу MySQL (не удаляя описания, они будут игнорироваться), в процессе чего будут созданы таблицы описаны выше !!!!! */