· 8 years ago · Dec 05, 2017, 01:24 PM
1 -- --------------------------------------------------------
2 -- Host: 127.0.0.1
3 -- Server version: 10.1.19-MariaDB - mariadb.org binary distribution
4 -- OS on server: Win32
5 -- HeidiSQL version: 9.4.0.5125
6 -- --------------------------------------------------------
7
8 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9 /*!40101 SET NAMES utf8 */;
10 /*!50503 SET NAMES utf8mb4 */;
11 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15
16 DROP DATABASE IF EXISTS `cardb`;
17 CREATE DATABASE IF NOT EXISTS `cardb` /*!40100 DEFAULT CHARACTER SET utf8 */;
18 USE `cardb`;
19
20
21 DROP TABLE IF EXISTS `cars`;
22 CREATE TABLE IF NOT EXISTS `cars` (
23 `id` bigint(20) NOT NULL,
24 `make` varchar(255) NOT NULL,
25 `model` varchar(255) NOT NULL,
26 `travelledDistance` bigint(20) NOT NULL,
27 PRIMARY KEY (`id`)
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29
30
31 /*!40000 ALTER TABLE `cars` DISABLE KEYS */;
32 INSERT INTO `cars` (`id`, `make`, `model`, `travelledDistance`) VALUES
33 (1, 'Opel', 'Omega', 2147483647),
34 (2, 'Opel', 'Astra', 9223372036854775807),
35 (3, 'Opel', 'Astra', 922337203685807),
36 (4, 'Opel', 'Corsa', 214747),
37 (5, 'Opel', 'Kadet', 21474847),
38 (6, 'Opel', 'Vectra', 9223372854775807),
39 (7, 'Opel', 'Insignia', 2147483647),
40 (8, 'Opel', 'Astra', 922336854775807),
41 (9, 'Opel', 'Corsa', 21474847),
42 (10, 'Opel', 'Omega', 2147483647),
43 (11, 'Opel', 'Insignia', 9223372036854775807),
44 (12, 'Opel', 'Vectra', 2147483647),
45 (13, 'Opel', 'Astra', 2147483647),
46 (14, 'Opel', 'Omega', 2147483647),
47 (15, 'Opel', 'Corsa', 2147483647),
48 (16, 'Opel', 'Insignia', 9223372036854775807),
49 (17, 'Opel', 'Omega', 9223336854775807),
50 (18, 'Opel', 'Corsa', 2),
51 (19, 'Opel', 'Omega', 1),
52 (20, 'BMW', 'F20', 2147483647),
53 (21, 'BMW', 'F25', 9223372036854775807),
54 (22, 'BMW', 'M5 F10', 10),
55 (23, 'BMW', 'F04', 100000),
56 (24, 'BMW', 'E88', 200000),
57 (25, 'BMW', 'M Roadster E85', 92233720365807),
58 (26, 'BMW', '1M Coupe', 2147),
59 (27, 'BMW', 'X6 M', 922775807),
60 (28, 'BMW', 'E67', 21447),
61 (29, 'BMW', 'M6 E63', 92235807),
62 (30, 'BMW', 'M6 E63', 2147),
63 (31, 'BMW', 'F20', 21447),
64 (32, 'BMW', 'F04', 2143647),
65 (33, 'BMW', 'M5 F10', 27483647),
66 (34, 'BMW', 'X6 M', 2036854775807),
67 (35, 'BMW', 'F20', 83647),
68 (36, 'BMW', 'X6 M', 483647),
69 (37, 'BMW', 'F04', 483647),
70 (38, 'BMW', 'F20', 975807),
71 (39, 'BMW', 'M6 E63', 214747),
72 (40, 'Fiat', 'Panda', 92233854775807),
73 (41, 'Fiat', 'Panda 4x4 Antarctica', 214747),
74 (42, 'Fiat', '500 (2007) Abarth 695 Tributo Maserati', 214747),
75 (43, 'Fiat', 'Panda 4x4 Antarctica', 2183647),
76 (44, 'Fiat', 'Panda 4x4', 2147447),
77 (45, 'Fiat', 'Panda', 21447),
78 (46, 'Fiat', 'Freemont', 214647),
79 (47, 'Fiat', '500L', 21474847),
80 (48, 'Fiat', 'Panda', 21474837),
81 (49, 'Fiat', 'Freemont', 92233685477),
82 (50, 'Fiat', 'Panda 4x4', 92233736854775807),
83 (51, 'Fiat', 'Panda 4x4 Antarctica', 21483647),
84 (52, 'Fiat', '500L', 2147647),
85 (53, 'Fiat', '500L', 92233754775807),
86 (54, 'Fiat', '500 (2007) Abarth 695 Tributo Maserati', 922337205807),
87 (55, 'Fiat', 'Panda', 2147487),
88 (56, 'Fiat', '500L', 922337204775807),
89 (57, 'Fiat', 'Freemont', 21473647),
90 (58, 'Fiat', 'Panda 4x4', 922036854775807),
91 (59, 'Fiat', '500 (2007) Abarth 695 Tributo Maserati', 92236854775807),
92 (60, 'Fiat', 'Freemont', 2147647),
93 (61, 'Fiat', '500L', 922337203675807),
94 (62, 'Mercedes', 'A 140', 92233754775807),
95 (63, 'Mercedes', 'W212', 2147647),
96 (64, 'Mercedes', 'A 160', 9223372036),
97 (65, 'Mercedes', 'A 160 CDI', 4775807),
98 (66, 'Mercedes', 'W212', 54775807),
99 (67, 'Mercedes', 'W202', 92233754775807),
100 (68, 'Mercedes', 'W211', 47757),
101 (69, 'Mercedes', 'A 170 CDI', 9223775807),
102 (70, 'Mercedes', 'W212', 927254775807),
103 (71, 'Mercedes', 'W124', 922336854775807),
104 (72, 'Mercedes', 'W210', 9223372036854775807),
105 (73, 'Mercedes', 'W202', 2147647),
106 (74, 'Mercedes', 'W211', 922775807),
107 (75, 'Mercedes', 'W212', 2183647),
108 (76, 'Mercedes', 'W203', 5807),
109 (77, 'Mercedes', 'W211', 92775807),
110 (78, 'Mercedes', 'W210', 2147483647),
111 (79, 'Mercedes', 'W204', 9285807),
112 (80, 'Mercedes', 'W124', 2147647),
113 (81, 'Mercedes', 'W212', 927),
114 (82, 'Ford', 'Fiesta', 922807),
115 (83, 'Ford', 'Pinto', 9854775807),
116 (84, 'Ford', 'Torino', 2147),
117 (85, 'Ford', 'Fiesta', 214647),
118 (86, 'Ford', 'Pinto', 922337807),
119 (87, 'Ford', 'Taurus', 21473647),
120 (88, 'Ford', 'Fiesta', 2143647),
121 (89, 'Ford', 'Torino', 922337807),
122 (90, 'Ford', 'Pinto', 922337203),
123 (91, 'Ford', 'GT40', 92233775807),
124 (92, 'Ford', 'Pinto', 9223807),
125 (93, 'Ford', 'GT40', 9223377),
126 (94, 'Ford', 'Fiesta', 922337775807),
127 (95, 'Ford', 'Torino', 217),
128 (96, 'Ford', 'Fiesta', 922375807),
129 (97, 'Ford', 'Pinto', 214647),
130 (98, 'Ford', 'Taurus', 9223375807),
131 (99, 'Ford', 'Fiesta', 214647),
132 (100, 'Ford', 'Torino', 21474647),
133 (101, 'Ford', 'Ranger', 9223372007),
134 (102, 'Ford', 'Pinto', 2147647),
135 (103, 'Ford', 'Ranger', 92233775807),
136 (104, 'Toyota', 'Prius', 9223372037),
137 (105, 'Toyota', 'Tacoma', 96854775807),
138 (106, 'Toyota', 'Prius', 214747),
139 (107, 'Toyota', 'Tacoma', 94775807),
140 (108, 'Toyota', 'Prius', 922337207),
141 (109, 'Toyota', 'Corolla', 9223854775807),
142 (110, 'Toyota', 'Yaris', 21477),
143 (111, 'Toyota', 'Prius', 922337203685),
144 (112, 'Toyota', 'Camry Hybrid', 92275807),
145 (113, 'Toyota', 'Corolla', 92235807),
146 (114, 'Toyota', 'Prius', 21477),
147 (115, 'Toyota', 'Corolla', 9223807),
148 (116, 'Toyota', 'Tacoma', 9225807),
149 (117, 'Toyota', 'Camry Hybrid', 954775807),
150 (118, 'Toyota', 'Prius', 925807),
151 (119, 'Toyota', 'Tacoma', 922337807),
152 (120, 'Toyota', 'Corolla', 2147),
153 (121, 'Toyota', 'Prius', 21477),
154 (122, 'Toyota', 'Corolla', 975807),
155 (123, 'Toyota', 'Yaris', 94775807),
156 (124, 'Toyota', 'Corolla', 21477),
157 (125, 'Toyota', 'Prius', 283647),
158 (126, 'Toyota', 'Tacoma', 927),
159 (127, 'Toyota', 'Yaris', 9207),
160 (128, 'Toyota', 'Prius', 92233775807),
161 (129, 'Toyota', 'Tacoma', 247),
162 (130, 'Toyota', 'Prius', 9223354775807),
163 (131, 'Toyota', 'Yaris', 21477),
164 (132, 'Toyota', 'Prius', 92233775807),
165 (133, 'Toyota', 'Tacoma', 2147),
166 (134, 'Toyota', 'Camry Hybrid', 2143647),
167 (135, 'Toyota', 'Prius', 922337807),
168 (136, 'Toyota', 'Camry Hybrid', 214647),
169 (137, 'Toyota', 'Prius', 922335807),
170 (138, 'Toyota', 'Tacoma', 21474647),
171 (139, 'Toyota', 'Camry Hybrid', 214647),
172 (140, 'Nissan', 'GT-R', 21473647),
173 (141, 'Nissan', 'Altima', 9223372775807),
174 (142, 'Nissan', 'GT-R', 2147647),
175 (143, 'Nissan', '370Z', 2143647),
176 (144, 'Nissan', 'GT-R', 21477),
177 (145, 'Nissan', 'Altima', 9224775807),
178 (146, 'Nissan', 'GT-R', 23647),
179 (147, 'Nissan', '370Z', 922775807),
180 (148, 'Nissan', '370Z', 21477),
181 (149, 'Nissan', 'Altima', 2147),
182 (150, 'Nissan', '370Z', 21447),
183 (151, 'Nissan', 'Altima', 92233707),
184 (152, 'Nissan', 'GT-R', 954775807),
185 (153, 'Nissan', 'Altima', 214647),
186 (154, 'Nissan', '370Z', 922337205807),
187 (155, 'Nissan', 'GT-R', 96854775807),
188 (156, 'Nissan', 'Versa', 9223775807),
189 (157, 'Nissan', 'Altima', 2147447),
190 (158, 'Nissan', '370Z', 922307),
191 (159, 'Nissan', 'GT-R', 2147447),
192 (160, 'Nissan', 'Rogue', 9223807),
193 (161, 'Nissan', 'Altima', 213647),
194 (162, 'Nissan', 'GT-R', 2143647),
195 (163, 'Nissan', 'Altima', 214747),
196 (164, 'Nissan', 'Rogue', 214647),
197 (165, 'Nissan', 'GT-R', 2147483647),
198 (166, 'Nissan', 'Altima', 2147483647),
199 (167, 'Nissan', 'Versa', 2143647),
200 (168, 'Nissan', 'GT-R', 2143647),
201 (169, 'Nissan', 'Versa', 922775807),
202 (170, 'Great Wall', 'H2', 9236854775807),
203 (171, 'Great Wall', 'Haval M4', 213647),
204 (172, 'Great Wall', 'H2', 21647),
205 (173, 'Great Wall', 'H8', 21447),
206 (174, 'Great Wall', 'Steed 3', 922336854775807),
207 (175, 'Great Wall', 'Wingle 5', 214747),
208 (176, 'Great Wall', 'Haval M4', 9223372035807),
209 (177, 'Great Wall', 'Haval H6', 214747),
210 (178, 'Renault', 'Alaskan', 2647),
211 (179, 'Renault', 'Clio IV', 2147483647),
212 (180, 'Renault', 'Duster', 2147483647),
213 (181, 'Renault', 'Alaskan', 92807),
214 (182, 'Renault', 'Alaskan', 2147483647),
215 (183, 'Renault', 'Duster', 922337203685807),
216 (184, 'Renault', 'Alaskan', 2147483647),
217 (185, 'Renault', 'Clio IV', 92234775807),
218 (186, 'Renault', 'Duster', 922337203685807),
219 (187, 'Renault', 'Alaskan', 92233720375807),
220 (188, 'Renault', 'Captur', 9223807),
221 (189, 'Renault', 'Alaskan', 21447),
222 (190, 'Renault', 'Espace', 9223375807),
223 (191, 'Renault', 'Alaskan', 2147483647),
224 (192, 'Renault', 'Captur', 92233724775807),
225 (193, 'Renault', 'Espace', 2147487),
226 (194, 'Chevy', 'Camaro', 92233854775807),
227 (195, 'Chevy', 'Caprice', 2147647),
228 (196, 'Chevy', 'Camaro', 922335807),
229 (197, 'Chevy', 'Caprice', 2143647),
230 (198, 'Chevy', 'Malibu', 92233854775807),
231 (199, 'Chevy', 'Camaro', 283647),
232 (200, 'Chevy', 'Impala', 214747),
233 (201, 'Chevy', 'Malibu', 922337775807),
234 (202, 'Chevy', 'Impala', 214748347),
235 (203, 'Chevy', 'Camaro', 21473647),
236 (204, 'Chevy', 'Camaro', 2147483647),
237 (205, 'Chevy', 'Corvette', 92233720375807),
238 (206, 'Chevy', 'Cruze', 92775807),
239 (207, 'Chevy', 'Corvette', 21474847),
240 (208, 'Chevy', 'Camaro', 2147487),
241 (209, 'Chevy', 'Caprice', 2147483647),
242 (210, 'Chevy', 'Cruze', 9223372034775807),
243 (211, 'Chevy', 'Caprice', 9223372034775807),
244 (212, 'Chevy', 'Matiz', 922337203685807),
245 (213, 'Rolls-Royce', 'Phantom', 2147483647),
246 (214, 'Rolls-Royce', 'Phantom Drophead Coupé', 92233775807),
247 (215, 'Rolls-Royce', 'Phantom', 214647),
248 (216, 'Rolls-Royce', 'Ghost', 21473647),
249 (217, 'Rolls-Royce', 'Dawn', 214647),
250 (218, 'Rolls-Royce', 'Phantom', 922337254775807),
251 (219, 'Rolls-Royce', 'Ghost', 214747),
252 (220, 'Rolls-Royce', 'Wraith', 2147483647),
253 (221, 'Rolls-Royce', 'Phantom Drophead Coupé', 922336854775807),
254 (222, 'Rolls-Royce', 'Wraith', 21647),
255 (223, 'Rolls-Royce', 'Phantom Drophead Coupé', 9223372075807),
256 (224, 'Lamborghini', 'Gallardo', 92234775807),
257 (225, 'Lamborghini', 'Murciélago', 2143647),
258 (226, 'Lamborghini', 'Diablo', 283647),
259 (227, 'Lamborghini', 'Gallardo', 9223372054775807),
260 (228, 'Lamborghini', 'Murciélago', 214783647),
261 (229, 'Lamborghini', 'Gallardo', 923372054775807),
262 (230, 'Lamborghini', 'Diablo', 2147483647),
263 (231, 'Ferrari', 'Daytona', 92036854775807),
264 (232, 'Ferrari', '250 GTO', 214747),
265 (233, 'Ferrari', 'F430', 2147647),
266 (234, 'Ferrari', '275', 92854775807),
267 (235, 'Ferrari', 'F430', 92236854775807),
268 (236, 'Ferrari', 'F40', 2647),
269 (237, 'Ferrari', '250 GTO', 214747),
270 (238, 'Ferrari', 'Daytona', 922337275807),
271 (239, 'Ferrari', '275', 214647),
272 (240, 'Ferrari', '250 GTO', 2183647),
273 (241, 'Ferrari', 'F40', 214647),
274 (242, 'Ferrari', '250 GTO', 213647),
275 (243, 'Ferrari', 'F430', 214647),
276 (244, 'Ferrari', 'Daytona', 213647),
277 (245, 'Ferrari', 'F40', 21447),
278 (246, 'Ferrari', '250 GTO', 213647),
279 (247, 'Ferrari', '275', 2147647),
280 (248, 'Ferrari', 'Enzo', 2147483647),
281 (249, 'Ferrari', 'Daytona', 2147447),
282 (250, 'Alfa Romeo', 'Giulia', 214647),
283 (251, 'Alfa Romeo', 'Giulietta', 21474847),
284 (252, 'Alfa Romeo', 'AR51', 2147483647),
285 (253, 'Alfa Romeo', 'Alfetta', 92233720775807),
286 (254, 'Alfa Romeo', '75', 9223372775807),
287 (255, 'Alfa Romeo', 'AR51', 922337275807),
288 (256, 'Alfa Romeo', '156', 92233720368547),
289 (257, 'Alfa Romeo', 'Giulietta', 922337203685807),
290 (258, 'Alfa Romeo', '164', 92233775807),
291 (259, 'Alfa Romeo', '75', 72036854775807),
292 (260, 'Alfa Romeo', 'Giulietta', 2036854775807),
293 (261, 'Alfa Romeo', '156', 92036854775807),
294 (262, 'Alfa Romeo', 'Giulietta', 2036854775807),
295 (263, 'Alfa Romeo', '75', 9775807),
296 (264, 'Peugeot', '206', 214647),
297 (265, 'Peugeot', '405', 92236854775807),
298 (266, 'Peugeot', '206', 2147483647),
299 (267, 'Peugeot', '405', 922854775807),
300 (268, 'Peugeot', '306', 2036854775807),
301 (269, 'Peugeot', '308', 775807),
302 (270, 'Peugeot', '407', 854775807),
303 (271, 'Peugeot', '306', 2147483647),
304 (272, 'Peugeot', '308', 854775807),
305 (273, 'Peugeot', '405', 9226854775807),
306 (274, 'Peugeot', '306', 21474647),
307 (275, 'Peugeot', '407', 922036854775807),
308 (276, 'Peugeot', '206', 21474647),
309 (277, 'Peugeot', '407', 9223372775807),
310 (278, 'Peugeot', '206', 922036854775807),
311 (279, 'Peugeot', '308', 23647),
312 (280, 'Peugeot', '405', 92036854775807),
313 (281, 'Peugeot', '306', 2147483647),
314 (282, 'Peugeot', '405', 92233854775807),
315 (283, 'Peugeot', '308', 2147483647),
316 (284, 'Peugeot', '206', 922775807),
317 (285, 'Peugeot', '206', 214748347),
318 (286, 'Citroen', 'Berlingo', 922354775807),
319 (287, 'Citroen', 'C1', 924775807),
320 (288, 'Citroen', 'Berlingo', 9223354775807),
321 (289, 'Citroen', 'C5', 922334775807),
322 (290, 'Citroen', 'C5', 213647),
323 (291, 'Citroen', 'C8', 2147447),
324 (292, 'Citroen', 'Elysée', 922354775807),
325 (293, 'Citroen', 'C1', 2147),
326 (294, 'Citroen', 'C4', 2147487),
327 (295, 'Citroen', 'C5', 922337204775807),
328 (296, 'Citroen', 'C1', 922337854775807),
329 (297, 'Citroen', 'C3', 214647),
330 (298, 'Citroen', 'C1', 2483647),
331 (299, 'Citroen', 'C4', 92236854775807),
332 (300, 'Citroen', 'C1', 922336854775807),
333 (301, 'Citroen', 'C5', 2147483647),
334 (302, 'Citroen', 'C3', 2147647),
335 (303, 'Citroen', 'C8', 92236854775807),
336 (304, 'Citroen', 'C1', 2147483647),
337 (305, 'Citroen', 'C3', 9223336854775807),
338 (306, 'Citroen', 'Elysée', 23336854775),
339 (307, 'Citroen', 'C1', 92236854775807),
340 (308, 'Citroen', 'C4', 213647),
341 (309, 'Citroen', 'C3', 2147647),
342 (310, 'Citroen', 'C1', 9223775807),
343 (311, 'Citroen', 'C5', 2183647),
344 (312, 'Citroen', 'C1', 9854775807),
345 (313, 'Citroen', 'C8', 83647),
346 (314, 'Seat', 'Toledo', 21483647),
347 (315, 'Seat', 'Mii', 214783647),
348 (316, 'Seat', 'Ibiza', 21647),
349 (317, 'Seat', 'Mii', 2147447),
350 (318, 'Seat', 'Ibiza', 213647),
351 (319, 'Seat', 'Mii', 21447),
352 (320, 'Seat', 'Toledo', 2147647),
353 (321, 'Seat', 'Toledo', 21473647),
354 (322, 'Seat', 'Ibiza', 92234775807),
355 (323, 'Seat', 'Mii', 936854775807),
356 (324, 'Seat', 'Toledo', 21447),
357 (325, 'Seat', 'Mii', 214747),
358 (326, 'Seat', 'Toledo', 2147647),
359 (327, 'Seat', 'Ibiza', 21474847),
360 (328, 'Seat', 'Toledo', 2147447),
361 (329, 'Seat', 'Mii', 92236854775807),
362 (330, 'Skoda', 'Citigo', 214647),
363 (331, 'Skoda', 'Rapid Spaceback', 685477580),
364 (332, 'Skoda', 'Citigo', 92233854775807),
365 (333, 'Skoda', 'Citigo', 2183647),
366 (334, 'Skoda', 'Citigo', 214747),
367 (335, 'Skoda', 'Fabia', 9223372036875807),
368 (336, 'Skoda', 'Citigo', 214647),
369 (337, 'Skoda', 'Fabia', 214747),
370 (338, 'Skoda', 'Rapid', 9223372775807),
371 (339, 'Skoda', 'Fabia', 214647),
372 (340, 'Skoda', 'Fabia', 922337203775807),
373 (341, 'Skoda', 'Rapid', 2147447),
374 (342, 'Skoda', 'Rapid Spaceback', 474),
375 (343, 'Skoda', 'Fabia', 92233720368807),
376 (344, 'Dacia', 'Logan', 9036854775807),
377 (345, 'Dacia', 'Sandero Stepway', 92233724775807),
378 (346, 'Dacia', 'Sandero', 2147647),
379 (347, 'Dacia', 'Dokker', 213647),
380 (348, 'Dacia', 'Sandero', 2143647),
381 (349, 'Dacia', 'Logan', 21474647),
382 (350, 'Dacia', 'Logan', 9275807),
383 (351, 'Dacia', 'Dokker', 2147647),
384 (352, 'Dacia', 'Sandero', 922337254775807),
385 (353, 'Dacia', 'Dokker', 2147447),
386 (354, 'Dacia', 'Logan', 922337203687),
387 (355, 'Dacia', 'Duster', 21447),
388 (356, 'Dacia', 'Sandero Stepway', 922337807),
389 (357, 'Dacia', 'Duster', 922375807),
390 (358, 'Dacia', 'Logan', 213647);
391 /*!40000 ALTER TABLE `cars` ENABLE KEYS */;
392
393
394 DROP TABLE IF EXISTS `customers`;
395 CREATE TABLE IF NOT EXISTS `customers` (
396 `id` bigint(20) NOT NULL,
397 `name` varchar(255) NOT NULL,
398 `birthDate` datetime NOT NULL,
399 `isYoungDriver` bit(1) NOT NULL,
400 PRIMARY KEY (`id`)
401 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
402
403
404 /*!40000 ALTER TABLE `customers` DISABLE KEYS */;
405 INSERT INTO `customers` (`id`, `name`, `birthDate`, `isYoungDriver`) VALUES
406 (1, 'Emmitt Benally', '1993-11-20 00:00:00', b'1'),
407 (2, 'Natalie Poli', '1990-10-04 00:00:00', b'0'),
408 (3, 'Marcelle Griego', '1990-10-04 00:00:00', b'1'),
409 (4, 'Zada Attwood', '1982-10-01 00:00:00', b'1'),
410 (5, 'Hai Everton', '1985-10-01 00:00:00', b'1'),
411 (6, 'Lino Subia', '1985-12-21 00:00:00', b'0'),
412 (7, 'Rico Peer', '1984-10-01 00:00:00', b'1'),
413 (8, 'Teddy Hobby', '1975-10-01 00:00:00', b'1'),
414 (9, 'Johnette Derryberry', '1995-10-01 00:00:00', b'1'),
415 (10, 'Audrea Cardinal', '1976-10-01 00:00:00', b'0'),
416 (11, 'Francis Mckim', '1977-10-01 00:00:00', b'1'),
417 (12, 'Carole Witman', '1987-10-01 00:00:00', b'0'),
418 (13, 'Oren Perlman', '1988-10-01 00:00:00', b'1'),
419 (14, 'Brett Brickley', '1980-10-01 00:00:00', b'1'),
420 (15, 'Kristian Engberg', '1981-10-03 00:00:00', b'0'),
421 (16, 'Carri Knapik', '1972-02-02 00:00:00', b'1'),
422 (17, 'Rema Revelle', '1970-05-01 00:00:00', b'1'),
423 (18, 'Taina Achenbach', '1994-10-01 00:00:00', b'0'),
424 (19, 'Yvonne Mccalla', '1992-03-02 00:00:00', b'1'),
425 (20, 'Nisha Markwell', '1994-04-04 00:00:00', b'0'),
426 (21, 'Cinthia Lasala', '1992-11-01 00:00:00', b'1'),
427 (22, 'Daniele Zarate', '1995-10-05 00:00:00', b'0'),
428 (23, 'Faustina Burgher', '1994-06-01 00:00:00', b'0'),
429 (24, 'Jimmy Grossi', '1986-07-01 00:00:00', b'1'),
430 (25, 'Sylvie Mcelravy', '1983-10-01 00:00:00', b'0'),
431 (26, 'Hipolito Lamoreaux', '1982-08-01 00:00:00', b'1'),
432 (27, 'Garret Capron', '1975-07-01 00:00:00', b'0'),
433 (28, 'Donnetta Soliz', '1963-10-01 00:00:00', b'1'),
434 (29, 'Louann Holzworth', '1960-10-01 00:00:00', b'0'),
435 (30, 'Ann Mcenaney', '1992-03-02 00:00:00', b'1');
436 /*!40000 ALTER TABLE `customers` ENABLE KEYS */;
437
438
439 DROP TABLE IF EXISTS `parts`;
440 CREATE TABLE IF NOT EXISTS `parts` (
441 `id` bigint(20) NOT NULL,
442 `name` varchar(255) DEFAULT NULL,
443 `price` double DEFAULT NULL,
444 `quantity` bigint(20) DEFAULT NULL,
445 `supplier_id` bigint(20) DEFAULT NULL,
446 PRIMARY KEY (`id`),
447 KEY `FK__suppliers` (`supplier_id`),
448 CONSTRAINT `FK__suppliers` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
449 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
450
451
452 /*!40000 ALTER TABLE `parts` DISABLE KEYS */;
453 INSERT INTO `parts` (`id`, `name`, `price`, `quantity`, `supplier_id`) VALUES
454 (1, 'Bonnet/hood', 1001.34, 10, 13),
455 (2, 'Unexposed bumper', 1003.34, 10, 22),
456 (3, 'Exposed bumper', 1400.34, 10, 20),
457 (4, 'Cowl screen', 1500.34, 10, 19),
458 (5, 'Decklid', 1060.34, 11, 2),
459 (6, 'Fascia', 100.34, 10, 31),
460 (7, 'Fender', 10.34, 10, 30),
461 (8, 'Front clip', 100, 10, 13),
462 (9, 'Front fascia', 11.99, 10, 11),
463 (10, 'Grille', 144.99, 10, 15),
464 (11, 'Pillar', 100.99, 10, 13),
465 (12, 'Quarter panel', 100.99, 200, 27),
466 (13, 'Radiator ', 100.99, 10, 6),
467 (14, 'Rocker', 100.99, 10, 4),
468 (15, 'Roof rack', 100.99, 10, 8),
469 (16, 'Spoiler', 3000.99, 10, 12),
470 (17, 'Rims', 4020.99, 10, 21),
471 (18, 'Trim package', 1900.99, 10, 5),
472 (19, 'Trunk/boot/hatch', 2200.99, 300, 3),
473 (20, 'Valance', 1002.99, 10, 17),
474 (21, 'Welded assembly', 1020.99, 10, 16),
475 (22, 'Front Right Outer door handle', 999.99, 345, 14),
476 (23, 'Front Left Side Outer door handle', 999.99, 10, 28),
477 (24, 'Rear Right Side Outer door handle', 80.99, 10, 27),
478 (25, 'Rear Left Side Outer door handle', 120.99, 10, 30),
479 (26, 'Front Right Side Inner door handle', 100.99, 10, 28),
480 (27, 'Front Left Side Inner door handle', 77.99, 1032, 12),
481 (28, 'Rear Right Side Inner door handle', 79.99, 10, 10),
482 (29, 'Rear Left Side Inner door handle', 93.99, 234, 8),
483 (30, 'Back Door Outer Door Handle', 43.99, 10, 23),
484 (31, 'Front Right Side Window motor', 44.99, 10, 1),
485 (32, 'Front Left Side Window motor', 56.99, 10, 31),
486 (33, 'Rear Right Side Window motor', 22.99, 10, 29),
487 (34, 'Rear Left Side Window motor', 144.99, 10, 12),
488 (35, 'Door control module', 421.99, 10, 11),
489 (36, 'Door seal', 444.99, 10, 25),
490 (37, 'Door water-shield', 123.99, 10, 23),
491 (38, 'Hinge', 11.99, 10, 22),
492 (39, 'Door latch', 2331.99, 10, 5),
493 (40, 'Door lock and power door locks', 120.99, 10, 23),
494 (41, 'Center-locking', 313.99, 10, 7),
495 (42, 'Fuel tank', 100.98, 10, 11),
496 (43, 'Front Right Side Door Glass', 100.91, 10, 25),
497 (44, 'Front Left Side Door Glass', 100.92, 10, 24),
498 (45, 'Rear Right Side Door Glass', 100.9, 10, 7),
499 (46, 'Rear Left Side Door Glass', 100.66, 10, 5),
500 (47, 'Rear Right Quarter Glass', 100.66, 10, 4),
501 (48, 'Rear Left Quarter Glass', 100.55, 10, 18),
502 (49, 'Sunroof', 103.43, 10, 17),
503 (50, 'Sunroof Rail', 100.25, 10, 15),
504 (51, 'Sunroof Glass', 205.24, 10, 29),
505 (52, 'Window motor', 123.49, 10, 28),
506 (53, 'Window regulator', 100.99, 10, 6),
507 (54, 'Windshield', 100.99, 10, 20),
508 (55, 'Window seal', 100.99, 10, 19),
509 (56, 'Engine', 100.99, 10, 22),
510 (57, 'Camshaft', 100.98, 10, 20),
511 (58, 'Crank case', 2.93, 10, 19),
512 (59, 'Crank pulley', 2.8, 10, 2),
513 (60, 'Crankshaft', 4.99, 10, 5),
514 (61, 'Cylinder head', 6.99, 10, 15),
515 (62, 'Distributor', 7.99, 10, 13),
516 (63, 'Distributor cap', 9.99, 10, 16),
517 (64, 'Drive belt', 3.99, 10, 15),
518 (65, 'Engine block', 40.99, 10, 13),
519 (66, 'Engine cradle', 39.99, 10, 27),
520 (67, 'Engine shake damper and vibration absorber', 100.99, 10, 26),
521 (68, 'Engine valve', 49.99, 10, 9),
522 (69, 'Fan belt', 10.99, 10, 7),
523 (70, 'Gudgeon pin', 44.99, 10, 6),
524 (71, 'Harmonic balancer', 67.99, 10, 20),
525 (72, 'Heater', 82.99, 10, 18),
526 (73, 'Piston', 94.99, 10, 17),
527 (74, 'Poppet valve', 88.99, 10, 31),
528 (75, 'Rocker arm', 98.99, 10, 29),
529 (76, 'Rocker cover', 10.99, 10, 13),
530 (77, 'Starter motor', 0.99, 10, 11),
531 (78, 'Turbocharger', 0.4, 10, 10),
532 (79, 'Tappet', 300.29, 10, 19),
533 (80, 'Timing tape', 40.9, 10, 2),
534 (81, 'Valve cover', 130.99, 10, 1),
535 (82, 'Valve housing', 400.99, 10, 30),
536 (83, 'Valve spring', 104.99, 10, 13),
537 (84, 'Valve stem seal', 120.99, 10, 12),
538 (85, 'Water pump pulley', 150.99, 10, 26),
539 (86, 'Air blower', 140.99, 10, 5),
540 (87, 'Coolant hose ', 150.99, 10, 3),
541 (88, 'Cooling fan', 120.99, 10, 1),
542 (89, 'Fan blade', 150.99, 10, 4),
543 (90, 'Fan clutch', 120.99, 10, 3),
544 (91, 'Radiator bolt', 160.99, 10, 17),
545 (92, 'Radiator (fan) shroud', 300.99, 10, 21),
546 (93, 'Radiator gasket', 140.99, 10, 30),
547 (94, 'Radiator pressure cap', 600.99, 10, 28),
548 (95, 'Overflow tank', 1200.99, 10, 26),
549 (96, 'Thermostat', 1050.99, 10, 10),
550 (97, 'Water neck', 900.99, 10, 8),
551 (98, 'Water neck o-ring', 43.99, 10, 7),
552 (99, 'Water pipe', 44.94, 10, 21),
553 (100, 'Water pump', 44.93, 10, 19),
554 (101, 'Water pump gasket', 120.29, 10, 3),
555 (102, 'Water tank', 100.99, 10, 12),
556 (103, 'Oil filter', 200.99, 10, 10),
557 (104, 'Oil gasket', 130.99, 10, 9),
558 (105, 'Oil pan', 140.99, 10, 23),
559 (106, 'Oil pipe', 100.29, 10, 21),
560 (107, 'Oil pump', 100.19, 10, 20),
561 (108, 'Oil strainer', 45.29, 10, 3),
562 (109, 'Catalytic converter', 540.99, 10, 1),
563 (110, 'Exhaust clamp and bracket', 140.99, 10, 16),
564 (111, 'Exhaust flange gasket', 130.99, 10, 14),
565 (112, 'Resonator', 106.99, 10, 12),
566 (113, 'Muffler', 106.9, 10, 27),
567 (114, 'Exhaust pipe', 130.99, 10, 25),
568 (115, 'Heat shield', 10.99, 10, 23),
569 (116, 'Air filter', 200.99, 10, 7),
570 (117, 'Choke cable', 130.99, 10, 5),
571 (118, 'Fuel cooler', 140.99, 10, 15),
572 (119, 'Fuel filter', 162.99, 10, 29),
573 (120, 'Fuel rail', 107.99, 10, 27),
574 (121, 'Fuel pressure regulator', 100.99, 10, 26),
575 (122, 'Steering arm', 104.99, 10, 9),
576 (123, 'Steering box', 103.99, 10, 7),
577 (124, 'Clutch assembly', 120.99, 10, 6),
578 (125, 'Master cylinder', 130.99, 10, 20),
579 (126, 'Speed reducer', 14.99, 10, 23),
580 (127, 'Transmission gear', 15.99, 10, 2),
581 (128, 'Transmission pan', 106.99, 10, 31),
582 (129, 'Differential seal', 109.99, 10, 29),
583 (130, 'Differential clutch', 120.99, 10, 13),
584 (131, 'Clutch shoe', 10.49, 10, 11);
585 /*!40000 ALTER TABLE `parts` ENABLE KEYS */;
586
587
588 DROP TABLE IF EXISTS `parts_cars`;
589 CREATE TABLE IF NOT EXISTS `parts_cars` (
590 `part_id` bigint(20) DEFAULT NULL,
591 `car_id` bigint(20) DEFAULT NULL,
592 KEY `FK__parts` (`part_id`),
593 KEY `FK__cars` (`car_id`),
594 CONSTRAINT `FK__cars` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`),
595 CONSTRAINT `FK__parts` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`)
596 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
597
598
599 /*!40000 ALTER TABLE `parts_cars` DISABLE KEYS */;
600 INSERT INTO `parts_cars` (`part_id`, `car_id`) VALUES
601 (20, 1),
602 (41, 1),
603 (67, 1),
604 (92, 1),
605 (114, 1),
606 (8, 2),
607 (34, 2),
608 (92, 2),
609 (118, 2),
610 (34, 3),
611 (59, 3),
612 (81, 3),
613 (22, 4),
614 (59, 4),
615 (106, 4),
616 (1, 5),
617 (22, 5),
618 (48, 5),
619 (26, 6),
620 (48, 6),
621 (73, 6),
622 (15, 7),
623 (99, 7),
624 (120, 7),
625 (15, 8),
626 (41, 8),
627 (62, 8),
628 (41, 9),
629 (88, 9),
630 (29, 10),
631 (66, 10),
632 (113, 10),
633 (8, 11),
634 (29, 11),
635 (55, 11),
636 (80, 12),
637 (102, 12),
638 (127, 12),
639 (22, 13),
640 (47, 13),
641 (69, 13),
642 (106, 13),
643 (127, 13),
644 (10, 14),
645 (36, 14),
646 (94, 14),
647 (120, 14),
648 (15, 15),
649 (36, 15),
650 (62, 15),
651 (62, 16),
652 (87, 16),
653 (109, 16),
654 (3, 17),
655 (29, 17),
656 (50, 17),
657 (76, 17),
658 (17, 18),
659 (54, 18),
660 (101, 18),
661 (127, 18),
662 (43, 19),
663 (68, 19),
664 (90, 19),
665 (115, 19),
666 (127, 19),
667 (10, 20),
668 (94, 20),
669 (115, 20),
670 (36, 21),
671 (57, 21),
672 (36, 22),
673 (83, 22),
674 (130, 22),
675 (3, 23),
676 (24, 23),
677 (108, 23),
678 (130, 23),
679 (3, 24),
680 (50, 24),
681 (50, 25),
682 (75, 25),
683 (97, 25),
684 (122, 25),
685 (17, 26),
686 (38, 26),
687 (122, 26),
688 (42, 27),
689 (64, 27),
690 (5, 28),
691 (42, 28),
692 (89, 28),
693 (5, 29),
694 (31, 29),
695 (115, 29),
696 (31, 30),
697 (57, 30),
698 (78, 30),
699 (57, 31),
700 (82, 31),
701 (104, 31),
702 (24, 32),
703 (45, 32),
704 (82, 32),
705 (129, 32),
706 (24, 33),
707 (71, 33),
708 (118, 33),
709 (12, 34),
710 (96, 34),
711 (118, 34),
712 (12, 35),
713 (38, 35),
714 (122, 35),
715 (38, 36),
716 (63, 36),
717 (85, 36),
718 (26, 37),
719 (63, 37),
720 (110, 37),
721 (5, 38),
722 (26, 38),
723 (52, 38),
724 (31, 39),
725 (52, 39),
726 (78, 39),
727 (19, 40),
728 (78, 40),
729 (103, 40),
730 (125, 40),
731 (19, 41),
732 (45, 41),
733 (66, 41),
734 (45, 42),
735 (70, 42),
736 (92, 42),
737 (12, 43),
738 (33, 43),
739 (70, 43),
740 (117, 43),
741 (12, 44),
742 (59, 44),
743 (106, 44),
744 (84, 45),
745 (106, 45),
746 (110, 45),
747 (131, 45),
748 (26, 46),
749 (73, 46),
750 (110, 46),
751 (15, 47),
752 (52, 47),
753 (73, 47),
754 (99, 47),
755 (15, 48),
756 (40, 48),
757 (124, 48),
758 (19, 49),
759 (40, 49),
760 (66, 49),
761 (113, 49),
762 (7, 50),
763 (33, 50),
764 (54, 50),
765 (91, 50),
766 (113, 50),
767 (33, 51),
768 (80, 51),
769 (21, 52),
770 (58, 52),
771 (105, 52),
772 (47, 53),
773 (131, 53),
774 (73, 54),
775 (94, 54),
776 (120, 54),
777 (14, 55),
778 (40, 55),
779 (61, 55),
780 (98, 55),
781 (120, 55),
782 (3, 56),
783 (40, 56),
784 (87, 56),
785 (7, 57),
786 (28, 57),
787 (112, 57),
788 (7, 58),
789 (54, 58),
790 (101, 58),
791 (42, 59),
792 (79, 59),
793 (101, 59),
794 (126, 59),
795 (21, 60),
796 (47, 60),
797 (68, 60),
798 (10, 61),
799 (94, 61),
800 (35, 62),
801 (119, 62),
802 (61, 63),
803 (82, 63),
804 (108, 63),
805 (2, 64),
806 (28, 64),
807 (49, 64),
808 (86, 64),
809 (108, 64),
810 (28, 65),
811 (75, 65),
812 (122, 65),
813 (16, 66),
814 (42, 66),
815 (100, 66),
816 (122, 66),
817 (126, 66),
818 (42, 67),
819 (68, 67),
820 (89, 67),
821 (115, 67),
822 (9, 68),
823 (31, 68),
824 (56, 68),
825 (115, 68),
826 (35, 69),
827 (82, 69),
828 (129, 69),
829 (23, 70),
830 (70, 70),
831 (107, 70),
832 (129, 70),
833 (49, 71),
834 (74, 71),
835 (96, 71),
836 (16, 72),
837 (37, 72),
838 (74, 72),
839 (121, 72),
840 (63, 73),
841 (110, 73),
842 (5, 74),
843 (30, 74),
844 (89, 74),
845 (110, 74),
846 (114, 74),
847 (56, 75),
848 (77, 75),
849 (103, 75),
850 (19, 76),
851 (103, 76),
852 (128, 76),
853 (23, 77),
854 (44, 77),
855 (70, 77),
856 (128, 77),
857 (70, 78),
858 (95, 78),
859 (117, 78),
860 (11, 79),
861 (58, 79),
862 (95, 79),
863 (37, 80),
864 (63, 80),
865 (84, 80),
866 (26, 81),
867 (63, 81),
868 (110, 81),
869 (4, 82),
870 (26, 82),
871 (51, 82),
872 (51, 83),
873 (77, 83),
874 (98, 83),
875 (18, 84),
876 (65, 84),
877 (102, 84),
878 (124, 84),
879 (44, 85),
880 (65, 85),
881 (91, 85),
882 (7, 86),
883 (32, 86),
884 (91, 86),
885 (116, 86),
886 (11, 87),
887 (32, 87),
888 (58, 87),
889 (58, 88),
890 (84, 88),
891 (105, 88),
892 (47, 89),
893 (84, 89),
894 (131, 89),
895 (25, 90),
896 (47, 90),
897 (72, 90),
898 (51, 91),
899 (72, 91),
900 (98, 91),
901 (14, 92),
902 (39, 92),
903 (98, 92),
904 (123, 92),
905 (39, 93),
906 (65, 93),
907 (86, 93),
908 (6, 94),
909 (53, 94),
910 (65, 94),
911 (90, 94),
912 (112, 94),
913 (32, 95),
914 (53, 95),
915 (79, 95),
916 (79, 96),
917 (105, 96),
918 (126, 96),
919 (21, 97),
920 (46, 97),
921 (105, 97),
922 (130, 97),
923 (46, 98),
924 (72, 98),
925 (93, 98),
926 (35, 99),
927 (72, 99),
928 (119, 99),
929 (13, 100),
930 (35, 100),
931 (60, 100),
932 (39, 101),
933 (60, 101),
934 (86, 101),
935 (2, 102),
936 (27, 102),
937 (111, 102),
938 (27, 103),
939 (53, 103),
940 (74, 103),
941 (100, 103),
942 (79, 104),
943 (100, 104),
944 (126, 104),
945 (20, 105),
946 (42, 105),
947 (67, 105),
948 (126, 105),
949 (9, 106),
950 (67, 106),
951 (93, 106),
952 (114, 106),
953 (9, 107),
954 (118, 107),
955 (34, 108),
956 (60, 108),
957 (81, 108),
958 (1, 109),
959 (23, 109),
960 (60, 109),
961 (107, 109),
962 (1, 110),
963 (48, 110),
964 (27, 111),
965 (48, 111),
966 (74, 111),
967 (121, 111),
968 (16, 112),
969 (63, 112),
970 (100, 112),
971 (121, 112),
972 (41, 113),
973 (63, 113),
974 (88, 113),
975 (30, 114),
976 (67, 114),
977 (114, 114),
978 (8, 115),
979 (30, 115),
980 (55, 115),
981 (55, 116),
982 (81, 116),
983 (102, 116),
984 (22, 117),
985 (81, 117),
986 (106, 117),
987 (128, 117),
988 (22, 118),
989 (69, 118),
990 (11, 119),
991 (48, 119),
992 (69, 119),
993 (95, 119),
994 (11, 120),
995 (121, 120),
996 (15, 121),
997 (37, 121),
998 (62, 121),
999 (121, 121),
1000 (4, 122),
1001 (51, 122),
1002 (62, 122),
1003 (88, 122),
1004 (109, 122),
1005 (29, 123),
1006 (51, 123),
1007 (76, 123),
1008 (18, 124),
1009 (55, 124),
1010 (76, 124),
1011 (102, 124),
1012 (18, 125),
1013 (43, 125),
1014 (127, 125),
1015 (43, 126),
1016 (90, 126),
1017 (69, 127),
1018 (90, 127),
1019 (95, 127),
1020 (116, 127),
1021 (11, 128),
1022 (36, 128),
1023 (58, 128),
1024 (95, 128),
1025 (36, 129),
1026 (83, 129),
1027 (130, 129),
1028 (3, 130),
1029 (25, 130),
1030 (50, 130),
1031 (97, 130),
1032 (109, 130),
1033 (130, 130),
1034 (17, 131),
1035 (39, 131),
1036 (76, 131),
1037 (97, 131),
1038 (123, 131),
1039 (17, 132),
1040 (43, 132),
1041 (64, 132),
1042 (6, 133),
1043 (90, 133),
1044 (116, 133),
1045 (32, 134),
1046 (57, 134),
1047 (79, 134),
1048 (116, 134),
1049 (83, 135),
1050 (104, 135),
1051 (130, 135),
1052 (24, 136),
1053 (46, 136),
1054 (71, 136),
1055 (118, 136),
1056 (130, 136),
1057 (13, 137),
1058 (97, 137),
1059 (118, 137),
1060 (122, 137),
1061 (38, 138),
1062 (64, 138),
1063 (85, 138),
1064 (111, 138),
1065 (6, 139),
1066 (27, 139),
1067 (53, 139),
1068 (111, 139),
1069 (31, 140),
1070 (53, 140),
1071 (78, 140),
1072 (20, 141),
1073 (78, 141),
1074 (104, 141),
1075 (125, 141),
1076 (20, 142),
1077 (67, 142),
1078 (45, 143),
1079 (71, 143),
1080 (92, 143),
1081 (34, 144),
1082 (71, 144),
1083 (118, 144),
1084 (12, 145),
1085 (34, 145),
1086 (59, 145),
1087 (1, 146),
1088 (59, 146),
1089 (85, 146),
1090 (106, 146),
1091 (1, 147),
1092 (27, 147),
1093 (111, 147),
1094 (27, 148),
1095 (74, 148),
1096 (15, 149),
1097 (52, 149),
1098 (74, 149),
1099 (99, 149),
1100 (15, 150),
1101 (125, 150),
1102 (19, 151),
1103 (41, 151),
1104 (66, 151),
1105 (125, 151),
1106 (8, 152),
1107 (66, 152),
1108 (92, 152),
1109 (113, 152),
1110 (8, 153),
1111 (55, 153),
1112 (33, 154),
1113 (55, 154),
1114 (80, 154),
1115 (22, 155),
1116 (59, 155),
1117 (106, 155),
1118 (1, 156),
1119 (22, 156),
1120 (95, 156),
1121 (73, 157),
1122 (95, 157),
1123 (120, 157),
1124 (15, 158),
1125 (62, 158),
1126 (99, 158),
1127 (120, 158),
1128 (40, 159),
1129 (62, 159),
1130 (87, 159),
1131 (3, 160),
1132 (29, 160),
1133 (113, 160),
1134 (7, 161),
1135 (29, 161),
1136 (54, 161),
1137 (54, 162),
1138 (80, 162),
1139 (101, 162),
1140 (22, 163),
1141 (43, 163),
1142 (80, 163),
1143 (127, 163),
1144 (22, 164),
1145 (69, 164),
1146 (10, 165),
1147 (47, 165),
1148 (94, 165),
1149 (10, 166),
1150 (36, 166),
1151 (120, 166),
1152 (36, 167),
1153 (61, 167),
1154 (83, 167),
1155 (61, 168),
1156 (87, 168),
1157 (108, 168),
1158 (3, 169),
1159 (50, 169),
1160 (87, 169),
1161 (28, 170),
1162 (50, 170),
1163 (75, 170),
1164 (17, 171),
1165 (75, 171),
1166 (101, 171),
1167 (122, 171),
1168 (17, 172),
1169 (43, 172),
1170 (127, 172),
1171 (43, 173),
1172 (68, 173),
1173 (90, 173),
1174 (31, 174),
1175 (68, 174),
1176 (115, 174),
1177 (10, 175),
1178 (31, 175),
1179 (57, 175),
1180 (35, 176),
1181 (57, 176),
1182 (82, 176),
1183 (24, 177),
1184 (108, 177),
1185 (129, 177),
1186 (24, 178),
1187 (71, 178),
1188 (49, 179),
1189 (71, 179),
1190 (75, 179),
1191 (96, 179),
1192 (17, 180),
1193 (38, 180),
1194 (75, 180),
1195 (122, 180),
1196 (17, 181),
1197 (64, 181),
1198 (5, 182),
1199 (64, 182),
1200 (89, 182),
1201 (111, 182),
1202 (5, 183),
1203 (115, 183),
1204 (31, 184),
1205 (56, 184),
1206 (78, 184),
1207 (115, 184),
1208 (19, 185),
1209 (56, 185),
1210 (103, 185),
1211 (45, 186),
1212 (129, 186),
1213 (23, 187),
1214 (45, 187),
1215 (70, 187),
1216 (12, 188),
1217 (70, 188),
1218 (96, 188),
1219 (117, 188),
1220 (12, 189),
1221 (38, 189),
1222 (59, 189),
1223 (38, 190),
1224 (85, 190),
1225 (26, 191),
1226 (63, 191),
1227 (85, 191),
1228 (110, 191),
1229 (5, 192),
1230 (26, 192),
1231 (52, 192),
1232 (52, 193),
1233 (77, 193),
1234 (99, 193),
1235 (19, 194),
1236 (77, 194),
1237 (103, 194),
1238 (124, 194),
1239 (19, 195),
1240 (66, 195),
1241 (7, 196),
1242 (44, 196),
1243 (66, 196),
1244 (91, 196),
1245 (7, 197),
1246 (117, 197),
1247 (12, 198),
1248 (33, 198),
1249 (59, 198),
1250 (117, 198),
1251 (59, 199),
1252 (84, 199),
1253 (106, 199),
1254 (26, 200),
1255 (47, 200),
1256 (73, 200),
1257 (131, 200),
1258 (51, 201),
1259 (73, 201),
1260 (98, 201),
1261 (14, 202),
1262 (40, 202),
1263 (98, 202),
1264 (124, 202),
1265 (40, 203),
1266 (65, 203),
1267 (87, 203),
1268 (65, 204),
1269 (91, 204),
1270 (112, 204),
1271 (7, 205),
1272 (33, 205),
1273 (54, 205),
1274 (33, 206),
1275 (80, 206),
1276 (127, 206),
1277 (21, 207),
1278 (47, 207),
1279 (105, 207),
1280 (127, 207),
1281 (131, 207),
1282 (47, 208),
1283 (72, 208),
1284 (94, 208),
1285 (35, 209),
1286 (72, 209),
1287 (119, 209),
1288 (14, 210),
1289 (35, 210),
1290 (61, 210),
1291 (39, 211),
1292 (61, 211),
1293 (86, 211),
1294 (2, 212),
1295 (28, 212),
1296 (86, 212),
1297 (112, 212),
1298 (28, 213),
1299 (75, 213),
1300 (54, 214),
1301 (79, 214),
1302 (101, 214),
1303 (21, 215),
1304 (42, 215),
1305 (79, 215),
1306 (126, 215),
1307 (21, 216),
1308 (68, 216),
1309 (115, 216),
1310 (9, 217),
1311 (93, 217),
1312 (115, 217),
1313 (119, 217),
1314 (35, 218),
1315 (60, 218),
1316 (82, 218),
1317 (119, 218),
1318 (23, 219),
1319 (60, 219),
1320 (107, 219),
1321 (2, 220),
1322 (23, 220),
1323 (49, 220),
1324 (28, 221),
1325 (49, 221),
1326 (75, 221),
1327 (16, 222),
1328 (75, 222),
1329 (100, 222),
1330 (122, 222),
1331 (16, 223),
1332 (63, 223),
1333 (42, 224),
1334 (67, 224),
1335 (89, 224),
1336 (9, 225),
1337 (30, 225),
1338 (67, 225),
1339 (114, 225),
1340 (9, 226),
1341 (56, 226),
1342 (56, 227),
1343 (81, 227),
1344 (103, 227),
1345 (23, 228),
1346 (81, 228),
1347 (107, 228),
1348 (128, 228),
1349 (23, 229),
1350 (49, 229),
1351 (70, 229),
1352 (12, 230),
1353 (49, 230),
1354 (96, 230),
1355 (12, 231),
1356 (37, 231),
1357 (121, 231),
1358 (16, 232),
1359 (37, 232),
1360 (63, 232),
1361 (63, 233),
1362 (88, 233),
1363 (110, 233),
1364 (4, 234),
1365 (30, 234),
1366 (51, 234),
1367 (88, 234),
1368 (30, 235),
1369 (55, 235),
1370 (77, 235),
1371 (18, 236),
1372 (55, 236),
1373 (102, 236),
1374 (18, 237),
1375 (44, 237),
1376 (128, 237),
1377 (44, 238),
1378 (70, 238),
1379 (91, 238),
1380 (70, 239),
1381 (95, 239),
1382 (117, 239),
1383 (11, 240),
1384 (37, 240),
1385 (58, 240),
1386 (37, 241),
1387 (84, 241),
1388 (131, 241),
1389 (4, 242),
1390 (25, 242),
1391 (109, 242),
1392 (131, 242),
1393 (4, 243),
1394 (51, 243),
1395 (98, 243),
1396 (39, 244),
1397 (76, 244),
1398 (98, 244),
1399 (123, 244),
1400 (18, 245),
1401 (39, 245),
1402 (65, 245),
1403 (44, 246),
1404 (65, 246),
1405 (91, 246),
1406 (7, 247),
1407 (91, 247),
1408 (116, 247),
1409 (32, 248),
1410 (58, 248),
1411 (79, 248),
1412 (105, 248),
1413 (116, 248),
1414 (46, 249),
1415 (83, 249),
1416 (105, 249),
1417 (130, 249),
1418 (25, 250),
1419 (46, 250),
1420 (72, 250),
1421 (72, 251),
1422 (97, 251),
1423 (119, 251),
1424 (13, 252),
1425 (39, 252),
1426 (97, 252),
1427 (123, 252),
1428 (39, 253),
1429 (65, 253),
1430 (86, 253),
1431 (28, 254),
1432 (65, 254),
1433 (112, 254),
1434 (6, 255),
1435 (53, 255),
1436 (32, 256),
1437 (79, 256),
1438 (126, 256),
1439 (20, 257),
1440 (104, 257),
1441 (126, 257),
1442 (20, 258),
1443 (46, 258),
1444 (67, 258),
1445 (46, 259),
1446 (71, 259),
1447 (93, 259),
1448 (34, 260),
1449 (71, 260),
1450 (118, 260),
1451 (13, 261),
1452 (60, 261),
1453 (2, 262),
1454 (86, 262),
1455 (107, 262),
1456 (2, 263),
1457 (111, 263),
1458 (27, 264),
1459 (53, 264),
1460 (74, 264),
1461 (100, 264),
1462 (111, 264),
1463 (16, 265),
1464 (100, 265),
1465 (125, 265),
1466 (20, 266),
1467 (41, 266),
1468 (67, 266),
1469 (125, 266),
1470 (67, 267),
1471 (92, 267),
1472 (114, 267),
1473 (8, 268),
1474 (34, 268),
1475 (55, 268),
1476 (92, 268),
1477 (34, 269),
1478 (60, 269),
1479 (81, 269),
1480 (23, 270),
1481 (60, 270),
1482 (107, 270),
1483 (1, 271),
1484 (23, 271),
1485 (48, 271),
1486 (48, 272),
1487 (74, 272),
1488 (95, 272),
1489 (15, 273),
1490 (62, 273),
1491 (99, 273),
1492 (121, 273),
1493 (41, 274),
1494 (62, 274),
1495 (88, 274),
1496 (4, 275),
1497 (29, 275),
1498 (113, 275),
1499 (8, 276),
1500 (29, 276),
1501 (55, 276),
1502 (55, 277),
1503 (81, 277),
1504 (102, 277),
1505 (44, 278),
1506 (81, 278),
1507 (128, 278),
1508 (22, 279),
1509 (44, 279),
1510 (69, 279),
1511 (11, 280),
1512 (48, 280),
1513 (95, 280),
1514 (11, 281),
1515 (120, 281),
1516 (36, 282),
1517 (62, 282),
1518 (83, 282),
1519 (3, 283),
1520 (50, 283),
1521 (87, 283),
1522 (109, 283),
1523 (29, 284),
1524 (50, 284),
1525 (76, 284),
1526 (76, 285),
1527 (102, 285),
1528 (123, 285),
1529 (18, 286),
1530 (43, 286),
1531 (90, 286),
1532 (127, 286),
1533 (32, 287),
1534 (69, 287),
1535 (90, 287),
1536 (116, 287),
1537 (10, 288),
1538 (32, 288),
1539 (57, 288),
1540 (36, 289),
1541 (83, 289),
1542 (130, 289),
1543 (24, 290),
1544 (50, 290),
1545 (71, 290),
1546 (97, 290),
1547 (108, 290),
1548 (130, 290),
1549 (39, 291),
1550 (76, 291),
1551 (97, 291),
1552 (123, 291),
1553 (17, 292),
1554 (39, 292),
1555 (64, 292),
1556 (111, 292),
1557 (6, 293),
1558 (31, 293),
1559 (90, 293),
1560 (111, 293),
1561 (115, 293),
1562 (31, 294),
1563 (57, 294),
1564 (78, 294),
1565 (20, 295),
1566 (57, 295),
1567 (104, 295),
1568 (20, 296),
1569 (45, 296),
1570 (129, 296),
1571 (24, 297),
1572 (45, 297),
1573 (71, 297),
1574 (71, 298),
1575 (97, 298),
1576 (118, 298),
1577 (13, 299),
1578 (38, 299),
1579 (60, 299),
1580 (97, 299),
1581 (38, 300),
1582 (64, 300),
1583 (85, 300),
1584 (5, 301),
1585 (27, 301),
1586 (64, 301),
1587 (111, 301),
1588 (5, 302),
1589 (52, 302),
1590 (52, 303),
1591 (78, 303),
1592 (99, 303),
1593 (78, 304),
1594 (103, 304),
1595 (125, 304),
1596 (19, 305),
1597 (45, 305),
1598 (66, 305),
1599 (8, 306),
1600 (45, 306),
1601 (92, 306),
1602 (34, 307),
1603 (118, 307),
1604 (12, 308),
1605 (34, 308),
1606 (59, 308),
1607 (1, 309),
1608 (59, 309),
1609 (85, 309),
1610 (106, 309),
1611 (1, 310),
1612 (48, 310),
1613 (26, 311),
1614 (48, 311),
1615 (73, 311),
1616 (52, 312),
1617 (73, 312),
1618 (99, 312),
1619 (15, 313),
1620 (40, 313),
1621 (124, 313),
1622 (40, 314),
1623 (66, 314),
1624 (87, 314),
1625 (66, 315),
1626 (92, 315),
1627 (113, 315),
1628 (8, 316),
1629 (33, 316),
1630 (55, 316),
1631 (92, 316),
1632 (33, 317),
1633 (80, 317),
1634 (127, 317),
1635 (22, 318),
1636 (106, 318),
1637 (127, 318),
1638 (131, 318),
1639 (47, 319),
1640 (73, 319),
1641 (94, 319),
1642 (120, 319),
1643 (131, 319),
1644 (14, 320),
1645 (36, 320),
1646 (120, 320),
1647 (14, 321),
1648 (40, 321),
1649 (61, 321),
1650 (87, 321),
1651 (3, 322),
1652 (87, 322),
1653 (113, 322),
1654 (29, 323),
1655 (54, 323),
1656 (76, 323),
1657 (113, 323),
1658 (54, 324),
1659 (80, 324),
1660 (101, 324),
1661 (43, 325),
1662 (80, 325),
1663 (127, 325),
1664 (21, 326),
1665 (68, 326),
1666 (10, 327),
1667 (94, 327),
1668 (115, 327),
1669 (10, 328),
1670 (35, 328),
1671 (119, 328),
1672 (35, 329),
1673 (61, 329),
1674 (82, 329),
1675 (24, 330),
1676 (61, 330),
1677 (108, 330),
1678 (3, 331),
1679 (24, 331),
1680 (50, 331),
1681 (28, 332),
1682 (50, 332),
1683 (75, 332),
1684 (75, 333),
1685 (101, 333),
1686 (122, 333),
1687 (17, 334),
1688 (42, 334),
1689 (64, 334),
1690 (101, 334),
1691 (42, 335),
1692 (68, 335),
1693 (89, 335),
1694 (31, 336),
1695 (68, 336),
1696 (115, 336),
1697 (9, 337),
1698 (56, 337),
1699 (56, 338),
1700 (82, 338),
1701 (103, 338),
1702 (129, 338),
1703 (24, 339),
1704 (71, 339),
1705 (108, 339),
1706 (129, 339),
1707 (49, 340),
1708 (71, 340),
1709 (96, 340),
1710 (12, 341),
1711 (16, 341),
1712 (38, 341),
1713 (96, 341),
1714 (122, 341),
1715 (16, 342),
1716 (63, 342),
1717 (110, 342),
1718 (5, 343),
1719 (52, 343),
1720 (89, 343),
1721 (110, 343),
1722 (30, 344),
1723 (52, 344),
1724 (77, 344),
1725 (19, 345),
1726 (56, 345),
1727 (77, 345),
1728 (103, 345),
1729 (19, 346),
1730 (129, 346),
1731 (45, 347),
1732 (70, 347),
1733 (92, 347),
1734 (117, 347),
1735 (12, 348),
1736 (59, 348),
1737 (96, 348),
1738 (117, 348),
1739 (37, 349),
1740 (59, 349),
1741 (84, 349),
1742 (26, 350),
1743 (110, 350),
1744 (131, 350),
1745 (4, 351),
1746 (51, 351),
1747 (98, 351),
1748 (40, 352),
1749 (77, 352),
1750 (98, 352),
1751 (124, 352),
1752 (19, 353),
1753 (40, 353),
1754 (66, 353),
1755 (7, 354),
1756 (44, 354),
1757 (66, 354),
1758 (91, 354),
1759 (7, 355),
1760 (33, 355),
1761 (117, 355),
1762 (33, 356),
1763 (58, 356),
1764 (80, 356),
1765 (58, 357),
1766 (84, 357),
1767 (105, 357),
1768 (25, 358),
1769 (47, 358),
1770 (131, 358);
1771 /*!40000 ALTER TABLE `parts_cars` ENABLE KEYS */;
1772
1773
1774 DROP TABLE IF EXISTS `sales`;
1775 CREATE TABLE IF NOT EXISTS `sales` (
1776 `id` bigint(20) NOT NULL,
1777 `discount` double DEFAULT NULL,
1778 `car_id` bigint(20) DEFAULT NULL,
1779 `customer_id` bigint(20) DEFAULT NULL,
1780 PRIMARY KEY (`id`),
1781 KEY `FK_sales_cars` (`car_id`),
1782 KEY `FK_sales_customers` (`customer_id`),
1783 CONSTRAINT `FK_sales_cars` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`),
1784 CONSTRAINT `FK_sales_customers` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`)
1785 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1786
1787
1788 /*!40000 ALTER TABLE `sales` DISABLE KEYS */;
1789 INSERT INTO `sales` (`id`, `discount`, `car_id`, `customer_id`) VALUES
1790 (1, 0.3, 280, 28),
1791 (2, 0.2, 80, 16),
1792 (3, 0.4, 356, 29),
1793 (4, 0.4, 316, 11),
1794 (5, 0.2, 105, 18),
1795 (6, 0.4, 322, 11),
1796 (7, 0.05, 111, 8),
1797 (8, 0.3, 259, 20),
1798 (9, 0.4, 347, 28),
1799 (10, 0.05, 136, 10),
1800 (11, 0, 283, 23),
1801 (12, 0.2, 244, 5),
1802 (13, 0.1, 161, 12),
1803 (14, 0.05, 121, 25),
1804 (15, 0.3, 269, 7),
1805 (16, 0.4, 58, 4),
1806 (17, 0.05, 146, 27),
1807 (18, 0.3, 294, 23),
1808 (19, 0, 83, 6),
1809 (20, 0.5, 230, 18),
1810 (21, 0.4, 190, 30),
1811 (22, 0.05, 108, 8),
1812 (23, 0, 68, 20),
1813 (24, 0.4, 215, 2),
1814 (25, 0.5, 133, 10),
1815 (26, 0.05, 152, 11),
1816 (27, 0.05, 112, 24),
1817 (28, 0.3, 259, 6),
1818 (29, 0.5, 48, 3),
1819 (30, 0.1, 195, 15),
1820 (31, 0.1, 155, 27),
1821 (32, 0, 303, 10),
1822 (33, 0.5, 220, 17),
1823 (34, 0.1, 180, 30),
1824 (35, 0.4, 328, 26),
1825 (36, 0.05, 117, 9),
1826 (37, 0.2, 205, 2),
1827 (38, 0.4, 353, 28),
1828 (39, 0.05, 142, 11),
1829 (40, 0.2, 102, 18),
1830 (41, 0.4, 20, 30),
1831 (42, 0.05, 108, 24),
1832 (43, 0.1, 255, 1),
1833 (44, 0.5, 344, 13),
1834 (45, 0.05, 133, 10),
1835 (46, 0.3, 280, 22),
1836 (47, 0.2, 70, 5),
1837 (48, 0.1, 30, 12),
1838 (49, 0.3, 305, 24),
1839 (50, 0.3, 266, 7);
1840 /*!40000 ALTER TABLE `sales` ENABLE KEYS */;
1841
1842
1843 DROP TABLE IF EXISTS `suppliers`;
1844 CREATE TABLE IF NOT EXISTS `suppliers` (
1845 `id` bigint(20) NOT NULL,
1846 `name` varchar(255) NOT NULL,
1847 `isImporter` bit(1) NOT NULL,
1848 PRIMARY KEY (`id`)
1849 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1850
1851
1852 /*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
1853 INSERT INTO `suppliers` (`id`, `name`, `isImporter`) VALUES
1854 (1, '3M Company', b'1'),
1855 (2, 'Agway Inc.', b'0'),
1856 (3, 'Anthem, Inc.', b'1'),
1857 (4, 'Airgas, Inc.', b'0'),
1858 (5, 'Atmel Corporation', b'1'),
1859 (6, 'Big Lots, Inc.', b'1'),
1860 (7, 'Caterpillar Inc.', b'0'),
1861 (8, 'Casey\'s General Stores Inc.', b'1'),
1862 (9, 'Cintas Corp.', b'0'),
1863 (10, 'Chubb Corp', b'1'),
1864 (11, 'Cintas Corp.', b'0'),
1865 (12, 'CNF Inc.', b'1'),
1866 (13, 'CMGI Inc.', b'1'),
1867 (14, 'The Clorox Co.', b'0'),
1868 (15, 'Danaher Corporation', b'1'),
1869 (16, 'E.I. Du Pont de Nemours and Company', b'0'),
1870 (17, 'E*Trade Group, Inc.', b'1'),
1871 (18, 'Emcor Group Inc.', b'1'),
1872 (19, 'GenCorp Inc.', b'0'),
1873 (20, 'IDT Corporation', b'1'),
1874 (21, 'Level 3 Communications Inc.', b'0'),
1875 (22, 'Merck & Co., Inc.', b'1'),
1876 (23, 'Nicor Inc', b'0'),
1877 (24, 'Olin Corp.', b'1'),
1878 (25, 'Paychex Inc', b'1'),
1879 (26, 'Saks Inc', b'0'),
1880 (27, 'Sunoco Inc.', b'1'),
1881 (28, 'Textron Inc', b'1'),
1882 (29, 'VF Corporation', b'0'),
1883 (30, 'Wyeth', b'1'),
1884 (31, 'Zale', b'0');
1885 /*!40000 ALTER TABLE `suppliers` ENABLE KEYS */;
1886
1887 /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
1888 /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
1889 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;