· 8 years ago · Jun 03, 2018, 05:52 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.1.32-MariaDB - mariadb.org binary distribution
4-- Server OS: Win32
5-- HeidiSQL Version: 9.5.0.5278
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-- Dumping database structure for essentialmode
16CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `essentialmode`;
18
19-- Dumping structure for table essentialmode.addon_account
20CREATE TABLE IF NOT EXISTS `addon_account` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `name` varchar(255) NOT NULL,
23 `label` varchar(255) NOT NULL,
24 `shared` int(11) NOT NULL,
25 PRIMARY KEY (`id`)
26) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
27
28-- Dumping data for table essentialmode.addon_account: ~3 rows (approximately)
29/*!40000 ALTER TABLE `addon_account` DISABLE KEYS */;
30INSERT INTO `addon_account` (`id`, `name`, `label`, `shared`) VALUES
31 (1, 'society_police', 'Police', 1),
32 (2, 'property_black_money', 'Money Sale Property', 0),
33 (3, 'society_cardealer', 'Concessionnaire', 1);
34/*!40000 ALTER TABLE `addon_account` ENABLE KEYS */;
35
36-- Dumping structure for table essentialmode.addon_account_data
37CREATE TABLE IF NOT EXISTS `addon_account_data` (
38 `id` int(11) NOT NULL AUTO_INCREMENT,
39 `account_name` varchar(255) DEFAULT NULL,
40 `money` double NOT NULL,
41 `owner` varchar(255) DEFAULT NULL,
42 PRIMARY KEY (`id`)
43) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
44
45-- Dumping data for table essentialmode.addon_account_data: ~3 rows (approximately)
46/*!40000 ALTER TABLE `addon_account_data` DISABLE KEYS */;
47INSERT INTO `addon_account_data` (`id`, `account_name`, `money`, `owner`) VALUES
48 (1, 'society_police', 0, NULL),
49 (2, 'property_black_money', 0, 'steam:110000109036197'),
50 (3, 'society_cardealer', 0, NULL);
51/*!40000 ALTER TABLE `addon_account_data` ENABLE KEYS */;
52
53-- Dumping structure for table essentialmode.addon_inventory
54CREATE TABLE IF NOT EXISTS `addon_inventory` (
55 `id` int(11) NOT NULL AUTO_INCREMENT,
56 `name` varchar(255) NOT NULL,
57 `label` varchar(255) NOT NULL,
58 `shared` int(11) NOT NULL,
59 PRIMARY KEY (`id`)
60) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
61
62-- Dumping data for table essentialmode.addon_inventory: ~3 rows (approximately)
63/*!40000 ALTER TABLE `addon_inventory` DISABLE KEYS */;
64INSERT INTO `addon_inventory` (`id`, `name`, `label`, `shared`) VALUES
65 (1, 'society_police', 'Police', 1),
66 (2, 'property', 'Property', 0),
67 (3, 'society_cardealer', 'Concesionnaire', 1);
68/*!40000 ALTER TABLE `addon_inventory` ENABLE KEYS */;
69
70-- Dumping structure for table essentialmode.addon_inventory_items
71CREATE TABLE IF NOT EXISTS `addon_inventory_items` (
72 `id` int(11) NOT NULL AUTO_INCREMENT,
73 `inventory_name` varchar(255) NOT NULL,
74 `name` varchar(255) NOT NULL,
75 `count` int(11) NOT NULL,
76 `owner` varchar(60) DEFAULT NULL,
77 PRIMARY KEY (`id`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80-- Dumping data for table essentialmode.addon_inventory_items: ~0 rows (approximately)
81/*!40000 ALTER TABLE `addon_inventory_items` DISABLE KEYS */;
82/*!40000 ALTER TABLE `addon_inventory_items` ENABLE KEYS */;
83
84-- Dumping structure for table essentialmode.billing
85CREATE TABLE IF NOT EXISTS `billing` (
86 `id` int(11) NOT NULL AUTO_INCREMENT,
87 `identifier` varchar(255) NOT NULL,
88 `sender` varchar(255) NOT NULL,
89 `target_type` varchar(50) NOT NULL,
90 `target` varchar(255) NOT NULL,
91 `label` varchar(255) NOT NULL,
92 `amount` int(11) NOT NULL,
93 PRIMARY KEY (`id`)
94) ENGINE=InnoDB DEFAULT CHARSET=latin1;
95
96-- Dumping data for table essentialmode.billing: ~0 rows (approximately)
97/*!40000 ALTER TABLE `billing` DISABLE KEYS */;
98/*!40000 ALTER TABLE `billing` ENABLE KEYS */;
99
100-- Dumping structure for table essentialmode.cardealer_vehicles
101CREATE TABLE IF NOT EXISTS `cardealer_vehicles` (
102 `id` int(11) NOT NULL AUTO_INCREMENT,
103 `vehicle` varchar(255) NOT NULL,
104 `price` int(11) NOT NULL,
105 PRIMARY KEY (`id`)
106) ENGINE=InnoDB DEFAULT CHARSET=latin1;
107
108-- Dumping data for table essentialmode.cardealer_vehicles: ~0 rows (approximately)
109/*!40000 ALTER TABLE `cardealer_vehicles` DISABLE KEYS */;
110/*!40000 ALTER TABLE `cardealer_vehicles` ENABLE KEYS */;
111
112-- Dumping structure for table essentialmode.characters
113CREATE TABLE IF NOT EXISTS `characters` (
114 `id` int(11) NOT NULL AUTO_INCREMENT,
115 `identifier` varchar(255) NOT NULL,
116 `firstname` varchar(255) NOT NULL,
117 `lastname` varchar(255) NOT NULL,
118 `dateofbirth` varchar(255) NOT NULL,
119 `sex` varchar(1) NOT NULL DEFAULT 'f',
120 `height` varchar(128) NOT NULL,
121 PRIMARY KEY (`id`)
122) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
123
124-- Dumping data for table essentialmode.characters: ~1 rows (approximately)
125/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
126INSERT INTO `characters` (`id`, `identifier`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`) VALUES
127 (1, 'steam:110000109036197', 'Jackson', 'Corleone', '1999/11/02', 'm', '180');
128/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
129
130-- Dumping structure for table essentialmode.datastore
131CREATE TABLE IF NOT EXISTS `datastore` (
132 `id` int(11) NOT NULL AUTO_INCREMENT,
133 `name` varchar(255) NOT NULL,
134 `label` varchar(255) NOT NULL,
135 `shared` int(11) NOT NULL,
136 PRIMARY KEY (`id`)
137) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
138
139-- Dumping data for table essentialmode.datastore: ~2 rows (approximately)
140/*!40000 ALTER TABLE `datastore` DISABLE KEYS */;
141INSERT INTO `datastore` (`id`, `name`, `label`, `shared`) VALUES
142 (1, 'society_police', 'Police', 1),
143 (2, 'property', 'Property', 0);
144/*!40000 ALTER TABLE `datastore` ENABLE KEYS */;
145
146-- Dumping structure for table essentialmode.datastore_data
147CREATE TABLE IF NOT EXISTS `datastore_data` (
148 `id` int(11) NOT NULL AUTO_INCREMENT,
149 `name` varchar(255) NOT NULL,
150 `owner` varchar(255) DEFAULT NULL,
151 `data` longtext,
152 PRIMARY KEY (`id`)
153) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
154
155-- Dumping data for table essentialmode.datastore_data: ~2 rows (approximately)
156/*!40000 ALTER TABLE `datastore_data` DISABLE KEYS */;
157INSERT INTO `datastore_data` (`id`, `name`, `owner`, `data`) VALUES
158 (1, 'society_police', NULL, '{}'),
159 (2, 'property', 'steam:110000109036197', '{}');
160/*!40000 ALTER TABLE `datastore_data` ENABLE KEYS */;
161
162-- Dumping structure for table essentialmode.fine_types
163CREATE TABLE IF NOT EXISTS `fine_types` (
164 `id` int(11) NOT NULL AUTO_INCREMENT,
165 `label` varchar(255) DEFAULT NULL,
166 `amount` int(11) DEFAULT NULL,
167 `category` int(11) DEFAULT NULL,
168 PRIMARY KEY (`id`)
169) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
170
171-- Dumping data for table essentialmode.fine_types: ~52 rows (approximately)
172/*!40000 ALTER TABLE `fine_types` DISABLE KEYS */;
173INSERT INTO `fine_types` (`id`, `label`, `amount`, `category`) VALUES
174 (1, 'Misuse of a horn', 30, 0),
175 (2, 'Illegally Crossing a continuous Line', 40, 0),
176 (3, 'Driving on the wrong side of the road', 250, 0),
177 (4, 'Illegal U-Turn', 250, 0),
178 (5, 'Illegally Driving Off-road', 170, 0),
179 (6, 'Refusing a Lawful Command', 30, 0),
180 (7, 'Illegally Stoped of a Vehicle', 150, 0),
181 (8, 'Illegal Parking', 70, 0),
182 (9, 'Failing to Yield to the right', 70, 0),
183 (10, 'Failure to comply with Vehicle Information', 90, 0),
184 (11, 'Failing to stop at a Stop Sign ', 105, 0),
185 (12, 'Failing to stop at a Red Light', 130, 0),
186 (13, 'Illegal Passing', 100, 0),
187 (14, 'Driving an illegal Vehicle', 100, 0),
188 (15, 'Driving without a License', 1500, 0),
189 (16, 'Hit and Run', 800, 0),
190 (17, 'Exceeding Speeds Over < 5 mph', 90, 0),
191 (18, 'Exceeding Speeds Over 5-15 mph', 120, 0),
192 (19, 'Exceeding Speeds Over 15-30 mph', 180, 0),
193 (20, 'Exceeding Speeds Over > 30 mph', 300, 0),
194 (21, 'Impeding traffic flow', 110, 1),
195 (22, 'Public Intoxication', 90, 1),
196 (23, 'Disorderly conduct', 90, 1),
197 (24, 'Obstruction of Justice', 130, 1),
198 (25, 'Insults towards Civilans', 75, 1),
199 (26, 'Disrespecting of an LEO', 110, 1),
200 (27, 'Verbal Threat towards a Civilan', 90, 1),
201 (28, 'Verbal Threat towards an LEO', 150, 1),
202 (29, 'Providing False Information', 250, 1),
203 (30, 'Attempt of Corruption', 1500, 1),
204 (31, 'Brandishing a weapon in city Limits', 120, 2),
205 (32, 'Brandishing a Lethal Weapon in city Limits', 300, 2),
206 (33, 'No Firearms License', 600, 2),
207 (34, 'Possession of an Illegal Weapon', 700, 2),
208 (35, 'Possession of Burglary Tools', 300, 2),
209 (36, 'Grand Theft Auto', 1800, 2),
210 (37, 'Intent to Sell/Distrube of an illegal Substance', 1500, 2),
211 (38, 'Frabrication of an Illegal Substance', 1500, 2),
212 (39, 'Possession of an Illegal Substance ', 650, 2),
213 (40, 'Kidnapping of a Civilan', 1500, 2),
214 (41, 'Kidnapping of an LEO', 2000, 2),
215 (42, 'Robbery', 650, 2),
216 (43, 'Armed Robbery of a Store', 650, 2),
217 (44, 'Armed Robbery of a Bank', 1500, 2),
218 (45, 'Assault on a Civilian', 2000, 3),
219 (46, 'Assault of an LEO', 2500, 3),
220 (47, 'Attempt of Murder of a Civilian', 3000, 3),
221 (48, 'Attempt of Murder of an LEO', 5000, 3),
222 (49, 'Murder of a Civilian', 10000, 3),
223 (50, 'Murder of an LEO', 30000, 3),
224 (51, 'Involuntary manslaughter', 1800, 3),
225 (52, 'Fraud', 2000, 2);
226/*!40000 ALTER TABLE `fine_types` ENABLE KEYS */;
227
228-- Dumping structure for table essentialmode.items
229CREATE TABLE IF NOT EXISTS `items` (
230 `name` varchar(50) NOT NULL,
231 `label` varchar(255) NOT NULL,
232 `limit` int(11) NOT NULL DEFAULT '-1',
233 `rare` int(11) NOT NULL DEFAULT '0',
234 `can_remove` int(11) NOT NULL DEFAULT '1',
235 PRIMARY KEY (`name`)
236) ENGINE=InnoDB DEFAULT CHARSET=latin1;
237
238-- Dumping data for table essentialmode.items: ~0 rows (approximately)
239/*!40000 ALTER TABLE `items` DISABLE KEYS */;
240/*!40000 ALTER TABLE `items` ENABLE KEYS */;
241
242-- Dumping structure for table essentialmode.jobs
243CREATE TABLE IF NOT EXISTS `jobs` (
244 `name` varchar(50) NOT NULL,
245 `label` varchar(255) DEFAULT NULL,
246 PRIMARY KEY (`name`)
247) ENGINE=InnoDB DEFAULT CHARSET=latin1;
248
249-- Dumping data for table essentialmode.jobs: ~3 rows (approximately)
250/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
251INSERT INTO `jobs` (`name`, `label`) VALUES
252 ('cardealer', 'Concessionnaire'),
253 ('police', 'LSPD'),
254 ('unemployed', 'Unemployed');
255/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
256
257-- Dumping structure for table essentialmode.job_grades
258CREATE TABLE IF NOT EXISTS `job_grades` (
259 `id` int(11) NOT NULL AUTO_INCREMENT,
260 `job_name` varchar(255) DEFAULT NULL,
261 `grade` int(11) NOT NULL,
262 `name` varchar(255) NOT NULL,
263 `label` varchar(255) NOT NULL,
264 `salary` int(11) NOT NULL,
265 `skin_male` longtext NOT NULL,
266 `skin_female` longtext NOT NULL,
267 PRIMARY KEY (`id`)
268) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
269
270-- Dumping data for table essentialmode.job_grades: ~12 rows (approximately)
271/*!40000 ALTER TABLE `job_grades` DISABLE KEYS */;
272INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
273 (1, 'unemployed', 0, 'unemployed', 'Unemployed', 200, '{}', '{}'),
274 (2, 'police', 0, 'recruit', 'Cadet', 20, '{}', '{}'),
275 (3, 'police', 1, 'officer', 'Officer', 40, '{}', '{}'),
276 (4, 'police', 2, 'snrofficer', 'Senior Officer', 60, '{}', '{}'),
277 (5, 'police', 4, 'corporal', 'Corporal', 85, '{}', '{}'),
278 (6, 'police', 5, 'sergeant', 'Sergeant', 100, '{}', '{}'),
279 (7, 'police', 6, 'lieutenant', 'Lieutenant', 120, '{}', '{}'),
280 (8, 'police', 7, 'boss', 'Captain', 200, '{}', '{}'),
281 (9, 'cardealer', 0, 'recruit', 'Recrue', 10, '{}', '{}'),
282 (10, 'cardealer', 1, 'novice', 'Novice', 25, '{}', '{}'),
283 (11, 'cardealer', 2, 'experienced', 'Experimente', 40, '{}', '{}'),
284 (12, 'cardealer', 3, 'boss', 'Patron', 0, '{}', '{}');
285/*!40000 ALTER TABLE `job_grades` ENABLE KEYS */;
286
287-- Dumping structure for table essentialmode.licenses
288CREATE TABLE IF NOT EXISTS `licenses` (
289 `type` varchar(60) NOT NULL,
290 `label` varchar(60) NOT NULL,
291 PRIMARY KEY (`type`)
292) ENGINE=InnoDB DEFAULT CHARSET=latin1;
293
294-- Dumping data for table essentialmode.licenses: ~1 rows (approximately)
295/*!40000 ALTER TABLE `licenses` DISABLE KEYS */;
296INSERT INTO `licenses` (`type`, `label`) VALUES
297 ('weapon', 'Permis de port d\'arme');
298/*!40000 ALTER TABLE `licenses` ENABLE KEYS */;
299
300-- Dumping structure for table essentialmode.owned_properties
301CREATE TABLE IF NOT EXISTS `owned_properties` (
302 `id` int(11) NOT NULL AUTO_INCREMENT,
303 `name` varchar(255) NOT NULL,
304 `price` double NOT NULL,
305 `rented` int(11) NOT NULL,
306 `owner` varchar(60) NOT NULL,
307 PRIMARY KEY (`id`)
308) ENGINE=InnoDB DEFAULT CHARSET=latin1;
309
310-- Dumping data for table essentialmode.owned_properties: ~0 rows (approximately)
311/*!40000 ALTER TABLE `owned_properties` DISABLE KEYS */;
312/*!40000 ALTER TABLE `owned_properties` ENABLE KEYS */;
313
314-- Dumping structure for table essentialmode.owned_vehicles
315CREATE TABLE IF NOT EXISTS `owned_vehicles` (
316 `id` int(11) NOT NULL AUTO_INCREMENT,
317 `vehicle` longtext NOT NULL,
318 `owner` varchar(60) NOT NULL,
319 PRIMARY KEY (`id`)
320) ENGINE=InnoDB DEFAULT CHARSET=latin1;
321
322-- Dumping data for table essentialmode.owned_vehicles: ~0 rows (approximately)
323/*!40000 ALTER TABLE `owned_vehicles` DISABLE KEYS */;
324/*!40000 ALTER TABLE `owned_vehicles` ENABLE KEYS */;
325
326-- Dumping structure for table essentialmode.properties
327CREATE TABLE IF NOT EXISTS `properties` (
328 `id` int(11) NOT NULL AUTO_INCREMENT,
329 `name` varchar(255) DEFAULT NULL,
330 `label` varchar(255) DEFAULT NULL,
331 `entering` varchar(255) DEFAULT NULL,
332 `exit` varchar(255) DEFAULT NULL,
333 `inside` varchar(255) DEFAULT NULL,
334 `outside` varchar(255) DEFAULT NULL,
335 `ipls` varchar(255) DEFAULT '[]',
336 `gateway` varchar(255) DEFAULT NULL,
337 `is_single` int(11) DEFAULT NULL,
338 `is_room` int(11) DEFAULT NULL,
339 `is_gateway` int(11) DEFAULT NULL,
340 `room_menu` varchar(255) DEFAULT NULL,
341 `price` int(11) NOT NULL,
342 PRIMARY KEY (`id`)
343) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;
344
345-- Dumping data for table essentialmode.properties: ~72 rows (approximately)
346/*!40000 ALTER TABLE `properties` DISABLE KEYS */;
347INSERT INTO `properties` (`id`, `name`, `label`, `entering`, `exit`, `inside`, `outside`, `ipls`, `gateway`, `is_single`, `is_room`, `is_gateway`, `room_menu`, `price`) VALUES
348 (1, 'WhispymoundDrive', '2677 Whispymound Drive', '{"y":564.89,"z":182.959,"x":119.384}', '{"x":117.347,"y":559.506,"z":183.304}', '{"y":557.032,"z":183.301,"x":118.037}', '{"y":567.798,"z":182.131,"x":119.249}', '[]', NULL, 1, 1, 0, '{"x":118.748,"y":566.573,"z":175.697}', 1500000),
349 (2, 'NorthConkerAvenue2045', '2045 North Conker Avenue', '{"x":372.796,"y":428.327,"z":144.685}', '{"x":373.548,"y":422.982,"z":144.907},', '{"y":420.075,"z":145.904,"x":372.161}', '{"x":372.454,"y":432.886,"z":143.443}', '[]', NULL, 1, 1, 0, '{"x":377.349,"y":429.422,"z":137.3}', 1500000),
350 (3, 'RichardMajesticApt2', 'Richard Majestic, Apt 2', '{"y":-379.165,"z":37.961,"x":-936.363}', '{"y":-365.476,"z":113.274,"x":-913.097}', '{"y":-367.637,"z":113.274,"x":-918.022}', '{"y":-382.023,"z":37.961,"x":-943.626}', '[]', NULL, 1, 1, 0, '{"x":-927.554,"y":-377.744,"z":112.674}', 1700000),
351 (4, 'NorthConkerAvenue2044', '2044 North Conker Avenue', '{"y":440.8,"z":146.702,"x":346.964}', '{"y":437.456,"z":148.394,"x":341.683}', '{"y":435.626,"z":148.394,"x":339.595}', '{"x":350.535,"y":443.329,"z":145.764}', '[]', NULL, 1, 1, 0, '{"x":337.726,"y":436.985,"z":140.77}', 1500000),
352 (5, 'WildOatsDrive', '3655 Wild Oats Drive', '{"y":502.696,"z":136.421,"x":-176.003}', '{"y":497.817,"z":136.653,"x":-174.349}', '{"y":495.069,"z":136.666,"x":-173.331}', '{"y":506.412,"z":135.0664,"x":-177.927}', '[]', NULL, 1, 1, 0, '{"x":-174.725,"y":493.095,"z":129.043}', 1500000),
353 (6, 'HillcrestAvenue2862', '2862 Hillcrest Avenue', '{"y":596.58,"z":142.641,"x":-686.554}', '{"y":591.988,"z":144.392,"x":-681.728}', '{"y":590.608,"z":144.392,"x":-680.124}', '{"y":599.019,"z":142.059,"x":-689.492}', '[]', NULL, 1, 1, 0, '{"x":-680.46,"y":588.6,"z":136.769}', 1500000),
354 (7, 'LowEndApartment', 'Basic apartment', '{"y":-1078.735,"z":28.4031,"x":292.528}', '{"y":-1007.152,"z":-102.002,"x":265.845}', '{"y":-1002.802,"z":-100.008,"x":265.307}', '{"y":-1078.669,"z":28.401,"x":296.738}', '[]', NULL, 1, 1, 0, '{"x":265.916,"y":-999.38,"z":-100.008}', 562500),
355 (8, 'MadWayneThunder', '2113 Mad Wayne Thunder', '{"y":454.955,"z":96.462,"x":-1294.433}', '{"x":-1289.917,"y":449.541,"z":96.902}', '{"y":446.322,"z":96.899,"x":-1289.642}', '{"y":455.453,"z":96.517,"x":-1298.851}', '[]', NULL, 1, 1, 0, '{"x":-1287.306,"y":455.901,"z":89.294}', 1500000),
356 (9, 'HillcrestAvenue2874', '2874 Hillcrest Avenue', '{"x":-853.346,"y":696.678,"z":147.782}', '{"y":690.875,"z":151.86,"x":-859.961}', '{"y":688.361,"z":151.857,"x":-859.395}', '{"y":701.628,"z":147.773,"x":-855.007}', '[]', NULL, 1, 1, 0, '{"x":-858.543,"y":697.514,"z":144.253}', 1500000),
357 (10, 'HillcrestAvenue2868', '2868 Hillcrest Avenue', '{"y":620.494,"z":141.588,"x":-752.82}', '{"y":618.62,"z":143.153,"x":-759.317}', '{"y":617.629,"z":143.153,"x":-760.789}', '{"y":621.281,"z":141.254,"x":-750.919}', '[]', NULL, 1, 1, 0, '{"x":-762.504,"y":618.992,"z":135.53}', 1500000),
358 (11, 'TinselTowersApt12', 'Tinsel Towers, Apt 42', '{"y":37.025,"z":42.58,"x":-618.299}', '{"y":58.898,"z":97.2,"x":-603.301}', '{"y":58.941,"z":97.2,"x":-608.741}', '{"y":30.603,"z":42.524,"x":-620.017}', '[]', NULL, 1, 1, 0, '{"x":-622.173,"y":54.585,"z":96.599}', 1700000),
359 (12, 'MiltonDrive', 'Milton Drive', '{"x":-775.17,"y":312.01,"z":84.658}', NULL, NULL, '{"x":-775.346,"y":306.776,"z":84.7}', '[]', NULL, 0, 0, 1, NULL, 0),
360 (13, 'Modern1Apartment', 'Modern Apartment 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_01_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.661,"y":327.672,"z":210.396}', 1300000),
361 (14, 'Modern2Apartment', 'Modern Apartment 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_01_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.735,"y":326.757,"z":186.313}', 1300000),
362 (15, 'Modern3Apartment', 'Modern Apartment 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_01_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.386,"y":330.782,"z":195.08}', 1300000),
363 (16, 'Mody1Apartment', 'Mody Apartment 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_02_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.615,"y":327.878,"z":210.396}', 1300000),
364 (17, 'Mody2Apartment', 'Mody Apartment 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_02_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.297,"y":327.092,"z":186.313}', 1300000),
365 (18, 'Mody3Apartment', 'Mody Apartment 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_02_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.303,"y":330.932,"z":195.085}', 1300000),
366 (19, 'Vibrant1Apartment', 'Vibrant Apartment 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_03_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.885,"y":327.641,"z":210.396}', 1300000),
367 (20, 'Vibrant2Apartment', 'Vibrant Apartment 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_03_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.607,"y":327.344,"z":186.313}', 1300000),
368 (21, 'Vibrant3Apartment', 'Vibrant Apartment 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_03_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.525,"y":330.851,"z":195.085}', 1300000),
369 (22, 'Sharp1Apartment', 'Sharp Apartment 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_04_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.527,"y":327.89,"z":210.396}', 1300000),
370 (23, 'Sharp2Apartment', 'Sharp Apartment 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_04_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.642,"y":326.497,"z":186.313}', 1300000),
371 (24, 'Sharp3Apartment', 'Sharp Apartment 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_04_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.503,"y":331.318,"z":195.085}', 1300000),
372 (25, 'Monochrome1Apartment', 'Monochrome Apartment 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_05_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.289,"y":328.086,"z":210.396}', 1300000),
373 (26, 'Monochrome2Apartment', 'Monochrome Apartment 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_05_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.692,"y":326.762,"z":186.313}', 1300000),
374 (27, 'Monochrome3Apartment', 'Monochrome Apartment 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_05_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.094,"y":330.976,"z":195.085}', 1300000),
375 (28, 'Seductive1Apartment', 'Seductive Apartment 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_06_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.263,"y":328.104,"z":210.396}', 1300000),
376 (29, 'Seductive2Apartment', 'Seductive Apartment 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_06_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.655,"y":326.611,"z":186.313}', 1300000),
377 (30, 'Seductive3Apartment', 'Seductive Apartment 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_06_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.3,"y":331.414,"z":195.085}', 1300000),
378 (31, 'Regal1Apartment', 'Regal Apartment 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_07_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.956,"y":328.257,"z":210.396}', 1300000),
379 (32, 'Regal2Apartment', 'Regal Apartment 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_07_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.545,"y":326.659,"z":186.313}', 1300000),
380 (33, 'Regal3Apartment', 'Regal Apartment 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_07_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.087,"y":331.429,"z":195.123}', 1300000),
381 (34, 'Aqua1Apartment', 'Aqua Apartment 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_08_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.187,"y":328.47,"z":210.396}', 1300000),
382 (35, 'Aqua2Apartment', 'Aqua Apartment 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_08_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.658,"y":326.563,"z":186.313}', 1300000),
383 (36, 'Aqua3Apartment', 'Aqua Apartment 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_08_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.287,"y":331.084,"z":195.086}', 1300000),
384 (37, 'IntegrityWay', '4 Integrity Way', '{"x":-47.804,"y":-585.867,"z":36.956}', NULL, NULL, '{"x":-54.178,"y":-583.762,"z":35.798}', '[]', NULL, 0, 0, 1, NULL, 0),
385 (38, 'IntegrityWay28', '4 Integrity Way - Apt 28', NULL, '{"x":-31.409,"y":-594.927,"z":79.03}', '{"x":-26.098,"y":-596.909,"z":79.03}', NULL, '[]', 'IntegrityWay', 0, 1, 0, '{"x":-11.923,"y":-597.083,"z":78.43}', 1700000),
386 (39, 'IntegrityWay30', '4 Integrity Way - Apt 30', NULL, '{"x":-17.702,"y":-588.524,"z":89.114}', '{"x":-16.21,"y":-582.569,"z":89.114}', NULL, '[]', 'IntegrityWay', 0, 1, 0, '{"x":-26.327,"y":-588.384,"z":89.123}', 1700000),
387 (40, 'DellPerroHeights', 'Dell Perro Heights', '{"x":-1447.06,"y":-538.28,"z":33.74}', NULL, NULL, '{"x":-1440.022,"y":-548.696,"z":33.74}', '[]', NULL, 0, 0, 1, NULL, 0),
388 (41, 'DellPerroHeightst4', 'Dell Perro Heights - Apt 28', NULL, '{"x":-1452.125,"y":-540.591,"z":73.044}', '{"x":-1455.435,"y":-535.79,"z":73.044}', NULL, '[]', 'DellPerroHeights', 0, 1, 0, '{"x":-1467.058,"y":-527.571,"z":72.443}', 1700000),
389 (42, 'DellPerroHeightst7', 'Dell Perro Heights - Apt 30', NULL, '{"x":-1451.562,"y":-523.535,"z":55.928}', '{"x":-1456.02,"y":-519.209,"z":55.929}', NULL, '[]', 'DellPerroHeights', 0, 1, 0, '{"x":-1457.026,"y":-530.219,"z":55.937}', 1700000),
390 (43, 'MazeBankBuilding', 'Maze Bank Building', '{"x":-79.18,"y":-795.92,"z":43.35}', NULL, NULL, '{"x":-72.50,"y":-786.92,"z":43.40}', '[]', NULL, 0, 0, 1, NULL, 0),
391 (44, 'OldSpiceWarm', 'Old Spice Warm', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_01a"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
392 (45, 'OldSpiceClassical', 'Old Spice Classical', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_01b"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
393 (46, 'OldSpiceVintage', 'Old Spice Vintage', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_01c"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
394 (47, 'ExecutiveRich', 'Executive Rich', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_02b"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
395 (48, 'ExecutiveCool', 'Executive Cool', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_02c"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
396 (49, 'ExecutiveContrast', 'Executive Contrast', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_02a"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
397 (50, 'PowerBrokerIce', 'Power Broker Ice', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_03a"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
398 (51, 'PowerBrokerConservative', 'Power Broker Conservative', NULL, '', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_03b"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
399 (52, 'PowerBrokerPolished', 'Power Broker Polished', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"x":-75.51,"y":-823.90,"z":242.43}', NULL, '["ex_dt1_11_office_03c"]', 'MazeBankBuilding', 0, 1, 0, '{"x":-71.81,"y":-814.34,"z":242.39}', 5000000),
400 (53, 'LomBank', 'Lom Bank', '{"x":-1581.36,"y":-558.23,"z":34.07}', NULL, NULL, '{"x":-1583.60,"y":-555.12,"z":34.07}', '[]', NULL, 0, 0, 1, NULL, 0),
401 (54, 'LBOldSpiceWarm', 'LB Old Spice Warm', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_01a"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
402 (55, 'LBOldSpiceClassical', 'LB Old Spice Classical', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_01b"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
403 (56, 'LBOldSpiceVintage', 'LB Old Spice Vintage', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_01c"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
404 (57, 'LBExecutiveRich', 'LB Executive Rich', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_02b"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
405 (58, 'LBExecutiveCool', 'LB Executive Cool', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_02c"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
406 (59, 'LBExecutiveContrast', 'LB Executive Contrast', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_02a"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
407 (60, 'LBPowerBrokerIce', 'LB Power Broker Ice', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_03a"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
408 (61, 'LBPowerBrokerConservative', 'LB Power Broker Conservative', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_03b"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
409 (62, 'LBPowerBrokerPolished', 'LB Power Broker Polished', NULL, '{"x":-1579.53,"y":-564.89,"z":107.62}', '{"x":-1576.42,"y":-567.57,"z":107.62}', NULL, '["ex_sm_13_office_03c"]', 'LomBank', 0, 1, 0, '{"x":-1571.26,"y":-575.76,"z":107.52}', 3500000),
410 (63, 'MazeBankWest', 'Maze Bank West', '{"x":-1379.58,"y":-499.63,"z":32.22}', NULL, NULL, '{"x":-1378.95,"y":-502.82,"z":32.22}', '[]', NULL, 0, 0, 1, NULL, 0),
411 (64, 'MBWOldSpiceWarm', 'MBW Old Spice Warm', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_01a"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000),
412 (65, 'MBWOldSpiceClassical', 'MBW Old Spice Classical', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_01b"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000),
413 (66, 'MBWOldSpiceVintage', 'MBW Old Spice Vintage', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_01c"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000),
414 (67, 'MBWExecutiveRich', 'MBW Executive Rich', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_02b"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000),
415 (68, 'MBWExecutiveCool', 'MBW Executive Cool', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_02c"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000),
416 (69, 'MBWExecutive Contrast', 'MBW Executive Contrast', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_02a"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000),
417 (70, 'MBWPowerBrokerIce', 'MBW Power Broker Ice', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_03a"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000),
418 (71, 'MBWPowerBrokerConvservative', 'MBW Power Broker Convservative', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_03b"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000),
419 (72, 'MBWPowerBrokerPolished', 'MBW Power Broker Polished', NULL, '{"x":-1392.74,"y":-480.18,"z":71.14}', '{"x":-1389.43,"y":-479.01,"z":71.14}', NULL, '["ex_sm_15_office_03c"]', 'MazeBankWest', 0, 1, 0, '{"x":-1390.76,"y":-479.22,"z":72.04}', 2700000);
420/*!40000 ALTER TABLE `properties` ENABLE KEYS */;
421
422-- Dumping structure for table essentialmode.rented_vehicles
423CREATE TABLE IF NOT EXISTS `rented_vehicles` (
424 `id` int(11) NOT NULL AUTO_INCREMENT,
425 `vehicle` varchar(60) NOT NULL,
426 `plate` varchar(10) NOT NULL,
427 `player_name` varchar(255) NOT NULL,
428 `base_price` int(11) NOT NULL,
429 `rent_price` int(11) NOT NULL,
430 `owner` varchar(255) NOT NULL,
431 PRIMARY KEY (`id`)
432) ENGINE=InnoDB DEFAULT CHARSET=latin1;
433
434-- Dumping data for table essentialmode.rented_vehicles: ~0 rows (approximately)
435/*!40000 ALTER TABLE `rented_vehicles` DISABLE KEYS */;
436/*!40000 ALTER TABLE `rented_vehicles` ENABLE KEYS */;
437
438-- Dumping structure for table essentialmode.shops
439CREATE TABLE IF NOT EXISTS `shops` (
440 `id` int(11) NOT NULL AUTO_INCREMENT,
441 `name` varchar(255) NOT NULL,
442 `item` varchar(255) NOT NULL,
443 `price` int(11) NOT NULL,
444 PRIMARY KEY (`id`)
445) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
446
447-- Dumping data for table essentialmode.shops: ~6 rows (approximately)
448/*!40000 ALTER TABLE `shops` DISABLE KEYS */;
449INSERT INTO `shops` (`id`, `name`, `item`, `price`) VALUES
450 (1, 'TwentyFourSeven', 'bread', 30),
451 (2, 'TwentyFourSeven', 'water', 15),
452 (3, 'RobsLiquor', 'bread', 30),
453 (4, 'RobsLiquor', 'water', 15),
454 (5, 'LTDgasoline', 'bread', 30),
455 (6, 'LTDgasoline', 'water', 15);
456/*!40000 ALTER TABLE `shops` ENABLE KEYS */;
457
458-- Dumping structure for table essentialmode.society_moneywash
459CREATE TABLE IF NOT EXISTS `society_moneywash` (
460 `id` int(11) NOT NULL AUTO_INCREMENT,
461 `identifier` varchar(60) NOT NULL,
462 `society` varchar(60) NOT NULL,
463 `amount` int(11) NOT NULL,
464 PRIMARY KEY (`id`)
465) ENGINE=InnoDB DEFAULT CHARSET=latin1;
466
467-- Dumping data for table essentialmode.society_moneywash: ~0 rows (approximately)
468/*!40000 ALTER TABLE `society_moneywash` DISABLE KEYS */;
469/*!40000 ALTER TABLE `society_moneywash` ENABLE KEYS */;
470
471-- Dumping structure for table essentialmode.users
472CREATE TABLE IF NOT EXISTS `users` (
473 `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
474 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
475 `money` int(11) DEFAULT NULL,
476 `name` varchar(255) COLLATE utf8mb4_bin DEFAULT '',
477 `skin` longtext COLLATE utf8mb4_bin,
478 `job` varchar(255) COLLATE utf8mb4_bin DEFAULT 'unemployed',
479 `job_grade` int(11) DEFAULT '0',
480 `loadout` longtext COLLATE utf8mb4_bin,
481 `position` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
482 `bank` int(11) DEFAULT NULL,
483 `permission_level` int(11) DEFAULT NULL,
484 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
485 `firstname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
486 `lastname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
487 `dateofbirth` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
488 `sex` varchar(10) COLLATE utf8mb4_bin DEFAULT '',
489 `height` varchar(5) COLLATE utf8mb4_bin DEFAULT '',
490 `last_property` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL
491) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
492
493-- Dumping data for table essentialmode.users: ~1 rows (approximately)
494/*!40000 ALTER TABLE `users` DISABLE KEYS */;
495INSERT INTO `users` (`identifier`, `license`, `money`, `name`, `skin`, `job`, `job_grade`, `loadout`, `position`, `bank`, `permission_level`, `group`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`, `last_property`) VALUES
496 ('steam:110000109036197', 'license:548d3cb00cc4f8f60b0d60ed804026aec87e5134', 94150, 'Opti', '{"ears_2":0,"pants_1":0,"arms":0,"beard_3":0,"age_2":0,"shoes_1":0,"helmet_2":0,"bproof_2":0,"lipstick_3":0,"bags_1":0,"ears_1":-1,"bproof_1":0,"makeup_4":0,"lipstick_1":0,"chain_2":0,"eyebrows_1":0,"decals_1":0,"helmet_1":-1,"lipstick_2":0,"glasses_2":0,"beard_4":0,"shoes_2":0,"makeup_2":0,"eyebrows_4":0,"beard_2":0,"lipstick_4":0,"torso_1":0,"decals_2":0,"tshirt_2":0,"skin":0,"hair_2":0,"tshirt_1":0,"mask_2":0,"eyebrows_3":0,"eyebrows_2":0,"glasses_1":0,"makeup_3":0,"hair_color_2":0,"mask_1":0,"hair_1":0,"torso_2":0,"face":0,"hair_color_1":0,"makeup_1":0,"chain_1":0,"age_1":0,"sex":0,"bags_2":0,"pants_2":0,"beard_1":0}', 'police', 7, '[]', '{"y":-1283.8619384766,"z":29.278722763062,"x":127.38172149658}', 10000, 0, 'superadmin', 'Jackson', 'Corleone', '1999/11/02', 'm', '180', NULL);
497/*!40000 ALTER TABLE `users` ENABLE KEYS */;
498
499-- Dumping structure for table essentialmode.user_accounts
500CREATE TABLE IF NOT EXISTS `user_accounts` (
501 `id` int(11) NOT NULL AUTO_INCREMENT,
502 `identifier` varchar(255) NOT NULL,
503 `name` varchar(255) NOT NULL,
504 `money` double NOT NULL DEFAULT '0',
505 PRIMARY KEY (`id`)
506) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
507
508-- Dumping data for table essentialmode.user_accounts: ~1 rows (approximately)
509/*!40000 ALTER TABLE `user_accounts` DISABLE KEYS */;
510INSERT INTO `user_accounts` (`id`, `identifier`, `name`, `money`) VALUES
511 (1, 'steam:110000109036197', 'black_money', 0);
512/*!40000 ALTER TABLE `user_accounts` ENABLE KEYS */;
513
514-- Dumping structure for table essentialmode.user_inventory
515CREATE TABLE IF NOT EXISTS `user_inventory` (
516 `id` int(11) NOT NULL AUTO_INCREMENT,
517 `identifier` varchar(255) NOT NULL,
518 `item` varchar(255) NOT NULL,
519 `count` int(11) NOT NULL,
520 PRIMARY KEY (`id`)
521) ENGINE=InnoDB DEFAULT CHARSET=latin1;
522
523-- Dumping data for table essentialmode.user_inventory: ~0 rows (approximately)
524/*!40000 ALTER TABLE `user_inventory` DISABLE KEYS */;
525/*!40000 ALTER TABLE `user_inventory` ENABLE KEYS */;
526
527-- Dumping structure for table essentialmode.user_licenses
528CREATE TABLE IF NOT EXISTS `user_licenses` (
529 `id` int(11) NOT NULL AUTO_INCREMENT,
530 `type` varchar(60) NOT NULL,
531 `owner` varchar(60) NOT NULL,
532 PRIMARY KEY (`id`)
533) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
534
535-- Dumping data for table essentialmode.user_licenses: ~1 rows (approximately)
536/*!40000 ALTER TABLE `user_licenses` DISABLE KEYS */;
537INSERT INTO `user_licenses` (`id`, `type`, `owner`) VALUES
538 (1, 'weapon', 'steam:110000109036197');
539/*!40000 ALTER TABLE `user_licenses` ENABLE KEYS */;
540
541-- Dumping structure for table essentialmode.user_parkings
542CREATE TABLE IF NOT EXISTS `user_parkings` (
543 `id` int(11) NOT NULL AUTO_INCREMENT,
544 `identifier` varchar(60) DEFAULT NULL,
545 `garage` varchar(60) DEFAULT NULL,
546 `zone` int(11) NOT NULL,
547 `vehicle` longtext,
548 PRIMARY KEY (`id`)
549) ENGINE=InnoDB DEFAULT CHARSET=latin1;
550
551-- Dumping data for table essentialmode.user_parkings: ~0 rows (approximately)
552/*!40000 ALTER TABLE `user_parkings` DISABLE KEYS */;
553/*!40000 ALTER TABLE `user_parkings` ENABLE KEYS */;
554
555-- Dumping structure for table essentialmode.vehicles
556CREATE TABLE IF NOT EXISTS `vehicles` (
557 `name` varchar(60) NOT NULL,
558 `model` varchar(60) NOT NULL,
559 `price` int(11) NOT NULL,
560 `category` varchar(60) DEFAULT NULL,
561 PRIMARY KEY (`model`)
562) ENGINE=InnoDB DEFAULT CHARSET=latin1;
563
564-- Dumping data for table essentialmode.vehicles: ~240 rows (approximately)
565/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
566INSERT INTO `vehicles` (`name`, `model`, `price`, `category`) VALUES
567 ('Adder', 'adder', 900000, 'super'),
568 ('Akuma', 'AKUMA', 7500, 'motorcycles'),
569 ('Alpha', 'alpha', 60000, 'sports'),
570 ('Ardent', 'ardent', 1150000, 'sportsclassics'),
571 ('Asea', 'asea', 5500, 'sedans'),
572 ('Autarch', 'autarch', 1955000, 'super'),
573 ('Avarus', 'avarus', 18000, 'motorcycles'),
574 ('Bagger', 'bagger', 13500, 'motorcycles'),
575 ('Baller', 'baller2', 40000, 'suvs'),
576 ('Baller Sport', 'baller3', 60000, 'suvs'),
577 ('Banshee', 'banshee', 70000, 'sports'),
578 ('Banshee 900R', 'banshee2', 255000, 'super'),
579 ('Bati 801', 'bati', 12000, 'motorcycles'),
580 ('Bati 801RR', 'bati2', 19000, 'motorcycles'),
581 ('Bestia GTS', 'bestiagts', 55000, 'sports'),
582 ('BF400', 'bf400', 6500, 'motorcycles'),
583 ('Bf Injection', 'bfinjection', 16000, 'offroad'),
584 ('Bifta', 'bifta', 12000, 'offroad'),
585 ('Bison', 'bison', 45000, 'vans'),
586 ('Blade', 'blade', 15000, 'muscle'),
587 ('Blazer', 'blazer', 6500, 'offroad'),
588 ('Blazer Sport', 'blazer4', 8500, 'offroad'),
589 ('blazer5', 'blazer5', 1755600, 'offroad'),
590 ('Blista', 'blista', 8000, 'compacts'),
591 ('BMX (velo)', 'bmx', 160, 'motorcycles'),
592 ('Bobcat XL', 'bobcatxl', 32000, 'vans'),
593 ('Brawler', 'brawler', 45000, 'offroad'),
594 ('Brioso R/A', 'brioso', 18000, 'compacts'),
595 ('Btype', 'btype', 62000, 'sportsclassics'),
596 ('Btype Hotroad', 'btype2', 155000, 'sportsclassics'),
597 ('Btype Luxe', 'btype3', 85000, 'sportsclassics'),
598 ('Buccaneer', 'buccaneer', 18000, 'muscle'),
599 ('Buccaneer Rider', 'buccaneer2', 24000, 'muscle'),
600 ('Buffalo', 'buffalo', 12000, 'sports'),
601 ('Buffalo S', 'buffalo2', 20000, 'sports'),
602 ('Bullet', 'bullet', 90000, 'super'),
603 ('Burrito', 'burrito3', 19000, 'vans'),
604 ('Camper', 'camper', 42000, 'vans'),
605 ('Carbonizzare', 'carbonizzare', 75000, 'sports'),
606 ('Carbon RS', 'carbonrs', 18000, 'motorcycles'),
607 ('Casco', 'casco', 30000, 'sportsclassics'),
608 ('Cavalcade', 'cavalcade2', 55000, 'suvs'),
609 ('Cheetah', 'cheetah', 375000, 'super'),
610 ('Chimera', 'chimera', 38000, 'motorcycles'),
611 ('Chino', 'chino', 15000, 'muscle'),
612 ('Chino Luxe', 'chino2', 19000, 'muscle'),
613 ('Cliffhanger', 'cliffhanger', 9500, 'motorcycles'),
614 ('Cognoscenti Cabrio', 'cogcabrio', 55000, 'coupes'),
615 ('Cognoscenti', 'cognoscenti', 55000, 'sedans'),
616 ('Comet', 'comet2', 65000, 'sports'),
617 ('Comet 5', 'comet5', 1145000, 'sports'),
618 ('Contender', 'contender', 70000, 'suvs'),
619 ('Coquette', 'coquette', 65000, 'sports'),
620 ('Coquette Classic', 'coquette2', 40000, 'sportsclassics'),
621 ('Coquette BlackFin', 'coquette3', 55000, 'muscle'),
622 ('Cruiser (velo)', 'cruiser', 510, 'motorcycles'),
623 ('Cyclone', 'cyclone', 1890000, 'super'),
624 ('Daemon', 'daemon', 11500, 'motorcycles'),
625 ('Daemon High', 'daemon2', 13500, 'motorcycles'),
626 ('Defiler', 'defiler', 9800, 'motorcycles'),
627 ('Deluxo', 'deluxo', 4721500, 'sportsclassics'),
628 ('Dominator', 'dominator', 35000, 'muscle'),
629 ('Double T', 'double', 28000, 'motorcycles'),
630 ('Dubsta', 'dubsta', 45000, 'suvs'),
631 ('Dubsta Luxuary', 'dubsta2', 60000, 'suvs'),
632 ('Bubsta 6x6', 'dubsta3', 120000, 'offroad'),
633 ('Dukes', 'dukes', 28000, 'muscle'),
634 ('Dune Buggy', 'dune', 8000, 'offroad'),
635 ('Elegy', 'elegy2', 38500, 'sports'),
636 ('Emperor', 'emperor', 8500, 'sedans'),
637 ('Enduro', 'enduro', 5500, 'motorcycles'),
638 ('Entity XF', 'entityxf', 425000, 'super'),
639 ('Esskey', 'esskey', 4200, 'motorcycles'),
640 ('Exemplar', 'exemplar', 32000, 'coupes'),
641 ('F620', 'f620', 40000, 'coupes'),
642 ('Faction', 'faction', 20000, 'muscle'),
643 ('Faction Rider', 'faction2', 30000, 'muscle'),
644 ('Faction XL', 'faction3', 40000, 'muscle'),
645 ('Faggio', 'faggio', 1900, 'motorcycles'),
646 ('Vespa', 'faggio2', 2800, 'motorcycles'),
647 ('Felon', 'felon', 42000, 'coupes'),
648 ('Felon GT', 'felon2', 55000, 'coupes'),
649 ('Feltzer', 'feltzer2', 55000, 'sports'),
650 ('Stirling GT', 'feltzer3', 65000, 'sportsclassics'),
651 ('Fixter (velo)', 'fixter', 225, 'motorcycles'),
652 ('FMJ', 'fmj', 185000, 'super'),
653 ('Fhantom', 'fq2', 17000, 'suvs'),
654 ('Fugitive', 'fugitive', 12000, 'sedans'),
655 ('Furore GT', 'furoregt', 45000, 'sports'),
656 ('Fusilade', 'fusilade', 40000, 'sports'),
657 ('Gargoyle', 'gargoyle', 16500, 'motorcycles'),
658 ('Gauntlet', 'gauntlet', 30000, 'muscle'),
659 ('Gang Burrito', 'gburrito', 45000, 'vans'),
660 ('Burrito', 'gburrito2', 29000, 'vans'),
661 ('Glendale', 'glendale', 6500, 'sedans'),
662 ('Grabger', 'granger', 50000, 'suvs'),
663 ('Gresley', 'gresley', 47500, 'suvs'),
664 ('GT 500', 'gt500', 785000, 'sportsclassics'),
665 ('Guardian', 'guardian', 45000, 'offroad'),
666 ('Hakuchou', 'hakuchou', 31000, 'motorcycles'),
667 ('Hakuchou Sport', 'hakuchou2', 55000, 'motorcycles'),
668 ('Hermes', 'hermes', 535000, 'muscle'),
669 ('Hexer', 'hexer', 12000, 'motorcycles'),
670 ('Hotknife', 'hotknife', 125000, 'muscle'),
671 ('Huntley S', 'huntley', 40000, 'suvs'),
672 ('Hustler', 'hustler', 625000, 'muscle'),
673 ('Infernus', 'infernus', 180000, 'super'),
674 ('Innovation', 'innovation', 23500, 'motorcycles'),
675 ('Intruder', 'intruder', 7500, 'sedans'),
676 ('Issi', 'issi2', 10000, 'compacts'),
677 ('Jackal', 'jackal', 38000, 'coupes'),
678 ('Jester', 'jester', 65000, 'sports'),
679 ('Jester(Racecar)', 'jester2', 135000, 'sports'),
680 ('Journey', 'journey', 6500, 'vans'),
681 ('Kamacho', 'kamacho', 345000, 'offroad'),
682 ('Khamelion', 'khamelion', 38000, 'sports'),
683 ('Kuruma', 'kuruma', 30000, 'sports'),
684 ('Landstalker', 'landstalker', 35000, 'suvs'),
685 ('RE-7B', 'le7b', 325000, 'super'),
686 ('Lynx', 'lynx', 40000, 'sports'),
687 ('Mamba', 'mamba', 70000, 'sports'),
688 ('Manana', 'manana', 12800, 'sportsclassics'),
689 ('Manchez', 'manchez', 5300, 'motorcycles'),
690 ('Massacro', 'massacro', 65000, 'sports'),
691 ('Massacro(Racecar)', 'massacro2', 130000, 'sports'),
692 ('Mesa', 'mesa', 16000, 'suvs'),
693 ('Mesa Trail', 'mesa3', 40000, 'suvs'),
694 ('Minivan', 'minivan', 13000, 'vans'),
695 ('Monroe', 'monroe', 55000, 'sportsclassics'),
696 ('The Liberator', 'monster', 210000, 'offroad'),
697 ('Moonbeam', 'moonbeam', 18000, 'vans'),
698 ('Moonbeam Rider', 'moonbeam2', 35000, 'vans'),
699 ('Nemesis', 'nemesis', 5800, 'motorcycles'),
700 ('Neon', 'neon', 1500000, 'sports'),
701 ('Nightblade', 'nightblade', 35000, 'motorcycles'),
702 ('Nightshade', 'nightshade', 65000, 'muscle'),
703 ('9F', 'ninef', 65000, 'sports'),
704 ('9F Cabrio', 'ninef2', 80000, 'sports'),
705 ('Omnis', 'omnis', 35000, 'sports'),
706 ('Oppressor', 'oppressor', 3524500, 'super'),
707 ('Oracle XS', 'oracle2', 35000, 'coupes'),
708 ('Osiris', 'osiris', 160000, 'super'),
709 ('Panto', 'panto', 10000, 'compacts'),
710 ('Paradise', 'paradise', 19000, 'vans'),
711 ('Pariah', 'pariah', 1420000, 'sports'),
712 ('Patriot', 'patriot', 55000, 'suvs'),
713 ('PCJ-600', 'pcj', 6200, 'motorcycles'),
714 ('Penumbra', 'penumbra', 28000, 'sports'),
715 ('Pfister', 'pfister811', 85000, 'super'),
716 ('Phoenix', 'phoenix', 12500, 'muscle'),
717 ('Picador', 'picador', 18000, 'muscle'),
718 ('Pigalle', 'pigalle', 20000, 'sportsclassics'),
719 ('Prairie', 'prairie', 12000, 'compacts'),
720 ('Premier', 'premier', 8000, 'sedans'),
721 ('Primo Custom', 'primo2', 14000, 'sedans'),
722 ('X80 Proto', 'prototipo', 2500000, 'super'),
723 ('Radius', 'radi', 29000, 'suvs'),
724 ('raiden', 'raiden', 1375000, 'sports'),
725 ('Rapid GT', 'rapidgt', 35000, 'sports'),
726 ('Rapid GT Convertible', 'rapidgt2', 45000, 'sports'),
727 ('Rapid GT3', 'rapidgt3', 885000, 'sportsclassics'),
728 ('Reaper', 'reaper', 150000, 'super'),
729 ('Rebel', 'rebel2', 35000, 'offroad'),
730 ('Regina', 'regina', 5000, 'sedans'),
731 ('Retinue', 'retinue', 615000, 'sportsclassics'),
732 ('Revolter', 'revolter', 1610000, 'sports'),
733 ('riata', 'riata', 380000, 'offroad'),
734 ('Rocoto', 'rocoto', 45000, 'suvs'),
735 ('Ruffian', 'ruffian', 6800, 'motorcycles'),
736 ('Ruiner 2', 'ruiner2', 5745600, 'muscle'),
737 ('Rumpo', 'rumpo', 15000, 'vans'),
738 ('Rumpo Trail', 'rumpo3', 19500, 'vans'),
739 ('Sabre Turbo', 'sabregt', 20000, 'muscle'),
740 ('Sabre GT', 'sabregt2', 25000, 'muscle'),
741 ('Sanchez', 'sanchez', 5300, 'motorcycles'),
742 ('Sanchez Sport', 'sanchez2', 5300, 'motorcycles'),
743 ('Sanctus', 'sanctus', 25000, 'motorcycles'),
744 ('Sandking', 'sandking', 55000, 'offroad'),
745 ('Savestra', 'savestra', 990000, 'sportsclassics'),
746 ('SC 1', 'sc1', 1603000, 'super'),
747 ('Schafter', 'schafter2', 25000, 'sedans'),
748 ('Schafter V12', 'schafter3', 50000, 'sports'),
749 ('Scorcher (velo)', 'scorcher', 280, 'motorcycles'),
750 ('Seminole', 'seminole', 25000, 'suvs'),
751 ('Sentinel', 'sentinel', 32000, 'coupes'),
752 ('Sentinel XS', 'sentinel2', 40000, 'coupes'),
753 ('Sentinel3', 'sentinel3', 650000, 'sports'),
754 ('Seven 70', 'seven70', 39500, 'sports'),
755 ('ETR1', 'sheava', 220000, 'super'),
756 ('Shotaro Concept', 'shotaro', 320000, 'motorcycles'),
757 ('Slam Van', 'slamvan3', 11500, 'muscle'),
758 ('Sovereign', 'sovereign', 22000, 'motorcycles'),
759 ('Stinger', 'stinger', 80000, 'sportsclassics'),
760 ('Stinger GT', 'stingergt', 75000, 'sportsclassics'),
761 ('Streiter', 'streiter', 500000, 'sports'),
762 ('Stretch', 'stretch', 90000, 'sedans'),
763 ('Stromberg', 'stromberg', 3185350, 'sports'),
764 ('Sultan', 'sultan', 15000, 'sports'),
765 ('Sultan RS', 'sultanrs', 65000, 'super'),
766 ('Super Diamond', 'superd', 130000, 'sedans'),
767 ('Surano', 'surano', 50000, 'sports'),
768 ('Surfer', 'surfer', 12000, 'vans'),
769 ('T20', 't20', 300000, 'super'),
770 ('Tailgater', 'tailgater', 30000, 'sedans'),
771 ('Tampa', 'tampa', 16000, 'muscle'),
772 ('Drift Tampa', 'tampa2', 80000, 'sports'),
773 ('Thrust', 'thrust', 24000, 'motorcycles'),
774 ('Tri bike (velo)', 'tribike3', 520, 'motorcycles'),
775 ('Trophy Truck', 'trophytruck', 60000, 'offroad'),
776 ('Trophy Truck Limited', 'trophytruck2', 80000, 'offroad'),
777 ('Tropos', 'tropos', 40000, 'sports'),
778 ('Turismo R', 'turismor', 350000, 'super'),
779 ('Tyrus', 'tyrus', 600000, 'super'),
780 ('Vacca', 'vacca', 120000, 'super'),
781 ('Vader', 'vader', 7200, 'motorcycles'),
782 ('Verlierer', 'verlierer2', 70000, 'sports'),
783 ('Vigero', 'vigero', 12500, 'muscle'),
784 ('Virgo', 'virgo', 14000, 'muscle'),
785 ('Viseris', 'viseris', 875000, 'sportsclassics'),
786 ('Visione', 'visione', 2250000, 'super'),
787 ('Voltic', 'voltic', 90000, 'super'),
788 ('Voltic 2', 'voltic2', 3830400, 'super'),
789 ('Voodoo', 'voodoo', 7200, 'muscle'),
790 ('Vortex', 'vortex', 9800, 'motorcycles'),
791 ('Warrener', 'warrener', 4000, 'sedans'),
792 ('Washington', 'washington', 9000, 'sedans'),
793 ('Windsor', 'windsor', 95000, 'coupes'),
794 ('Windsor Drop', 'windsor2', 125000, 'coupes'),
795 ('Woflsbane', 'wolfsbane', 9000, 'motorcycles'),
796 ('XLS', 'xls', 32000, 'suvs'),
797 ('Yosemite', 'yosemite', 485000, 'muscle'),
798 ('Youga', 'youga', 10800, 'vans'),
799 ('Youga Luxuary', 'youga2', 14500, 'vans'),
800 ('Z190', 'z190', 900000, 'sportsclassics'),
801 ('Zentorno', 'zentorno', 1500000, 'super'),
802 ('Zion', 'zion', 36000, 'coupes'),
803 ('Zion Cabrio', 'zion2', 45000, 'coupes'),
804 ('Zombie', 'zombiea', 9500, 'motorcycles'),
805 ('Zombie Luxuary', 'zombieb', 12000, 'motorcycles'),
806 ('Z-Type', 'ztype', 220000, 'sportsclassics');
807/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
808
809-- Dumping structure for table essentialmode.vehicle_categories
810CREATE TABLE IF NOT EXISTS `vehicle_categories` (
811 `id` int(11) NOT NULL AUTO_INCREMENT,
812 `name` varchar(60) NOT NULL,
813 `label` varchar(60) NOT NULL,
814 PRIMARY KEY (`id`)
815) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
816
817-- Dumping data for table essentialmode.vehicle_categories: ~11 rows (approximately)
818/*!40000 ALTER TABLE `vehicle_categories` DISABLE KEYS */;
819INSERT INTO `vehicle_categories` (`id`, `name`, `label`) VALUES
820 (1, 'compacts', 'Compacts'),
821 (2, 'coupes', 'Coupés'),
822 (3, 'sedans', 'Sedans'),
823 (4, 'sports', 'Sports'),
824 (5, 'sportsclassics', 'Sports Classics'),
825 (6, 'super', 'Super'),
826 (7, 'muscle', 'Muscle'),
827 (8, 'offroad', 'Off Road'),
828 (9, 'suvs', 'SUVs'),
829 (10, 'vans', 'Vans'),
830 (11, 'motorcycles', 'Motos');
831/*!40000 ALTER TABLE `vehicle_categories` ENABLE KEYS */;
832
833-- Dumping structure for table essentialmode.weashops
834CREATE TABLE IF NOT EXISTS `weashops` (
835 `id` int(11) NOT NULL AUTO_INCREMENT,
836 `name` varchar(255) NOT NULL,
837 `item` varchar(255) NOT NULL,
838 `price` int(11) NOT NULL,
839 PRIMARY KEY (`id`)
840) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
841
842-- Dumping data for table essentialmode.weashops: ~40 rows (approximately)
843/*!40000 ALTER TABLE `weashops` DISABLE KEYS */;
844INSERT INTO `weashops` (`id`, `name`, `item`, `price`) VALUES
845 (1, 'GunShop', 'WEAPON_PISTOL', 300),
846 (2, 'BlackWeashop', 'WEAPON_PISTOL', 500),
847 (3, 'GunShop', 'WEAPON_FLASHLIGHT', 60),
848 (4, 'BlackWeashop', 'WEAPON_FLASHLIGHT', 70),
849 (5, 'GunShop', 'WEAPON_MACHETE', 90),
850 (6, 'BlackWeashop', 'WEAPON_MACHETE', 110),
851 (7, 'GunShop', 'WEAPON_NIGHTSTICK', 150),
852 (8, 'BlackWeashop', 'WEAPON_NIGHTSTICK', 150),
853 (9, 'GunShop', 'WEAPON_BAT', 100),
854 (10, 'BlackWeashop', 'WEAPON_BAT', 100),
855 (11, 'GunShop', 'WEAPON_STUNGUN', 50),
856 (12, 'BlackWeashop', 'WEAPON_STUNGUN', 50),
857 (13, 'GunShop', 'WEAPON_MICROSMG', 1400),
858 (14, 'BlackWeashop', 'WEAPON_MICROSMG', 1700),
859 (15, 'GunShop', 'WEAPON_PUMPSHOTGUN', 3400),
860 (16, 'BlackWeashop', 'WEAPON_PUMPSHOTGUN', 3500),
861 (17, 'GunShop', 'WEAPON_ASSAULTRIFLE', 10000),
862 (18, 'BlackWeashop', 'WEAPON_ASSAULTRIFLE', 11000),
863 (19, 'GunShop', 'WEAPON_SPECIALCARBINE', 15000),
864 (20, 'BlackWeashop', 'WEAPON_SPECIALCARBINE', 16500),
865 (21, 'GunShop', 'WEAPON_SNIPERRIFLE', 22000),
866 (22, 'BlackWeashop', 'WEAPON_SNIPERRIFLE', 24000),
867 (23, 'GunShop', 'WEAPON_FIREWORK', 18000),
868 (24, 'BlackWeashop', 'WEAPON_FIREWORK', 20000),
869 (25, 'GunShop', 'WEAPON_GRENADE', 500),
870 (26, 'BlackWeashop', 'WEAPON_GRENADE', 650),
871 (27, 'GunShop', 'WEAPON_BZGAS', 200),
872 (28, 'BlackWeashop', 'WEAPON_BZGAS', 350),
873 (29, 'GunShop', 'WEAPON_FIREEXTINGUISHER', 100),
874 (30, 'BlackWeashop', 'WEAPON_FIREEXTINGUISHER', 100),
875 (31, 'GunShop', 'WEAPON_BALL', 50),
876 (32, 'BlackWeashop', 'WEAPON_BALL', 50),
877 (33, 'GunShop', 'WEAPON_SMOKEGRENADE', 100),
878 (34, 'BlackWeashop', 'WEAPON_SMOKEGRENADE', 100),
879 (35, 'BlackWeashop', 'WEAPON_APPISTOL', 1100),
880 (36, 'BlackWeashop', 'WEAPON_CARBINERIFLE', 12000),
881 (37, 'BlackWeashop', 'WEAPON_HEAVYSNIPER', 30000),
882 (38, 'BlackWeashop', 'WEAPON_MINIGUN', 45000),
883 (39, 'BlackWeashop', 'WEAPON_RAILGUN', 50000),
884 (40, 'BlackWeashop', 'WEAPON_STICKYBOMB', 500);
885/*!40000 ALTER TABLE `weashops` ENABLE KEYS */;
886
887/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
888/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
889/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;