· 6 years ago · Apr 06, 2019, 12:12 PM
1-- --------------------------------------------------------
2
3--
4-- Table structure for table `vehicles`
5--
6
7CREATE TABLE IF NOT EXISTS `vehicles` (
8 `name` varchar(60) NOT NULL,
9 `model` varchar(60) NOT NULL,
10 `price` int(11) NOT NULL,
11 `category` varchar(60) DEFAULT NULL
12) ENGINE=InnoDB DEFAULT CHARSET=latin1;
13
14--
15-- Dumping data for table `vehicles`
16--
17
18INSERT INTO `vehicles` (`name`, `model`, `price`, `category`) VALUES
19('Dodge Charger', '16charger', 369000, 'muscle'),
20('Pontiac Trans AM', '2018transam', 335000, 'muscle'),
21('Dinka Akuma', 'akuma', 50420, 'motors'),
22('Declasse Asea', 'asea', 27531, 'sedan'),
23('Aston Martin Vanquish', 'ast', 3255000, 'supersport'),
24('Karin Asterope', 'asterope', 36410, 'sedan'),
25('LCC Avarus', 'avarus', 23620, 'choppers'),
26('Western Bagger', 'bagger', 19026, 'motors'),
27('Gallivanter Baller', 'baller2', 118298, 'suv'),
28('Gallivanter Baller Sport', 'baller3', 126578, 'suv'),
29('Bravado Banshee 900R', 'banshee2', 785000, 'supersport'),
30('Pegassi Bati 801', 'bati', 61902, 'motors'),
31('Pegassi Bati 801RR', 'bati2', 72200, 'motors'),
32('Grotti Bestia GTS', 'bestiagts', 59398, 'sport'),
33('Nagasaki FB400', 'bf400', 30188, 'motors'),
34('BF Injection', 'bfinjection', 51200, 'offroad'),
35('BF Bifta', 'bifta', 64000, 'offroad'),
36('Bravado Bison', 'bison', 42937, 'van'),
37('Bravado Bison Ranch', 'bison2', 41649, 'van'),
38('Karin BeeJay XL', 'bjxl', 45878, 'suv'),
39('Vapid Blade', 'blade', 58354, 'muscle'),
40('Nagasaki Blazer', 'blazer', 5498, 'offroad'),
41('Nagasaki Blazer Hot Rod', 'blazer3', 4398, 'offroad'),
42('Nagasaki Street Blazer', 'blazer4', 26214, 'offroad'),
43('Dinka Blista', 'blista', 38585, 'compact'),
44('Bentley Mulsanne Mulliner', 'bmm', 4150000, 'luxary'),
45('Bmx', 'bmx', 275, 'rower'),
46('Vapid Bobcat XL', 'bobcatxl', 32642, 'van'),
47('Coil Brawler', 'brawler', 80000, 'offroad'),
48('Grotti Brioso R/A', 'brioso', 31888, 'compact'),
49('Ford Bronco', 'bronco', 40072, 'suv'),
50('Albany Fränken Stange', 'btype2', 27469, 'sportcalssic'),
51('Albany Roosevelt', 'btype3', 13217, 'sportcalssic'),
52('Albany Buccaneer', 'buccaneer', 64100, 'muscle'),
53('Albany Buccaneer Custom', 'buccaneer2', 67400, 'muscle'),
54('Bravado Buffalo Soprt', 'buffalo2', 46540, 'sport'),
55('Vapid Bullet', 'bullet', 1015000, 'supersport'),
56('Declasse Burrito', 'burrito3', 36871, 'van'),
57('AMG c63', 'c63coupe', 3423000, 'supersport'),
58('Brute Camper', 'camper', 28898, 'van'),
59('Grotti', 'carbonizzare', 79599, 'sport'),
60('Nagasaki Carbon RS', 'carbonrs', 39014, 'motors'),
61('Lampadati Casco', 'casco', 136500, 'sportcalssic'),
62('Albany Cavalcade', 'cavalcade2', 64346, 'suv'),
63('Rune Cheburek', 'cheburek', 24996, 'sportcalssic'),
64('Gritti Cheetah', 'cheetah', 1100000, 'supersport'),
65('Grotti Cheetah Classic', 'cheetah2', 124215, 'sportcalssic'),
66('Nagasaki Chimera', 'chimera', 12552, 'choppers'),
67('Vapid Chino', 'chino', 40489, 'muscle'),
68('Vapid Chino Custom', 'chino2', 43032, 'muscle'),
69('Westerm Cliffhanger', 'cliffhanger', 58807, 'motors'),
70('AMG CLS63', 'cls2015', 3567000, 'supersport'),
71('Enus Cognoscenti S', 'cog55', 2150000, 'luxary'),
72('Enus Cognoscenti', 'cognoscenti', 2350000, 'luxary'),
73('Pfister Comet', 'comet2', 129658, 'sport'),
74('Pfister Comet RC', 'comet3', 165480, 'sport'),
75('Vapid Contender', 'contender', 96566, 'suv'),
76('Invetero Coquette', 'coquette', 150096, 'sport'),
77('Invetero Coquette Clasic', 'coquette2', 85180, 'sportcalssic'),
78('Invetero Coquette BlackFin', 'coquette3', 61500, 'muscle'),
79('Cruiser', 'cruiser', 175, 'rower'),
80('Western Daemon Classic', 'daemon', 19132, 'choppers'),
81('Western Daemon', 'daemon2', 21258, 'choppers'),
82('Shitzu Defiler', 'defiler', 55867, 'motors'),
83('Principe Diablous', 'diablous', 41067, 'motors'),
84('Principe Diablous Custom', 'diablous2', 45504, 'motors'),
85('Karin Dilettante', 'dilettante', 18000, 'compact'),
86('Bravado Duneloader', 'dloader', 3518, 'offroad'),
87('Vapid Dominator', 'dominator', 143500, 'muscle'),
88('Vapid Dominator GTX', 'dominator3', 226000, 'muscle'),
89('Dinka Doubble-T', 'double', 45504, 'motors'),
90('Citroën DS4', 'ds4', 19800, 'compact'),
91('Benefactor Dubsta', 'dubsta', 165919, 'suv'),
92('Benefactor Dubsta Luxary', 'dubsta2', 170000, 'suv'),
93('Benefactor Dubsta 6x6', 'dubsta3', 16777, 'offroad'),
94('Imponte Dukes', 'dukes', 100000, 'muscle'),
95('BF Dune Buggy', 'dune', 20972, 'offroad'),
96('Honda Civic R', 'ek9', 56492, 'compact'),
97('Annis Elegy RH8', 'elegy2', 92146, 'sport'),
98('Vapid Ellie', 'ellie', 185000, 'muscle'),
99('Albany Emperor', 'emperor', 13688, 'sedan'),
100('Dinka Enduro', 'enduro', 22191, 'motors'),
101('Överflöd Entity XF', 'entityxf', 1241000, 'supersport'),
102('Pagassi Esskey', 'esskey', 25883, 'motors'),
103('Dewbauchee Exemplar', 'Exemplar', 70000, 'coupe'),
104('Ocelot F620', 'f620', 63000, 'coupe'),
105('BMW M4F82', 'f824slw', 2650000, 'supersport'),
106('Willard Faction', 'faction', 87000, 'muscle'),
107('Willard Faction Custom', 'faction2', 83590, 'muscle'),
108('Willard Faction XL', 'faction3', 39274, 'muscle'),
109('Vulcar Fagaloa', 'fagaloa', 8528, 'sportcalssic'),
110('Pegassio Faggio Sport', 'faggio', 10000, 'skuter'),
111('Pegassi Faggio', 'faggio2', 6000, 'skuter'),
112('Pegassio Faggio Custom', 'faggio3', 7500, 'skuter'),
113('Pegassi FCR1000', 'fcr', 33450, 'motors'),
114('Pegassi FCR1000 Custom', 'fcr2', 37063, 'motors'),
115('Ferrari California', 'fct', 3659000, 'supersport'),
116('Lampadati Felon', 'felon', 37201, 'coupe'),
117('Lampadati Felon GT', 'felon2', 39133, 'coupe'),
118('Benefactor Feltzer', 'feltzer2', 101591, 'sport'),
119('Benefactor Feltzer Classic', 'feltzer3', 44018, 'sportcalssic'),
120('Fixter', 'fixter', 325, 'rower'),
121('Ford Mustang GT', 'fmgt', 435000, 'muscle'),
122('Vapid FMJ', 'fmj', 1315000, 'supersport'),
123('Fathom FQ2', 'fq2', 78827, 'suv'),
124('Cheval Fugitive', 'fugitive', 63681, 'sedan'),
125('Lampadati Furore GT', 'furoregt', 173754, 'sport'),
126('Schyster Fusilade', 'fusilade', 87758, 'sport'),
127('Karin Futo', 'futo', 191564, 'sport'),
128('AMG 65 G Class', 'g65amg', 2000000, 'luxary'),
129('Western Gargoyle', 'gargoyle', 47899, 'motors'),
130('Bravado Gauntlet', 'gauntlet', 90500, 'muscle'),
131('Vapid GB200', 'gb200', 201143, 'sport'),
132('Declasse Gang Burrito', 'gburitto2', 48500, 'van'),
133('Benefactor Glendale', 'glendale', 55375, 'sedan'),
134('GMC YUKON XL', 'gmcyd', 215000, 'suv'),
135('Volksvagen Golf GTI', 'golfgti', 51356, 'compact'),
136('Declasse Granger', 'granger', 42877, 'suv'),
137('Bravado Gresley', 'gresley', 60137, 'suv'),
138('Grotti GT500', 'gt500', 40056, 'sportcalssic'),
139('Ferrari 599 GTB', 'gtoxx', 4000000, 'supersport'),
140('Vapid Guardian', 'Guardian', 32768, 'offroad'),
141('Emperor Habanero', 'habanero', 73670, 'suv'),
142('Shitzu Hakuchou', 'hakuchou', 76000, 'motors'),
143('Shitzu Hakuchou Drag', 'hakuchou2', 80000, 'motors'),
144('Albany Hermes', 'hermes', 51660, 'muscle'),
145('LCC Hexer', 'hexer', 17219, 'choppers'),
146('Enus Huntley S', 'huntley', 110559, 'suv'),
147('Vapid Hustler', 'hustler', 60159, 'muscle'),
148('Pegassi Infernus', 'infernus', 1555000, 'supersport'),
149('Pagassi Infernus Classic', 'infernus2', 64189, 'sportcalssic'),
150('Vulcan Ingot', 'ingot', 13688, 'sedan'),
151('LCC Innovation', 'innovation', 32400, 'choppers'),
152('Karin Intruder', 'intruder', 48152, 'sedan'),
153('Wenny Issi', 'issi2', 35077, 'compact'),
154('Wenny Issi Classic', 'issi3', 21780, 'compact'),
155('Itali GTB', 'italigtb', 2325000, 'supersport'),
156('Ocelot Jackal', 'Jackal', 41334, 'coupe'),
157('Zirconium Journey', 'journey', 29791, 'van'),
158('Canis Kalahari', 'kalahari', 6872, 'offroad'),
159('Hijak Khamelion', 'khamelion', 42213, 'sport'),
160('Dundreary Landstalker', 'landstalker', 52526, 'suv'),
161('Principe Lectro', 'lectro', 24589, 'motors'),
162('Daewoo Leganza', 'leganza', 42443, 'compact'),
163('Ocelot Lynx', 'lynx', 221760, 'sport'),
164('BMW M5E60', 'm5e60', 2899000, 'supersport'),
165('Declasse Mamba', 'mamba', 77514, 'sportcalssic'),
166('Albany Manana', 'manana', 11755, 'sportcalssic'),
167('Maibatsu Manche', 'manchez', 28679, 'motors'),
168('Dewbauchee Massacro', 'massacro', 142948, 'sport'),
169('Mercedes 300SL', 'mb300sl', 225000, 'sportcalssic'),
170('Canis Mesa', 'mesa', 35000, 'suv'),
171('Canis Mesa Trail', 'mesa2', 37450, 'suv'),
172('Lampadati Michelli GT', 'michelli', 22747, 'sportcalssic'),
173('Vapid Minivan', 'minivan', 33651, 'van'),
174('Vapid Minivan Custom', 'minivan2', 34692, 'van'),
175('Pegassi Monroe', 'monroe', 102862, 'sportcalssic'),
176('Declasse Moonbeam', 'moonbeam', 50000, 'van'),
177('Declasse Moonbeam Custom', 'moonbeam2', 53258, 'muscle'),
178('Principe Nemesis', 'nemesis', 31777, 'motors'),
179('Pfister Neon', 'neon', 2500000, 'electric'),
180('Nero', 'nero', 2599000, 'supersport'),
181('Imponte Nightshade', 'nightshade', 48607, 'muscle'),
182('Western Nightblade', 'nigthblade', 40000, 'choppers'),
183('Obey 9F', 'ninef', 83579, 'sport'),
184('Obey 9F Cabrio', 'ninef2', 75809, 'sport'),
185('Obey Omnis', 'Omnis', 42213, 'sportcalssic'),
186('Übermacht Oracle', 'oracle2', 45927, 'coupe'),
187('Pagassi Osiris', 'osiris', 915000, 'supersport'),
188('Benefactor Panto', 'panto', 23958, 'compact'),
189('Bravado Pradise', 'paradise', 45634, 'van'),
190('Ocelot Pariah', 'pariah', 211200, 'sport'),
191('Mammoth Patriot', 'patriot', 56202, 'suv'),
192('Shitzu PCJ600', 'pcj', 21082, 'motors'),
193('Ocelot Penetrator', 'penetrator', 1715000, 'supersport'),
194('Vapid Peyote', 'peyote', 10217, 'sportcalssic'),
195('Pfister 811', 'pfister811', 1425000, 'supersport'),
196('Imponte Phoenix', 'phoenix', 95600, 'muscle'),
197('Lampadati Pigalle', 'pigalle', 93605, 'sportcalssic'),
198('Brute Pony Classic', 'pony', 39187, 'van'),
199('Brute Pony', 'pony2', 40399, 'van'),
200('Bollokan Prairie', 'prairie', 26354, 'compact'),
201('Declasse Premier', 'premier', 15741, 'sedan'),
202('Albany Primo', 'primo', 18102, 'sedan'),
203('Albany Primo Custom', 'primo2', 31661, 'sedan'),
204('Vapid Radius', 'radi', 68850, 'suv'),
205('Coil Raiden', 'raiden', 2250000, 'electric'),
206('Dewbauchee Rapid GT', 'rapidgt', 117604, 'sport'),
207('Dewbauchee Rapid GT Sport', 'rapidgt2', 123484, 'sport'),
208('Dewbauchee Rapid GT Classic', 'rapidgt3', 53155, 'sportcalssic'),
209('Western Rat Bike', 'ratbike', 15497, 'choppers'),
210('Bravado Rat-Truck', 'ratloader2', 45735, 'muscle'),
211('Pegassi Reaper', 'reaper', 2000000, 'supersport'),
212('Karin Rebel', 'rebel2', 13422, 'offroad'),
213('Dundreary Regina', 'regina', 10350, 'sedan'),
214('Vapid Retinue', 'retinue', 14837, 'sportcalssic'),
215('Übermacht Revolter', 'revolter', 2790000, 'luxary'),
216('Declasse Rhapsody', 'rhapsody', 28989, 'compact'),
217('Vapid Riata', 'riata', 40960, 'offroad'),
218('Obey Rocoto', 'rocoto', 90249, 'suv'),
219('Pegassi Ruffian', 'ruffian', 35210, 'motors'),
220('Imponte Ruiner', 'ruiner', 121500, 'muscle'),
221('Bravado Rumpo', 'rumpo', 35765, 'van'),
222('Bravado Rumpo', 'rumpo2', 44265, 'van'),
223('Hijak Ruston', 'ruston', 48867, 'sport'),
224('Declasse Sabre GT', 'sabregt', 74590, 'muscle'),
225('Declasse Sabre GT Turbo', 'sabregt2', 78590, 'muscle'),
226('Maibatsu Sanchez', 'sanchez2', 20028, 'motors'),
227('LCC Sanctus', 'sanctus', 36000, 'choppers'),
228('Vapid Sandking XL', 'sandking', 10737, 'offroad'),
229('Vapid Sandking SWB', 'sandking2', 8590, 'offroad'),
230('Annis Savestra', 'savestra', 18837, 'sportcalssic'),
231('SC1', 'sc1', 2500500, 'supersport'),
232('Benefactor Schafter', 'schafter2', 41872, 'sedan'),
233('Benefactor Schafter v12', 'schafter3', 182442, 'sport'),
234('Benefactor Schwartzer', 'schwartzer', 65486, 'sport'),
235('Scorcher', 'scorcher', 365, 'rower'),
236('Canis Seminole', 'seminole', 49089, 'suv'),
237('Übermacht Sentinel XS', 'sentinel', 33481, 'coupe'),
238('Übermacht Sentinel', 'sentinel2', 30133, 'coupe'),
239('Benefactor Serrano', 'serrano', 84345, 'suv'),
240('Dewbauchee Seven 70', 'seven70', 165480, 'sport'),
241('Emperor ETR', 'sheava', 800000, 'supersport'),
242('Vapid Slamvan Custom', 'slamvan3', 47149, 'muscle'),
243('Western Sovereign', 'Sovereign', 27245, 'motors'),
244('Dewbauchee Specter', 'specter', 72199, 'sport'),
245('Dewbauchee Specter Custom', 'specter2', 96753, 'sport'),
246('Vapid Speedo', 'speedo', 47045, 'van'),
247('Declasse Stallion', 'stalion', 62019, 'muscle'),
248('Vapid Stanier', 'stanier', 84219, 'sedan'),
249('Grotti Stinger', 'stinger', 33171, 'sportcalssic'),
250('Zirconium Stratum', 'stratum', 73234, 'sedan'),
251('Dundreary Stretch', 'stretch', 3000000, 'luxary'),
252('Karin Sultan', 'sultan', 111379, 'sedan'),
253('Karin SultanRS', 'sultanrs', 2067000, 'supersport'),
254('Enus Super Diamond', 'superd', 3750000, 'luxary'),
255('Benefactor Surano', 'surano', 136141, 'sport'),
256('BF Surfer', 'surfer', 28031, 'van'),
257('Cheval Surge', 'surge', 9000, 'sedan'),
258('Range Rover SVR', 'svr2014', 195000, 'suv'),
259('T20', 't20', 2455000, 'supersport'),
260('Chevrolet Tahoe', 'tahoe', 175000, 'suv'),
261('Obey Tailgater', 'tailgater', 23940, 'sedan'),
262('Cheval Taipan', 'taipan', 1605000, 'supersport'),
263('Declasse Tampa', 'tampa', 56603, 'muscle'),
264('Pagassi Tempesta', 'tempesta', 835000, 'supersport'),
265('Tesla Model X', 'teslax', 3000000, 'electric'),
266('Dinka Thrust', 'thrust', 68590, 'motors'),
267('Pagassi Torero', 'torero', 58412, 'sportcalssic'),
268('Declasse Tornado', 'tornado', 9734, 'sportcalssic'),
269('Tesla Model S', 'tr22', 2700000, 'electric'),
270('Whipped Race Bike', 'tribike', 395, 'rower'),
271('Endurex Race Bike', 'tribike2', 385, 'rower'),
272('Tri-Cycles Race Bike', 'tribike3', 375, 'rower'),
273('Lampadati Tropos', 'tropos', 31500, 'sport'),
274('Grotti Turismo Classic', 'turismo2', 70538, 'sportcalssic'),
275('Grotti Turismo R', 'turismor', 2230000, 'supersport'),
276('Överflöd Tyrant', 'tyrant', 1835000, 'supersport'),
277('Progen Tyrus', 'tyrus', 1121000, 'supersport'),
278('Shitzu Vader', 'vader', 24589, 'motors'),
279('Dewbauchee Vagner', 'vagner', 1985000, 'supersport'),
280('Declasse Vigero', 'Vigero', 70000, 'muscle'),
281('Dinka Vindicator', 'vindicator', 65161, 'motors'),
282('STR Viper ACR', 'viper', 2957000, 'supersport'),
283('Dundreary Virgo Custom', 'virgo2', 41741, 'muscle'),
284('Lampadati Viseris', 'viseris', 48371, 'sportcalssic'),
285('Grotti Visione', 'visione', 2300000, 'supersport'),
286('Declasse Voodoo Custom', 'voodoo', 45735, 'muscle'),
287('Pagassi Vortex', 'vortex', 53074, 'motors'),
288('Aston Martin Vulcan', 'vulcan', 3145000, 'supersport'),
289('Vulcan Warrener', 'warrener', 20818, 'sedan'),
290('Albany Washington', 'washington', 96851, 'sedan'),
291('Enus Windsor', 'windsor', 3350000, 'luxary'),
292('Enus Windsor Drop', 'windsor2', 3450000, 'luxary'),
293('Western Wolfsbane', 'wolfsbane', 13947, 'choppers'),
294('Rolls-Royce Wraith', 'wraith', 4300000, 'luxary'),
295('Ocelot XA-21', 'xa21', 986000, 'supersport'),
296('Benefactor XLS', 'xls', 103326, 'suv'),
297('Declasse Yosemite', 'yosemite', 54905, 'muscle'),
298('Bravado Youga', 'youga', 30713, 'van'),
299('Bravado Youga Classic', 'youga2', 31663, 'van'),
300('Karin 190z', 'z190', 20700, 'sportcalssic'),
301('Übermacht Zion', 'zion', 51030, 'coupe'),
302('Übermacht Zion Cabrio', 'zion2', 56700, 'coupe'),
303('Western Zombie Bobber', 'zombiea', 29160, 'choppers'),
304('Western Zombie Chopper', 'zombieb', 23620, 'choppers'),
305('Tullade Z-Type', 'ztype', 150000, 'sportcalssic');
306
307-- --------------------------------------------------------
308
309--
310-- Table structure for table `vehicle_categories`
311--
312
313CREATE TABLE IF NOT EXISTS `vehicle_categories` (
314`id` int(11) NOT NULL,
315 `name` varchar(60) NOT NULL,
316 `label` varchar(60) NOT NULL
317) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4;
318
319--
320-- Dumping data for table `vehicle_categories`
321--
322
323INSERT INTO `vehicle_categories` (`id`, `name`, `label`) VALUES
324(1, 'supersport', 'SuperSport'),
325(2, 'luxary', 'Luksusowe'),
326(3, 'sport', 'Sportowe'),
327(4, 'electric', 'Elektryczne'),
328(5, 'sportcalssic', 'Klasyki Sportowe'),
329(6, 'muscle', 'Muscle Car'),
330(7, 'offroad', 'Terenowe'),
331(8, 'suv', 'Suv'),
332(9, 'van', 'Van'),
333(10, 'coupe', 'Coupe'),
334(11, 'sedan', 'Sedany'),
335(12, 'compact', 'Kompaty'),
336(13, 'motors', 'Motocykle'),
337(14, 'choppers', 'Choppery'),
338(15, 'skuter', 'Skutery'),
339(16, 'rower', 'Rowery');