· 7 years ago · Feb 16, 2019, 07:46 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 maldenlife1
16DROP DATABASE IF EXISTS `maldenlife1`;
17CREATE DATABASE IF NOT EXISTS `maldenlife1` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
18USE `maldenlife1`;
19
20-- Dumping structure for table maldenlife1.advanced_identity
21DROP TABLE IF EXISTS `advanced_identity`;
22CREATE TABLE IF NOT EXISTS `advanced_identity` (
23 `pid` varchar(64) NOT NULL,
24 `name_player` varchar(32) NOT NULL,
25 `nom` varchar(32) NOT NULL,
26 `prenom` varchar(32) NOT NULL,
27 `naissance` text NOT NULL,
28 `lieu_naissance` text NOT NULL,
29 `taille` int(10) NOT NULL,
30 `sexe` int(1) NOT NULL,
31 PRIMARY KEY (`pid`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
33
34-- Dumping data for table maldenlife1.advanced_identity: ~0 rows (approximately)
35DELETE FROM `advanced_identity`;
36/*!40000 ALTER TABLE `advanced_identity` DISABLE KEYS */;
37INSERT INTO `advanced_identity` (`pid`, `name_player`, `nom`, `prenom`, `naissance`, `lieu_naissance`, `taille`, `sexe`) VALUES
38 ('76561198094478387', 'Ghul', 'DASDASDAS', 'AAAAA', '"[4,4,1997]"', '"Altis"', 157, 2);
39
40/*!40000 ALTER TABLE `advanced_identity` ENABLE KEYS */;
41
42-- Dumping structure for table maldenlife1.ah
43DROP TABLE IF EXISTS `ah`;
44CREATE TABLE IF NOT EXISTS `ah` (
45 `id` int(11) NOT NULL AUTO_INCREMENT,
46 `type` int(5) NOT NULL DEFAULT '0',
47 `amount` int(5) NOT NULL DEFAULT '0',
48 `item` text NOT NULL,
49 `price` int(100) NOT NULL DEFAULT '0',
50 `seller` varchar(50) NOT NULL,
51 `sellername` varchar(32) NOT NULL,
52 `status` int(5) NOT NULL DEFAULT '0',
53 `time` int(11) NOT NULL DEFAULT '0',
54 PRIMARY KEY (`id`)
55) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
56
57-- Dumping data for table maldenlife1.ah: ~0 rows (approximately)
58DELETE FROM `ah`;
59/*!40000 ALTER TABLE `ah` DISABLE KEYS */;
60/*!40000 ALTER TABLE `ah` ENABLE KEYS */;
61
62-- Dumping structure for table maldenlife1.containers
63DROP TABLE IF EXISTS `containers`;
64CREATE TABLE IF NOT EXISTS `containers` (
65 `id` int(6) NOT NULL AUTO_INCREMENT,
66 `pid` varchar(17) NOT NULL,
67 `classname` varchar(32) NOT NULL,
68 `pos` varchar(64) DEFAULT NULL,
69 `inventory` text NOT NULL,
70 `gear` text NOT NULL,
71 `dir` varchar(128) DEFAULT NULL,
72 `active` tinyint(1) NOT NULL DEFAULT '0',
73 `owned` tinyint(1) DEFAULT '0',
74 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
75 PRIMARY KEY (`id`,`pid`)
76) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
77
78-- Dumping data for table maldenlife1.containers: ~0 rows (approximately)
79DELETE FROM `containers`;
80/*!40000 ALTER TABLE `containers` DISABLE KEYS */;
81/*!40000 ALTER TABLE `containers` ENABLE KEYS */;
82
83-- Dumping structure for procedure maldenlife1.deleteDeadVehicles
84DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
85DELIMITER //
86CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()
87BEGIN
88 DELETE FROM `vehicles` WHERE `alive` = 0;
89END//
90DELIMITER ;
91
92-- Dumping structure for procedure maldenlife1.deleteOldContainers
93DROP PROCEDURE IF EXISTS `deleteOldContainers`;
94DELIMITER //
95CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldContainers`()
96BEGIN
97 DELETE FROM `containers` WHERE `owned` = 0;
98END//
99DELIMITER ;
100
101-- Dumping structure for procedure maldenlife1.deleteOldGangs
102DROP PROCEDURE IF EXISTS `deleteOldGangs`;
103DELIMITER //
104CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()
105BEGIN
106 DELETE FROM `gangs` WHERE `active` = 0;
107END//
108DELIMITER ;
109
110-- Dumping structure for procedure maldenlife1.deleteOldHouses
111DROP PROCEDURE IF EXISTS `deleteOldHouses`;
112DELIMITER //
113CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()
114BEGIN
115 DELETE FROM `houses` WHERE `owned` = 0;
116END//
117DELIMITER ;
118
119-- Dumping structure for procedure maldenlife1.deleteOldWanted
120DROP PROCEDURE IF EXISTS `deleteOldWanted`;
121DELIMITER //
122CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldWanted`()
123BEGIN
124 DELETE FROM `wanted` WHERE `active` = 0;
125END//
126DELIMITER ;
127
128-- Dumping structure for table maldenlife1.entreprises
129DROP TABLE IF EXISTS `entreprises`;
130CREATE TABLE IF NOT EXISTS `entreprises` (
131 `id` int(6) NOT NULL AUTO_INCREMENT,
132 `name` varchar(32) NOT NULL,
133 `pdg_pid` varchar(17) NOT NULL DEFAULT '0',
134 `pdg_name` varchar(32) NOT NULL,
135 `members` text NOT NULL,
136 `prices` text NOT NULL,
137 `items_stock` text NOT NULL,
138 `max_stock` int(3) NOT NULL DEFAULT '0',
139 `items_stock_2` text NOT NULL,
140 `max_stock_2` int(3) NOT NULL DEFAULT '0',
141 `bankacc` int(100) NOT NULL DEFAULT '0',
142 `position` varchar(32) DEFAULT NULL,
143 `objects` text NOT NULL,
144 `type` varchar(32) NOT NULL,
145 `active` tinyint(1) NOT NULL DEFAULT '1',
146 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
147 PRIMARY KEY (`id`)
148) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
149
150-- Dumping data for table maldenlife1.entreprises: ~0 rows (approximately)
151DELETE FROM `entreprises`;
152/*!40000 ALTER TABLE `entreprises` DISABLE KEYS */;
153/*!40000 ALTER TABLE `entreprises` ENABLE KEYS */;
154
155-- Dumping structure for table maldenlife1.entreprises_logs
156DROP TABLE IF EXISTS `entreprises_logs`;
157CREATE TABLE IF NOT EXISTS `entreprises_logs` (
158 `id` int(6) NOT NULL AUTO_INCREMENT,
159 `entreprise_id` int(6) NOT NULL DEFAULT '0',
160 `name` varchar(32) NOT NULL,
161 `value` int(6) NOT NULL DEFAULT '0',
162 `type` int(1) NOT NULL DEFAULT '0',
163 `other` int(1) NOT NULL DEFAULT '0',
164 `insert_time` text NOT NULL,
165 PRIMARY KEY (`id`)
166) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
167
168-- Dumping data for table maldenlife1.entreprises_logs: ~0 rows (approximately)
169DELETE FROM `entreprises_logs`;
170/*!40000 ALTER TABLE `entreprises_logs` DISABLE KEYS */;
171/*!40000 ALTER TABLE `entreprises_logs` ENABLE KEYS */;
172
173-- Dumping structure for table maldenlife1.gangs
174DROP TABLE IF EXISTS `gangs`;
175CREATE TABLE IF NOT EXISTS `gangs` (
176 `id` int(6) NOT NULL AUTO_INCREMENT,
177 `owner` varchar(32) DEFAULT NULL,
178 `name` varchar(32) DEFAULT NULL,
179 `members` text,
180 `maxmembers` int(3) DEFAULT '8',
181 `bank` int(100) DEFAULT '0',
182 `active` tinyint(1) DEFAULT '1',
183 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
184 PRIMARY KEY (`id`),
185 UNIQUE KEY `name_UNIQUE` (`name`)
186) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
187
188-- Dumping data for table maldenlife1.gangs: ~0 rows (approximately)
189DELETE FROM `gangs`;
190/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
191/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
192
193-- Dumping structure for table maldenlife1.gouvernement
194DROP TABLE IF EXISTS `gouvernement`;
195CREATE TABLE IF NOT EXISTS `gouvernement` (
196 `id` int(6) NOT NULL DEFAULT '1',
197 `vote_proccessing` int(1) NOT NULL DEFAULT '0',
198 `candidats` text NOT NULL,
199 `voters` text NOT NULL,
200 `compte_gouv` int(100) NOT NULL DEFAULT '0',
201 `compte_cop` int(100) NOT NULL DEFAULT '0',
202 `compte_med` int(100) NOT NULL DEFAULT '0',
203 `gouverneur` text NOT NULL,
204 `ministres` text NOT NULL,
205 `security` text NOT NULL,
206 `taxes` text NOT NULL,
207 `laws` text NOT NULL,
208 PRIMARY KEY (`id`)
209) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
210
211-- Dumping data for table maldenlife1.gouvernement: ~1 rows (approximately)
212DELETE FROM `gouvernement`;
213/*!40000 ALTER TABLE `gouvernement` DISABLE KEYS */;
214INSERT INTO `gouvernement` (`id`, `vote_proccessing`, `candidats`, `voters`, `compte_gouv`, `compte_cop`, `compte_med`, `gouverneur`, `ministres`, `security`, `taxes`, `laws`) VALUES
215 (1, 0, '"[]"', '"[]"', 0, 0, 0, '"[]"', '"[]"', '"[]"', '"[0,0,0]"', '"[]"');
216/*!40000 ALTER TABLE `gouvernement` ENABLE KEYS */;
217
218-- Dumping structure for table maldenlife1.gouvernement_logs
219DROP TABLE IF EXISTS `gouvernement_logs`;
220CREATE TABLE IF NOT EXISTS `gouvernement_logs` (
221 `id` int(6) NOT NULL AUTO_INCREMENT,
222 `name` varchar(32) NOT NULL,
223 `value` int(6) NOT NULL DEFAULT '0',
224 `from_id` int(1) NOT NULL,
225 `to_id` int(1) NOT NULL,
226 `type` int(1) NOT NULL,
227 `insert_time` text NOT NULL,
228 PRIMARY KEY (`id`)
229) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
230
231-- Dumping data for table maldenlife1.gouvernement_logs: ~0 rows (approximately)
232DELETE FROM `gouvernement_logs`;
233/*!40000 ALTER TABLE `gouvernement_logs` DISABLE KEYS */;
234/*!40000 ALTER TABLE `gouvernement_logs` ENABLE KEYS */;
235
236-- Dumping structure for table maldenlife1.houses
237DROP TABLE IF EXISTS `houses`;
238CREATE TABLE IF NOT EXISTS `houses` (
239 `id` int(6) NOT NULL AUTO_INCREMENT,
240 `pid` varchar(17) NOT NULL,
241 `pos` varchar(64) DEFAULT NULL,
242 `owned` tinyint(1) DEFAULT '0',
243 `garage` tinyint(1) NOT NULL DEFAULT '0',
244 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
245 PRIMARY KEY (`id`,`pid`)
246) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
247
248-- Dumping data for table maldenlife1.houses: ~0 rows (approximately)
249DELETE FROM `houses`;
250/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
251/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
252
253-- Dumping structure for table maldenlife1.messages
254DROP TABLE IF EXISTS `messages`;
255CREATE TABLE IF NOT EXISTS `messages` (
256 `uid` int(12) NOT NULL AUTO_INCREMENT,
257 `fromID` varchar(50) NOT NULL,
258 `toID` varchar(50) NOT NULL,
259 `message` text,
260 `fromName` varchar(32) NOT NULL,
261 `toName` varchar(32) NOT NULL,
262 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
263 PRIMARY KEY (`uid`)
264) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
265
266-- Dumping data for table maldenlife1.messages: ~0 rows (approximately)
267DELETE FROM `messages`;
268/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
269/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
270
271-- Dumping structure for table maldenlife1.players
272DROP TABLE IF EXISTS `players`;
273CREATE TABLE IF NOT EXISTS `players` (
274 `uid` int(6) NOT NULL AUTO_INCREMENT,
275 `name` varchar(32) NOT NULL,
276 `aliases` text NOT NULL,
277 `pid` varchar(17) NOT NULL,
278 `cash` int(100) NOT NULL DEFAULT '20',
279 `bankacc` int(100) NOT NULL DEFAULT '0',
280 `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12') NOT NULL DEFAULT '0',
281 `mediclevel` enum('0','1') NOT NULL DEFAULT '0',
282 `civ_licenses` text NOT NULL,
283 `cop_licenses` text NOT NULL,
284 `med_licenses` text NOT NULL,
285 `civ_gear` text NOT NULL,
286 `cop_gear` text NOT NULL,
287 `med_gear` text NOT NULL,
288 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
289 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
290 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
291 `arrested` tinyint(1) NOT NULL DEFAULT '0',
292 `adminlevel` enum('0','1','2') NOT NULL DEFAULT '0',
293 `donorlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
294 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
295 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
296 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
297 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
298 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
299 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
300 `exp_level` int(11) NOT NULL DEFAULT '0',
301 `exp_total` int(11) NOT NULL DEFAULT '0',
302 `exp_perkPoints` int(11) NOT NULL DEFAULT '0',
303 `exp_perks` text,
304 `jail_time` int(11) NOT NULL DEFAULT '0',
305 PRIMARY KEY (`uid`),
306 UNIQUE KEY `pid` (`pid`),
307 KEY `name` (`name`),
308 KEY `blacklist` (`blacklist`)
309) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
310
311-- Dumping data for table maldenlife1.players: ~1 rows (approximately)
312DELETE FROM `players`;
313/*!40000 ALTER TABLE `players` DISABLE KEYS */;
314INSERT INTO `players` (`uid`, `name`, `aliases`, `pid`, `cash`, `bankacc`, `coplevel`, `mediclevel`, `civ_licenses`, `cop_licenses`, `med_licenses`, `civ_gear`, `cop_gear`, `med_gear`, `civ_stats`, `cop_stats`, `med_stats`, `arrested`, `adminlevel`, `donorlevel`, `blacklist`, `civ_alive`, `civ_position`, `playtime`, `insert_time`, `last_seen`, `exp_level`, `exp_total`, `exp_perkPoints`, `exp_perks`, `jail_time`) VALUES
315 (37, '[Dev] Ras Al Ghul', '"[`[Dev] Ras Al Ghul`]"', '76561198094478387', 242000, 0, '0', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_cloth`,0],[`license_civ_steelplate`,0],[`license_civ_C4`,0],[`license_civ_rubber`,0],[`license_civ_gunpowder`,0],[`license_civ_lumber`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_redwhite`,``,`B_TacticalPack_blk`,``,`H_Booniehat_dirty`,[`ItemMap`,`ItemCompass`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', '0', 0, 0, '"[8074.3,4042.15,0.470825]"', '"[0,0,1]"', '2019-02-16 20:18:40', '2019-02-16 20:39:17', 0, 15, 0, '[[["perk_gunsspecialist_lessRecoil_1",0],[[["perk_gunsspecialist_lessRecoil_2",0],[[["perk_gunsspecialist_lessRecoil_3",0],[[["perk_gunsspecialist_lessRecoil_4",0],[["perk_gunsspecialist_lessRecoil_5",0]]]]]]]]],[["perk_weaponSway_1",0],[[["perk_weaponSway_2",0],[[["perk_weaponSway_3",0],[["perk_weaponSway_4",0]]]]]]],[["perk_paycheck_1",0],[[["perk_paycheck_2",0],[[["perk_paycheck_3",0],[["perk_paycheck_4",0]]]]]]],[["perk_processing_1",0],[[["perk_processing_2",0],[[["perk_processing_3",0],[[["perk_processing_4",0],[[["perk_processing_5",0],[["perk_processing_6",0]]]]]]]]]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[[["perk_locksmith_3",0],[[["perk_locksmith_4",0],[["perk_locksmith_5",0]]]]]]]]],[["functions_impoundSpeed_1",0],[["functions_impoundSpeed_2",0]]],[["functions_repairSpeed_1",0],[[["functions_repairSpeed_2",0],[["functions_repairInfinite_1",0]]]]],[["perk_medical",0],[[["perk_cpr_1",0],[[["perk_cpr_2",0],[["perk_cpr_full",0]]]]]]],[["functions_rebel_1",0],[["functions_terrorist_1",0]]],["functions_loadouts_1",0],[["perk_lsd_1",0],[["perk_uranium_1",0]]],["functions_air_1",0],["perk_gasrobbery_1",0],["functions_home_1",0],["functions_advCop_1",0],[["functions_relicReward",0],[[["functions_relicReward2",0],[["functions_relicReward3",0]]]]]]', 0);
316/*!40000 ALTER TABLE `players` ENABLE KEYS */;
317
318-- Dumping structure for procedure maldenlife1.resetLifeVehicles
319DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
320DELIMITER //
321CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
322BEGIN
323 UPDATE `vehicles` SET `active`= 0;
324END//
325DELIMITER ;
326
327-- Dumping structure for table maldenlife1.vehicles
328DROP TABLE IF EXISTS `vehicles`;
329CREATE TABLE IF NOT EXISTS `vehicles` (
330 `id` int(6) NOT NULL AUTO_INCREMENT,
331 `side` varchar(16) NOT NULL,
332 `classname` varchar(64) NOT NULL,
333 `type` varchar(16) NOT NULL,
334 `pid` varchar(17) NOT NULL,
335 `alive` tinyint(1) NOT NULL DEFAULT '1',
336 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
337 `active` tinyint(1) NOT NULL DEFAULT '0',
338 `plate` int(20) NOT NULL,
339 `color` int(20) NOT NULL,
340 `inventory` text NOT NULL,
341 `gear` text NOT NULL,
342 `fuel` double NOT NULL DEFAULT '1',
343 `damage` varchar(256) NOT NULL,
344 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
345 `insure` int(1) NOT NULL DEFAULT '0',
346 `entreprise_id` int(10) NOT NULL DEFAULT '0',
347 PRIMARY KEY (`id`),
348 KEY `side` (`side`),
349 KEY `pid` (`pid`),
350 KEY `type` (`type`)
351) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;
352
353-- Dumping data for table maldenlife1.vehicles: ~0 rows (approximately)
354DELETE FROM `vehicles`;
355/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
356INSERT INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `blacklist`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`, `damage`, `insert_time`, `insure`, `entreprise_id`) VALUES
357 (91, 'civ', 'B_Quadbike_01_F', 'Car', '76561198094478387', 1, 0, 0, 386607, 3, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-02-16 20:39:17', 0, 0);
358/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
359
360-- Dumping structure for table maldenlife1.wanted
361DROP TABLE IF EXISTS `wanted`;
362CREATE TABLE IF NOT EXISTS `wanted` (
363 `wantedID` varchar(64) NOT NULL,
364 `wantedName` varchar(32) NOT NULL,
365 `wantedCrimes` text NOT NULL,
366 `wantedBounty` int(100) NOT NULL,
367 `active` tinyint(1) NOT NULL DEFAULT '0',
368 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
369 PRIMARY KEY (`wantedID`)
370) ENGINE=InnoDB DEFAULT CHARSET=utf8;
371
372-- Dumping data for table maldenlife1.wanted: ~0 rows (approximately)
373DELETE FROM `wanted`;
374/*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
375/*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
376
377/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
378/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
379/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;