text: USE `es_extended`;
  
  INSERT INTO `addon_account` (name, label, shared) VALUES
  	('society_cardealer','Bilförsäljare',1)
  ;
  
  INSERT INTO `addon_inventory` (name, label, shared) VALUES
  	('society_cardealer','Bilförsäljare',1)
  ;
  
  INSERT INTO `jobs` (name, label) VALUES
  	('cardealer','Bilförsäljare')
  ;
  
  INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
  	('cardealer',0,'recruit','Nyanställd',10,'{}','{}'),
  	('cardealer',1,'novice','Nybörjare',25,'{}','{}'),
  	('cardealer',2,'experienced','Erfaren',40,'{}','{}'),
  	('cardealer',3,'boss','Chef',0,'{}','{}')
  ;
  
  CREATE TABLE `cardealer_vehicles` (
  	`id` int(11) NOT NULL AUTO_INCREMENT,
  	`vehicle` varchar(255) NOT NULL,
  	`price` int(11) NOT NULL,
  
  	PRIMARY KEY (`id`)
  );
  
  CREATE TABLE `vehicle_sold` (
  	`client` VARCHAR(50) NOT NULL,
  	`model` VARCHAR(50) NOT NULL,
  	`plate` VARCHAR(50) NOT NULL,
  	`soldby` VARCHAR(50) NOT NULL,
  	`date` VARCHAR(50) NOT NULL,
  
  	PRIMARY KEY (`plate`)
  );
  
  CREATE TABLE `owned_vehicles` (
  	`owner` varchar(40) NOT NULL,
  	`plate` varchar(12) NOT NULL,
  	`vehicle` longtext,
  	`type` VARCHAR(20) NOT NULL DEFAULT 'car',
  	`job` VARCHAR(20) NULL DEFAULT NULL,
  	`stored` TINYINT(1) NOT NULL DEFAULT '0',
  
  	PRIMARY KEY (`plate`)
  );
  
  CREATE TABLE `rented_vehicles` (
  	`vehicle` varchar(60) NOT NULL,
  	`plate` varchar(12) NOT NULL,
  	`player_name` varchar(255) NOT NULL,
  	`base_price` int(11) NOT NULL,
  	`rent_price` int(11) NOT NULL,
  	`owner` varchar(22) NOT NULL,
  
  	PRIMARY KEY (`plate`)
  );
  
  CREATE TABLE `vehicle_categories` (
  	`name` varchar(60) NOT NULL,
  	`label` varchar(60) NOT NULL,
  
  	PRIMARY KEY (`name`)
  );
  
  INSERT INTO `vehicle_categories` (name, label) VALUES
  	('compacts','Småbil'),
  	('coupes','Coupés'),
  	('sedans','Sedans'),
  	('sports','Sportbil'),
  	('sportsclassics','Klassik sportbil'),
  	('super','Super'),
  	('muscle','Muskel'),
  	('offroad','Off Road'),
  	('suvs','SUVs'),
  	('vans','Vans'),
  	('motorcycles','Motorcykel')
  ;
  
  CREATE TABLE `vehicles` (
  	`name` varchar(60) NOT NULL,
  	`model` varchar(60) NOT NULL,
  	`price` int(11) NOT NULL,
  	`category` varchar(60) DEFAULT NULL,
  
  	PRIMARY KEY (`model`)
  );
  
  INSERT INTO `vehicles` (name, model, price, category) VALUES
  	('Blade','blade',15000,'muscle'),
  	('Buccaneer','buccaneer',18000,'muscle'),
  	('Buccaneer Rider','buccaneer2',24000,'muscle'),
  	('Chino','chino',15000,'muscle'),
  	('Chino Luxe','chino2',19000,'muscle'),
  	('Coquette BlackFin','coquette3',55000,'muscle'),
  	('Dominator','dominator',35000,'muscle'),
  	('Dukes','dukes',28000,'muscle'),
  	('Gauntlet','gauntlet',30000,'muscle'),
  	('Hotknife','hotknife',125000,'muscle'),
  	('Faction','faction',20000,'muscle'),
  	('Faction Rider','faction2',30000,'muscle'),
  	('Faction XL','faction3',40000,'muscle'),
  	('Nightshade','nightshade',65000,'muscle'),
  	('Phoenix','phoenix',12500,'muscle'),
  	('Picador','picador',18000,'muscle'),
  	('Sabre Turbo','sabregt',20000,'muscle'),
  	('Sabre GT','sabregt2',25000,'muscle'),
  	('Slam Van','slamvan3',11500,'muscle'),
  	('Tampa','tampa',16000,'muscle'),
  	('Virgo','virgo',14000,'muscle'),
  	('Vigero','vigero',12500,'muscle'),
  	('Voodoo','voodoo',7200,'muscle'),
  	('Blista','blista',8000,'compacts'),
  	('Brioso R/A','brioso',18000,'compacts'),
  	('Issi','issi2',10000,'compacts'),
  	('Panto','panto',10000,'compacts'),
  	('Prairie','prairie',12000,'compacts'),
  	('Bison','bison',45000,'vans'),
  	('Bobcat XL','bobcatxl',32000,'vans'),
  	('Burrito','burrito3',19000,'vans'),
  	('Burrito','gburrito2',29000,'vans'),
  	('Camper','camper',42000,'vans'),
  	('Gang Burrito','gburrito',45000,'vans'),
  	('Journey','journey',6500,'vans'),
  	('Minivan','minivan',13000,'vans'),
  	('Moonbeam','moonbeam',18000,'vans'),
  	('Moonbeam Rider','moonbeam2',35000,'vans'),
  	('Paradise','paradise',19000,'vans'),
  	('Rumpo','rumpo',15000,'vans'),
  	('Rumpo Trail','rumpo3',19500,'vans'),
  	('Surfer','surfer',12000,'vans'),
  	('Youga','youga',10800,'vans'),
  	('Youga Luxuary','youga2',14500,'vans'),
  	('Asea','asea',5500,'sedans'),
  	('Cognoscenti','cognoscenti',55000,'sedans'),
  	('Emperor','emperor',8500,'sedans'),
  	('Fugitive','fugitive',12000,'sedans'),
  	('Glendale','glendale',6500,'sedans'),
  	('Intruder','intruder',7500,'sedans'),
  	('Premier','premier',8000,'sedans'),
  	('Primo Custom','primo2',14000,'sedans'),
  	('Regina','regina',5000,'sedans'),
  	('Schafter','schafter2',25000,'sedans'),
  	('Stretch','stretch',90000,'sedans'),
  	('Super Diamond','superd',130000,'sedans'),
  	('Tailgater','tailgater',30000,'sedans'),
  	('Warrener','warrener',4000,'sedans'),
  	('Washington','washington',9000,'sedans'),
  	('Baller','baller2',40000,'suvs'),
  	('Baller Sport','baller3',60000,'suvs'),
  	('Cavalcade','cavalcade2',55000,'suvs'),
  	('Contender','contender',70000,'suvs'),
  	('Dubsta','dubsta',45000,'suvs'),
  	('Dubsta Luxuary','dubsta2',60000,'suvs'),
  	('Fhantom','fq2',17000,'suvs'),
  	('Grabger','granger',50000,'suvs'),
  	('Gresley','gresley',47500,'suvs'),
  	('Huntley S','huntley',40000,'suvs'),
  	('Landstalker','landstalker',35000,'suvs'),
  	('Mesa','mesa',16000,'suvs'),
  	('Mesa Trail','mesa3',40000,'suvs'),
  	('Patriot','patriot',55000,'suvs'),
  	('Radius','radi',29000,'suvs'),
  	('Rocoto','rocoto',45000,'suvs'),
  	('Seminole','seminole',25000,'suvs'),
  	('XLS','xls',32000,'suvs'),
  	('Btype','btype',62000,'sportsclassics'),
  	('Btype Luxe','btype3',85000,'sportsclassics'),
  	('Btype Hotroad','btype2',155000,'sportsclassics'),
  	('Casco','casco',30000,'sportsclassics'),
  	('Coquette Classic','coquette2',40000,'sportsclassics'),
  	('Manana','manana',12800,'sportsclassics'),
  	('Monroe','monroe',55000,'sportsclassics'),
  	('Pigalle','pigalle',20000,'sportsclassics'),
  	('Stinger','stinger',80000,'sportsclassics'),
  	('Stinger GT','stingergt',75000,'sportsclassics'),
  	('Stirling GT','feltzer3',65000,'sportsclassics'),
  	('Z-Type','ztype',220000,'sportsclassics'),
  	('Bifta','bifta',12000,'offroad'),
  	('Bf Injection','bfinjection',16000,'offroad'),
  	('Blazer','blazer',6500,'offroad'),
  	('Blazer Sport','blazer4',8500,'offroad'),
  	('Brawler','brawler',45000,'offroad'),
  	('Bubsta 6x6','dubsta3',120000,'offroad'),
  	('Dune Buggy','dune',8000,'offroad'),
  	('Guardian','guardian',45000,'offroad'),
  	('Rebel','rebel2',35000,'offroad'),
  	('Sandking','sandking',55000,'offroad'),
  	('The Liberator','monster',210000,'offroad'),
  	('Trophy Truck','trophytruck',60000,'offroad'),
  	('Trophy Truck Limited','trophytruck2',80000,'offroad'),
  	('Cognoscenti Cabrio','cogcabrio',55000,'coupes'),
  	('Exemplar','exemplar',32000,'coupes'),
  	('F620','f620',40000,'coupes'),
  	('Felon','felon',42000,'coupes'),
  	('Felon GT','felon2',55000,'coupes'),
  	('Jackal','jackal',38000,'coupes'),
  	('Oracle XS','oracle2',35000,'coupes'),
  	('Sentinel','sentinel',32000,'coupes'),
  	('Sentinel XS','sentinel2',40000,'coupes'),
  	('Windsor','windsor',95000,'coupes'),
  	('Windsor Drop','windsor2',125000,'coupes'),
  	('Zion','zion',36000,'coupes'),
  	('Zion Cabrio','zion2',45000,'coupes'),
  	('9F','ninef',65000,'sports'),
  	('9F Cabrio','ninef2',80000,'sports'),
  	('Alpha','alpha',60000,'sports'),
  	('Banshee','banshee',70000,'sports'),
  	('Bestia GTS','bestiagts',55000,'sports'),
  	('Buffalo','buffalo',12000,'sports'),
  	('Buffalo S','buffalo2',20000,'sports'),
  	('Carbonizzare','carbonizzare',75000,'sports'),
  	('Comet','comet2',65000,'sports'),
  	('Coquette','coquette',65000,'sports'),
  	('Drift Tampa','tampa2',80000,'sports'),
  	('Elegy','elegy2',38500,'sports'),
  	('Feltzer','feltzer2',55000,'sports'),
  	('Furore GT','furoregt',45000,'sports'),
  	('Fusilade','fusilade',40000,'sports'),
  	('Jester','jester',65000,'sports'),
  	('Jester(Racecar)','jester2',135000,'sports'),
  	('Khamelion','khamelion',38000,'sports'),
  	('Kuruma','kuruma',30000,'sports'),
  	('Lynx','lynx',40000,'sports'),
  	('Mamba','mamba',70000,'sports'),
  	('Massacro','massacro',65000,'sports'),
  	('Massacro(Racecar)','massacro2',130000,'sports'),
  	('Omnis','omnis',35000,'sports'),
  	('Penumbra','penumbra',28000,'sports'),
  	('Rapid GT','rapidgt',35000,'sports'),
  	('Rapid GT Convertible','rapidgt2',45000,'sports'),
  	('Schafter V12','schafter3',50000,'sports'),
  	('Seven 70','seven70',39500,'sports'),
  	('Sultan','sultan',15000,'sports'),
  	('Surano','surano',50000,'sports'),
  	('Tropos','tropos',40000,'sports'),
  	('Verlierer','verlierer2',70000,'sports'),
  	('Adder','adder',900000,'super'),
  	('Banshee 900R','banshee2',255000,'super'),
  	('Bullet','bullet',90000,'super'),
  	('Cheetah','cheetah',375000,'super'),
  	('Entity XF','entityxf',425000,'super'),
  	('ETR1','sheava',220000,'super'),
  	('FMJ','fmj',185000,'super'),
  	('Infernus','infernus',180000,'super'),
  	('Osiris','osiris',160000,'super'),
  	('Pfister','pfister811',85000,'super'),
  	('RE-7B','le7b',325000,'super'),
  	('Reaper','reaper',150000,'super'),
  	('Sultan RS','sultanrs',65000,'super'),
  	('T20','t20',300000,'super'),
  	('Turismo R','turismor',350000,'super'),
  	('Tyrus','tyrus',600000,'super'),
  	('Vacca','vacca',120000,'super'),
  	('Voltic','voltic',90000,'super'),
  	('X80 Proto','prototipo',2500000,'super'),
  	('Zentorno','zentorno',1500000,'super'),
  	('Akuma','AKUMA',7500,'motorcycles'),
  	('Avarus','avarus',18000,'motorcycles'),
  	('Bagger','bagger',13500,'motorcycles'),
  	('Bati 801','bati',12000,'motorcycles'),
  	('Bati 801RR','bati2',19000,'motorcycles'),
  	('BF400','bf400',6500,'motorcycles'),
  	('BMX (velo)','bmx',160,'motorcycles'),
  	('Carbon RS','carbonrs',18000,'motorcycles'),
  	('Chimera','chimera',38000,'motorcycles'),
  	('Cliffhanger','cliffhanger',9500,'motorcycles'),
  	('Cruiser (velo)','cruiser',510,'motorcycles'),
  	('Daemon','daemon',11500,'motorcycles'),
  	('Daemon High','daemon2',13500,'motorcycles'),
  	('Defiler','defiler',9800,'motorcycles'),
  	('Double T','double',28000,'motorcycles'),
  	('Enduro','enduro',5500,'motorcycles'),
  	('Esskey','esskey',4200,'motorcycles'),
  	('Faggio','faggio',1900,'motorcycles'),
  	('Vespa','faggio2',2800,'motorcycles'),
  	('Fixter (velo)','fixter',225,'motorcycles'),
  	('Gargoyle','gargoyle',16500,'motorcycles'),
  	('Hakuchou','hakuchou',31000,'motorcycles'),
  	('Hakuchou Sport','hakuchou2',55000,'motorcycles'),
  	('Hexer','hexer',12000,'motorcycles'),
  	('Innovation','innovation',23500,'motorcycles'),
  	('Manchez','manchez',5300,'motorcycles'),
  	('Nemesis','nemesis',5800,'motorcycles'),
  	('Nightblade','nightblade',35000,'motorcycles'),
  	('PCJ-600','pcj',6200,'motorcycles'),
  	('Ruffian','ruffian',6800,'motorcycles'),
  	('Sanchez','sanchez',5300,'motorcycles'),
  	('Sanchez Sport','sanchez2',5300,'motorcycles'),
  	('Sanctus','sanctus',25000,'motorcycles'),
  	('Scorcher (velo)','scorcher',280,'motorcycles'),
  	('Sovereign','sovereign',22000,'motorcycles'),
  	('Shotaro Concept','shotaro',320000,'motorcycles'),
  	('Thrust','thrust',24000,'motorcycles'),
  	('Tri bike (velo)','tribike3',520,'motorcycles'),
  	('Vader','vader',7200,'motorcycles'),
  	('Vortex','vortex',9800,'motorcycles'),
  	('Woflsbane','wolfsbane',9000,'motorcycles'),
  	('Zombie','zombiea',9500,'motorcycles'),
  	('Zombie Luxuary','zombieb',12000,'motorcycles'),
  	('blazer5', 'blazer5', 1755600, 'offroad'),
  	('Ruiner 2', 'ruiner2', 5745600, 'muscle'),
  	('Voltic 2', 'voltic2', 3830400, 'super'),
  	('Ardent', 'ardent', 1150000, 'sportsclassics'),
  	('Oppressor', 'oppressor', 3524500, 'super'),
  	('Visione', 'visione', 2250000, 'super'),
  	('Retinue', 'retinue', 615000, 'sportsclassics'),
  	('Cyclone', 'cyclone', 1890000, 'super'), 
  	('Rapid GT3', 'rapidgt3', 885000, 'sportsclassics'),
  	('raiden', 'raiden', 1375000, 'sports'),
  	('Yosemite', 'yosemite', 485000, 'muscle'),
  	('Deluxo', 'deluxo', 4721500, 'sportsclassics'),
  	('Pariah', 'pariah', 1420000, 'sports'),
  	('Stromberg', 'stromberg', 3185350, 'sports'),
  	('SC 1', 'sc1', 1603000, 'super'),
  	('riata', 'riata', 380000, 'offroad'),
  	('Hermes', 'hermes', 535000, 'muscle'),
  	('Savestra', 'savestra', 990000, 'sportsclassics'),
  	('Streiter', 'streiter', 500000, 'sports'),
  	('Kamacho', 'kamacho', 345000, 'offroad'),
  	('GT 500', 'gt500', 785000, 'sportsclassics'),
  	('Z190', 'z190', 900000, 'sportsclassics'),
  	('Viseris', 'viseris', 875000, 'sportsclassics'),
  	('Autarch', 'autarch', 1955000, 'super'),
  	('Comet 5', 'comet5', 1145000, 'sports'), 
  	('Neon', 'neon', 1500000, 'sports'),
  	('Revolter', 'revolter', 1610000, 'sports'),
  	('Sentinel3', 'sentinel3', 650000, 'sports'),
  	('Hustler', 'hustler', 625000, 'muscle')
  ;
  