wwg1VeRk

1-- Dumping structure for table essentialmode.addon_account
2CREATE TABLE IF NOT EXISTS `addon_account` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
5  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
6  `shared` int(11) NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
9
10-- Dumping structure for table essentialmode.addon_account_data
11CREATE TABLE IF NOT EXISTS `addon_account_data` (
12  `id` int(11) NOT NULL AUTO_INCREMENT,
13  `account_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
14  `money` double NOT NULL,
15  `owner` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=11869 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
18
19-- Dumping structure for table essentialmode.addon_inventory
20CREATE TABLE IF NOT EXISTS `addon_inventory` (
21  `id` int(11) NOT NULL AUTO_INCREMENT,
22  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
23  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
24  `shared` int(11) NOT NULL,
25  PRIMARY KEY (`id`)
26) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
27
28-- Dumping structure for table essentialmode.addon_inventory_items
29CREATE TABLE IF NOT EXISTS `addon_inventory_items` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `inventory_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
32  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
33  `count` int(11) NOT NULL,
34  `owner` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
37
38-- Dumping structure for table essentialmode.billing
39CREATE TABLE IF NOT EXISTS `billing` (
40  `id` int(11) NOT NULL AUTO_INCREMENT,
41  `identifier` varchar(255) COLLATE utf8mb4_bin NOT NULL,
42  `sender` varchar(255) COLLATE utf8mb4_bin NOT NULL,
43  `target_type` varchar(50) COLLATE utf8mb4_bin NOT NULL,
44  `target` varchar(255) COLLATE utf8mb4_bin NOT NULL,
45  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
46  `amount` int(11) NOT NULL,
47  PRIMARY KEY (`id`)
48) ENGINE=InnoDB AUTO_INCREMENT=1672 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
49
50-- Dumping structure for table essentialmode.characters
51CREATE TABLE IF NOT EXISTS `characters` (
52  `identifier` varchar(255) COLLATE utf8mb4_bin NOT NULL,
53  `firstname` varchar(255) COLLATE utf8mb4_bin NOT NULL,
54  `lastname` varchar(255) COLLATE utf8mb4_bin NOT NULL,
55  `dateofbirth` varchar(255) COLLATE utf8mb4_bin NOT NULL,
56  `sex` varchar(1) COLLATE utf8mb4_bin NOT NULL DEFAULT 'f',
57  `height` varchar(128) COLLATE utf8mb4_bin NOT NULL
58) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
59
60-- Dumping structure for table essentialmode.coffees
61CREATE TABLE IF NOT EXISTS `coffees` (
62  `id` int(11) NOT NULL AUTO_INCREMENT,
63  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
64  `item` varchar(255) COLLATE utf8mb4_bin NOT NULL,
65  `price` int(11) NOT NULL,
66  PRIMARY KEY (`id`)
67) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
68
69-- Dumping structure for table essentialmode.datastore
70CREATE TABLE IF NOT EXISTS `datastore` (
71  `id` int(11) NOT NULL AUTO_INCREMENT,
72  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
73  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
74  `shared` int(11) NOT NULL,
75  PRIMARY KEY (`id`)
76) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
77
78-- Dumping structure for table essentialmode.datastore_data
79CREATE TABLE IF NOT EXISTS `datastore_data` (
80  `id` int(11) NOT NULL AUTO_INCREMENT,
81  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
82  `owner` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
83  `data` longtext COLLATE utf8mb4_bin,
84  PRIMARY KEY (`id`)
85) ENGINE=InnoDB AUTO_INCREMENT=7958 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
86
87-- Dumping structure for table essentialmode.dock
88CREATE TABLE IF NOT EXISTS `dock` (
89  `id` int(11) NOT NULL AUTO_INCREMENT,
90  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
91  `model` varchar(60) COLLATE utf8mb4_bin NOT NULL,
92  `price` int(11) NOT NULL,
93  `category` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
94  PRIMARY KEY (`id`)
95) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
96
97-- Dumping structure for table essentialmode.dock_categories
98CREATE TABLE IF NOT EXISTS `dock_categories` (
99  `id` int(11) NOT NULL AUTO_INCREMENT,
100  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
101  `label` varchar(60) COLLATE utf8mb4_bin NOT NULL,
102  PRIMARY KEY (`id`)
103) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
104
105-- Dumping structure for table essentialmode.fine_types
106CREATE TABLE IF NOT EXISTS `fine_types` (
107  `id` int(11) NOT NULL AUTO_INCREMENT,
108  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
109  `amount` int(11) DEFAULT NULL,
110  `category` int(11) DEFAULT NULL,
111  PRIMARY KEY (`id`)
112) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
113
114-- Dumping structure for table essentialmode.fine_types_ambulance
115CREATE TABLE IF NOT EXISTS `fine_types_ambulance` (
116  `id` int(11) NOT NULL,
117  `label` varchar(255) DEFAULT NULL,
118  `amount` int(11) DEFAULT NULL,
119  `category` int(11) DEFAULT NULL
120) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
121
122-- Dumping structure for table essentialmode.fine_types_bishops
123CREATE TABLE IF NOT EXISTS `fine_types_bishops` (
124  `id` int(11) NOT NULL AUTO_INCREMENT,
125  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
126  `amount` int(11) DEFAULT NULL,
127  `category` int(11) DEFAULT NULL,
128  PRIMARY KEY (`id`)
129) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
130
131-- Dumping structure for table essentialmode.fine_types_bountyhunter
132CREATE TABLE IF NOT EXISTS `fine_types_bountyhunter` (
133  `id` int(11) NOT NULL AUTO_INCREMENT,
134  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
135  `amount` int(11) DEFAULT NULL,
136  `category` int(11) DEFAULT NULL,
137  PRIMARY KEY (`id`)
138) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
139
140-- Dumping structure for table essentialmode.fine_types_dismay
141CREATE TABLE IF NOT EXISTS `fine_types_dismay` (
142  `id` int(11) NOT NULL AUTO_INCREMENT,
143  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
144  `amount` int(11) DEFAULT NULL,
145  `category` int(11) DEFAULT NULL,
146  PRIMARY KEY (`id`)
147) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
148
149-- Dumping structure for table essentialmode.fine_types_grove
150CREATE TABLE IF NOT EXISTS `fine_types_grove` (
151  `id` int(11) NOT NULL AUTO_INCREMENT,
152  `label` varchar(255) DEFAULT NULL,
153  `amount` int(11) DEFAULT NULL,
154  `category` int(11) DEFAULT NULL,
155  PRIMARY KEY (`id`)
156) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
157
158-- Dumping structure for table essentialmode.fine_types_irish
159CREATE TABLE IF NOT EXISTS `fine_types_irish` (
160  `id` int(11) NOT NULL AUTO_INCREMENT,
161  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
162  `amount` int(11) DEFAULT NULL,
163  `category` int(11) DEFAULT NULL,
164  PRIMARY KEY (`id`)
165) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
166
167-- Dumping structure for table essentialmode.fine_types_mafia
168CREATE TABLE IF NOT EXISTS `fine_types_mafia` (
169  `id` int(11) NOT NULL AUTO_INCREMENT,
170  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
171  `amount` int(11) DEFAULT NULL,
172  `category` int(11) DEFAULT NULL,
173  PRIMARY KEY (`id`)
174) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
175
176-- Dumping structure for table essentialmode.fine_types_rebel
177CREATE TABLE IF NOT EXISTS `fine_types_rebel` (
178  `id` int(11) NOT NULL AUTO_INCREMENT,
179  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
180  `amount` int(11) DEFAULT NULL,
181  `category` int(11) DEFAULT NULL,
182  PRIMARY KEY (`id`)
183) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
184
185-- Dumping structure for table essentialmode.fine_types_rodriguez
186CREATE TABLE IF NOT EXISTS `fine_types_rodriguez` (
187  `id` int(11) NOT NULL AUTO_INCREMENT,
188  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
189  `amount` int(11) DEFAULT NULL,
190  `category` int(11) DEFAULT NULL,
191  PRIMARY KEY (`id`)
192) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
193
194-- Dumping structure for table essentialmode.items
195CREATE TABLE IF NOT EXISTS `items` (
196  `id` int(11) NOT NULL AUTO_INCREMENT,
197  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
198  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
199  `limit` int(11) NOT NULL DEFAULT '-1',
200  `rare` int(11) NOT NULL DEFAULT '0',
201  `can_remove` int(11) NOT NULL DEFAULT '1',
202  PRIMARY KEY (`id`)
203) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
204
205-- Dumping structure for table essentialmode.jobs
206CREATE TABLE IF NOT EXISTS `jobs` (
207  `id` int(11) NOT NULL AUTO_INCREMENT,
208  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
209  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
210  `whitelisted` tinyint(1) NOT NULL DEFAULT '0',
211  PRIMARY KEY (`id`)
212) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
213
214-- Dumping structure for table essentialmode.job_grades
215CREATE TABLE IF NOT EXISTS `job_grades` (
216  `id` int(11) NOT NULL AUTO_INCREMENT,
217  `job_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
218  `grade` int(11) NOT NULL,
219  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
220  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
221  `salary` int(11) NOT NULL,
222  `skin_male` longtext COLLATE utf8mb4_bin NOT NULL,
223  `skin_female` longtext COLLATE utf8mb4_bin NOT NULL,
224  PRIMARY KEY (`id`)
225) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
226
227-- Dumping structure for table essentialmode.licenses
228CREATE TABLE IF NOT EXISTS `licenses` (
229  `id` int(11) NOT NULL AUTO_INCREMENT,
230  `type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
231  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
232  PRIMARY KEY (`id`)
233) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
234
235-- Dumping structure for table essentialmode.owned_dock
236CREATE TABLE IF NOT EXISTS `owned_dock` (
237  `id` int(11) NOT NULL AUTO_INCREMENT,
238  `vehicle` longtext COLLATE utf8mb4_bin NOT NULL,
239  `owner` varchar(60) COLLATE utf8mb4_bin NOT NULL,
240  PRIMARY KEY (`id`)
241) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
242
243-- Dumping structure for table essentialmode.owned_properties
244CREATE TABLE IF NOT EXISTS `owned_properties` (
245  `id` int(11) NOT NULL AUTO_INCREMENT,
246  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
247  `price` double NOT NULL,
248  `rented` int(11) NOT NULL,
249  `owner` varchar(60) COLLATE utf8mb4_bin NOT NULL,
250  PRIMARY KEY (`id`)
251) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
252
253-- Dumping structure for table essentialmode.owned_vehicles
254CREATE TABLE IF NOT EXISTS `owned_vehicles` (
255  `id` int(11) NOT NULL AUTO_INCREMENT,
256  `vehicle` longtext COLLATE utf8mb4_bin NOT NULL,
257  `owner` varchar(60) COLLATE utf8mb4_bin NOT NULL,
258  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Etat de la voiture',
259  PRIMARY KEY (`id`)
260) ENGINE=InnoDB AUTO_INCREMENT=944 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
261
262-- Dumping structure for table essentialmode.owner_vehicles
263CREATE TABLE IF NOT EXISTS `owner_vehicles` (
264  `id` int(11) NOT NULL AUTO_INCREMENT,
265  `vehicle` varchar(255) COLLATE utf8mb4_bin NOT NULL,
266  `price` int(11) NOT NULL,
267  PRIMARY KEY (`id`)
268) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
269
270-- Dumping structure for table essentialmode.playerstattoos
271CREATE TABLE IF NOT EXISTS `playerstattoos` (
272  `id` int(11) NOT NULL AUTO_INCREMENT,
273  `identifier` varchar(255) NOT NULL,
274  `tattoos` varchar(255) NOT NULL,
275  PRIMARY KEY (`id`)
276) ENGINE=InnoDB AUTO_INCREMENT=3308 DEFAULT CHARSET=utf8mb4;
277
278-- Dumping structure for table essentialmode.properties
279CREATE TABLE IF NOT EXISTS `properties` (
280  `id` int(11) NOT NULL AUTO_INCREMENT,
281  `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
282  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
283  `entering` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
284  `exit` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
285  `inside` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
286  `outside` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
287  `ipls` varchar(255) COLLATE utf8mb4_bin DEFAULT '[]',
288  `gateway` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
289  `is_single` int(11) DEFAULT NULL,
290  `is_room` int(11) DEFAULT NULL,
291  `is_gateway` int(11) DEFAULT NULL,
292  `room_menu` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
293  `price` int(11) NOT NULL,
294  PRIMARY KEY (`id`)
295) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
296
297-- Dumping structure for table essentialmode.rented_dock
298CREATE TABLE IF NOT EXISTS `rented_dock` (
299  `id` int(11) NOT NULL AUTO_INCREMENT,
300  `vehicle` varchar(60) COLLATE utf8mb4_bin NOT NULL,
301  `plate` varchar(10) COLLATE utf8mb4_bin NOT NULL,
302  `player_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
303  `base_price` int(11) NOT NULL,
304  `rent_price` int(11) NOT NULL,
305  `owner` varchar(255) COLLATE utf8mb4_bin NOT NULL,
306  PRIMARY KEY (`id`)
307) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
308
309-- Dumping structure for table essentialmode.rented_vehicles
310CREATE TABLE IF NOT EXISTS `rented_vehicles` (
311  `id` int(11) NOT NULL AUTO_INCREMENT,
312  `vehicle` varchar(60) COLLATE utf8mb4_bin NOT NULL,
313  `plate` varchar(10) COLLATE utf8mb4_bin NOT NULL,
314  `player_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
315  `base_price` int(11) NOT NULL,
316  `rent_price` int(11) NOT NULL,
317  `owner` varchar(255) COLLATE utf8mb4_bin NOT NULL,
318  PRIMARY KEY (`id`)
319) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
320
321-- Dumping structure for table essentialmode.shops
322CREATE TABLE IF NOT EXISTS `shops` (
323  `id` int(11) NOT NULL AUTO_INCREMENT,
324  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
325  `item` varchar(255) COLLATE utf8mb4_bin NOT NULL,
326  `price` int(11) NOT NULL,
327  PRIMARY KEY (`id`)
328) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
329
330-- Dumping structure for table essentialmode.society_moneywash
331CREATE TABLE IF NOT EXISTS `society_moneywash` (
332  `id` int(11) NOT NULL AUTO_INCREMENT,
333  `identifier` varchar(60) COLLATE utf8mb4_bin NOT NULL,
334  `society` varchar(60) COLLATE utf8mb4_bin NOT NULL,
335  `amount` int(11) NOT NULL,
336  PRIMARY KEY (`id`)
337) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
338
339-- Dumping structure for table essentialmode.truck_inventory
340CREATE TABLE IF NOT EXISTS `truck_inventory` (
341  `id` int(11) NOT NULL AUTO_INCREMENT,
342  `item` varchar(100) NOT NULL,
343  `count` int(11) NOT NULL,
344  `plate` varchar(8) NOT NULL,
345  `name` varchar(255) NOT NULL,
346  PRIMARY KEY (`id`),
347  UNIQUE KEY `item` (`item`,`plate`)
348) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
349
350-- Dumping structure for table essentialmode.users
351CREATE TABLE IF NOT EXISTS `users` (
352  `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
353  `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
354  `money` int(11) DEFAULT NULL,
355  `name` varchar(255) COLLATE utf8mb4_bin DEFAULT '',
356  `skin` longtext COLLATE utf8mb4_bin,
357  `job` varchar(255) COLLATE utf8mb4_bin DEFAULT 'unemployed',
358  `job_grade` int(11) DEFAULT '0',
359  `loadout` longtext COLLATE utf8mb4_bin,
360  `position` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
361  `bank` int(11) DEFAULT NULL,
362  `permission_level` int(11) DEFAULT NULL,
363  `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
364  `status` longtext COLLATE utf8mb4_bin,
365  `firstname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
366  `lastname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
367  `dateofbirth` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
368  `sex` varchar(10) COLLATE utf8mb4_bin DEFAULT '',
369  `height` varchar(5) COLLATE utf8mb4_bin DEFAULT '',
370  `phone_number` int(11) DEFAULT NULL,
371  `last_property` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
372  `animal` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL
373) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
374
375-- Dumping structure for table essentialmode.user_accounts
376CREATE TABLE IF NOT EXISTS `user_accounts` (
377  `id` int(11) NOT NULL AUTO_INCREMENT,
378  `identifier` varchar(255) COLLATE utf8mb4_bin NOT NULL,
379  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
380  `money` double NOT NULL DEFAULT '0',
381  PRIMARY KEY (`id`)
382) ENGINE=InnoDB AUTO_INCREMENT=3850 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
383
384-- Dumping structure for table essentialmode.user_contacts
385CREATE TABLE IF NOT EXISTS `user_contacts` (
386  `id` int(11) NOT NULL AUTO_INCREMENT,
387  `identifier` varchar(255) COLLATE utf8mb4_bin NOT NULL,
388  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
389  `number` int(11) NOT NULL,
390  PRIMARY KEY (`id`)
391) ENGINE=InnoDB AUTO_INCREMENT=410 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
392
393-- Dumping structure for table essentialmode.user_inventory
394CREATE TABLE IF NOT EXISTS `user_inventory` (
395  `id` int(11) NOT NULL AUTO_INCREMENT,
396  `identifier` varchar(255) COLLATE utf8mb4_bin NOT NULL,
397  `item` varchar(255) COLLATE utf8mb4_bin NOT NULL,
398  `count` int(11) NOT NULL,
399  PRIMARY KEY (`id`)
400) ENGINE=InnoDB AUTO_INCREMENT=79459 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
401
402-- Dumping structure for table essentialmode.user_licenses
403CREATE TABLE IF NOT EXISTS `user_licenses` (
404  `id` int(11) NOT NULL AUTO_INCREMENT,
405  `type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
406  `owner` varchar(255) COLLATE utf8mb4_bin NOT NULL,
407  PRIMARY KEY (`id`)
408) ENGINE=InnoDB AUTO_INCREMENT=2106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
409
410-- Dumping structure for table essentialmode.user_parkings
411CREATE TABLE IF NOT EXISTS `user_parkings` (
412  `id` int(11) NOT NULL AUTO_INCREMENT,
413  `identifier` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
414  `garage` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
415  `zone` int(11) NOT NULL,
416  `vehicle` longtext COLLATE utf8mb4_bin,
417  PRIMARY KEY (`id`)
418) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
419
420-- Dumping structure for table essentialmode.vehicles
421CREATE TABLE IF NOT EXISTS `vehicles` (
422  `id` int(11) NOT NULL AUTO_INCREMENT,
423  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
424  `model` varchar(60) COLLATE utf8mb4_bin NOT NULL,
425  `price` int(11) NOT NULL,
426  `category` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
427  PRIMARY KEY (`id`)
428) ENGINE=InnoDB AUTO_INCREMENT=366 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
429
430-- Dumping structure for table essentialmode.vehicle_categories
431CREATE TABLE IF NOT EXISTS `vehicle_categories` (
432  `id` int(11) NOT NULL AUTO_INCREMENT,
433  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
434  `label` varchar(60) COLLATE utf8mb4_bin NOT NULL,
435  PRIMARY KEY (`id`)
436) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
437
438-- Dumping structure for table essentialmode.warrants
439CREATE TABLE IF NOT EXISTS `warrants` (
440  `fullname` varchar(255) COLLATE utf8mb4_bin NOT NULL,
441  `crimes` varchar(255) COLLATE utf8mb4_bin NOT NULL
442) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
443
444-- Dumping structure for table essentialmode.weashops
445CREATE TABLE IF NOT EXISTS `weashops` (
446  `id` int(11) NOT NULL AUTO_INCREMENT,
447  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
448  `item` varchar(255) COLLATE utf8mb4_bin NOT NULL,
449  `price` int(11) NOT NULL,
450  PRIMARY KEY (`id`)
451) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
452
453-- Dumping structure for table essentialmode.zoneaccess
454CREATE TABLE IF NOT EXISTS `zoneaccess` (
455  `id` int(10) NOT NULL AUTO_INCREMENT,
456  `label` varchar(128) NOT NULL,
457  `identifier` varchar(255) NOT NULL,
458  PRIMARY KEY (`id`)
459) ENGINE=InnoDB DEFAULT CHARSET=latin1;
460
461-- Dumping structure for table essentialmode.zoneowners
462CREATE TABLE IF NOT EXISTS `zoneowners` (
463  `label` varchar(128) NOT NULL,
464  `identifier` varchar(255) NOT NULL,
465  `cooldown` int(10) NOT NULL,
466  PRIMARY KEY (`label`)
467) ENGINE=InnoDB DEFAULT CHARSET=latin1;