· 6 years ago · Sep 10, 2019, 05:20 PM
1-- --------------------------------------------------------
2-- Hôte : 127.0.0.1
3-- Version du serveur: 10.4.6-MariaDB - mariadb.org binary distribution
4-- SE du serveur: Win64
5-- HeidiSQL Version: 10.2.0.5599
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Listage de la structure de la base pour altislife
16DROP DATABASE IF EXISTS `altislife`;
17CREATE DATABASE IF NOT EXISTS `altislife` /*!40100 DEFAULT CHARACTER SET latin1 */;
18USE `altislife`;
19
20-- Listage de la structure de la table altislife. advanced_identity
21DROP TABLE IF EXISTS `advanced_identity`;
22CREATE TABLE IF NOT EXISTS `advanced_identity` (
23 `pid` varchar(64) NOT NULL,
24 `name_player` varchar(32) NOT NULL,
25 `nom` varchar(32) NOT NULL,
26 `prenom` varchar(32) NOT NULL,
27 `naissance` text NOT NULL,
28 `lieu_naissance` text NOT NULL,
29 `taille` int(10) NOT NULL,
30 `sexe` int(1) NOT NULL
31) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
32
33-- Les données exportées n'étaient pas sélectionnées.
34
35-- Listage de la structure de la table altislife. containers
36DROP TABLE IF EXISTS `containers`;
37CREATE TABLE IF NOT EXISTS `containers` (
38 `id` int(6) NOT NULL AUTO_INCREMENT,
39 `pid` varchar(17) NOT NULL,
40 `classname` varchar(32) NOT NULL,
41 `pos` varchar(64) DEFAULT NULL,
42 `inventory` text NOT NULL,
43 `gear` text NOT NULL,
44 `dir` varchar(128) DEFAULT NULL,
45 `active` tinyint(1) NOT NULL DEFAULT 0,
46 `owned` tinyint(1) DEFAULT 0,
47 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
48 PRIMARY KEY (`id`,`pid`)
49) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
50
51-- Les données exportées n'étaient pas sélectionnées.
52
53-- Listage de la structure de la procédure altislife. deleteDeadVehicles
54DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
55DELIMITER //
56CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
57BEGIN
58 DELETE FROM `vehicles` WHERE `alive` = 0;
59END//
60DELIMITER ;
61
62-- Listage de la structure de la procédure altislife. deleteOldContainers
63DROP PROCEDURE IF EXISTS `deleteOldContainers`;
64DELIMITER //
65CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers`()
66BEGIN
67 DELETE FROM `containers` WHERE `owned` = 0;
68END//
69DELIMITER ;
70
71-- Listage de la structure de la procédure altislife. deleteOldGangs
72DROP PROCEDURE IF EXISTS `deleteOldGangs`;
73DELIMITER //
74CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
75BEGIN
76 DELETE FROM `gangs` WHERE `active` = 0;
77END//
78DELIMITER ;
79
80-- Listage de la structure de la procédure altislife. deleteOldHouses
81DROP PROCEDURE IF EXISTS `deleteOldHouses`;
82DELIMITER //
83CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
84BEGIN
85 DELETE FROM `houses` WHERE `owned` = 0;
86END//
87DELIMITER ;
88
89-- Listage de la structure de la procédure altislife. deleteOldWanted
90DROP PROCEDURE IF EXISTS `deleteOldWanted`;
91DELIMITER //
92CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldWanted`()
93BEGIN
94 DELETE FROM `wanted` WHERE `active` = 0;
95END//
96DELIMITER ;
97
98-- Listage de la structure de la table altislife. gangs
99DROP TABLE IF EXISTS `gangs`;
100CREATE TABLE IF NOT EXISTS `gangs` (
101 `id` int(6) NOT NULL AUTO_INCREMENT,
102 `owner` varchar(32) DEFAULT NULL,
103 `name` varchar(32) DEFAULT NULL,
104 `members` text DEFAULT NULL,
105 `maxmembers` int(3) DEFAULT 8,
106 `bank` int(100) DEFAULT 0,
107 `active` tinyint(1) DEFAULT 1,
108 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
109 PRIMARY KEY (`id`),
110 UNIQUE KEY `name_UNIQUE` (`name`)
111) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
112
113-- Les données exportées n'étaient pas sélectionnées.
114
115-- Listage de la structure de la table altislife. houses
116DROP TABLE IF EXISTS `houses`;
117CREATE TABLE IF NOT EXISTS `houses` (
118 `id` int(6) NOT NULL AUTO_INCREMENT,
119 `pid` varchar(17) NOT NULL,
120 `pos` varchar(64) DEFAULT NULL,
121 `owned` tinyint(1) DEFAULT 0,
122 `garage` tinyint(1) NOT NULL DEFAULT 0,
123 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
124 PRIMARY KEY (`id`,`pid`)
125) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
126
127-- Les données exportées n'étaient pas sélectionnées.
128
129-- Listage de la structure de la table altislife. interpol
130DROP TABLE IF EXISTS `interpol`;
131CREATE TABLE IF NOT EXISTS `interpol` (
132 `id` int(6) NOT NULL AUTO_INCREMENT,
133 `prenom` varchar(32) NOT NULL,
134 `nom` varchar(32) NOT NULL,
135 `naissance` text NOT NULL,
136 `adresse` text NOT NULL,
137 `ville` text NOT NULL,
138 `numero` varchar(32) NOT NULL DEFAULT '0',
139 `yeux` text NOT NULL,
140 `details` text NOT NULL,
141 `insert_time` text NOT NULL,
142 PRIMARY KEY (`id`)
143) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
144
145-- Les données exportées n'étaient pas sélectionnées.
146
147-- Listage de la structure de la table altislife. interpol_crimes
148DROP TABLE IF EXISTS `interpol_crimes`;
149CREATE TABLE IF NOT EXISTS `interpol_crimes` (
150 `id` int(6) NOT NULL AUTO_INCREMENT,
151 `interpol_id` int(6) NOT NULL,
152 `crime` varchar(64) NOT NULL,
153 `price` int(100) NOT NULL,
154 `payed` tinyint(1) NOT NULL DEFAULT 0,
155 `insert_time` text NOT NULL,
156 PRIMARY KEY (`id`)
157) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
158
159-- Les données exportées n'étaient pas sélectionnées.
160
161-- Listage de la structure de la table altislife. messages_history
162DROP TABLE IF EXISTS `messages_history`;
163CREATE TABLE IF NOT EXISTS `messages_history` (
164 `id` int(6) NOT NULL AUTO_INCREMENT,
165 `pid` varchar(64) NOT NULL,
166 `from_number` varchar(32) NOT NULL,
167 `message` text NOT NULL,
168 `insert_time` text NOT NULL,
169 PRIMARY KEY (`id`)
170) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
171
172-- Les données exportées n'étaient pas sélectionnées.
173
174-- Listage de la structure de la table altislife. permis
175DROP TABLE IF EXISTS `permis`;
176CREATE TABLE IF NOT EXISTS `permis` (
177 `id` int(8) NOT NULL AUTO_INCREMENT,
178 `pid` varchar(17) NOT NULL DEFAULT '0',
179 `permis_type` varchar(255) NOT NULL DEFAULT '0',
180 `reason` varchar(255) NOT NULL DEFAULT '0',
181 `insert_time` datetime NOT NULL DEFAULT current_timestamp(),
182 PRIMARY KEY (`id`)
183) ENGINE=InnoDB DEFAULT CHARSET=latin1;
184
185-- Les données exportées n'étaient pas sélectionnées.
186
187-- Listage de la structure de la table altislife. players
188DROP TABLE IF EXISTS `players`;
189CREATE TABLE IF NOT EXISTS `players` (
190 `uid` int(6) NOT NULL AUTO_INCREMENT,
191 `name` varchar(32) NOT NULL,
192 `aliases` text NOT NULL,
193 `pid` varchar(17) NOT NULL,
194 `cash` int(100) NOT NULL DEFAULT 0,
195 `bankacc` int(100) NOT NULL DEFAULT 0,
196 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
197 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
198 `civ_licenses` text NOT NULL,
199 `cop_licenses` text NOT NULL,
200 `med_licenses` text NOT NULL,
201 `civ_gear` text NOT NULL,
202 `cop_gear` text NOT NULL,
203 `med_gear` text NOT NULL,
204 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
205 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
206 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
207 `arrested` tinyint(1) NOT NULL DEFAULT 0,
208 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
209 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
210 `blacklist` tinyint(1) NOT NULL DEFAULT 0,
211 `civ_alive` tinyint(1) NOT NULL DEFAULT 0,
212 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
213 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
214 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
215 `last_seen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
216 `IsEMT` tinyint(1) NOT NULL DEFAULT 0,
217 `IsAdac` tinyint(1) NOT NULL DEFAULT 0,
218 `IsCop` tinyint(1) NOT NULL DEFAULT 0,
219 `points_data` text DEFAULT NULL,
220 `phone_number` varchar(10) NOT NULL DEFAULT '0',
221 `contact_list` text DEFAULT NULL,
222 `sms_value` int(10) NOT NULL DEFAULT 0,
223 `call_value` int(10) NOT NULL DEFAULT 0,
224 PRIMARY KEY (`uid`),
225 UNIQUE KEY `pid` (`pid`),
226 KEY `name` (`name`),
227 KEY `blacklist` (`blacklist`)
228) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;
229
230-- Les données exportées n'étaient pas sélectionnées.
231
232-- Listage de la structure de la procédure altislife. resetLifeVehicles
233DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
234DELIMITER //
235CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
236BEGIN
237 UPDATE `vehicles` SET `active`= 0;
238END//
239DELIMITER ;
240
241-- Listage de la structure de la table altislife. vehicles
242DROP TABLE IF EXISTS `vehicles`;
243CREATE TABLE IF NOT EXISTS `vehicles` (
244 `id` int(6) NOT NULL AUTO_INCREMENT,
245 `side` varchar(16) NOT NULL,
246 `classname` varchar(64) NOT NULL,
247 `type` varchar(16) NOT NULL,
248 `pid` varchar(17) NOT NULL,
249 `alive` tinyint(1) NOT NULL DEFAULT 1,
250 `blacklist` tinyint(1) NOT NULL DEFAULT 0,
251 `active` tinyint(1) NOT NULL DEFAULT 0,
252 `plate` int(20) NOT NULL,
253 `color` int(20) NOT NULL,
254 `inventory` text NOT NULL,
255 `gear` text NOT NULL,
256 `fuel` double NOT NULL DEFAULT 1,
257 `damage` varchar(256) NOT NULL,
258 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
259 `fourriere` int(1) NOT NULL DEFAULT 0,
260 PRIMARY KEY (`id`),
261 KEY `side` (`side`),
262 KEY `pid` (`pid`),
263 KEY `type` (`type`)
264) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4;
265
266-- Les données exportées n'étaient pas sélectionnées.
267
268-- Listage de la structure de la table altislife. wanted
269DROP TABLE IF EXISTS `wanted`;
270CREATE TABLE IF NOT EXISTS `wanted` (
271 `wantedID` varchar(64) NOT NULL,
272 `wantedName` varchar(32) NOT NULL,
273 `wantedCrimes` text NOT NULL,
274 `wantedBounty` int(100) NOT NULL,
275 `active` tinyint(1) NOT NULL DEFAULT 0,
276 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
277 PRIMARY KEY (`wantedID`)
278) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
279
280-- Les données exportées n'étaient pas sélectionnées.
281
282/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
283/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
284/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;