· 6 years ago · Apr 02, 2019, 07:24 PM
1-- --------------------------------------------------------
2-- Värd: 127.0.0.1
3-- Serverversion: 10.1.38-MariaDB - mariadb.org binary distribution
4-- Server-OS: Win32
5-- HeidiSQL Version: 10.1.0.5464
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-- Dumpar databasstruktur för essentialmode
16CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */;
17USE `essentialmode`;
18
19-- Dumpar struktur för tabell essentialmode.vehicles
20CREATE TABLE IF NOT EXISTS `vehicles` (
21 `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
22 `model` varchar(60) COLLATE utf8mb4_bin NOT NULL,
23 `price` int(11) NOT NULL,
24 `category` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
25 PRIMARY KEY (`model`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
27
28-- Dumpar data för tabell essentialmode.vehicles: ~192 rows (ungefär)
29/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
30INSERT INTO `vehicles` (`name`, `model`, `price`, `category`) VALUES
31 ('BMW M5 Touring', '16m5', 84000, 'addons'),
32 ('BMW 760I', '17m760i', 535000, 'addons'),
33 ('Nissan 370Z', '370z', 68500, 'addons'),
34 ('McLaren 675 LT', '675lt', 600000, 'addons'),
35 ('Akuma', 'AKUMA', 7500, 'motorcycles'),
36 ('Audi a6', 'a6tfsi', 320000, 'addons'),
37 ('Adder', 'adder', 500000, 'super'),
38 ('VW Amarok V6', 'amarok', 77000, 'addons'),
39 ('Rs6', 'audirs6tk', 455000, 'addons'),
40 ('Autarch', 'autarch', 750000, 'super'),
41 ('Avarus', 'avarus', 18000, 'motorcycles'),
42 ('Bagger', 'bagger', 13500, 'motorcycles'),
43 ('Baller', 'baller2', 40000, 'suvs'),
44 ('Baller Sport', 'baller3', 60000, 'suvs'),
45 ('Banshee', 'banshee', 70000, 'sports'),
46 ('Banshee 900R', 'banshee2', 300000, 'super'),
47 ('Bati 801', 'bati', 28000, 'motorcycles'),
48 ('Bati 801RR', 'bati2', 32000, 'motorcycles'),
49 ('Bugatti Divo', 'bdivo', 1200000, 'addons'),
50 ('Bentley Bentayga', 'bentaygast', 275000, 'addons'),
51 ('Bestia GTS', 'bestiagts', 55000, 'sports'),
52 ('BF400', 'bf400', 16500, 'motorcycles'),
53 ('Bf Injection', 'bfinjection', 22000, 'offroad'),
54 ('Bifta', 'bifta', 12000, 'offroad'),
55 ('Bobcat XL', 'bobcatxl', 32000, 'vans'),
56 ('Brawler', 'brawler', 45000, 'offroad'),
57 ('Brioso R/A', 'brioso', 20000, 'compacts'),
58 ('Btype', 'btype', 62000, 'sportsclassics'),
59 ('Btype Hotroad', 'btype2', 155000, 'sportsclassics'),
60 ('Btype Luxe', 'btype3', 85000, 'sportsclassics'),
61 ('Buccaneer', 'buccaneer', 22000, 'muscle'),
62 ('Buccaneer Rider', 'buccaneer2', 36000, 'muscle'),
63 ('Buffalo S', 'buffalo2', 20000, 'sports'),
64 ('Carbonizzare', 'carbonizzare', 75000, 'sports'),
65 ('Carbon RS', 'carbonrs', 20000, 'motorcycles'),
66 ('Casco', 'casco', 30000, 'sportsclassics'),
67 ('Cavalcade', 'cavalcade2', 55000, 'suvs'),
68 ('Cheetah', 'cheetah', 400000, 'super'),
69 ('Chimera', 'chimera', 38000, 'motorcycles'),
70 ('Chino Luxe', 'chino2', 34000, 'muscle'),
71 ('Cliffhanger', 'cliffhanger', 11000, 'motorcycles'),
72 ('AMG CLS 6.3', 'cls63', 342000, 'addons'),
73 ('Cognoscenti Cabrio', 'cogcabrio', 55000, 'coupes'),
74 ('Comet', 'comet2', 65000, 'sports'),
75 ('Comet 5', 'comet5', 270000, 'sports'),
76 ('Contender', 'contender', 70000, 'suvs'),
77 ('Coquette', 'coquette', 65000, 'sports'),
78 ('Coquette Classic', 'coquette2', 40000, 'sportsclassics'),
79 ('Coquette BlackFin', 'coquette3', 55000, 'muscle'),
80 ('Cyclone', 'cyclone', 1000000, 'super'),
81 ('Daemon', 'daemon', 11500, 'motorcycles'),
82 ('Daemon High', 'daemon2', 13500, 'motorcycles'),
83 ('Dubsta', 'dubsta', 45000, 'suvs'),
84 ('Dubsta Luxuary', 'dubsta2', 60000, 'suvs'),
85 ('BMW E92', 'e92r', 315000, 'addons'),
86 ('Elegy', 'elegy2', 55000, 'sports'),
87 ('Enduro', 'enduro', 5500, 'motorcycles'),
88 ('Entity XF', 'entityxf', 425000, 'super'),
89 ('Esskey', 'esskey', 4200, 'motorcycles'),
90 ('Mitsubishi Evo 10', 'evo10', 78500, 'addons'),
91 ('Range Rover', 'evoque', 175000, 'addons'),
92 ('Exemplar', 'exemplar', 38500, 'coupes'),
93 ('BMW M4 (F82)', 'f82', 325000, 'addons'),
94 ('Faction Rider', 'faction2', 30000, 'muscle'),
95 ('Faction XL', 'faction3', 40000, 'muscle'),
96 ('Vespa', 'faggio2', 2800, 'motorcycles'),
97 ('Feltzer', 'feltzer2', 55000, 'sports'),
98 ('Stirling GT', 'feltzer3', 65000, 'sportsclassics'),
99 ('FMJ', 'fmj', 185000, 'super'),
100 ('Fhantom', 'fq2', 17000, 'suvs'),
101 ('Fugitive', 'fugitive', 45000, 'sedans'),
102 ('Fusilade', 'fusilade', 40000, 'sports'),
103 ('Wagon G65', 'g65amg', 465000, 'addons'),
104 ('Gargoyle', 'gargoyle', 19500, 'motorcycles'),
105 ('Gang Burrito', 'gburrito', 45000, 'vans'),
106 ('Glendale', 'glendale', 24800, 'sedans'),
107 ('VW Golf', 'golf4', 15500, 'addons'),
108 ('Grabger', 'granger', 50000, 'suvs'),
109 ('Gresley', 'gresley', 47500, 'suvs'),
110 ('GT 500', 'gt500', 90000, 'sportsclassics'),
111 ('Guardian', 'guardian', 65000, 'offroad'),
112 ('Hakuchou', 'hakuchou', 45000, 'motorcycles'),
113 ('Hakuchou Sport', 'hakuchou2', 80000, 'motorcycles'),
114 ('Hermes', 'hermes', 70000, 'muscle'),
115 ('Hexer', 'hexer', 12000, 'motorcycles'),
116 ('Hotknife', 'hotknife', 125000, 'muscle'),
117 ('Huntley S', 'huntley', 40000, 'suvs'),
118 ('BMW I8', 'i8', 1100000, 'addons'),
119 ('Infernus', 'infernus', 150000, 'super'),
120 ('Innovation', 'innovation', 23500, 'motorcycles'),
121 ('Intruder', 'intruder', 27000, 'sedans'),
122 ('Jackal', 'jackal', 38000, 'coupes'),
123 ('Jester', 'jester', 65000, 'sports'),
124 ('Jester(Racecar)', 'jester2', 80000, 'sports'),
125 ('Journey', 'journey', 20000, 'vans'),
126 ('Kamacho', 'kamacho', 80000, 'offroad'),
127 ('Khamelion', 'khamelion', 38000, 'sports'),
128 ('Kuruma', 'kuruma', 30000, 'sports'),
129 ('Landstalker', 'landstalker', 35000, 'suvs'),
130 ('RE-7B', 'le7b', 325000, 'super'),
131 ('Lexus LX570', 'lx2018', 405000, 'addons'),
132 ('Lynx', 'lynx', 40000, 'sports'),
133 ('BMW M3 E30', 'm3e30', 104000, 'addons'),
134 ('BMW M6', 'm6gc', 422000, 'addons'),
135 ('Mamba', 'mamba', 70000, 'sports'),
136 ('Manana', 'manana', 12800, 'sportsclassics'),
137 ('Manchez', 'manchez', 13000, 'motorcycles'),
138 ('Ferrari F12', 'massacro', 442000, 'addons'),
139 ('Mesa', 'mesa', 16000, 'suvs'),
140 ('Mesa Trail', 'mesa3', 40000, 'suvs'),
141 ('Minivan', 'minivan', 13000, 'vans'),
142 ('Monroe', 'monroe', 80000, 'sportsclassics'),
143 ('Moonbeam', 'moonbeam', 18000, 'vans'),
144 ('Moonbeam Rider', 'moonbeam2', 58500, 'vans'),
145 ('Neon', 'neon', 800000, 'sports'),
146 ('Nightblade', 'nightblade', 35000, 'motorcycles'),
147 ('9F', 'ninef', 65000, 'sports'),
148 ('9F Cabrio', 'ninef2', 80000, 'sports'),
149 ('Omnis', 'omnis', 70000, 'sports'),
150 ('Osiris', 'osiris', 270000, 'super'),
151 ('Panto', 'panto', 10000, 'compacts'),
152 ('Paradise', 'paradise', 19000, 'vans'),
153 ('Pariah', 'pariah', 320000, 'sports'),
154 ('Patriot', 'patriot', 55000, 'suvs'),
155 ('Penumbra', 'penumbra', 28000, 'sports'),
156 ('Pfister', 'pfister811', 700000, 'super'),
157 ('Premier', 'premier', 41000, 'sedans'),
158 ('Primo Custom', 'primo2', 14000, 'sedans'),
159 ('X80 Proto', 'prototipo', 1000000, 'super'),
160 ('Porche Panamera', 'pturismo', 625000, 'addons'),
161 ('Yamaha R1', 'r1', 69500, 'addons'),
162 ('Radius', 'radi', 29000, 'suvs'),
163 ('raiden', 'raiden', 155000, 'sports'),
164 ('Rapid GT', 'rapidgt', 35000, 'sports'),
165 ('Rapid GT Convertible', 'rapidgt2', 45000, 'sports'),
166 ('Rapid GT3', 'rapidgt3', 85000, 'sportsclassics'),
167 ('Lexus RCF', 'rcf', 92000, 'addons'),
168 ('Reaper', 'reaper', 150000, 'super'),
169 ('Regina', 'regina', 10000, 'sedans'),
170 ('Retinue', 'retinue', 35000, 'sportsclassics'),
171 ('BMW E36', 'rmodm3e36', 89000, 'addons'),
172 ('Rocoto', 'rocoto', 45000, 'suvs'),
173 ('Audi RS5', 'rs5', 395000, 'addons'),
174 ('Ruffian', 'ruffian', 10000, 'motorcycles'),
175 ('Rumpo Trail', 'rumpo3', 19500, 'vans'),
176 ('Mercedes Benz 500', 's500w222', 215000, 'addons'),
177 ('Sabre GT', 'sabregt2', 43000, 'muscle'),
178 ('Sandking', 'sandking', 100000, 'offroad'),
179 ('Savestra', 'savestra', 55000, 'sportsclassics'),
180 ('Schafter V12', 'schafter3', 95000, 'sports'),
181 ('Seminole', 'seminole', 25000, 'suvs'),
182 ('Sentinel', 'sentinel', 34500, 'coupes'),
183 ('Sentinel XS', 'sentinel2', 40000, 'coupes'),
184 ('Sentinel Classic', 'sentinel3', 65000, 'sports'),
185 ('Seven 70', 'seven70', 90000, 'sports'),
186 ('ETR1', 'sheava', 220000, 'super'),
187 ('Nissan Skyline', 'skyline', 110000, 'addons'),
188 ('Mercedes SLS', 'slsamg', 645000, 'addons'),
189 ('Stinger', 'stinger', 80000, 'sportsclassics'),
190 ('Stinger GT', 'stingergt', 75000, 'sportsclassics'),
191 ('Streiter', 'streiter', 85000, 'sports'),
192 ('Stretch', 'stretch', 90000, 'sedans'),
193 ('Sultan RS', 'sultanrs', 110000, 'super'),
194 ('Superduty', 'superduty', 75000, 'addons'),
195 ('Surano', 'surano', 50000, 'sports'),
196 ('Surfer', 'surfer', 12000, 'vans'),
197 ('T20', 't20', 450000, 'super'),
198 ('Turismo R', 'turismor', 350000, 'super'),
199 ('Lambo Ursus', 'urus2018', 425000, 'addons'),
200 ('Volvo 242', 'v242', 20000, 'addons'),
201 ('Vacca', 'vacca', 120000, 'super'),
202 ('Vader', 'vader', 7200, 'motorcycles'),
203 ('Visione', 'visione', 1100000, 'super'),
204 ('Voltic', 'voltic', 200000, 'super'),
205 ('Volvo 850R', 'volvo850r', 16800, 'addons'),
206 ('Volvo C30', 'volvoc30', 70000, 'addons'),
207 ('Voodoo', 'voodoo', 35000, 'muscle'),
208 ('Vortex', 'vortex', 17500, 'motorcycles'),
209 ('VW Passat Stance B8', 'vwstance', 82000, 'addons'),
210 ('Mercedes Benz S600', 'w140s600', 18500, 'addons'),
211 ('Warrener', 'warrener', 18000, 'sedans'),
212 ('Washington', 'washington', 9000, 'sedans'),
213 ('Windsor', 'windsor', 95000, 'coupes'),
214 ('RollsRoyce Wraith', 'wraith', 550000, 'addons'),
215 ('XLS', 'xls', 32000, 'suvs'),
216 ('Youga', 'youga', 10800, 'vans'),
217 ('Youga Luxuary', 'youga2', 14500, 'vans'),
218 ('Z190', 'z190', 110000, 'sportsclassics'),
219 ('Zentorno', 'zentorno', 320000, 'super'),
220 ('Camaro', 'zl12017', 215000, 'addons'),
221 ('Zombie', 'zombiea', 12500, 'motorcycles'),
222 ('Z-Type', 'ztype', 100000, 'sportsclassics');
223/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
224
225/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
226/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
227/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;