· 6 years ago · Jul 12, 2019, 06:36 PM
1-- --------------------------------------------------------
2-- Sunucu: 127.0.0.1
3-- Sunucu sürümü: 5.7.17-log - MySQL Community Server (GPL)
4-- Sunucu İşletim Sistemi: Win32
5-- HeidiSQL Sürüm: 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-- essentialmode için veritabanı yapısı dökülüyor
16CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */;
17USE `essentialmode`;
18
19-- tablo yapısı dökülüyor 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-- essentialmode.vehicles: ~240 rows (yaklaşık) tablosu için veriler indiriliyor
29/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
30INSERT IGNORE INTO `vehicles` (`name`, `model`, `price`, `category`) VALUES
31 ('Akuma', 'AKUMA', 7500, 'motorcycles'),
32 ('Adder', 'adder', 900000, 'super'),
33 ('Alpha', 'alpha', 60000, 'sports'),
34 ('Asea', 'asea', 5500, 'sedans'),
35 ('Autarch', 'autarch', 1955000, 'super'),
36 ('Avarus', 'avarus', 18000, 'motorcycles'),
37 ('Bagger', 'bagger', 13500, 'motorcycles'),
38 ('Baller', 'baller2', 40000, 'suvs'),
39 ('Baller Sport', 'baller3', 60000, 'suvs'),
40 ('Banshee', 'banshee', 70000, 'sports'),
41 ('Banshee 900R', 'banshee2', 255000, 'super'),
42 ('Bati 801', 'bati', 12000, 'motorcycles'),
43 ('Bati 801RR', 'bati2', 19000, 'motorcycles'),
44 ('Bestia GTS', 'bestiagts', 55000, 'sports'),
45 ('BF400', 'bf400', 6500, 'motorcycles'),
46 ('Bf Injection', 'bfinjection', 16000, 'offroad'),
47 ('Bifta', 'bifta', 12000, 'offroad'),
48 ('Bison', 'bison', 45000, 'vans'),
49 ('Blade', 'blade', 15000, 'muscle'),
50 ('Blazer', 'blazer', 6500, 'offroad'),
51 ('Blazer Sport', 'blazer4', 8500, 'offroad'),
52 ('blazer5', 'blazer5', 1755600, 'offroad'),
53 ('Blista', 'blista', 8000, 'compacts'),
54 ('BMX (velo)', 'bmx', 160, 'motorcycles'),
55 ('Bobcat XL', 'bobcatxl', 32000, 'vans'),
56 ('Brawler', 'brawler', 45000, 'offroad'),
57 ('Brioso R/A', 'brioso', 18000, 'compacts'),
58 ('Btype', 'btype', 62000, 'sportsclassics'),
59 ('Btype Hotroad', 'btype2', 155000, 'sportsclassics'),
60 ('Btype Luxe', 'btype3', 85000, 'sportsclassics'),
61 ('Buccaneer', 'buccaneer', 18000, 'muscle'),
62 ('Buccaneer Rider', 'buccaneer2', 24000, 'muscle'),
63 ('Buffalo', 'buffalo', 12000, 'sports'),
64 ('Buffalo S', 'buffalo2', 20000, 'sports'),
65 ('Bullet', 'bullet', 90000, 'super'),
66 ('Burrito', 'burrito3', 19000, 'vans'),
67 ('Camper', 'camper', 42000, 'vans'),
68 ('Carbonizzare', 'carbonizzare', 75000, 'sports'),
69 ('Carbon RS', 'carbonrs', 18000, 'motorcycles'),
70 ('Casco', 'casco', 30000, 'sportsclassics'),
71 ('Cavalcade', 'cavalcade2', 55000, 'suvs'),
72 ('Cheetah', 'cheetah', 375000, 'super'),
73 ('Chimera', 'chimera', 38000, 'motorcycles'),
74 ('Chino', 'chino', 15000, 'muscle'),
75 ('Chino Luxe', 'chino2', 19000, 'muscle'),
76 ('Cliffhanger', 'cliffhanger', 9500, 'motorcycles'),
77 ('Cognoscenti Cabrio', 'cogcabrio', 55000, 'coupes'),
78 ('Cognoscenti', 'cognoscenti', 55000, 'sedans'),
79 ('Comet', 'comet2', 65000, 'sports'),
80 ('Comet 5', 'comet5', 1145000, 'sports'),
81 ('Contender', 'contender', 70000, 'suvs'),
82 ('Coquette', 'coquette', 65000, 'sports'),
83 ('Coquette Classic', 'coquette2', 40000, 'sportsclassics'),
84 ('Coquette BlackFin', 'coquette3', 55000, 'muscle'),
85 ('Cruiser (velo)', 'cruiser', 510, 'motorcycles'),
86 ('Cyclone', 'cyclone', 1890000, 'super'),
87 ('Daemon', 'daemon', 11500, 'motorcycles'),
88 ('Daemon High', 'daemon2', 13500, 'motorcycles'),
89 ('Defiler', 'defiler', 9800, 'motorcycles'),
90 ('Dominator', 'dominator', 35000, 'muscle'),
91 ('Double T', 'double', 28000, 'motorcycles'),
92 ('Dubsta', 'dubsta', 45000, 'suvs'),
93 ('Dubsta Luxuary', 'dubsta2', 60000, 'suvs'),
94 ('Bubsta 6x6', 'dubsta3', 120000, 'offroad'),
95 ('Dukes', 'dukes', 28000, 'muscle'),
96 ('Dune Buggy', 'dune', 8000, 'offroad'),
97 ('Elegy', 'elegy2', 38500, 'sports'),
98 ('Emperor', 'emperor', 8500, 'sedans'),
99 ('Enduro', 'enduro', 5500, 'motorcycles'),
100 ('Entity XF', 'entityxf', 425000, 'super'),
101 ('Esskey', 'esskey', 4200, 'motorcycles'),
102 ('Exemplar', 'exemplar', 32000, 'coupes'),
103 ('F620', 'f620', 40000, 'coupes'),
104 ('Faction', 'faction', 20000, 'muscle'),
105 ('Faction Rider', 'faction2', 30000, 'muscle'),
106 ('Faction XL', 'faction3', 40000, 'muscle'),
107 ('Faggio', 'faggio', 1900, 'motorcycles'),
108 ('Vespa', 'faggio2', 2800, 'motorcycles'),
109 ('Felon', 'felon', 42000, 'coupes'),
110 ('Felon GT', 'felon2', 55000, 'coupes'),
111 ('Feltzer', 'feltzer2', 55000, 'sports'),
112 ('Stirling GT', 'feltzer3', 65000, 'sportsclassics'),
113 ('Fixter (velo)', 'fixter', 225, 'motorcycles'),
114 ('FMJ', 'fmj', 185000, 'super'),
115 ('Fhantom', 'fq2', 17000, 'suvs'),
116 ('Fugitive', 'fugitive', 12000, 'sedans'),
117 ('Furore GT', 'furoregt', 45000, 'sports'),
118 ('Fusilade', 'fusilade', 40000, 'sports'),
119 ('Gargoyle', 'gargoyle', 16500, 'motorcycles'),
120 ('Gauntlet', 'gauntlet', 30000, 'muscle'),
121 ('Gang Burrito', 'gburrito', 45000, 'vans'),
122 ('Burrito', 'gburrito2', 29000, 'vans'),
123 ('Glendale', 'glendale', 6500, 'sedans'),
124 ('Grabger', 'granger', 50000, 'suvs'),
125 ('Gresley', 'gresley', 47500, 'suvs'),
126 ('GT 500', 'gt500', 785000, 'sportsclassics'),
127 ('Guardian', 'guardian', 45000, 'offroad'),
128 ('Hakuchou', 'hakuchou', 31000, 'motorcycles'),
129 ('Hakuchou Sport', 'hakuchou2', 55000, 'motorcycles'),
130 ('Hermes', 'hermes', 535000, 'muscle'),
131 ('Hexer', 'hexer', 12000, 'motorcycles'),
132 ('Hotknife', 'hotknife', 125000, 'muscle'),
133 ('Huntley S', 'huntley', 40000, 'suvs'),
134 ('Hustler', 'hustler', 625000, 'muscle'),
135 ('Infernus', 'infernus', 180000, 'super'),
136 ('Innovation', 'innovation', 23500, 'motorcycles'),
137 ('Intruder', 'intruder', 7500, 'sedans'),
138 ('Issi', 'issi2', 10000, 'compacts'),
139 ('Jackal', 'jackal', 38000, 'coupes'),
140 ('Jester', 'jester', 65000, 'sports'),
141 ('Journey', 'journey', 6500, 'vans'),
142 ('Kamacho', 'kamacho', 345000, 'offroad'),
143 ('Khamelion', 'khamelion', 38000, 'sports'),
144 ('Kuruma', 'kuruma', 30000, 'sports'),
145 ('Landstalker', 'landstalker', 35000, 'suvs'),
146 ('RE-7B', 'le7b', 325000, 'super'),
147 ('Lynx', 'lynx', 40000, 'sports'),
148 ('Mamba', 'mamba', 70000, 'sports'),
149 ('Manana', 'manana', 12800, 'sportsclassics'),
150 ('Manchez', 'manchez', 5300, 'motorcycles'),
151 ('Massacro', 'massacro', 65000, 'sports'),
152 ('Mesa', 'mesa', 16000, 'suvs'),
153 ('Mesa Trail', 'mesa3', 40000, 'suvs'),
154 ('Minivan', 'minivan', 13000, 'vans'),
155 ('Monroe', 'monroe', 55000, 'sportsclassics'),
156 ('The Liberator', 'monster', 210000, 'offroad'),
157 ('Moonbeam', 'moonbeam', 18000, 'vans'),
158 ('Moonbeam Rider', 'moonbeam2', 35000, 'vans'),
159 ('Nemesis', 'nemesis', 5800, 'motorcycles'),
160 ('Neon', 'neon', 1500000, 'sports'),
161 ('Nightblade', 'nightblade', 35000, 'motorcycles'),
162 ('Nightshade', 'nightshade', 65000, 'muscle'),
163 ('9F', 'ninef', 65000, 'sports'),
164 ('9F Cabrio', 'ninef2', 80000, 'sports'),
165 ('Omnis', 'omnis', 35000, 'sports'),
166 ('Oracle XS', 'oracle2', 35000, 'coupes'),
167 ('Osiris', 'osiris', 160000, 'super'),
168 ('Panto', 'panto', 10000, 'compacts'),
169 ('Paradise', 'paradise', 19000, 'vans'),
170 ('Pariah', 'pariah', 1420000, 'sports'),
171 ('Patriot', 'patriot', 55000, 'suvs'),
172 ('PCJ-600', 'pcj', 6200, 'motorcycles'),
173 ('Penumbra', 'penumbra', 28000, 'sports'),
174 ('Pfister', 'pfister811', 85000, 'super'),
175 ('Phoenix', 'phoenix', 12500, 'muscle'),
176 ('Picador', 'picador', 18000, 'muscle'),
177 ('Pigalle', 'pigalle', 20000, 'sportsclassics'),
178 ('Prairie', 'prairie', 12000, 'compacts'),
179 ('Premier', 'premier', 8000, 'sedans'),
180 ('Primo Custom', 'primo2', 14000, 'sedans'),
181 ('X80 Proto', 'prototipo', 2500000, 'super'),
182 ('Radius', 'radi', 29000, 'suvs'),
183 ('raiden', 'raiden', 1375000, 'sports'),
184 ('Rapid GT', 'rapidgt', 35000, 'sports'),
185 ('Rapid GT Convertible', 'rapidgt2', 45000, 'sports'),
186 ('Rapid GT3', 'rapidgt3', 885000, 'sportsclassics'),
187 ('Reaper', 'reaper', 150000, 'super'),
188 ('Rebel', 'rebel2', 35000, 'offroad'),
189 ('Regina', 'regina', 5000, 'sedans'),
190 ('Retinue', 'retinue', 615000, 'sportsclassics'),
191 ('Revolter', 'revolter', 1610000, 'sports'),
192 ('riata', 'riata', 380000, 'offroad'),
193 ('Rocoto', 'rocoto', 45000, 'suvs'),
194 ('Ruffian', 'ruffian', 6800, 'motorcycles'),
195 ('Rumpo Trail', 'rumpo3', 19500, 'vans'),
196 ('Sabre Turbo', 'sabregt', 20000, 'muscle'),
197 ('Sabre GT', 'sabregt2', 25000, 'muscle'),
198 ('Sanchez', 'sanchez', 5300, 'motorcycles'),
199 ('Sanchez Sport', 'sanchez2', 5300, 'motorcycles'),
200 ('Sanctus', 'sanctus', 25000, 'motorcycles'),
201 ('Sandking', 'sandking', 55000, 'offroad'),
202 ('Savestra', 'savestra', 990000, 'sportsclassics'),
203 ('SC 1', 'sc1', 1603000, 'super'),
204 ('Schafter', 'schafter2', 25000, 'sedans'),
205 ('Schafter V12', 'schafter3', 50000, 'sports'),
206 ('Scorcher (velo)', 'scorcher', 280, 'motorcycles'),
207 ('Seminole', 'seminole', 25000, 'suvs'),
208 ('Sentinel', 'sentinel', 32000, 'coupes'),
209 ('Sentinel XS', 'sentinel2', 40000, 'coupes'),
210 ('Sentinel3', 'sentinel3', 650000, 'sports'),
211 ('Seven 70', 'seven70', 39500, 'sports'),
212 ('ETR1', 'sheava', 220000, 'super'),
213 ('Shotaro Concept', 'shotaro', 320000, 'motorcycles'),
214 ('Slam Van', 'slamvan3', 11500, 'muscle'),
215 ('Sovereign', 'sovereign', 22000, 'motorcycles'),
216 ('Stinger', 'stinger', 80000, 'sportsclassics'),
217 ('Stinger GT', 'stingergt', 75000, 'sportsclassics'),
218 ('Streiter', 'streiter', 500000, 'sports'),
219 ('Stretch', 'stretch', 90000, 'sedans'),
220 ('Sultan', 'sultan', 15000, 'sports'),
221 ('Sultan RS', 'sultanrs', 65000, 'super'),
222 ('Super Diamond', 'superd', 130000, 'sedans'),
223 ('Surano', 'surano', 50000, 'sports'),
224 ('Surfer', 'surfer', 12000, 'vans'),
225 ('T20', 't20', 300000, 'super'),
226 ('Tailgater', 'tailgater', 30000, 'sedans'),
227 ('Tampa', 'tampa', 16000, 'muscle'),
228 ('Drift Tampa', 'tampa2', 80000, 'sports'),
229 ('Thrust', 'thrust', 24000, 'motorcycles'),
230 ('Tri bike (velo)', 'tribike3', 520, 'motorcycles'),
231 ('Trophy Truck', 'trophytruck', 60000, 'offroad'),
232 ('Trophy Truck Limited', 'trophytruck2', 80000, 'offroad'),
233 ('Tropos', 'tropos', 40000, 'sports'),
234 ('Turismo R', 'turismor', 350000, 'super'),
235 ('Tyrus', 'tyrus', 600000, 'super'),
236 ('Vacca', 'vacca', 120000, 'super'),
237 ('Vader', 'vader', 7200, 'motorcycles'),
238 ('Verlierer', 'verlierer2', 70000, 'sports'),
239 ('Vigero', 'vigero', 12500, 'muscle'),
240 ('Virgo', 'virgo', 14000, 'muscle'),
241 ('Viseris', 'viseris', 875000, 'sportsclassics'),
242 ('Visione', 'visione', 2250000, 'super'),
243 ('Voltic', 'voltic', 90000, 'super'),
244 ('Voodoo', 'voodoo', 7200, 'muscle'),
245 ('Vortex', 'vortex', 9800, 'motorcycles'),
246 ('Warrener', 'warrener', 4000, 'sedans'),
247 ('Washington', 'washington', 9000, 'sedans'),
248 ('Windsor', 'windsor', 95000, 'coupes'),
249 ('Windsor Drop', 'windsor2', 125000, 'coupes'),
250 ('Woflsbane', 'wolfsbane', 9000, 'motorcycles'),
251 ('XLS', 'xls', 32000, 'suvs'),
252 ('Yosemite', 'yosemite', 485000, 'muscle'),
253 ('Youga', 'youga', 10800, 'vans'),
254 ('Youga Luxuary', 'youga2', 14500, 'vans'),
255 ('Z190', 'z190', 900000, 'sportsclassics'),
256 ('Zentorno', 'zentorno', 1500000, 'super'),
257 ('Zion', 'zion', 36000, 'coupes'),
258 ('Zion Cabrio', 'zion2', 45000, 'coupes'),
259 ('Zombie', 'zombiea', 9500, 'motorcycles'),
260 ('Zombie Luxuary', 'zombieb', 12000, 'motorcycles'),
261 ('Z-Type', 'ztype', 220000, 'sportsclassics');
262/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
263
264/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
265/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
266/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;