ueXn7Uaw

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