· 7 years ago · Feb 11, 2019, 10:02 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 maldenlife
16CREATE DATABASE IF NOT EXISTS `maldenlife` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
17USE `maldenlife`;
18
19-- Dumping structure for table maldenlife.advanced_identity
20CREATE TABLE IF NOT EXISTS `advanced_identity` (
21 `pid` varchar(64) NOT NULL,
22 `name_player` varchar(32) NOT NULL,
23 `nom` varchar(32) NOT NULL,
24 `prenom` varchar(32) NOT NULL,
25 `naissance` text NOT NULL,
26 `lieu_naissance` text NOT NULL,
27 `taille` int(10) NOT NULL,
28 `sexe` int(1) NOT NULL,
29 PRIMARY KEY (`pid`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
31
32-- Data exporting was unselected.
33-- Dumping structure for table maldenlife.ah
34CREATE TABLE IF NOT EXISTS `ah` (
35 `id` int(11) NOT NULL AUTO_INCREMENT,
36 `type` int(5) NOT NULL DEFAULT '0',
37 `amount` int(5) NOT NULL DEFAULT '0',
38 `item` text NOT NULL,
39 `price` int(100) NOT NULL DEFAULT '0',
40 `seller` varchar(50) NOT NULL,
41 `sellername` varchar(32) NOT NULL,
42 `status` int(5) NOT NULL DEFAULT '0',
43 `time` int(11) NOT NULL DEFAULT '0',
44 PRIMARY KEY (`id`)
45) ENGINE=InnoDB DEFAULT CHARSET=latin1;
46
47-- Data exporting was unselected.
48-- Dumping structure for table maldenlife.bounty
49CREATE TABLE IF NOT EXISTS `bounty` (
50 `bountyID` varchar(64) NOT NULL,
51 `bountyName` varchar(32) NOT NULL,
52 `bounty` int(100) NOT NULL,
53 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
54 PRIMARY KEY (`bountyID`)
55) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
56
57-- Data exporting was unselected.
58-- Dumping structure for table maldenlife.containers
59CREATE TABLE IF NOT EXISTS `containers` (
60 `id` int(6) NOT NULL AUTO_INCREMENT,
61 `pid` varchar(17) NOT NULL,
62 `classname` varchar(32) NOT NULL,
63 `pos` varchar(64) DEFAULT NULL,
64 `inventory` text NOT NULL,
65 `gear` text NOT NULL,
66 `dir` varchar(128) DEFAULT NULL,
67 `active` tinyint(1) NOT NULL DEFAULT '0',
68 `owned` tinyint(1) DEFAULT '0',
69 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
70 PRIMARY KEY (`id`,`pid`)
71) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;
72
73-- Data exporting was unselected.
74-- Dumping structure for procedure maldenlife.deleteDeadVehicles
75DELIMITER //
76CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()
77BEGIN
78 DELETE FROM `vehicles` WHERE `alive` = 0;
79END//
80DELIMITER ;
81
82-- Dumping structure for procedure maldenlife.deleteOldContainers
83DELIMITER //
84CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldContainers`()
85BEGIN
86 DELETE FROM `containers` WHERE `owned` = 0;
87END//
88DELIMITER ;
89
90-- Dumping structure for procedure maldenlife.deleteOldGangs
91DELIMITER //
92CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()
93BEGIN
94 DELETE FROM `gangs` WHERE `active` = 0;
95END//
96DELIMITER ;
97
98-- Dumping structure for procedure maldenlife.deleteOldHouses
99DELIMITER //
100CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()
101BEGIN
102 DELETE FROM `houses` WHERE `owned` = 0;
103END//
104DELIMITER ;
105
106-- Dumping structure for procedure maldenlife.deleteOldWanted
107DELIMITER //
108CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldWanted`()
109BEGIN
110 DELETE FROM `wanted` WHERE `active` = 0;
111END//
112DELIMITER ;
113
114-- Dumping structure for table maldenlife.entreprises
115CREATE TABLE IF NOT EXISTS `entreprises` (
116 `id` int(6) NOT NULL AUTO_INCREMENT,
117 `name` varchar(32) NOT NULL,
118 `pdg_pid` varchar(17) NOT NULL DEFAULT '0',
119 `pdg_name` varchar(32) NOT NULL,
120 `members` text NOT NULL,
121 `prices` text NOT NULL,
122 `items_stock` text NOT NULL,
123 `max_stock` int(3) NOT NULL DEFAULT '0',
124 `items_stock_2` text NOT NULL,
125 `max_stock_2` int(3) NOT NULL DEFAULT '0',
126 `bankacc` int(100) NOT NULL DEFAULT '0',
127 `position` varchar(32) DEFAULT NULL,
128 `objects` text NOT NULL,
129 `type` varchar(32) NOT NULL,
130 `active` tinyint(1) NOT NULL DEFAULT '1',
131 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
132 PRIMARY KEY (`id`)
133) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
134
135-- Data exporting was unselected.
136-- Dumping structure for table maldenlife.entreprises_logs
137CREATE TABLE IF NOT EXISTS `entreprises_logs` (
138 `id` int(6) NOT NULL AUTO_INCREMENT,
139 `entreprise_id` int(6) NOT NULL DEFAULT '0',
140 `name` varchar(32) NOT NULL,
141 `value` int(6) NOT NULL DEFAULT '0',
142 `type` int(1) NOT NULL DEFAULT '0',
143 `other` int(1) NOT NULL DEFAULT '0',
144 `insert_time` text NOT NULL,
145 PRIMARY KEY (`id`)
146) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
147
148-- Data exporting was unselected.
149-- Dumping structure for table maldenlife.gangs
150CREATE TABLE IF NOT EXISTS `gangs` (
151 `id` int(6) NOT NULL AUTO_INCREMENT,
152 `owner` varchar(32) DEFAULT NULL,
153 `name` varchar(32) DEFAULT NULL,
154 `members` text,
155 `maxmembers` int(3) DEFAULT '8',
156 `bank` int(100) DEFAULT '0',
157 `active` tinyint(1) DEFAULT '1',
158 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
159 PRIMARY KEY (`id`),
160 UNIQUE KEY `name_UNIQUE` (`name`)
161) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4;
162
163-- Data exporting was unselected.
164-- Dumping structure for table maldenlife.gouvernement
165CREATE TABLE IF NOT EXISTS `gouvernement` (
166 `id` int(6) NOT NULL DEFAULT '1',
167 `vote_proccessing` int(1) NOT NULL DEFAULT '0',
168 `candidats` text NOT NULL,
169 `voters` text NOT NULL,
170 `compte_gouv` int(100) NOT NULL DEFAULT '0',
171 `compte_cop` int(100) NOT NULL DEFAULT '0',
172 `compte_med` int(100) NOT NULL DEFAULT '0',
173 `gouverneur` text NOT NULL,
174 `ministres` text NOT NULL,
175 `security` text NOT NULL,
176 `taxes` text NOT NULL,
177 `laws` text NOT NULL,
178 PRIMARY KEY (`id`)
179) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
180
181-- Data exporting was unselected.
182-- Dumping structure for table maldenlife.gouvernement_logs
183CREATE TABLE IF NOT EXISTS `gouvernement_logs` (
184 `id` int(6) NOT NULL AUTO_INCREMENT,
185 `name` varchar(32) NOT NULL,
186 `value` int(6) NOT NULL DEFAULT '0',
187 `from_id` int(1) NOT NULL,
188 `to_id` int(1) NOT NULL,
189 `type` int(1) NOT NULL,
190 `insert_time` text NOT NULL,
191 PRIMARY KEY (`id`)
192) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
193
194-- Data exporting was unselected.
195-- Dumping structure for table maldenlife.houses
196CREATE TABLE IF NOT EXISTS `houses` (
197 `id` int(6) NOT NULL AUTO_INCREMENT,
198 `pid` varchar(17) NOT NULL,
199 `pos` varchar(64) DEFAULT NULL,
200 `owned` tinyint(1) DEFAULT '0',
201 `garage` tinyint(1) NOT NULL DEFAULT '0',
202 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
203 PRIMARY KEY (`id`,`pid`)
204) ENGINE=InnoDB AUTO_INCREMENT=944 DEFAULT CHARSET=utf8mb4;
205
206-- Data exporting was unselected.
207-- Dumping structure for table maldenlife.messages
208CREATE TABLE IF NOT EXISTS `messages` (
209 `uid` int(12) NOT NULL AUTO_INCREMENT,
210 `fromID` varchar(50) NOT NULL,
211 `toID` varchar(50) NOT NULL,
212 `message` text,
213 `fromName` varchar(32) NOT NULL,
214 `toName` varchar(32) NOT NULL,
215 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
216 PRIMARY KEY (`uid`)
217) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
218
219-- Data exporting was unselected.
220-- Dumping structure for table maldenlife.perso
221CREATE TABLE IF NOT EXISTS `perso` (
222 `id` int(12) NOT NULL AUTO_INCREMENT,
223 `pid` varchar(50) NOT NULL DEFAULT '',
224 `persoCop` text NOT NULL,
225 `persoMed` text NOT NULL,
226 `persoCiv` text NOT NULL,
227 `persoEast` text NOT NULL,
228 `Erstellungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
229 `Aenderungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
230 PRIMARY KEY (`id`),
231 UNIQUE KEY `pid` (`pid`)
232) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
233
234-- Data exporting was unselected.
235-- Dumping structure for table maldenlife.players
236CREATE TABLE IF NOT EXISTS `players` (
237 `uid` int(6) NOT NULL AUTO_INCREMENT,
238 `name` varchar(32) NOT NULL,
239 `aliases` text NOT NULL,
240 `pid` varchar(17) NOT NULL,
241 `banking_pin` int(4) NOT NULL DEFAULT '0',
242 `cash` int(100) NOT NULL DEFAULT '20',
243 `bankacc` int(100) NOT NULL DEFAULT '0',
244 `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12') NOT NULL DEFAULT '0',
245 `mediclevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
246 `civ_licenses` text NOT NULL,
247 `cop_licenses` text NOT NULL,
248 `med_licenses` text NOT NULL,
249 `civ_gear` text NOT NULL,
250 `cop_gear` text NOT NULL,
251 `med_gear` text NOT NULL,
252 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
253 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
254 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
255 `arrested` tinyint(1) NOT NULL DEFAULT '0',
256 `adminlevel` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
257 `donorlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
258 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
259 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
260 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
261 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
262 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
263 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
264 `exp_level` int(11) NOT NULL DEFAULT '0',
265 `exp_total` int(11) NOT NULL DEFAULT '0',
266 `exp_perkPoints` int(11) NOT NULL DEFAULT '0',
267 `exp_perks` text,
268 `jail_time` int(11) NOT NULL DEFAULT '0',
269 PRIMARY KEY (`uid`),
270 UNIQUE KEY `pid` (`pid`),
271 KEY `name` (`name`),
272 KEY `blacklist` (`blacklist`)
273) ENGINE=InnoDB AUTO_INCREMENT=303 DEFAULT CHARSET=utf8mb4;
274
275-- Data exporting was unselected.
276-- Dumping structure for procedure maldenlife.resetLifeVehicles
277DELIMITER //
278CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
279BEGIN
280 UPDATE `vehicles` SET `active`= 0;
281END//
282DELIMITER ;
283
284-- Dumping structure for table maldenlife.vehicles
285CREATE TABLE IF NOT EXISTS `vehicles` (
286 `id` int(6) NOT NULL AUTO_INCREMENT,
287 `side` varchar(16) NOT NULL,
288 `classname` varchar(64) NOT NULL,
289 `type` varchar(16) NOT NULL,
290 `pid` varchar(17) NOT NULL,
291 `alive` tinyint(1) NOT NULL DEFAULT '1',
292 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
293 `active` tinyint(1) NOT NULL DEFAULT '0',
294 `plate` int(20) NOT NULL,
295 `color` int(20) NOT NULL,
296 `inventory` text NOT NULL,
297 `gear` text NOT NULL,
298 `fuel` double NOT NULL DEFAULT '1',
299 `damage` varchar(256) NOT NULL,
300 `vis` text,
301 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
302 `insure` int(1) NOT NULL DEFAULT '0',
303 `tuning_data` varchar(300) NOT NULL DEFAULT '[]',
304 PRIMARY KEY (`id`),
305 KEY `side` (`side`),
306 KEY `pid` (`pid`),
307 KEY `type` (`type`)
308) ENGINE=InnoDB AUTO_INCREMENT=1083 DEFAULT CHARSET=utf8mb4;
309
310-- Data exporting was unselected.
311-- Dumping structure for table maldenlife.wanted
312CREATE TABLE IF NOT EXISTS `wanted` (
313 `wantedID` varchar(64) NOT NULL,
314 `wantedName` varchar(32) NOT NULL,
315 `wantedCrimes` text NOT NULL,
316 `wantedBounty` int(100) NOT NULL,
317 `active` tinyint(1) NOT NULL DEFAULT '0',
318 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
319 PRIMARY KEY (`wantedID`)
320) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
321
322-- Data exporting was unselected.
323-- Dumping structure for table maldenlife.xphonemessages
324CREATE TABLE IF NOT EXISTS `xphonemessages` (
325 `sender` varchar(50) DEFAULT NULL,
326 `receiver` varchar(50) DEFAULT NULL,
327 `message` text,
328 `timesent` timestamp NULL DEFAULT CURRENT_TIMESTAMP
329) ENGINE=InnoDB DEFAULT CHARSET=latin1;
330
331-- Data exporting was unselected.
332-- Dumping structure for table maldenlife.xphonenumbers
333CREATE TABLE IF NOT EXISTS `xphonenumbers` (
334 `number` varchar(50) DEFAULT NULL,
335 `uid` varchar(50) DEFAULT NULL
336) ENGINE=InnoDB DEFAULT CHARSET=latin1;
337
338-- Data exporting was unselected.
339/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
340/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
341/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;