· 6 years ago · Aug 28, 2019, 09:20 PM
1-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost Database: db69127
4-- ------------------------------------------------------
5-- Server version 5.5.5-10.1.21-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `containers`
20--
21
22DROP TABLE IF EXISTS `containers`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `containers` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `pid` varchar(32) NOT NULL,
28 `classname` varchar(32) NOT NULL,
29 `pos` varchar(64) DEFAULT NULL,
30 `inventory` text NOT NULL,
31 `gear` text NOT NULL,
32 `dir` varchar(128) DEFAULT NULL,
33 `active` tinyint(1) NOT NULL DEFAULT '0',
34 `owned` tinyint(1) DEFAULT '0',
35 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
36 PRIMARY KEY (`id`,`pid`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Table structure for table `gangs`
42--
43
44DROP TABLE IF EXISTS `gangs`;
45/*!40101 SET @saved_cs_client = @@character_set_client */;
46/*!40101 SET character_set_client = utf8 */;
47CREATE TABLE `gangs` (
48 `id` int(11) NOT NULL AUTO_INCREMENT,
49 `owner` varchar(32) DEFAULT NULL,
50 `name` varchar(32) DEFAULT NULL,
51 `members` text,
52 `maxmembers` int(3) DEFAULT '8',
53 `bank` int(100) DEFAULT '0',
54 `active` tinyint(1) DEFAULT '1',
55 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
56 PRIMARY KEY (`id`),
57 UNIQUE KEY `name_UNIQUE` (`name`)
58) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
59/*!40101 SET character_set_client = @saved_cs_client */;
60
61--
62-- Table structure for table `houses`
63--
64
65DROP TABLE IF EXISTS `houses`;
66/*!40101 SET @saved_cs_client = @@character_set_client */;
67/*!40101 SET character_set_client = utf8 */;
68CREATE TABLE `houses` (
69 `id` int(11) NOT NULL AUTO_INCREMENT,
70 `pid` varchar(32) NOT NULL,
71 `pos` varchar(64) DEFAULT NULL,
72 `owned` tinyint(1) DEFAULT '0',
73 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
74 PRIMARY KEY (`id`,`pid`)
75) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
76/*!40101 SET character_set_client = @saved_cs_client */;
77
78--
79-- Table structure for table `players`
80--
81
82DROP TABLE IF EXISTS `players`;
83/*!40101 SET @saved_cs_client = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `players` (
86 `uid` int(12) NOT NULL AUTO_INCREMENT,
87 `name` varchar(32) NOT NULL,
88 `aliases` text NOT NULL,
89 `playerid` varchar(64) NOT NULL,
90 `cash` int(100) NOT NULL DEFAULT '0',
91 `bankacc` int(100) NOT NULL DEFAULT '0',
92 `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10') NOT NULL DEFAULT '0',
93 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
94 `civ_licenses` text NOT NULL,
95 `cop_licenses` text NOT NULL,
96 `med_licenses` text NOT NULL,
97 `civ_gear` text NOT NULL,
98 `cop_gear` text NOT NULL,
99 `med_gear` text NOT NULL,
100 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
101 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
102 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
103 `arrested` tinyint(1) NOT NULL DEFAULT '0',
104 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
105 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
106 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
107 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
108 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
109 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
110 `voted` tinyint(1) NOT NULL DEFAULT '0',
111 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
112 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
113 `jail_time` int(11) NOT NULL DEFAULT '0',
114 `experience_points` int(11) NOT NULL DEFAULT '0',
115 `unlocked_perks` text,
116 `perk_points` int(11) NOT NULL DEFAULT '0',
117 `ugrank` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
118 `depositbox` int(100) NOT NULL DEFAULT '0',
119 PRIMARY KEY (`uid`),
120 UNIQUE KEY `playerid` (`playerid`),
121 KEY `name` (`name`),
122 KEY `blacklist` (`blacklist`)
123) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Table structure for table `vehicles`
128--
129
130DROP TABLE IF EXISTS `vehicles`;
131/*!40101 SET @saved_cs_client = @@character_set_client */;
132/*!40101 SET character_set_client = utf8 */;
133CREATE TABLE `vehicles` (
134 `id` int(12) NOT NULL AUTO_INCREMENT,
135 `side` varchar(16) NOT NULL,
136 `classname` varchar(64) NOT NULL,
137 `type` varchar(16) NOT NULL,
138 `pid` varchar(32) NOT NULL,
139 `alive` tinyint(1) NOT NULL DEFAULT '1',
140 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
141 `active` tinyint(1) NOT NULL DEFAULT '0',
142 `plate` int(20) NOT NULL,
143 `color` int(20) NOT NULL,
144 `inventory` text NOT NULL,
145 `gear` text NOT NULL,
146 `fuel` double NOT NULL DEFAULT '1',
147 `damage` varchar(256) NOT NULL,
148 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
149 PRIMARY KEY (`id`),
150 KEY `side` (`side`),
151 KEY `pid` (`pid`),
152 KEY `type` (`type`)
153) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
154/*!40101 SET character_set_client = @saved_cs_client */;
155
156--
157-- Table structure for table `wanted`
158--
159
160DROP TABLE IF EXISTS `wanted`;
161/*!40101 SET @saved_cs_client = @@character_set_client */;
162/*!40101 SET character_set_client = utf8 */;
163CREATE TABLE `wanted` (
164 `wantedID` varchar(64) NOT NULL,
165 `wantedName` varchar(32) NOT NULL,
166 `wantedCrimes` text NOT NULL,
167 `wantedBounty` int(100) NOT NULL,
168 `active` tinyint(1) NOT NULL DEFAULT '0',
169 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
170 PRIMARY KEY (`wantedID`)
171) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
172/*!40101 SET character_set_client = @saved_cs_client */;
173
174--
175-- Dumping events for database 'db69127'
176--
177
178--
179-- Dumping routines for database 'db69127'
180--
181/*!50003 DROP PROCEDURE IF EXISTS `deleteDeadVehicles` */;
182/*!50003 SET @saved_cs_client = @@character_set_client */ ;
183/*!50003 SET @saved_cs_results = @@character_set_results */ ;
184/*!50003 SET @saved_col_connection = @@collation_connection */ ;
185/*!50003 SET character_set_client = utf8mb4 */ ;
186/*!50003 SET character_set_results = utf8mb4 */ ;
187/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
188/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
189/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ;
190DELIMITER ;;
191CREATE DEFINER=`life`@`localhost` PROCEDURE `deleteDeadVehicles`()
192BEGIN
193 DELETE FROM `vehicles` WHERE `alive` = 0;
194END ;;
195DELIMITER ;
196/*!50003 SET sql_mode = @saved_sql_mode */ ;
197/*!50003 SET character_set_client = @saved_cs_client */ ;
198/*!50003 SET character_set_results = @saved_cs_results */ ;
199/*!50003 SET collation_connection = @saved_col_connection */ ;
200/*!50003 DROP PROCEDURE IF EXISTS `deleteOldContainers` */;
201/*!50003 SET @saved_cs_client = @@character_set_client */ ;
202/*!50003 SET @saved_cs_results = @@character_set_results */ ;
203/*!50003 SET @saved_col_connection = @@collation_connection */ ;
204/*!50003 SET character_set_client = utf8mb4 */ ;
205/*!50003 SET character_set_results = utf8mb4 */ ;
206/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
207/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
208/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ;
209DELIMITER ;;
210CREATE DEFINER=`life`@`localhost` PROCEDURE `deleteOldContainers`()
211BEGIN
212 DELETE FROM `containers` WHERE `owned` = 0;
213END ;;
214DELIMITER ;
215/*!50003 SET sql_mode = @saved_sql_mode */ ;
216/*!50003 SET character_set_client = @saved_cs_client */ ;
217/*!50003 SET character_set_results = @saved_cs_results */ ;
218/*!50003 SET collation_connection = @saved_col_connection */ ;
219/*!50003 DROP PROCEDURE IF EXISTS `deleteOldGangs` */;
220/*!50003 SET @saved_cs_client = @@character_set_client */ ;
221/*!50003 SET @saved_cs_results = @@character_set_results */ ;
222/*!50003 SET @saved_col_connection = @@collation_connection */ ;
223/*!50003 SET character_set_client = utf8mb4 */ ;
224/*!50003 SET character_set_results = utf8mb4 */ ;
225/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
226/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
227/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ;
228DELIMITER ;;
229CREATE DEFINER=`life`@`localhost` PROCEDURE `deleteOldGangs`()
230BEGIN
231 DELETE FROM `gangs` WHERE `active` = 0;
232END ;;
233DELIMITER ;
234/*!50003 SET sql_mode = @saved_sql_mode */ ;
235/*!50003 SET character_set_client = @saved_cs_client */ ;
236/*!50003 SET character_set_results = @saved_cs_results */ ;
237/*!50003 SET collation_connection = @saved_col_connection */ ;
238/*!50003 DROP PROCEDURE IF EXISTS `deleteOldHouses` */;
239/*!50003 SET @saved_cs_client = @@character_set_client */ ;
240/*!50003 SET @saved_cs_results = @@character_set_results */ ;
241/*!50003 SET @saved_col_connection = @@collation_connection */ ;
242/*!50003 SET character_set_client = utf8mb4 */ ;
243/*!50003 SET character_set_results = utf8mb4 */ ;
244/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
245/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
246/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ;
247DELIMITER ;;
248CREATE DEFINER=`life`@`localhost` PROCEDURE `deleteOldHouses`()
249BEGIN
250 DELETE FROM `houses` WHERE `owned` = 0;
251END ;;
252DELIMITER ;
253/*!50003 SET sql_mode = @saved_sql_mode */ ;
254/*!50003 SET character_set_client = @saved_cs_client */ ;
255/*!50003 SET character_set_results = @saved_cs_results */ ;
256/*!50003 SET collation_connection = @saved_col_connection */ ;
257/*!50003 DROP PROCEDURE IF EXISTS `resetLifeVehicles` */;
258/*!50003 SET @saved_cs_client = @@character_set_client */ ;
259/*!50003 SET @saved_cs_results = @@character_set_results */ ;
260/*!50003 SET @saved_col_connection = @@collation_connection */ ;
261/*!50003 SET character_set_client = utf8mb4 */ ;
262/*!50003 SET character_set_results = utf8mb4 */ ;
263/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
264/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
265/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ;
266DELIMITER ;;
267CREATE DEFINER=`life`@`localhost` PROCEDURE `resetLifeVehicles`()
268BEGIN
269 UPDATE `vehicles` SET `active`= 0;
270END ;;
271DELIMITER ;
272/*!50003 SET sql_mode = @saved_sql_mode */ ;
273/*!50003 SET character_set_client = @saved_cs_client */ ;
274/*!50003 SET character_set_results = @saved_cs_results */ ;
275/*!50003 SET collation_connection = @saved_col_connection */ ;
276/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
277
278/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
279/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
280/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
281/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
282/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
283/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
284/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
285
286-- Dump completed on 2017-04-18 21:36:20