· 9 years ago · Jan 28, 2017, 06:12 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.12
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jan 28, 2017 at 10:10 AM
7-- Server version: 5.6.34
8-- PHP Version: 5.6.26-pl0-gentoo
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `brehler1234567_PHPADMINACCES`
21--
22
23DELIMITER $$
24--
25-- Procedures
26--
27CREATE DEFINER=`brehler1234567`@`localhost` PROCEDURE `deleteDeadVehicles`()
28BEGIN
29 DELETE FROM `vehicles` WHERE `alive` = 0;
30END$$
31
32CREATE DEFINER=`brehler1234567`@`localhost` PROCEDURE `deleteOldContainers`()
33BEGIN
34 DELETE FROM `containers` WHERE `owned` = 0;
35END$$
36
37CREATE DEFINER=`brehler1234567`@`localhost` PROCEDURE `deleteOldGangs`()
38BEGIN
39 DELETE FROM `gangs` WHERE `active` = 0;
40END$$
41
42CREATE DEFINER=`brehler1234567`@`localhost` PROCEDURE `deleteOldHouses`()
43BEGIN
44 DELETE FROM `houses` WHERE `owned` = 0;
45END$$
46
47CREATE DEFINER=`brehler1234567`@`localhost` PROCEDURE `resetLifeVehicles`()
48BEGIN
49 UPDATE `vehicles` SET `active`= 0;
50END$$
51
52DELIMITER ;
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `containers`
58--
59
60CREATE TABLE IF NOT EXISTS `containers` (
61 `id` int(11) NOT NULL,
62 `pid` varchar(32) NOT NULL,
63 `classname` varchar(32) NOT NULL,
64 `pos` varchar(64) DEFAULT NULL,
65 `inventory` text NOT NULL,
66 `gear` text NOT NULL,
67 `dir` varchar(128) DEFAULT NULL,
68 `active` tinyint(1) NOT NULL DEFAULT '0',
69 `owned` tinyint(1) DEFAULT '0',
70 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
71) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `gangs`
77--
78
79CREATE TABLE IF NOT EXISTS `gangs` (
80 `id` int(11) NOT NULL,
81 `owner` varchar(32) DEFAULT NULL,
82 `name` varchar(32) DEFAULT NULL,
83 `members` text,
84 `maxmembers` int(3) DEFAULT '8',
85 `bank` int(100) DEFAULT '0',
86 `active` tinyint(1) DEFAULT '1',
87 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
88) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
89
90-- --------------------------------------------------------
91
92--
93-- Table structure for table `houses`
94--
95
96CREATE TABLE IF NOT EXISTS `houses` (
97 `id` int(11) NOT NULL,
98 `pid` varchar(32) NOT NULL,
99 `pos` varchar(64) DEFAULT NULL,
100 `owned` tinyint(1) DEFAULT '0',
101 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
102) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
103
104-- --------------------------------------------------------
105
106--
107-- Table structure for table `players`
108--
109
110CREATE TABLE IF NOT EXISTS `players` (
111 `uid` int(12) NOT NULL,
112 `name` varchar(32) NOT NULL,
113 `aliases` text NOT NULL,
114 `playerid` varchar(64) NOT NULL,
115 `cash` int(100) NOT NULL DEFAULT '0',
116 `bankacc` int(100) NOT NULL DEFAULT '0',
117 `coplevel` enum('0','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT '0',
118 `swatlevel` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
119 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
120 `civ_licenses` text NOT NULL,
121 `cop_licenses` text NOT NULL,
122 `med_licenses` text NOT NULL,
123 `civ_gear` text NOT NULL,
124 `cop_gear` text NOT NULL,
125 `med_gear` text NOT NULL,
126 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
127 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
128 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
129 `arrested` tinyint(1) NOT NULL DEFAULT '0',
130 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
131 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
132 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
133 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
134 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
135 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
136 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
137 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
138) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
139
140-- --------------------------------------------------------
141
142--
143-- Table structure for table `vehicles`
144--
145
146CREATE TABLE IF NOT EXISTS `vehicles` (
147 `id` int(12) NOT NULL,
148 `side` varchar(16) NOT NULL,
149 `classname` varchar(64) NOT NULL,
150 `type` varchar(16) NOT NULL,
151 `pid` varchar(32) NOT NULL,
152 `alive` tinyint(1) NOT NULL DEFAULT '1',
153 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
154 `active` tinyint(1) NOT NULL DEFAULT '0',
155 `plate` int(20) NOT NULL,
156 `color` int(20) NOT NULL,
157 `inventory` text NOT NULL,
158 `gear` text NOT NULL,
159 `fuel` double NOT NULL DEFAULT '1',
160 `damage` varchar(256) NOT NULL,
161 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
162) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
163
164-- --------------------------------------------------------
165
166--
167-- Table structure for table `wanted`
168--
169
170CREATE TABLE IF NOT EXISTS `wanted` (
171 `wantedID` varchar(64) NOT NULL,
172 `wantedName` varchar(32) NOT NULL,
173 `wantedCrimes` text NOT NULL,
174 `wantedBounty` int(100) NOT NULL,
175 `active` tinyint(1) NOT NULL DEFAULT '0',
176 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
177) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
178
179--
180-- Indexes for dumped tables
181--
182
183--
184-- Indexes for table `containers`
185--
186ALTER TABLE `containers`
187 ADD PRIMARY KEY (`id`,`pid`);
188
189--
190-- Indexes for table `gangs`
191--
192ALTER TABLE `gangs`
193 ADD PRIMARY KEY (`id`),
194 ADD UNIQUE KEY `name_UNIQUE` (`name`);
195
196--
197-- Indexes for table `houses`
198--
199ALTER TABLE `houses`
200 ADD PRIMARY KEY (`id`,`pid`);
201
202--
203-- Indexes for table `players`
204--
205ALTER TABLE `players`
206 ADD PRIMARY KEY (`uid`),
207 ADD UNIQUE KEY `playerid` (`playerid`),
208 ADD KEY `name` (`name`),
209 ADD KEY `blacklist` (`blacklist`);
210
211--
212-- Indexes for table `vehicles`
213--
214ALTER TABLE `vehicles`
215 ADD PRIMARY KEY (`id`),
216 ADD KEY `side` (`side`),
217 ADD KEY `pid` (`pid`),
218 ADD KEY `type` (`type`);
219
220--
221-- Indexes for table `wanted`
222--
223ALTER TABLE `wanted`
224 ADD PRIMARY KEY (`wantedID`);
225
226--
227-- AUTO_INCREMENT for dumped tables
228--
229
230--
231-- AUTO_INCREMENT for table `containers`
232--
233ALTER TABLE `containers`
234 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
235--
236-- AUTO_INCREMENT for table `gangs`
237--
238ALTER TABLE `gangs`
239 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
240--
241-- AUTO_INCREMENT for table `houses`
242--
243ALTER TABLE `houses`
244 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
245--
246-- AUTO_INCREMENT for table `players`
247--
248ALTER TABLE `players`
249 MODIFY `uid` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
250--
251-- AUTO_INCREMENT for table `vehicles`
252--
253ALTER TABLE `vehicles`
254 MODIFY `id` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
255/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
256/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
257/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;