z0JS23uQ

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