· 6 years ago · Mar 29, 2019, 05:12 PM
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 KEY `FoundString` (`FoundString`),
31 KEY `key_articles_suppliers` (`supplierId`),
32 KEY `DataSupplierArticleNumber` (`DataSupplierArticleNumber`),
33 CONSTRAINT `key_articles_suppliers` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
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 `DataSupplierArticleNumber` (`DataSupplierArticleNumber`),
42 KEY `AccDataSupplierArticleNumber` (`AccDataSupplierArticleNumber`),
43 KEY `key_article_acc_suppliers` (`supplierId`),
44 KEY `key_article_acc_suppliers_2` (`AccSupplierId`),
45 CONSTRAINT `key_article_acc_articles` FOREIGN KEY (`DataSupplierArticleNumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
46 CONSTRAINT `key_article_acc_suppliers` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
47 CONSTRAINT `key_article_acc_suppliers_2` FOREIGN KEY (`AccSupplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
48) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
49
50CREATE TABLE IF NOT EXISTS `article_attributes` (
51 `supplierid` smallint(4) unsigned NOT NULL,
52 `datasupplierarticlenumber` varchar(32) NOT NULL,
53 `id` smallint(4) unsigned NOT NULL,
54 `description` varchar(128) NOT NULL,
55 `displaytitle` varchar(128) NOT NULL,
56 `displayvalue` varchar(4000) NOT NULL,
57 KEY `key_article_attributes_suppliers` (`supplierid`),
58 KEY `key_article_attributes_articles` (`datasupplierarticlenumber`),
59 CONSTRAINT `key_article_attributes_articles` FOREIGN KEY (`datasupplierarticlenumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
60 CONSTRAINT `key_article_attributes_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
61) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
62
63CREATE TABLE IF NOT EXISTS `article_cross` (
64 `manufacturerId` int(10) unsigned NOT NULL,
65 `OENbr` varchar(64) NOT NULL,
66 `SupplierId` smallint(4) unsigned NOT NULL,
67 `PartsDataSupplierArticleNumber` varchar(32) NOT NULL,
68 KEY `OENbr` (`OENbr`),
69 KEY `PartsDataSupplierArticleNumber` (`PartsDataSupplierArticleNumber`),
70 KEY `key_article_cross_manufacturers` (`manufacturerId`),
71 KEY `key_article_cross_suppliers` (`SupplierId`),
72 CONSTRAINT `key_article_cross_manufacturers` FOREIGN KEY (`manufacturerId`) REFERENCES `manufacturers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
73 CONSTRAINT `key_article_cross_suppliers` FOREIGN KEY (`SupplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
74) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
75
76CREATE TABLE IF NOT EXISTS `article_ean` (
77 `supplierid` smallint(4) unsigned NOT NULL,
78 `datasupplierarticlenumber` varchar(32) NOT NULL,
79 `ean` varchar(24) NOT NULL,
80 KEY `ean` (`ean`),
81 KEY `key_article_ean_suppliers` (`supplierid`),
82 KEY `key_article_ean_articles` (`datasupplierarticlenumber`),
83 CONSTRAINT `key_article_ean_articles` FOREIGN KEY (`datasupplierarticlenumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
84 CONSTRAINT `key_article_ean_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
85) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
86
87CREATE TABLE IF NOT EXISTS `article_images` (
88 `supplierId` smallint(4) unsigned NOT NULL,
89 `DataSupplierArticleNumber` varchar(32) NOT NULL,
90 `AdditionalDescription` varchar(64) NOT NULL,
91 `Description` varchar(64) NOT NULL,
92 `DocumentName` varchar(128) NOT NULL,
93 `DocumentType` varchar(8) NOT NULL,
94 `NormedDescriptionID` smallint(4) unsigned NOT NULL,
95 `PictureName` varchar(64) NOT NULL,
96 `ShowImmediately` enum('True','False') NOT NULL,
97 KEY `key_article_images_suppliers` (`supplierId`),
98 KEY `key_article_images_articles` (`DataSupplierArticleNumber`),
99 CONSTRAINT `key_article_images_articles` FOREIGN KEY (`DataSupplierArticleNumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
100 CONSTRAINT `key_article_images_suppliers` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
101) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
102
103CREATE TABLE IF NOT EXISTS `article_inf` (
104 `supplierId` smallint(4) unsigned NOT NULL,
105 `DataSupplierArticleNumber` varchar(32) NOT NULL,
106 `InformationText` text NOT NULL,
107 `InformationType` varchar(64) NOT NULL,
108 `InformationTypeKey` smallint(4) unsigned NOT NULL,
109 KEY `key_article_inf_suppliers` (`supplierId`),
110 KEY `key_article_inf_articles` (`DataSupplierArticleNumber`),
111 CONSTRAINT `key_article_inf_articles` FOREIGN KEY (`DataSupplierArticleNumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
112 CONSTRAINT `key_article_inf_suppliers` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
113) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
114
115CREATE TABLE IF NOT EXISTS `article_li` (
116 `supplierId` smallint(4) unsigned NOT NULL,
117 `DataSupplierArticleNumber` varchar(32) NOT NULL,
118 `linkageTypeId` varchar(32) NOT NULL,
119 `linkageId` int(10) unsigned NOT NULL,
120 KEY `key_article_li_suppliers` (`supplierId`),
121 KEY `key_article_li_articles` (`DataSupplierArticleNumber`),
122 CONSTRAINT `key_article_li_articles` FOREIGN KEY (`DataSupplierArticleNumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
123 CONSTRAINT `key_article_li_suppliers` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
124) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
125
126CREATE TABLE IF NOT EXISTS `article_links` (
127 `supplierid` smallint(4) unsigned NOT NULL,
128 `productid` smallint(4) unsigned NOT NULL,
129 `linkagetypeid` smallint(4) unsigned NOT NULL,
130 `linkageid` int(10) unsigned NOT NULL,
131 `datasupplierarticlenumber` varchar(32) DEFAULT NULL,
132 KEY `productid` (`productid`),
133 KEY `linkagetypeid` (`linkagetypeid`),
134 KEY `linkageid` (`linkageid`),
135 KEY `datasupplierarticlenumber` (`datasupplierarticlenumber`),
136 KEY `key_article_links_suppliers` (`supplierid`),
137 CONSTRAINT `key_article_links_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
138) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
139
140CREATE TABLE IF NOT EXISTS `article_nn` (
141 `supplierid` smallint(4) unsigned NOT NULL,
142 `datasupplierarticlenumber` varchar(32) NOT NULL,
143 `newnbr` varchar(32) NOT NULL,
144 `newsupplierid` smallint(4) unsigned NOT NULL,
145 `newdatasupplierarticlenumber` varchar(32) NOT NULL,
146 KEY `key_article_nn_suppliers` (`supplierid`),
147 KEY `key_article_nn_articles` (`datasupplierarticlenumber`),
148 CONSTRAINT `key_article_nn_articles` FOREIGN KEY (`datasupplierarticlenumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
149 CONSTRAINT `key_article_nn_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
150) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
151
152CREATE TABLE IF NOT EXISTS `article_numbers` (
153 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
154 `supplierid` smallint(5) unsigned NOT NULL,
155 `datasupplierarticlenumber` varchar(32) DEFAULT NULL,
156 PRIMARY KEY (`id`),
157 KEY `datasupplierarticlenumber` (`datasupplierarticlenumber`),
158 KEY `key_article_numbers_suppliers` (`supplierid`),
159 CONSTRAINT `key_article_numbers_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
160) ENGINE=InnoDB AUTO_INCREMENT=4521916 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
161
162CREATE TABLE IF NOT EXISTS `article_oe` (
163 `supplierid` smallint(4) unsigned NOT NULL,
164 `datasupplierarticlenumber` varchar(32) NOT NULL,
165 `IsAdditive` enum('True','False') NOT NULL,
166 `OENbr` varchar(64) NOT NULL,
167 `manufacturerId` int(10) unsigned NOT NULL,
168 KEY `OENbr` (`OENbr`),
169 KEY `key_article_oe_suppliers` (`supplierid`),
170 KEY `key_article_oe_articles` (`datasupplierarticlenumber`),
171 KEY `key_article_oe_manufacturers` (`manufacturerId`),
172 CONSTRAINT `key_article_oe_articles` FOREIGN KEY (`datasupplierarticlenumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
173 CONSTRAINT `key_article_oe_manufacturers` FOREIGN KEY (`manufacturerId`) REFERENCES `manufacturers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
174 CONSTRAINT `key_article_oe_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
175) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
176
177CREATE TABLE IF NOT EXISTS `article_parts` (
178 `supplierId` smallint(4) unsigned NOT NULL,
179 `DataSupplierArticleNumber` varchar(32) NOT NULL,
180 `Quantity` int(10) unsigned NOT NULL,
181 `PartsSupplierId` smallint(4) unsigned NOT NULL,
182 `PartsDataSupplierArticleNumber` varchar(32) NOT NULL,
183 KEY `key_article_parts_suppliers` (`supplierId`),
184 KEY `key_article_parts_articles_2` (`DataSupplierArticleNumber`),
185 CONSTRAINT `key_article_parts_articles` FOREIGN KEY (`DataSupplierArticleNumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
186 CONSTRAINT `key_article_parts_suppliers` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
187) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
188
189CREATE TABLE IF NOT EXISTS `article_prd` (
190 `supplierid` smallint(4) unsigned NOT NULL,
191 `datasupplierarticlenumber` varchar(32) NOT NULL,
192 `productId` int(10) unsigned NOT NULL,
193 PRIMARY KEY (`supplierid`,`datasupplierarticlenumber`,`productId`),
194 KEY `key_article_prd_articles` (`datasupplierarticlenumber`),
195 CONSTRAINT `key_article_prd_articles` FOREIGN KEY (`datasupplierarticlenumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
196 CONSTRAINT `key_article_prd_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
197) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
198
199CREATE TABLE IF NOT EXISTS `article_rn` (
200 `supplierid` smallint(4) unsigned NOT NULL,
201 `datasupplierarticlenumber` varchar(32) NOT NULL,
202 `replacenbr` varchar(32) NOT NULL,
203 `replacedupplierid` smallint(4) unsigned NOT NULL,
204 `replacedatasupplierarticlenumber` varchar(32) NOT NULL,
205 KEY `key_article_rn_suppliers` (`supplierid`),
206 KEY `key_article_rn_articles` (`datasupplierarticlenumber`),
207 CONSTRAINT `key_article_rn_articles` FOREIGN KEY (`datasupplierarticlenumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
208 CONSTRAINT `key_article_rn_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
209) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
210
211CREATE TABLE IF NOT EXISTS `article_un` (
212 `supplierid` smallint(4) unsigned NOT NULL,
213 `datasupplierarticlenumber` varchar(32) NOT NULL,
214 `utilityno` varchar(64) NOT NULL,
215 KEY `key_article_un_suppliers` (`supplierid`),
216 KEY `key_article_un_articles` (`datasupplierarticlenumber`),
217 CONSTRAINT `key_article_un_articles` FOREIGN KEY (`datasupplierarticlenumber`) REFERENCES `articles` (`DataSupplierArticleNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
218 CONSTRAINT `key_article_un_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
219) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
220
221CREATE TABLE IF NOT EXISTS `axles` (
222 `id` int(10) unsigned NOT NULL,
223 `canbedisplayed` enum('True','False') DEFAULT NULL,
224 `constructioninterval` varchar(24) DEFAULT NULL,
225 `description` varchar(64) DEFAULT NULL,
226 `fulldescription` varchar(128) DEFAULT NULL,
227 `haslink` enum('True','False') DEFAULT NULL,
228 `isaxle` enum('True','False') DEFAULT NULL,
229 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
230 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
231 `isengine` enum('True','False') DEFAULT NULL,
232 `ismotorbike` enum('True','False') DEFAULT NULL,
233 `ispassengercar` enum('True','False') DEFAULT NULL,
234 `istransporter` enum('True','False') DEFAULT NULL,
235 `modelid` int(10) unsigned DEFAULT NULL,
236 PRIMARY KEY (`id`),
237 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
238 KEY `key_axles_models` (`modelid`),
239 CONSTRAINT `key_axles_models` FOREIGN KEY (`modelid`) REFERENCES `models` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
240) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
241
242CREATE TABLE IF NOT EXISTS `axle_attributes` (
243 `axleid` int(10) unsigned NOT NULL,
244 `attributegroup` varchar(32) DEFAULT NULL,
245 `attributetype` varchar(32) DEFAULT NULL,
246 `displaytitle` varchar(32) DEFAULT NULL,
247 `displayvalue` varchar(128) DEFAULT NULL,
248 KEY `attributegroup` (`attributegroup`),
249 KEY `axleid` (`axleid`)
250) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
251
252CREATE TABLE IF NOT EXISTS `axle_pds` (
253 `axleid` int(10) unsigned NOT NULL,
254 `nodeid` int(10) unsigned NOT NULL,
255 `productid` int(10) unsigned NOT NULL,
256 `supplierid` smallint(4) unsigned NOT NULL,
257 PRIMARY KEY (`axleid`,`nodeid`,`productid`,`supplierid`),
258 KEY `key_axle_pds_suppliers` (`supplierid`),
259 CONSTRAINT `key_axle_pds_axles` FOREIGN KEY (`axleid`) REFERENCES `axles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
260 CONSTRAINT `key_axle_pds_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
261) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
262
263CREATE TABLE IF NOT EXISTS `axle_prd` (
264 `id` int(10) unsigned NOT NULL,
265 `assemblygroupdescription` varchar(128) NOT NULL,
266 `description` varchar(128) NOT NULL,
267 `normalizeddescription` varchar(128) NOT NULL,
268 `usagedescription` varchar(128) NOT NULL,
269 PRIMARY KEY (`id`)
270) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
271
272CREATE TABLE IF NOT EXISTS `axle_trees` (
273 `axleid` int(10) unsigned NOT NULL,
274 `searchtreeid` int(10) unsigned NOT NULL,
275 `id` int(10) unsigned NOT NULL,
276 `parentid` int(10) unsigned DEFAULT NULL,
277 `description` varchar(128) DEFAULT NULL,
278 KEY `id` (`id`),
279 KEY `parentid` (`parentid`),
280 KEY `key_axle_trees_axles` (`axleid`),
281 CONSTRAINT `key_axle_trees_axles` FOREIGN KEY (`axleid`) REFERENCES `axles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
282) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
283
284CREATE TABLE IF NOT EXISTS `commercial_driver_cabs` (
285 `id` int(10) unsigned NOT NULL,
286 `drivercabid` int(10) unsigned NOT NULL,
287 PRIMARY KEY (`id`,`drivercabid`),
288 CONSTRAINT `key_commercial_driver_cabs_commercial_vehicles` FOREIGN KEY (`id`) REFERENCES `commercial_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
289) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
290
291CREATE TABLE IF NOT EXISTS `commercial_vehicles` (
292 `id` int(10) unsigned NOT NULL,
293 `canbedisplayed` enum('True','False') DEFAULT NULL,
294 `constructioninterval` varchar(24) DEFAULT NULL,
295 `description` varchar(64) DEFAULT NULL,
296 `fulldescription` varchar(128) DEFAULT NULL,
297 `haslink` enum('True','False') DEFAULT NULL,
298 `isaxle` enum('True','False') DEFAULT NULL,
299 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
300 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
301 `isengine` enum('True','False') DEFAULT NULL,
302 `ismotorbike` enum('True','False') DEFAULT NULL,
303 `ispassengercar` enum('True','False') DEFAULT NULL,
304 `istransporter` enum('True','False') DEFAULT NULL,
305 `modelid` int(10) unsigned DEFAULT NULL,
306 PRIMARY KEY (`id`),
307 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
308 KEY `key_commercial_vehicles_models` (`modelid`),
309 CONSTRAINT `key_commercial_vehicles_models` FOREIGN KEY (`modelid`) REFERENCES `models` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
310) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
311
312CREATE TABLE IF NOT EXISTS `commercial_vehicle_attributes` (
313 `commercialvehicleid` int(10) unsigned NOT NULL,
314 `attributegroup` varchar(32) DEFAULT NULL,
315 `attributetype` varchar(32) DEFAULT NULL,
316 `displaytitle` varchar(32) DEFAULT NULL,
317 `displayvalue` varchar(128) DEFAULT NULL,
318 KEY `attributegroup` (`attributegroup`),
319 KEY `key_commercial_vehicle_attributes_commercial_vehicles` (`commercialvehicleid`),
320 CONSTRAINT `key_commercial_vehicle_attributes_commercial_vehicles` FOREIGN KEY (`commercialvehicleid`) REFERENCES `commercial_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
321) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
322
323CREATE TABLE IF NOT EXISTS `commercial_vehicle_axles` (
324 `id` int(10) unsigned NOT NULL,
325 `axleid` int(10) unsigned NOT NULL,
326 KEY `key_commercial_vehicle_axles_commercial_vehicles` (`id`),
327 KEY `key_commercial_vehicle_axles_axles` (`axleid`),
328 CONSTRAINT `key_commercial_vehicle_axles_axles` FOREIGN KEY (`axleid`) REFERENCES `axles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
329 CONSTRAINT `key_commercial_vehicle_axles_commercial_vehicles` FOREIGN KEY (`id`) REFERENCES `commercial_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
330) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
331
332CREATE TABLE IF NOT EXISTS `commercial_vehicle_engines` (
333 `id` int(10) unsigned NOT NULL,
334 `engineid` int(10) unsigned NOT NULL,
335 PRIMARY KEY (`id`,`engineid`),
336 KEY `key_commercial_vehicle_engines_engines` (`engineid`),
337 CONSTRAINT `key_commercial_vehicle_engines_commercial_vehicles` FOREIGN KEY (`id`) REFERENCES `commercial_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
338 CONSTRAINT `key_commercial_vehicle_engines_engines` FOREIGN KEY (`engineid`) REFERENCES `engines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
339) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
340
341CREATE TABLE IF NOT EXISTS `commercial_vehicle_pds` (
342 `commertialvehicleid` int(10) unsigned NOT NULL,
343 `nodeid` int(10) unsigned NOT NULL,
344 `productid` int(10) unsigned NOT NULL,
345 `supplierid` smallint(4) unsigned NOT NULL,
346 PRIMARY KEY (`commertialvehicleid`,`nodeid`,`productid`,`supplierid`),
347 KEY `key_commercial_vehicle_pds_suppliers` (`supplierid`),
348 CONSTRAINT `key_commercial_vehicle_pds_commercial_vehicles` FOREIGN KEY (`commertialvehicleid`) REFERENCES `commercial_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
349 CONSTRAINT `key_commercial_vehicle_pds_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
350) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
351
352CREATE TABLE IF NOT EXISTS `commercial_vehicle_prd` (
353 `id` int(10) unsigned NOT NULL,
354 `assemblygroupdescription` varchar(128) NOT NULL,
355 `description` varchar(128) NOT NULL,
356 `normalizeddescription` varchar(128) NOT NULL,
357 `usagedescription` varchar(128) NOT NULL,
358 PRIMARY KEY (`id`)
359) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
360
361CREATE TABLE IF NOT EXISTS `commercial_vehicle_qsi` (
362 `commercialvehicleid` int(10) unsigned NOT NULL,
363 `description` varchar(128) DEFAULT NULL,
364 `quickstarttype` smallint(4) unsigned DEFAULT NULL,
365 KEY `key_commercial_vehicle_qsi_commercial_vehicles` (`commercialvehicleid`),
366 CONSTRAINT `key_commercial_vehicle_qsi_commercial_vehicles` FOREIGN KEY (`commercialvehicleid`) REFERENCES `commercial_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
367) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
368
369CREATE TABLE IF NOT EXISTS `commercial_vehicle_sub_types` (
370 `id` int(10) unsigned NOT NULL,
371 `subtypeid` int(10) unsigned NOT NULL,
372 PRIMARY KEY (`id`,`subtypeid`),
373 CONSTRAINT `key_commercial_vehicle_sub_types_commercial_vehicles` FOREIGN KEY (`id`) REFERENCES `commercial_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
374) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
375
376CREATE TABLE IF NOT EXISTS `commercial_vehicle_trees` (
377 `commercialvehicleid` int(10) unsigned NOT NULL,
378 `searchtreeid` int(10) unsigned NOT NULL,
379 `id` int(10) unsigned NOT NULL,
380 `parentid` int(10) unsigned DEFAULT NULL,
381 `description` varchar(128) DEFAULT NULL,
382 KEY `id` (`id`),
383 KEY `parentid` (`parentid`),
384 KEY `key_commercial_vehicle_trees_commercial_vehicles` (`commercialvehicleid`),
385 CONSTRAINT `key_commercial_vehicle_trees_commercial_vehicles` FOREIGN KEY (`commercialvehicleid`) REFERENCES `commercial_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
386) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
387
388CREATE TABLE IF NOT EXISTS `countries` (
389 `countrycode` varchar(4) NOT NULL,
390 `currencycode` varchar(4) DEFAULT NULL,
391 `description` varchar(128) DEFAULT NULL,
392 `isocode2` varchar(4) DEFAULT NULL,
393 `isocode3` varchar(4) DEFAULT NULL,
394 `isocodeno` varchar(4) DEFAULT NULL,
395 PRIMARY KEY (`countrycode`)
396) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
397
398CREATE TABLE IF NOT EXISTS `country_groups` (
399 `countrycode` varchar(4) NOT NULL,
400 `description` varchar(128) DEFAULT NULL,
401 PRIMARY KEY (`countrycode`)
402) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
403
404CREATE TABLE IF NOT EXISTS `engines` (
405 `id` int(10) unsigned NOT NULL,
406 `canbedisplayed` enum('True','False') DEFAULT NULL,
407 `constructioninterval` varchar(24) DEFAULT NULL,
408 `description` varchar(64) DEFAULT NULL,
409 `fulldescription` varchar(128) DEFAULT NULL,
410 `haslink` enum('True','False') DEFAULT NULL,
411 `haslinkitem` enum('True','False') DEFAULT NULL,
412 `isaxle` enum('True','False') DEFAULT NULL,
413 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
414 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
415 `isengine` enum('True','False') DEFAULT NULL,
416 `ismotorbike` enum('True','False') DEFAULT NULL,
417 `ispassengercar` enum('True','False') DEFAULT NULL,
418 `istransporter` enum('True','False') DEFAULT NULL,
419 `manufacturerid` int(10) unsigned DEFAULT NULL,
420 `salesdescription` varchar(64) DEFAULT NULL,
421 PRIMARY KEY (`id`),
422 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
423 KEY `key_engines_manufacturers` (`manufacturerid`),
424 CONSTRAINT `key_engines_manufacturers` FOREIGN KEY (`manufacturerid`) REFERENCES `manufacturers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
425) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
426
427CREATE TABLE IF NOT EXISTS `engine_attributes` (
428 `engineid` int(10) unsigned NOT NULL,
429 `attributegroup` varchar(32) DEFAULT NULL,
430 `attributetype` varchar(32) DEFAULT NULL,
431 `displaytitle` varchar(32) DEFAULT NULL,
432 `displayvalue` varchar(128) DEFAULT NULL,
433 KEY `attributegroup` (`attributegroup`),
434 KEY `key_engine_attributes_engines` (`engineid`),
435 CONSTRAINT `key_engine_attributes_engines` FOREIGN KEY (`engineid`) REFERENCES `engines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
436) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
437
438CREATE TABLE IF NOT EXISTS `engine_pds` (
439 `engineid` int(10) unsigned NOT NULL,
440 `nodeid` int(10) unsigned NOT NULL,
441 `productid` int(10) unsigned NOT NULL,
442 `supplierid` smallint(4) unsigned NOT NULL,
443 PRIMARY KEY (`engineid`,`nodeid`,`productid`,`supplierid`),
444 KEY `key_engine_pds_suppliers` (`supplierid`),
445 CONSTRAINT `key_engine_pds_engines` FOREIGN KEY (`engineid`) REFERENCES `engines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
446 CONSTRAINT `key_engine_pds_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
447) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
448
449CREATE TABLE IF NOT EXISTS `engine_prd` (
450 `id` int(10) unsigned NOT NULL,
451 `assemblygroupdescription` varchar(128) NOT NULL,
452 `description` varchar(128) NOT NULL,
453 `normalizeddescription` varchar(128) NOT NULL,
454 `usagedescription` varchar(128) NOT NULL,
455 PRIMARY KEY (`id`)
456) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
457
458CREATE TABLE IF NOT EXISTS `engine_trees` (
459 `engineid` int(10) unsigned NOT NULL,
460 `searchtreeid` int(10) unsigned NOT NULL,
461 `id` int(10) unsigned NOT NULL,
462 `parentid` int(10) unsigned DEFAULT NULL,
463 `description` varchar(128) DEFAULT NULL,
464 KEY `id` (`id`),
465 KEY `parentid` (`parentid`),
466 KEY `key_engine_trees_engines` (`engineid`),
467 CONSTRAINT `key_engine_trees_engines` FOREIGN KEY (`engineid`) REFERENCES `engines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
468) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
469
470CREATE TABLE IF NOT EXISTS `languages` (
471 `id` smallint(4) unsigned NOT NULL,
472 `codepage` smallint(4) DEFAULT NULL,
473 `description` varchar(16) DEFAULT NULL,
474 `isocode2` char(2) DEFAULT NULL,
475 PRIMARY KEY (`id`),
476 KEY `isocode2` (`isocode2`)
477) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
478
479CREATE TABLE IF NOT EXISTS `manufacturer` (
480 `id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
481 `name` varchar(64) NOT NULL,
482 `parent_id` smallint(4) unsigned DEFAULT NULL,
483 `is_genuine` tinyint(1) unsigned NOT NULL DEFAULT 0,
484 `is_slash_allowed` tinyint(1) unsigned NOT NULL DEFAULT 0,
485 `group_id` smallint(4) unsigned DEFAULT NULL,
486 `use_group_name` char(1) NOT NULL DEFAULT '1',
487 PRIMARY KEY (`id`),
488 UNIQUE KEY `manufacturer_uk01` (`name`),
489 KEY `manufacturer_fk01` (`parent_id`),
490 KEY `manufacturer_fk02` (`group_id`),
491 CONSTRAINT `manufacturer_fk01` FOREIGN KEY (`parent_id`) REFERENCES `manufacturer` (`id`) ON DELETE CASCADE,
492 CONSTRAINT `manufacturer_fk02` FOREIGN KEY (`group_id`) REFERENCES `manufacturer_group` (`id`)
493) ENGINE=InnoDB AUTO_INCREMENT=7057 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
494
495CREATE TABLE IF NOT EXISTS `manufacturers` (
496 `id` int(10) unsigned NOT NULL,
497 `canbedisplayed` enum('True','False') DEFAULT NULL,
498 `description` varchar(64) DEFAULT NULL,
499 `fulldescription` varchar(64) DEFAULT NULL,
500 `haslink` enum('True','False') DEFAULT NULL,
501 `isaxle` enum('True','False') NOT NULL,
502 `iscommercialvehicle` enum('True','False') NOT NULL,
503 `isengine` enum('True','False') NOT NULL,
504 `ismotorbike` enum('True','False') NOT NULL,
505 `ispassengercar` enum('True','False') NOT NULL,
506 `istransporter` enum('True','False') NOT NULL,
507 `isvgl` enum('True','False') DEFAULT NULL,
508 `matchcode` varchar(64) DEFAULT NULL,
509 PRIMARY KEY (`id`,`isaxle`,`iscommercialvehicle`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
510 KEY `canbedisplayed` (`canbedisplayed`)
511) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
512
513CREATE TABLE IF NOT EXISTS `manufacturers_of_new_linkages` (
514 `id` int(10) unsigned NOT NULL,
515 `canbedisplayed` enum('True','False') DEFAULT NULL,
516 `description` varchar(64) DEFAULT NULL,
517 `fulldescription` varchar(64) DEFAULT NULL,
518 `haslink` enum('True','False') DEFAULT NULL,
519 `isaxle` enum('True','False'),
520 `iscommercialvehicle` enum('True','False'),
521 `iscvmanufacturerid` enum('True','False'),
522 `isengine` enum('True','False'),
523 `ismotorbike` enum('True','False'),
524 `ispassengercar` enum('True','False'),
525 `istransporter` enum('True','False'),
526 `isvgl` enum('True','False'),
527 `matchcode` varchar(64) DEFAULT NULL,
528 `linkitemtype` varchar(32) DEFAULT NULL,
529 `supplier_id` smallint(4) unsigned NOT NULL,
530 KEY `canbedisplayed` (`canbedisplayed`),
531 KEY `key_manufacturers_of_new_linkages_suppliers` (`supplier_id`),
532 KEY `id` (`id`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
533 CONSTRAINT `key_manufacturers_of_new_linkages_suppliers` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
534) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
535
536CREATE TABLE IF NOT EXISTS `models` (
537 `id` int(10) unsigned NOT NULL,
538 `canbedisplayed` enum('True','False') DEFAULT NULL,
539 `constructioninterval` varchar(24) DEFAULT NULL,
540 `description` varchar(128) DEFAULT NULL,
541 `fulldescription` varchar(128) DEFAULT NULL,
542 `haslink` enum('True','False') DEFAULT NULL,
543 `isaxle` enum('True','False') NOT NULL,
544 `iscommercialvehicle` enum('True','False') NOT NULL,
545 `isengine` enum('True','False') NOT NULL,
546 `ismotorbike` enum('True','False') NOT NULL,
547 `ispassengercar` enum('True','False') NOT NULL,
548 `istransporter` enum('True','False') NOT NULL,
549 `manufacturerid` int(10) unsigned DEFAULT NULL,
550 PRIMARY KEY (`id`,`isaxle`,`iscommercialvehicle`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
551 KEY `key_models_manufacturers` (`manufacturerid`),
552 KEY `canbedisplayed` (`canbedisplayed`),
553 CONSTRAINT `key_models_manufacturers` FOREIGN KEY (`manufacturerid`) REFERENCES `manufacturers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
554) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
555
556CREATE TABLE IF NOT EXISTS `motorbikes` (
557 `id` int(10) unsigned NOT NULL,
558 `canbedisplayed` enum('True','False') DEFAULT NULL,
559 `constructioninterval` varchar(24) DEFAULT NULL,
560 `description` varchar(64) DEFAULT NULL,
561 `fulldescription` varchar(128) DEFAULT NULL,
562 `haslink` enum('True','False') DEFAULT NULL,
563 `isaxle` enum('True','False') DEFAULT NULL,
564 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
565 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
566 `isengine` enum('True','False') DEFAULT NULL,
567 `ismotorbike` enum('True','False') DEFAULT NULL,
568 `ispassengercar` enum('True','False') DEFAULT NULL,
569 `istransporter` enum('True','False') DEFAULT NULL,
570 `modelid` int(10) unsigned DEFAULT NULL,
571 PRIMARY KEY (`id`),
572 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
573 KEY `key_motorbikes_models` (`modelid`),
574 CONSTRAINT `key_motorbikes_models` FOREIGN KEY (`modelid`) REFERENCES `models` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
575) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
576
577CREATE TABLE IF NOT EXISTS `motorbike_attributes` (
578 `motorbikeid` int(10) unsigned NOT NULL,
579 `attributegroup` varchar(32) DEFAULT NULL,
580 `attributetype` varchar(32) DEFAULT NULL,
581 `displaytitle` varchar(32) DEFAULT NULL,
582 `displayvalue` varchar(128) DEFAULT NULL,
583 KEY `motorbike_attributes_idx01` (`motorbikeid`),
584 KEY `attributegroup` (`attributegroup`),
585 CONSTRAINT `key_motorbike_attributes_motorbikes` FOREIGN KEY (`motorbikeid`) REFERENCES `motorbikes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
586) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
587
588CREATE TABLE IF NOT EXISTS `motorbike_pds` (
589 `motorbikeid` int(10) unsigned NOT NULL,
590 `nodeid` int(10) unsigned NOT NULL,
591 `productid` int(10) unsigned NOT NULL,
592 `supplierid` smallint(4) unsigned NOT NULL,
593 PRIMARY KEY (`motorbikeid`,`nodeid`,`productid`,`supplierid`),
594 KEY `key_motorbike_pds_suppliers` (`supplierid`),
595 CONSTRAINT `key_motorbike_pds_motorbikes` FOREIGN KEY (`motorbikeid`) REFERENCES `motorbikes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
596 CONSTRAINT `key_motorbike_pds_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
597) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
598
599CREATE TABLE IF NOT EXISTS `motorbike_prd` (
600 `id` int(10) unsigned NOT NULL,
601 `assemblygroupdescription` varchar(128) NOT NULL,
602 `description` varchar(128) NOT NULL,
603 `normalizeddescription` varchar(128) NOT NULL,
604 `usagedescription` varchar(128) NOT NULL,
605 PRIMARY KEY (`id`)
606) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
607
608CREATE TABLE IF NOT EXISTS `motorbike_qsi` (
609 `motorbikeid` int(10) unsigned NOT NULL,
610 `description` varchar(128) DEFAULT NULL,
611 `quickstarttype` smallint(4) unsigned DEFAULT NULL,
612 KEY `key_motorbike_qsi_motorbikes` (`motorbikeid`),
613 CONSTRAINT `key_motorbike_qsi_motorbikes` FOREIGN KEY (`motorbikeid`) REFERENCES `motorbikes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
614) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
615
616CREATE TABLE IF NOT EXISTS `motorbike_trees` (
617 `motorbikeid` int(10) unsigned NOT NULL,
618 `searchtreeid` int(10) unsigned NOT NULL,
619 `id` int(10) unsigned NOT NULL,
620 `parentid` int(10) unsigned DEFAULT NULL,
621 `description` varchar(128) DEFAULT NULL,
622 KEY `key_motorbike_trees_motorbikes` (`motorbikeid`),
623 KEY `id` (`id`),
624 KEY `parentid` (`parentid`),
625 CONSTRAINT `key_motorbike_trees_motorbikes` FOREIGN KEY (`motorbikeid`) REFERENCES `motorbikes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
626) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
627
628CREATE TABLE IF NOT EXISTS `passanger_cars` (
629 `id` int(10) unsigned NOT NULL,
630 `canbedisplayed` enum('True','False') DEFAULT NULL,
631 `constructioninterval` varchar(24) DEFAULT NULL,
632 `description` varchar(128) DEFAULT NULL,
633 `fulldescription` varchar(255) DEFAULT NULL,
634 `haslink` enum('True','False') DEFAULT NULL,
635 `isaxle` enum('True','False') DEFAULT NULL,
636 `iscommercialvehicle` enum('True','False') DEFAULT NULL,
637 `iscvmanufacturerid` enum('True','False') DEFAULT NULL,
638 `isengine` enum('True','False') DEFAULT NULL,
639 `ismotorbike` enum('True','False') DEFAULT NULL,
640 `ispassengercar` enum('True','False') DEFAULT NULL,
641 `istransporter` enum('True','False') DEFAULT NULL,
642 `modelid` int(10) unsigned DEFAULT NULL,
643 PRIMARY KEY (`id`),
644 KEY `id` (`canbedisplayed`,`isaxle`,`iscommercialvehicle`,`iscvmanufacturerid`,`isengine`,`ismotorbike`,`ispassengercar`,`istransporter`),
645 KEY `key_passanger_cars_models` (`modelid`),
646 CONSTRAINT `key_passanger_cars_models` FOREIGN KEY (`modelid`) REFERENCES `models` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
647) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
648
649CREATE TABLE IF NOT EXISTS `passanger_car_attributes` (
650 `passangercarid` int(10) unsigned NOT NULL,
651 `attributegroup` varchar(32) DEFAULT NULL,
652 `attributetype` varchar(32) DEFAULT NULL,
653 `displaytitle` varchar(32) DEFAULT NULL,
654 `displayvalue` varchar(128) DEFAULT NULL,
655 KEY `attributegroup` (`attributegroup`),
656 KEY `key_passanger_car_attributes_passanger_cars` (`passangercarid`),
657 CONSTRAINT `key_passanger_car_attributes_passanger_cars` FOREIGN KEY (`passangercarid`) REFERENCES `passanger_cars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
658) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
659
660CREATE TABLE IF NOT EXISTS `passanger_car_engines` (
661 `id` int(10) unsigned NOT NULL,
662 `engineid` int(10) unsigned NOT NULL,
663 KEY `key_passanger_car_engines_passanger_cars` (`id`),
664 KEY `key_passanger_car_engines_engines` (`engineid`),
665 CONSTRAINT `key_passanger_car_engines_engines` FOREIGN KEY (`engineid`) REFERENCES `engines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
666 CONSTRAINT `key_passanger_car_engines_passanger_cars` FOREIGN KEY (`id`) REFERENCES `passanger_cars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
667) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
668
669CREATE TABLE IF NOT EXISTS `passanger_car_pds` (
670 `passangercarid` int(10) unsigned NOT NULL,
671 `nodeid` int(10) unsigned NOT NULL,
672 `productid` int(10) unsigned NOT NULL,
673 `supplierid` smallint(4) unsigned NOT NULL,
674 PRIMARY KEY (`passangercarid`,`nodeid`,`productid`,`supplierid`),
675 KEY `key_passanger_car_pds_suppliers` (`supplierid`),
676 CONSTRAINT `key_passanger_car_pds_passanger_cars` FOREIGN KEY (`passangercarid`) REFERENCES `passanger_cars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
677 CONSTRAINT `key_passanger_car_pds_suppliers` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
678) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
679
680CREATE TABLE IF NOT EXISTS `passanger_car_prd` (
681 `id` int(10) unsigned NOT NULL,
682 `assemblygroupdescription` varchar(128) NOT NULL,
683 `description` varchar(128) NOT NULL,
684 `normalizeddescription` varchar(128) NOT NULL,
685 `usagedescription` varchar(128) NOT NULL,
686 PRIMARY KEY (`id`)
687) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
688
689CREATE TABLE IF NOT EXISTS `passanger_car_qsi` (
690 `passangercarid` int(10) unsigned NOT NULL,
691 `description` varchar(128) DEFAULT NULL,
692 `quickstarttype` smallint(4) unsigned DEFAULT NULL,
693 KEY `key_passanger_car_qsi_passanger_cars` (`passangercarid`),
694 CONSTRAINT `key_passanger_car_qsi_passanger_cars` FOREIGN KEY (`passangercarid`) REFERENCES `passanger_cars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
695) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
696
697CREATE TABLE IF NOT EXISTS `passanger_car_trees` (
698 `passangercarid` int(10) unsigned NOT NULL,
699 `searchtreeid` int(10) unsigned NOT NULL,
700 `id` int(10) unsigned NOT NULL,
701 `parentid` int(10) unsigned DEFAULT NULL,
702 `description` varchar(128) DEFAULT NULL,
703 KEY `id` (`id`),
704 KEY `parentid` (`parentid`),
705 KEY `key_passanger_car_trees_passanger_cars` (`passangercarid`),
706 CONSTRAINT `key_passanger_car_trees_passanger_cars` FOREIGN KEY (`passangercarid`) REFERENCES `passanger_cars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
707) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
708
709CREATE TABLE IF NOT EXISTS `prd` (
710 `id` int(10) unsigned NOT NULL,
711 `assemblygroupdescription` varchar(128) NOT NULL,
712 `description` varchar(128) NOT NULL,
713 `normalizeddescription` varchar(128) NOT NULL,
714 `usagedescription` varchar(128) NOT NULL,
715 PRIMARY KEY (`id`)
716) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
717
718CREATE TABLE IF NOT EXISTS `suppliers` (
719 `id` smallint(4) unsigned NOT NULL,
720 `dataversion` smallint(4) unsigned DEFAULT NULL,
721 `description` varchar(32) DEFAULT NULL,
722 `matchcode` varchar(32) DEFAULT NULL,
723 `nbrofarticles` int(10) unsigned DEFAULT NULL,
724 `hasnewversionarticles` enum('True','False') DEFAULT NULL,
725 PRIMARY KEY (`id`),
726 KEY `description` (`description`)
727) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
728
729CREATE TABLE IF NOT EXISTS `suppliers_with_nv_articles` (
730 `id` smallint(4) unsigned NOT NULL,
731 `dataversion` smallint(4) unsigned DEFAULT NULL,
732 `description` varchar(32) DEFAULT NULL,
733 `matchcode` varchar(32) DEFAULT NULL,
734 `nbrofarticles` int(10) unsigned DEFAULT NULL,
735 `hasnewversionarticles` enum('True','False') DEFAULT NULL,
736 PRIMARY KEY (`id`),
737 KEY `description` (`description`)
738) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
739
740CREATE TABLE IF NOT EXISTS `suppliers_with_nv_linkages` (
741 `id` smallint(4) unsigned NOT NULL,
742 `dataversion` smallint(4) unsigned DEFAULT NULL,
743 `description` varchar(32) DEFAULT NULL,
744 `matchcode` varchar(32) DEFAULT NULL,
745 `nbrofarticles` int(10) unsigned DEFAULT NULL,
746 `hasnewversionarticles` enum('True','False') DEFAULT NULL,
747 PRIMARY KEY (`id`),
748 KEY `description` (`description`)
749) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
750
751CREATE TABLE IF NOT EXISTS `supplier_details` (
752 `supplierid` smallint(4) unsigned NOT NULL,
753 `addresstype` varchar(32) DEFAULT NULL,
754 `addresstypeid` char(1) NOT NULL,
755 `city1` varchar(64) DEFAULT NULL,
756 `city2` varchar(64) DEFAULT NULL,
757 `countrycode` varchar(64) DEFAULT NULL,
758 `email` varchar(64) DEFAULT NULL,
759 `fax` varchar(64) DEFAULT NULL,
760 `homepage` varchar(64) DEFAULT NULL,
761 `name1` varchar(64) DEFAULT NULL,
762 `name2` varchar(64) DEFAULT NULL,
763 `postalcodecity` varchar(32) DEFAULT NULL,
764 `postalcodepob` varchar(32) DEFAULT NULL,
765 `postalcodewholesaler` varchar(32) DEFAULT NULL,
766 `postalcountrycode` varchar(32) DEFAULT NULL,
767 `postofficebox` varchar(32) DEFAULT NULL,
768 `street1` varchar(64) DEFAULT NULL,
769 `street2` varchar(64) DEFAULT NULL,
770 `telephone` varchar(32) DEFAULT NULL,
771 PRIMARY KEY (`supplierid`,`addresstypeid`)
772) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
773
774/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
775/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
776/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;