· 6 years ago · Nov 04, 2019, 02:50 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.4.8-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 10.2.0.5599
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 utf8mb4 COLLATE utf8mb4_bin */;
17USE `essentialmode`;
18
19-- Dumping structure for table essentialmode.addon_account
20CREATE TABLE IF NOT EXISTS `addon_account` (
21 `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
22 `label` varchar(100) COLLATE utf8mb4_bin NOT NULL,
23 `shared` int(11) NOT NULL,
24 PRIMARY KEY (`name`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
26
27-- Dumping data for table essentialmode.addon_account: ~4 rows (approximately)
28/*!40000 ALTER TABLE `addon_account` DISABLE KEYS */;
29INSERT INTO `addon_account` (`name`, `label`, `shared`) VALUES
30 ('property_black_money', 'Money Sale Property', 0),
31 ('society_ambulance', 'EMS', 1),
32 ('society_cardealer', 'Cardealer', 1),
33 ('society_police', 'Police', 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(100) COLLATE utf8mb4_bin DEFAULT NULL,
40 `money` int(11) NOT NULL,
41 `owner` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
42 PRIMARY KEY (`id`),
43 UNIQUE KEY `index_addon_account_data_account_name_owner` (`account_name`,`owner`),
44 KEY `index_addon_account_data_account_name` (`account_name`)
45) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
46
47-- Dumping data for table essentialmode.addon_account_data: ~10 rows (approximately)
48/*!40000 ALTER TABLE `addon_account_data` DISABLE KEYS */;
49INSERT INTO `addon_account_data` (`id`, `account_name`, `money`, `owner`) VALUES
50 (1, 'society_police', 0, NULL),
51 (2, 'property_black_money', 0, 'steam:110000105b25f97'),
52 (3, 'society_cardealer', 0, NULL),
53 (4, 'property_black_money', 0, 'steam:11000010706aaf5'),
54 (5, 'property_black_money', 0, 'steam:110000135d961a4'),
55 (6, 'society_ambulance', 0, NULL),
56 (7, 'property_black_money', 0, 'steam:11000010949144a'),
57 (8, 'property_black_money', 0, 'steam:110000108d48a86'),
58 (9, 'property_black_money', 0, 'steam:1100001034d094b'),
59 (10, 'property_black_money', 0, 'steam:1100001037b8282');
60/*!40000 ALTER TABLE `addon_account_data` ENABLE KEYS */;
61
62-- Dumping structure for table essentialmode.addon_inventory
63CREATE TABLE IF NOT EXISTS `addon_inventory` (
64 `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
65 `label` varchar(100) COLLATE utf8mb4_bin NOT NULL,
66 `shared` int(11) NOT NULL,
67 PRIMARY KEY (`name`)
68) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
69
70-- Dumping data for table essentialmode.addon_inventory: ~4 rows (approximately)
71/*!40000 ALTER TABLE `addon_inventory` DISABLE KEYS */;
72INSERT INTO `addon_inventory` (`name`, `label`, `shared`) VALUES
73 ('property', 'Property', 0),
74 ('society_ambulance', 'EMS', 1),
75 ('society_cardealer', 'Cardealer', 1),
76 ('society_police', 'Police', 1);
77/*!40000 ALTER TABLE `addon_inventory` ENABLE KEYS */;
78
79-- Dumping structure for table essentialmode.addon_inventory_items
80CREATE TABLE IF NOT EXISTS `addon_inventory_items` (
81 `id` int(11) NOT NULL AUTO_INCREMENT,
82 `inventory_name` varchar(100) COLLATE utf8mb4_bin NOT NULL,
83 `name` varchar(100) COLLATE utf8mb4_bin NOT NULL,
84 `count` int(11) NOT NULL,
85 `owner` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
86 PRIMARY KEY (`id`),
87 KEY `index_addon_inventory_items_inventory_name_name` (`inventory_name`,`name`),
88 KEY `index_addon_inventory_items_inventory_name_name_owner` (`inventory_name`,`name`,`owner`),
89 KEY `index_addon_inventory_inventory_name` (`inventory_name`)
90) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
91
92-- Dumping data for table essentialmode.addon_inventory_items: ~0 rows (approximately)
93/*!40000 ALTER TABLE `addon_inventory_items` DISABLE KEYS */;
94/*!40000 ALTER TABLE `addon_inventory_items` ENABLE KEYS */;
95
96-- Dumping structure for table essentialmode.arrests_list
97CREATE TABLE IF NOT EXISTS `arrests_list` (
98 `id` int(11) NOT NULL AUTO_INCREMENT,
99 `json_data` longtext NOT NULL,
100 PRIMARY KEY (`id`)
101) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
102
103-- Dumping data for table essentialmode.arrests_list: ~1 rows (approximately)
104/*!40000 ALTER TABLE `arrests_list` DISABLE KEYS */;
105INSERT INTO `arrests_list` (`id`, `json_data`) VALUES
106 (20, '{"Officer":"steam:110000105b25f97","Detainee":"ben archer","Description":"JAILED - ROBBERY","OfficerC":"Robbery x1, porn x2", "Date":"Mon Nov 4 02:34:58 2019"}');
107/*!40000 ALTER TABLE `arrests_list` ENABLE KEYS */;
108
109-- Dumping structure for table essentialmode.billing
110CREATE TABLE IF NOT EXISTS `billing` (
111 `id` int(11) NOT NULL AUTO_INCREMENT,
112 `identifier` varchar(255) COLLATE utf8mb4_bin NOT NULL,
113 `sender` varchar(255) COLLATE utf8mb4_bin NOT NULL,
114 `target_type` varchar(50) COLLATE utf8mb4_bin NOT NULL,
115 `target` varchar(255) COLLATE utf8mb4_bin NOT NULL,
116 `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
117 `amount` int(11) NOT NULL,
118 PRIMARY KEY (`id`)
119) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
120
121-- Dumping data for table essentialmode.billing: ~0 rows (approximately)
122/*!40000 ALTER TABLE `billing` DISABLE KEYS */;
123/*!40000 ALTER TABLE `billing` ENABLE KEYS */;
124
125-- Dumping structure for table essentialmode.bolos_list
126CREATE TABLE IF NOT EXISTS `bolos_list` (
127 `id` int(11) NOT NULL AUTO_INCREMENT,
128 `json_data` longtext NOT NULL,
129 PRIMARY KEY (`id`)
130) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
131
132-- Dumping data for table essentialmode.bolos_list: ~2 rows (approximately)
133/*!40000 ALTER TABLE `bolos_list` DISABLE KEYS */;
134INSERT INTO `bolos_list` (`id`, `json_data`) VALUES
135 (2, '{"Officer":"steam:1100001037b8282","Suspect":"Tits Mcgee","Description":"Wanted for NOT WEARING A SHIRT","OfficerC":"See description.", "Date":"Mon Nov 4 02:33:48 2019"}'),
136 (3, '{"Officer":"steam:110000108d48a86","Suspect":"Paige Turner","Description":"Walking around like a naked idiot","OfficerC":"She had pasties on but she\'s such a trouble", "Date":"Mon Nov 4 02:33:50 2019"}');
137/*!40000 ALTER TABLE `bolos_list` ENABLE KEYS */;
138
139-- Dumping structure for table essentialmode.cardealer_vehicles
140CREATE TABLE IF NOT EXISTS `cardealer_vehicles` (
141 `id` int(11) NOT NULL AUTO_INCREMENT,
142 `vehicle` varchar(255) COLLATE utf8mb4_bin NOT NULL,
143 `price` int(11) NOT NULL,
144 PRIMARY KEY (`id`)
145) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
146
147-- Dumping data for table essentialmode.cardealer_vehicles: ~0 rows (approximately)
148/*!40000 ALTER TABLE `cardealer_vehicles` DISABLE KEYS */;
149/*!40000 ALTER TABLE `cardealer_vehicles` ENABLE KEYS */;
150
151-- Dumping structure for table essentialmode.characters
152CREATE TABLE IF NOT EXISTS `characters` (
153 `id` int(11) NOT NULL AUTO_INCREMENT,
154 `identifier` varchar(255) COLLATE utf8mb4_bin NOT NULL,
155 `firstname` varchar(255) COLLATE utf8mb4_bin NOT NULL,
156 `lastname` varchar(255) COLLATE utf8mb4_bin NOT NULL,
157 `dateofbirth` varchar(255) COLLATE utf8mb4_bin NOT NULL,
158 `sex` varchar(1) COLLATE utf8mb4_bin NOT NULL DEFAULT 'M',
159 `height` varchar(128) COLLATE utf8mb4_bin NOT NULL,
160 `lastdigits` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
161 PRIMARY KEY (`id`)
162) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
163
164-- Dumping data for table essentialmode.characters: ~7 rows (approximately)
165/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
166INSERT INTO `characters` (`id`, `identifier`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`, `lastdigits`) VALUES
167 (1, 'steam:110000105b25f97', 'Ben', 'Archer', '1999-06-24', 'M', '175', '1628'),
168 (2, 'steam:11000010706aaf5', 'jock', 'knob', '1990-01-01', 'M', '170', '1628'),
169 (3, 'steam:110000135d961a4', 'Richard', 'Rasche', '1974-12-13', 'M', '155', '4473'),
170 (4, 'steam:11000010949144a', 'Johnny', 'Harlem', '1990-01-01', 'M', '172', '1628'),
171 (5, 'steam:110000108d48a86', 'Paige', 'Turner', '1980-12-14', 'F', '173', '5975'),
172 (6, 'steam:1100001034d094b', 'tekashi', 'sixnine', '1990-01-01', 'M', '180', '9964'),
173 (7, 'steam:1100001037b8282', 'Nicholas', 'Blundstone', '1988-08-30', 'M', '179', '7635');
174/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
175
176-- Dumping structure for table essentialmode.datastore
177CREATE TABLE IF NOT EXISTS `datastore` (
178 `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
179 `label` varchar(100) COLLATE utf8mb4_bin NOT NULL,
180 `shared` int(11) NOT NULL,
181 PRIMARY KEY (`name`)
182) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
183
184-- Dumping data for table essentialmode.datastore: ~2 rows (approximately)
185/*!40000 ALTER TABLE `datastore` DISABLE KEYS */;
186INSERT INTO `datastore` (`name`, `label`, `shared`) VALUES
187 ('property', 'Property', 0),
188 ('society_ambulance', 'EMS', 1),
189 ('society_police', 'Police', 1);
190/*!40000 ALTER TABLE `datastore` ENABLE KEYS */;
191
192-- Dumping structure for table essentialmode.datastore_data
193CREATE TABLE IF NOT EXISTS `datastore_data` (
194 `id` int(11) NOT NULL AUTO_INCREMENT,
195 `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
196 `owner` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
197 `data` longtext COLLATE utf8mb4_bin DEFAULT NULL,
198 PRIMARY KEY (`id`),
199 UNIQUE KEY `index_datastore_data_name_owner` (`name`,`owner`),
200 KEY `index_datastore_data_name` (`name`)
201) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
202
203-- Dumping data for table essentialmode.datastore_data: ~9 rows (approximately)
204/*!40000 ALTER TABLE `datastore_data` DISABLE KEYS */;
205INSERT INTO `datastore_data` (`id`, `name`, `owner`, `data`) VALUES
206 (1, 'society_police', NULL, '{}'),
207 (2, 'property', 'steam:110000105b25f97', '{}'),
208 (3, 'property', 'steam:11000010706aaf5', '{}'),
209 (4, 'property', 'steam:110000135d961a4', '{}'),
210 (5, 'society_ambulance', NULL, '{}'),
211 (6, 'property', 'steam:11000010949144a', '{}'),
212 (7, 'property', 'steam:110000108d48a86', '{}'),
213 (8, 'property', 'steam:1100001034d094b', '{}'),
214 (9, 'property', 'steam:1100001037b8282', '{}');
215/*!40000 ALTER TABLE `datastore_data` ENABLE KEYS */;
216
217-- Dumping structure for table essentialmode.fine_types
218CREATE TABLE IF NOT EXISTS `fine_types` (
219 `id` int(11) NOT NULL AUTO_INCREMENT,
220 `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
221 `amount` int(11) DEFAULT NULL,
222 `category` int(11) DEFAULT NULL,
223 PRIMARY KEY (`id`)
224) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
225
226-- Dumping data for table essentialmode.fine_types: ~52 rows (approximately)
227/*!40000 ALTER TABLE `fine_types` DISABLE KEYS */;
228INSERT INTO `fine_types` (`id`, `label`, `amount`, `category`) VALUES
229 (1, 'Misuse of a horn', 30, 0),
230 (2, 'Illegally Crossing a continuous Line', 40, 0),
231 (3, 'Driving on the wrong side of the road', 250, 0),
232 (4, 'Illegal U-Turn', 250, 0),
233 (5, 'Illegally Driving Off-road', 170, 0),
234 (6, 'Refusing a Lawful Command', 30, 0),
235 (7, 'Illegally Stopping a Vehicle', 150, 0),
236 (8, 'Illegal Parking', 70, 0),
237 (9, 'Failing to Yield to the right', 70, 0),
238 (10, 'Failure to comply with Vehicle Information', 90, 0),
239 (11, 'Failing to stop at a Stop Sign ', 105, 0),
240 (12, 'Failing to stop at a Red Light', 130, 0),
241 (13, 'Illegal Passing', 100, 0),
242 (14, 'Driving an illegal Vehicle', 100, 0),
243 (15, 'Driving without a License', 1500, 0),
244 (16, 'Hit and Run', 800, 0),
245 (17, 'Exceeding Speeds Over < 5 mph', 90, 0),
246 (18, 'Exceeding Speeds Over 5-15 mph', 120, 0),
247 (19, 'Exceeding Speeds Over 15-30 mph', 180, 0),
248 (20, 'Exceeding Speeds Over > 30 mph', 300, 0),
249 (21, 'Impeding traffic flow', 110, 1),
250 (22, 'Public Intoxication', 90, 1),
251 (23, 'Disorderly conduct', 90, 1),
252 (24, 'Obstruction of Justice', 130, 1),
253 (25, 'Insults towards Civilans', 75, 1),
254 (26, 'Disrespecting of an LEO', 110, 1),
255 (27, 'Verbal Threat towards a Civilan', 90, 1),
256 (28, 'Verbal Threat towards an LEO', 150, 1),
257 (29, 'Providing False Information', 250, 1),
258 (30, 'Attempt of Corruption', 1500, 1),
259 (31, 'Brandishing a weapon in city Limits', 120, 2),
260 (32, 'Brandishing a Lethal Weapon in city Limits', 300, 2),
261 (33, 'No Firearms License', 600, 2),
262 (34, 'Possession of an Illegal Weapon', 700, 2),
263 (35, 'Possession of Burglary Tools', 300, 2),
264 (36, 'Grand Theft Auto', 1800, 2),
265 (37, 'Intent to Sell/Distrube of an illegal Substance', 1500, 2),
266 (38, 'Frabrication of an Illegal Substance', 1500, 2),
267 (39, 'Possession of an Illegal Substance ', 650, 2),
268 (40, 'Kidnapping of a Civilan', 1500, 2),
269 (41, 'Kidnapping of an LEO', 2000, 2),
270 (42, 'Robbery', 650, 2),
271 (43, 'Armed Robbery of a Store', 650, 2),
272 (44, 'Armed Robbery of a Bank', 1500, 2),
273 (45, 'Assault on a Civilian', 2000, 3),
274 (46, 'Assault of an LEO', 2500, 3),
275 (47, 'Attempt of Murder of a Civilian', 3000, 3),
276 (48, 'Attempt of Murder of an LEO', 5000, 3),
277 (49, 'Murder of a Civilian', 10000, 3),
278 (50, 'Murder of an LEO', 30000, 3),
279 (51, 'Involuntary manslaughter', 1800, 3),
280 (52, 'Fraud', 2000, 2);
281/*!40000 ALTER TABLE `fine_types` ENABLE KEYS */;
282
283-- Dumping structure for table essentialmode.items
284CREATE TABLE IF NOT EXISTS `items` (
285 `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
286 `label` varchar(50) COLLATE utf8mb4_bin NOT NULL,
287 `limit` int(11) NOT NULL DEFAULT -1,
288 `rare` int(11) NOT NULL DEFAULT 0,
289 `can_remove` int(11) NOT NULL DEFAULT 1,
290 PRIMARY KEY (`name`)
291) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
292
293-- Dumping data for table essentialmode.items: ~10 rows (approximately)
294/*!40000 ALTER TABLE `items` DISABLE KEYS */;
295INSERT INTO `items` (`name`, `label`, `limit`, `rare`, `can_remove`) VALUES
296 ('bandage', 'Bandage', 20, 0, 1),
297 ('beer', 'Beer', 6, 0, 1),
298 ('bread', 'Bread', -1, 0, 1),
299 ('jewels', 'Jewels', -1, 0, 1),
300 ('medikit', 'Medikit', 5, 0, 1),
301 ('tequila', 'Tequila', 2, 0, 1),
302 ('vodka', 'Vodka', 2, 0, 1),
303 ('water', 'Water', -1, 0, 1),
304 ('whisky', 'Whisky', 2, 0, 1),
305 ('wine', 'Wine', 2, 0, 1);
306/*!40000 ALTER TABLE `items` ENABLE KEYS */;
307
308-- Dumping structure for table essentialmode.jobs
309CREATE TABLE IF NOT EXISTS `jobs` (
310 `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
311 `label` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
312 PRIMARY KEY (`name`)
313) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
314
315-- Dumping data for table essentialmode.jobs: ~4 rows (approximately)
316/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
317INSERT INTO `jobs` (`name`, `label`) VALUES
318 ('ambulance', 'EMS'),
319 ('cardealer', 'Cardealer'),
320 ('police', 'Police'),
321 ('unemployed', 'Unemployed');
322/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
323
324-- Dumping structure for table essentialmode.job_grades
325CREATE TABLE IF NOT EXISTS `job_grades` (
326 `id` int(11) NOT NULL AUTO_INCREMENT,
327 `job_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
328 `grade` int(11) NOT NULL,
329 `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
330 `label` varchar(50) COLLATE utf8mb4_bin NOT NULL,
331 `salary` int(11) NOT NULL,
332 `skin_male` longtext COLLATE utf8mb4_bin NOT NULL,
333 `skin_female` longtext COLLATE utf8mb4_bin NOT NULL,
334 PRIMARY KEY (`id`)
335) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
336
337-- Dumping data for table essentialmode.job_grades: ~29 rows (approximately)
338/*!40000 ALTER TABLE `job_grades` DISABLE KEYS */;
339INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
340 (1, 'unemployed', 0, 'unemployed', 'Unemployed', 200, '{}', '{}'),
341 (2, 'police', 0, 'lspdcadet', 'LSPD: Cadet', 20, '{}', '{}'),
342 (3, 'police', 1, 'lspdprobie', 'LSPD: Probationary Officer', 40, '{}', '{}'),
343 (4, 'police', 2, 'lspdofficer', 'LSPD: Officer', 60, '{}', '{}'),
344 (5, 'police', 3, 'lspdseniorofficer', 'LSPD: Senior Officer', 85, '{}', '{}'),
345 (6, 'police', 4, 'lspdsergeant', 'LSPD: Sergeant', 100, '{}', '{}'),
346 (7, 'police', 5, 'lspdlieutenant', 'LSPD: Lieutenant', 20, '{}', '{}'),
347 (8, 'police', 6, 'lspdcaptain', 'LSPD: Captain', 40, '{}', '{}'),
348 (9, 'police', 7, 'lspdmajor', 'LSPD: Major', 60, '{}', '{}'),
349 (10, 'police', 8, 'lspdassistantchief', 'LSPD: Assistant Chief', 85, '{}', '{}'),
350 (11, 'police', 9, 'boss', 'LSPD: Chief', 100, '{}', '{}'),
351 (12, 'police', 10, 'bcsocadet', 'BCSO: Cadet', 20, '{}', '{}'),
352 (13, 'police', 11, 'bcsoprobie', 'BCSO: Probationary Deputy', 40, '{}', '{}'),
353 (14, 'police', 12, 'bcsodeputy', 'BCSO: Deputy', 60, '{}', '{}'),
354 (15, 'police', 13, 'bcsocorporal', 'BCSO: Corporal', 85, '{}', '{}'),
355 (16, 'police', 14, 'bcsosergeant', 'BCSO: Sergeant', 100, '{}', '{}'),
356 (17, 'police', 15, 'bcsolieutenant', 'BCSO: Lieutenant', 20, '{}', '{}'),
357 (18, 'police', 16, 'bcsocaptain', 'BCSO: Captain', 40, '{}', '{}'),
358 (19, 'police', 17, 'bcsomajor', 'BCSO: Major', 60, '{}', '{}'),
359 (20, 'police', 18, 'bcsoundersheriff', 'BCSO: Undersheriff', 85, '{}', '{}'),
360 (21, 'police', 19, 'boss', 'BCSO: Sheriff', 100, '{}', '{}'),
361 (22, 'cardealer', 0, 'recruit', 'Recruit', 10, '{}', '{}'),
362 (23, 'cardealer', 1, 'novice', 'Novice', 25, '{}', '{}'),
363 (24, 'cardealer', 2, 'experienced', 'Experienced', 40, '{}', '{}'),
364 (25, 'cardealer', 3, 'boss', 'Boss', 0, '{}', '{}'),
365 (30, 'ambulance', 0, 'ambulance', 'Jr. EMT', 20, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":3,"shoes":9,"torso_2":3,"hair_color_2":0,"pants_1":24,"glasses_1":4,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":15,"helmet_1":8,"helmet_2":0,"arms":92,"face":19,"decals_1":60,"torso_1":13,"hair_2":0,"skin":34,"pants_2":5}', '{"tshirt_2":3,"decals_2":0,"glasses":0,"hair_1":2,"torso_1":73,"shoes":1,"hair_color_2":0,"glasses_1":19,"skin":13,"face":6,"pants_2":5,"tshirt_1":75,"pants_1":37,"helmet_1":57,"torso_2":0,"arms":14,"sex":1,"glasses_2":0,"decals_1":0,"hair_2":0,"helmet_2":0,"hair_color_1":0}'),
366 (31, 'ambulance', 1, 'doctor', 'EMT', 40, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":3,"shoes":9,"torso_2":3,"hair_color_2":0,"pants_1":24,"glasses_1":4,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":15,"helmet_1":8,"helmet_2":0,"arms":92,"face":19,"decals_1":60,"torso_1":13,"hair_2":0,"skin":34,"pants_2":5}', '{"tshirt_2":3,"decals_2":0,"glasses":0,"hair_1":2,"torso_1":73,"shoes":1,"hair_color_2":0,"glasses_1":19,"skin":13,"face":6,"pants_2":5,"tshirt_1":75,"pants_1":37,"helmet_1":57,"torso_2":0,"arms":14,"sex":1,"glasses_2":0,"decals_1":0,"hair_2":0,"helmet_2":0,"hair_color_1":0}'),
367 (32, 'ambulance', 2, 'chief_doctor', 'Sr. EMT', 60, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":3,"shoes":9,"torso_2":3,"hair_color_2":0,"pants_1":24,"glasses_1":4,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":15,"helmet_1":8,"helmet_2":0,"arms":92,"face":19,"decals_1":60,"torso_1":13,"hair_2":0,"skin":34,"pants_2":5}', '{"tshirt_2":3,"decals_2":0,"glasses":0,"hair_1":2,"torso_1":73,"shoes":1,"hair_color_2":0,"glasses_1":19,"skin":13,"face":6,"pants_2":5,"tshirt_1":75,"pants_1":37,"helmet_1":57,"torso_2":0,"arms":14,"sex":1,"glasses_2":0,"decals_1":0,"hair_2":0,"helmet_2":0,"hair_color_1":0}'),
368 (33, 'ambulance', 3, 'boss', 'EMT Supervisor', 80, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":3,"shoes":9,"torso_2":3,"hair_color_2":0,"pants_1":24,"glasses_1":4,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":15,"helmet_1":8,"helmet_2":0,"arms":92,"face":19,"decals_1":60,"torso_1":13,"hair_2":0,"skin":34,"pants_2":5}', '{"tshirt_2":3,"decals_2":0,"glasses":0,"hair_1":2,"torso_1":73,"shoes":1,"hair_color_2":0,"glasses_1":19,"skin":13,"face":6,"pants_2":5,"tshirt_1":75,"pants_1":37,"helmet_1":57,"torso_2":0,"arms":14,"sex":1,"glasses_2":0,"decals_1":0,"hair_2":0,"helmet_2":0,"hair_color_1":0}');
369/*!40000 ALTER TABLE `job_grades` ENABLE KEYS */;
370
371-- Dumping structure for table essentialmode.licenses
372CREATE TABLE IF NOT EXISTS `licenses` (
373 `type` varchar(60) COLLATE utf8mb4_bin NOT NULL,
374 `label` varchar(60) COLLATE utf8mb4_bin NOT NULL,
375 PRIMARY KEY (`type`)
376) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
377
378-- Dumping data for table essentialmode.licenses: ~0 rows (approximately)
379/*!40000 ALTER TABLE `licenses` DISABLE KEYS */;
380/*!40000 ALTER TABLE `licenses` ENABLE KEYS */;
381
382-- Dumping structure for table essentialmode.liquor
383CREATE TABLE IF NOT EXISTS `liquor` (
384 `id` int(11) NOT NULL AUTO_INCREMENT,
385 `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
386 `item` varchar(255) COLLATE utf8mb4_bin NOT NULL,
387 `price` int(11) NOT NULL,
388 PRIMARY KEY (`id`)
389) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
390
391-- Dumping data for table essentialmode.liquor: ~5 rows (approximately)
392/*!40000 ALTER TABLE `liquor` DISABLE KEYS */;
393INSERT INTO `liquor` (`id`, `name`, `item`, `price`) VALUES
394 (1, 'Liquor', 'wine', 50),
395 (2, 'Liquor', 'beer', 50),
396 (3, 'Liquor', 'vodka', 50),
397 (4, 'Liquor', 'tequila', 50),
398 (5, 'Liquor', 'whisky', 50);
399/*!40000 ALTER TABLE `liquor` ENABLE KEYS */;
400
401-- Dumping structure for table essentialmode.owned_properties
402CREATE TABLE IF NOT EXISTS `owned_properties` (
403 `id` int(11) NOT NULL AUTO_INCREMENT,
404 `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
405 `price` double NOT NULL,
406 `rented` int(11) NOT NULL,
407 `owner` varchar(60) COLLATE utf8mb4_bin NOT NULL,
408 PRIMARY KEY (`id`)
409) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
410
411-- Dumping data for table essentialmode.owned_properties: ~3 rows (approximately)
412/*!40000 ALTER TABLE `owned_properties` DISABLE KEYS */;
413INSERT INTO `owned_properties` (`id`, `name`, `price`, `rented`, `owner`) VALUES
414 (1, 'PowerBrokerPolished', 5000000, 0, 'steam:11000010706aaf5'),
415 (2, 'PowerBrokerPolished', 5000000, 0, 'steam:110000105b25f97'),
416 (3, 'WildOatsDrive', 1500000, 0, 'steam:11000010706aaf5');
417/*!40000 ALTER TABLE `owned_properties` ENABLE KEYS */;
418
419-- Dumping structure for table essentialmode.owned_vehicles
420CREATE TABLE IF NOT EXISTS `owned_vehicles` (
421 `owner` varchar(30) COLLATE utf8mb4_bin NOT NULL,
422 `plate` varchar(12) COLLATE utf8mb4_bin NOT NULL,
423 `vehicle` longtext COLLATE utf8mb4_bin NOT NULL,
424 `type` varchar(20) COLLATE utf8mb4_bin NOT NULL DEFAULT 'car',
425 `job` varchar(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
426 `stored` tinyint(1) NOT NULL DEFAULT 0,
427 PRIMARY KEY (`plate`)
428) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
429
430-- Dumping data for table essentialmode.owned_vehicles: ~2 rows (approximately)
431/*!40000 ALTER TABLE `owned_vehicles` DISABLE KEYS */;
432INSERT INTO `owned_vehicles` (`owner`, `plate`, `vehicle`, `type`, `job`, `stored`) VALUES
433 ('steam:110000105b25f97', 'AQO 278', '{"modPlateHolder":-1,"modHood":-1,"modTurbo":false,"modRearBumper":-1,"modHorns":-1,"modLivery":-1,"modRoof":-1,"modArmor":-1,"modSideSkirt":-1,"modFrontBumper":-1,"color2":0,"modAPlate":-1,"modBackWheels":-1,"modHydrolic":-1,"modTrimB":-1,"windowTint":-1,"modTrimA":-1,"modSpeakers":-1,"modFrame":-1,"modXenon":false,"extras":{"1":false},"fuelLevel":70.0,"modSmokeEnabled":false,"modAirFilter":-1,"modFender":-1,"neonEnabled":[false,false,false,false],"modEngine":-1,"plateIndex":0,"modArchCover":-1,"modSpoilers":-1,"neonColor":[255,0,255],"modDashboard":-1,"modStruts":-1,"modEngineBlock":-1,"modSteeringWheel":-1,"modShifterLeavers":-1,"bodyHealth":1000.0,"modRightFender":-1,"modWindows":-1,"modOrnaments":-1,"modBrakes":-1,"modVanityPlate":-1,"modFrontWheels":-1,"pearlescentColor":2,"modTrunk":-1,"modGrille":-1,"wheelColor":7,"dirtLevel":14.1,"color1":12,"modSuspension":-1,"modDial":-1,"tyreSmokeColor":[255,255,255],"modSeats":-1,"modExhaust":-1,"modDoorSpeaker":-1,"engineHealth":1000.0,"modTransmission":-1,"wheels":3,"plate":"AQO 278","modAerials":-1,"modTank":-1,"model":683047626}', 'car', '', 1),
434 ('steam:11000010706aaf5', 'XCC 940', '{"modSmokeEnabled":1,"modBackWheels":-1,"modTurbo":1,"modArmor":-1,"modXenon":false,"modArchCover":-1,"modFrontBumper":-1,"modShifterLeavers":-1,"wheelColor":156,"modAirFilter":-1,"modAerials":-1,"modHydrolic":-1,"modFender":-1,"windowTint":-1,"modRearBumper":-1,"modLivery":-1,"modHood":0,"modFrontWheels":-1,"color2":0,"modEngineBlock":-1,"modSpeakers":-1,"modAPlate":-1,"modTrimB":-1,"modSeats":-1,"modHorns":-1,"modEngine":3,"pearlescentColor":4,"modSteeringWheel":-1,"modRightFender":-1,"plateIndex":0,"modGrille":-1,"modPlateHolder":-1,"modDashboard":-1,"modRoof":-1,"modFrame":-1,"modTrimA":-1,"modTransmission":2,"wheels":7,"fuelLevel":65.0,"modOrnaments":-1,"modVanityPlate":-1,"dirtLevel":8.6,"modDial":-1,"modExhaust":0,"modSideSkirt":-1,"neonEnabled":[false,false,false,false],"model":2072687711,"modTrunk":-1,"modDoorSpeaker":-1,"modSpoilers":1,"plate":"XCC 940","modBrakes":2,"neonColor":[255,0,255],"modTank":-1,"extras":{"12":false,"10":true},"color1":1,"modSuspension":3,"tyreSmokeColor":[255,255,255],"modStruts":-1,"modWindows":-1,"engineHealth":1000.0,"bodyHealth":1000.0}', 'car', '', 0);
435/*!40000 ALTER TABLE `owned_vehicles` ENABLE KEYS */;
436
437-- Dumping structure for table essentialmode.properties
438CREATE TABLE IF NOT EXISTS `properties` (
439 `id` int(11) NOT NULL AUTO_INCREMENT,
440 `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
441 `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
442 `entering` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
443 `exit` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
444 `inside` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
445 `outside` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
446 `ipls` varchar(255) COLLATE utf8mb4_bin DEFAULT '[]',
447 `gateway` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
448 `is_single` int(11) DEFAULT NULL,
449 `is_room` int(11) DEFAULT NULL,
450 `is_gateway` int(11) DEFAULT NULL,
451 `room_menu` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
452 `price` int(11) NOT NULL,
453 PRIMARY KEY (`id`)
454) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
455
456-- Dumping data for table essentialmode.properties: ~82 rows (approximately)
457/*!40000 ALTER TABLE `properties` DISABLE KEYS */;
458INSERT INTO `properties` (`id`, `name`, `label`, `entering`, `exit`, `inside`, `outside`, `ipls`, `gateway`, `is_single`, `is_room`, `is_gateway`, `room_menu`, `price`) VALUES
459 (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),
460 (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),
461 (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),
462 (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),
463 (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),
464 (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),
465 (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),
466 (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),
467 (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),
468 (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),
469 (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),
470 (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),
471 (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),
472 (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),
473 (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),
474 (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),
475 (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),
476 (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),
477 (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),
478 (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),
479 (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),
480 (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),
481 (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),
482 (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),
483 (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),
484 (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),
485 (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),
486 (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),
487 (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),
488 (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),
489 (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),
490 (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),
491 (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),
492 (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),
493 (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),
494 (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),
495 (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),
496 (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),
497 (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),
498 (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),
499 (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),
500 (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),
501 (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),
502 (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),
503 (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),
504 (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),
505 (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),
506 (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),
507 (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),
508 (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),
509 (51, 'PowerBrokerConservative', 'Power Broker Conservative', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{"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),
510 (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),
511 (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),
512 (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),
513 (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),
514 (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),
515 (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),
516 (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),
517 (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),
518 (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),
519 (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),
520 (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),
521 (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),
522 (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),
523 (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),
524 (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),
525 (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),
526 (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),
527 (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),
528 (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),
529 (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),
530 (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),
531 (100, 'MedEndApartment1', 'Medium Apartment 1', '{"y":3107.56,"z":41.49,"x":240.6}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":3100.77,"z":41.49,"x":240.21}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
532 (101, 'MedEndApartment2', 'Medium Apartment 2', '{"y":3169.1,"z":41.81,"x":246.7}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":3163.97,"z":41.82,"x":245.83}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
533 (102, 'MedEndApartment3', 'Medium Apartment 3', '{"y":2667.22,"z":39.06,"x":980.38}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":2668.77,"z":39.06,"x":986.38}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
534 (103, 'MedEndApartment4', 'Medium Apartment 4', '{"y":3031.08,"z":42.89,"x":195.85}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":3031.39,"z":42.27,"x":200.68}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
535 (104, 'MedEndApartment5', 'Medium Apartment 5', '{"y":4642.17,"z":42.88,"x":1724.43}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":4637.34,"z":42.31,"x":1724.27}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
536 (105, 'MedEndApartment6', 'Medium Apartment 6', '{"y":4739.73,"z":40.99,"x":1664.98}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":4740.93,"z":41.08,"x":1670.92}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
537 (106, 'MedEndApartment7', 'Medium Apartment 7', '{"y":6577.19,"z":31.74,"x":12.57}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":6572.61,"z":31.72,"x":16.93}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
538 (107, 'MedEndApartment8', 'Medium Apartment 8', '{"y":6190.84,"z":30.73,"x":-374.31}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":6186.58,"z":30.52,"x":-372.65}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
539 (108, 'MedEndApartment9', 'Medium Apartment 9', '{"y":6597.56,"z":30.86,"x":-27.06}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":6601.55,"z":30.44,"x":-30.55}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000),
540 (109, 'MedEndApartment10', 'Medium Apartment 10', '{"y":6340.1,"z":28.84,"x":-367.33}', '{"y":-1012.27,"z":-100.2,"x":346.49}', '{"y":-1000.09,"z":-100.2,"x":347.06}', '{"y":6336.97,"z":28.84,"x":-371.3}', '[]', NULL, 1, 1, 0, '{"x":345.3,"y":-995.24,"z":-100.2}', 500000);
541/*!40000 ALTER TABLE `properties` ENABLE KEYS */;
542
543-- Dumping structure for table essentialmode.rented_vehicles
544CREATE TABLE IF NOT EXISTS `rented_vehicles` (
545 `vehicle` varchar(60) COLLATE utf8mb4_bin NOT NULL,
546 `plate` varchar(12) COLLATE utf8mb4_bin NOT NULL,
547 `player_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
548 `base_price` int(11) NOT NULL,
549 `rent_price` int(11) NOT NULL,
550 `owner` varchar(22) COLLATE utf8mb4_bin NOT NULL,
551 PRIMARY KEY (`plate`)
552) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
553
554-- Dumping data for table essentialmode.rented_vehicles: ~0 rows (approximately)
555/*!40000 ALTER TABLE `rented_vehicles` DISABLE KEYS */;
556/*!40000 ALTER TABLE `rented_vehicles` ENABLE KEYS */;
557
558-- Dumping structure for table essentialmode.trunk_inventory
559CREATE TABLE IF NOT EXISTS `trunk_inventory` (
560 `id` int(11) NOT NULL AUTO_INCREMENT,
561 `plate` varchar(8) COLLATE utf8mb4_bin NOT NULL,
562 `data` text COLLATE utf8mb4_bin NOT NULL,
563 `owned` int(11) NOT NULL,
564 PRIMARY KEY (`id`),
565 UNIQUE KEY `plate` (`plate`)
566) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
567
568-- Dumping data for table essentialmode.trunk_inventory: ~0 rows (approximately)
569/*!40000 ALTER TABLE `trunk_inventory` DISABLE KEYS */;
570/*!40000 ALTER TABLE `trunk_inventory` ENABLE KEYS */;
571
572-- Dumping structure for table essentialmode.users
573CREATE TABLE IF NOT EXISTS `users` (
574 `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
575 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
576 `money` int(11) DEFAULT NULL,
577 `name` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
578 `skin` longtext COLLATE utf8mb4_bin DEFAULT NULL,
579 `job` varchar(50) COLLATE utf8mb4_bin DEFAULT 'unemployed',
580 `job_grade` int(11) DEFAULT 0,
581 `loadout` longtext COLLATE utf8mb4_bin DEFAULT NULL,
582 `position` varchar(36) COLLATE utf8mb4_bin DEFAULT NULL,
583 `bank` int(11) DEFAULT NULL,
584 `permission_level` int(11) DEFAULT NULL,
585 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
586 `firstname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
587 `lastname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
588 `dateofbirth` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
589 `sex` varchar(10) COLLATE utf8mb4_bin DEFAULT '',
590 `height` varchar(5) COLLATE utf8mb4_bin DEFAULT '',
591 `lastdigits` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
592 `last_property` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
593 `tattoos` longtext COLLATE utf8mb4_bin DEFAULT NULL,
594 `is_dead` tinyint(1) DEFAULT 0,
595 `jail` int(11) NOT NULL DEFAULT 0,
596 `status` longtext COLLATE utf8mb4_bin DEFAULT NULL,
597 PRIMARY KEY (`identifier`)
598) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
599
600-- Dumping data for table essentialmode.users: ~7 rows (approximately)
601/*!40000 ALTER TABLE `users` DISABLE KEYS */;
602INSERT INTO `users` (`identifier`, `license`, `money`, `name`, `skin`, `job`, `job_grade`, `loadout`, `position`, `bank`, `permission_level`, `group`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`, `lastdigits`, `last_property`, `tattoos`, `is_dead`, `jail`, `status`) VALUES
603 ('steam:1100001034d094b', 'license:1ef1b7977638fb765ae70f5afd2bea18f06be0be', 0, 'FleX', '{"eye_color":0,"bracelets_2":0,"bproof_1":0,"blemishes_1":0,"mask_1":79,"decals_2":0,"torso_1":0,"face":8,"tshirt_2":0,"eyebrows_3":0,"watches_1":-1,"arms_2":0,"glasses_1":0,"bags_2":0,"sun_2":0,"beard_4":0,"chain_2":0,"beard_2":0,"shoes_2":0,"torso_2":0,"age_1":0,"tshirt_1":0,"age_2":0,"helmet_1":-1,"blush_3":0,"lipstick_2":0,"bags_1":0,"lipstick_1":0,"pants_1":82,"eyebrows_2":0,"arms":0,"chest_1":0,"sex":0,"hair_1":8,"complexion_1":0,"beard_1":0,"lipstick_3":0,"sun_1":0,"makeup_2":0,"pants_2":7,"ears_1":-1,"blemishes_2":0,"glasses_2":0,"complexion_2":0,"moles_1":0,"ears_2":0,"makeup_1":0,"skin":0,"blush_2":0,"chest_2":0,"bodyb_1":0,"eyebrows_1":0,"shoes_1":28,"makeup_4":0,"chest_3":0,"helmet_2":0,"hair_color_2":2,"hair_2":4,"watches_2":0,"bproof_2":0,"hair_color_1":63,"mask_2":0,"moles_2":0,"lipstick_4":0,"eyebrows_4":0,"beard_3":0,"makeup_3":0,"blush_1":0,"chain_1":0,"decals_1":0,"bracelets_1":-1,"bodyb_2":0}', 'unemployed', 0, '[]', '{"z":2.6,"y":-928.1,"x":-1128.6}', 400, 0, 'user', 'tekashi', 'sixnine', '1990-01-01', 'M', '180', '9964', NULL, NULL, 0, 0, NULL),
604 ('steam:1100001037b8282', 'license:3cb5b8b1ff730d23370fd70e296124d394dd2c7d', 0, 'A. Verom', '{"sun_2":0,"chest_3":0,"blush_2":0,"helmet_1":-1,"shoes_2":3,"bodyb_1":0,"bodyb_2":0,"eyebrows_2":10,"makeup_2":0,"chest_2":0,"beard_3":26,"hair_1":33,"lipstick_2":0,"bproof_2":1,"eyebrows_4":0,"torso_2":3,"bracelets_2":0,"blush_1":0,"chain_2":0,"age_1":0,"watches_1":-1,"moles_2":7,"hair_color_2":11,"tshirt_1":122,"bags_1":0,"watches_2":0,"makeup_1":0,"arms":12,"torso_1":193,"lipstick_3":0,"bags_2":0,"chest_1":0,"sun_1":0,"makeup_3":0,"eyebrows_1":0,"decals_2":0,"decals_1":0,"complexion_2":0,"sex":0,"glasses_2":6,"ears_2":0,"mask_1":0,"arms_2":0,"bracelets_1":-1,"shoes_1":12,"glasses_1":5,"moles_1":3,"complexion_1":0,"lipstick_1":0,"beard_2":10,"mask_2":0,"pants_1":9,"age_2":0,"ears_1":-1,"beard_4":0,"chain_1":8,"makeup_4":0,"blemishes_1":0,"tshirt_2":0,"eye_color":2,"eyebrows_3":0,"pants_2":7,"helmet_2":0,"bproof_1":12,"beard_1":10,"blush_3":0,"lipstick_4":0,"skin":0,"hair_2":0,"blemishes_2":0,"face":0,"hair_color_1":26}', 'police', 3, '[{"ammo":160,"label":"Heavy pistol","components":["clip_default"],"name":"WEAPON_HEAVYPISTOL"},{"ammo":130,"label":"Assault SMG","components":["clip_default"],"name":"WEAPON_ASSAULTSMG"},{"ammo":130,"label":"Combat pdw","components":["clip_default"],"name":"WEAPON_COMBATPDW"},{"ammo":203,"label":"Assault rifle","components":["clip_default"],"name":"WEAPON_ASSAULTRIFLE"},{"ammo":203,"label":"Special carbine","components":["clip_default"],"name":"WEAPON_SPECIALCARBINE"},{"ammo":193,"label":"Combat MG","components":["clip_default"],"name":"WEAPON_COMBATMG"},{"ammo":12,"label":"Rocket launcher","components":[],"name":"WEAPON_RPG"},{"ammo":23,"label":"Smoke grenade","components":[],"name":"WEAPON_SMOKEGRENADE"},{"ammo":23,"label":"Bz gas","components":[],"name":"WEAPON_BZGAS"},{"ammo":0,"label":"Fire extinguisher","components":[],"name":"WEAPON_FIREEXTINGUISHER"}]', '{"y":-995.4,"x":467.7,"z":35.9}', 4140, 0, 'superadmin', 'Nicholas', 'Blundstone', '1988-08-30', 'M', '179', '7635', NULL, NULL, 0, 0, '[{"name":"hunger","val":424500,"percent":42.45},{"name":"thirst","val":443375,"percent":44.3375},{"name":"drunk","val":0,"percent":0.0}]'),
605 ('steam:110000105b25f97', 'license:b88cfc5bb5dc74c37a36d07975df85cf05e0ec8a', 0, 'Gregory', '{"sun_2":0,"chest_3":0,"blemishes_1":0,"helmet_1":-1,"shoes_2":0,"tshirt_2":0,"bodyb_2":0,"eyebrows_2":0,"makeup_2":0,"chest_2":0,"beard_3":0,"hair_1":21,"lipstick_2":0,"lipstick_4":0,"eyebrows_4":0,"torso_2":0,"ears_1":-1,"blush_1":0,"blemishes_2":0,"makeup_4":0,"watches_1":4,"beard_2":10,"hair_color_2":0,"tshirt_1":53,"bags_1":0,"watches_2":0,"makeup_1":0,"ears_2":0,"torso_1":51,"age_2":0,"bags_2":0,"chest_1":0,"sun_1":0,"makeup_3":0,"eyebrows_1":0,"decals_2":0,"decals_1":56,"eye_color":0,"blush_3":0,"glasses_2":0,"moles_2":0,"face":7,"lipstick_1":0,"skin":5,"shoes_1":10,"glasses_1":0,"moles_1":0,"mask_1":0,"age_1":0,"bproof_1":0,"mask_2":0,"pants_1":25,"arms":0,"lipstick_3":0,"beard_4":0,"chain_1":1,"complexion_2":0,"blush_2":0,"bodyb_1":0,"bracelets_2":0,"eyebrows_3":0,"arms_2":0,"helmet_2":0,"sex":0,"beard_1":10,"bproof_2":0,"hair_color_1":8,"complexion_1":0,"hair_2":4,"chain_2":0,"pants_2":3,"bracelets_1":-1}', 'police', 3, '[{"components":[],"label":"Fire extinguisher","ammo":0,"name":"WEAPON_FIREEXTINGUISHER"}]', '{"y":-995.4,"x":462.6,"z":35.9}', 16320, 0, 'superadmin', 'Ben', 'Archer', '1999-06-24', 'M', '175', '1628', NULL, '[{"texture":4,"collection":"mpairraces_overlays"}]', 0, 0, '[{"name":"hunger","val":432900,"percent":43.29},{"name":"thirst","val":449675,"percent":44.9675},{"name":"drunk","val":0,"percent":0.0}]'),
606 ('steam:11000010706aaf5', 'license:d64dfceaddefea57c6975c859365321140f06e2f', 9529673, 'Anxiou$', '{"bags_2":0,"tshirt_2":0,"eyebrows_2":0,"watches_2":0,"bodyb_1":0,"sun_2":0,"sun_1":0,"torso_2":0,"moles_1":0,"makeup_4":0,"eyebrows_1":0,"makeup_3":0,"makeup_2":0,"lipstick_2":0,"bracelets_2":0,"arms":0,"shoes_1":0,"chain_2":0,"chain_1":0,"blush_3":0,"lipstick_1":0,"blemishes_2":0,"age_1":0,"eyebrows_4":0,"skin":0,"arms_2":0,"blush_1":0,"decals_2":0,"helmet_2":0,"mask_2":0,"bags_1":0,"bodyb_2":0,"lipstick_3":0,"decals_1":0,"eyebrows_3":0,"eye_color":0,"bproof_2":0,"shoes_2":0,"tshirt_1":0,"chest_1":0,"face":0,"complexion_2":0,"hair_2":0,"torso_1":0,"hair_color_1":0,"glasses_1":0,"blush_2":0,"ears_1":-1,"chest_3":0,"hair_color_2":0,"blemishes_1":0,"hair_1":2,"chest_2":0,"makeup_1":0,"lipstick_4":0,"helmet_1":-1,"beard_3":0,"pants_2":0,"age_2":0,"watches_1":-1,"bracelets_1":-1,"sex":0,"beard_4":0,"mask_1":0,"moles_2":0,"beard_1":0,"complexion_1":0,"beard_2":0,"glasses_2":0,"ears_2":0,"pants_1":0,"bproof_1":0}', 'police', 2, '[{"components":["clip_default"],"label":"Carbine rifle","ammo":18,"name":"WEAPON_CARBINERIFLE"}]', '{"y":-993.9,"x":426.2,"z":35.7}', 34040, 0, 'superadmin', 'jock', 'knob', '1990-01-01', 'M', '170', '1628', NULL, NULL, 0, 0, '[{"name":"hunger","val":424100,"percent":42.41},{"name":"thirst","val":443075,"percent":44.3075},{"name":"drunk","val":0,"percent":0.0}]'),
607 ('steam:110000108d48a86', 'license:cc82dfac750a77f30ca1248a2ea814b9d200eaf2', 0, 'Sarahbeare', '{"shoes_1":1,"chest_1":0,"skin":0,"blemishes_1":0,"mask_1":0,"chest_2":0,"eyebrows_3":31,"moles_1":0,"mask_2":0,"eye_color":0,"arms_2":0,"tshirt_1":14,"chest_3":0,"lipstick_2":5,"decals_2":0,"eyebrows_4":0,"blemishes_2":0,"makeup_4":0,"age_1":0,"beard_3":0,"ears_2":0,"lipstick_3":20,"beard_4":0,"makeup_2":0,"helmet_1":-1,"makeup_1":0,"bproof_1":0,"bproof_2":0,"sun_2":0,"sun_1":0,"eyebrows_1":10,"lipstick_1":1,"bodyb_1":0,"sex":1,"age_2":0,"helmet_2":0,"torso_2":0,"pants_1":0,"arms":15,"torso_1":82,"decals_1":0,"makeup_3":0,"complexion_2":0,"pants_2":0,"hair_color_1":33,"blush_2":0,"watches_2":0,"hair_1":15,"blush_1":0,"chain_2":0,"bracelets_2":0,"chain_1":0,"moles_2":0,"glasses_1":5,"bracelets_1":-1,"beard_2":0,"bags_1":0,"bags_2":0,"hair_2":0,"complexion_1":0,"eyebrows_2":8,"ears_1":-1,"lipstick_4":0,"face":45,"beard_1":0,"glasses_2":0,"tshirt_2":0,"watches_1":-1,"shoes_2":5,"bodyb_2":0,"blush_3":0,"hair_color_2":37}', 'police', 4, '[]', '{"y":-995.5,"x":452.8,"z":36.8}', 1800, 0, 'superadmin', 'Paige', 'Turner', '1980-12-14', 'F', '173', '5975', NULL, NULL, 0, 0, '[{"name":"hunger","val":427100,"percent":42.71},{"name":"thirst","val":445325,"percent":44.5325},{"name":"drunk","val":0,"percent":0.0}]'),
608 ('steam:11000010949144a', 'license:1dc47bb4174aca830ca2d403aa9e1db1b2a42408', 0, 'Stotzie', '{"shoes_1":10,"chest_1":0,"skin":0,"blemishes_1":0,"mask_1":0,"chest_2":0,"ears_1":-1,"moles_1":0,"bags_1":0,"complexion_1":0,"watches_2":0,"tshirt_1":33,"chest_3":0,"lipstick_2":0,"decals_2":0,"eyebrows_4":0,"blemishes_2":0,"makeup_4":0,"age_1":0,"beard_3":0,"ears_2":0,"lipstick_3":0,"beard_4":0,"makeup_2":0,"helmet_1":-1,"makeup_1":0,"face":5,"bproof_2":0,"sun_2":0,"sun_1":0,"bracelets_2":0,"lipstick_1":0,"bodyb_1":0,"sex":0,"age_2":0,"helmet_2":0,"torso_2":0,"pants_1":22,"arms":24,"torso_1":29,"decals_1":0,"makeup_3":0,"eyebrows_1":0,"arms_2":0,"hair_color_1":0,"eyebrows_3":0,"blush_2":0,"hair_1":21,"pants_2":0,"chain_2":0,"tshirt_2":0,"hair_2":0,"moles_2":0,"bracelets_1":-1,"lipstick_4":0,"beard_2":0,"mask_2":0,"chain_1":0,"eye_color":0,"hair_color_2":0,"eyebrows_2":0,"complexion_2":0,"shoes_2":0,"glasses_1":0,"beard_1":0,"glasses_2":0,"blush_3":0,"watches_1":-1,"bodyb_2":0,"blush_1":0,"bags_2":0,"bproof_1":0}', 'police', 2, '[{"ammo":0,"label":"Bat","components":[],"name":"WEAPON_BAT"},{"ammo":111,"label":"Combat pistol","components":["clip_default"],"name":"WEAPON_COMBATPISTOL"},{"ammo":1565,"label":"Fire extinguisher","components":[],"name":"WEAPON_FIREEXTINGUISHER"}]', '{"y":-994.2,"x":463.9,"z":35.9}', 520, 0, 'superadmin', 'Johnny', 'Harlem', '1990-01-01', 'M', '172', '1628', NULL, NULL, 0, 0, '[{"name":"hunger","val":433500,"percent":43.35},{"name":"thirst","val":450125,"percent":45.0125},{"name":"drunk","val":0,"percent":0.0}]'),
609 ('steam:110000135d961a4', 'license:3cb5b8b1ff730d23370fd70e296124d394dd2c7d', 10000, 'Domont', '{"eye_color":8,"bracelets_2":0,"bproof_1":18,"blemishes_1":0,"mask_1":0,"decals_2":0,"ears_1":-1,"face":13,"tshirt_2":0,"bproof_2":2,"skin":0,"arms_2":0,"glasses_1":12,"bags_2":0,"sun_2":0,"beard_4":0,"chain_2":0,"beard_2":10,"shoes_2":4,"torso_2":3,"age_1":0,"tshirt_1":130,"age_2":0,"helmet_1":33,"blemishes_2":0,"lipstick_2":0,"complexion_2":0,"lipstick_1":0,"pants_1":47,"eyebrows_2":0,"arms":11,"helmet_2":0,"sex":0,"hair_color_1":28,"complexion_1":0,"shoes_1":71,"lipstick_3":0,"sun_1":0,"makeup_2":0,"pants_2":0,"watches_1":-1,"hair_1":5,"beard_3":28,"blush_1":0,"moles_1":0,"ears_2":0,"makeup_1":0,"chest_1":0,"watches_2":0,"chest_2":0,"bodyb_1":0,"bracelets_1":-1,"blush_2":0,"makeup_4":0,"hair_color_2":29,"eyebrows_4":0,"glasses_2":3,"makeup_3":0,"chain_1":0,"beard_1":23,"torso_1":44,"eyebrows_3":0,"moles_2":0,"lipstick_4":0,"eyebrows_1":0,"bags_1":0,"blush_3":0,"mask_2":0,"chest_3":0,"decals_1":0,"hair_2":0,"bodyb_2":0}', 'unemployed', 0, '[{"ammo":0,"label":"Pistol","name":"WEAPON_PISTOL","components":["clip_default"]},{"ammo":25,"label":"Pump shotgun","name":"WEAPON_PUMPSHOTGUN","components":[]},{"ammo":76,"label":"Carbine rifle","name":"WEAPON_CARBINERIFLE","components":["clip_default"]},{"ammo":2,"label":"Rocket launcher","name":"WEAPON_RPG","components":[]}]', '{"z":62.4,"y":4973.9,"x":-1507.5}', 10000, 0, 'superadmin', 'Richard', 'Rasche', '1974-12-13', 'M', '155', '4473', NULL, NULL, 0, 0, NULL);
610/*!40000 ALTER TABLE `users` ENABLE KEYS */;
611
612-- Dumping structure for table essentialmode.user_accounts
613CREATE TABLE IF NOT EXISTS `user_accounts` (
614 `id` int(11) NOT NULL AUTO_INCREMENT,
615 `identifier` varchar(22) COLLATE utf8mb4_bin NOT NULL,
616 `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
617 `money` double NOT NULL DEFAULT 0,
618 PRIMARY KEY (`id`)
619) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
620
621-- Dumping data for table essentialmode.user_accounts: ~7 rows (approximately)
622/*!40000 ALTER TABLE `user_accounts` DISABLE KEYS */;
623INSERT INTO `user_accounts` (`id`, `identifier`, `name`, `money`) VALUES
624 (6, 'steam:110000105b25f97', 'black_money', 0),
625 (7, 'steam:11000010706aaf5', 'black_money', 0),
626 (8, 'steam:110000135d961a4', 'black_money', 0),
627 (9, 'steam:11000010949144a', 'black_money', 0),
628 (10, 'steam:110000108d48a86', 'black_money', 0),
629 (11, 'steam:1100001034d094b', 'black_money', 0),
630 (12, 'steam:1100001037b8282', 'black_money', 0);
631/*!40000 ALTER TABLE `user_accounts` ENABLE KEYS */;
632
633-- Dumping structure for table essentialmode.user_inventory
634CREATE TABLE IF NOT EXISTS `user_inventory` (
635 `id` int(11) NOT NULL AUTO_INCREMENT,
636 `identifier` varchar(22) COLLATE utf8mb4_bin NOT NULL,
637 `item` varchar(50) COLLATE utf8mb4_bin NOT NULL,
638 `count` int(11) NOT NULL,
639 PRIMARY KEY (`id`)
640) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
641
642-- Dumping data for table essentialmode.user_inventory: ~54 rows (approximately)
643/*!40000 ALTER TABLE `user_inventory` DISABLE KEYS */;
644INSERT INTO `user_inventory` (`id`, `identifier`, `item`, `count`) VALUES
645 (1, 'steam:110000105b25f97', 'bandage', 0),
646 (2, 'steam:110000105b25f97', 'medikit', 0),
647 (3, 'steam:11000010706aaf5', 'bandage', 0),
648 (4, 'steam:11000010706aaf5', 'medikit', 0),
649 (5, 'steam:110000135d961a4', 'bandage', 0),
650 (6, 'steam:110000135d961a4', 'medikit', 0),
651 (7, 'steam:11000010949144a', 'medikit', 0),
652 (8, 'steam:11000010949144a', 'bandage', 0),
653 (9, 'steam:110000108d48a86', 'medikit', 0),
654 (10, 'steam:110000108d48a86', 'bandage', 0),
655 (11, 'steam:1100001034d094b', 'bandage', 0),
656 (12, 'steam:1100001034d094b', 'medikit', 0),
657 (13, 'steam:11000010706aaf5', 'vodka', 0),
658 (14, 'steam:11000010706aaf5', 'whisky', 0),
659 (15, 'steam:11000010706aaf5', 'tequila', 0),
660 (16, 'steam:11000010706aaf5', 'beer', 0),
661 (17, 'steam:11000010706aaf5', 'bread', 0),
662 (18, 'steam:11000010706aaf5', 'water', 0),
663 (19, 'steam:11000010706aaf5', 'wine', 0),
664 (20, 'steam:110000105b25f97', 'vodka', 0),
665 (21, 'steam:110000105b25f97', 'whisky', 0),
666 (22, 'steam:110000105b25f97', 'tequila', 0),
667 (23, 'steam:110000105b25f97', 'beer', 0),
668 (24, 'steam:110000105b25f97', 'bread', 0),
669 (25, 'steam:110000105b25f97', 'water', 0),
670 (26, 'steam:110000105b25f97', 'wine', 0),
671 (27, 'steam:1100001037b8282', 'bread', 197),
672 (28, 'steam:1100001037b8282', 'bandage', 0),
673 (29, 'steam:1100001037b8282', 'vodka', 0),
674 (30, 'steam:1100001037b8282', 'tequila', 0),
675 (31, 'steam:1100001037b8282', 'medikit', 0),
676 (32, 'steam:1100001037b8282', 'beer', 0),
677 (33, 'steam:1100001037b8282', 'wine', 0),
678 (34, 'steam:1100001037b8282', 'whisky', 3),
679 (35, 'steam:1100001037b8282', 'water', 197),
680 (36, 'steam:110000105b25f97', 'jewels', 0),
681 (37, 'steam:11000010706aaf5', 'jewels', 0),
682 (38, 'steam:1100001037b8282', 'jewels', 0),
683 (39, 'steam:110000108d48a86', 'water', 0),
684 (40, 'steam:110000108d48a86', 'tequila', 0),
685 (41, 'steam:110000108d48a86', 'bread', 0),
686 (42, 'steam:110000108d48a86', 'vodka', 0),
687 (43, 'steam:110000108d48a86', 'wine', 0),
688 (44, 'steam:110000108d48a86', 'jewels', 0),
689 (45, 'steam:110000108d48a86', 'whisky', 0),
690 (46, 'steam:110000108d48a86', 'beer', 0),
691 (47, 'steam:11000010949144a', 'water', 0),
692 (48, 'steam:11000010949144a', 'tequila', 0),
693 (49, 'steam:11000010949144a', 'bread', 0),
694 (50, 'steam:11000010949144a', 'vodka', 0),
695 (51, 'steam:11000010949144a', 'wine', 0),
696 (52, 'steam:11000010949144a', 'jewels', 0),
697 (53, 'steam:11000010949144a', 'whisky', 0),
698 (54, 'steam:11000010949144a', 'beer', 0);
699/*!40000 ALTER TABLE `user_inventory` ENABLE KEYS */;
700
701-- Dumping structure for table essentialmode.user_lastcharacter
702CREATE TABLE IF NOT EXISTS `user_lastcharacter` (
703 `steamid` varchar(255) NOT NULL,
704 `charid` int(11) NOT NULL
705) ENGINE=InnoDB DEFAULT CHARSET=latin1;
706
707-- Dumping data for table essentialmode.user_lastcharacter: ~7 rows (approximately)
708/*!40000 ALTER TABLE `user_lastcharacter` DISABLE KEYS */;
709INSERT INTO `user_lastcharacter` (`steamid`, `charid`) VALUES
710 ('steam:110000105b25f97', 1),
711 ('steam:11000010706aaf5', 1),
712 ('steam:110000135d961a4', 1),
713 ('steam:110000108d48a86', 1),
714 ('steam:11000010949144a', 1),
715 ('steam:1100001034d094b', 1),
716 ('steam:1100001037b8282', 1);
717/*!40000 ALTER TABLE `user_lastcharacter` ENABLE KEYS */;
718
719-- Dumping structure for table essentialmode.user_licenses
720CREATE TABLE IF NOT EXISTS `user_licenses` (
721 `id` int(11) NOT NULL AUTO_INCREMENT,
722 `type` varchar(60) COLLATE utf8mb4_bin NOT NULL,
723 `owner` varchar(60) COLLATE utf8mb4_bin NOT NULL,
724 PRIMARY KEY (`id`)
725) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
726
727-- Dumping data for table essentialmode.user_licenses: ~0 rows (approximately)
728/*!40000 ALTER TABLE `user_licenses` DISABLE KEYS */;
729/*!40000 ALTER TABLE `user_licenses` ENABLE KEYS */;
730
731-- Dumping structure for table essentialmode.vehicles
732CREATE TABLE IF NOT EXISTS `vehicles` (
733 `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
734 `model` varchar(60) COLLATE utf8mb4_bin NOT NULL,
735 `price` int(11) NOT NULL,
736 `category` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
737 PRIMARY KEY (`model`)
738) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
739
740-- Dumping data for table essentialmode.vehicles: ~240 rows (approximately)
741/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
742INSERT INTO `vehicles` (`name`, `model`, `price`, `category`) VALUES
743 ('Akuma', 'AKUMA', 7500, 'motorcycles'),
744 ('Adder', 'adder', 900000, 'super'),
745 ('Alpha', 'alpha', 60000, 'sports'),
746 ('Ardent', 'ardent', 1150000, 'sportsclassics'),
747 ('Asea', 'asea', 5500, 'sedans'),
748 ('Autarch', 'autarch', 1955000, 'super'),
749 ('Avarus', 'avarus', 18000, 'motorcycles'),
750 ('Bagger', 'bagger', 13500, 'motorcycles'),
751 ('Baller', 'baller2', 40000, 'suvs'),
752 ('Baller Sport', 'baller3', 60000, 'suvs'),
753 ('Banshee', 'banshee', 70000, 'sports'),
754 ('Banshee 900R', 'banshee2', 255000, 'super'),
755 ('Bati 801', 'bati', 12000, 'motorcycles'),
756 ('Bati 801RR', 'bati2', 19000, 'motorcycles'),
757 ('Bestia GTS', 'bestiagts', 55000, 'sports'),
758 ('BF400', 'bf400', 6500, 'motorcycles'),
759 ('Bf Injection', 'bfinjection', 16000, 'offroad'),
760 ('Bifta', 'bifta', 12000, 'offroad'),
761 ('Bison', 'bison', 45000, 'vans'),
762 ('Blade', 'blade', 15000, 'muscle'),
763 ('Blazer', 'blazer', 6500, 'offroad'),
764 ('Blazer Sport', 'blazer4', 8500, 'offroad'),
765 ('blazer5', 'blazer5', 1755600, 'offroad'),
766 ('Blista', 'blista', 8000, 'compacts'),
767 ('BMX (velo)', 'bmx', 160, 'motorcycles'),
768 ('Bobcat XL', 'bobcatxl', 32000, 'vans'),
769 ('Brawler', 'brawler', 45000, 'offroad'),
770 ('Brioso R/A', 'brioso', 18000, 'compacts'),
771 ('Btype', 'btype', 62000, 'sportsclassics'),
772 ('Btype Hotroad', 'btype2', 155000, 'sportsclassics'),
773 ('Btype Luxe', 'btype3', 85000, 'sportsclassics'),
774 ('Buccaneer', 'buccaneer', 18000, 'muscle'),
775 ('Buccaneer Rider', 'buccaneer2', 24000, 'muscle'),
776 ('Buffalo', 'buffalo', 12000, 'sports'),
777 ('Buffalo S', 'buffalo2', 20000, 'sports'),
778 ('Bullet', 'bullet', 90000, 'super'),
779 ('Burrito', 'burrito3', 19000, 'vans'),
780 ('Camper', 'camper', 42000, 'vans'),
781 ('Carbonizzare', 'carbonizzare', 75000, 'sports'),
782 ('Carbon RS', 'carbonrs', 18000, 'motorcycles'),
783 ('Casco', 'casco', 30000, 'sportsclassics'),
784 ('Cavalcade', 'cavalcade2', 55000, 'suvs'),
785 ('Cheetah', 'cheetah', 375000, 'super'),
786 ('Chimera', 'chimera', 38000, 'motorcycles'),
787 ('Chino', 'chino', 15000, 'muscle'),
788 ('Chino Luxe', 'chino2', 19000, 'muscle'),
789 ('Cliffhanger', 'cliffhanger', 9500, 'motorcycles'),
790 ('Cognoscenti Cabrio', 'cogcabrio', 55000, 'coupes'),
791 ('Cognoscenti', 'cognoscenti', 55000, 'sedans'),
792 ('Comet', 'comet2', 65000, 'sports'),
793 ('Comet 5', 'comet5', 1145000, 'sports'),
794 ('Contender', 'contender', 70000, 'suvs'),
795 ('Coquette', 'coquette', 65000, 'sports'),
796 ('Coquette Classic', 'coquette2', 40000, 'sportsclassics'),
797 ('Coquette BlackFin', 'coquette3', 55000, 'muscle'),
798 ('Cruiser (velo)', 'cruiser', 510, 'motorcycles'),
799 ('Cyclone', 'cyclone', 1890000, 'super'),
800 ('Daemon', 'daemon', 11500, 'motorcycles'),
801 ('Daemon High', 'daemon2', 13500, 'motorcycles'),
802 ('Defiler', 'defiler', 9800, 'motorcycles'),
803 ('Dominator', 'dominator', 35000, 'muscle'),
804 ('Double T', 'double', 28000, 'motorcycles'),
805 ('Dubsta', 'dubsta', 45000, 'suvs'),
806 ('Dubsta Luxuary', 'dubsta2', 60000, 'suvs'),
807 ('Bubsta 6x6', 'dubsta3', 120000, 'offroad'),
808 ('Dukes', 'dukes', 28000, 'muscle'),
809 ('Dune Buggy', 'dune', 8000, 'offroad'),
810 ('Elegy', 'elegy2', 38500, 'sports'),
811 ('Emperor', 'emperor', 8500, 'sedans'),
812 ('Enduro', 'enduro', 5500, 'motorcycles'),
813 ('Entity XF', 'entityxf', 425000, 'super'),
814 ('Esskey', 'esskey', 4200, 'motorcycles'),
815 ('Exemplar', 'exemplar', 32000, 'coupes'),
816 ('F620', 'f620', 40000, 'coupes'),
817 ('Faction', 'faction', 20000, 'muscle'),
818 ('Faction Rider', 'faction2', 30000, 'muscle'),
819 ('Faction XL', 'faction3', 40000, 'muscle'),
820 ('Faggio', 'faggio', 1900, 'motorcycles'),
821 ('Vespa', 'faggio2', 2800, 'motorcycles'),
822 ('Felon', 'felon', 42000, 'coupes'),
823 ('Felon GT', 'felon2', 55000, 'coupes'),
824 ('Feltzer', 'feltzer2', 55000, 'sports'),
825 ('Stirling GT', 'feltzer3', 65000, 'sportsclassics'),
826 ('Fixter (velo)', 'fixter', 225, 'motorcycles'),
827 ('FMJ', 'fmj', 185000, 'super'),
828 ('Fhantom', 'fq2', 17000, 'suvs'),
829 ('Fugitive', 'fugitive', 12000, 'sedans'),
830 ('Furore GT', 'furoregt', 45000, 'sports'),
831 ('Fusilade', 'fusilade', 40000, 'sports'),
832 ('Gargoyle', 'gargoyle', 16500, 'motorcycles'),
833 ('Gauntlet', 'gauntlet', 30000, 'muscle'),
834 ('Gang Burrito', 'gburrito', 45000, 'vans'),
835 ('Burrito', 'gburrito2', 29000, 'vans'),
836 ('Glendale', 'glendale', 6500, 'sedans'),
837 ('Grabger', 'granger', 50000, 'suvs'),
838 ('Gresley', 'gresley', 47500, 'suvs'),
839 ('GT 500', 'gt500', 785000, 'sportsclassics'),
840 ('Guardian', 'guardian', 45000, 'offroad'),
841 ('Hakuchou', 'hakuchou', 31000, 'motorcycles'),
842 ('Hakuchou Sport', 'hakuchou2', 55000, 'motorcycles'),
843 ('Hermes', 'hermes', 535000, 'muscle'),
844 ('Hexer', 'hexer', 12000, 'motorcycles'),
845 ('Hotknife', 'hotknife', 125000, 'muscle'),
846 ('Huntley S', 'huntley', 40000, 'suvs'),
847 ('Hustler', 'hustler', 625000, 'muscle'),
848 ('Infernus', 'infernus', 180000, 'super'),
849 ('Innovation', 'innovation', 23500, 'motorcycles'),
850 ('Intruder', 'intruder', 7500, 'sedans'),
851 ('Issi', 'issi2', 10000, 'compacts'),
852 ('Jackal', 'jackal', 38000, 'coupes'),
853 ('Jester', 'jester', 65000, 'sports'),
854 ('Jester(Racecar)', 'jester2', 135000, 'sports'),
855 ('Journey', 'journey', 6500, 'vans'),
856 ('Kamacho', 'kamacho', 345000, 'offroad'),
857 ('Khamelion', 'khamelion', 38000, 'sports'),
858 ('Kuruma', 'kuruma', 30000, 'sports'),
859 ('Landstalker', 'landstalker', 35000, 'suvs'),
860 ('RE-7B', 'le7b', 325000, 'super'),
861 ('Lynx', 'lynx', 40000, 'sports'),
862 ('Mamba', 'mamba', 70000, 'sports'),
863 ('Manana', 'manana', 12800, 'sportsclassics'),
864 ('Manchez', 'manchez', 5300, 'motorcycles'),
865 ('Massacro', 'massacro', 65000, 'sports'),
866 ('Massacro(Racecar)', 'massacro2', 130000, 'sports'),
867 ('Mesa', 'mesa', 16000, 'suvs'),
868 ('Mesa Trail', 'mesa3', 40000, 'suvs'),
869 ('Minivan', 'minivan', 13000, 'vans'),
870 ('Monroe', 'monroe', 55000, 'sportsclassics'),
871 ('The Liberator', 'monster', 210000, 'offroad'),
872 ('Moonbeam', 'moonbeam', 18000, 'vans'),
873 ('Moonbeam Rider', 'moonbeam2', 35000, 'vans'),
874 ('Nemesis', 'nemesis', 5800, 'motorcycles'),
875 ('Neon', 'neon', 1500000, 'sports'),
876 ('Nightblade', 'nightblade', 35000, 'motorcycles'),
877 ('Nightshade', 'nightshade', 65000, 'muscle'),
878 ('9F', 'ninef', 65000, 'sports'),
879 ('9F Cabrio', 'ninef2', 80000, 'sports'),
880 ('Omnis', 'omnis', 35000, 'sports'),
881 ('Oracle XS', 'oracle2', 35000, 'coupes'),
882 ('Osiris', 'osiris', 160000, 'super'),
883 ('Panto', 'panto', 10000, 'compacts'),
884 ('Paradise', 'paradise', 19000, 'vans'),
885 ('Pariah', 'pariah', 1420000, 'sports'),
886 ('Patriot', 'patriot', 55000, 'suvs'),
887 ('PCJ-600', 'pcj', 6200, 'motorcycles'),
888 ('Penumbra', 'penumbra', 28000, 'sports'),
889 ('Pfister', 'pfister811', 85000, 'super'),
890 ('Phoenix', 'phoenix', 12500, 'muscle'),
891 ('Picador', 'picador', 18000, 'muscle'),
892 ('Pigalle', 'pigalle', 20000, 'sportsclassics'),
893 ('Prairie', 'prairie', 12000, 'compacts'),
894 ('Premier', 'premier', 8000, 'sedans'),
895 ('Primo Custom', 'primo2', 14000, 'sedans'),
896 ('X80 Proto', 'prototipo', 2500000, 'super'),
897 ('Radius', 'radi', 29000, 'suvs'),
898 ('raiden', 'raiden', 1375000, 'sports'),
899 ('Rapid GT', 'rapidgt', 35000, 'sports'),
900 ('Rapid GT Convertible', 'rapidgt2', 45000, 'sports'),
901 ('Rapid GT3', 'rapidgt3', 885000, 'sportsclassics'),
902 ('Reaper', 'reaper', 150000, 'super'),
903 ('Rebel', 'rebel2', 35000, 'offroad'),
904 ('Regina', 'regina', 5000, 'sedans'),
905 ('Retinue', 'retinue', 615000, 'sportsclassics'),
906 ('Revolter', 'revolter', 1610000, 'sports'),
907 ('riata', 'riata', 380000, 'offroad'),
908 ('Rocoto', 'rocoto', 45000, 'suvs'),
909 ('Ruffian', 'ruffian', 6800, 'motorcycles'),
910 ('Rumpo', 'rumpo', 15000, 'vans'),
911 ('Rumpo Trail', 'rumpo3', 19500, 'vans'),
912 ('Sabre Turbo', 'sabregt', 20000, 'muscle'),
913 ('Sabre GT', 'sabregt2', 25000, 'muscle'),
914 ('Sanchez', 'sanchez', 5300, 'motorcycles'),
915 ('Sanchez Sport', 'sanchez2', 5300, 'motorcycles'),
916 ('Sanctus', 'sanctus', 25000, 'motorcycles'),
917 ('Sandking', 'sandking', 55000, 'offroad'),
918 ('Savestra', 'savestra', 990000, 'sportsclassics'),
919 ('SC 1', 'sc1', 1603000, 'super'),
920 ('Schafter', 'schafter2', 25000, 'sedans'),
921 ('Schafter V12', 'schafter3', 50000, 'sports'),
922 ('Scorcher (velo)', 'scorcher', 280, 'motorcycles'),
923 ('Seminole', 'seminole', 25000, 'suvs'),
924 ('Sentinel', 'sentinel', 32000, 'coupes'),
925 ('Sentinel XS', 'sentinel2', 40000, 'coupes'),
926 ('Sentinel3', 'sentinel3', 650000, 'sports'),
927 ('Seven 70', 'seven70', 39500, 'sports'),
928 ('ETR1', 'sheava', 220000, 'super'),
929 ('Shotaro Concept', 'shotaro', 320000, 'motorcycles'),
930 ('Slam Van', 'slamvan3', 11500, 'muscle'),
931 ('Sovereign', 'sovereign', 22000, 'motorcycles'),
932 ('Stinger', 'stinger', 80000, 'sportsclassics'),
933 ('Stinger GT', 'stingergt', 75000, 'sportsclassics'),
934 ('Streiter', 'streiter', 500000, 'sports'),
935 ('Stretch', 'stretch', 90000, 'sedans'),
936 ('Stromberg', 'stromberg', 3185350, 'sports'),
937 ('Sultan', 'sultan', 15000, 'sports'),
938 ('Sultan RS', 'sultanrs', 65000, 'super'),
939 ('Super Diamond', 'superd', 130000, 'sedans'),
940 ('Surano', 'surano', 50000, 'sports'),
941 ('Surfer', 'surfer', 12000, 'vans'),
942 ('T20', 't20', 300000, 'super'),
943 ('Tailgater', 'tailgater', 30000, 'sedans'),
944 ('Tampa', 'tampa', 16000, 'muscle'),
945 ('Drift Tampa', 'tampa2', 80000, 'sports'),
946 ('Thrust', 'thrust', 24000, 'motorcycles'),
947 ('Tri bike (velo)', 'tribike3', 520, 'motorcycles'),
948 ('Trophy Truck', 'trophytruck', 60000, 'offroad'),
949 ('Trophy Truck Limited', 'trophytruck2', 80000, 'offroad'),
950 ('Tropos', 'tropos', 40000, 'sports'),
951 ('Turismo R', 'turismor', 350000, 'super'),
952 ('Tyrus', 'tyrus', 600000, 'super'),
953 ('Vacca', 'vacca', 120000, 'super'),
954 ('Vader', 'vader', 7200, 'motorcycles'),
955 ('Verlierer', 'verlierer2', 70000, 'sports'),
956 ('Vigero', 'vigero', 12500, 'muscle'),
957 ('Virgo', 'virgo', 14000, 'muscle'),
958 ('Viseris', 'viseris', 875000, 'sportsclassics'),
959 ('Visione', 'visione', 2250000, 'super'),
960 ('Voltic', 'voltic', 90000, 'super'),
961 ('Voodoo', 'voodoo', 7200, 'muscle'),
962 ('Vortex', 'vortex', 9800, 'motorcycles'),
963 ('Warrener', 'warrener', 4000, 'sedans'),
964 ('Washington', 'washington', 9000, 'sedans'),
965 ('Windsor', 'windsor', 95000, 'coupes'),
966 ('Windsor Drop', 'windsor2', 125000, 'coupes'),
967 ('Woflsbane', 'wolfsbane', 9000, 'motorcycles'),
968 ('XLS', 'xls', 32000, 'suvs'),
969 ('Yosemite', 'yosemite', 485000, 'muscle'),
970 ('Youga', 'youga', 10800, 'vans'),
971 ('Youga Luxuary', 'youga2', 14500, 'vans'),
972 ('Z190', 'z190', 900000, 'sportsclassics'),
973 ('Zentorno', 'zentorno', 1500000, 'super'),
974 ('Zion', 'zion', 36000, 'coupes'),
975 ('Zion Cabrio', 'zion2', 45000, 'coupes'),
976 ('Zombie', 'zombiea', 9500, 'motorcycles'),
977 ('Zombie Luxuary', 'zombieb', 12000, 'motorcycles'),
978 ('Z-Type', 'ztype', 220000, 'sportsclassics');
979/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
980
981-- Dumping structure for table essentialmode.vehicle_categories
982CREATE TABLE IF NOT EXISTS `vehicle_categories` (
983 `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
984 `label` varchar(60) COLLATE utf8mb4_bin NOT NULL,
985 PRIMARY KEY (`name`)
986) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
987
988-- Dumping data for table essentialmode.vehicle_categories: ~11 rows (approximately)
989/*!40000 ALTER TABLE `vehicle_categories` DISABLE KEYS */;
990INSERT INTO `vehicle_categories` (`name`, `label`) VALUES
991 ('compacts', 'Compacts'),
992 ('coupes', 'Coupes'),
993 ('motorcycles', 'Motos'),
994 ('muscle', 'Muscle'),
995 ('offroad', 'Off Road'),
996 ('sedans', 'Sedans'),
997 ('sports', 'Sports'),
998 ('sportsclassics', 'Sports Classics'),
999 ('super', 'Super'),
1000 ('suvs', 'SUVs'),
1001 ('vans', 'Vans');
1002/*!40000 ALTER TABLE `vehicle_categories` ENABLE KEYS */;
1003
1004-- Dumping structure for table essentialmode.vehicle_sold
1005CREATE TABLE IF NOT EXISTS `vehicle_sold` (
1006 `client` varchar(50) COLLATE utf8mb4_bin NOT NULL,
1007 `model` varchar(50) COLLATE utf8mb4_bin NOT NULL,
1008 `plate` varchar(50) COLLATE utf8mb4_bin NOT NULL,
1009 `soldby` varchar(50) COLLATE utf8mb4_bin NOT NULL,
1010 `date` varchar(50) COLLATE utf8mb4_bin NOT NULL,
1011 PRIMARY KEY (`plate`)
1012) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
1013
1014-- Dumping data for table essentialmode.vehicle_sold: ~0 rows (approximately)
1015/*!40000 ALTER TABLE `vehicle_sold` DISABLE KEYS */;
1016/*!40000 ALTER TABLE `vehicle_sold` ENABLE KEYS */;
1017
1018-- Dumping structure for table essentialmode.warrants_list
1019CREATE TABLE IF NOT EXISTS `warrants_list` (
1020 `id` int(11) NOT NULL AUTO_INCREMENT,
1021 `json_data` longtext NOT NULL,
1022 PRIMARY KEY (`id`)
1023) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1024
1025-- Dumping data for table essentialmode.warrants_list: ~2 rows (approximately)
1026/*!40000 ALTER TABLE `warrants_list` DISABLE KEYS */;
1027INSERT INTO `warrants_list` (`id`, `json_data`) VALUES
1028 (2, '{"Officer":"steam:11000010949144a","Suspect":"Pasties ","Description":"Dongle","OfficerC":"Shirtless", "Date":"Mon Nov 4 02:34:37 2019"}'),
1029 (3, '{"Officer":"steam:110000108d48a86","Suspect":"Dick Rasche","Description":"Wanted -- Idiocy","OfficerC":"Rocket Launcher and lighting ALL OF LSPD ON FIRE", "Date":"Mon Nov 4 02:34:58 2019"}');
1030/*!40000 ALTER TABLE `warrants_list` ENABLE KEYS */;
1031
1032/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
1033/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
1034/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;