· 7 years ago · Feb 27, 2019, 04:50 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Erstellungszeit: 23. Mai 2018 um 22:35
7-- Server-Version: 10.1.31-MariaDB
8-- PHP-Version: 7.0.28
9
10CREATE DATABASE IF NOT EXISTS `life` /*!40100 DEFAULT CHARACTER SET utf8 */;
11USE `life`;
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET NAMES utf8mb4 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17
18--
19-- Datenbank: `life`
20--
21
22DELIMITER $$
23--
24-- Prozeduren
25--
26CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles` () BEGIN
27 DELETE FROM `vehicles` WHERE `alive` = 0;
28END$$
29
30CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers` () BEGIN
31 DELETE FROM `containers` WHERE `owned` = 0;
32END$$
33
34CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs` () BEGIN
35 DELETE FROM `gangs` WHERE `active` = 0;
36END$$
37
38CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses` () BEGIN
39 DELETE FROM `houses` WHERE `owned` = 0;
40END$$
41
42CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles` () BEGIN
43 UPDATE `vehicles` SET `active`= 0;
44END$$
45
46DELIMITER ;
47
48-- --------------------------------------------------------
49
50--
51-- Tabellenstruktur für Tabelle `cellphone`
52--
53
54CREATE TABLE `cellphone` (
55 `pid` varchar(64) NOT NULL,
56 `playerName` varchar(32) NOT NULL,
57 `messages` text NOT NULL,
58 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60
61-- --------------------------------------------------------
62
63--
64-- Tabellenstruktur für Tabelle `containers`
65--
66
67CREATE TABLE `containers` (
68 `id` int(11) NOT NULL,
69 `pid` varchar(32) NOT NULL,
70 `classname` varchar(32) NOT NULL,
71 `pos` varchar(64) DEFAULT NULL,
72 `inventory` text NOT NULL,
73 `gear` text NOT NULL,
74 `dir` varchar(128) DEFAULT NULL,
75 `active` tinyint(1) NOT NULL DEFAULT '0',
76 `owned` tinyint(1) DEFAULT '0',
77 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
78) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
79
80--
81-- Daten für Tabelle `containers`
82--
83
84INSERT INTO `containers` (`id`, `pid`, `classname`, `pos`, `inventory`, `gear`, `dir`, `active`, `owned`, `insert_time`) VALUES
85(4, '76561198265216281', 'B_supplyCrate_F', '[3920.5,4915.36,1.12288]', '\"[[],0]\"', '\"[[[``optic_Hamr``],[2]],[[``RH_15Rnd_9x19_M9``],[17]],[[``RH_m9``,``arifle_AK12_F``,``CUP_arifle_Sa58RIS2_camo``],[1,1,1]],[[],[]]]\"', '[[-0.878235,-0.47823,0],[0,0,1]]', 0, 1, '2018-05-19 19:28:08'),
86(5, '76561198211877125', 'B_supplyCrate_F', '[5768.5,2882.31,1.83022]', '\"[[],0]\"', '\"[[[],[]],[[],[]],[[],[]],[[],[]]]\"', '[[0.983948,-0.17754,-0.0180664],[-0.00419162,-0.124201,0.992248]]', 0, 1, '2018-05-23 13:38:26'),
87(6, '76561198142605883', 'Box_IND_Grenades_F', '[2170.28,3271.06,5.39369]', '\"[[],0]\"', '\"[[[],[]],[[``RH_30Rnd_68x43_FMJ``],[18]],[[``RH_m16a6_des``],[1]],[[],[]]]\"', '[[0.999939,-0.0110485,0],[0,0,1]]', 0, 1, '2018-05-23 14:41:07'),
88(13, '76561198161530692', 'B_supplyCrate_F', '[5768.36,3081.27,0.585339]', '\"[[],0]\"', '\"[]\"', '[[-0.0739746,-0.997134,0.0158691],[-0.0368171,0.0186326,0.999148]]', 0, 1, '2018-05-23 18:15:45'),
89(14, '76561198161530692', 'B_supplyCrate_F', '[5768.77,3087.31,1.00358]', '\"[[],0]\"', '\"[]\"', '[[0.0568237,0.998384,0],[0,0,1]]', 0, 1, '2018-05-23 18:17:07');
90
91-- --------------------------------------------------------
92
93--
94-- Tabellenstruktur für Tabelle `gangs`
95--
96
97CREATE TABLE `gangs` (
98 `id` int(11) NOT NULL,
99 `owner` varchar(32) DEFAULT NULL,
100 `name` varchar(32) DEFAULT NULL,
101 `members` text,
102 `maxmembers` int(3) DEFAULT '8',
103 `bank` int(100) DEFAULT '0',
104 `active` tinyint(1) DEFAULT '1',
105 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
106) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
107
108-- --------------------------------------------------------
109
110--
111-- Tabellenstruktur für Tabelle `houses`
112--
113
114CREATE TABLE `houses` (
115 `id` int(11) NOT NULL,
116 `pid` varchar(32) NOT NULL,
117 `pos` varchar(64) DEFAULT NULL,
118 `owned` tinyint(1) DEFAULT '0',
119 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
120) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
121
122--
123-- Daten für Tabelle `houses`
124--
125
126INSERT INTO `houses` (`id`, `pid`, `pos`, `owned`, `insert_time`) VALUES
127
128-- --------------------------------------------------------
129
130--
131-- Tabellenstruktur für Tabelle `players`
132--
133
134CREATE TABLE `players` (
135 `uid` int(12) NOT NULL,
136 `name` varchar(32) NOT NULL,
137 `aliases` text NOT NULL,
138 `playerid` varchar(64) NOT NULL,
139 `cash` int(100) NOT NULL DEFAULT '0',
140 `bankacc` int(100) NOT NULL DEFAULT '0',
141 `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16') NOT NULL DEFAULT '0',
142 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
143 `civ_licenses` text NOT NULL,
144 `cop_licenses` text NOT NULL,
145 `med_licenses` text NOT NULL,
146 `civ_gear` text NOT NULL,
147 `cop_gear` text NOT NULL,
148 `med_gear` text NOT NULL,
149 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
150 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
151 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
152 `arrested` tinyint(1) NOT NULL DEFAULT '0',
153 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
154 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
155 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
156 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
157 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
158 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
159 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
160 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
161 `jail_time` int(11) NOT NULL DEFAULT '0'
162) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
163
164--
165-- Daten für Tabelle `players`
166--
167
168INSERT INTO `players` (`uid`, `name`, `aliases`, `playerid`, `cash`, `bankacc`, `coplevel`, `mediclevel`, `civ_licenses`, `cop_licenses`, `med_licenses`, `civ_gear`, `cop_gear`, `med_gear`, `civ_stats`, `cop_stats`, `med_stats`, `arrested`, `adminlevel`, `donorlevel`, `blacklist`, `civ_alive`, `civ_position`, `playtime`, `insert_time`, `last_seen`, `jail_time`) VALUES
169
170-- --------------------------------------------------------
171
172--
173-- Tabellenstruktur für Tabelle `vehicles`
174--
175
176CREATE TABLE `vehicles` (
177 `id` int(12) NOT NULL,
178 `side` varchar(16) NOT NULL,
179 `classname` varchar(64) NOT NULL,
180 `type` varchar(16) NOT NULL,
181 `pid` varchar(32) NOT NULL,
182 `alive` tinyint(1) NOT NULL DEFAULT '1',
183 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
184 `active` tinyint(1) NOT NULL DEFAULT '0',
185 `plate` int(20) NOT NULL,
186 `color` int(20) NOT NULL,
187 `inventory` text NOT NULL,
188 `gear` text NOT NULL,
189 `fuel` double NOT NULL DEFAULT '1',
190 `damage` varchar(256) NOT NULL,
191 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
192) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
193
194--
195-- Daten für Tabelle `vehicles`
196--
197
198INSERT INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `blacklist`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`, `damage`, `insert_time`) VALUES
199
200-- --------------------------------------------------------
201
202--
203-- Tabellenstruktur für Tabelle `wanted`
204--
205
206CREATE TABLE `wanted` (
207 `wantedID` varchar(64) NOT NULL,
208 `wantedName` varchar(32) NOT NULL,
209 `wantedCrimes` text NOT NULL,
210 `wantedBounty` int(100) NOT NULL,
211 `active` tinyint(1) NOT NULL DEFAULT '0',
212 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
213) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
214
215--
216-- Daten für Tabelle `wanted`
217--
218
219INSERT INTO `wanted` (`wantedID`, `wantedName`, `wantedCrimes`, `wantedBounty`, `active`, `insert_time`) VALUES
220
221-- --------------------------------------------------------
222
223--
224-- Indizes der exportierten Tabellen
225--
226
227--
228-- Indizes für die Tabelle `cellphone`
229--
230ALTER TABLE `cellphone`
231 ADD PRIMARY KEY (`pid`);
232
233--
234-- Indizes für die Tabelle `containers`
235--
236ALTER TABLE `containers`
237 ADD PRIMARY KEY (`id`,`pid`);
238
239--
240-- Indizes für die Tabelle `gangs`
241--
242ALTER TABLE `gangs`
243 ADD PRIMARY KEY (`id`),
244 ADD UNIQUE KEY `name_UNIQUE` (`name`);
245
246--
247-- Indizes für die Tabelle `houses`
248--
249ALTER TABLE `houses`
250 ADD PRIMARY KEY (`id`,`pid`);
251
252--
253-- Indizes für die Tabelle `players`
254--
255ALTER TABLE `players`
256 ADD PRIMARY KEY (`uid`),
257 ADD UNIQUE KEY `playerid` (`playerid`),
258 ADD KEY `name` (`name`),
259 ADD KEY `blacklist` (`blacklist`);
260
261--
262-- Indizes für die Tabelle `vehicles`
263--
264ALTER TABLE `vehicles`
265 ADD PRIMARY KEY (`id`),
266 ADD KEY `side` (`side`),
267 ADD KEY `pid` (`pid`),
268 ADD KEY `type` (`type`);
269
270--
271-- Indizes für die Tabelle `wanted`
272--
273ALTER TABLE `wanted`
274 ADD PRIMARY KEY (`wantedID`);
275
276--
277-- AUTO_INCREMENT für exportierte Tabellen
278--
279
280--
281-- AUTO_INCREMENT für Tabelle `containers`
282--
283ALTER TABLE `containers`
284 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
285
286--
287-- AUTO_INCREMENT für Tabelle `gangs`
288--
289ALTER TABLE `gangs`
290 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
291
292--
293-- AUTO_INCREMENT für Tabelle `houses`
294--
295ALTER TABLE `houses`
296 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
297
298--
299-- AUTO_INCREMENT für Tabelle `players`
300--
301ALTER TABLE `players`
302 MODIFY `uid` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
303
304--
305-- AUTO_INCREMENT für Tabelle `vehicles`
306--
307ALTER TABLE `vehicles`
308 MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=264;
309COMMIT;
310
311/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
312/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
313/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;