· 7 years ago · Jan 14, 2019, 03:48 PM
1-- MySQL dump 10.13 Distrib 5.7.12, for Win64 (x86_64)
2--
3-- Host: localhost Database: tecdoc_2016_3q_europe
4-- ------------------------------------------------------
5-- Server version 5.7.12-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `ACCESSORY_LISTS`
20--
21
22DROP TABLE IF EXISTS `ACCESSORY_LISTS`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `ACCESSORY_LISTS` (
26 `ACL_ART_ID` int(11) NOT NULL,
27 `ACL_NR` smallint(6) NOT NULL,
28 `ACL_SORT` smallint(6) NOT NULL,
29 `ACL_LINK_TYPE` smallint(6) DEFAULT NULL,
30 `ACL_MFA_ID` smallint(6) DEFAULT NULL,
31 `ACL_MOD_ID` int(11) DEFAULT NULL,
32 `ACL_TYP_ID` int(11) DEFAULT NULL,
33 `ACL_ENG_ID` int(11) DEFAULT NULL,
34 `ACL_ACCESSORY_ART_ID` int(11) DEFAULT NULL,
35 `ACL_QUANTITY` smallint(6) DEFAULT NULL,
36 `ACL_GA_ID` int(11) DEFAULT NULL,
37 `ACL_DES_ID` int(11) DEFAULT NULL,
38 PRIMARY KEY (`ACL_ART_ID`,`ACL_NR`,`ACL_SORT`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8;
40/*!40101 SET character_set_client = @saved_cs_client */;
41
42--
43-- Table structure for table `ACL_CRITERIA`
44--
45
46DROP TABLE IF EXISTS `ACL_CRITERIA`;
47/*!40101 SET @saved_cs_client = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `ACL_CRITERIA` (
50 `ACC_ART_ID` int(11) NOT NULL,
51 `ACC_NR` smallint(6) NOT NULL,
52 `ACC_SORT` smallint(6) NOT NULL,
53 `ACC_SEQ_NR` smallint(6) NOT NULL,
54 `ACC_CRI_ID` smallint(6) DEFAULT NULL,
55 `ACC_VALUE` varchar(60) DEFAULT NULL,
56 `ACC_KV_DES_ID` int(11) DEFAULT NULL,
57 PRIMARY KEY (`ACC_ART_ID`,`ACC_NR`,`ACC_SORT`,`ACC_SEQ_NR`)
58) ENGINE=MyISAM DEFAULT CHARSET=utf8;
59/*!40101 SET character_set_client = @saved_cs_client */;
60
61--
62-- Table structure for table `ALI_COORDINATES`
63--
64
65DROP TABLE IF EXISTS `ALI_COORDINATES`;
66/*!40101 SET @saved_cs_client = @@character_set_client */;
67/*!40101 SET character_set_client = utf8 */;
68CREATE TABLE `ALI_COORDINATES` (
69 `ACO_GRA_ID` varchar(11) NOT NULL,
70 `ACO_GRA_LNG_ID` smallint(6) NOT NULL,
71 `ACO_ALI_ART_ID` int(11) NOT NULL,
72 `ACO_ALI_SORT` smallint(6) NOT NULL,
73 `ACO_SORT` smallint(6) NOT NULL,
74 `ACO_TYPE` smallint(6) DEFAULT NULL,
75 `ACO_X1` smallint(6) DEFAULT NULL,
76 `ACO_Y1` smallint(6) DEFAULT NULL,
77 `ACO_X2` smallint(6) DEFAULT NULL,
78 `ACO_Y2` smallint(6) DEFAULT NULL,
79 PRIMARY KEY (`ACO_GRA_ID`,`ACO_GRA_LNG_ID`,`ACO_ALI_ART_ID`,`ACO_ALI_SORT`,`ACO_SORT`)
80) ENGINE=MyISAM DEFAULT CHARSET=utf8;
81/*!40101 SET character_set_client = @saved_cs_client */;
82
83--
84-- Table structure for table `ARTICLES`
85--
86
87DROP TABLE IF EXISTS `ARTICLES`;
88/*!40101 SET @saved_cs_client = @@character_set_client */;
89/*!40101 SET character_set_client = utf8 */;
90CREATE TABLE `ARTICLES` (
91 `ART_ID` int(11) NOT NULL,
92 `ART_ARTICLE_NR` varchar(66) NOT NULL,
93 `ART_SUP_ID` smallint(6) DEFAULT NULL,
94 `ART_DES_ID` int(11) DEFAULT NULL,
95 `ART_COMPLETE_DES_ID` int(11) DEFAULT NULL,
96 `ART_PACK_SELFSERVICE` smallint(6) DEFAULT NULL,
97 `ART_MATERIAL_MARK` smallint(6) DEFAULT NULL,
98 `ART_REPLACEMENT` smallint(6) DEFAULT NULL,
99 `ART_ACCESSORY` smallint(6) DEFAULT NULL,
100 `ART_BATCH_SIZE1` int(11) DEFAULT NULL,
101 `ART_BATCH_SIZE2` int(11) DEFAULT NULL,
102 PRIMARY KEY (`ART_ID`),
103 KEY `ART_SUP_ID` (`ART_SUP_ID`),
104 KEY `ART_DES_ID` (`ART_DES_ID`),
105 KEY `ART_COMPLETE_DES_ID` (`ART_COMPLETE_DES_ID`),
106 KEY `ART_ARTICLE_NR` (`ART_ARTICLE_NR`(18))
107) ENGINE=MyISAM DEFAULT CHARSET=utf8;
108/*!40101 SET character_set_client = @saved_cs_client */;
109
110--
111-- Table structure for table `ARTICLES_NEW`
112--
113
114DROP TABLE IF EXISTS `ARTICLES_NEW`;
115/*!40101 SET @saved_cs_client = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `ARTICLES_NEW` (
118 `ARTN_SUP_ID` smallint(6) NOT NULL DEFAULT '0',
119 `ARTN_ART_ID` int(11) NOT NULL DEFAULT '0',
120 PRIMARY KEY (`ARTN_SUP_ID`,`ARTN_ART_ID`)
121) ENGINE=MyISAM DEFAULT CHARSET=utf8;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Table structure for table `ARTICLE_CRITERIA`
126--
127
128DROP TABLE IF EXISTS `ARTICLE_CRITERIA`;
129/*!40101 SET @saved_cs_client = @@character_set_client */;
130/*!40101 SET character_set_client = utf8 */;
131CREATE TABLE `ARTICLE_CRITERIA` (
132 `ACR_ART_ID` int(11) NOT NULL,
133 `ACR_GA_ID` int(11) NOT NULL,
134 `ACR_SORT` smallint(6) NOT NULL,
135 `ACR_CRI_ID` smallint(6) NOT NULL,
136 `ACR_VALUE` varchar(60) DEFAULT NULL,
137 `ACR_KV_DES_ID` int(11) DEFAULT NULL,
138 `ACR_DISPLAY` smallint(6) DEFAULT NULL,
139 PRIMARY KEY (`ACR_ART_ID`,`ACR_GA_ID`,`ACR_SORT`),
140 KEY `ACR_VALUE` (`ACR_VALUE`(19)),
141 KEY `ACR_KV_DES_ID` (`ACR_KV_DES_ID`)
142) ENGINE=MyISAM DEFAULT CHARSET=utf8;
143/*!40101 SET character_set_client = @saved_cs_client */;
144
145--
146-- Table structure for table `ARTICLE_INFO`
147--
148
149DROP TABLE IF EXISTS `ARTICLE_INFO`;
150/*!40101 SET @saved_cs_client = @@character_set_client */;
151/*!40101 SET character_set_client = utf8 */;
152CREATE TABLE `ARTICLE_INFO` (
153 `AIN_ART_ID` int(11) NOT NULL,
154 `AIN_GA_ID` int(11) NOT NULL,
155 `AIN_SORT` smallint(6) NOT NULL,
156 `AIN_KV_TYPE` varchar(9) NOT NULL DEFAULT '',
157 `AIN_DISPLAY` smallint(6) NOT NULL DEFAULT '0',
158 `AIN_TMO_ID` int(11) NOT NULL DEFAULT '0',
159 PRIMARY KEY (`AIN_ART_ID`,`AIN_GA_ID`,`AIN_SORT`,`AIN_KV_TYPE`,`AIN_DISPLAY`,`AIN_TMO_ID`)
160) ENGINE=MyISAM DEFAULT CHARSET=utf8;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Table structure for table `ARTICLE_LISTS`
165--
166
167DROP TABLE IF EXISTS `ARTICLE_LISTS`;
168/*!40101 SET @saved_cs_client = @@character_set_client */;
169/*!40101 SET character_set_client = utf8 */;
170CREATE TABLE `ARTICLE_LISTS` (
171 `ALI_ART_ID` int(11) NOT NULL,
172 `ALI_SORT` smallint(6) NOT NULL,
173 `ALI_ART_ID_COMPONENT` int(11) DEFAULT NULL,
174 `ALI_QUANTITY` smallint(6) DEFAULT NULL,
175 `ALI_GA_ID` int(11) DEFAULT NULL,
176 PRIMARY KEY (`ALI_ART_ID`,`ALI_SORT`)
177) ENGINE=MyISAM DEFAULT CHARSET=utf8;
178/*!40101 SET character_set_client = @saved_cs_client */;
179
180--
181-- Table structure for table `ARTICLE_LIST_CRITERIA`
182--
183
184DROP TABLE IF EXISTS `ARTICLE_LIST_CRITERIA`;
185/*!40101 SET @saved_cs_client = @@character_set_client */;
186/*!40101 SET character_set_client = utf8 */;
187CREATE TABLE `ARTICLE_LIST_CRITERIA` (
188 `ALC_ALI_ART_ID` int(11) NOT NULL,
189 `ALC_ALI_SORT` smallint(6) NOT NULL,
190 `ALC_SORT` smallint(6) NOT NULL DEFAULT '0',
191 `ALC_CRI_ID` smallint(6) NOT NULL DEFAULT '0',
192 `ALC_VALUE` varchar(60) NOT NULL DEFAULT '',
193 `ALC_KV_DES_ID` int(11) NOT NULL DEFAULT '0',
194 `ALC_TYP_ID` int(11) NOT NULL DEFAULT '0',
195 `ALC_ENG_ID` int(11) NOT NULL DEFAULT '0',
196 `ALC_AXL_ID` int(11) NOT NULL DEFAULT '0',
197 `ALC_MRK_ID` int(11) NOT NULL DEFAULT '0',
198 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`)
199) ENGINE=MyISAM DEFAULT CHARSET=utf8;
200/*!40101 SET character_set_client = @saved_cs_client */;
201
202--
203-- Table structure for table `ART_COUNTRY_SPECIFICS`
204--
205
206DROP TABLE IF EXISTS `ART_COUNTRY_SPECIFICS`;
207/*!40101 SET @saved_cs_client = @@character_set_client */;
208/*!40101 SET character_set_client = utf8 */;
209CREATE TABLE `ART_COUNTRY_SPECIFICS` (
210 `ACS_ART_ID` int(11) NOT NULL,
211 `ACS_PACK_UNIT` int(11) DEFAULT NULL,
212 `ACS_QUANTITY_PER_UNIT` int(11) DEFAULT NULL,
213 `ACS_KV_STATUS_DES_ID` int(11) DEFAULT NULL,
214 `ACS_KV_STATUS` varchar(9) DEFAULT NULL,
215 `ACS_STATUS_DATE` datetime DEFAULT NULL,
216 KEY `ACS_ART_ID` (`ACS_ART_ID`)
217) ENGINE=MyISAM DEFAULT CHARSET=utf8;
218/*!40101 SET character_set_client = @saved_cs_client */;
219
220--
221-- Table structure for table `ART_LOOKUP`
222--
223
224DROP TABLE IF EXISTS `ART_LOOKUP`;
225/*!40101 SET @saved_cs_client = @@character_set_client */;
226/*!40101 SET character_set_client = utf8 */;
227CREATE TABLE `ART_LOOKUP` (
228 `ARL_ART_ID` int(11) NOT NULL DEFAULT '0',
229 `ARL_SEARCH_NUMBER` varchar(105) NOT NULL DEFAULT '',
230 `ARL_KIND` binary(1) NOT NULL DEFAULT '\0',
231 `ARL_BRA_ID` smallint(6) NOT NULL DEFAULT '0',
232 `ARL_DISPLAY_NR` varchar(105) NOT NULL DEFAULT '',
233 `ARL_DISPLAY` smallint(6) NOT NULL DEFAULT '0',
234 `ARL_BLOCK` smallint(6) NOT NULL DEFAULT '0',
235 `ARL_SORT` smallint(6) NOT NULL DEFAULT '0',
236 PRIMARY KEY (`ARL_ART_ID`,`ARL_SEARCH_NUMBER`,`ARL_KIND`,`ARL_BRA_ID`,`ARL_DISPLAY_NR`(36),`ARL_DISPLAY`,`ARL_BLOCK`,`ARL_SORT`),
237 KEY `ARL_SEARCH_NUMBER` (`ARL_SEARCH_NUMBER`(13),`ARL_BRA_ID`,`ARL_KIND`),
238 KEY `ARL_BRA_ID` (`ARL_BRA_ID`)
239) ENGINE=MyISAM DEFAULT CHARSET=utf8;
240/*!40101 SET character_set_client = @saved_cs_client */;
241
242--
243-- Table structure for table `AXLES`
244--
245
246DROP TABLE IF EXISTS `AXLES`;
247/*!40101 SET @saved_cs_client = @@character_set_client */;
248/*!40101 SET character_set_client = utf8 */;
249CREATE TABLE `AXLES` (
250 `AXL_ID` int(11) NOT NULL,
251 `AXL_DESCRIPTION` varchar(90) DEFAULT NULL,
252 `AXL_SEARCH_TEXT` varchar(90) DEFAULT NULL,
253 `AXL_MMA_CDS_ID` int(11) DEFAULT NULL,
254 `AXL_MOD_ID` int(11) DEFAULT NULL,
255 `AXL_SORT` int(11) DEFAULT NULL,
256 `AXL_PCON_START` int(11) DEFAULT NULL,
257 `AXL_PCON_END` int(11) DEFAULT NULL,
258 `AXL_KV_TYPE_DES_ID` int(11) DEFAULT NULL,
259 `AXL_KV_STYLE_DES_ID` int(11) DEFAULT NULL,
260 `AXL_KV_BRAKE_TYPE_DES_ID` int(11) DEFAULT NULL,
261 `AXL_KV_BODY_DES_ID` int(11) DEFAULT NULL,
262 `AXL_LOAD_FROM` int(11) DEFAULT NULL,
263 `AXL_LOAD_UPTO` int(11) DEFAULT NULL,
264 `AXL_KV_WHEEL_MOUNT_DES_ID` int(11) DEFAULT NULL,
265 `AXL_TRACK_GAUGE` int(11) DEFAULT NULL,
266 `AXL_HUB_SYSTEM` varchar(60) DEFAULT NULL,
267 `AXL_DISTANCE_FROM` int(11) DEFAULT NULL,
268 `AXL_DISTANCE_UPTO` int(11) DEFAULT NULL,
269 `AXL_SEARCH_BRAKE_SIZES` varchar(256) DEFAULT NULL,
270 PRIMARY KEY (`AXL_ID`)
271) ENGINE=MyISAM DEFAULT CHARSET=utf8;
272/*!40101 SET character_set_client = @saved_cs_client */;
273
274--
275-- Table structure for table `AXL_BRAKE_SIZES`
276--
277
278DROP TABLE IF EXISTS `AXL_BRAKE_SIZES`;
279/*!40101 SET @saved_cs_client = @@character_set_client */;
280/*!40101 SET character_set_client = utf8 */;
281CREATE TABLE `AXL_BRAKE_SIZES` (
282 `ABS_AXL_ID` int(11) NOT NULL,
283 `ABS_SORT` smallint(6) NOT NULL,
284 `ABS_KV_BRAKE_SIZE_DES_ID` int(11) DEFAULT NULL,
285 `ABS_DESCRIPTION` varchar(60) DEFAULT NULL,
286 PRIMARY KEY (`ABS_AXL_ID`,`ABS_SORT`)
287) ENGINE=MyISAM DEFAULT CHARSET=utf8;
288/*!40101 SET character_set_client = @saved_cs_client */;
289
290--
291-- Table structure for table `BRANDS`
292--
293
294DROP TABLE IF EXISTS `BRANDS`;
295/*!40101 SET @saved_cs_client = @@character_set_client */;
296/*!40101 SET character_set_client = utf8 */;
297CREATE TABLE `BRANDS` (
298 `BRA_ID` smallint(6) NOT NULL,
299 `BRA_MFC_CODE` varchar(60) DEFAULT NULL,
300 `BRA_BRAND` varchar(60) DEFAULT NULL,
301 `BRA_MF_NR` int(11) DEFAULT NULL,
302 PRIMARY KEY (`BRA_ID`),
303 KEY `BRA_BRAND` (`BRA_BRAND`(20))
304) ENGINE=MyISAM DEFAULT CHARSET=utf8;
305/*!40101 SET character_set_client = @saved_cs_client */;
306
307--
308-- Table structure for table `CONST_PATTERN_LOOKUP`
309--
310
311DROP TABLE IF EXISTS `CONST_PATTERN_LOOKUP`;
312/*!40101 SET @saved_cs_client = @@character_set_client */;
313/*!40101 SET character_set_client = utf8 */;
314CREATE TABLE `CONST_PATTERN_LOOKUP` (
315 `CPL_ID` int(11) NOT NULL,
316 `CPL_SORT` smallint(6) NOT NULL DEFAULT '0',
317 `CPL_ORIGINAL_TEXT` varchar(60) NOT NULL,
318 `CPL_SEARCH_TEXT` varchar(60) NOT NULL DEFAULT '',
319 `CPL_KIND` smallint(6) NOT NULL DEFAULT '0',
320 KEY `CPL_ID` (`CPL_ID`,`CPL_SORT`,`CPL_ORIGINAL_TEXT`,`CPL_SEARCH_TEXT`,`CPL_KIND`)
321) ENGINE=MyISAM DEFAULT CHARSET=utf8;
322/*!40101 SET character_set_client = @saved_cs_client */;
323
324--
325-- Table structure for table `COUNTRIES`
326--
327
328DROP TABLE IF EXISTS `COUNTRIES`;
329/*!40101 SET @saved_cs_client = @@character_set_client */;
330/*!40101 SET character_set_client = utf8 */;
331CREATE TABLE `COUNTRIES` (
332 `COU_ID` smallint(6) NOT NULL,
333 `COU_CC` varchar(9) DEFAULT NULL,
334 `COU_DES_ID` int(11) DEFAULT NULL,
335 `COU_CURRENCY_CODE` varchar(9) DEFAULT NULL,
336 `COU_ISO2` varchar(6) DEFAULT NULL,
337 `COU_IS_GROUP` smallint(6) NOT NULL,
338 PRIMARY KEY (`COU_ID`)
339) ENGINE=MyISAM DEFAULT CHARSET=utf8;
340/*!40101 SET character_set_client = @saved_cs_client */;
341
342--
343-- Table structure for table `COUNTRY_DESIGNATIONS`
344--
345
346DROP TABLE IF EXISTS `COUNTRY_DESIGNATIONS`;
347/*!40101 SET @saved_cs_client = @@character_set_client */;
348/*!40101 SET character_set_client = utf8 */;
349CREATE TABLE `COUNTRY_DESIGNATIONS` (
350 `CDS_ID` int(11) NOT NULL,
351 `CDS_LNG_ID` smallint(6) NOT NULL,
352 `CDS_TEX_ID` int(11) NOT NULL,
353 PRIMARY KEY (`CDS_ID`,`CDS_LNG_ID`),
354 KEY `CDS_TEX_ID` (`CDS_TEX_ID`)
355) ENGINE=MyISAM DEFAULT CHARSET=utf8;
356/*!40101 SET character_set_client = @saved_cs_client */;
357
358--
359-- Table structure for table `CRITERIA`
360--
361
362DROP TABLE IF EXISTS `CRITERIA`;
363/*!40101 SET @saved_cs_client = @@character_set_client */;
364/*!40101 SET character_set_client = utf8 */;
365CREATE TABLE `CRITERIA` (
366 `CRI_ID` smallint(6) NOT NULL,
367 `CRI_DES_ID` int(11) NOT NULL,
368 `CRI_SHORT_DES_ID` int(11) DEFAULT NULL,
369 `CRI_UNIT_DES_ID` int(11) DEFAULT NULL,
370 `CRI_TYPE` binary(1) DEFAULT NULL,
371 `CRI_KT_ID` smallint(6) DEFAULT NULL,
372 `CRI_IS_INTERVAL` smallint(6) DEFAULT NULL,
373 `CRI_SUCCESSOR` smallint(6) DEFAULT NULL,
374 PRIMARY KEY (`CRI_ID`)
375) ENGINE=MyISAM DEFAULT CHARSET=utf8;
376/*!40101 SET character_set_client = @saved_cs_client */;
377
378--
379-- Table structure for table `CV_CABS`
380--
381
382DROP TABLE IF EXISTS `CV_CABS`;
383/*!40101 SET @saved_cs_client = @@character_set_client */;
384/*!40101 SET character_set_client = utf8 */;
385CREATE TABLE `CV_CABS` (
386 `CAB_ID` int(11) NOT NULL,
387 `CAB_MOD_ID` int(11) DEFAULT NULL,
388 `CAB_CDS_ID` int(11) NOT NULL,
389 `CAB_MMC_CDS_ID` int(11) DEFAULT NULL,
390 `CAB_KV_SIZE_DES_ID` int(11) DEFAULT NULL,
391 `CAB_PCON_START` int(11) DEFAULT NULL,
392 `CAB_PCON_END` int(11) DEFAULT NULL,
393 `X_CAB_DESIGN` varchar(90) DEFAULT NULL,
394 `X_CAB_LENGTH` int(11) DEFAULT NULL,
395 `X_CAB_HEIGHT` int(11) DEFAULT NULL,
396 `X_CAB_WIDTH` int(11) DEFAULT NULL,
397 PRIMARY KEY (`CAB_ID`)
398) ENGINE=MyISAM DEFAULT CHARSET=utf8;
399/*!40101 SET character_set_client = @saved_cs_client */;
400
401--
402-- Table structure for table `CV_MARKS`
403--
404
405DROP TABLE IF EXISTS `CV_MARKS`;
406/*!40101 SET @saved_cs_client = @@character_set_client */;
407/*!40101 SET character_set_client = utf8 */;
408CREATE TABLE `CV_MARKS` (
409 `MRK_ID` int(11) NOT NULL,
410 `MRK_DESIGNATION` varchar(60) DEFAULT NULL,
411 `MRK_SEARCH_TEXT` varchar(60) DEFAULT NULL,
412 `MRK_MFA_ID` smallint(6) DEFAULT NULL,
413 PRIMARY KEY (`MRK_ID`)
414) ENGINE=MyISAM DEFAULT CHARSET=utf8;
415/*!40101 SET character_set_client = @saved_cs_client */;
416
417--
418-- Table structure for table `CV_SECONDARY_TYPES`
419--
420
421DROP TABLE IF EXISTS `CV_SECONDARY_TYPES`;
422/*!40101 SET @saved_cs_client = @@character_set_client */;
423/*!40101 SET character_set_client = utf8 */;
424CREATE TABLE `CV_SECONDARY_TYPES` (
425 `CST_TYP_ID` int(11) NOT NULL,
426 `CST_SUBNR` smallint(6) NOT NULL,
427 `CST_SORT` smallint(6) NOT NULL,
428 `CST_CDS_ID` int(11) DEFAULT NULL,
429 `CST_PCON_START` int(11) DEFAULT NULL,
430 `CST_PCON_END` int(11) DEFAULT NULL,
431 PRIMARY KEY (`CST_TYP_ID`,`CST_SUBNR`)
432) ENGINE=MyISAM DEFAULT CHARSET=utf8;
433/*!40101 SET character_set_client = @saved_cs_client */;
434
435--
436-- Table structure for table `DESIGNATIONS`
437--
438
439DROP TABLE IF EXISTS `DESIGNATIONS`;
440/*!40101 SET @saved_cs_client = @@character_set_client */;
441/*!40101 SET character_set_client = utf8 */;
442CREATE TABLE `DESIGNATIONS` (
443 `DES_ID` int(11) NOT NULL,
444 `DES_LNG_ID` smallint(6) NOT NULL,
445 `DES_TEX_ID` int(11) NOT NULL,
446 PRIMARY KEY (`DES_ID`,`DES_LNG_ID`),
447 KEY `DES_TEX_ID` (`DES_TEX_ID`)
448) ENGINE=MyISAM DEFAULT CHARSET=utf8;
449/*!40101 SET character_set_client = @saved_cs_client */;
450
451--
452-- Table structure for table `DES_TEXTS`
453--
454
455DROP TABLE IF EXISTS `DES_TEXTS`;
456/*!40101 SET @saved_cs_client = @@character_set_client */;
457/*!40101 SET character_set_client = utf8 */;
458CREATE TABLE `DES_TEXTS` (
459 `TEX_ID` int(11) NOT NULL,
460 `TEX_TEXT` text,
461 PRIMARY KEY (`TEX_ID`),
462 KEY `TEX_TEXT` (`TEX_TEXT`(70))
463) ENGINE=MyISAM DEFAULT CHARSET=utf8;
464/*!40101 SET character_set_client = @saved_cs_client */;
465
466--
467-- Table structure for table `DOC_TYPES`
468--
469
470DROP TABLE IF EXISTS `DOC_TYPES`;
471/*!40101 SET @saved_cs_client = @@character_set_client */;
472/*!40101 SET character_set_client = utf8 */;
473CREATE TABLE `DOC_TYPES` (
474 `DOC_TYPE` smallint(4) NOT NULL,
475 `DOC_EXTENSION` varchar(9) DEFAULT NULL,
476 PRIMARY KEY (`DOC_TYPE`)
477) ENGINE=MyISAM DEFAULT CHARSET=utf8;
478/*!40101 SET character_set_client = @saved_cs_client */;
479
480--
481-- Table structure for table `ENGINES`
482--
483
484DROP TABLE IF EXISTS `ENGINES`;
485/*!40101 SET @saved_cs_client = @@character_set_client */;
486/*!40101 SET character_set_client = utf8 */;
487CREATE TABLE `ENGINES` (
488 `ENG_ID` int(11) NOT NULL,
489 `ENG_MFA_ID` smallint(6) DEFAULT NULL,
490 `ENG_CODE` varchar(180) NOT NULL,
491 `ENG_PCON_START` int(11) DEFAULT NULL,
492 `ENG_PCON_END` int(11) DEFAULT NULL,
493 `ENG_KW_FROM` int(11) DEFAULT NULL,
494 `ENG_KW_UPTO` int(11) DEFAULT NULL,
495 `ENG_HP_FROM` int(11) DEFAULT NULL,
496 `ENG_HP_UPTO` int(11) DEFAULT NULL,
497 `ENG_VALVES` smallint(6) DEFAULT NULL,
498 `ENG_CYLINDERS` smallint(6) DEFAULT NULL,
499 `ENG_CCM_FROM` int(11) DEFAULT NULL,
500 `ENG_CCM_UPTO` int(11) DEFAULT NULL,
501 `ENG_KV_DESIGN_DES_ID` int(11) DEFAULT NULL,
502 `ENG_KV_FUEL_TYPE_DES_ID` int(11) DEFAULT NULL,
503 `ENG_KV_FUEL_SUPPLY_DES_ID` int(11) DEFAULT NULL,
504 `ENG_DESCRIPTION` varchar(90) DEFAULT NULL,
505 `ENG_KV_ENGINE_DES_ID` int(11) DEFAULT NULL,
506 `ENG_KW_RPM_FROM` int(11) DEFAULT NULL,
507 `ENG_KW_RPM_UPTO` int(11) DEFAULT NULL,
508 `ENG_TORQUE_FROM` int(11) DEFAULT NULL,
509 `ENG_TORQUE_UPTO` int(11) DEFAULT NULL,
510 `ENG_TORQUE_RPM_FROM` int(11) DEFAULT NULL,
511 `ENG_TORQUE_RPM_UPTO` int(11) DEFAULT NULL,
512 `ENG_COMPRESSION_FROM` double DEFAULT NULL,
513 `ENG_COMPRESSION_UPTO` double DEFAULT NULL,
514 `ENG_DRILLING` double DEFAULT NULL,
515 `ENG_EXTENSION` double DEFAULT NULL,
516 `ENG_CRANKSHAFT` smallint(6) DEFAULT NULL,
517 `ENG_KV_CHARGE_DES_ID` int(11) DEFAULT NULL,
518 `ENG_KV_GAS_NORM_DES_ID` int(11) DEFAULT NULL,
519 `ENG_KV_CYLINDERS_DES_ID` int(11) DEFAULT NULL,
520 `ENG_KV_CONTROL_DES_ID` int(11) DEFAULT NULL,
521 `ENG_KV_VALVE_CONTROL_DES_ID` int(11) DEFAULT NULL,
522 `ENG_KV_COOLING_DES_ID` int(11) DEFAULT NULL,
523 `ENG_CCM_TAX_FROM` int(11) DEFAULT NULL,
524 `ENG_CCM_TAX_UPTO` int(11) DEFAULT NULL,
525 `ENG_LITRES_TAX_FROM` double DEFAULT NULL,
526 `ENG_LITRES_TAX_UPTO` double DEFAULT NULL,
527 `ENG_LITRES_FROM` double DEFAULT NULL,
528 `ENG_LITRES_UPTO` double DEFAULT NULL,
529 `ENG_KV_USE_DES_ID` int(11) DEFAULT NULL,
530 PRIMARY KEY (`ENG_ID`)
531) ENGINE=MyISAM DEFAULT CHARSET=utf8;
532/*!40101 SET character_set_client = @saved_cs_client */;
533
534--
535-- Table structure for table `ENG_COUNTRY_SPECIFICS`
536--
537
538DROP TABLE IF EXISTS `ENG_COUNTRY_SPECIFICS`;
539/*!40101 SET @saved_cs_client = @@character_set_client */;
540/*!40101 SET character_set_client = utf8 */;
541CREATE TABLE `ENG_COUNTRY_SPECIFICS` (
542 `ENC_ENG_ID` int(11) NOT NULL,
543 `ENC_COU_ID` smallint(6) NOT NULL,
544 `ENC_PCON_START` int(11) DEFAULT NULL,
545 `ENC_PCON_END` int(11) DEFAULT NULL,
546 `ENC_KW_FROM` int(11) DEFAULT NULL,
547 `ENC_KW_UPTO` int(11) DEFAULT NULL,
548 `ENC_HP_FROM` int(11) DEFAULT NULL,
549 `ENC_HP_UPTO` int(11) DEFAULT NULL,
550 `ENC_VALVES` smallint(6) DEFAULT NULL,
551 `ENC_CYLINDERS` smallint(6) DEFAULT NULL,
552 `ENC_CCM_FROM` int(11) DEFAULT NULL,
553 `ENC_CCM_UPTO` int(11) DEFAULT NULL,
554 `ENC_KV_DESIGN_DES_ID` int(11) DEFAULT NULL,
555 `ENC_KV_FUEL_TYPE_DES_ID` int(11) DEFAULT NULL,
556 `ENC_KV_FUEL_SUPPLY_DES_ID` int(11) DEFAULT NULL,
557 `ENC_DESCRIPTION` varchar(90) DEFAULT NULL,
558 `ENC_KV_ENGINE_DES_ID` int(11) DEFAULT NULL,
559 `ENC_KW_RPM_FROM` int(11) DEFAULT NULL,
560 `ENC_KW_RPM_UPTO` int(11) DEFAULT NULL,
561 `ENC_TORQUE_FROM` int(11) DEFAULT NULL,
562 `ENC_TORQUE_UPTO` int(11) DEFAULT NULL,
563 `ENC_TORQUE_RPM_FROM` int(11) DEFAULT NULL,
564 `ENC_TORQUE_RPM_UPTO` int(11) DEFAULT NULL,
565 `ENC_COMPRESSION_FROM` double DEFAULT NULL,
566 `ENC_COMPRESSION_UPTO` double DEFAULT NULL,
567 `ENC_DRILLING` double DEFAULT NULL,
568 `ENC_EXTENSION` double DEFAULT NULL,
569 `ENC_CRANKSHAFT` smallint(6) DEFAULT NULL,
570 `ENC_KV_CHARGE_DES_ID` int(11) DEFAULT NULL,
571 `ENC_KV_GAS_NORM_DES_ID` int(11) DEFAULT NULL,
572 `ENC_KV_CYLINDERS_DES_ID` int(11) DEFAULT NULL,
573 `ENC_KV_CONTROL_DES_ID` int(11) DEFAULT NULL,
574 `ENC_KV_VALVE_CONTROL_DES_ID` int(11) DEFAULT NULL,
575 `ENC_KV_COOLING_DES_ID` int(11) DEFAULT NULL,
576 `ENC_CCM_TAX_FROM` int(11) DEFAULT NULL,
577 `ENC_CCM_TAX_UPTO` int(11) DEFAULT NULL,
578 `ENC_LITRES_TAX_FROM` double DEFAULT NULL,
579 `ENC_LITRES_TAX_UPTO` double DEFAULT NULL,
580 `ENC_LITRES_FROM` double DEFAULT NULL,
581 `ENC_LITRES_UPTO` double DEFAULT NULL,
582 `ENC_KV_USE_DES_ID` int(11) DEFAULT NULL,
583 PRIMARY KEY (`ENC_ENG_ID`,`ENC_COU_ID`)
584) ENGINE=MyISAM DEFAULT CHARSET=utf8;
585/*!40101 SET character_set_client = @saved_cs_client */;
586
587--
588-- Table structure for table `ENG_LOOKUP`
589--
590
591DROP TABLE IF EXISTS `ENG_LOOKUP`;
592/*!40101 SET @saved_cs_client = @@character_set_client */;
593/*!40101 SET character_set_client = utf8 */;
594CREATE TABLE `ENG_LOOKUP` (
595 `ENL_ENG_ID` int(11) DEFAULT NULL,
596 `ENL_SEARCH_TEXT` varchar(180) DEFAULT NULL,
597 KEY `ENL_ENG_ID` (`ENL_ENG_ID`,`ENL_SEARCH_TEXT`)
598) ENGINE=MyISAM DEFAULT CHARSET=utf8;
599/*!40101 SET character_set_client = @saved_cs_client */;
600
601--
602-- Table structure for table `ERR_TRACK_KEY_VALUES`
603--
604
605DROP TABLE IF EXISTS `ERR_TRACK_KEY_VALUES`;
606/*!40101 SET @saved_cs_client = @@character_set_client */;
607/*!40101 SET character_set_client = utf8 */;
608CREATE TABLE `ERR_TRACK_KEY_VALUES` (
609 `ETK_TAB_NR` smallint(6) NOT NULL,
610 `ETK_KEY` varchar(9) NOT NULL,
611 `ETK_LNG_ID` smallint(6) NOT NULL,
612 `ETK_SORTNR` smallint(6) DEFAULT NULL,
613 `ETK_DESCRIPTION` varchar(180) NOT NULL,
614 PRIMARY KEY (`ETK_TAB_NR`,`ETK_KEY`,`ETK_LNG_ID`)
615) ENGINE=MyISAM DEFAULT CHARSET=utf8;
616/*!40101 SET character_set_client = @saved_cs_client */;
617
618--
619-- Table structure for table `FILTERS`
620--
621
622DROP TABLE IF EXISTS `FILTERS`;
623/*!40101 SET @saved_cs_client = @@character_set_client */;
624/*!40101 SET character_set_client = utf8 */;
625CREATE TABLE `FILTERS` (
626 `FIL_USS_ID` int(11) NOT NULL,
627 `FIL_KIND` smallint(6) NOT NULL,
628 `FIL_VALUE` int(11) NOT NULL,
629 PRIMARY KEY (`FIL_USS_ID`,`FIL_KIND`,`FIL_VALUE`)
630) ENGINE=MyISAM DEFAULT CHARSET=utf8;
631/*!40101 SET character_set_client = @saved_cs_client */;
632
633--
634-- Table structure for table `GENERIC_ARTICLES`
635--
636
637DROP TABLE IF EXISTS `GENERIC_ARTICLES`;
638/*!40101 SET @saved_cs_client = @@character_set_client */;
639/*!40101 SET character_set_client = utf8 */;
640CREATE TABLE `GENERIC_ARTICLES` (
641 `GA_ID` int(11) NOT NULL,
642 `GA_NR` smallint(6) DEFAULT NULL,
643 `GA_DES_ID` int(11) NOT NULL,
644 `GA_DES_ID_STANDARD` int(11) NOT NULL,
645 `GA_DES_ID_ASSEMBLY` int(11) DEFAULT NULL,
646 `GA_DES_ID_INTENDED` int(11) DEFAULT NULL,
647 `GA_UNIVERSAL` smallint(6) DEFAULT NULL,
648 PRIMARY KEY (`GA_ID`)
649) ENGINE=MyISAM DEFAULT CHARSET=utf8;
650/*!40101 SET character_set_client = @saved_cs_client */;
651
652--
653-- Table structure for table `GRAPHICS`
654--
655
656DROP TABLE IF EXISTS `GRAPHICS`;
657/*!40101 SET @saved_cs_client = @@character_set_client */;
658/*!40101 SET character_set_client = utf8 */;
659CREATE TABLE `GRAPHICS` (
660 `GRA_SUP_ID` smallint(6) DEFAULT NULL,
661 `GRA_ID` varchar(11) NOT NULL,
662 `GRA_DOC_TYPE` tinyint(4) DEFAULT NULL,
663 `GRA_LNG_ID` smallint(6) NOT NULL,
664 `GRA_GRD_ID` varchar(14) DEFAULT NULL,
665 `GRA_TYPE` smallint(6) DEFAULT NULL,
666 `GRA_NORM` varchar(9) DEFAULT NULL,
667 `GRA_SUPPLIER_NR` smallint(6) DEFAULT NULL,
668 `GRA_TAB_NR` smallint(6) DEFAULT NULL,
669 `GRA_DES_ID` int(11) DEFAULT NULL,
670 PRIMARY KEY (`GRA_ID`,`GRA_LNG_ID`)
671) ENGINE=MyISAM DEFAULT CHARSET=utf8;
672/*!40101 SET character_set_client = @saved_cs_client */;
673
674--
675-- Table structure for table `KEY_VALUES`
676--
677
678DROP TABLE IF EXISTS `KEY_VALUES`;
679/*!40101 SET @saved_cs_client = @@character_set_client */;
680/*!40101 SET character_set_client = utf8 */;
681CREATE TABLE `KEY_VALUES` (
682 `KV_KT_ID` smallint(6) NOT NULL,
683 `KV_KV` varchar(9) NOT NULL,
684 `KV_DES_ID` int(11) DEFAULT NULL,
685 PRIMARY KEY (`KV_KV`,`KV_KT_ID`)
686) ENGINE=MyISAM DEFAULT CHARSET=utf8;
687/*!40101 SET character_set_client = @saved_cs_client */;
688
689--
690-- Table structure for table `LANGUAGES`
691--
692
693DROP TABLE IF EXISTS `LANGUAGES`;
694/*!40101 SET @saved_cs_client = @@character_set_client */;
695/*!40101 SET character_set_client = utf8 */;
696CREATE TABLE `LANGUAGES` (
697 `LNG_ID` smallint(6) NOT NULL,
698 `LNG_DES_ID` int(11) DEFAULT NULL,
699 `LNG_ISO2` varchar(6) DEFAULT NULL,
700 `LNG_CODEPAGE` varchar(30) DEFAULT NULL,
701 PRIMARY KEY (`LNG_ID`)
702) ENGINE=MyISAM DEFAULT CHARSET=utf8;
703/*!40101 SET character_set_client = @saved_cs_client */;
704
705--
706-- Table structure for table `LA_CRITERIA`
707--
708
709DROP TABLE IF EXISTS `LA_CRITERIA`;
710/*!40101 SET @saved_cs_client = @@character_set_client */;
711/*!40101 SET character_set_client = utf8 */;
712CREATE TABLE `LA_CRITERIA` (
713 `LAC_LA_ID` int(11) NOT NULL,
714 `LAC_SORT` int(11) NOT NULL,
715 `LAC_CRI_ID` smallint(6) NOT NULL,
716 `LAC_VALUE` varchar(60) DEFAULT NULL,
717 `LAC_KV_DES_ID` int(11) DEFAULT NULL,
718 `LAC_DISPLAY` smallint(6) DEFAULT NULL,
719 PRIMARY KEY (`LAC_LA_ID`,`LAC_SORT`)
720) ENGINE=MyISAM DEFAULT CHARSET=utf8;
721/*!40101 SET character_set_client = @saved_cs_client */;
722
723--
724-- Table structure for table `LA_INFO`
725--
726
727DROP TABLE IF EXISTS `LA_INFO`;
728/*!40101 SET @saved_cs_client = @@character_set_client */;
729/*!40101 SET character_set_client = utf8 */;
730CREATE TABLE `LA_INFO` (
731 `LIN_LA_ID` int(11) NOT NULL,
732 `LIN_SORT` smallint(6) NOT NULL,
733 `LIN_KV_TYPE` varchar(9) NOT NULL,
734 `LIN_DISPLAY` smallint(6) NOT NULL,
735 `LIN_TMO_ID` int(11) DEFAULT NULL,
736 PRIMARY KEY (`LIN_LA_ID`,`LIN_SORT`,`LIN_KV_TYPE`)
737) ENGINE=MyISAM DEFAULT CHARSET=utf8;
738/*!40101 SET character_set_client = @saved_cs_client */;
739
740--
741-- Table structure for table `LINK_ART`
742--
743
744DROP TABLE IF EXISTS `LINK_ART`;
745/*!40101 SET @saved_cs_client = @@character_set_client */;
746/*!40101 SET character_set_client = utf8 */;
747CREATE TABLE `LINK_ART` (
748 `LA_ID` int(11) NOT NULL,
749 `LA_ART_ID` int(11) NOT NULL,
750 `LA_GA_ID` int(11) NOT NULL,
751 `LA_SORT` int(11) NOT NULL,
752 PRIMARY KEY (`LA_ID`),
753 KEY `LA_ART_ID` (`LA_ART_ID`)
754) ENGINE=MyISAM DEFAULT CHARSET=utf8;
755/*!40101 SET character_set_client = @saved_cs_client */;
756
757--
758-- Table structure for table `LINK_ART_GA`
759--
760
761DROP TABLE IF EXISTS `LINK_ART_GA`;
762/*!40101 SET @saved_cs_client = @@character_set_client */;
763/*!40101 SET character_set_client = utf8 */;
764CREATE TABLE `LINK_ART_GA` (
765 `LAG_ART_ID` int(11) NOT NULL,
766 `LAG_GA_ID` int(11) NOT NULL,
767 `LAG_SUP_ID` smallint(6) DEFAULT NULL,
768 PRIMARY KEY (`LAG_ART_ID`,`LAG_GA_ID`),
769 KEY `LAG_GA_ID` (`LAG_GA_ID`)
770) ENGINE=MyISAM DEFAULT CHARSET=utf8;
771/*!40101 SET character_set_client = @saved_cs_client */;
772
773--
774-- Table structure for table `LINK_CAB_TYP`
775--
776
777DROP TABLE IF EXISTS `LINK_CAB_TYP`;
778/*!40101 SET @saved_cs_client = @@character_set_client */;
779/*!40101 SET character_set_client = utf8 */;
780CREATE TABLE `LINK_CAB_TYP` (
781 `LCT_TYP_ID` int(11) NOT NULL,
782 `LCT_NR` smallint(6) NOT NULL,
783 `LCT_CAB_ID` int(11) NOT NULL,
784 `LCT_PCON_START` int(11) NOT NULL DEFAULT '0',
785 `LCT_PCON_END` int(11) NOT NULL DEFAULT '0',
786 PRIMARY KEY (`LCT_TYP_ID`,`LCT_NR`,`LCT_CAB_ID`,`LCT_PCON_START`,`LCT_PCON_END`)
787) ENGINE=MyISAM DEFAULT CHARSET=utf8;
788/*!40101 SET character_set_client = @saved_cs_client */;
789
790--
791-- Table structure for table `LINK_GA_CRI`
792--
793
794DROP TABLE IF EXISTS `LINK_GA_CRI`;
795/*!40101 SET @saved_cs_client = @@character_set_client */;
796/*!40101 SET character_set_client = utf8 */;
797CREATE TABLE `LINK_GA_CRI` (
798 `LGC_GA_NR` smallint(6) NOT NULL,
799 `LGC_CRI_ID` smallint(6) NOT NULL,
800 `LGC_SORT` smallint(6) NOT NULL,
801 `LGC_SUGGESTION` smallint(4) NOT NULL,
802 PRIMARY KEY (`LGC_GA_NR`,`LGC_CRI_ID`,`LGC_SORT`)
803) ENGINE=MyISAM DEFAULT CHARSET=utf8;
804/*!40101 SET character_set_client = @saved_cs_client */;
805
806--
807-- Table structure for table `LINK_GA_STR`
808--
809
810DROP TABLE IF EXISTS `LINK_GA_STR`;
811/*!40101 SET @saved_cs_client = @@character_set_client */;
812/*!40101 SET character_set_client = utf8 */;
813CREATE TABLE `LINK_GA_STR` (
814 `LGS_STR_ID` int(11) NOT NULL,
815 `LGS_GA_ID` int(11) NOT NULL,
816 PRIMARY KEY (`LGS_STR_ID`,`LGS_GA_ID`)
817) ENGINE=MyISAM DEFAULT CHARSET=utf8;
818/*!40101 SET character_set_client = @saved_cs_client */;
819
820--
821-- Table structure for table `LINK_GRA_ART`
822--
823
824DROP TABLE IF EXISTS `LINK_GRA_ART`;
825/*!40101 SET @saved_cs_client = @@character_set_client */;
826/*!40101 SET character_set_client = utf8 */;
827CREATE TABLE `LINK_GRA_ART` (
828 `LGA_ART_ID` int(11) NOT NULL,
829 `LGA_SORT` smallint(6) NOT NULL,
830 `LGA_GRA_ID` varchar(11) NOT NULL,
831 PRIMARY KEY (`LGA_ART_ID`,`LGA_SORT`)
832) ENGINE=MyISAM DEFAULT CHARSET=utf8;
833/*!40101 SET character_set_client = @saved_cs_client */;
834
835--
836-- Table structure for table `LINK_GRA_LA`
837--
838
839DROP TABLE IF EXISTS `LINK_GRA_LA`;
840/*!40101 SET @saved_cs_client = @@character_set_client */;
841/*!40101 SET character_set_client = utf8 */;
842CREATE TABLE `LINK_GRA_LA` (
843 `LGL_LA_ID` int(11) NOT NULL,
844 `LGL_TYP_ID` int(11) NOT NULL DEFAULT '0',
845 `LGL_ENG_ID` int(11) NOT NULL DEFAULT '0',
846 `LGL_AXL_ID` int(11) NOT NULL DEFAULT '0',
847 `LGL_MRK_ID` int(11) NOT NULL DEFAULT '0',
848 `LGL_SORT` smallint(6) NOT NULL,
849 `LGL_GRA_ID` varchar(11) NOT NULL,
850 PRIMARY KEY (`LGL_LA_ID`,`LGL_TYP_ID`,`LGL_ENG_ID`,`LGL_AXL_ID`,`LGL_MRK_ID`,`LGL_SORT`)
851) ENGINE=MyISAM DEFAULT CHARSET=utf8;
852/*!40101 SET character_set_client = @saved_cs_client */;
853
854--
855-- Table structure for table `LINK_LA_AXL`
856--
857
858DROP TABLE IF EXISTS `LINK_LA_AXL`;
859/*!40101 SET @saved_cs_client = @@character_set_client */;
860/*!40101 SET character_set_client = utf8 */;
861CREATE TABLE `LINK_LA_AXL` (
862 `LAA_LA_ID` int(11) NOT NULL,
863 `LAA_AXL_ID` int(11) NOT NULL,
864 `LAA_GA_ID` int(11) NOT NULL,
865 `LAA_SUP_ID` smallint(6) DEFAULT NULL,
866 `LAA_SORT` int(11) NOT NULL,
867 PRIMARY KEY (`LAA_GA_ID`,`LAA_LA_ID`,`LAA_SORT`,`LAA_AXL_ID`)
868) ENGINE=MyISAM DEFAULT CHARSET=utf8;
869/*!40101 SET character_set_client = @saved_cs_client */;
870
871--
872-- Table structure for table `LINK_LA_AXL_NEW`
873--
874
875DROP TABLE IF EXISTS `LINK_LA_AXL_NEW`;
876/*!40101 SET @saved_cs_client = @@character_set_client */;
877/*!40101 SET character_set_client = utf8 */;
878CREATE TABLE `LINK_LA_AXL_NEW` (
879 `LAAN_LA_ID` int(11) NOT NULL,
880 `LAAN_AXL_ID` int(11) NOT NULL,
881 `LAAN_GA_ID` int(11) NOT NULL,
882 `LAAN_SUP_ID` smallint(6) NOT NULL DEFAULT '0',
883 `LAAN_SORT` int(11) NOT NULL,
884 PRIMARY KEY (`LAAN_LA_ID`,`LAAN_AXL_ID`,`LAAN_GA_ID`,`LAAN_SUP_ID`,`LAAN_SORT`)
885) ENGINE=MyISAM DEFAULT CHARSET=utf8;
886/*!40101 SET character_set_client = @saved_cs_client */;
887
888--
889-- Table structure for table `LINK_LA_ENG`
890--
891
892DROP TABLE IF EXISTS `LINK_LA_ENG`;
893/*!40101 SET @saved_cs_client = @@character_set_client */;
894/*!40101 SET character_set_client = utf8 */;
895CREATE TABLE `LINK_LA_ENG` (
896 `LAE_LA_ID` int(11) NOT NULL,
897 `LAE_ENG_ID` int(11) NOT NULL,
898 `LAE_GA_ID` int(11) NOT NULL,
899 `LAE_SUP_ID` smallint(6) DEFAULT NULL,
900 `LAE_SORT` int(11) NOT NULL,
901 PRIMARY KEY (`LAE_ENG_ID`,`LAE_GA_ID`,`LAE_LA_ID`,`LAE_SORT`)
902) ENGINE=MyISAM DEFAULT CHARSET=utf8;
903/*!40101 SET character_set_client = @saved_cs_client */;
904
905--
906-- Table structure for table `LINK_LA_ENG_NEW`
907--
908
909DROP TABLE IF EXISTS `LINK_LA_ENG_NEW`;
910/*!40101 SET @saved_cs_client = @@character_set_client */;
911/*!40101 SET character_set_client = utf8 */;
912CREATE TABLE `LINK_LA_ENG_NEW` (
913 `LAEN_SUP_ID` smallint(6) NOT NULL DEFAULT '0',
914 `LAEN_GA_ID` int(11) NOT NULL DEFAULT '0',
915 `LAEN_LA_ID` int(11) NOT NULL DEFAULT '0',
916 `LAEN_ENG_ID` int(11) NOT NULL DEFAULT '0',
917 `LAEN_SORT` int(11) NOT NULL DEFAULT '0',
918 PRIMARY KEY (`LAEN_SUP_ID`,`LAEN_GA_ID`,`LAEN_LA_ID`,`LAEN_ENG_ID`,`LAEN_SORT`)
919) ENGINE=MyISAM DEFAULT CHARSET=utf8;
920/*!40101 SET character_set_client = @saved_cs_client */;
921
922--
923-- Table structure for table `LINK_LA_MRK`
924--
925
926DROP TABLE IF EXISTS `LINK_LA_MRK`;
927/*!40101 SET @saved_cs_client = @@character_set_client */;
928/*!40101 SET character_set_client = utf8 */;
929CREATE TABLE `LINK_LA_MRK` (
930 `LAM_LA_ID` int(11) NOT NULL,
931 `LAM_MRK_ID` int(11) NOT NULL,
932 `LAM_GA_ID` int(11) NOT NULL,
933 `LAM_SUP_ID` smallint(6) DEFAULT NULL,
934 `LAM_SORT` int(11) NOT NULL,
935 PRIMARY KEY (`LAM_MRK_ID`,`LAM_GA_ID`,`LAM_LA_ID`,`LAM_SORT`)
936) ENGINE=MyISAM DEFAULT CHARSET=utf8;
937/*!40101 SET character_set_client = @saved_cs_client */;
938
939--
940-- Table structure for table `LINK_LA_MRK_NEW`
941--
942
943DROP TABLE IF EXISTS `LINK_LA_MRK_NEW`;
944/*!40101 SET @saved_cs_client = @@character_set_client */;
945/*!40101 SET character_set_client = utf8 */;
946CREATE TABLE `LINK_LA_MRK_NEW` (
947 `LAMN_LA_ID` int(11) NOT NULL DEFAULT '0',
948 `LAMN_MRK_ID` int(11) NOT NULL DEFAULT '0',
949 `LAMN_GA_ID` int(11) NOT NULL DEFAULT '0',
950 `LAMN_SUP_ID` smallint(6) NOT NULL DEFAULT '0',
951 `LAMN_SORT` int(11) NOT NULL DEFAULT '0',
952 PRIMARY KEY (`LAMN_LA_ID`,`LAMN_MRK_ID`,`LAMN_GA_ID`,`LAMN_SUP_ID`,`LAMN_SORT`)
953) ENGINE=MyISAM DEFAULT CHARSET=utf8;
954/*!40101 SET character_set_client = @saved_cs_client */;
955
956--
957-- Table structure for table `LINK_LA_TYP`
958--
959
960DROP TABLE IF EXISTS `LINK_LA_TYP`;
961/*!40101 SET @saved_cs_client = @@character_set_client */;
962/*!40101 SET character_set_client = utf8 */;
963CREATE TABLE `LINK_LA_TYP` (
964 `LAT_TYP_ID` int(11) NOT NULL,
965 `LAT_LA_ID` int(11) NOT NULL,
966 `LAT_GA_ID` int(11) NOT NULL,
967 `LAT_SUP_ID` smallint(6) DEFAULT NULL,
968 `LAT_SORT` int(11) NOT NULL,
969 PRIMARY KEY (`LAT_TYP_ID`,`LAT_GA_ID`,`LAT_LA_ID`,`LAT_SORT`),
970 KEY `LAT_LA_ID` (`LAT_LA_ID`)
971) ENGINE=MyISAM DEFAULT CHARSET=utf8;
972/*!40101 SET character_set_client = @saved_cs_client */;
973
974--
975-- Table structure for table `LINK_LA_TYP_NEW`
976--
977
978DROP TABLE IF EXISTS `LINK_LA_TYP_NEW`;
979/*!40101 SET @saved_cs_client = @@character_set_client */;
980/*!40101 SET character_set_client = utf8 */;
981CREATE TABLE `LINK_LA_TYP_NEW` (
982 `LATN_SUP_ID` smallint(6) NOT NULL,
983 `LATN_GA_ID` int(11) NOT NULL,
984 `LATN_TYP_ID` int(11) NOT NULL,
985 `LATN_LA_ID` int(11) NOT NULL,
986 `LATN_SORT` int(11) NOT NULL,
987 PRIMARY KEY (`LATN_SUP_ID`,`LATN_GA_ID`,`LATN_TYP_ID`,`LATN_LA_ID`,`LATN_SORT`)
988) ENGINE=MyISAM DEFAULT CHARSET=utf8;
989/*!40101 SET character_set_client = @saved_cs_client */;
990
991--
992-- Table structure for table `LINK_SHO_STR`
993--
994
995DROP TABLE IF EXISTS `LINK_SHO_STR`;
996/*!40101 SET @saved_cs_client = @@character_set_client */;
997/*!40101 SET character_set_client = utf8 */;
998CREATE TABLE `LINK_SHO_STR` (
999 `LSS_SHO_ID` smallint(6) NOT NULL,
1000 `LSS_STR_ID` int(11) NOT NULL,
1001 `LSS_EXPAND` smallint(6) DEFAULT NULL,
1002 `LSS_LEVEL` smallint(6) NOT NULL,
1003 `LSS_SORT` smallint(6) DEFAULT NULL,
1004 PRIMARY KEY (`LSS_SHO_ID`,`LSS_STR_ID`,`LSS_LEVEL`)
1005) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1006/*!40101 SET character_set_client = @saved_cs_client */;
1007
1008--
1009-- Table structure for table `LINK_SHO_STR_TYPE`
1010--
1011
1012DROP TABLE IF EXISTS `LINK_SHO_STR_TYPE`;
1013/*!40101 SET @saved_cs_client = @@character_set_client */;
1014/*!40101 SET character_set_client = utf8 */;
1015CREATE TABLE `LINK_SHO_STR_TYPE` (
1016 `LST_STR_TYPE` smallint(6) NOT NULL,
1017 `LST_SHO_ID` smallint(6) NOT NULL,
1018 `LST_SORT` smallint(6) DEFAULT NULL,
1019 PRIMARY KEY (`LST_STR_TYPE`,`LST_SHO_ID`)
1020) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1021/*!40101 SET character_set_client = @saved_cs_client */;
1022
1023--
1024-- Table structure for table `LINK_TYP_AXL`
1025--
1026
1027DROP TABLE IF EXISTS `LINK_TYP_AXL`;
1028/*!40101 SET @saved_cs_client = @@character_set_client */;
1029/*!40101 SET character_set_client = utf8 */;
1030CREATE TABLE `LINK_TYP_AXL` (
1031 `LTA_TYP_ID` int(11) NOT NULL,
1032 `LTA_SORT` smallint(6) NOT NULL,
1033 `LTA_AXL_ID` int(11) NOT NULL,
1034 `LTA_PCON_START` int(11) DEFAULT NULL,
1035 `LTA_PCON_END` int(11) DEFAULT NULL,
1036 `LTA_KV_AXLE_POS_DES_ID` int(11) DEFAULT NULL,
1037 PRIMARY KEY (`LTA_TYP_ID`,`LTA_SORT`,`LTA_AXL_ID`)
1038) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1039/*!40101 SET character_set_client = @saved_cs_client */;
1040
1041--
1042-- Table structure for table `LINK_TYP_ENG`
1043--
1044
1045DROP TABLE IF EXISTS `LINK_TYP_ENG`;
1046/*!40101 SET @saved_cs_client = @@character_set_client */;
1047/*!40101 SET character_set_client = utf8 */;
1048CREATE TABLE `LINK_TYP_ENG` (
1049 `LTE_TYP_ID` int(11) NOT NULL,
1050 `LTE_NR` smallint(6) NOT NULL,
1051 `LTE_ENG_ID` int(11) NOT NULL,
1052 `LTE_PCON_START` int(11) DEFAULT NULL,
1053 `LTE_PCON_END` int(11) DEFAULT NULL,
1054 PRIMARY KEY (`LTE_TYP_ID`,`LTE_NR`,`LTE_ENG_ID`)
1055) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1056/*!40101 SET character_set_client = @saved_cs_client */;
1057
1058--
1059-- Table structure for table `LINK_TYP_MRK`
1060--
1061
1062DROP TABLE IF EXISTS `LINK_TYP_MRK`;
1063/*!40101 SET @saved_cs_client = @@character_set_client */;
1064/*!40101 SET character_set_client = utf8 */;
1065CREATE TABLE `LINK_TYP_MRK` (
1066 `LMK_TYP_ID` int(11) NOT NULL,
1067 `LMK_MRK_ID` int(11) NOT NULL,
1068 PRIMARY KEY (`LMK_TYP_ID`,`LMK_MRK_ID`)
1069) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1070/*!40101 SET character_set_client = @saved_cs_client */;
1071
1072--
1073-- Table structure for table `MANUFACTURERS`
1074--
1075
1076DROP TABLE IF EXISTS `MANUFACTURERS`;
1077/*!40101 SET @saved_cs_client = @@character_set_client */;
1078/*!40101 SET character_set_client = utf8 */;
1079CREATE TABLE `MANUFACTURERS` (
1080 `MFA_ID` smallint(6) NOT NULL,
1081 `MFA_PC_MFC` smallint(6) DEFAULT NULL,
1082 `MFA_CV_MFC` smallint(6) DEFAULT NULL,
1083 `MFA_AXL_MFC` smallint(6) DEFAULT NULL,
1084 `MFA_ENG_MFC` smallint(6) DEFAULT NULL,
1085 `MFA_ENG_TYP` smallint(6) DEFAULT NULL,
1086 `MFA_MFC_CODE` varchar(30) DEFAULT NULL,
1087 `MFA_BRAND` varchar(60) DEFAULT NULL,
1088 `MFA_MF_NR` int(11) DEFAULT NULL,
1089 PRIMARY KEY (`MFA_ID`),
1090 KEY `MFA_BRAND` (`MFA_BRAND`(14))
1091) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1092/*!40101 SET character_set_client = @saved_cs_client */;
1093
1094--
1095-- Table structure for table `MODELS`
1096--
1097
1098DROP TABLE IF EXISTS `MODELS`;
1099/*!40101 SET @saved_cs_client = @@character_set_client */;
1100/*!40101 SET character_set_client = utf8 */;
1101CREATE TABLE `MODELS` (
1102 `MOD_ID` int(11) NOT NULL,
1103 `MOD_MFA_ID` smallint(6) DEFAULT NULL,
1104 `MOD_CDS_ID` int(11) DEFAULT NULL,
1105 `MOD_PCON_START` int(11) DEFAULT NULL,
1106 `MOD_PCON_END` int(11) DEFAULT NULL,
1107 `MOD_PC` smallint(6) DEFAULT NULL,
1108 `MOD_CV` smallint(6) DEFAULT NULL,
1109 `MOD_AXL` smallint(6) DEFAULT NULL,
1110 PRIMARY KEY (`MOD_ID`),
1111 KEY `MOD_MFA_ID` (`MOD_MFA_ID`),
1112 KEY `MOD_CDS_ID` (`MOD_CDS_ID`)
1113) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1114/*!40101 SET character_set_client = @saved_cs_client */;
1115
1116--
1117-- Table structure for table `MOD_TYP_LOOKUP`
1118--
1119
1120DROP TABLE IF EXISTS `MOD_TYP_LOOKUP`;
1121/*!40101 SET @saved_cs_client = @@character_set_client */;
1122/*!40101 SET character_set_client = utf8 */;
1123CREATE TABLE `MOD_TYP_LOOKUP` (
1124 `MTL_TYP_ID` int(11) NOT NULL,
1125 `MTL_LNG_ID` smallint(6) NOT NULL,
1126 `MTL_SEARCH_TEXT` varchar(100) NOT NULL,
1127 KEY `MTL_TYP_ID` (`MTL_TYP_ID`,`MTL_LNG_ID`,`MTL_SEARCH_TEXT`(60))
1128) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1129/*!40101 SET character_set_client = @saved_cs_client */;
1130
1131--
1132-- Table structure for table `NUMBERPLATES_NL`
1133--
1134
1135DROP TABLE IF EXISTS `NUMBERPLATES_NL`;
1136/*!40101 SET @saved_cs_client = @@character_set_client */;
1137/*!40101 SET character_set_client = utf8 */;
1138CREATE TABLE `NUMBERPLATES_NL` (
1139 `NNL_NUMBERPLATE` varchar(8) NOT NULL,
1140 `NNL_TYP_ID` int(11) NOT NULL,
1141 PRIMARY KEY (`NNL_NUMBERPLATE`,`NNL_TYP_ID`)
1142) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1143/*!40101 SET character_set_client = @saved_cs_client */;
1144
1145--
1146-- Table structure for table `PARAMETERS`
1147--
1148
1149DROP TABLE IF EXISTS `PARAMETERS`;
1150/*!40101 SET @saved_cs_client = @@character_set_client */;
1151/*!40101 SET character_set_client = utf8 */;
1152CREATE TABLE `PARAMETERS` (
1153 `PAR_NAME` varchar(60) NOT NULL,
1154 `PAR_VALUE` text,
1155 PRIMARY KEY (`PAR_NAME`)
1156) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1157/*!40101 SET character_set_client = @saved_cs_client */;
1158
1159--
1160-- Table structure for table `PRICES`
1161--
1162
1163DROP TABLE IF EXISTS `PRICES`;
1164/*!40101 SET @saved_cs_client = @@character_set_client */;
1165/*!40101 SET character_set_client = utf8 */;
1166CREATE TABLE `PRICES` (
1167 `PRI_ART_ID` int(11) NOT NULL,
1168 `PRI_KV_PRICE_TYPE` varchar(9) NOT NULL,
1169 `PRI_PRICE` varchar(30) DEFAULT NULL,
1170 `PRI_KV_PRICE_UNIT_DES_ID` int(11) NOT NULL,
1171 `PRI_KV_QUANTITY_UNIT_DES_ID` int(11) NOT NULL,
1172 `PRI_VAL_START` datetime DEFAULT NULL,
1173 `PRI_VAL_END` datetime DEFAULT NULL,
1174 `PRI_CURRENCY_CODE` varchar(9) NOT NULL,
1175 `PRI_REBATE` varchar(15) DEFAULT NULL,
1176 `PRI_DISCOUNT_FLAG` smallint(6) NOT NULL,
1177 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`)
1178) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1179/*!40101 SET character_set_client = @saved_cs_client */;
1180
1181--
1182-- Table structure for table `SEARCH_TREE`
1183--
1184
1185DROP TABLE IF EXISTS `SEARCH_TREE`;
1186/*!40101 SET @saved_cs_client = @@character_set_client */;
1187/*!40101 SET character_set_client = utf8 */;
1188CREATE TABLE `SEARCH_TREE` (
1189 `STR_ID` int(11) NOT NULL,
1190 `STR_ID_PARENT` int(11) DEFAULT NULL,
1191 `STR_TYPE` smallint(6) DEFAULT NULL,
1192 `STR_LEVEL` smallint(6) DEFAULT NULL,
1193 `STR_DES_ID` int(11) DEFAULT NULL,
1194 `STR_SORT` smallint(6) DEFAULT NULL,
1195 `STR_NODE_NR` int(11) DEFAULT NULL,
1196 PRIMARY KEY (`STR_ID`),
1197 KEY `STR_ID_PARENT` (`STR_ID_PARENT`),
1198 KEY `STR_LEVEL` (`STR_LEVEL`)
1199) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1200/*!40101 SET character_set_client = @saved_cs_client */;
1201
1202--
1203-- Table structure for table `STR_FAMILY_TREE`
1204--
1205
1206DROP TABLE IF EXISTS `STR_FAMILY_TREE`;
1207/*!40101 SET @saved_cs_client = @@character_set_client */;
1208/*!40101 SET character_set_client = utf8 */;
1209CREATE TABLE `STR_FAMILY_TREE` (
1210 `SFT_ANCESTOR_STR_ID` int(11) NOT NULL,
1211 `SFT_DESCENDANT_STR_ID` int(11) NOT NULL,
1212 PRIMARY KEY (`SFT_ANCESTOR_STR_ID`,`SFT_DESCENDANT_STR_ID`)
1213) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1214/*!40101 SET character_set_client = @saved_cs_client */;
1215
1216--
1217-- Table structure for table `STR_LOOKUP`
1218--
1219
1220DROP TABLE IF EXISTS `STR_LOOKUP`;
1221/*!40101 SET @saved_cs_client = @@character_set_client */;
1222/*!40101 SET character_set_client = utf8 */;
1223CREATE TABLE `STR_LOOKUP` (
1224 `STL_LNG_ID` smallint(6) NOT NULL,
1225 `STL_SEARCH_TEXT` varchar(180) NOT NULL,
1226 `STL_STR_ID` int(11) NOT NULL,
1227 `STL_GA_ID` int(11) NOT NULL,
1228 KEY `STL_LNG_ID` (`STL_LNG_ID`,`STL_SEARCH_TEXT`,`STL_STR_ID`,`STL_GA_ID`)
1229) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1230/*!40101 SET character_set_client = @saved_cs_client */;
1231
1232--
1233-- Table structure for table `SUPERSEDED_ARTICLES`
1234--
1235
1236DROP TABLE IF EXISTS `SUPERSEDED_ARTICLES`;
1237/*!40101 SET @saved_cs_client = @@character_set_client */;
1238/*!40101 SET character_set_client = utf8 */;
1239CREATE TABLE `SUPERSEDED_ARTICLES` (
1240 `SUA_ART_ID` int(11) NOT NULL,
1241 `SUA_NUMBER` varchar(66) NOT NULL,
1242 `SUA_SORT` int(11) NOT NULL,
1243 PRIMARY KEY (`SUA_ART_ID`,`SUA_NUMBER`)
1244) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1245/*!40101 SET character_set_client = @saved_cs_client */;
1246
1247--
1248-- Table structure for table `SUPPLIERS`
1249--
1250
1251DROP TABLE IF EXISTS `SUPPLIERS`;
1252/*!40101 SET @saved_cs_client = @@character_set_client */;
1253/*!40101 SET character_set_client = utf8 */;
1254CREATE TABLE `SUPPLIERS` (
1255 `SUP_ID` smallint(6) NOT NULL,
1256 `SUP_BRAND` varchar(60) DEFAULT NULL,
1257 `SUP_SUPPLIER_NR` smallint(6) DEFAULT NULL,
1258 `SUP_COU_ID` smallint(6) DEFAULT NULL,
1259 `SUP_IS_HESS` smallint(6) DEFAULT NULL,
1260 PRIMARY KEY (`SUP_ID`),
1261 KEY `SUP_BRAND` (`SUP_BRAND`(20))
1262) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1263/*!40101 SET character_set_client = @saved_cs_client */;
1264
1265--
1266-- Table structure for table `SUPPLIER_ADDRESSES`
1267--
1268
1269DROP TABLE IF EXISTS `SUPPLIER_ADDRESSES`;
1270/*!40101 SET @saved_cs_client = @@character_set_client */;
1271/*!40101 SET character_set_client = utf8 */;
1272CREATE TABLE `SUPPLIER_ADDRESSES` (
1273 `SAD_SUP_ID` smallint(6) NOT NULL,
1274 `SAD_TYPE_OF_ADDRESS` varchar(9) NOT NULL,
1275 `SAD_COU_ID` smallint(6) NOT NULL DEFAULT '0',
1276 `SAD_NAME1` varchar(120) DEFAULT NULL,
1277 `SAD_NAME2` varchar(120) DEFAULT NULL,
1278 `SAD_STREET1` varchar(120) DEFAULT NULL,
1279 `SAD_STREET2` varchar(120) DEFAULT NULL,
1280 `SAD_POB` varchar(30) DEFAULT NULL,
1281 `SAD_COU_ID_POSTAL` smallint(6) DEFAULT NULL,
1282 `SAD_POSTAL_CODE_PLACE` varchar(24) DEFAULT NULL,
1283 `SAD_POSTAL_CODE_POB` varchar(24) DEFAULT NULL,
1284 `SAD_POSTAL_CODE_CUST` varchar(24) DEFAULT NULL,
1285 `SAD_CITY1` varchar(120) DEFAULT NULL,
1286 `SAD_CITY2` varchar(120) DEFAULT NULL,
1287 `SAD_TEL` varchar(120) DEFAULT NULL,
1288 `SAD_FAX` varchar(60) DEFAULT NULL,
1289 `SAD_EMAIL` varchar(180) DEFAULT NULL,
1290 `SAD_WEB` varchar(180) DEFAULT NULL,
1291 PRIMARY KEY (`SAD_SUP_ID`,`SAD_TYPE_OF_ADDRESS`,`SAD_COU_ID`)
1292) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1293/*!40101 SET character_set_client = @saved_cs_client */;
1294
1295--
1296-- Table structure for table `SUPPLIER_LOGOS`
1297--
1298
1299DROP TABLE IF EXISTS `SUPPLIER_LOGOS`;
1300/*!40101 SET @saved_cs_client = @@character_set_client */;
1301/*!40101 SET character_set_client = utf8 */;
1302CREATE TABLE `SUPPLIER_LOGOS` (
1303 `SLO_ID` smallint(6) NOT NULL,
1304 `SLO_SUP_ID` smallint(6) NOT NULL,
1305 `SLO_LNG_ID` smallint(6) NOT NULL,
1306 PRIMARY KEY (`SLO_ID`),
1307 KEY `SLO_SUP_ID` (`SLO_SUP_ID`,`SLO_LNG_ID`)
1308) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1309/*!40101 SET character_set_client = @saved_cs_client */;
1310
1311--
1312-- Table structure for table `TEXT_MODULES`
1313--
1314
1315DROP TABLE IF EXISTS `TEXT_MODULES`;
1316/*!40101 SET @saved_cs_client = @@character_set_client */;
1317/*!40101 SET character_set_client = utf8 */;
1318CREATE TABLE `TEXT_MODULES` (
1319 `TMO_ID` int(11) NOT NULL,
1320 `TMO_LNG_ID` smallint(6) NOT NULL,
1321 `TMO_FIXED` smallint(6) NOT NULL,
1322 `TMO_TMT_ID` int(11) NOT NULL,
1323 PRIMARY KEY (`TMO_ID`,`TMO_LNG_ID`)
1324) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1325/*!40101 SET character_set_client = @saved_cs_client */;
1326
1327--
1328-- Table structure for table `TEXT_MODULE_TEXTS`
1329--
1330
1331DROP TABLE IF EXISTS `TEXT_MODULE_TEXTS`;
1332/*!40101 SET @saved_cs_client = @@character_set_client */;
1333/*!40101 SET character_set_client = utf8 */;
1334CREATE TABLE `TEXT_MODULE_TEXTS` (
1335 `TMT_ID` int(11) NOT NULL DEFAULT '0',
1336 `TMT_TEXT` text,
1337 PRIMARY KEY (`TMT_ID`)
1338) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1339/*!40101 SET character_set_client = @saved_cs_client */;
1340
1341--
1342-- Table structure for table `TYPES`
1343--
1344
1345DROP TABLE IF EXISTS `TYPES`;
1346/*!40101 SET @saved_cs_client = @@character_set_client */;
1347/*!40101 SET character_set_client = utf8 */;
1348CREATE TABLE `TYPES` (
1349 `TYP_ID` int(11) NOT NULL,
1350 `TYP_CDS_ID` int(11) DEFAULT NULL,
1351 `TYP_MMT_CDS_ID` int(11) DEFAULT NULL,
1352 `TYP_MOD_ID` int(11) NOT NULL,
1353 `TYP_SORT` int(11) NOT NULL,
1354 `TYP_PCON_START` int(11) DEFAULT NULL,
1355 `TYP_PCON_END` int(11) DEFAULT NULL,
1356 `TYP_KW_FROM` int(11) DEFAULT NULL,
1357 `TYP_KW_UPTO` int(11) DEFAULT NULL,
1358 `TYP_HP_FROM` int(11) DEFAULT NULL,
1359 `TYP_HP_UPTO` int(11) DEFAULT NULL,
1360 `TYP_CCM` int(11) DEFAULT NULL,
1361 `TYP_CYLINDERS` smallint(6) DEFAULT NULL,
1362 `TYP_DOORS` smallint(6) DEFAULT NULL,
1363 `TYP_TANK` smallint(6) DEFAULT NULL,
1364 `TYP_KV_VOLTAGE_DES_ID` int(11) DEFAULT NULL,
1365 `TYP_KV_ABS_DES_ID` int(11) DEFAULT NULL,
1366 `TYP_KV_ASR_DES_ID` int(11) DEFAULT NULL,
1367 `TYP_KV_ENGINE_DES_ID` int(11) DEFAULT NULL,
1368 `TYP_KV_BRAKE_TYPE_DES_ID` int(11) DEFAULT NULL,
1369 `TYP_KV_BRAKE_SYST_DES_ID` int(11) DEFAULT NULL,
1370 `TYP_KV_FUEL_DES_ID` int(11) DEFAULT NULL,
1371 `TYP_KV_CATALYST_DES_ID` int(11) DEFAULT NULL,
1372 `TYP_KV_BODY_DES_ID` int(11) DEFAULT NULL,
1373 `TYP_KV_STEERING_DES_ID` int(11) DEFAULT NULL,
1374 `TYP_KV_STEERING_SIDE_DES_ID` int(11) DEFAULT NULL,
1375 `TYP_MAX_WEIGHT` double DEFAULT NULL,
1376 `TYP_KV_MODEL_DES_ID` int(11) DEFAULT NULL,
1377 `TYP_KV_AXLE_DES_ID` int(11) DEFAULT NULL,
1378 `TYP_CCM_TAX` int(11) DEFAULT NULL,
1379 `TYP_LITRES` double DEFAULT NULL,
1380 `TYP_KV_DRIVE_DES_ID` int(11) DEFAULT NULL,
1381 `TYP_KV_TRANS_DES_ID` int(11) DEFAULT NULL,
1382 `TYP_KV_FUEL_SUPPLY_DES_ID` int(11) DEFAULT NULL,
1383 `TYP_VALVES` smallint(6) DEFAULT NULL,
1384 `TYP_RT_EXISTS` smallint(6) DEFAULT NULL,
1385 PRIMARY KEY (`TYP_ID`),
1386 KEY `TYP_MOD_ID` (`TYP_MOD_ID`),
1387 KEY `TYP_CDS_ID` (`TYP_CDS_ID`)
1388) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1389/*!40101 SET character_set_client = @saved_cs_client */;
1390
1391--
1392-- Table structure for table `TYPE_NUMBERS`
1393--
1394
1395DROP TABLE IF EXISTS `TYPE_NUMBERS`;
1396/*!40101 SET @saved_cs_client = @@character_set_client */;
1397/*!40101 SET character_set_client = utf8 */;
1398CREATE TABLE `TYPE_NUMBERS` (
1399 `TYN_TYP_ID` int(11) NOT NULL,
1400 `TYN_SEARCH_TEXT` varchar(60) NOT NULL,
1401 `TYN_KIND` smallint(6) NOT NULL,
1402 `TYN_DISPLAY_NR` varchar(60) NOT NULL DEFAULT '',
1403 `TYN_GOP_NR` varchar(75) NOT NULL DEFAULT '',
1404 `TYN_GOP_START` int(11) NOT NULL DEFAULT '0',
1405 PRIMARY KEY (`TYN_TYP_ID`,`TYN_SEARCH_TEXT`,`TYN_KIND`,`TYN_DISPLAY_NR`,`TYN_GOP_NR`,`TYN_GOP_START`),
1406 KEY `TYN_SEARCH_TEXT` (`TYN_SEARCH_TEXT`(12),`TYN_KIND`)
1407) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1408/*!40101 SET character_set_client = @saved_cs_client */;
1409
1410--
1411-- Table structure for table `TYP_COUNTRY_SPECIFICS`
1412--
1413
1414DROP TABLE IF EXISTS `TYP_COUNTRY_SPECIFICS`;
1415/*!40101 SET @saved_cs_client = @@character_set_client */;
1416/*!40101 SET character_set_client = utf8 */;
1417CREATE TABLE `TYP_COUNTRY_SPECIFICS` (
1418 `TYC_TYP_ID` int(11) NOT NULL,
1419 `TYC_COU_ID` smallint(6) NOT NULL,
1420 `TYC_PCON_START` int(11) DEFAULT NULL,
1421 `TYC_PCON_END` int(11) DEFAULT NULL,
1422 `TYC_KW_FROM` int(11) DEFAULT NULL,
1423 `TYC_KW_UPTO` int(11) DEFAULT NULL,
1424 `TYC_HP_FROM` int(11) DEFAULT NULL,
1425 `TYC_HP_UPTO` int(11) DEFAULT NULL,
1426 `TYC_CCM` int(11) DEFAULT NULL,
1427 `TYC_CYLINDERS` smallint(6) DEFAULT NULL,
1428 `TYC_DOORS` smallint(6) DEFAULT NULL,
1429 `TYC_TANK` smallint(6) DEFAULT NULL,
1430 `TYC_KV_VOLTAGE_DES_ID` int(11) DEFAULT NULL,
1431 `TYC_KV_ABS_DES_ID` int(11) DEFAULT NULL,
1432 `TYC_KV_ASR_DES_ID` int(11) DEFAULT NULL,
1433 `TYC_KV_ENGINE_DES_ID` int(11) DEFAULT NULL,
1434 `TYC_KV_BRAKE_TYPE_DES_ID` int(11) DEFAULT NULL,
1435 `TYC_KV_BRAKE_SYST_DES_ID` int(11) DEFAULT NULL,
1436 `TYC_KV_CATALYST_DES_ID` int(11) DEFAULT NULL,
1437 `TYC_KV_BODY_DES_ID` int(11) DEFAULT NULL,
1438 `TYC_KV_STEERING_DES_ID` int(11) DEFAULT NULL,
1439 `TYC_KV_STEERING_SIDE_DES_ID` int(11) DEFAULT NULL,
1440 `TYC_MAX_WEIGHT` double DEFAULT NULL,
1441 `TYC_KV_MODEL_DES_ID` int(11) DEFAULT NULL,
1442 `TYC_KV_AXLE_DES_ID` int(11) DEFAULT NULL,
1443 `TYC_CCM_TAX` int(11) DEFAULT NULL,
1444 `TYC_LITRES` double DEFAULT NULL,
1445 `TYC_KV_DRIVE_DES_ID` int(11) DEFAULT NULL,
1446 `TYC_KV_TRANS_DES_ID` int(11) DEFAULT NULL,
1447 PRIMARY KEY (`TYC_TYP_ID`,`TYC_COU_ID`)
1448) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1449/*!40101 SET character_set_client = @saved_cs_client */;
1450
1451--
1452-- Table structure for table `TYP_SUSPENSIONS`
1453--
1454
1455DROP TABLE IF EXISTS `TYP_SUSPENSIONS`;
1456/*!40101 SET @saved_cs_client = @@character_set_client */;
1457/*!40101 SET character_set_client = utf8 */;
1458CREATE TABLE `TYP_SUSPENSIONS` (
1459 `TSU_TYP_ID` int(11) NOT NULL,
1460 `TSU_NR` smallint(6) NOT NULL,
1461 `TSU_KV_SUSPENSION_DES_ID` int(11) NOT NULL,
1462 `TSU_KV_AXLE_POS_DES_ID` int(11) NOT NULL,
1463 PRIMARY KEY (`TSU_TYP_ID`,`TSU_NR`,`TSU_KV_SUSPENSION_DES_ID`,`TSU_KV_AXLE_POS_DES_ID`)
1464) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1465/*!40101 SET character_set_client = @saved_cs_client */;
1466
1467--
1468-- Table structure for table `TYP_VOLTAGES`
1469--
1470
1471DROP TABLE IF EXISTS `TYP_VOLTAGES`;
1472/*!40101 SET @saved_cs_client = @@character_set_client */;
1473/*!40101 SET character_set_client = utf8 */;
1474CREATE TABLE `TYP_VOLTAGES` (
1475 `TVO_TYP_ID` int(11) NOT NULL,
1476 `TVO_NR` smallint(6) NOT NULL,
1477 `TVO_KV_VOLTAGE_DES_ID` int(11) NOT NULL,
1478 PRIMARY KEY (`TVO_TYP_ID`,`TVO_NR`,`TVO_KV_VOLTAGE_DES_ID`)
1479) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1480/*!40101 SET character_set_client = @saved_cs_client */;
1481
1482--
1483-- Table structure for table `TYP_WHEEL_BASES`
1484--
1485
1486DROP TABLE IF EXISTS `TYP_WHEEL_BASES`;
1487/*!40101 SET @saved_cs_client = @@character_set_client */;
1488/*!40101 SET character_set_client = utf8 */;
1489CREATE TABLE `TYP_WHEEL_BASES` (
1490 `TWB_TYP_ID` int(11) NOT NULL,
1491 `TWB_NR` smallint(6) NOT NULL,
1492 `TWB_WHEEL_BASE` int(11) NOT NULL,
1493 `TWB_KV_AXLE_POS_DES_ID` int(11) NOT NULL,
1494 PRIMARY KEY (`TWB_TYP_ID`,`TWB_NR`,`TWB_WHEEL_BASE`,`TWB_KV_AXLE_POS_DES_ID`)
1495) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1496/*!40101 SET character_set_client = @saved_cs_client */;
1497
1498--
1499-- Table structure for table `UTILITY_DIRECT`
1500--
1501
1502DROP TABLE IF EXISTS `UTILITY_DIRECT`;
1503/*!40101 SET @saved_cs_client = @@character_set_client */;
1504/*!40101 SET character_set_client = utf8 */;
1505CREATE TABLE `UTILITY_DIRECT` (
1506 `UTD_ART_ID` int(11) NOT NULL,
1507 `UTD_TEXT` text,
1508 KEY `UTD_ART_ID` (`UTD_ART_ID`)
1509) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1510/*!40101 SET character_set_client = @saved_cs_client */;
1511/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1512
1513/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1514/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1515/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1516/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1517/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1518/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1519/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1520
1521-- Dump completed on 2016-08-23 13:17:30