· 7 years ago · Feb 07, 2019, 11:36 AM
1(c) autodatabases.com 2019
2/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3/*!40101 SET NAMES utf8 */;
4/*!50503 SET NAMES utf8mb4 */;
5/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
6/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
7
8CREATE TABLE IF NOT EXISTS `articles` (
9 `supplierId` smallint(4) unsigned NOT NULL,
10 `DataSupplierArticleNumber` varchar(32) NOT NULL,
11 `ArticleStateDisplayValue` varchar(128) NOT NULL,
12 `Description` varchar(128) NOT NULL,
13 `FlagAccessory` enum('True','False') NOT NULL,
14 `FlagMaterialCertification` enum('True','False') NOT NULL,
15 `FlagRemanufactured` enum('True','False') NOT NULL,
16 `FlagSelfServicePacking` enum('True','False') NOT NULL,
17 `FoundString` varchar(64) NOT NULL,
18 `HasAxle` enum('True','False') NOT NULL,
19 `HasCommercialVehicle` enum('True','False') NOT NULL,
20 `HasCVManuID` enum('True','False') NOT NULL,
21 `HasEngine` enum('True','False') NOT NULL,
22 `HasLinkitems` enum('True','False') NOT NULL,
23 `HasMotorbike` enum('True','False') NOT NULL,
24 `HasPassengerCar` enum('True','False') NOT NULL,
25 `IsValid` enum('True','False') NOT NULL,
26 `LotSize1` int(10) unsigned DEFAULT NULL,
27 `LotSize2` int(10) unsigned DEFAULT NULL,
28 `NormalizedDescription` varchar(128) NOT NULL,
29 `PackingUnit` int(10) unsigned DEFAULT NULL,
30 `QuantityPerPackingUnit` int(10) unsigned DEFAULT NULL,
31 PRIMARY KEY (`supplierId`,`DataSupplierArticleNumber`),
32 KEY `supplierId` (`supplierId`),
33 KEY `DataSupplierArticleNumber` (`DataSupplierArticleNumber`),
34 KEY `FoundString` (`FoundString`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
36
37CREATE TABLE IF NOT EXISTS `article_acc` (
38 `supplierId` smallint(4) unsigned NOT NULL,
39 `DataSupplierArticleNumber` varchar(32) NOT NULL,
40 `AccSupplierId` smallint(4) unsigned NOT NULL,
41 `AccDataSupplierArticleNumber` varchar(32) NOT NULL,
42 KEY `supplierId` (`supplierId`),
43 KEY `DataSupplierArticleNumber` (`DataSupplierArticleNumber`),
44 KEY `AccSupplierId` (`AccSupplierId`),
45 KEY `AccDataSupplierArticleNumber` (`AccDataSupplierArticleNumber`)
46) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
47
48CREATE TABLE IF NOT EXISTS `article_attributes` (
49 `supplierid` smallint(4) unsigned NOT NULL,
50 `datasupplierarticlenumber` varchar(32) NOT NULL,
51 `id` smallint(4) unsigned NOT NULL,
52 `description` varchar(128) DEFAULT NULL,
53 `displaytitle` varchar(128) NOT NULL,
54 `displayvalue` varchar(4000) NOT NULL,
55 KEY `article` (`supplierid`,`datasupplierarticlenumber`),
56 KEY `id` (`id`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
58
59CREATE TABLE IF NOT EXISTS `article_cross` (
60 `manufacturerId` int(10) unsigned NOT NULL,
61 `OENbr` varchar(64) NOT NULL,
62 `SupplierId` smallint(4) unsigned NOT NULL,
63 `PartsDataSupplierArticleNumber` varchar(32) NOT NULL,
64 UNIQUE KEY `unique` (`manufacturerId`,`OENbr`,`SupplierId`,`PartsDataSupplierArticleNumber`),
65 KEY `manufacturerId` (`manufacturerId`),
66 KEY `OENbr` (`OENbr`),
67 KEY `SupplierId` (`SupplierId`,`PartsDataSupplierArticleNumber`)
68) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
69
70CREATE TABLE IF NOT EXISTS `article_ean` (
71 `supplierid` smallint(4) unsigned NOT NULL,
72 `datasupplierarticlenumber` varchar(32) NOT NULL,
73 `ean` varchar(24) NOT NULL,
74 KEY `supplierid` (`supplierid`,`datasupplierarticlenumber`),
75 KEY `ean` (`ean`)
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
77
78CREATE TABLE IF NOT EXISTS `article_images` (
79 `supplierId` smallint(4) unsigned NOT NULL,
80 `DataSupplierArticleNumber` varchar(32) NOT NULL,
81 `AdditionalDescription` varchar(64) NOT NULL,
82 `Description` varchar(64) NOT NULL,
83 `DocumentName` varchar(256) NOT NULL,
84 `DocumentType` varchar(8) NOT NULL,
85 `NormedDescriptionID` smallint(4) unsigned NOT NULL,
86 `PictureName` varchar(64) NOT NULL,
87 `ShowImmediately` enum('True','False') NOT NULL,
88 KEY `supplierId` (`supplierId`,`DataSupplierArticleNumber`),
89 KEY `DocumentType` (`DocumentType`)
90) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
91
92CREATE TABLE IF NOT EXISTS `article_inf` (
93 `supplierId` smallint(4) unsigned NOT NULL,
94 `DataSupplierArticleNumber` varchar(32) NOT NULL,
95 `InformationText` text NOT NULL,
96 `InformationType` varchar(64) NOT NULL,
97 `InformationTypeKey` smallint(4) unsigned NOT NULL,
98 KEY `supplierId` (`supplierId`,`DataSupplierArticleNumber`)
99) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
100
101CREATE TABLE IF NOT EXISTS `article_li` (
102 `supplierId` smallint(4) unsigned NOT NULL,
103 `DataSupplierArticleNumber` varchar(32) NOT NULL,
104 `linkageTypeId` varchar(32) NOT NULL,
105 `linkageId` int(10) unsigned NOT NULL,
106 KEY `supplierId` (`supplierId`,`DataSupplierArticleNumber`),
107 KEY `linkageTypeId` (`linkageTypeId`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
109
110CREATE TABLE IF NOT EXISTS `article_links` (
111 `supplierid` smallint(4) unsigned NOT NULL,
112 `productid` smallint(4) unsigned NOT NULL,
113 `linkagetypeid` smallint(4) unsigned NOT NULL,
114 `linkageid` int(10) unsigned NOT NULL,
115 `datasupplierarticlenumber` varchar(32) NOT NULL,
116 PRIMARY KEY (`supplierid`,`productid`,`linkageid`,`linkagetypeid`,`datasupplierarticlenumber`),
117 KEY `productid` (`productid`),
118 KEY `linkagetypeid` (`linkagetypeid`),
119 KEY `linkageid` (`linkageid`),
120 KEY `supplierid` (`supplierid`),
121 KEY `datasupplierarticlenumber` (`datasupplierarticlenumber`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
123
124CREATE TABLE IF NOT EXISTS `article_link_attributes` (
125 `supplierid` smallint(4) unsigned NOT NULL,
126 `productid` smallint(4) unsigned NOT NULL,
127 `linkagetypeid` smallint(4) unsigned NOT NULL,
128 `linkageid` int(10) unsigned NOT NULL,
129 `datasupplierarticlenumber` varchar(32) NOT NULL,
130 `attributeid` int(10) unsigned DEFAULT NULL,
131 `displaytitle` varchar(128) DEFAULT NULL,
132 `displayvalue` varchar(256) DEFAULT NULL,
133 `description` varchar(256) DEFAULT NULL,
134 PRIMARY KEY (`supplierid`,`productid`,`linkagetypeid`,`linkageid`,`datasupplierarticlenumber`),
135 KEY `datasupplierarticlenumber` (`datasupplierarticlenumber`,`supplierid`),
136 KEY `linkagetypeid` (`linkagetypeid`,`linkageid`)
137) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
138
139CREATE TABLE IF NOT EXISTS `article_nn` (
140 `supplierid` smallint(4) unsigned NOT NULL,
141 `datasupplierarticlenumber` varchar(32) NOT NULL,
142 `newnbr` varchar(32) NOT NULL,
143 `newsupplierid` smallint(4) unsigned NOT NULL,
144 `newdatasupplierarticlenumber` varchar(32) NOT NULL,
145 KEY `supplierid` (`supplierid`,`datasupplierarticlenumber`)
146) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
147
148CREATE TABLE IF NOT EXISTS `article_numbers` (
149 `supplierid` smallint(4) unsigned NOT NULL,
150 `datasupplierarticlenumber` varchar(32) NOT NULL,
151 PRIMARY KEY (`supplierid`,`datasupplierarticlenumber`)
152) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
153
154CREATE TABLE IF NOT EXISTS `article_oe` (
155 `supplierid` smallint(4) unsigned NOT NULL,
156 `datasupplierarticlenumber` varchar(32) NOT NULL,
157 `IsAdditive` enum('True','False') NOT NULL,
158 `OENbr` varchar(64) NOT NULL,
159 `manufacturerId` int(10) unsigned NOT NULL,
160 KEY `supplierid` (`supplierid`,`datasupplierarticlenumber`),
161 KEY `OENbr` (`OENbr`),
162 KEY `manufacturerId` (`manufacturerId`)
163) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
164
165CREATE TABLE IF NOT EXISTS `article_parts` (
166 `supplierId` smallint(4) unsigned NOT NULL,
167 `DataSupplierArticleNumber` varchar(32) NOT NULL,
168 `Quantity` int(10) NOT NULL,
169 `PartsSupplierId` smallint(4) NOT NULL,
170 `PartsDataSupplierArticleNumber` varchar(32) NOT NULL,
171 KEY `supplierId` (`supplierId`,`DataSupplierArticleNumber`)
172) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
173
174CREATE TABLE IF NOT EXISTS `article_prd` (
175 `supplierid` smallint(4) unsigned NOT NULL,
176 `datasupplierarticlenumber` varchar(32) NOT NULL,
177 `productId` int(10) unsigned NOT NULL,
178 PRIMARY KEY (`supplierid`,`datasupplierarticlenumber`,`productId`),
179 KEY `supplierid` (`supplierid`,`datasupplierarticlenumber`)
180) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
181
182CREATE TABLE IF NOT EXISTS `article_rn` (
183 `supplierid` smallint(4) unsigned NOT NULL,
184 `datasupplierarticlenumber` varchar(32) NOT NULL,
185 `replacenbr` varchar(32) NOT NULL,
186 `replacedupplierid` smallint(4) unsigned NOT NULL,
187 `replacedatasupplierarticlenumber` varchar(32) NOT NULL,
188 KEY `supplierid` (`supplierid`,`datasupplierarticlenumber`)
189) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
190
191CREATE TABLE IF NOT EXISTS `article_un` (
192 `supplierid` smallint(4) unsigned NOT NULL,
193 `datasupplierarticlenumber` varchar(32) NOT NULL,
194 `utilityno` varchar(64) NOT NULL,
195 KEY `supplierid` (`supplierid`,`datasupplierarticlenumber`)
196) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
197
198CREATE TABLE IF NOT EXISTS `axles` (
199 `id` int(10) unsigned NOT NULL,
200 `canbedisplayed` enum('True','False') DEFAULT NULL,
201 `constructioninterval` varchar(24) DEFAULT NULL,
202 `description` varchar(64) DEFAULT NULL,
203 `fulldescription` varchar(128) DEFAULT NULL,
204 `haslink` enum('True','False') DEFAULT NULL,
205 `isaxle` enum('True','False') DEFAULT NULL,
206 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
207 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
208 `isengine` enum('True','False') DEFAULT NULL,
209 `ismotorbike` enum('True','False') DEFAULT NULL,
210 `ispassengercar` enum('True','False') DEFAULT NULL,
211 `istransporter` enum('True','False') DEFAULT NULL,
212 `modelid` int(10) unsigned DEFAULT NULL,
213 PRIMARY KEY (`id`),
214 KEY `id` (`canbedisplayed`,`isaxle`,`istransporter`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`),
215 KEY `modelid` (`modelid`)
216) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
217
218CREATE TABLE IF NOT EXISTS `axle_attributes` (
219 `axleid` int(10) unsigned NOT NULL,
220 `attributegroup` varchar(32) DEFAULT NULL,
221 `attributetype` varchar(32) DEFAULT NULL,
222 `displaytitle` varchar(32) DEFAULT NULL,
223 `displayvalue` varchar(128) DEFAULT NULL,
224 KEY `axleid` (`axleid`),
225 KEY `attributegroup` (`attributegroup`)
226) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
227
228CREATE TABLE IF NOT EXISTS `axle_pds` (
229 `axleid` int(10) unsigned NOT NULL,
230 `nodeid` int(10) unsigned NOT NULL,
231 `productid` int(10) unsigned NOT NULL,
232 `supplierid` smallint(4) unsigned NOT NULL,
233 PRIMARY KEY (`axleid`,`nodeid`,`productid`,`supplierid`),
234 KEY `axleid` (`axleid`),
235 KEY `supplierid` (`supplierid`)
236) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
237
238CREATE TABLE IF NOT EXISTS `axle_prd` (
239 `id` int(10) unsigned NOT NULL,
240 `assemblygroupdescription` varchar(128) NOT NULL,
241 `description` varchar(128) NOT NULL,
242 `normalizeddescription` varchar(128) NOT NULL,
243 `usagedescription` varchar(128) NOT NULL,
244 PRIMARY KEY (`id`)
245) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
246
247CREATE TABLE IF NOT EXISTS `axle_trees` (
248 `axleid` int(10) unsigned NOT NULL,
249 `searchtreeid` int(10) unsigned NOT NULL,
250 `id` int(10) unsigned NOT NULL,
251 `parentid` int(10) unsigned DEFAULT NULL,
252 `description` varchar(128) DEFAULT NULL,
253 KEY `id` (`id`),
254 KEY `axleid` (`axleid`),
255 KEY `parentid` (`parentid`)
256) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
257
258CREATE TABLE IF NOT EXISTS `commercial_driver_cabs` (
259 `id` int(10) unsigned NOT NULL,
260 `drivercabid` int(10) unsigned NOT NULL,
261 KEY `id` (`id`),
262 KEY `drivercabid` (`drivercabid`)
263) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
264
265CREATE TABLE IF NOT EXISTS `commercial_vehicles` (
266 `id` int(10) unsigned NOT NULL,
267 `canbedisplayed` enum('True','False') DEFAULT NULL,
268 `constructioninterval` varchar(24) DEFAULT NULL,
269 `description` varchar(64) DEFAULT NULL,
270 `fulldescription` varchar(128) DEFAULT NULL,
271 `haslink` enum('True','False') DEFAULT NULL,
272 `isaxle` enum('True','False') DEFAULT NULL,
273 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
274 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
275 `isengine` enum('True','False') DEFAULT NULL,
276 `ismotorbike` enum('True','False') DEFAULT NULL,
277 `ispassengercar` enum('True','False') DEFAULT NULL,
278 `istransporter` enum('True','False') DEFAULT NULL,
279 `modelid` int(10) unsigned DEFAULT NULL,
280 PRIMARY KEY (`id`),
281 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
282 KEY `modelid` (`modelid`)
283) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
284
285CREATE TABLE IF NOT EXISTS `commercial_vehicle_attributes` (
286 `commercialvehicleid` int(10) unsigned NOT NULL,
287 `attributegroup` varchar(32) DEFAULT NULL,
288 `attributetype` varchar(32) DEFAULT NULL,
289 `displaytitle` varchar(32) DEFAULT NULL,
290 `displayvalue` varchar(128) DEFAULT NULL,
291 KEY `commercialvehicleid` (`commercialvehicleid`),
292 KEY `attributegroup` (`attributegroup`)
293) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
294
295CREATE TABLE IF NOT EXISTS `commercial_vehicle_axles` (
296 `id` int(10) unsigned NOT NULL,
297 `axleid` int(10) unsigned NOT NULL,
298 KEY `id` (`id`),
299 KEY `axleid` (`axleid`)
300) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
301
302CREATE TABLE IF NOT EXISTS `commercial_vehicle_engines` (
303 `id` int(10) unsigned NOT NULL,
304 `engineid` int(10) unsigned NOT NULL,
305 KEY `id` (`id`),
306 KEY `engineid` (`engineid`)
307) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
308
309CREATE TABLE IF NOT EXISTS `commercial_vehicle_pds` (
310 `commertialvehicleid` int(10) unsigned NOT NULL,
311 `nodeid` int(10) unsigned NOT NULL,
312 `productid` int(10) unsigned NOT NULL,
313 `supplierid` smallint(4) unsigned NOT NULL,
314 PRIMARY KEY (`commertialvehicleid`,`nodeid`,`productid`,`supplierid`),
315 KEY `commertialvehicleid` (`commertialvehicleid`),
316 KEY `supplierid` (`supplierid`,`productid`)
317) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
318
319CREATE TABLE IF NOT EXISTS `commercial_vehicle_prd` (
320 `id` int(10) unsigned NOT NULL,
321 `assemblygroupdescription` varchar(128) NOT NULL,
322 `description` varchar(128) NOT NULL,
323 `normalizeddescription` varchar(128) NOT NULL,
324 `usagedescription` varchar(128) NOT NULL,
325 PRIMARY KEY (`id`)
326) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
327
328CREATE TABLE IF NOT EXISTS `commercial_vehicle_qsi` (
329 `commercialvehicleid` int(10) unsigned NOT NULL,
330 `description` varchar(128) DEFAULT NULL,
331 `quickstarttype` smallint(4) unsigned DEFAULT NULL,
332 KEY `commercialvehicleid` (`commercialvehicleid`)
333) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
334
335CREATE TABLE IF NOT EXISTS `commercial_vehicle_sub_types` (
336 `id` int(10) NOT NULL,
337 `subtypeid` int(10) NOT NULL,
338 PRIMARY KEY (`id`,`subtypeid`),
339 KEY `id` (`id`)
340) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
341
342CREATE TABLE IF NOT EXISTS `commercial_vehicle_trees` (
343 `commercialvehicleid` int(11) NOT NULL,
344 `searchtreeid` int(11) NOT NULL,
345 `id` int(11) NOT NULL,
346 `parentid` int(11) DEFAULT NULL,
347 `description` varchar(128) DEFAULT NULL,
348 KEY `commercialvehicleid` (`commercialvehicleid`),
349 KEY `id` (`id`),
350 KEY `parentid` (`parentid`)
351) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
352
353CREATE TABLE IF NOT EXISTS `countries` (
354 `countrycode` varchar(4) NOT NULL,
355 `currencycode` varchar(4) DEFAULT NULL,
356 `description` varchar(128) DEFAULT NULL,
357 `isgroup` enum('True','False') DEFAULT NULL,
358 `isocode2` varchar(4) DEFAULT NULL,
359 `isocode3` varchar(4) DEFAULT NULL,
360 `isocodeno` varchar(4) DEFAULT NULL,
361 PRIMARY KEY (`countrycode`)
362) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
363
364CREATE TABLE IF NOT EXISTS `engines` (
365 `id` int(10) unsigned NOT NULL,
366 `canbedisplayed` enum('True','False') DEFAULT NULL,
367 `constructioninterval` varchar(24) DEFAULT NULL,
368 `description` varchar(64) DEFAULT NULL,
369 `fulldescription` varchar(128) DEFAULT NULL,
370 `haslink` enum('True','False') DEFAULT NULL,
371 `haslinkitem` enum('True','False') DEFAULT NULL,
372 `isaxle` enum('True','False') DEFAULT NULL,
373 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
374 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
375 `isengine` enum('True','False') DEFAULT NULL,
376 `ismotorbike` enum('True','False') DEFAULT NULL,
377 `ispassengercar` enum('True','False') DEFAULT NULL,
378 `istransporter` enum('True','False') DEFAULT NULL,
379 `manufacturerid` int(10) unsigned DEFAULT NULL,
380 `salesdescription` varchar(64) DEFAULT NULL,
381 PRIMARY KEY (`id`),
382 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
383 KEY `manufacturerid` (`manufacturerid`)
384) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
385
386CREATE TABLE IF NOT EXISTS `engine_attributes` (
387 `engineid` int(11) NOT NULL,
388 `attributegroup` varchar(32) DEFAULT NULL,
389 `attributetype` varchar(32) DEFAULT NULL,
390 `displaytitle` varchar(32) DEFAULT NULL,
391 `displayvalue` varchar(128) DEFAULT NULL,
392 KEY `engineid` (`engineid`),
393 KEY `attributegroup` (`attributegroup`)
394) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
395
396CREATE TABLE IF NOT EXISTS `engine_pds` (
397 `engineid` int(10) unsigned NOT NULL,
398 `nodeid` int(10) unsigned NOT NULL,
399 `productid` int(10) unsigned NOT NULL,
400 `supplierid` smallint(4) unsigned NOT NULL,
401 PRIMARY KEY (`engineid`,`nodeid`,`productid`,`supplierid`),
402 KEY `engineid` (`engineid`),
403 KEY `supplierid` (`supplierid`)
404) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
405
406CREATE TABLE IF NOT EXISTS `engine_prd` (
407 `id` int(10) unsigned NOT NULL,
408 `assemblygroupdescription` varchar(128) NOT NULL,
409 `description` varchar(128) NOT NULL,
410 `normalizeddescription` varchar(128) NOT NULL,
411 `usagedescription` varchar(128) NOT NULL,
412 PRIMARY KEY (`id`)
413) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
414
415CREATE TABLE IF NOT EXISTS `engine_qsi` (
416 `engineid` bigint(20) NOT NULL,
417 `description` varchar(128) DEFAULT NULL,
418 `quickstarttype` varchar(32) DEFAULT NULL,
419 `validstate` varchar(32) DEFAULT NULL
420) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
421
422CREATE TABLE IF NOT EXISTS `engine_trees` (
423 `engineid` int(10) unsigned NOT NULL,
424 `searchtreeid` int(10) unsigned NOT NULL,
425 `id` int(10) unsigned NOT NULL,
426 `parentid` int(10) unsigned DEFAULT NULL,
427 `description` varchar(128) DEFAULT NULL,
428 KEY `engineid` (`engineid`),
429 KEY `id` (`id`),
430 KEY `parentid` (`parentid`)
431) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
432
433CREATE TABLE IF NOT EXISTS `languages` (
434 `id` smallint(4) unsigned NOT NULL,
435 `codepage` smallint(4) unsigned DEFAULT NULL,
436 `description` varchar(16) DEFAULT NULL,
437 `isocode2` char(2) DEFAULT NULL,
438 PRIMARY KEY (`id`),
439 KEY `isocode2` (`isocode2`)
440) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
441
442CREATE TABLE IF NOT EXISTS `manufacturers` (
443 `id` int(10) unsigned NOT NULL,
444 `canbedisplayed` enum('True','False') DEFAULT NULL,
445 `description` varchar(64) DEFAULT NULL,
446 `fulldescription` varchar(64) DEFAULT NULL,
447 `haslink` enum('True','False') DEFAULT NULL,
448 `isaxle` enum('True','False') NOT NULL,
449 `iscommercialvehicle` enum('True','False') NOT NULL,
450 `isengine` enum('True','False') NOT NULL,
451 `ismotorbike` enum('True','False') NOT NULL,
452 `ispassengercar` enum('True','False') NOT NULL,
453 `istransporter` enum('True','False') NOT NULL,
454 `isvgl` enum('True','False') DEFAULT NULL,
455 `matchcode` varchar(64) DEFAULT NULL,
456 PRIMARY KEY (`id`,`isaxle`,`iscommercialvehicle`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
457 KEY `canbedisplayed` (`canbedisplayed`)
458) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
459
460CREATE TABLE IF NOT EXISTS `manufacturers_of_new_linkages` (
461 `id` int(10) unsigned NOT NULL,
462 `canbedisplayed` enum('True','False') DEFAULT NULL,
463 `description` varchar(64) DEFAULT NULL,
464 `fulldescription` varchar(64) DEFAULT NULL,
465 `haslink` enum('True','False') DEFAULT NULL,
466 `isaxle` enum('True','False') DEFAULT NULL,
467 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
468 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
469 `isengine` enum('True','False') DEFAULT NULL,
470 `ismotorbike` enum('True','False') DEFAULT NULL,
471 `ispassengercar` enum('True','False') DEFAULT NULL,
472 `istransporter` enum('True','False') DEFAULT NULL,
473 `isvgl` enum('True','False') DEFAULT NULL,
474 `matchcode` varchar(64) DEFAULT NULL,
475 `linkitemtype` varchar(32) DEFAULT NULL,
476 `supplier_id` smallint(4) unsigned NOT NULL,
477 KEY `id` (`id`),
478 KEY `canbedisplayed` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
479 KEY `supplier_id` (`supplier_id`)
480) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
481
482CREATE TABLE IF NOT EXISTS `models` (
483 `id` int(10) unsigned NOT NULL,
484 `canbedisplayed` enum('True','False') DEFAULT NULL,
485 `constructioninterval` varchar(24) DEFAULT NULL,
486 `description` varchar(128) DEFAULT NULL,
487 `fulldescription` varchar(128) DEFAULT NULL,
488 `haslink` enum('True','False') DEFAULT NULL,
489 `isaxle` enum('True','False') NOT NULL,
490 `iscommercialvehicle` enum('True','False') NOT NULL,
491 `isengine` enum('True','False') NOT NULL,
492 `ismotorbike` enum('True','False') NOT NULL,
493 `ispassengercar` enum('True','False') NOT NULL,
494 `istransporter` enum('True','False') NOT NULL,
495 `manufacturerid` int(10) unsigned DEFAULT NULL,
496 PRIMARY KEY (`id`,`isaxle`,`istransporter`,`ispassengercar`,`ismotorbike`,`isengine`,`iscommercialvehicle`),
497 KEY `manufacturerid` (`manufacturerid`),
498 KEY `canbedisplayed` (`canbedisplayed`)
499) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
500
501CREATE TABLE IF NOT EXISTS `motorbikes` (
502 `id` int(10) unsigned NOT NULL,
503 `canbedisplayed` enum('True','False') DEFAULT NULL,
504 `constructioninterval` varchar(24) DEFAULT NULL,
505 `description` varchar(64) DEFAULT NULL,
506 `fulldescription` varchar(128) DEFAULT NULL,
507 `haslink` enum('True','False') DEFAULT NULL,
508 `isaxle` enum('True','False') DEFAULT NULL,
509 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
510 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
511 `isengine` enum('True','False') DEFAULT NULL,
512 `ismotorbike` enum('True','False') DEFAULT NULL,
513 `ispassengercar` enum('True','False') DEFAULT NULL,
514 `istransporter` enum('True','False') DEFAULT NULL,
515 `modelid` int(10) unsigned DEFAULT NULL,
516 PRIMARY KEY (`id`),
517 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
518 KEY `modelid` (`modelid`)
519) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
520
521CREATE TABLE IF NOT EXISTS `motorbike_attributes` (
522 `motorbikeid` int(10) unsigned NOT NULL,
523 `attributegroup` varchar(32) DEFAULT NULL,
524 `attributetype` varchar(32) DEFAULT NULL,
525 `displaytitle` varchar(32) DEFAULT NULL,
526 `displayvalue` varchar(128) DEFAULT NULL,
527 KEY `motorbikeid` (`motorbikeid`),
528 KEY `attributegroup` (`attributegroup`)
529) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
530
531CREATE TABLE IF NOT EXISTS `motorbike_pds` (
532 `motorbikeid` int(10) unsigned NOT NULL,
533 `nodeid` int(10) unsigned NOT NULL,
534 `productid` int(10) unsigned NOT NULL,
535 `supplierid` smallint(4) unsigned NOT NULL,
536 PRIMARY KEY (`motorbikeid`,`nodeid`,`productid`,`supplierid`),
537 KEY `motorbikeid` (`motorbikeid`),
538 KEY `productid` (`productid`,`supplierid`)
539) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
540
541CREATE TABLE IF NOT EXISTS `motorbike_prd` (
542 `id` int(10) NOT NULL,
543 `assemblygroupdescription` varchar(128) NOT NULL,
544 `description` varchar(128) NOT NULL,
545 `normalizeddescription` varchar(128) NOT NULL,
546 `usagedescription` varchar(128) NOT NULL,
547 PRIMARY KEY (`id`)
548) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
549
550CREATE TABLE IF NOT EXISTS `motorbike_qsi` (
551 `motorbikeid` int(10) unsigned NOT NULL,
552 `description` varchar(128) DEFAULT NULL,
553 `quickstarttype` smallint(4) unsigned DEFAULT NULL,
554 KEY `motorbikeid` (`motorbikeid`)
555) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
556
557CREATE TABLE IF NOT EXISTS `motorbike_trees` (
558 `motorbikeid` int(10) unsigned NOT NULL,
559 `searchtreeid` int(10) unsigned NOT NULL,
560 `id` int(10) unsigned NOT NULL,
561 `parentid` int(10) unsigned DEFAULT NULL,
562 `description` varchar(128) DEFAULT NULL,
563 KEY `motorbikeid` (`motorbikeid`),
564 KEY `id` (`id`),
565 KEY `parentid` (`parentid`)
566) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
567
568CREATE TABLE IF NOT EXISTS `passanger_cars` (
569 `id` int(10) unsigned NOT NULL,
570 `canbedisplayed` enum('True','False') DEFAULT NULL,
571 `constructioninterval` varchar(24) DEFAULT NULL,
572 `description` varchar(128) DEFAULT NULL,
573 `fulldescription` varchar(255) DEFAULT NULL,
574 `haslink` enum('True','False') DEFAULT NULL,
575 `isaxle` enum('True','False') DEFAULT NULL,
576 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
577 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
578 `isengine` enum('True','False') DEFAULT NULL,
579 `ismotorbike` enum('True','False') DEFAULT NULL,
580 `ispassengercar` enum('True','False') DEFAULT NULL,
581 `istransporter` enum('True','False') DEFAULT NULL,
582 `modelid` int(10) unsigned DEFAULT NULL,
583 PRIMARY KEY (`id`),
584 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
585 KEY `modelid` (`modelid`)
586) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
587
588CREATE TABLE IF NOT EXISTS `passanger_car_attributes` (
589 `passangercarid` int(10) unsigned NOT NULL,
590 `attributegroup` varchar(32) DEFAULT NULL,
591 `attributetype` varchar(32) DEFAULT NULL,
592 `displaytitle` varchar(32) DEFAULT NULL,
593 `displayvalue` varchar(128) DEFAULT NULL,
594 KEY `passangercarid` (`passangercarid`),
595 KEY `attributegroup` (`attributegroup`)
596) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
597
598CREATE TABLE IF NOT EXISTS `passanger_car_engines` (
599 `id` int(10) unsigned NOT NULL,
600 `engineid` int(10) unsigned NOT NULL,
601 KEY `id` (`id`),
602 KEY `engineid` (`engineid`)
603) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
604
605CREATE TABLE IF NOT EXISTS `passanger_car_pds` (
606 `passangercarid` int(10) unsigned NOT NULL,
607 `nodeid` int(10) unsigned NOT NULL,
608 `productid` int(10) unsigned NOT NULL,
609 `supplierid` smallint(4) unsigned NOT NULL,
610 PRIMARY KEY (`passangercarid`,`nodeid`,`productid`,`supplierid`),
611 KEY `passangercarid` (`passangercarid`),
612 KEY `supplierid` (`supplierid`),
613 KEY `nodeid` (`nodeid`),
614 KEY `productid` (`productid`)
615) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
616
617CREATE TABLE IF NOT EXISTS `passanger_car_prd` (
618 `id` int(10) unsigned NOT NULL,
619 `assemblygroupdescription` varchar(128) NOT NULL,
620 `description` varchar(128) NOT NULL,
621 `normalizeddescription` varchar(128) NOT NULL,
622 `usagedescription` varchar(128) NOT NULL,
623 PRIMARY KEY (`id`)
624) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
625
626CREATE TABLE IF NOT EXISTS `passanger_car_qsi` (
627 `passangercarid` int(10) unsigned NOT NULL,
628 `description` varchar(128) DEFAULT NULL,
629 `quickstarttype` smallint(4) unsigned DEFAULT NULL,
630 KEY `passangercarid` (`passangercarid`)
631) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
632
633CREATE TABLE IF NOT EXISTS `passanger_car_trees` (
634 `passangercarid` int(10) unsigned NOT NULL,
635 `searchtreeid` int(10) unsigned NOT NULL,
636 `id` int(10) unsigned NOT NULL,
637 `parentid` int(10) unsigned DEFAULT NULL,
638 `description` varchar(128) DEFAULT NULL,
639 KEY `id` (`id`),
640 KEY `parentid` (`parentid`),
641 KEY `passangercarid` (`passangercarid`)
642) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
643
644CREATE TABLE IF NOT EXISTS `prd` (
645 `id` int(10) unsigned NOT NULL,
646 `assemblygroupdescription` varchar(128) NOT NULL,
647 `description` varchar(128) NOT NULL,
648 `normalizeddescription` varchar(128) NOT NULL,
649 `usagedescription` varchar(128) NOT NULL,
650 PRIMARY KEY (`id`)
651) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
652
653CREATE TABLE IF NOT EXISTS `suppliers` (
654 `id` smallint(4) unsigned NOT NULL,
655 `dataversion` smallint(4) unsigned DEFAULT NULL,
656 `description` varchar(32) DEFAULT NULL,
657 `matchcode` varchar(32) DEFAULT NULL,
658 `nbrofarticles` int(10) unsigned DEFAULT NULL,
659 `hasnewversionarticles` enum('True','False') DEFAULT NULL,
660 PRIMARY KEY (`id`),
661 KEY `description` (`description`)
662) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
663
664CREATE TABLE IF NOT EXISTS `suppliers_with_nv_articles` (
665 `id` smallint(4) NOT NULL,
666 `dataversion` smallint(4) DEFAULT NULL,
667 `description` varchar(32) DEFAULT NULL,
668 `matchcode` varchar(32) DEFAULT NULL,
669 `nbrofarticles` int(10) unsigned DEFAULT NULL,
670 `hasnewversionarticles` enum('True','False') DEFAULT NULL,
671 PRIMARY KEY (`id`),
672 KEY `description` (`description`)
673) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
674
675CREATE TABLE IF NOT EXISTS `suppliers_with_nv_linkages` (
676 `id` smallint(4) unsigned NOT NULL,
677 `dataversion` smallint(4) unsigned DEFAULT NULL,
678 `description` varchar(32) DEFAULT NULL,
679 `matchcode` varchar(32) DEFAULT NULL,
680 `nbrofarticles` int(10) unsigned DEFAULT NULL,
681 `hasnewversionarticles` enum('True','False') DEFAULT NULL,
682 PRIMARY KEY (`id`),
683 KEY `description` (`description`)
684) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
685
686CREATE TABLE IF NOT EXISTS `supplier_details` (
687 `supplierid` smallint(4) unsigned NOT NULL,
688 `addresstype` varchar(32) DEFAULT NULL,
689 `addresstypeid` char(1) NOT NULL,
690 `city1` varchar(64) DEFAULT NULL,
691 `city2` varchar(64) DEFAULT NULL,
692 `countrycode` varchar(64) DEFAULT NULL,
693 `email` varchar(64) DEFAULT NULL,
694 `fax` varchar(64) DEFAULT NULL,
695 `homepage` varchar(64) DEFAULT NULL,
696 `name1` varchar(64) DEFAULT NULL,
697 `name2` varchar(64) DEFAULT NULL,
698 `postalcodecity` varchar(32) DEFAULT NULL,
699 `postalcodepob` varchar(32) DEFAULT NULL,
700 `postalcodewholesaler` varchar(32) DEFAULT NULL,
701 `postalcountrycode` varchar(32) DEFAULT NULL,
702 `postofficebox` varchar(32) DEFAULT NULL,
703 `street1` varchar(64) DEFAULT NULL,
704 `street2` varchar(64) DEFAULT NULL,
705 `telephone` varchar(32) DEFAULT NULL,
706 KEY `supplierid` (`supplierid`,`addresstypeid`)
707) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
708
709/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
710/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
711/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;