API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 5th, 2017
329
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 49.01 KB | None | 0 0
raw download clone embed print report
  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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!