· 6 years ago · Sep 05, 2019, 12:08 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 8.0.13 - MySQL Community Server - GPL
4-- Server OS: Win64
5-- HeidiSQL Version: 9.5.0.5196
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-- Dumping structure for table test.mdt_active_users
14CREATE TABLE IF NOT EXISTS `mdt_active_users` (
15 `user_id` int(11) DEFAULT NULL,
16 `server` int(11) DEFAULT NULL,
17 `callID` int(11) DEFAULT '0',
18 `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
19 `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '10-42',
20 `department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
21 `divison` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
22 `logout` int(11) DEFAULT '0'
23) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
24/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
25-- Dumping data for table test.mdt_active_users: ~0 rows (approximately)
26/*!40000 ALTER TABLE `mdt_active_users` DISABLE KEYS */;
27/* SQL Error (1146): Table 'essentialmode.mdt_active_users' doesn't exist */
28/*!40000 ALTER TABLE `mdt_active_users` ENABLE KEYS */;
29/* SQL Error (1146): Table 'essentialmode.mdt_active_users' doesn't exist */
30-- Dumping structure for table test.mdt_aop_names
31CREATE TABLE IF NOT EXISTS `mdt_aop_names` (
32 `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
33) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
34/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
35-- Dumping data for table test.mdt_aop_names: ~4 rows (approximately)
36/*!40000 ALTER TABLE `mdt_aop_names` DISABLE KEYS */;
37/* SQL Error (1146): Table 'essentialmode.mdt_aop_names' doesn't exist */
38INSERT INTO `mdt_aop_names` (`name`) VALUES
39 ('Statewide'),
40 ('Blaine County'),
41 ('Los Santos'),
42 ('Sandy Shores & Surrounding Area');
43/* SQL Error (1146): Table 'essentialmode.mdt_aop_names' doesn't exist */
44/*!40000 ALTER TABLE `mdt_aop_names` ENABLE KEYS */;
45/* SQL Error (1146): Table 'essentialmode.mdt_aop_names' doesn't exist */
46-- Dumping structure for table test.mdt_arrests
47CREATE TABLE IF NOT EXISTS `mdt_arrests` (
48 `id` int(11) NOT NULL AUTO_INCREMENT,
49 `charaterId` int(11) DEFAULT NULL,
50 `first` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
51 `last` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
52 `plateId` int(11) DEFAULT NULL,
53 `plate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
54 `description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
55 `infraction` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
56 `location` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
57 `fine` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
58 `jail` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
59 `date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
60 `officer` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
61 UNIQUE KEY `id` (`id`)
62) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
63/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
64-- Dumping data for table test.mdt_arrests: ~0 rows (approximately)
65/*!40000 ALTER TABLE `mdt_arrests` DISABLE KEYS */;
66/* SQL Error (1146): Table 'essentialmode.mdt_arrests' doesn't exist */
67/*!40000 ALTER TABLE `mdt_arrests` ENABLE KEYS */;
68/* SQL Error (1146): Table 'essentialmode.mdt_arrests' doesn't exist */
69-- Dumping structure for table test.mdt_ban
70CREATE TABLE IF NOT EXISTS `mdt_ban` (
71 `steam` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
72 `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
73) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
74/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
75-- Dumping data for table test.mdt_ban: ~0 rows (approximately)
76/*!40000 ALTER TABLE `mdt_ban` DISABLE KEYS */;
77/* SQL Error (1146): Table 'essentialmode.mdt_ban' doesn't exist */
78/*!40000 ALTER TABLE `mdt_ban` ENABLE KEYS */;
79/* SQL Error (1146): Table 'essentialmode.mdt_ban' doesn't exist */
80-- Dumping structure for table test.mdt_calls
81CREATE TABLE IF NOT EXISTS `mdt_calls` (
82 `id` int(11) NOT NULL AUTO_INCREMENT,
83 `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
84 `location` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
85 `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
86 UNIQUE KEY `id` (`id`)
87) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
88/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
89-- Dumping data for table test.mdt_calls: ~0 rows (approximately)
90/*!40000 ALTER TABLE `mdt_calls` DISABLE KEYS */;
91/* SQL Error (1146): Table 'essentialmode.mdt_calls' doesn't exist */
92/*!40000 ALTER TABLE `mdt_calls` ENABLE KEYS */;
93/* SQL Error (1146): Table 'essentialmode.mdt_calls' doesn't exist */
94-- Dumping structure for table test.mdt_call_type
95CREATE TABLE IF NOT EXISTS `mdt_call_type` (
96 `id` int(11) NOT NULL AUTO_INCREMENT,
97 `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
98 UNIQUE KEY `id` (`id`)
99) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
100/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
101-- Dumping data for table test.mdt_call_type: ~34 rows (approximately)
102/*!40000 ALTER TABLE `mdt_call_type` DISABLE KEYS */;
103/* SQL Error (1146): Table 'essentialmode.mdt_call_type' doesn't exist */
104INSERT INTO `mdt_call_type` (`id`, `name`) VALUES
105 (1, 'Traffic Stop'),
106 (2, 'MVA'),
107 (3, 'MVA W/ Injury'),
108 (4, 'Abandon Vehicle'),
109 (5, 'Robbery'),
110 (6, 'Arson'),
111 (7, 'Assault'),
112 (8, 'Assist Person'),
113 (9, 'Attempt to Locate'),
114 (10, 'Burglary'),
115 (11, 'Dead Body'),
116 (12, 'Domestic Disturbance'),
117 (13, 'Disturbance'),
118 (14, 'Follow Up / Additional Information '),
119 (15, 'Hit and Run '),
120 (16, 'Hazard'),
121 (17, 'Kidnapping'),
122 (18, 'Littering / Dumping'),
123 (19, 'Missing Person'),
124 (20, 'Motorist Assist'),
125 (21, 'Noise Complaint'),
126 (22, 'Pursuit'),
127 (23, 'Search & Rescue\r'),
128 (24, 'Shots Fired/Heard'),
129 (25, 'Stolen Vehicle '),
130 (26, 'Subject Stop'),
131 (27, 'Suicide'),
132 (28, 'Sex Crime'),
133 (29, 'Suspicious Vehicle'),
134 (30, 'Suspicious Person'),
135 (31, 'Theft'),
136 (32, 'Trespassing'),
137 (33, 'Welfare Check'),
138 (34, 'Drugs');
139/* SQL Error (1146): Table 'essentialmode.mdt_call_type' doesn't exist */
140/*!40000 ALTER TABLE `mdt_call_type` ENABLE KEYS */;
141/* SQL Error (1146): Table 'essentialmode.mdt_call_type' doesn't exist */
142-- Dumping structure for table test.mdt_characters
143CREATE TABLE IF NOT EXISTS `mdt_characters` (
144 `id` int(11) NOT NULL AUTO_INCREMENT,
145 `ownerID` int(11) DEFAULT NULL,
146 `first` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
147 `last` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
148 `dob` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
149 `gender` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
150 `address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
151 `lic` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
152 `weapon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
153 KEY `id` (`id`)
154) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
155/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
156-- Dumping data for table test.mdt_characters: ~0 rows (approximately)
157/*!40000 ALTER TABLE `mdt_characters` DISABLE KEYS */;
158/* SQL Error (1146): Table 'essentialmode.mdt_characters' doesn't exist */
159/*!40000 ALTER TABLE `mdt_characters` ENABLE KEYS */;
160/* SQL Error (1146): Table 'essentialmode.mdt_characters' doesn't exist */
161-- Dumping structure for table test.mdt_departments
162CREATE TABLE IF NOT EXISTS `mdt_departments` (
163 `id` int(11) NOT NULL AUTO_INCREMENT,
164 `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
165 `abbreviation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
166 `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
167 UNIQUE KEY `id` (`id`)
168) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
169/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
170-- Dumping data for table test.mdt_departments: ~3 rows (approximately)
171/*!40000 ALTER TABLE `mdt_departments` DISABLE KEYS */;
172/* SQL Error (1146): Table 'essentialmode.mdt_departments' doesn't exist */
173INSERT INTO `mdt_departments` (`id`, `name`, `abbreviation`, `icon`) VALUES
174 (1, 'San Andreas Highway Patrol', 'SAHP', 'SAHP'),
175 (2, 'Blaine County Sheriffs Office', 'BCSO', 'BCSO'),
176 (3, 'Los Santos Police Department', 'LSPD', 'LSPD');
177/* SQL Error (1146): Table 'essentialmode.mdt_departments' doesn't exist */
178/*!40000 ALTER TABLE `mdt_departments` ENABLE KEYS */;
179/* SQL Error (1146): Table 'essentialmode.mdt_departments' doesn't exist */
180-- Dumping structure for table test.mdt_divisions
181CREATE TABLE IF NOT EXISTS `mdt_divisions` (
182 `id` int(11) NOT NULL AUTO_INCREMENT,
183 `departmentID` int(11) NOT NULL,
184 `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
185 `abbreviation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
186 `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
187 UNIQUE KEY `id` (`id`)
188) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
189/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
190-- Dumping data for table test.mdt_divisions: ~25 rows (approximately)
191/*!40000 ALTER TABLE `mdt_divisions` DISABLE KEYS */;
192/* SQL Error (1146): Table 'essentialmode.mdt_divisions' doesn't exist */
193INSERT INTO `mdt_divisions` (`id`, `departmentID`, `name`, `abbreviation`, `icon`) VALUES
194 (1, 3, 'Patrol', 'Patrol', 'LSPD'),
195 (2, 3, 'K9', 'K9', 'K9'),
196 (3, 3, 'Port Authority', 'PA', 'PA'),
197 (4, 3, 'Traffic', 'TRAFFIC', 'traffic'),
198 (5, 2, 'Patrol', ' ', 'BCSO'),
199 (6, 2, 'Traffic', 'TRAFFIC', 'traffic'),
200 (7, 2, 'K9', 'K9', 'K9'),
201 (8, 3, 'Detective', 'DETECTIVE', 'detective'),
202 (9, 2, 'Detective', 'DETECTIVE', 'detective'),
203 (10, 3, 'Vinewood', 'VINEWOOD', 'Vinewood'),
204 (11, 2, 'Sandy Shores', 'SANDY', 'sandy'),
205 (12, 3, 'Narcotics', 'DRUG', 'narcotics'),
206 (13, 2, 'Narcotics', 'DRUG', 'narcotics'),
207 (14, 1, 'Patrol', 'Patrol', 'SAHP'),
208 (15, 1, 'K9', 'K9', 'K9'),
209 (16, 3, 'Air', 'AIR', 'heli'),
210 (17, 1, 'Air', 'AIR', 'heli'),
211 (18, 2, 'Air', 'AIR', 'heli'),
212 (19, 1, 'Motor', 'MOTOR', 'motor'),
213 (20, 2, 'Motor', 'MOTOR', 'motor'),
214 (21, 3, 'Motor', 'MOTOR', 'motor'),
215 (22, 1, 'SWAT', 'SWAT', 'SWAT'),
216 (23, 2, 'SWAT', 'SWAT', 'SWAT'),
217 (24, 3, 'SWAT', 'SWAT', 'SWAT'),
218 (25, 1, 'CVE', 'CVE', 'cve');
219/* SQL Error (1146): Table 'essentialmode.mdt_divisions' doesn't exist */
220/*!40000 ALTER TABLE `mdt_divisions` ENABLE KEYS */;
221/* SQL Error (1146): Table 'essentialmode.mdt_divisions' doesn't exist */
222-- Dumping structure for table test.mdt_penal_category
223CREATE TABLE IF NOT EXISTS `mdt_penal_category` (
224 `id` int(11) DEFAULT NULL,
225 `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
226) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
227/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
228-- Dumping data for table test.mdt_penal_category: ~4 rows (approximately)
229/*!40000 ALTER TABLE `mdt_penal_category` DISABLE KEYS */;
230/* SQL Error (1146): Table 'essentialmode.mdt_penal_category' doesn't exist */
231INSERT INTO `mdt_penal_category` (`id`, `name`) VALUES
232 (1, 'Property'),
233 (2, 'Possession'),
234 (3, 'Violent Crimes'),
235 (4, 'Traffic');
236/* SQL Error (1146): Table 'essentialmode.mdt_penal_category' doesn't exist */
237/*!40000 ALTER TABLE `mdt_penal_category` ENABLE KEYS */;
238/* SQL Error (1146): Table 'essentialmode.mdt_penal_category' doesn't exist */
239-- Dumping structure for table test.mdt_penal_charges
240CREATE TABLE IF NOT EXISTS `mdt_penal_charges` (
241 `id` int(11) NOT NULL AUTO_INCREMENT,
242 `cat` int(11) DEFAULT NULL,
243 `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
244 `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
245 `punishment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
246 `fine` int(11) DEFAULT NULL,
247 `jail` int(11) DEFAULT NULL,
248 UNIQUE KEY `id` (`id`)
249) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
250/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
251-- Dumping data for table test.mdt_penal_charges: ~31 rows (approximately)
252/*!40000 ALTER TABLE `mdt_penal_charges` DISABLE KEYS */;
253/* SQL Error (1146): Table 'essentialmode.mdt_penal_charges' doesn't exist */
254INSERT INTO `mdt_penal_charges` (`id`, `cat`, `name`, `type`, `punishment`, `fine`, `jail`) VALUES
255 (1, 1, 'Destruction', 'Misdemeanor', '10 Seconds In Jail', 0, 10),
256 (2, 1, 'Theft', 'Misdemeanor', '25 Seconds In Jail AND $1,000 Fine', 1000, 25),
257 (3, 1, 'Trespassing', 'Misdemeanor', '$1,000 Fine OR 10 Seconds In Jail', 1000, 10),
258 (4, 1, 'Burglary', 'Felony', '60 Seconds In Jail ', 0, 60),
259 (5, 1, 'Grand Theft', 'Felony', '60 Seconds In Jail AND $1,000 Fine', 1000, 60),
260 (6, 2, 'Possession of Drugs With Intent to Dristribute', 'Felony', '60 Seconds In Jail ', 0, 60),
261 (7, 2, 'Drug Paraphernalia', 'Misdemeanor', '30 Seconds In Jail AND $500 Fine', 500, 30),
262 (8, 2, 'Simple Possession', 'Misdemeanor', '30 Seconds In Jail AND/OR $1,000 Fine', 1000, 30),
263 (10, 2, 'Stolen Weapon', 'Felony', '60 Seconds In Jail ', 0, 60),
264 (11, 2, 'Illegal Possession of a Firearm', 'Felony', '60 Seconds In Jail ', 0, 60),
265 (12, 2, 'Stolen Property', 'Felony', '60 Seconds In Jail ', 0, 60),
266 (13, 2, 'Stolen ID', 'Felony', '60 Seconds In Jail ', 0, 60),
267 (14, 2, 'Stolen Vehicle', 'Felony', '60 Seconds In Jail ', 0, 60),
268 (15, 3, 'Assault', 'Misdemeanor', '30 Seconds In Jail AND/OR $1,000 Fine', 1000, 30),
269 (16, 3, 'Assault W/ A Deadly Weapon', 'Felony', '60 Seconds In Jail ', 0, 60),
270 (17, 3, 'Battery', 'Misdemeanor', '30 Seconds In Jail AND/OR $1,000 Fine', 1000, 30),
271 (18, 3, 'Grand Theft Auto', 'Felony', '60 Seconds In Jail AND Up To $5,000 Fine', 5000, 60),
272 (19, 3, 'Murder', 'Felony', '60+ Seconds In Jail', 0, 60),
273 (20, 3, 'Manslaughter', 'Felony', '60+ Seconds In Jail ', 0, 60),
274 (21, 4, 'Speeding 10-15', 'Traffic', '$234 Fine', 234, 0),
275 (23, 4, 'Speeding 16-25', 'Traffic', '$360 Fine', 360, 0),
276 (24, 4, 'Speeding 26+', 'Traffic', '$480 Fine', 480, 0),
277 (25, 4, 'Speeding 100+', 'Traffic', '$1000 Fine', 1000, 0),
278 (26, 4, 'DUI', 'Felony', '10+ Seconds In Jail AND/OR $400+ Fine', 400, 10),
279 (27, 4, 'Reckless Driving', 'Misdemeanor', '20+ Seconds In Jail AND/* large SQL query (2.4 KiB), snipped at 2,000 characters */
280/* SQL Error (1146): Table 'essentialmode.mdt_penal_charges' doesn't exist */
281/*!40000 ALTER TABLE `mdt_penal_charges` ENABLE KEYS */;
282/* SQL Error (1146): Table 'essentialmode.mdt_penal_charges' doesn't exist */
283-- Dumping structure for table test.mdt_players
284CREATE TABLE IF NOT EXISTS `mdt_players` (
285 `id` int(11) DEFAULT NULL,
286 `steam` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
287 `name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
288 `code` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
289 KEY `steam` (`steam`)
290) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
291/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
292-- Dumping data for table test.mdt_players: ~0 rows (approximately)
293/*!40000 ALTER TABLE `mdt_players` DISABLE KEYS */;
294/* SQL Error (1146): Table 'essentialmode.mdt_players' doesn't exist */
295/*!40000 ALTER TABLE `mdt_players` ENABLE KEYS */;
296/* SQL Error (1146): Table 'essentialmode.mdt_players' doesn't exist */
297-- Dumping structure for table test.mdt_server
298CREATE TABLE IF NOT EXISTS `mdt_server` (
299 `id` int(11) NOT NULL AUTO_INCREMENT,
300 `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
301 `aop` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
302 `emergency` int(11) DEFAULT '0',
303 `ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
304 `port` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
305 UNIQUE KEY `id` (`id`)
306) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
307/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
308-- Dumping data for table test.mdt_server: ~1 rows (approximately)
309/*!40000 ALTER TABLE `mdt_server` DISABLE KEYS */;
310/* SQL Error (1146): Table 'essentialmode.mdt_server' doesn't exist */
311INSERT INTO `mdt_server` (`id`, `status`, `aop`, `emergency`, `ip`, `port`) VALUES
312 (1, 'offline', 'Sandy Shores & Surrounding Area', 0, 'localhost', '30120');
313/* SQL Error (1146): Table 'essentialmode.mdt_server' doesn't exist */
314/*!40000 ALTER TABLE `mdt_server` ENABLE KEYS */;
315/* SQL Error (1146): Table 'essentialmode.mdt_server' doesn't exist */
316-- Dumping structure for table test.mdt_tickets
317CREATE TABLE IF NOT EXISTS `mdt_tickets` (
318 `id` int(11) NOT NULL AUTO_INCREMENT,
319 `charaterId` int(11) DEFAULT NULL,
320 `first` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
321 `last` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
322 `plateId` int(11) DEFAULT NULL,
323 `plate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
324 `description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
325 `infraction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
326 `location` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
327 `fine` int(11) DEFAULT NULL,
328 `date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
329 `officer` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
330 UNIQUE KEY `id` (`id`)
331) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
332/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
333-- Dumping data for table test.mdt_tickets: ~0 rows (approximately)
334/*!40000 ALTER TABLE `mdt_tickets` DISABLE KEYS */;
335/* SQL Error (1146): Table 'essentialmode.mdt_tickets' doesn't exist */
336/*!40000 ALTER TABLE `mdt_tickets` ENABLE KEYS */;
337/* SQL Error (1146): Table 'essentialmode.mdt_tickets' doesn't exist */
338-- Dumping structure for table test.mdt_users
339CREATE TABLE IF NOT EXISTS `mdt_users` (
340 `user_id` int(11) NOT NULL AUTO_INCREMENT,
341 `email` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
342 `password` text CHARACTER SET latin1,
343 `name` text CHARACTER SET latin1,
344 `admin` int(11) DEFAULT NULL,
345 `steam` varchar(500) CHARACTER SET latin1 DEFAULT '0',
346 `code` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
347 `suspend` int(11) DEFAULT '0',
348 PRIMARY KEY (`user_id`)
349) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
350-- Dumping data for table test.mdt_users: ~1 rows (approximately)
351/*!40000 ALTER TABLE `mdt_users` DISABLE KEYS */;
352/*!40000 ALTER TABLE `mdt_users` ENABLE KEYS */;
353-- Dumping structure for table test.mdt_vehicles
354CREATE TABLE IF NOT EXISTS `mdt_vehicles` (
355 `id` int(11) NOT NULL AUTO_INCREMENT,
356 `ownerID` int(11) DEFAULT '0',
357 `characterID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
358 `model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
359 `plate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
360 `description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
361 `reg` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
362 `insurance` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
363 `flags` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
364 UNIQUE KEY `id` (`id`)
365) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
366/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
367-- Dumping data for table test.mdt_vehicles: ~0 rows (approximately)
368/*!40000 ALTER TABLE `mdt_vehicles` DISABLE KEYS */;
369/* SQL Error (1146): Table 'essentialmode.mdt_vehicles' doesn't exist */
370/*!40000 ALTER TABLE `mdt_vehicles` ENABLE KEYS */;
371/* SQL Error (1146): Table 'essentialmode.mdt_vehicles' doesn't exist */
372-- Dumping structure for table test.mdt_warnings
373CREATE TABLE IF NOT EXISTS `mdt_warnings` (
374 `id` int(11) NOT NULL AUTO_INCREMENT,
375 `charaterId` int(11) DEFAULT NULL,
376 `first` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
377 `last` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
378 `plateId` int(11) DEFAULT NULL,
379 `plate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
380 `description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
381 `infraction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
382 `location` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
383 `date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
384 `officer` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
385 UNIQUE KEY `id` (`id`)
386) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
387/* SQL Error (1273): Unknown collation: 'utf8mb4_0900_ai_ci' */
388-- Dumping data for table test.mdt_warnings: ~0 rows (approximately)
389/*!40000 ALTER TABLE `mdt_warnings` DISABLE KEYS */;
390/* SQL Error (1146): Table 'essentialmode.mdt_warnings' doesn't exist */
391/*!40000 ALTER TABLE `mdt_warnings` ENABLE KEYS */;
392/* SQL Error (1146): Table 'essentialmode.mdt_warnings' doesn't exist */
393/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
394/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
395/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
396/* Affected rows: 0 Found rows: 0 Warnings: 2 Duration for 66 queries: 0.031 sec. */
397SHOW WARNINGS LIMIT 5;