j3HuXX2a

1USE `essentialmode`;
2
3INSERT INTO `addon_account` (name, label, shared) VALUES
4	('society_cardealer','Händler',1)
5;
6
7INSERT INTO `addon_inventory` (name, label, shared) VALUES
8	('society_cardealer','Händler',1)
9;
10
11INSERT INTO `jobs` (name, label) VALUES
12	('cardealer','Händler')
13;
14
15INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
16	('cardealer',0,'recruit','Neuling',10,'{}','{}'),
17	('cardealer',1,'novice','Verkäufer',25,'{}','{}'),
18	('cardealer',2,'experienced','Verkaufsleiter',40,'{}','{}'),
19	('cardealer',3,'boss','Boss',0,'{}','{}')
20;
21
22CREATE TABLE `cardealer_vehicles` (
23	`id` int(11) NOT NULL AUTO_INCREMENT,
24	`vehicle` varchar(255) NOT NULL,
25	`price` int(11) NOT NULL,
26
27	PRIMARY KEY (`id`)
28);
29
30CREATE TABLE `vehicle_sold` (
31	`client` VARCHAR(50) NOT NULL,
32	`model` VARCHAR(50) NOT NULL,
33	`plate` VARCHAR(50) NOT NULL,
34	`soldby` VARCHAR(50) NOT NULL,
35	`date` VARCHAR(50) NOT NULL,
36
37	PRIMARY KEY (`plate`)
38);
39
40CREATE TABLE `owned_vehicles` (
41	`owner` varchar(22) NOT NULL,
42	`plate` varchar(12) NOT NULL,
43	`vehicle` longtext,
44	`type` VARCHAR(20) NOT NULL DEFAULT 'car',
45	`job` VARCHAR(20) NULL DEFAULT NULL,
46	`stored` TINYINT(1) NOT NULL DEFAULT '0',
47
48	PRIMARY KEY (`plate`)
49);
50
51CREATE TABLE `rented_vehicles` (
52	`vehicle` varchar(60) NOT NULL,
53	`plate` varchar(12) NOT NULL,
54	`player_name` varchar(255) NOT NULL,
55	`base_price` int(11) NOT NULL,
56	`rent_price` int(11) NOT NULL,
57	`owner` varchar(22) NOT NULL,
58
59	PRIMARY KEY (`plate`)
60);
61
62CREATE TABLE `vehicle_categories` (
63	`name` varchar(60) NOT NULL,
64	`label` varchar(60) NOT NULL,
65
66	PRIMARY KEY (`name`)
67);
68
69INSERT INTO `vehicle_categories` (name, label) VALUES
70	('compacts','Compacts'),
71	('coupes','Coupés'),
72	('sedans','Sedans'),
73	('sports','Sports'),
74	('sportsclassics','Sports Classics'),
75	('super','Super'),
76	('muscle','Muscle'),
77	('offroad','Off Road'),
78	('suvs','SUVs'),
79	('vans','Vans'),
80	('motorcycles','Motos')
81;
82
83DROP TABLE IF EXISTS `vehicles`;
84CREATE TABLE `vehicles` (
85  `name` varchar(60) NOT NULL,
86  `model` varchar(60) NOT NULL,
87  `price` int(11) NOT NULL,
88  `category` varchar(60) DEFAULT NULL,
89  PRIMARY KEY (`model`)
90) ENGINE=InnoDB DEFAULT CHARSET=utf8;
91
92INSERT INTO `vehicles` (`name`, `model`, `price`, `category`) VALUES
93('Adder',	'adder',	1105769,	'super'),
94('Akuma',	'akuma',	9953,	'motorcycles'),
95('Alpha',	'alpha',	144231,	'sports'),
96('Ardent',	'ardent',	1658654,	'sportclassics'),
97('Asea',	'asea',	13269,	'sedans'),
98('Asterope',	'asterope',	28750,	'sedans'),
99('Autarch',	'autarch',	2161779,	'super'),
100('Avarus',	'avarus',	128269,	'motorcycles'),
101('Bagger',	'bagger',	17693,	'motorcycles'),
102('Baller',	'baller',	86539,	'suvs'),
103('Baller LE',	'baller3',	143269,	'suvs'),
104('Baller LE LWB',	'baller4',	237500,	'suvs'),
105('Banshee',	'banshee',	100961,	'sports'),
106('Banshee',	'banshee2',	121154,	'sports'),
107('Bati 801',	'bati',	16586,	'motorcycles'),
108('Bati 801RR',	'bati2',	17693,	'motorcycles'),
109('BF400',	'bf400',	105048,	'motorcycles'),
110('Injection',	'bfinjection',	17693,	'offroad'),
111('Bifta',	'bifta',	75193,	'offroad'),
112('Bison',	'bison',	43269,	'vans'),
113('Blade',	'blade',	96203,	'muscle'),
114('Blazer Standard',	'blazer',	8846,	'motorcycles'),
115('Blazer III',	'blazer3',	77404,	'motorcycles'),
116('Blazer IV',	'blazer4',	89568,	'motorcycles'),
117('Blista Compact',	'blista2',	40385,	'sports'),
118('GO-GO-Monkey Blista',	'blista3',	116346,	'sports'),
119('Bobcat XL',	'bobcatxl',	30769,	'vans'),
120('Bodhi',	'bodhi2',	24825,	'offroad'),
121('Brawler',	'brawler',	790625,	'offroad'),
122('Roosevelt',	'btype',	829328,	'sportclassics'),
123('Fränken Stange',	'btype2',	608173,	'sportclassics'),
124('Roosevelt Valor',	'btype3',	1085865,	'sportclassics'),
125('Buccaneer',	'buccaneer',	32068,	'muscle'),
126('Buccaneer Custom',	'buccaneer2',	387019,	'muscle'),
127('Buffalo',	'buffalo',	33654,	'sports'),
128('Buffalo S',	'buffalo2',	92308,	'sports'),
129('Sprunk Buffalo',	'buffalo3',	514423,	'sports'),
130('Bullet',	'bullet',	92885,	'super'),
131('Burrito',	'burrito3',	18269,	'vans'),
132('Camper',	'camper',	40385,	'vans'),
133('Carbonizzare',	'carbonizzare',	187500,	'sports'),
134('Carbon RS',	'carbonrs',	44231,	'motorcycles'),
135('Casco',	'casco',	1000058,	'sportclassics'),
136('Cavalcade',	'cavalcade',	57693,	'suvs'),
137('Cheburek',	'cheburek',	160336,	'sportclassics'),
138('Cheetah',	'cheetah',	718750,	'super'),
139('Cheetah Classic',	'cheetah2',	956490,	'sportclassics'),
140('Chimera',	'chimera',	232211,	'motorcycles'),
141('Chino',	'chino',	248798,	'muscle'),
142('Chino Custom',	'chino2',	199039,	'muscle'),
143('Cliffhanger',	'cliffhanger',	248798,	'motorcycles'),
144('Cognoscenti 55',	'cog55',	170289,	'sedans'),
145('Cognoscenti Small',	'cognoscenti',	193510,	'coupes'),
146('Cognoscenti Large',	'cognoscenti2',	238846,	'coupes'),
147('Comet',	'comet2',	96154,	'sports'),
148('Comet RC',	'comet3',	620193,	'sports'),
149('Comet S',	'comet4',	682693,	'sports'),
150('Comet SR',	'comet5',	1100961,	'sports'),
151('Contender',	'contender',	240385,	'suvs'),
152('Coquette',	'coquette',	132693,	'sports'),
153('Coquette Classic',	'coquette2',	436779,	'sportclassics'),
154('Coquette BlackFin',	'coquette3',	768510,	'muscle'),
155('Cyclone',	'cyclone',	2089904,	'super'),
156('Daemon',	'daemon',	160336,	'motorcycles'),
157('Daemon Custom',	'daemon2',	182453,	'motorcycles'),
158('Defiler',	'defiler',	455578,	'motorcycles'),
159('Diablous',	'diablous',	186875,	'motorcycles'),
160('Diablous Custom',	'diablous2',	280865,	'motorcycles'),
161('Duneloader',	'dloader',	24825,	'offroad'),
162('Dominator',	'dominator',	38703,	'muscle'),
163('Pisswasser Dominator',	'dominator2',	348318,	'muscle'),
164('Dominator GTX',	'dominator3',	801683,	'muscle'),
165('Double T',	'double',	13269,	'motorcycles'),
166('G65 AMG',	'dubsta',	82693,	'suvs'),
167('Dubsta 6x6',	'dubsta3',	275336,	'offroad'),
168('Dukes',	'dukes',	68558,	'muscle'),
169('Dune Buggy',	'dune',	22115,	'offroad'),
170('Elegy Retrco Custom',	'elegy',	869231,	'sports'),
171('Elegy RH8',	'elegy2',	91346,	'sports'),
172('Ellie',	'ellie',	624760,	'muscle'),
173('Emperor Classic',	'emperor',	59711,	'sedans'),
174('Emperor Rusty',	'emperor2',	10394,	'sedans'),
175('Enduro',	'enduro',	53078,	'motorcycles'),
176('Entity XXR',	'entity2',	2206010,	'super'),
177('Entity XF',	'entityxf',	879086,	'super'),
178('Esskey',	'esskey',	181346,	'motorcycles'),
179('Exemplar ',	'exemplar',	226683,	'coupes'),
180('F620 ',	'f620',	139328,	'coupes'),
181('Faction',	'faction',	39808,	'muscle'),
182('Faction Custom',	'faction2',	370433,	'muscle'),
183('Faction Custom Donk',	'faction3',	768510,	'muscle'),
184('Fagaloa',	'fagaloa',	370433,	'sportclassics'),
185('Faggio',	'faggio',	5529,	'motorcycles'),
186('Faggio Sport',	'faggio2',	7740,	'motorcycles'),
187('Faggio Classic',	'faggio3',	9953,	'motorcycles'),
188('FCR 1000',	'fcr',	149279,	'motorcycles'),
189('FCR 1000 Custom',	'fcr2',	216731,	'motorcycles'),
190('Felon ',	'felon',	99519,	'coupes'),
191('Felon Cabrio',	'felon2',	105048,	'coupes'),
192('Feltzer',	'feltzer2',	139423,	'sports'),
193('Stirling GT',	'feltzer3',	1078125,	'sportclassics'),
194('Flash GT',	'flashgt',	1852164,	'sportclassics'),
195('FMJ',	'fmj',	1935096,	'super'),
196('FQ 2',	'fq2',	48078,	'suvs'),
197('Fugitive',	'fugitive',	26539,	'sedans'),
198('Furore GT',	'furoregt',	430769,	'sports'),
199('Fusilade',	'fusilade',	34615,	'sports'),
200('Futo',	'futo',	10096,	'sports'),
201('Gargoyle',	'gargoyle',	132693,	'motorcycles'),
202('Gauntlet',	'gauntlet',	35385,	'muscle'),
203('Redwood Gauntlet',	'gauntlet2',	254328,	'muscle'),
204('GB200',	'gb200',	903846,	'sports'),
205('Gang Burrito',	'gburrito',	43269,	'vans'),
206('Burrito',	'gburrito2',	27885,	'vans'),
207('GP1',	'gp1',	1393269,	'super'),
208('Granger',	'granger',	33654,	'suvs'),
209('Gresley',	'gresley',	27885,	'suvs'),
210('GT 500',	'gt500',	868029,	'sportclassics'),
211('Habanero',	'habanero',	40385,	'suvs'),
212('Hakuchou',	'hakuchou',	90673,	'motorcycles'),
213('Hakuchou Drag',	'hakuchou2',	1079231,	'motorcycles'),
214('Hermes',	'hermes',	591586,	'muscle'),
215('Hexer',	'hexer',	16586,	'motorcycles'),
216('Hotknife',	'hotknife',	99519,	'muscle'),
217('Hotring Sabre (Race)',	'hotring',	72115,	'sports'),
218('Huntley S',	'huntley',	187500,	'suvs'),
219('Hustler',	'hustler',	691106,	'muscle'),
220('Infernus',	'infernus',	486539,	'super'),
221('Infernus Classic',	'infernus2',	1011779,	'sportclassics'),
222('Ingot',	'ingot',	9953,	'sedans'),
223('Innovation',	'innovation',	102284,	'motorcycles'),
224('Intruder',	'intruder',	17693,	'sedans'),
225('Itali GTB',	'italigtb',	1314760,	'super'),
226('Itali GTB Custom',	'italigtb2',	547356,	'super'),
227('Mercedes (Jackal)',	'jackal',	176923,	'coupes'),
228('JB 700',	'jb700',	525240,	'sportclassics'),
229('Jester',	'jester',	230769,	'sports'),
230('Jester (Race)',	'jester2',	336539,	'sports'),
231('Jester Classic',	'jester3',	759615,	'sports'),
232('Journey',	'journey',	6250,	'vans'),
233('Kalahari',	'kalahari',	56394,	'offroad'),
234('Kamacho',	'kamacho',	381490,	'offroad'),
235('Khamelion',	'khamelion',	96154,	'sports'),
236('Kuruma',	'kuruma',	91346,	'sports'),
237('Landstalker',	'lanstal',	55769,	'suvs'),
238('RE-7B',	'le7b',	2736779,	'super'),
239('Lectro (NOS)',	'lectro',	829328,	'motorcycles'),
240('Lurcher',	'lurcher',	718750,	'muscle'),
241('Lynx',	'lynx',	1668269,	'sports'),
242('Mamba',	'mamba',	1100240,	'sportclassics'),
243('Manana',	'manana',	14099,	'sportclassics'),
244('Manchez',	'manchez',	74086,	'motorcycles'),
245('Massacro',	'massacro',	264423,	'sports'),
246('Massacro (Race)',	'massacro2',	370193,	'sports'),
247('Mesa',	'mesa',	22115,	'offroad'),
248('Michelli GT',	'michelli',	1354568,	'sportclassics'),
249('Minivan',	'minivan',	12500,	'vans'),
250('Monroe',	'monroe',	541828,	'sportclassics'),
251('Moonbeam',	'moonbeam',	35938,	'muscle'),
252('Moonbeam Custom',	'moonbeam2',	409135,	'muscle'),
253('Nemesis',	'nemesis',	13269,	'motorcycles'),
254('Neon',	'neon',	1442308,	'sports'),
255('Nero',	'nero',	668990,	'super'),
256('Nero Custom',	'nero2',	1592308,	'super'),
257('Nightblade',	'nightblade',	110578,	'motorcycles'),
258('Nightshade',	'nightshade',	646875,	'muscle'),
259('9F',	'ninef',	115385,	'sports'),
260('9F Carbrio',	'ninef2',	125000,	'sports'),
261('Omnis',	'omnis',	674039,	'sports'),
262('Oracle',	'oracle',	88461,	'coupes'),
263('Oracle II',	'oracle2',	90673,	'coupes'),
264('Osiris',	'osiris',	2156250,	'super'),
265('Paradise',	'paradise',	18269,	'vans'),
266('Pariah',	'pariah',	1365385,	'sports'),
267('Patriot',	'patriot',	30769,	'suvs'),
268('Patriot Stretch',	'patriot2',	588269,	'suvs'),
269('PCJ-600',	'pcj',	9953,	'motorcycles'),
270('Penetrator',	'penetrator',	973078,	'super'),
271('Penumbra',	'penumbra',	23078,	'sports'),
272('Peyote',	'peyote',	68419,	'sportclassics'),
273('811',	'pfister811',	1255048,	'super'),
274('Phoenix',	'pheonix',	19904,	'muscle'),
275('Picador',	'picador',	9953,	'muscle'),
276('Pigalle',	'pigalle',	442308,	'sportclassics'),
277('Premier',	'premier',	11058,	'sedans'),
278('Primo',	'primo',	9953,	'sedans'),
279('Primo Custom',	'primo2',	442308,	'sedans'),
280('xa21',	'prototipo',	2985578,	'super'),
281('Radius',	'radius',	30769,	'suvs'),
282('Raiden',	'raiden',	1322115,	'sports'),
283('Rancher XL',	'rancherxl',	9953,	'offroad'),
284('Rapid GT',	'rapidgt',	126923,	'sports'),
285('Rapid GT Cabrio',	'rapidgt2',	134615,	'sports'),
286('Rapid GT Classic',	'rapidgt3',	967548,	'sportclassics'),
287('Raptor',	'raptor',	623078,	'sports'),
288('Rat-Truck',	'ratloader2',	41466,	'muscle'),
289('Reaper',	'reaper',	1763703,	'super'),
290('Rusty Rebel',	'rebel',	3318,	'offroad'),
291('Rebel',	'rebel2',	24328,	'offroad'),
292('Regina Classic',	'regina',	8846,	'sedans'),
293('Retinue',	'retinue',	680048,	'sportclassics'),
294('Revolter',	'revolter',	1548078,	'sports'),
295('riata',	'riata',	420193,	'offroad'),
296('Rocoto',	'rocoto',	81731,	'suvs'),
297('Romero Hearse',	'romero',	62864,	'sedans'),
298('Ruffian',	'ruffian',	11058,	'motorcycles'),
299('Ruiner',	'ruiner',	25985,	'muscle'),
300('Rumpo',	'rumpo',	14423,	'vans'),
301('Rumpo Trail',	'rumpo3',	18750,	'vans'),
302('Ruston',	'ruston',	413461,	'sports'),
303('Sabre Turbo',	'sabregt',	16586,	'muscle'),
304('Sabre Turbo Custom',	'sabregt2',	541828,	'muscle'),
305('Sanchez',	'sanchez',	8846,	'motorcycles'),
306('Sanchez Sport',	'sanchez2',	8846,	'motorcycles'),
307('Sanctus',	'sanctus',	2206010,	'motorcycles'),
308('Sandking SWB',	'sandking',	42019,	'offroad'),
309('Sandking XL',	'sandking2',	49760,	'offroad'),
310('Savestra',	'savestra',	1094711,	'sportclassics'),
311('Schafter II',	'schafter2',	71875,	'sedans'),
312('Schafter V12',	'schafter3',	111539,	'sports'),
313('Schafter LWB',	'schafter4',	200000,	'sports'),
314('Schwartzer',	'schwarzer',	76923,	'sports'),
315('Seminole',	'seminole',	28846,	'suvs'),
316('Sentinel XS',	'sentinel',	110578,	'coupes'),
317('Sentinel Coupe ',	'sentinel2',	90673,	'coupes'),
318('Sentinel Classic',	'sentinel3',	625000,	'sports'),
319('Serrano',	'serrano',	57693,	'suvs'),
320('Seven-70',	'seven70',	668269,	'sports'),
321('ETR1',	'sheava',	2206010,	'super'),
322('Shotaro Concept',	'shotaro',	2460336,	'motorcycles'),
323('Slamvan',	'slamvan',	54735,	'muscle'),
324('Lost Slamvan',	'slamvan2',	254328,	'muscle'),
325('Slamvan Custom',	'slamvan3',	458894,	'muscle'),
326('Sovereign',	'sovereign',	99519,	'motorcycles'),
327('Specter C',	'specter',	575961,	'sports'),
328('Specter',	'specter2',	242308,	'sports'),
329('Stafford',	'stafford',	1406539,	'sedans'),
330('Burger Shot Stallion',	'stalion2',	306298,	'muscle'),
331('Stallion',	'stallion',	78510,	'muscle'),
332('Stanier',	'stanier',	11058,	'sedans'),
333('Stinger',	'stinger',	1105769,	'sportclassics'),
334('Stinger GT',	'stingergt',	1105769,	'sportclassics'),
335('Stratum',	'stratum',	11058,	'sedans'),
336('Streiter',	'streiter',	480769,	'sports'),
337('Stretch Limo',	'stretch',	882404,	'sedans'),
338('Sultan',	'sultan',	11539,	'sports'),
339('Sultan RS',	'sultanrs',	879086,	'super'),
340('Super Diamond',	'superd',	27644,	'sedans'),
341('Surano',	'surano',	105769,	'sports'),
342('Surfer',	'surfer',	11539,	'vans'),
343('Surge',	'surge',	42019,	'sedans'),
344('Swinger',	'swinger',	1005144,	'sportclassics'),
345('T20',	't20',	2432693,	'super'),
346('Tailgater',	'tailgater',	60818,	'sedans'),
347('Taipan',	'taipan',	2189423,	'super'),
348('Tampa',	'tampa',	414664,	'muscle'),
349('Drift Tampa',	'tampa2',	956731,	'sports'),
350('Tempesta',	'tempesta',	1469568,	'super'),
351('Tezeract',	'tezeract',	1469568,	'super'),
352('Thrust',	'thrust',	82933,	'motorcycles'),
353('Torero',	'torero',	1103558,	'sportclassics'),
354('Tornado',	'tornado',	33173,	'sportclassics'),
355('Tornado Cabrio',	'tornado2',	38703,	'sportclassics'),
356('Tornado Rat Rod (Race)',	'tornado6',	417981,	'sportclassics'),
357('Trophy Truck',	'trophytruck',	608173,	'offroad'),
358('Desert Raid',	'trophytruck2',	768510,	'offroad'),
359('Tropos Rallye',	'tropos',	784615,	'sports'),
360('Turismo Classic',	'turismo2',	779568,	'sportclassics'),
361('Turismo R',	'turismor',	552885,	'super'),
362('Tyrant',	'tyrant',	2781010,	'super'),
363('Tyrus',	'tyrus',	2819711,	'super'),
364('Vacca',	'vacca',	265385,	'super'),
365('Vader',	'vader',	9953,	'motorcycles'),
366('Vagner',	'vagner',	1697356,	'super'),
367('Verlierer',	'verlierer2',	668269,	'sports'),
368('Vigero',	'vigero',	23221,	'muscle'),
369('Vindicator (NOS)',	'vindicator',	696635,	'motorcycles'),
370('Virgo',	'virgo',	215625,	'muscle'),
371('Virgo Classic Custom',	'virgo2',	265385,	'muscle'),
372('Virgo Classic',	'virgo3',	182453,	'muscle'),
373('Viseris',	'viseris',	967548,	'sportclassics'),
374('Visione',	'visione',	2487981,	'super'),
375('Voltic',	'voltic',	165865,	'super'),
376('Rocket Voltic',	'voltic2',	4235539,	'super'),
377('Voodoo Custom',	'voodoo',	464423,	'muscle'),
378('Voodoo',	'voodoo2',	8294,	'muscle'),
379('Vortex',	'vortex',	283078,	'motorcycles'),
380('Warrener',	'warrener',	132693,	'sedans'),
381('Washington',	'washington',	16586,	'sedans'),
382('Windsor Cabrio',	'windsor2',	995193,	'coupes'),
383('Woflsbane',	'wolfsbane',	105048,	'motorcycles'),
384('XA-21',	'xa21',	2626203,	'super'),
385('XLS',	'xls',	243269,	'suvs'),
386('Yosemite',	'yosemite',	536298,	'muscle'),
387('Youga',	'youga',	10385,	'vans'),
388('Youga Luxuary',	'youga2',	13943,	'vans'),
389('190z',	'z190',	995193,	'sportclassics'),
390('Zentorno',	'zentorno',	801683,	'super'),
391('Zion',	'zion',	55289,	'coupes'),
392('Zion Cabrio',	'zion2',	71875,	'coupes'),
393('Zombie Chopper',	'zombiea',	134904,	'motorcycles'),
394('Zombie Bobber',	'zombieb',	109471,	'motorcycles'),
395('Z-Type',	'ztype',	11057693,	'sportclassics')
396;