· 8 years ago · Jun 03, 2018, 05:44 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.1.32-MariaDB - mariadb.org binary distribution
4-- Server OS: Win32
5-- HeidiSQL Version: 9.5.0.5278
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for essentialmode
16DROP DATABASE IF EXISTS `essentialmode`;
17CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET latin1 */;
18USE `essentialmode`;
19
20-- Dumping structure for table essentialmode.addon_account
21DROP TABLE IF EXISTS `addon_account`;
22CREATE TABLE IF NOT EXISTS `addon_account` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `name` varchar(255) NOT NULL,
25 `label` varchar(255) NOT NULL,
26 `shared` int(11) NOT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
29
30-- Data exporting was unselected.
31-- Dumping structure for table essentialmode.addon_account_data
32DROP TABLE IF EXISTS `addon_account_data`;
33CREATE TABLE IF NOT EXISTS `addon_account_data` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `account_name` varchar(255) DEFAULT NULL,
36 `money` double NOT NULL,
37 `owner` varchar(255) DEFAULT NULL,
38 PRIMARY KEY (`id`)
39) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
40
41-- Data exporting was unselected.
42-- Dumping structure for table essentialmode.addon_inventory
43DROP TABLE IF EXISTS `addon_inventory`;
44CREATE TABLE IF NOT EXISTS `addon_inventory` (
45 `id` int(11) NOT NULL AUTO_INCREMENT,
46 `name` varchar(255) NOT NULL,
47 `label` varchar(255) NOT NULL,
48 `shared` int(11) NOT NULL,
49 PRIMARY KEY (`id`)
50) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
51
52-- Data exporting was unselected.
53-- Dumping structure for table essentialmode.addon_inventory_items
54DROP TABLE IF EXISTS `addon_inventory_items`;
55CREATE TABLE IF NOT EXISTS `addon_inventory_items` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `inventory_name` varchar(255) NOT NULL,
58 `name` varchar(255) NOT NULL,
59 `count` int(11) NOT NULL,
60 `owner` varchar(60) DEFAULT NULL,
61 PRIMARY KEY (`id`)
62) ENGINE=InnoDB DEFAULT CHARSET=latin1;
63
64-- Data exporting was unselected.
65-- Dumping structure for table essentialmode.billing
66DROP TABLE IF EXISTS `billing`;
67CREATE TABLE IF NOT EXISTS `billing` (
68 `id` int(11) NOT NULL AUTO_INCREMENT,
69 `identifier` varchar(255) NOT NULL,
70 `sender` varchar(255) NOT NULL,
71 `target_type` varchar(50) NOT NULL,
72 `target` varchar(255) NOT NULL,
73 `label` varchar(255) NOT NULL,
74 `amount` int(11) NOT NULL,
75 PRIMARY KEY (`id`)
76) ENGINE=InnoDB DEFAULT CHARSET=latin1;
77
78-- Data exporting was unselected.
79-- Dumping structure for table essentialmode.cardealer_vehicles
80DROP TABLE IF EXISTS `cardealer_vehicles`;
81CREATE TABLE IF NOT EXISTS `cardealer_vehicles` (
82 `id` int(11) NOT NULL AUTO_INCREMENT,
83 `vehicle` varchar(255) NOT NULL,
84 `price` int(11) NOT NULL,
85 PRIMARY KEY (`id`)
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87
88-- Data exporting was unselected.
89-- Dumping structure for table essentialmode.characters
90DROP TABLE IF EXISTS `characters`;
91CREATE TABLE IF NOT EXISTS `characters` (
92 `id` int(11) NOT NULL AUTO_INCREMENT,
93 `identifier` varchar(255) NOT NULL,
94 `firstname` varchar(255) NOT NULL,
95 `lastname` varchar(255) NOT NULL,
96 `dateofbirth` varchar(255) NOT NULL,
97 `sex` varchar(1) NOT NULL DEFAULT 'f',
98 `height` varchar(128) NOT NULL,
99 PRIMARY KEY (`id`)
100) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
101
102-- Data exporting was unselected.
103-- Dumping structure for table essentialmode.datastore
104DROP TABLE IF EXISTS `datastore`;
105CREATE TABLE IF NOT EXISTS `datastore` (
106 `id` int(11) NOT NULL AUTO_INCREMENT,
107 `name` varchar(255) NOT NULL,
108 `label` varchar(255) NOT NULL,
109 `shared` int(11) NOT NULL,
110 PRIMARY KEY (`id`)
111) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
112
113-- Data exporting was unselected.
114-- Dumping structure for table essentialmode.datastore_data
115DROP TABLE IF EXISTS `datastore_data`;
116CREATE TABLE IF NOT EXISTS `datastore_data` (
117 `id` int(11) NOT NULL AUTO_INCREMENT,
118 `name` varchar(255) NOT NULL,
119 `owner` varchar(255) DEFAULT NULL,
120 `data` longtext,
121 PRIMARY KEY (`id`)
122) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
123
124-- Data exporting was unselected.
125-- Dumping structure for table essentialmode.fine_types
126DROP TABLE IF EXISTS `fine_types`;
127CREATE TABLE IF NOT EXISTS `fine_types` (
128 `id` int(11) NOT NULL AUTO_INCREMENT,
129 `label` varchar(255) DEFAULT NULL,
130 `amount` int(11) DEFAULT NULL,
131 `category` int(11) DEFAULT NULL,
132 PRIMARY KEY (`id`)
133) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
134
135-- Data exporting was unselected.
136-- Dumping structure for table essentialmode.items
137DROP TABLE IF EXISTS `items`;
138CREATE TABLE IF NOT EXISTS `items` (
139 `name` varchar(50) NOT NULL,
140 `label` varchar(255) NOT NULL,
141 `limit` int(11) NOT NULL DEFAULT '-1',
142 `rare` int(11) NOT NULL DEFAULT '0',
143 `can_remove` int(11) NOT NULL DEFAULT '1',
144 PRIMARY KEY (`name`)
145) ENGINE=InnoDB DEFAULT CHARSET=latin1;
146
147-- Data exporting was unselected.
148-- Dumping structure for table essentialmode.jobs
149DROP TABLE IF EXISTS `jobs`;
150CREATE TABLE IF NOT EXISTS `jobs` (
151 `name` varchar(50) NOT NULL,
152 `label` varchar(255) DEFAULT NULL,
153 PRIMARY KEY (`name`)
154) ENGINE=InnoDB DEFAULT CHARSET=latin1;
155
156-- Data exporting was unselected.
157-- Dumping structure for table essentialmode.job_grades
158DROP TABLE IF EXISTS `job_grades`;
159CREATE TABLE IF NOT EXISTS `job_grades` (
160 `id` int(11) NOT NULL AUTO_INCREMENT,
161 `job_name` varchar(255) DEFAULT NULL,
162 `grade` int(11) NOT NULL,
163 `name` varchar(255) NOT NULL,
164 `label` varchar(255) NOT NULL,
165 `salary` int(11) NOT NULL,
166 `skin_male` longtext NOT NULL,
167 `skin_female` longtext NOT NULL,
168 PRIMARY KEY (`id`)
169) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
170
171-- Data exporting was unselected.
172-- Dumping structure for table essentialmode.licenses
173DROP TABLE IF EXISTS `licenses`;
174CREATE TABLE IF NOT EXISTS `licenses` (
175 `type` varchar(60) NOT NULL,
176 `label` varchar(60) NOT NULL,
177 PRIMARY KEY (`type`)
178) ENGINE=InnoDB DEFAULT CHARSET=latin1;
179
180-- Data exporting was unselected.
181-- Dumping structure for table essentialmode.owned_properties
182DROP TABLE IF EXISTS `owned_properties`;
183CREATE TABLE IF NOT EXISTS `owned_properties` (
184 `id` int(11) NOT NULL AUTO_INCREMENT,
185 `name` varchar(255) NOT NULL,
186 `price` double NOT NULL,
187 `rented` int(11) NOT NULL,
188 `owner` varchar(60) NOT NULL,
189 PRIMARY KEY (`id`)
190) ENGINE=InnoDB DEFAULT CHARSET=latin1;
191
192-- Data exporting was unselected.
193-- Dumping structure for table essentialmode.owned_vehicles
194DROP TABLE IF EXISTS `owned_vehicles`;
195CREATE TABLE IF NOT EXISTS `owned_vehicles` (
196 `id` int(11) NOT NULL AUTO_INCREMENT,
197 `vehicle` longtext NOT NULL,
198 `owner` varchar(60) NOT NULL,
199 PRIMARY KEY (`id`)
200) ENGINE=InnoDB DEFAULT CHARSET=latin1;
201
202-- Data exporting was unselected.
203-- Dumping structure for table essentialmode.properties
204DROP TABLE IF EXISTS `properties`;
205CREATE TABLE IF NOT EXISTS `properties` (
206 `id` int(11) NOT NULL AUTO_INCREMENT,
207 `name` varchar(255) DEFAULT NULL,
208 `label` varchar(255) DEFAULT NULL,
209 `entering` varchar(255) DEFAULT NULL,
210 `exit` varchar(255) DEFAULT NULL,
211 `inside` varchar(255) DEFAULT NULL,
212 `outside` varchar(255) DEFAULT NULL,
213 `ipls` varchar(255) DEFAULT '[]',
214 `gateway` varchar(255) DEFAULT NULL,
215 `is_single` int(11) DEFAULT NULL,
216 `is_room` int(11) DEFAULT NULL,
217 `is_gateway` int(11) DEFAULT NULL,
218 `room_menu` varchar(255) DEFAULT NULL,
219 `price` int(11) NOT NULL,
220 PRIMARY KEY (`id`)
221) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;
222
223-- Data exporting was unselected.
224-- Dumping structure for table essentialmode.rented_vehicles
225DROP TABLE IF EXISTS `rented_vehicles`;
226CREATE TABLE IF NOT EXISTS `rented_vehicles` (
227 `id` int(11) NOT NULL AUTO_INCREMENT,
228 `vehicle` varchar(60) NOT NULL,
229 `plate` varchar(10) NOT NULL,
230 `player_name` varchar(255) NOT NULL,
231 `base_price` int(11) NOT NULL,
232 `rent_price` int(11) NOT NULL,
233 `owner` varchar(255) NOT NULL,
234 PRIMARY KEY (`id`)
235) ENGINE=InnoDB DEFAULT CHARSET=latin1;
236
237-- Data exporting was unselected.
238-- Dumping structure for table essentialmode.shops
239DROP TABLE IF EXISTS `shops`;
240CREATE TABLE IF NOT EXISTS `shops` (
241 `id` int(11) NOT NULL AUTO_INCREMENT,
242 `name` varchar(255) NOT NULL,
243 `item` varchar(255) NOT NULL,
244 `price` int(11) NOT NULL,
245 PRIMARY KEY (`id`)
246) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
247
248-- Data exporting was unselected.
249-- Dumping structure for table essentialmode.society_moneywash
250DROP TABLE IF EXISTS `society_moneywash`;
251CREATE TABLE IF NOT EXISTS `society_moneywash` (
252 `id` int(11) NOT NULL AUTO_INCREMENT,
253 `identifier` varchar(60) NOT NULL,
254 `society` varchar(60) NOT NULL,
255 `amount` int(11) NOT NULL,
256 PRIMARY KEY (`id`)
257) ENGINE=InnoDB DEFAULT CHARSET=latin1;
258
259-- Data exporting was unselected.
260-- Dumping structure for table essentialmode.users
261DROP TABLE IF EXISTS `users`;
262CREATE TABLE IF NOT EXISTS `users` (
263 `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
264 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
265 `money` int(11) DEFAULT NULL,
266 `name` varchar(255) COLLATE utf8mb4_bin DEFAULT '',
267 `skin` longtext COLLATE utf8mb4_bin,
268 `job` varchar(255) COLLATE utf8mb4_bin DEFAULT 'unemployed',
269 `job_grade` int(11) DEFAULT '0',
270 `loadout` longtext COLLATE utf8mb4_bin,
271 `position` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
272 `bank` int(11) DEFAULT NULL,
273 `permission_level` int(11) DEFAULT NULL,
274 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
275 `firstname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
276 `lastname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
277 `dateofbirth` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
278 `sex` varchar(10) COLLATE utf8mb4_bin DEFAULT '',
279 `height` varchar(5) COLLATE utf8mb4_bin DEFAULT '',
280 `last_property` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL
281) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
282
283-- Data exporting was unselected.
284-- Dumping structure for table essentialmode.user_accounts
285DROP TABLE IF EXISTS `user_accounts`;
286CREATE TABLE IF NOT EXISTS `user_accounts` (
287 `id` int(11) NOT NULL AUTO_INCREMENT,
288 `identifier` varchar(255) NOT NULL,
289 `name` varchar(255) NOT NULL,
290 `money` double NOT NULL DEFAULT '0',
291 PRIMARY KEY (`id`)
292) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
293
294-- Data exporting was unselected.
295-- Dumping structure for table essentialmode.user_inventory
296DROP TABLE IF EXISTS `user_inventory`;
297CREATE TABLE IF NOT EXISTS `user_inventory` (
298 `id` int(11) NOT NULL AUTO_INCREMENT,
299 `identifier` varchar(255) NOT NULL,
300 `item` varchar(255) NOT NULL,
301 `count` int(11) NOT NULL,
302 PRIMARY KEY (`id`)
303) ENGINE=InnoDB DEFAULT CHARSET=latin1;
304
305-- Data exporting was unselected.
306-- Dumping structure for table essentialmode.user_licenses
307DROP TABLE IF EXISTS `user_licenses`;
308CREATE TABLE IF NOT EXISTS `user_licenses` (
309 `id` int(11) NOT NULL AUTO_INCREMENT,
310 `type` varchar(60) NOT NULL,
311 `owner` varchar(60) NOT NULL,
312 PRIMARY KEY (`id`)
313) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
314
315-- Data exporting was unselected.
316-- Dumping structure for table essentialmode.user_parkings
317DROP TABLE IF EXISTS `user_parkings`;
318CREATE TABLE IF NOT EXISTS `user_parkings` (
319 `id` int(11) NOT NULL AUTO_INCREMENT,
320 `identifier` varchar(60) DEFAULT NULL,
321 `garage` varchar(60) DEFAULT NULL,
322 `zone` int(11) NOT NULL,
323 `vehicle` longtext,
324 PRIMARY KEY (`id`)
325) ENGINE=InnoDB DEFAULT CHARSET=latin1;
326
327-- Data exporting was unselected.
328-- Dumping structure for table essentialmode.vehicles
329DROP TABLE IF EXISTS `vehicles`;
330CREATE TABLE IF NOT EXISTS `vehicles` (
331 `name` varchar(60) NOT NULL,
332 `model` varchar(60) NOT NULL,
333 `price` int(11) NOT NULL,
334 `category` varchar(60) DEFAULT NULL,
335 PRIMARY KEY (`model`)
336) ENGINE=InnoDB DEFAULT CHARSET=latin1;
337
338-- Data exporting was unselected.
339-- Dumping structure for table essentialmode.vehicle_categories
340DROP TABLE IF EXISTS `vehicle_categories`;
341CREATE TABLE IF NOT EXISTS `vehicle_categories` (
342 `id` int(11) NOT NULL AUTO_INCREMENT,
343 `name` varchar(60) NOT NULL,
344 `label` varchar(60) NOT NULL,
345 PRIMARY KEY (`id`)
346) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
347
348-- Data exporting was unselected.
349-- Dumping structure for table essentialmode.weashops
350DROP TABLE IF EXISTS `weashops`;
351CREATE TABLE IF NOT EXISTS `weashops` (
352 `id` int(11) NOT NULL AUTO_INCREMENT,
353 `name` varchar(255) NOT NULL,
354 `item` varchar(255) NOT NULL,
355 `price` int(11) NOT NULL,
356 PRIMARY KEY (`id`)
357) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
358
359-- Data exporting was unselected.
360/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
361/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
362/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;