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