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