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