· 9 years ago · Jan 08, 2017, 01:30 AM
1-- phpMyAdmin SQL Dump
2-- version 4.5.4.1deb2ubuntu2
3-- http://www.phpmyadmin.net
4--
5-- Client : localhost
6-- Généré le : Mar 20 Décembre 2016 à 17:38
7-- Version du serveur : 5.7.13-0ubuntu0.16.04.2
8-- Version de PHP : 7.0.8-0ubuntu0.16.04.3
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-- Base de données : `armalife_Test`
21--
22CREATE DATABASE IF NOT EXISTS `armalife_Test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `armalife_Test`;
24
25DELIMITER $$
26--
27-- Procédures
28--
29CREATE DEFINER=`test`@`localhost` PROCEDURE `deleteDeadVehicles` () BEGIN
30 DELETE FROM `vehicles` WHERE `alive` = 0;
31END$$
32
33CREATE DEFINER=`test`@`localhost` PROCEDURE `deleteOldContainers` () BEGIN
34 DELETE FROM `containers` WHERE `owned` = 0;
35END$$
36
37CREATE DEFINER=`test`@`localhost` PROCEDURE `deleteOldGangs` () BEGIN
38 DELETE FROM `gangs` WHERE `active` = 0;
39END$$
40
41CREATE DEFINER=`test`@`localhost` PROCEDURE `deleteOldHouses` () BEGIN
42 DELETE FROM `houses` WHERE `owned` = 0;
43END$$
44
45CREATE DEFINER=`test`@`localhost` PROCEDURE `resetLifeVehicles` () BEGIN
46 UPDATE `vehicles` SET `active`= 0;
47END$$
48
49DELIMITER ;
50
51-- --------------------------------------------------------
52
53--
54-- Structure de la table `containers`
55--
56
57CREATE TABLE `containers` (
58 `id` int(11) NOT NULL,
59 `pid` varchar(32) NOT NULL,
60 `classname` varchar(32) NOT NULL,
61 `pos` varchar(64) DEFAULT NULL,
62 `inventory` varchar(500) NOT NULL,
63 `gear` text NOT NULL,
64 `dir` varchar(64) DEFAULT NULL,
65 `active` tinyint(1) NOT NULL DEFAULT '0',
66 `owned` tinyint(4) DEFAULT '0'
67) ENGINE=InnoDB DEFAULT CHARSET=latin1;
68
69-- --------------------------------------------------------
70
71--
72-- Structure de la table `dynmarket`
73--
74
75CREATE TABLE `dynmarket` (
76 `id` int(11) NOT NULL DEFAULT '1',
77 `prices` text NOT NULL
78) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
79
80--
81-- Contenu de la table `dynmarket`
82--
83
84INSERT INTO `dynmarket` (`id`, `prices`) VALUES
85(1, '[["apple",63.8593,0],["peach",60,0],["tbacon",75.3305,0],["donuts",85,0],["rabbit_raw",65.2864,0],["ornate_raw",82.3613,0],["mackerel_raw",85.3745,0],["tuna_raw",70.3084,0],["mullet_raw",56.2467,0],["catshark_raw",60.2643,0],["turtle_soup",90,0],["hen_raw",72.3172,0],["rooster_raw",55.2423,0],["sheep_raw",63.2775,0],["goat_raw",60.2643,0],["redgull",150,0],["coffee",5,0],["waterBottle",10.044,0],["pickaxe",349.79,0],["fuelFull",500,0],["spikeStrip",1201.44,0],["lockpick",75,0],["goldbar",95000,0],["blastingcharge",35000,0],["boltcutter",7500,0],["defusekit",2500,0],["storagesmall",75000,0],["storagebig",15000,0],["oil_processed",1200,0],["copper_refined",1700,0],["iron_refined",1650,0],["salt_refined",1850,0],["glass",1450,0],["diamond_cut",1850,0],["cement",1250,0],["bois_t",1050,0],["couronne",2200,0],["Poudrediams",2215,0],["heroin_processed",5000,0],["marijuana",4900,0],["Methp",6250,0],["cocaine_processed",5300,0]]');
86
87-- --------------------------------------------------------
88
89--
90-- Structure de la table `gangs`
91--
92
93CREATE TABLE `gangs` (
94 `id` int(11) NOT NULL,
95 `owner` varchar(32) DEFAULT NULL,
96 `name` varchar(32) DEFAULT NULL,
97 `members` text,
98 `maxmembers` int(2) DEFAULT '8',
99 `bank` int(100) DEFAULT '0',
100 `active` tinyint(4) DEFAULT '1'
101) ENGINE=InnoDB DEFAULT CHARSET=latin1;
102
103--
104-- Contenu de la table `gangs`
105--
106
107INSERT INTO `gangs` (`id`, `owner`, `name`, `members`, `maxmembers`, `bank`, `active`) VALUES
108(1, '76561198083277485', 'freestyers', '"[`76561198083277485`]"', 8, 0, 1);
109
110-- --------------------------------------------------------
111
112--
113-- Structure de la table `houses`
114--
115
116CREATE TABLE `houses` (
117 `id` int(11) NOT NULL,
118 `pid` varchar(32) NOT NULL,
119 `pos` varchar(64) DEFAULT NULL,
120 `owned` tinyint(4) DEFAULT '0'
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122
123-- --------------------------------------------------------
124
125--
126-- Structure de la table `players`
127--
128
129CREATE TABLE `players` (
130 `uid` int(12) NOT NULL,
131 `name` varchar(32) NOT NULL,
132 `aliases` text NOT NULL,
133 `playerid` varchar(50) NOT NULL,
134 `cash` int(100) NOT NULL DEFAULT '0',
135 `bankacc` int(100) NOT NULL DEFAULT '0',
136 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
137 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
138 `civ_licenses` text NOT NULL,
139 `cop_licenses` text NOT NULL,
140 `med_licenses` text NOT NULL,
141 `civ_gear` text NOT NULL,
142 `cop_gear` text NOT NULL,
143 `med_gear` text NOT NULL,
144 `civ_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
145 `cop_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
146 `med_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
147 `arrested` tinyint(1) NOT NULL DEFAULT '0',
148 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
149 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
150 `blacklist` tinyint(1) NOT NULL DEFAULT '0'
151) ENGINE=InnoDB DEFAULT CHARSET=latin1;
152
153--
154-- Contenu de la table `players`
155--
156
157INSERT 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`, `donatorlvl`, `blacklist`) VALUES
158(9, 'Howkins Caudeur', '"[`Howkins Caudeur`]"', '76561198083277485', 1460, 18892, '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,1],[`license_civ_copper`,1],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_Lvl_1`,0],[`license_civ_Lvl_2`,0],[`license_civ_Lvl_3`,0],[`license_civ_Citoyen`,0],[`license_civ_Voyous`,1],[`license_civ_FerCuivre`,0],[`license_civ_snip`,0],[`license_civ_traficArme`,0],[`license_civ_Craft_Sac`,0],[`license_civ_Craft_Vet`,0],[`license_civ_Craft_Virt`,0],[`license_civ_Craft_Item`,0],[`license_civ_BAC`,0],[`license_civ_presse`,0],[`license_civ_chimi`,0],[`license_civ_SpAthira`,0],[`license_civ_SpSofia`,0],[`license_civ_SpPyrgos`,0],[`license_civ_Valid`,1],[`license_civ_meth`,0],[`license_civ_bandit`,0],[`license_civ_Freestylers`,0],[`license_civ_LPF`,0],[`license_civ_FAB`,0],[`license_civ_JAR`,0],[`license_civ_BD`,0],[`license_civ_LA`,0]]"', '"[]"', '"[]"', '"[`U_IG_Guerilla3_1`,``,`B_Kitbag_cbr`,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],`hgun_PDW2000_F`,``,[],[`30Rnd_9x21_Mag`],[`ToolKit`,`U_NikosAgedBody`],[`30Rnd_762x39_Mag_Tracer_F`,`30Rnd_9x21_Red_Mag`,`30Rnd_9x21_Red_Mag`,`30Rnd_9x21_Red_Mag`],[],[],[``,``,``,``],[``,``,``,``],[[`pickaxe`,1],[`fuelEmpty`,1],[`waterBottle`,1],[`peach`,3],[`tbacon`,2],[`textil_B`,5],[`textil_T`,6],[`textil_R`,1]]]"', '"[]"', '"[]"', '"[60,40]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
159(10, 'Pierre VigierMballa', '"[`Pierre VigierMballa`]"', '76561198287233431', 0, 5640, '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_Citoyen`,0],[`license_civ_Voyous`,1],[`license_civ_FerCuivre`,0],[`license_civ_snip`,0],[`license_civ_traficArme`,0],[`license_civ_Craft_Sac`,0],[`license_civ_Craft_Vet`,0],[`license_civ_Craft_Virt`,0],[`license_civ_Craft_Item`,0],[`license_civ_BAC`,0],[`license_civ_presse`,0],[`license_civ_chimi`,0],[`license_civ_SpAthira`,1],[`license_civ_SpSofia`,0],[`license_civ_SpPyrgos`,0],[`license_civ_Valid`,1],[`license_civ_meth`,0],[`license_civ_bandit`,0],[`license_civ_Freestylers`,0],[`license_civ_LPF`,0],[`license_civ_FAB`,0],[`license_civ_JAR`,0],[`license_civ_BD`,0],[`license_civ_LA`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_stripped`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`storageBig`,1]]]"', '"[]"', '"[]"', '"[60,90]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
160(11, 'Enzo Mech', '"[`Enzo Mech`]"', '76561198147809465', 0, 23538, '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_Lvl_1`,0],[`license_civ_Lvl_2`,0],[`license_civ_Lvl_3`,0],[`license_civ_Citoyen`,0],[`license_civ_Voyous`,1],[`license_civ_FerCuivre`,0],[`license_civ_snip`,0],[`license_civ_traficArme`,0],[`license_civ_Craft_Sac`,0],[`license_civ_Craft_Vet`,0],[`license_civ_Craft_Virt`,0],[`license_civ_Craft_Item`,0],[`license_civ_BAC`,0],[`license_civ_presse`,0],[`license_civ_chimi`,0],[`license_civ_SpAthira`,0],[`license_civ_SpSofia`,0],[`license_civ_SpPyrgos`,0],[`license_civ_Valid`,1],[`license_civ_meth`,0],[`license_civ_bandit`,0],[`license_civ_Freestylers`,0],[`license_civ_LPF`,0],[`license_civ_FAB`,0],[`license_civ_JAR`,0],[`license_civ_BD`,0],[`license_civ_LA`,0]]"', '"[]"', '"[]"', '"[`U_IG_Guerilla3_1`,``,`B_FieldPack_blk`,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[`U_C_Poloshirt_blue`],[],[],[],[``,``,``,``],[``,``,``,``],[[`waterBottle`,1],[`Chanvre_T`,9],[`Bamb_B`,15],[`textil_B`,26],[`chaise`,1]]]"', '"[]"', '"[]"', '"[60,50]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0);
161
162-- --------------------------------------------------------
163
164--
165-- Structure de la table `vehicles`
166--
167
168CREATE TABLE `vehicles` (
169 `id` int(12) NOT NULL,
170 `side` varchar(15) NOT NULL,
171 `classname` varchar(32) NOT NULL,
172 `type` varchar(12) NOT NULL,
173 `pid` varchar(32) NOT NULL,
174 `alive` tinyint(1) NOT NULL DEFAULT '1',
175 `active` tinyint(1) NOT NULL DEFAULT '0',
176 `plate` int(20) NOT NULL,
177 `color` int(20) NOT NULL,
178 `inventory` varchar(500) NOT NULL,
179 `gear` text NOT NULL,
180 `fuel` double NOT NULL DEFAULT '1'
181) ENGINE=InnoDB DEFAULT CHARSET=latin1;
182
183--
184-- Contenu de la table `vehicles`
185--
186
187INSERT INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`) VALUES
188(1, 'civ', 'O_Truck_03_ammo_F', 'Car', '76561198083277485', 1, 0, 196528, 0, '[[],0]', '[]', 0.984135),
189(2, 'civ', 'O_Truck_03_ammo_F', 'Car', '76561198045806126', 1, 0, 711242, 0, '"[[],0]"', '"[]"', 1),
190(4, 'civ', 'O_Truck_03_ammo_F', 'Car', '76561198083277485', 1, 0, 250773, 0, '[[],0]', '[]', 0.992152),
191(5, 'civ', 'B_Heli_Transport_03_unarmed_F', 'Air', '76561198083277485', 1, 0, 501244, 0, '[[],0]', '[]', 0.974381),
192(6, 'civ', 'C_SUV_01_F', 'Car', '76561198319236969', 1, 0, 412362, 1, '"[[],0]"', '"[]"', 1),
193(7, 'cop', 'C_Offroad_01_F', 'Car', '76561198083277485', 1, 0, 493374, 7, '[[],0]', '[]', 1),
194(8, 'civ', 'C_Offroad_01_F', 'Car', '76561198083277485', 1, 0, 923597, 5, '[[],0]', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', 0.971014),
195(9, 'civ', 'C_Offroad_01_F', 'Car', '76561198287233431', 1, 0, 336213, 4, '[[],0]', '[]', 1);
196
197-- --------------------------------------------------------
198
199--
200-- Structure de la table `wanted`
201--
202
203CREATE TABLE `wanted` (
204 `wantedID` varchar(50) NOT NULL,
205 `wantedName` varchar(52) NOT NULL,
206 `wantedCrimes` text NOT NULL,
207 `wantedBounty` int(100) NOT NULL,
208 `active` tinyint(1) NOT NULL DEFAULT '0'
209) ENGINE=InnoDB DEFAULT CHARSET=latin1;
210
211--
212-- Contenu de la table `wanted`
213--
214
215INSERT INTO `wanted` (`wantedID`, `wantedName`, `wantedCrimes`, `wantedBounty`, `active`) VALUES
216('76561198203354686', '[Admin] Rachid Laflame', '"[`187V`,`187`,`487`]"', 2800, 1),
217('76561198298688462', '[Colonel-P]Jean Michel ', '"[`187V`,`187V`,`187`,`187`,`187`,`187`]"', 9300, 1),
218('76561198319236969', 'stark delastrite', '"[`211`]"', 100, 1);
219
220--
221-- Index pour les tables exportées
222--
223
224--
225-- Index pour la table `containers`
226--
227ALTER TABLE `containers`
228 ADD PRIMARY KEY (`id`,`pid`);
229
230--
231-- Index pour la table `dynmarket`
232--
233ALTER TABLE `dynmarket`
234 ADD PRIMARY KEY (`id`);
235
236--
237-- Index pour la table `gangs`
238--
239ALTER TABLE `gangs`
240 ADD PRIMARY KEY (`id`),
241 ADD UNIQUE KEY `name_UNIQUE` (`name`);
242
243--
244-- Index pour la table `houses`
245--
246ALTER TABLE `houses`
247 ADD PRIMARY KEY (`id`,`pid`);
248
249--
250-- Index pour la table `players`
251--
252ALTER TABLE `players`
253 ADD PRIMARY KEY (`uid`),
254 ADD UNIQUE KEY `playerid` (`playerid`),
255 ADD KEY `name` (`name`),
256 ADD KEY `blacklist` (`blacklist`);
257
258--
259-- Index pour la table `vehicles`
260--
261ALTER TABLE `vehicles`
262 ADD PRIMARY KEY (`id`),
263 ADD KEY `side` (`side`),
264 ADD KEY `pid` (`pid`),
265 ADD KEY `type` (`type`);
266
267--
268-- Index pour la table `wanted`
269--
270ALTER TABLE `wanted`
271 ADD PRIMARY KEY (`wantedID`);
272
273--
274-- AUTO_INCREMENT pour les tables exportées
275--
276
277--
278-- AUTO_INCREMENT pour la table `containers`
279--
280ALTER TABLE `containers`
281 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
282--
283-- AUTO_INCREMENT pour la table `gangs`
284--
285ALTER TABLE `gangs`
286 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
287--
288-- AUTO_INCREMENT pour la table `houses`
289--
290ALTER TABLE `houses`
291 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
292--
293-- AUTO_INCREMENT pour la table `players`
294--
295ALTER TABLE `players`
296 MODIFY `uid` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
297--
298-- AUTO_INCREMENT pour la table `vehicles`
299--
300ALTER TABLE `vehicles`
301 MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
302/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
303/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
304/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;