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