· 9 years ago · Jan 26, 2017, 09:20 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Client : localhost
6-- Généré le : Jeu 26 Janvier 2017 à 22:19
7-- Version du serveur : 5.6.35
8-- Version de PHP : 5.6.29-0+deb8u1
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 utf8 */;
18
19--
20-- Base de données : `altislife`
21--
22
23DELIMITER $$
24--
25-- Procédures
26--
27CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()
28BEGIN
29 DELETE FROM `vehicles` WHERE `alive` = 0;
30END$$
31
32CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldContainers`()
33BEGIN
34 DELETE FROM `containers` WHERE `owned` = 0;
35END$$
36
37CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()
38BEGIN
39 DELETE FROM `gangs` WHERE `active` = 0;
40END$$
41
42CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()
43BEGIN
44 DELETE FROM `houses` WHERE `owned` = 0;
45END$$
46
47CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
48BEGIN
49 UPDATE `vehicles` SET `active`= 0;
50END$$
51
52DELIMITER ;
53
54-- --------------------------------------------------------
55
56--
57-- Structure de la 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 DEFAULT CHARSET=utf8mb4;
72
73-- --------------------------------------------------------
74
75--
76-- Structure de la 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-- Structure de la 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 DEFAULT CHARSET=utf8mb4;
103
104-- --------------------------------------------------------
105
106--
107-- Structure de la 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') NOT NULL DEFAULT '0',
118 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
119 `civ_licenses` text NOT NULL,
120 `cop_licenses` text NOT NULL,
121 `med_licenses` text NOT NULL,
122 `civ_gear` text NOT NULL,
123 `cop_gear` text NOT NULL,
124 `med_gear` text NOT NULL,
125 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
126 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
127 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
128 `arrested` tinyint(1) NOT NULL DEFAULT '0',
129 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
130 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
131 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
132 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
133 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
134 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
135 `insert_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
136 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
137) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
138
139-- --------------------------------------------------------
140
141--
142-- Structure de la table `vehicles`
143--
144
145CREATE TABLE IF NOT EXISTS `vehicles` (
146`id` int(12) NOT NULL,
147 `side` varchar(16) NOT NULL,
148 `classname` varchar(64) NOT NULL,
149 `type` varchar(16) NOT NULL,
150 `pid` varchar(32) NOT NULL,
151 `alive` tinyint(1) NOT NULL DEFAULT '1',
152 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
153 `active` tinyint(1) NOT NULL DEFAULT '0',
154 `plate` int(20) NOT NULL,
155 `color` int(20) NOT NULL,
156 `inventory` text NOT NULL,
157 `gear` text NOT NULL,
158 `fuel` double NOT NULL DEFAULT '1',
159 `damage` varchar(256) NOT NULL,
160 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
161) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
162
163-- --------------------------------------------------------
164
165--
166-- Structure de la table `wanted`
167--
168
169CREATE TABLE IF NOT EXISTS `wanted` (
170 `wantedID` varchar(64) NOT NULL,
171 `wantedName` varchar(32) NOT NULL,
172 `wantedCrimes` text NOT NULL,
173 `wantedBounty` int(100) NOT NULL,
174 `active` tinyint(1) NOT NULL DEFAULT '0',
175 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
176) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
177
178--
179-- Index pour les tables exportées
180--
181
182--
183-- Index pour la table `containers`
184--
185ALTER TABLE `containers`
186 ADD PRIMARY KEY (`id`,`pid`);
187
188--
189-- Index pour la table `gangs`
190--
191ALTER TABLE `gangs`
192 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`);
193
194--
195-- Index pour la table `houses`
196--
197ALTER TABLE `houses`
198 ADD PRIMARY KEY (`id`,`pid`);
199
200--
201-- Index pour la table `players`
202--
203ALTER TABLE `players`
204 ADD PRIMARY KEY (`uid`), ADD UNIQUE KEY `playerid` (`playerid`), ADD KEY `name` (`name`), ADD KEY `blacklist` (`blacklist`);
205
206--
207-- Index pour la table `vehicles`
208--
209ALTER TABLE `vehicles`
210 ADD PRIMARY KEY (`id`), ADD KEY `side` (`side`), ADD KEY `pid` (`pid`), ADD KEY `type` (`type`);
211
212--
213-- Index pour la table `wanted`
214--
215ALTER TABLE `wanted`
216 ADD PRIMARY KEY (`wantedID`);
217
218--
219-- AUTO_INCREMENT pour les tables exportées
220--
221
222--
223-- AUTO_INCREMENT pour la table `containers`
224--
225ALTER TABLE `containers`
226MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
227--
228-- AUTO_INCREMENT pour la table `gangs`
229--
230ALTER TABLE `gangs`
231MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
232--
233-- AUTO_INCREMENT pour la table `houses`
234--
235ALTER TABLE `houses`
236MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
237--
238-- AUTO_INCREMENT pour la table `players`
239--
240ALTER TABLE `players`
241MODIFY `uid` int(12) NOT NULL AUTO_INCREMENT;
242--
243-- AUTO_INCREMENT pour la table `vehicles`
244--
245ALTER TABLE `vehicles`
246MODIFY `id` int(12) NOT NULL AUTO_INCREMENT;
247/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
248/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
249/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;