· 6 years ago · Aug 03, 2019, 05:02 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.7.18-log - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
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.ah
20CREATE TABLE IF NOT EXISTS `ah` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `type` int(5) NOT NULL DEFAULT '0',
23 `amount` int(5) NOT NULL DEFAULT '0',
24 `item` text NOT NULL,
25 `price` int(100) NOT NULL DEFAULT '0',
26 `seller` varchar(50) NOT NULL,
27 `sellername` varchar(32) NOT NULL,
28 `status` int(5) NOT NULL DEFAULT '0',
29 `time` int(11) NOT NULL DEFAULT '0',
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
32
33-- Data exporting was unselected.
34-- Dumping structure for table maldenlife.bounty
35CREATE TABLE IF NOT EXISTS `bounty` (
36 `bountyID` varchar(64) NOT NULL,
37 `bountyName` varchar(32) NOT NULL,
38 `bounty` int(100) NOT NULL,
39 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
40 PRIMARY KEY (`bountyID`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
42
43-- Data exporting was unselected.
44-- Dumping structure for table maldenlife.containers
45CREATE TABLE IF NOT EXISTS `containers` (
46 `id` int(6) NOT NULL AUTO_INCREMENT,
47 `pid` varchar(17) NOT NULL,
48 `classname` varchar(32) NOT NULL,
49 `pos` varchar(64) DEFAULT NULL,
50 `inventory` text NOT NULL,
51 `gear` text NOT NULL,
52 `dir` varchar(128) DEFAULT NULL,
53 `active` tinyint(1) NOT NULL DEFAULT '0',
54 `owned` tinyint(1) DEFAULT '0',
55 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
56 PRIMARY KEY (`id`,`pid`)
57) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4;
58
59-- Data exporting was unselected.
60-- Dumping structure for procedure maldenlife.deleteDeadVehicles
61DELIMITER //
62CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()
63BEGIN
64 DELETE FROM `vehicles` WHERE `alive` = 0;
65END//
66DELIMITER ;
67
68-- Dumping structure for procedure maldenlife.deleteOldContainers
69DELIMITER //
70CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldContainers`()
71BEGIN
72 DELETE FROM `containers` WHERE `owned` = 0;
73END//
74DELIMITER ;
75
76-- Dumping structure for procedure maldenlife.deleteOldGangs
77DELIMITER //
78CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()
79BEGIN
80 DELETE FROM `gangs` WHERE `active` = 0;
81END//
82DELIMITER ;
83
84-- Dumping structure for procedure maldenlife.deleteOldHouses
85DELIMITER //
86CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()
87BEGIN
88 DELETE FROM `houses` WHERE `owned` = 0;
89END//
90DELIMITER ;
91
92-- Dumping structure for procedure maldenlife.deleteOldWanted
93DELIMITER //
94CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldWanted`()
95BEGIN
96 DELETE FROM `wanted` WHERE `active` = 0;
97END//
98DELIMITER ;
99
100-- Dumping structure for table maldenlife.gangs
101CREATE TABLE IF NOT EXISTS `gangs` (
102 `id` int(6) NOT NULL AUTO_INCREMENT,
103 `owner` varchar(32) DEFAULT NULL,
104 `name` varchar(32) DEFAULT NULL,
105 `members` text,
106 `maxmembers` int(3) DEFAULT '8',
107 `bank` int(100) DEFAULT '0',
108 `active` tinyint(1) DEFAULT '1',
109 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
110 PRIMARY KEY (`id`),
111 UNIQUE KEY `name_UNIQUE` (`name`)
112) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
113
114-- Data exporting was unselected.
115-- Dumping structure for table maldenlife.houses
116CREATE TABLE IF NOT EXISTS `houses` (
117 `id` int(6) NOT NULL AUTO_INCREMENT,
118 `pid` varchar(17) NOT NULL,
119 `pos` varchar(64) DEFAULT NULL,
120 `owned` tinyint(1) DEFAULT '0',
121 `garage` tinyint(1) NOT NULL DEFAULT '0',
122 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
123 PRIMARY KEY (`id`,`pid`)
124) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;
125
126-- Data exporting was unselected.
127-- Dumping structure for table maldenlife.messages
128CREATE TABLE IF NOT EXISTS `messages` (
129 `uid` int(12) NOT NULL AUTO_INCREMENT,
130 `fromID` varchar(50) NOT NULL,
131 `toID` varchar(50) NOT NULL,
132 `message` text,
133 `fromName` varchar(32) NOT NULL,
134 `toName` varchar(32) NOT NULL,
135 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
136 PRIMARY KEY (`uid`)
137) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
138
139-- Data exporting was unselected.
140-- Dumping structure for table maldenlife.perso
141CREATE TABLE IF NOT EXISTS `perso` (
142 `id` int(12) NOT NULL AUTO_INCREMENT,
143 `pid` varchar(50) NOT NULL DEFAULT '',
144 `persoCop` text NOT NULL,
145 `persoMed` text NOT NULL,
146 `persoCiv` text NOT NULL,
147 `persoEast` text NOT NULL,
148 `Erstellungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
149 `Aenderungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
150 PRIMARY KEY (`id`),
151 UNIQUE KEY `pid` (`pid`)
152) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
153
154-- Data exporting was unselected.
155-- Dumping structure for table maldenlife.players
156CREATE TABLE IF NOT EXISTS `players` (
157 `uid` int(6) NOT NULL AUTO_INCREMENT,
158 `name` varchar(32) NOT NULL,
159 `aliases` text NOT NULL,
160 `pid` varchar(17) NOT NULL,
161 `banking_pin` int(4) NOT NULL DEFAULT '0',
162 `cash` int(100) NOT NULL DEFAULT '20',
163 `bankacc` int(100) NOT NULL DEFAULT '0',
164 `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12') NOT NULL DEFAULT '0',
165 `mediclevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
166 `civ_licenses` text NOT NULL,
167 `cop_licenses` text NOT NULL,
168 `med_licenses` text NOT NULL,
169 `civ_gear` text NOT NULL,
170 `cop_gear` text NOT NULL,
171 `med_gear` text NOT NULL,
172 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
173 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
174 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
175 `arrested` tinyint(1) NOT NULL DEFAULT '0',
176 `adminlevel` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
177 `donorlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
178 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
179 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
180 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
181 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
182 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
183 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
184 `exp_level` int(11) NOT NULL DEFAULT '0',
185 `exp_total` int(11) NOT NULL DEFAULT '0',
186 `exp_perkPoints` int(11) NOT NULL DEFAULT '0',
187 `exp_perks` text,
188 `jail_time` int(11) NOT NULL DEFAULT '0',
189 `IsCop` tinyint(1) NOT NULL DEFAULT '0',
190 `IsEMT` tinyint(1) NOT NULL DEFAULT '0',
191 `IsAdac` tinyint(1) NOT NULL DEFAULT '0',
192 PRIMARY KEY (`uid`),
193 UNIQUE KEY `pid` (`pid`),
194 KEY `name` (`name`),
195 KEY `blacklist` (`blacklist`)
196) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4;
197
198-- Data exporting was unselected.
199-- Dumping structure for procedure maldenlife.resetLifeVehicles
200DELIMITER //
201CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
202BEGIN
203 UPDATE `vehicles` SET `active`= 0;
204END//
205DELIMITER ;
206
207-- Dumping structure for table maldenlife.vehicles
208CREATE TABLE IF NOT EXISTS `vehicles` (
209 `id` int(6) NOT NULL AUTO_INCREMENT,
210 `side` varchar(16) NOT NULL,
211 `classname` varchar(64) NOT NULL,
212 `type` varchar(16) NOT NULL,
213 `pid` varchar(17) NOT NULL,
214 `alive` tinyint(1) NOT NULL DEFAULT '1',
215 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
216 `active` tinyint(1) NOT NULL DEFAULT '0',
217 `plate` int(20) NOT NULL,
218 `color` int(20) NOT NULL,
219 `inventory` text NOT NULL,
220 `gear` text NOT NULL,
221 `fuel` double NOT NULL DEFAULT '1',
222 `damage` varchar(256) NOT NULL,
223 `vis` text,
224 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
225 `insure` int(1) NOT NULL DEFAULT '0',
226 `tuning_data` varchar(300) NOT NULL DEFAULT '[]',
227 PRIMARY KEY (`id`),
228 KEY `side` (`side`),
229 KEY `pid` (`pid`),
230 KEY `type` (`type`)
231) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4;
232
233-- Data exporting was unselected.
234-- Dumping structure for table maldenlife.wanted
235CREATE TABLE IF NOT EXISTS `wanted` (
236 `wantedID` varchar(64) NOT NULL,
237 `wantedName` varchar(32) NOT NULL,
238 `wantedCrimes` text NOT NULL,
239 `wantedBounty` int(100) NOT NULL,
240 `active` tinyint(1) NOT NULL DEFAULT '0',
241 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
242 PRIMARY KEY (`wantedID`)
243) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
244
245-- Data exporting was unselected.
246/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
247/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
248/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;