-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: tecdoc_2016_3q_europe
-- ------------------------------------------------------
-- Server version	5.7.12-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ACCESSORY_LISTS`
--

DROP TABLE IF EXISTS `ACCESSORY_LISTS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ACCESSORY_LISTS` (
  `ACL_ART_ID` int(11) NOT NULL,
  `ACL_NR` smallint(6) NOT NULL,
  `ACL_SORT` smallint(6) NOT NULL,
  `ACL_LINK_TYPE` smallint(6) DEFAULT NULL,
  `ACL_MFA_ID` smallint(6) DEFAULT NULL,
  `ACL_MOD_ID` int(11) DEFAULT NULL,
  `ACL_TYP_ID` int(11) DEFAULT NULL,
  `ACL_ENG_ID` int(11) DEFAULT NULL,
  `ACL_ACCESSORY_ART_ID` int(11) DEFAULT NULL,
  `ACL_QUANTITY` smallint(6) DEFAULT NULL,
  `ACL_GA_ID` int(11) DEFAULT NULL,
  `ACL_DES_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ACL_ART_ID`,`ACL_NR`,`ACL_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ACL_CRITERIA`
--

DROP TABLE IF EXISTS `ACL_CRITERIA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ACL_CRITERIA` (
  `ACC_ART_ID` int(11) NOT NULL,
  `ACC_NR` smallint(6) NOT NULL,
  `ACC_SORT` smallint(6) NOT NULL,
  `ACC_SEQ_NR` smallint(6) NOT NULL,
  `ACC_CRI_ID` smallint(6) DEFAULT NULL,
  `ACC_VALUE` varchar(60) DEFAULT NULL,
  `ACC_KV_DES_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ACC_ART_ID`,`ACC_NR`,`ACC_SORT`,`ACC_SEQ_NR`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ALI_COORDINATES`
--

DROP TABLE IF EXISTS `ALI_COORDINATES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ALI_COORDINATES` (
  `ACO_GRA_ID` varchar(11) NOT NULL,
  `ACO_GRA_LNG_ID` smallint(6) NOT NULL,
  `ACO_ALI_ART_ID` int(11) NOT NULL,
  `ACO_ALI_SORT` smallint(6) NOT NULL,
  `ACO_SORT` smallint(6) NOT NULL,
  `ACO_TYPE` smallint(6) DEFAULT NULL,
  `ACO_X1` smallint(6) DEFAULT NULL,
  `ACO_Y1` smallint(6) DEFAULT NULL,
  `ACO_X2` smallint(6) DEFAULT NULL,
  `ACO_Y2` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ACO_GRA_ID`,`ACO_GRA_LNG_ID`,`ACO_ALI_ART_ID`,`ACO_ALI_SORT`,`ACO_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ARTICLES`
--

DROP TABLE IF EXISTS `ARTICLES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ARTICLES` (
  `ART_ID` int(11) NOT NULL,
  `ART_ARTICLE_NR` varchar(66) NOT NULL,
  `ART_SUP_ID` smallint(6) DEFAULT NULL,
  `ART_DES_ID` int(11) DEFAULT NULL,
  `ART_COMPLETE_DES_ID` int(11) DEFAULT NULL,
  `ART_PACK_SELFSERVICE` smallint(6) DEFAULT NULL,
  `ART_MATERIAL_MARK` smallint(6) DEFAULT NULL,
  `ART_REPLACEMENT` smallint(6) DEFAULT NULL,
  `ART_ACCESSORY` smallint(6) DEFAULT NULL,
  `ART_BATCH_SIZE1` int(11) DEFAULT NULL,
  `ART_BATCH_SIZE2` int(11) DEFAULT NULL,
  PRIMARY KEY (`ART_ID`),
  KEY `ART_SUP_ID` (`ART_SUP_ID`),
  KEY `ART_DES_ID` (`ART_DES_ID`),
  KEY `ART_COMPLETE_DES_ID` (`ART_COMPLETE_DES_ID`),
  KEY `ART_ARTICLE_NR` (`ART_ARTICLE_NR`(18))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ARTICLES_NEW`
--

DROP TABLE IF EXISTS `ARTICLES_NEW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ARTICLES_NEW` (
  `ARTN_SUP_ID` smallint(6) NOT NULL DEFAULT '0',
  `ARTN_ART_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ARTN_SUP_ID`,`ARTN_ART_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ARTICLE_CRITERIA`
--

DROP TABLE IF EXISTS `ARTICLE_CRITERIA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ARTICLE_CRITERIA` (
  `ACR_ART_ID` int(11) NOT NULL,
  `ACR_GA_ID` int(11) NOT NULL,
  `ACR_SORT` smallint(6) NOT NULL,
  `ACR_CRI_ID` smallint(6) NOT NULL,
  `ACR_VALUE` varchar(60) DEFAULT NULL,
  `ACR_KV_DES_ID` int(11) DEFAULT NULL,
  `ACR_DISPLAY` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ACR_ART_ID`,`ACR_GA_ID`,`ACR_SORT`),
  KEY `ACR_VALUE` (`ACR_VALUE`(19)),
  KEY `ACR_KV_DES_ID` (`ACR_KV_DES_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ARTICLE_INFO`
--

DROP TABLE IF EXISTS `ARTICLE_INFO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ARTICLE_INFO` (
  `AIN_ART_ID` int(11) NOT NULL,
  `AIN_GA_ID` int(11) NOT NULL,
  `AIN_SORT` smallint(6) NOT NULL,
  `AIN_KV_TYPE` varchar(9) NOT NULL DEFAULT '',
  `AIN_DISPLAY` smallint(6) NOT NULL DEFAULT '0',
  `AIN_TMO_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`AIN_ART_ID`,`AIN_GA_ID`,`AIN_SORT`,`AIN_KV_TYPE`,`AIN_DISPLAY`,`AIN_TMO_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ARTICLE_LISTS`
--

DROP TABLE IF EXISTS `ARTICLE_LISTS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ARTICLE_LISTS` (
  `ALI_ART_ID` int(11) NOT NULL,
  `ALI_SORT` smallint(6) NOT NULL,
  `ALI_ART_ID_COMPONENT` int(11) DEFAULT NULL,
  `ALI_QUANTITY` smallint(6) DEFAULT NULL,
  `ALI_GA_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ALI_ART_ID`,`ALI_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ARTICLE_LIST_CRITERIA`
--

DROP TABLE IF EXISTS `ARTICLE_LIST_CRITERIA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ARTICLE_LIST_CRITERIA` (
  `ALC_ALI_ART_ID` int(11) NOT NULL,
  `ALC_ALI_SORT` smallint(6) NOT NULL,
  `ALC_SORT` smallint(6) NOT NULL DEFAULT '0',
  `ALC_CRI_ID` smallint(6) NOT NULL DEFAULT '0',
  `ALC_VALUE` varchar(60) NOT NULL DEFAULT '',
  `ALC_KV_DES_ID` int(11) NOT NULL DEFAULT '0',
  `ALC_TYP_ID` int(11) NOT NULL DEFAULT '0',
  `ALC_ENG_ID` int(11) NOT NULL DEFAULT '0',
  `ALC_AXL_ID` int(11) NOT NULL DEFAULT '0',
  `ALC_MRK_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ALC_ALI_ART_ID`,`ALC_ALI_SORT`,`ALC_SORT`,`ALC_CRI_ID`,`ALC_VALUE`,`ALC_KV_DES_ID`,`ALC_TYP_ID`,`ALC_ENG_ID`,`ALC_AXL_ID`,`ALC_MRK_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ART_COUNTRY_SPECIFICS`
--

DROP TABLE IF EXISTS `ART_COUNTRY_SPECIFICS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ART_COUNTRY_SPECIFICS` (
  `ACS_ART_ID` int(11) NOT NULL,
  `ACS_PACK_UNIT` int(11) DEFAULT NULL,
  `ACS_QUANTITY_PER_UNIT` int(11) DEFAULT NULL,
  `ACS_KV_STATUS_DES_ID` int(11) DEFAULT NULL,
  `ACS_KV_STATUS` varchar(9) DEFAULT NULL,
  `ACS_STATUS_DATE` datetime DEFAULT NULL,
  KEY `ACS_ART_ID` (`ACS_ART_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ART_LOOKUP`
--

DROP TABLE IF EXISTS `ART_LOOKUP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ART_LOOKUP` (
  `ARL_ART_ID` int(11) NOT NULL DEFAULT '0',
  `ARL_SEARCH_NUMBER` varchar(105) NOT NULL DEFAULT '',
  `ARL_KIND` binary(1) NOT NULL DEFAULT '\0',
  `ARL_BRA_ID` smallint(6) NOT NULL DEFAULT '0',
  `ARL_DISPLAY_NR` varchar(105) NOT NULL DEFAULT '',
  `ARL_DISPLAY` smallint(6) NOT NULL DEFAULT '0',
  `ARL_BLOCK` smallint(6) NOT NULL DEFAULT '0',
  `ARL_SORT` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ARL_ART_ID`,`ARL_SEARCH_NUMBER`,`ARL_KIND`,`ARL_BRA_ID`,`ARL_DISPLAY_NR`(36),`ARL_DISPLAY`,`ARL_BLOCK`,`ARL_SORT`),
  KEY `ARL_SEARCH_NUMBER` (`ARL_SEARCH_NUMBER`(13),`ARL_BRA_ID`,`ARL_KIND`),
  KEY `ARL_BRA_ID` (`ARL_BRA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AXLES`
--

DROP TABLE IF EXISTS `AXLES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AXLES` (
  `AXL_ID` int(11) NOT NULL,
  `AXL_DESCRIPTION` varchar(90) DEFAULT NULL,
  `AXL_SEARCH_TEXT` varchar(90) DEFAULT NULL,
  `AXL_MMA_CDS_ID` int(11) DEFAULT NULL,
  `AXL_MOD_ID` int(11) DEFAULT NULL,
  `AXL_SORT` int(11) DEFAULT NULL,
  `AXL_PCON_START` int(11) DEFAULT NULL,
  `AXL_PCON_END` int(11) DEFAULT NULL,
  `AXL_KV_TYPE_DES_ID` int(11) DEFAULT NULL,
  `AXL_KV_STYLE_DES_ID` int(11) DEFAULT NULL,
  `AXL_KV_BRAKE_TYPE_DES_ID` int(11) DEFAULT NULL,
  `AXL_KV_BODY_DES_ID` int(11) DEFAULT NULL,
  `AXL_LOAD_FROM` int(11) DEFAULT NULL,
  `AXL_LOAD_UPTO` int(11) DEFAULT NULL,
  `AXL_KV_WHEEL_MOUNT_DES_ID` int(11) DEFAULT NULL,
  `AXL_TRACK_GAUGE` int(11) DEFAULT NULL,
  `AXL_HUB_SYSTEM` varchar(60) DEFAULT NULL,
  `AXL_DISTANCE_FROM` int(11) DEFAULT NULL,
  `AXL_DISTANCE_UPTO` int(11) DEFAULT NULL,
  `AXL_SEARCH_BRAKE_SIZES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`AXL_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AXL_BRAKE_SIZES`
--

DROP TABLE IF EXISTS `AXL_BRAKE_SIZES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AXL_BRAKE_SIZES` (
  `ABS_AXL_ID` int(11) NOT NULL,
  `ABS_SORT` smallint(6) NOT NULL,
  `ABS_KV_BRAKE_SIZE_DES_ID` int(11) DEFAULT NULL,
  `ABS_DESCRIPTION` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`ABS_AXL_ID`,`ABS_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `BRANDS`
--

DROP TABLE IF EXISTS `BRANDS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `BRANDS` (
  `BRA_ID` smallint(6) NOT NULL,
  `BRA_MFC_CODE` varchar(60) DEFAULT NULL,
  `BRA_BRAND` varchar(60) DEFAULT NULL,
  `BRA_MF_NR` int(11) DEFAULT NULL,
  PRIMARY KEY (`BRA_ID`),
  KEY `BRA_BRAND` (`BRA_BRAND`(20))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CONST_PATTERN_LOOKUP`
--

DROP TABLE IF EXISTS `CONST_PATTERN_LOOKUP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CONST_PATTERN_LOOKUP` (
  `CPL_ID` int(11) NOT NULL,
  `CPL_SORT` smallint(6) NOT NULL DEFAULT '0',
  `CPL_ORIGINAL_TEXT` varchar(60) NOT NULL,
  `CPL_SEARCH_TEXT` varchar(60) NOT NULL DEFAULT '',
  `CPL_KIND` smallint(6) NOT NULL DEFAULT '0',
  KEY `CPL_ID` (`CPL_ID`,`CPL_SORT`,`CPL_ORIGINAL_TEXT`,`CPL_SEARCH_TEXT`,`CPL_KIND`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `COUNTRIES`
--

DROP TABLE IF EXISTS `COUNTRIES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `COUNTRIES` (
  `COU_ID` smallint(6) NOT NULL,
  `COU_CC` varchar(9) DEFAULT NULL,
  `COU_DES_ID` int(11) DEFAULT NULL,
  `COU_CURRENCY_CODE` varchar(9) DEFAULT NULL,
  `COU_ISO2` varchar(6) DEFAULT NULL,
  `COU_IS_GROUP` smallint(6) NOT NULL,
  PRIMARY KEY (`COU_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `COUNTRY_DESIGNATIONS`
--

DROP TABLE IF EXISTS `COUNTRY_DESIGNATIONS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `COUNTRY_DESIGNATIONS` (
  `CDS_ID` int(11) NOT NULL,
  `CDS_LNG_ID` smallint(6) NOT NULL,
  `CDS_TEX_ID` int(11) NOT NULL,
  PRIMARY KEY (`CDS_ID`,`CDS_LNG_ID`),
  KEY `CDS_TEX_ID` (`CDS_TEX_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CRITERIA`
--

DROP TABLE IF EXISTS `CRITERIA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CRITERIA` (
  `CRI_ID` smallint(6) NOT NULL,
  `CRI_DES_ID` int(11) NOT NULL,
  `CRI_SHORT_DES_ID` int(11) DEFAULT NULL,
  `CRI_UNIT_DES_ID` int(11) DEFAULT NULL,
  `CRI_TYPE` binary(1) DEFAULT NULL,
  `CRI_KT_ID` smallint(6) DEFAULT NULL,
  `CRI_IS_INTERVAL` smallint(6) DEFAULT NULL,
  `CRI_SUCCESSOR` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`CRI_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CV_CABS`
--

DROP TABLE IF EXISTS `CV_CABS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CV_CABS` (
  `CAB_ID` int(11) NOT NULL,
  `CAB_MOD_ID` int(11) DEFAULT NULL,
  `CAB_CDS_ID` int(11) NOT NULL,
  `CAB_MMC_CDS_ID` int(11) DEFAULT NULL,
  `CAB_KV_SIZE_DES_ID` int(11) DEFAULT NULL,
  `CAB_PCON_START` int(11) DEFAULT NULL,
  `CAB_PCON_END` int(11) DEFAULT NULL,
  `X_CAB_DESIGN` varchar(90) DEFAULT NULL,
  `X_CAB_LENGTH` int(11) DEFAULT NULL,
  `X_CAB_HEIGHT` int(11) DEFAULT NULL,
  `X_CAB_WIDTH` int(11) DEFAULT NULL,
  PRIMARY KEY (`CAB_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CV_MARKS`
--

DROP TABLE IF EXISTS `CV_MARKS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CV_MARKS` (
  `MRK_ID` int(11) NOT NULL,
  `MRK_DESIGNATION` varchar(60) DEFAULT NULL,
  `MRK_SEARCH_TEXT` varchar(60) DEFAULT NULL,
  `MRK_MFA_ID` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`MRK_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CV_SECONDARY_TYPES`
--

DROP TABLE IF EXISTS `CV_SECONDARY_TYPES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CV_SECONDARY_TYPES` (
  `CST_TYP_ID` int(11) NOT NULL,
  `CST_SUBNR` smallint(6) NOT NULL,
  `CST_SORT` smallint(6) NOT NULL,
  `CST_CDS_ID` int(11) DEFAULT NULL,
  `CST_PCON_START` int(11) DEFAULT NULL,
  `CST_PCON_END` int(11) DEFAULT NULL,
  PRIMARY KEY (`CST_TYP_ID`,`CST_SUBNR`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DESIGNATIONS`
--

DROP TABLE IF EXISTS `DESIGNATIONS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DESIGNATIONS` (
  `DES_ID` int(11) NOT NULL,
  `DES_LNG_ID` smallint(6) NOT NULL,
  `DES_TEX_ID` int(11) NOT NULL,
  PRIMARY KEY (`DES_ID`,`DES_LNG_ID`),
  KEY `DES_TEX_ID` (`DES_TEX_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DES_TEXTS`
--

DROP TABLE IF EXISTS `DES_TEXTS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DES_TEXTS` (
  `TEX_ID` int(11) NOT NULL,
  `TEX_TEXT` text,
  PRIMARY KEY (`TEX_ID`),
  KEY `TEX_TEXT` (`TEX_TEXT`(70))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DOC_TYPES`
--

DROP TABLE IF EXISTS `DOC_TYPES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DOC_TYPES` (
  `DOC_TYPE` smallint(4) NOT NULL,
  `DOC_EXTENSION` varchar(9) DEFAULT NULL,
  PRIMARY KEY (`DOC_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ENGINES`
--

DROP TABLE IF EXISTS `ENGINES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ENGINES` (
  `ENG_ID` int(11) NOT NULL,
  `ENG_MFA_ID` smallint(6) DEFAULT NULL,
  `ENG_CODE` varchar(180) NOT NULL,
  `ENG_PCON_START` int(11) DEFAULT NULL,
  `ENG_PCON_END` int(11) DEFAULT NULL,
  `ENG_KW_FROM` int(11) DEFAULT NULL,
  `ENG_KW_UPTO` int(11) DEFAULT NULL,
  `ENG_HP_FROM` int(11) DEFAULT NULL,
  `ENG_HP_UPTO` int(11) DEFAULT NULL,
  `ENG_VALVES` smallint(6) DEFAULT NULL,
  `ENG_CYLINDERS` smallint(6) DEFAULT NULL,
  `ENG_CCM_FROM` int(11) DEFAULT NULL,
  `ENG_CCM_UPTO` int(11) DEFAULT NULL,
  `ENG_KV_DESIGN_DES_ID` int(11) DEFAULT NULL,
  `ENG_KV_FUEL_TYPE_DES_ID` int(11) DEFAULT NULL,
  `ENG_KV_FUEL_SUPPLY_DES_ID` int(11) DEFAULT NULL,
  `ENG_DESCRIPTION` varchar(90) DEFAULT NULL,
  `ENG_KV_ENGINE_DES_ID` int(11) DEFAULT NULL,
  `ENG_KW_RPM_FROM` int(11) DEFAULT NULL,
  `ENG_KW_RPM_UPTO` int(11) DEFAULT NULL,
  `ENG_TORQUE_FROM` int(11) DEFAULT NULL,
  `ENG_TORQUE_UPTO` int(11) DEFAULT NULL,
  `ENG_TORQUE_RPM_FROM` int(11) DEFAULT NULL,
  `ENG_TORQUE_RPM_UPTO` int(11) DEFAULT NULL,
  `ENG_COMPRESSION_FROM` double DEFAULT NULL,
  `ENG_COMPRESSION_UPTO` double DEFAULT NULL,
  `ENG_DRILLING` double DEFAULT NULL,
  `ENG_EXTENSION` double DEFAULT NULL,
  `ENG_CRANKSHAFT` smallint(6) DEFAULT NULL,
  `ENG_KV_CHARGE_DES_ID` int(11) DEFAULT NULL,
  `ENG_KV_GAS_NORM_DES_ID` int(11) DEFAULT NULL,
  `ENG_KV_CYLINDERS_DES_ID` int(11) DEFAULT NULL,
  `ENG_KV_CONTROL_DES_ID` int(11) DEFAULT NULL,
  `ENG_KV_VALVE_CONTROL_DES_ID` int(11) DEFAULT NULL,
  `ENG_KV_COOLING_DES_ID` int(11) DEFAULT NULL,
  `ENG_CCM_TAX_FROM` int(11) DEFAULT NULL,
  `ENG_CCM_TAX_UPTO` int(11) DEFAULT NULL,
  `ENG_LITRES_TAX_FROM` double DEFAULT NULL,
  `ENG_LITRES_TAX_UPTO` double DEFAULT NULL,
  `ENG_LITRES_FROM` double DEFAULT NULL,
  `ENG_LITRES_UPTO` double DEFAULT NULL,
  `ENG_KV_USE_DES_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ENG_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ENG_COUNTRY_SPECIFICS`
--

DROP TABLE IF EXISTS `ENG_COUNTRY_SPECIFICS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ENG_COUNTRY_SPECIFICS` (
  `ENC_ENG_ID` int(11) NOT NULL,
  `ENC_COU_ID` smallint(6) NOT NULL,
  `ENC_PCON_START` int(11) DEFAULT NULL,
  `ENC_PCON_END` int(11) DEFAULT NULL,
  `ENC_KW_FROM` int(11) DEFAULT NULL,
  `ENC_KW_UPTO` int(11) DEFAULT NULL,
  `ENC_HP_FROM` int(11) DEFAULT NULL,
  `ENC_HP_UPTO` int(11) DEFAULT NULL,
  `ENC_VALVES` smallint(6) DEFAULT NULL,
  `ENC_CYLINDERS` smallint(6) DEFAULT NULL,
  `ENC_CCM_FROM` int(11) DEFAULT NULL,
  `ENC_CCM_UPTO` int(11) DEFAULT NULL,
  `ENC_KV_DESIGN_DES_ID` int(11) DEFAULT NULL,
  `ENC_KV_FUEL_TYPE_DES_ID` int(11) DEFAULT NULL,
  `ENC_KV_FUEL_SUPPLY_DES_ID` int(11) DEFAULT NULL,
  `ENC_DESCRIPTION` varchar(90) DEFAULT NULL,
  `ENC_KV_ENGINE_DES_ID` int(11) DEFAULT NULL,
  `ENC_KW_RPM_FROM` int(11) DEFAULT NULL,
  `ENC_KW_RPM_UPTO` int(11) DEFAULT NULL,
  `ENC_TORQUE_FROM` int(11) DEFAULT NULL,
  `ENC_TORQUE_UPTO` int(11) DEFAULT NULL,
  `ENC_TORQUE_RPM_FROM` int(11) DEFAULT NULL,
  `ENC_TORQUE_RPM_UPTO` int(11) DEFAULT NULL,
  `ENC_COMPRESSION_FROM` double DEFAULT NULL,
  `ENC_COMPRESSION_UPTO` double DEFAULT NULL,
  `ENC_DRILLING` double DEFAULT NULL,
  `ENC_EXTENSION` double DEFAULT NULL,
  `ENC_CRANKSHAFT` smallint(6) DEFAULT NULL,
  `ENC_KV_CHARGE_DES_ID` int(11) DEFAULT NULL,
  `ENC_KV_GAS_NORM_DES_ID` int(11) DEFAULT NULL,
  `ENC_KV_CYLINDERS_DES_ID` int(11) DEFAULT NULL,
  `ENC_KV_CONTROL_DES_ID` int(11) DEFAULT NULL,
  `ENC_KV_VALVE_CONTROL_DES_ID` int(11) DEFAULT NULL,
  `ENC_KV_COOLING_DES_ID` int(11) DEFAULT NULL,
  `ENC_CCM_TAX_FROM` int(11) DEFAULT NULL,
  `ENC_CCM_TAX_UPTO` int(11) DEFAULT NULL,
  `ENC_LITRES_TAX_FROM` double DEFAULT NULL,
  `ENC_LITRES_TAX_UPTO` double DEFAULT NULL,
  `ENC_LITRES_FROM` double DEFAULT NULL,
  `ENC_LITRES_UPTO` double DEFAULT NULL,
  `ENC_KV_USE_DES_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ENC_ENG_ID`,`ENC_COU_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ENG_LOOKUP`
--

DROP TABLE IF EXISTS `ENG_LOOKUP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ENG_LOOKUP` (
  `ENL_ENG_ID` int(11) DEFAULT NULL,
  `ENL_SEARCH_TEXT` varchar(180) DEFAULT NULL,
  KEY `ENL_ENG_ID` (`ENL_ENG_ID`,`ENL_SEARCH_TEXT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ERR_TRACK_KEY_VALUES`
--

DROP TABLE IF EXISTS `ERR_TRACK_KEY_VALUES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ERR_TRACK_KEY_VALUES` (
  `ETK_TAB_NR` smallint(6) NOT NULL,
  `ETK_KEY` varchar(9) NOT NULL,
  `ETK_LNG_ID` smallint(6) NOT NULL,
  `ETK_SORTNR` smallint(6) DEFAULT NULL,
  `ETK_DESCRIPTION` varchar(180) NOT NULL,
  PRIMARY KEY (`ETK_TAB_NR`,`ETK_KEY`,`ETK_LNG_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FILTERS`
--

DROP TABLE IF EXISTS `FILTERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `FILTERS` (
  `FIL_USS_ID` int(11) NOT NULL,
  `FIL_KIND` smallint(6) NOT NULL,
  `FIL_VALUE` int(11) NOT NULL,
  PRIMARY KEY (`FIL_USS_ID`,`FIL_KIND`,`FIL_VALUE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `GENERIC_ARTICLES`
--

DROP TABLE IF EXISTS `GENERIC_ARTICLES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `GENERIC_ARTICLES` (
  `GA_ID` int(11) NOT NULL,
  `GA_NR` smallint(6) DEFAULT NULL,
  `GA_DES_ID` int(11) NOT NULL,
  `GA_DES_ID_STANDARD` int(11) NOT NULL,
  `GA_DES_ID_ASSEMBLY` int(11) DEFAULT NULL,
  `GA_DES_ID_INTENDED` int(11) DEFAULT NULL,
  `GA_UNIVERSAL` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`GA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `GRAPHICS`
--

DROP TABLE IF EXISTS `GRAPHICS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `GRAPHICS` (
  `GRA_SUP_ID` smallint(6) DEFAULT NULL,
  `GRA_ID` varchar(11) NOT NULL,
  `GRA_DOC_TYPE` tinyint(4) DEFAULT NULL,
  `GRA_LNG_ID` smallint(6) NOT NULL,
  `GRA_GRD_ID` varchar(14) DEFAULT NULL,
  `GRA_TYPE` smallint(6) DEFAULT NULL,
  `GRA_NORM` varchar(9) DEFAULT NULL,
  `GRA_SUPPLIER_NR` smallint(6) DEFAULT NULL,
  `GRA_TAB_NR` smallint(6) DEFAULT NULL,
  `GRA_DES_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`GRA_ID`,`GRA_LNG_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `KEY_VALUES`
--

DROP TABLE IF EXISTS `KEY_VALUES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `KEY_VALUES` (
  `KV_KT_ID` smallint(6) NOT NULL,
  `KV_KV` varchar(9) NOT NULL,
  `KV_DES_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`KV_KV`,`KV_KT_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LANGUAGES`
--

DROP TABLE IF EXISTS `LANGUAGES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LANGUAGES` (
  `LNG_ID` smallint(6) NOT NULL,
  `LNG_DES_ID` int(11) DEFAULT NULL,
  `LNG_ISO2` varchar(6) DEFAULT NULL,
  `LNG_CODEPAGE` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`LNG_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LA_CRITERIA`
--

DROP TABLE IF EXISTS `LA_CRITERIA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LA_CRITERIA` (
  `LAC_LA_ID` int(11) NOT NULL,
  `LAC_SORT` int(11) NOT NULL,
  `LAC_CRI_ID` smallint(6) NOT NULL,
  `LAC_VALUE` varchar(60) DEFAULT NULL,
  `LAC_KV_DES_ID` int(11) DEFAULT NULL,
  `LAC_DISPLAY` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`LAC_LA_ID`,`LAC_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LA_INFO`
--

DROP TABLE IF EXISTS `LA_INFO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LA_INFO` (
  `LIN_LA_ID` int(11) NOT NULL,
  `LIN_SORT` smallint(6) NOT NULL,
  `LIN_KV_TYPE` varchar(9) NOT NULL,
  `LIN_DISPLAY` smallint(6) NOT NULL,
  `LIN_TMO_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`LIN_LA_ID`,`LIN_SORT`,`LIN_KV_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_ART`
--

DROP TABLE IF EXISTS `LINK_ART`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_ART` (
  `LA_ID` int(11) NOT NULL,
  `LA_ART_ID` int(11) NOT NULL,
  `LA_GA_ID` int(11) NOT NULL,
  `LA_SORT` int(11) NOT NULL,
  PRIMARY KEY (`LA_ID`),
  KEY `LA_ART_ID` (`LA_ART_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_ART_GA`
--

DROP TABLE IF EXISTS `LINK_ART_GA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_ART_GA` (
  `LAG_ART_ID` int(11) NOT NULL,
  `LAG_GA_ID` int(11) NOT NULL,
  `LAG_SUP_ID` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`LAG_ART_ID`,`LAG_GA_ID`),
  KEY `LAG_GA_ID` (`LAG_GA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_CAB_TYP`
--

DROP TABLE IF EXISTS `LINK_CAB_TYP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_CAB_TYP` (
  `LCT_TYP_ID` int(11) NOT NULL,
  `LCT_NR` smallint(6) NOT NULL,
  `LCT_CAB_ID` int(11) NOT NULL,
  `LCT_PCON_START` int(11) NOT NULL DEFAULT '0',
  `LCT_PCON_END` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`LCT_TYP_ID`,`LCT_NR`,`LCT_CAB_ID`,`LCT_PCON_START`,`LCT_PCON_END`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_GA_CRI`
--

DROP TABLE IF EXISTS `LINK_GA_CRI`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_GA_CRI` (
  `LGC_GA_NR` smallint(6) NOT NULL,
  `LGC_CRI_ID` smallint(6) NOT NULL,
  `LGC_SORT` smallint(6) NOT NULL,
  `LGC_SUGGESTION` smallint(4) NOT NULL,
  PRIMARY KEY (`LGC_GA_NR`,`LGC_CRI_ID`,`LGC_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_GA_STR`
--

DROP TABLE IF EXISTS `LINK_GA_STR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_GA_STR` (
  `LGS_STR_ID` int(11) NOT NULL,
  `LGS_GA_ID` int(11) NOT NULL,
  PRIMARY KEY (`LGS_STR_ID`,`LGS_GA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_GRA_ART`
--

DROP TABLE IF EXISTS `LINK_GRA_ART`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_GRA_ART` (
  `LGA_ART_ID` int(11) NOT NULL,
  `LGA_SORT` smallint(6) NOT NULL,
  `LGA_GRA_ID` varchar(11) NOT NULL,
  PRIMARY KEY (`LGA_ART_ID`,`LGA_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_GRA_LA`
--

DROP TABLE IF EXISTS `LINK_GRA_LA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_GRA_LA` (
  `LGL_LA_ID` int(11) NOT NULL,
  `LGL_TYP_ID` int(11) NOT NULL DEFAULT '0',
  `LGL_ENG_ID` int(11) NOT NULL DEFAULT '0',
  `LGL_AXL_ID` int(11) NOT NULL DEFAULT '0',
  `LGL_MRK_ID` int(11) NOT NULL DEFAULT '0',
  `LGL_SORT` smallint(6) NOT NULL,
  `LGL_GRA_ID` varchar(11) NOT NULL,
  PRIMARY KEY (`LGL_LA_ID`,`LGL_TYP_ID`,`LGL_ENG_ID`,`LGL_AXL_ID`,`LGL_MRK_ID`,`LGL_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_LA_AXL`
--

DROP TABLE IF EXISTS `LINK_LA_AXL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_LA_AXL` (
  `LAA_LA_ID` int(11) NOT NULL,
  `LAA_AXL_ID` int(11) NOT NULL,
  `LAA_GA_ID` int(11) NOT NULL,
  `LAA_SUP_ID` smallint(6) DEFAULT NULL,
  `LAA_SORT` int(11) NOT NULL,
  PRIMARY KEY (`LAA_GA_ID`,`LAA_LA_ID`,`LAA_SORT`,`LAA_AXL_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_LA_AXL_NEW`
--

DROP TABLE IF EXISTS `LINK_LA_AXL_NEW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_LA_AXL_NEW` (
  `LAAN_LA_ID` int(11) NOT NULL,
  `LAAN_AXL_ID` int(11) NOT NULL,
  `LAAN_GA_ID` int(11) NOT NULL,
  `LAAN_SUP_ID` smallint(6) NOT NULL DEFAULT '0',
  `LAAN_SORT` int(11) NOT NULL,
  PRIMARY KEY (`LAAN_LA_ID`,`LAAN_AXL_ID`,`LAAN_GA_ID`,`LAAN_SUP_ID`,`LAAN_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_LA_ENG`
--

DROP TABLE IF EXISTS `LINK_LA_ENG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_LA_ENG` (
  `LAE_LA_ID` int(11) NOT NULL,
  `LAE_ENG_ID` int(11) NOT NULL,
  `LAE_GA_ID` int(11) NOT NULL,
  `LAE_SUP_ID` smallint(6) DEFAULT NULL,
  `LAE_SORT` int(11) NOT NULL,
  PRIMARY KEY (`LAE_ENG_ID`,`LAE_GA_ID`,`LAE_LA_ID`,`LAE_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_LA_ENG_NEW`
--

DROP TABLE IF EXISTS `LINK_LA_ENG_NEW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_LA_ENG_NEW` (
  `LAEN_SUP_ID` smallint(6) NOT NULL DEFAULT '0',
  `LAEN_GA_ID` int(11) NOT NULL DEFAULT '0',
  `LAEN_LA_ID` int(11) NOT NULL DEFAULT '0',
  `LAEN_ENG_ID` int(11) NOT NULL DEFAULT '0',
  `LAEN_SORT` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`LAEN_SUP_ID`,`LAEN_GA_ID`,`LAEN_LA_ID`,`LAEN_ENG_ID`,`LAEN_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_LA_MRK`
--

DROP TABLE IF EXISTS `LINK_LA_MRK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_LA_MRK` (
  `LAM_LA_ID` int(11) NOT NULL,
  `LAM_MRK_ID` int(11) NOT NULL,
  `LAM_GA_ID` int(11) NOT NULL,
  `LAM_SUP_ID` smallint(6) DEFAULT NULL,
  `LAM_SORT` int(11) NOT NULL,
  PRIMARY KEY (`LAM_MRK_ID`,`LAM_GA_ID`,`LAM_LA_ID`,`LAM_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_LA_MRK_NEW`
--

DROP TABLE IF EXISTS `LINK_LA_MRK_NEW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_LA_MRK_NEW` (
  `LAMN_LA_ID` int(11) NOT NULL DEFAULT '0',
  `LAMN_MRK_ID` int(11) NOT NULL DEFAULT '0',
  `LAMN_GA_ID` int(11) NOT NULL DEFAULT '0',
  `LAMN_SUP_ID` smallint(6) NOT NULL DEFAULT '0',
  `LAMN_SORT` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`LAMN_LA_ID`,`LAMN_MRK_ID`,`LAMN_GA_ID`,`LAMN_SUP_ID`,`LAMN_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_LA_TYP`
--

DROP TABLE IF EXISTS `LINK_LA_TYP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_LA_TYP` (
  `LAT_TYP_ID` int(11) NOT NULL,
  `LAT_LA_ID` int(11) NOT NULL,
  `LAT_GA_ID` int(11) NOT NULL,
  `LAT_SUP_ID` smallint(6) DEFAULT NULL,
  `LAT_SORT` int(11) NOT NULL,
  PRIMARY KEY (`LAT_TYP_ID`,`LAT_GA_ID`,`LAT_LA_ID`,`LAT_SORT`),
  KEY `LAT_LA_ID` (`LAT_LA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_LA_TYP_NEW`
--

DROP TABLE IF EXISTS `LINK_LA_TYP_NEW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_LA_TYP_NEW` (
  `LATN_SUP_ID` smallint(6) NOT NULL,
  `LATN_GA_ID` int(11) NOT NULL,
  `LATN_TYP_ID` int(11) NOT NULL,
  `LATN_LA_ID` int(11) NOT NULL,
  `LATN_SORT` int(11) NOT NULL,
  PRIMARY KEY (`LATN_SUP_ID`,`LATN_GA_ID`,`LATN_TYP_ID`,`LATN_LA_ID`,`LATN_SORT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_SHO_STR`
--

DROP TABLE IF EXISTS `LINK_SHO_STR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_SHO_STR` (
  `LSS_SHO_ID` smallint(6) NOT NULL,
  `LSS_STR_ID` int(11) NOT NULL,
  `LSS_EXPAND` smallint(6) DEFAULT NULL,
  `LSS_LEVEL` smallint(6) NOT NULL,
  `LSS_SORT` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`LSS_SHO_ID`,`LSS_STR_ID`,`LSS_LEVEL`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_SHO_STR_TYPE`
--

DROP TABLE IF EXISTS `LINK_SHO_STR_TYPE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_SHO_STR_TYPE` (
  `LST_STR_TYPE` smallint(6) NOT NULL,
  `LST_SHO_ID` smallint(6) NOT NULL,
  `LST_SORT` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`LST_STR_TYPE`,`LST_SHO_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_TYP_AXL`
--

DROP TABLE IF EXISTS `LINK_TYP_AXL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_TYP_AXL` (
  `LTA_TYP_ID` int(11) NOT NULL,
  `LTA_SORT` smallint(6) NOT NULL,
  `LTA_AXL_ID` int(11) NOT NULL,
  `LTA_PCON_START` int(11) DEFAULT NULL,
  `LTA_PCON_END` int(11) DEFAULT NULL,
  `LTA_KV_AXLE_POS_DES_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`LTA_TYP_ID`,`LTA_SORT`,`LTA_AXL_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_TYP_ENG`
--

DROP TABLE IF EXISTS `LINK_TYP_ENG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_TYP_ENG` (
  `LTE_TYP_ID` int(11) NOT NULL,
  `LTE_NR` smallint(6) NOT NULL,
  `LTE_ENG_ID` int(11) NOT NULL,
  `LTE_PCON_START` int(11) DEFAULT NULL,
  `LTE_PCON_END` int(11) DEFAULT NULL,
  PRIMARY KEY (`LTE_TYP_ID`,`LTE_NR`,`LTE_ENG_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `LINK_TYP_MRK`
--

DROP TABLE IF EXISTS `LINK_TYP_MRK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `LINK_TYP_MRK` (
  `LMK_TYP_ID` int(11) NOT NULL,
  `LMK_MRK_ID` int(11) NOT NULL,
  PRIMARY KEY (`LMK_TYP_ID`,`LMK_MRK_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `MANUFACTURERS`
--

DROP TABLE IF EXISTS `MANUFACTURERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MANUFACTURERS` (
  `MFA_ID` smallint(6) NOT NULL,
  `MFA_PC_MFC` smallint(6) DEFAULT NULL,
  `MFA_CV_MFC` smallint(6) DEFAULT NULL,
  `MFA_AXL_MFC` smallint(6) DEFAULT NULL,
  `MFA_ENG_MFC` smallint(6) DEFAULT NULL,
  `MFA_ENG_TYP` smallint(6) DEFAULT NULL,
  `MFA_MFC_CODE` varchar(30) DEFAULT NULL,
  `MFA_BRAND` varchar(60) DEFAULT NULL,
  `MFA_MF_NR` int(11) DEFAULT NULL,
  PRIMARY KEY (`MFA_ID`),
  KEY `MFA_BRAND` (`MFA_BRAND`(14))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `MODELS`
--

DROP TABLE IF EXISTS `MODELS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MODELS` (
  `MOD_ID` int(11) NOT NULL,
  `MOD_MFA_ID` smallint(6) DEFAULT NULL,
  `MOD_CDS_ID` int(11) DEFAULT NULL,
  `MOD_PCON_START` int(11) DEFAULT NULL,
  `MOD_PCON_END` int(11) DEFAULT NULL,
  `MOD_PC` smallint(6) DEFAULT NULL,
  `MOD_CV` smallint(6) DEFAULT NULL,
  `MOD_AXL` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`MOD_ID`),
  KEY `MOD_MFA_ID` (`MOD_MFA_ID`),
  KEY `MOD_CDS_ID` (`MOD_CDS_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `MOD_TYP_LOOKUP`
--

DROP TABLE IF EXISTS `MOD_TYP_LOOKUP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MOD_TYP_LOOKUP` (
  `MTL_TYP_ID` int(11) NOT NULL,
  `MTL_LNG_ID` smallint(6) NOT NULL,
  `MTL_SEARCH_TEXT` varchar(100) NOT NULL,
  KEY `MTL_TYP_ID` (`MTL_TYP_ID`,`MTL_LNG_ID`,`MTL_SEARCH_TEXT`(60))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `NUMBERPLATES_NL`
--

DROP TABLE IF EXISTS `NUMBERPLATES_NL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `NUMBERPLATES_NL` (
  `NNL_NUMBERPLATE` varchar(8) NOT NULL,
  `NNL_TYP_ID` int(11) NOT NULL,
  PRIMARY KEY (`NNL_NUMBERPLATE`,`NNL_TYP_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PARAMETERS`
--

DROP TABLE IF EXISTS `PARAMETERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PARAMETERS` (
  `PAR_NAME` varchar(60) NOT NULL,
  `PAR_VALUE` text,
  PRIMARY KEY (`PAR_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PRICES`
--

DROP TABLE IF EXISTS `PRICES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PRICES` (
  `PRI_ART_ID` int(11) NOT NULL,
  `PRI_KV_PRICE_TYPE` varchar(9) NOT NULL,
  `PRI_PRICE` varchar(30) DEFAULT NULL,
  `PRI_KV_PRICE_UNIT_DES_ID` int(11) NOT NULL,
  `PRI_KV_QUANTITY_UNIT_DES_ID` int(11) NOT NULL,
  `PRI_VAL_START` datetime DEFAULT NULL,
  `PRI_VAL_END` datetime DEFAULT NULL,
  `PRI_CURRENCY_CODE` varchar(9) NOT NULL,
  `PRI_REBATE` varchar(15) DEFAULT NULL,
  `PRI_DISCOUNT_FLAG` smallint(6) NOT NULL,
  KEY `PRI_ART_ID` (`PRI_ART_ID`,`PRI_KV_PRICE_TYPE`,`PRI_KV_PRICE_UNIT_DES_ID`,`PRI_KV_QUANTITY_UNIT_DES_ID`,`PRI_VAL_START`,`PRI_CURRENCY_CODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SEARCH_TREE`
--

DROP TABLE IF EXISTS `SEARCH_TREE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SEARCH_TREE` (
  `STR_ID` int(11) NOT NULL,
  `STR_ID_PARENT` int(11) DEFAULT NULL,
  `STR_TYPE` smallint(6) DEFAULT NULL,
  `STR_LEVEL` smallint(6) DEFAULT NULL,
  `STR_DES_ID` int(11) DEFAULT NULL,
  `STR_SORT` smallint(6) DEFAULT NULL,
  `STR_NODE_NR` int(11) DEFAULT NULL,
  PRIMARY KEY (`STR_ID`),
  KEY `STR_ID_PARENT` (`STR_ID_PARENT`),
  KEY `STR_LEVEL` (`STR_LEVEL`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `STR_FAMILY_TREE`
--

DROP TABLE IF EXISTS `STR_FAMILY_TREE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STR_FAMILY_TREE` (
  `SFT_ANCESTOR_STR_ID` int(11) NOT NULL,
  `SFT_DESCENDANT_STR_ID` int(11) NOT NULL,
  PRIMARY KEY (`SFT_ANCESTOR_STR_ID`,`SFT_DESCENDANT_STR_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `STR_LOOKUP`
--

DROP TABLE IF EXISTS `STR_LOOKUP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STR_LOOKUP` (
  `STL_LNG_ID` smallint(6) NOT NULL,
  `STL_SEARCH_TEXT` varchar(180) NOT NULL,
  `STL_STR_ID` int(11) NOT NULL,
  `STL_GA_ID` int(11) NOT NULL,
  KEY `STL_LNG_ID` (`STL_LNG_ID`,`STL_SEARCH_TEXT`,`STL_STR_ID`,`STL_GA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SUPERSEDED_ARTICLES`
--

DROP TABLE IF EXISTS `SUPERSEDED_ARTICLES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SUPERSEDED_ARTICLES` (
  `SUA_ART_ID` int(11) NOT NULL,
  `SUA_NUMBER` varchar(66) NOT NULL,
  `SUA_SORT` int(11) NOT NULL,
  PRIMARY KEY (`SUA_ART_ID`,`SUA_NUMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SUPPLIERS`
--

DROP TABLE IF EXISTS `SUPPLIERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SUPPLIERS` (
  `SUP_ID` smallint(6) NOT NULL,
  `SUP_BRAND` varchar(60) DEFAULT NULL,
  `SUP_SUPPLIER_NR` smallint(6) DEFAULT NULL,
  `SUP_COU_ID` smallint(6) DEFAULT NULL,
  `SUP_IS_HESS` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`SUP_ID`),
  KEY `SUP_BRAND` (`SUP_BRAND`(20))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SUPPLIER_ADDRESSES`
--

DROP TABLE IF EXISTS `SUPPLIER_ADDRESSES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SUPPLIER_ADDRESSES` (
  `SAD_SUP_ID` smallint(6) NOT NULL,
  `SAD_TYPE_OF_ADDRESS` varchar(9) NOT NULL,
  `SAD_COU_ID` smallint(6) NOT NULL DEFAULT '0',
  `SAD_NAME1` varchar(120) DEFAULT NULL,
  `SAD_NAME2` varchar(120) DEFAULT NULL,
  `SAD_STREET1` varchar(120) DEFAULT NULL,
  `SAD_STREET2` varchar(120) DEFAULT NULL,
  `SAD_POB` varchar(30) DEFAULT NULL,
  `SAD_COU_ID_POSTAL` smallint(6) DEFAULT NULL,
  `SAD_POSTAL_CODE_PLACE` varchar(24) DEFAULT NULL,
  `SAD_POSTAL_CODE_POB` varchar(24) DEFAULT NULL,
  `SAD_POSTAL_CODE_CUST` varchar(24) DEFAULT NULL,
  `SAD_CITY1` varchar(120) DEFAULT NULL,
  `SAD_CITY2` varchar(120) DEFAULT NULL,
  `SAD_TEL` varchar(120) DEFAULT NULL,
  `SAD_FAX` varchar(60) DEFAULT NULL,
  `SAD_EMAIL` varchar(180) DEFAULT NULL,
  `SAD_WEB` varchar(180) DEFAULT NULL,
  PRIMARY KEY (`SAD_SUP_ID`,`SAD_TYPE_OF_ADDRESS`,`SAD_COU_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SUPPLIER_LOGOS`
--

DROP TABLE IF EXISTS `SUPPLIER_LOGOS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SUPPLIER_LOGOS` (
  `SLO_ID` smallint(6) NOT NULL,
  `SLO_SUP_ID` smallint(6) NOT NULL,
  `SLO_LNG_ID` smallint(6) NOT NULL,
  PRIMARY KEY (`SLO_ID`),
  KEY `SLO_SUP_ID` (`SLO_SUP_ID`,`SLO_LNG_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TEXT_MODULES`
--

DROP TABLE IF EXISTS `TEXT_MODULES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TEXT_MODULES` (
  `TMO_ID` int(11) NOT NULL,
  `TMO_LNG_ID` smallint(6) NOT NULL,
  `TMO_FIXED` smallint(6) NOT NULL,
  `TMO_TMT_ID` int(11) NOT NULL,
  PRIMARY KEY (`TMO_ID`,`TMO_LNG_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TEXT_MODULE_TEXTS`
--

DROP TABLE IF EXISTS `TEXT_MODULE_TEXTS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TEXT_MODULE_TEXTS` (
  `TMT_ID` int(11) NOT NULL DEFAULT '0',
  `TMT_TEXT` text,
  PRIMARY KEY (`TMT_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TYPES`
--

DROP TABLE IF EXISTS `TYPES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TYPES` (
  `TYP_ID` int(11) NOT NULL,
  `TYP_CDS_ID` int(11) DEFAULT NULL,
  `TYP_MMT_CDS_ID` int(11) DEFAULT NULL,
  `TYP_MOD_ID` int(11) NOT NULL,
  `TYP_SORT` int(11) NOT NULL,
  `TYP_PCON_START` int(11) DEFAULT NULL,
  `TYP_PCON_END` int(11) DEFAULT NULL,
  `TYP_KW_FROM` int(11) DEFAULT NULL,
  `TYP_KW_UPTO` int(11) DEFAULT NULL,
  `TYP_HP_FROM` int(11) DEFAULT NULL,
  `TYP_HP_UPTO` int(11) DEFAULT NULL,
  `TYP_CCM` int(11) DEFAULT NULL,
  `TYP_CYLINDERS` smallint(6) DEFAULT NULL,
  `TYP_DOORS` smallint(6) DEFAULT NULL,
  `TYP_TANK` smallint(6) DEFAULT NULL,
  `TYP_KV_VOLTAGE_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_ABS_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_ASR_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_ENGINE_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_BRAKE_TYPE_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_BRAKE_SYST_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_FUEL_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_CATALYST_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_BODY_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_STEERING_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_STEERING_SIDE_DES_ID` int(11) DEFAULT NULL,
  `TYP_MAX_WEIGHT` double DEFAULT NULL,
  `TYP_KV_MODEL_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_AXLE_DES_ID` int(11) DEFAULT NULL,
  `TYP_CCM_TAX` int(11) DEFAULT NULL,
  `TYP_LITRES` double DEFAULT NULL,
  `TYP_KV_DRIVE_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_TRANS_DES_ID` int(11) DEFAULT NULL,
  `TYP_KV_FUEL_SUPPLY_DES_ID` int(11) DEFAULT NULL,
  `TYP_VALVES` smallint(6) DEFAULT NULL,
  `TYP_RT_EXISTS` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`TYP_ID`),
  KEY `TYP_MOD_ID` (`TYP_MOD_ID`),
  KEY `TYP_CDS_ID` (`TYP_CDS_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TYPE_NUMBERS`
--

DROP TABLE IF EXISTS `TYPE_NUMBERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TYPE_NUMBERS` (
  `TYN_TYP_ID` int(11) NOT NULL,
  `TYN_SEARCH_TEXT` varchar(60) NOT NULL,
  `TYN_KIND` smallint(6) NOT NULL,
  `TYN_DISPLAY_NR` varchar(60) NOT NULL DEFAULT '',
  `TYN_GOP_NR` varchar(75) NOT NULL DEFAULT '',
  `TYN_GOP_START` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TYN_TYP_ID`,`TYN_SEARCH_TEXT`,`TYN_KIND`,`TYN_DISPLAY_NR`,`TYN_GOP_NR`,`TYN_GOP_START`),
  KEY `TYN_SEARCH_TEXT` (`TYN_SEARCH_TEXT`(12),`TYN_KIND`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TYP_COUNTRY_SPECIFICS`
--

DROP TABLE IF EXISTS `TYP_COUNTRY_SPECIFICS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TYP_COUNTRY_SPECIFICS` (
  `TYC_TYP_ID` int(11) NOT NULL,
  `TYC_COU_ID` smallint(6) NOT NULL,
  `TYC_PCON_START` int(11) DEFAULT NULL,
  `TYC_PCON_END` int(11) DEFAULT NULL,
  `TYC_KW_FROM` int(11) DEFAULT NULL,
  `TYC_KW_UPTO` int(11) DEFAULT NULL,
  `TYC_HP_FROM` int(11) DEFAULT NULL,
  `TYC_HP_UPTO` int(11) DEFAULT NULL,
  `TYC_CCM` int(11) DEFAULT NULL,
  `TYC_CYLINDERS` smallint(6) DEFAULT NULL,
  `TYC_DOORS` smallint(6) DEFAULT NULL,
  `TYC_TANK` smallint(6) DEFAULT NULL,
  `TYC_KV_VOLTAGE_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_ABS_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_ASR_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_ENGINE_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_BRAKE_TYPE_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_BRAKE_SYST_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_CATALYST_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_BODY_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_STEERING_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_STEERING_SIDE_DES_ID` int(11) DEFAULT NULL,
  `TYC_MAX_WEIGHT` double DEFAULT NULL,
  `TYC_KV_MODEL_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_AXLE_DES_ID` int(11) DEFAULT NULL,
  `TYC_CCM_TAX` int(11) DEFAULT NULL,
  `TYC_LITRES` double DEFAULT NULL,
  `TYC_KV_DRIVE_DES_ID` int(11) DEFAULT NULL,
  `TYC_KV_TRANS_DES_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`TYC_TYP_ID`,`TYC_COU_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TYP_SUSPENSIONS`
--

DROP TABLE IF EXISTS `TYP_SUSPENSIONS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TYP_SUSPENSIONS` (
  `TSU_TYP_ID` int(11) NOT NULL,
  `TSU_NR` smallint(6) NOT NULL,
  `TSU_KV_SUSPENSION_DES_ID` int(11) NOT NULL,
  `TSU_KV_AXLE_POS_DES_ID` int(11) NOT NULL,
  PRIMARY KEY (`TSU_TYP_ID`,`TSU_NR`,`TSU_KV_SUSPENSION_DES_ID`,`TSU_KV_AXLE_POS_DES_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TYP_VOLTAGES`
--

DROP TABLE IF EXISTS `TYP_VOLTAGES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TYP_VOLTAGES` (
  `TVO_TYP_ID` int(11) NOT NULL,
  `TVO_NR` smallint(6) NOT NULL,
  `TVO_KV_VOLTAGE_DES_ID` int(11) NOT NULL,
  PRIMARY KEY (`TVO_TYP_ID`,`TVO_NR`,`TVO_KV_VOLTAGE_DES_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TYP_WHEEL_BASES`
--

DROP TABLE IF EXISTS `TYP_WHEEL_BASES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TYP_WHEEL_BASES` (
  `TWB_TYP_ID` int(11) NOT NULL,
  `TWB_NR` smallint(6) NOT NULL,
  `TWB_WHEEL_BASE` int(11) NOT NULL,
  `TWB_KV_AXLE_POS_DES_ID` int(11) NOT NULL,
  PRIMARY KEY (`TWB_TYP_ID`,`TWB_NR`,`TWB_WHEEL_BASE`,`TWB_KV_AXLE_POS_DES_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `UTILITY_DIRECT`
--

DROP TABLE IF EXISTS `UTILITY_DIRECT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `UTILITY_DIRECT` (
  `UTD_ART_ID` int(11) NOT NULL,
  `UTD_TEXT` text,
  KEY `UTD_ART_ID` (`UTD_ART_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-08-23 13:17:30