· 7 years ago · Feb 28, 2019, 10:52 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1ubuntu0.1
3-- http://www.phpmyadmin.net
4--
5-- Client: localhost
6-- Généré le: Jeu 28 Février 2019 à 22:44
7-- Version du serveur: 5.5.62-0ubuntu0.14.04.1
8-- Version de PHP: 5.5.9-1ubuntu4.26
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: `zilsrpfr0`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `lvrp_users`
27--
28
29CREATE TABLE IF NOT EXISTS `lvrp_users` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `Name` varchar(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
32 `Pass` varchar(150) CHARACTER SET utf8 NOT NULL,
33 `Level` smallint(5) NOT NULL DEFAULT '1',
34 `AdminLevel` smallint(5) NOT NULL DEFAULT '0',
35 `Age` int(11) NOT NULL DEFAULT '16',
36 `DonateRank` smallint(5) NOT NULL DEFAULT '0',
37 `VipTime` int(11) NOT NULL DEFAULT '0',
38 `ConnectedTime` int(11) NOT NULL DEFAULT '0',
39 `Registered` smallint(5) NOT NULL DEFAULT '0',
40 `Sex` smallint(5) NOT NULL DEFAULT '0',
41 `Origin` smallint(5) NOT NULL DEFAULT '0',
42 `City` int(5) NOT NULL DEFAULT '0',
43 `Respect` int(11) NOT NULL DEFAULT '1',
44 `Cash` int(11) NOT NULL DEFAULT '2000',
45 `Bank` int(11) NOT NULL DEFAULT '4000',
46 `Deaths` int(11) NOT NULL DEFAULT '0',
47 `Wanted` smallint(5) NOT NULL DEFAULT '0',
48 `LottoNr` int(11) NOT NULL DEFAULT '0',
49 `Fishes` int(11) NOT NULL DEFAULT '0',
50 `Job` smallint(5) NOT NULL DEFAULT '0',
51 `JobLvl` smallint(5) NOT NULL DEFAULT '0',
52 `JobExp` smallint(5) NOT NULL DEFAULT '0',
53 `JobTime` int(11) NOT NULL DEFAULT '0',
54 `JobBonnus` int(11) NOT NULL DEFAULT '0',
55 `Paycheck` int(11) NOT NULL DEFAULT '0',
56 `Jailed` smallint(5) NOT NULL DEFAULT '0',
57 `JailTime` int(11) NOT NULL DEFAULT '0',
58 `Leader` smallint(5) NOT NULL DEFAULT '0',
59 `Member` smallint(5) NOT NULL DEFAULT '0',
60 `Rank` smallint(5) NOT NULL DEFAULT '0',
61 `Skin` int(11) NOT NULL DEFAULT '299',
62 `Spawn` smallint(5) NOT NULL DEFAULT '0',
63 `Faim` smallint(5) NOT NULL DEFAULT '100',
64 `Soif` smallint(5) NOT NULL DEFAULT '100',
65 `Disease` smallint(5) NOT NULL DEFAULT '0',
66 `Interior` int(11) NOT NULL DEFAULT '0',
67 `PhoneNr` int(11) NOT NULL DEFAULT '0',
68 `Operator` smallint(5) NOT NULL DEFAULT '0',
69 `Formul` smallint(5) NOT NULL DEFAULT '0',
70 `PhoneTime` int(11) NOT NULL DEFAULT '0',
71 `Car1` int(11) NOT NULL DEFAULT '-1',
72 `Car2` int(11) NOT NULL DEFAULT '-1',
73 `Car3` int(11) NOT NULL DEFAULT '-1',
74 `Car4` int(11) NOT NULL DEFAULT '-1',
75 `Car5` int(11) NOT NULL DEFAULT '-1',
76 `Car6` int(11) NOT NULL DEFAULT '-1',
77 `CarUnLock4` smallint(5) NOT NULL DEFAULT '0',
78 `CarUnLock5` smallint(5) NOT NULL DEFAULT '0',
79 `CarUnLock6` smallint(5) NOT NULL DEFAULT '0',
80 `Bizz1` int(11) NOT NULL DEFAULT '-1',
81 `Bizz2` int(11) NOT NULL DEFAULT '-1',
82 `Bizz3` int(11) NOT NULL DEFAULT '-1',
83 `Garage1` int(11) NOT NULL DEFAULT '-1',
84 `Garage2` int(11) NOT NULL DEFAULT '-1',
85 `Garage3` int(11) NOT NULL DEFAULT '-1',
86 `House1` int(11) NOT NULL DEFAULT '-1',
87 `House2` int(11) NOT NULL DEFAULT '-1',
88 `House3` int(11) NOT NULL DEFAULT '-1',
89 `Pos_x` float(10,5) NOT NULL DEFAULT '0.00000',
90 `Pos_y` float(10,5) NOT NULL DEFAULT '0.00000',
91 `Pos_z` float(10,5) NOT NULL DEFAULT '0.00000',
92 `CarLic` smallint(5) NOT NULL DEFAULT '0',
93 `FlyLic` smallint(5) NOT NULL DEFAULT '0',
94 `BoatLic` smallint(5) NOT NULL DEFAULT '0',
95 `FishLic` smallint(5) NOT NULL DEFAULT '0',
96 `LourdLic` smallint(5) NOT NULL DEFAULT '0',
97 `MotoLic` smallint(5) NOT NULL DEFAULT '0',
98 `TrainLic` smallint(5) NOT NULL DEFAULT '0',
99 `GunLic` smallint(5) NOT NULL DEFAULT '0',
100 `Gun1` smallint(5) NOT NULL DEFAULT '0',
101 `Gun2` smallint(5) NOT NULL DEFAULT '0',
102 `Gun3` smallint(5) NOT NULL DEFAULT '0',
103 `Gun4` smallint(5) NOT NULL DEFAULT '0',
104 `Ammo1` smallint(5) NOT NULL DEFAULT '0',
105 `Ammo2` smallint(5) NOT NULL DEFAULT '0',
106 `Ammo3` smallint(5) NOT NULL DEFAULT '0',
107 `Ammo4` smallint(5) NOT NULL DEFAULT '0',
108 `PayDay` int(11) NOT NULL DEFAULT '0',
109 `PayDayHad` smallint(5) NOT NULL DEFAULT '0',
110 `Identie` smallint(5) NOT NULL DEFAULT '0',
111 `PointsRename` int(11) NOT NULL DEFAULT '0',
112 `ChangeNum` int(11) NOT NULL DEFAULT '0',
113 `Crashed` smallint(5) NOT NULL DEFAULT '0',
114 `PointPermis` int(11) NOT NULL DEFAULT '0',
115 `Warnings` int(11) NOT NULL DEFAULT '0',
116 `VirWorld` int(11) NOT NULL DEFAULT '0',
117 `Married` smallint(5) NOT NULL DEFAULT '0',
118 `MarriedTo` int(11) NOT NULL DEFAULT '-1',
119 `FishTool` smallint(5) NOT NULL DEFAULT '0',
120 `InvWeapon1` smallint(5) NOT NULL DEFAULT '0',
121 `InvWeapon2` smallint(5) NOT NULL DEFAULT '0',
122 `InvWeapon3` smallint(5) NOT NULL DEFAULT '0',
123 `InvWeapon4` smallint(5) NOT NULL DEFAULT '0',
124 `InvWeapon5` smallint(5) NOT NULL DEFAULT '0',
125 `InvWeapon6` smallint(5) NOT NULL DEFAULT '0',
126 `InvAmmo1` smallint(5) NOT NULL DEFAULT '0',
127 `InvAmmo2` smallint(5) NOT NULL DEFAULT '0',
128 `InvAmmo3` smallint(5) NOT NULL DEFAULT '0',
129 `InvAmmo4` smallint(5) NOT NULL DEFAULT '0',
130 `InvAmmo5` smallint(5) NOT NULL DEFAULT '0',
131 `InvAmmo6` smallint(5) NOT NULL DEFAULT '0',
132 `InvDev5` smallint(5) NOT NULL DEFAULT '0',
133 `InvDev6` smallint(5) NOT NULL DEFAULT '0',
134 `Mask` smallint(5) NOT NULL DEFAULT '0',
135 `Skill_Pistol` int(11) NOT NULL DEFAULT '0',
136 `Skill_Pistol_Silenced` int(11) NOT NULL DEFAULT '0',
137 `Skill_Shotgun` int(11) NOT NULL DEFAULT '0',
138 `Skill_Uzi` int(11) NOT NULL DEFAULT '0',
139 `Skill_Tec9` int(11) NOT NULL DEFAULT '0',
140 `Skill_Mp5` int(11) NOT NULL DEFAULT '0',
141 `Skill_Ak47` int(11) NOT NULL DEFAULT '0',
142 `Skill_M4` int(11) NOT NULL DEFAULT '0',
143 `Train_Wep_Time` int(11) NOT NULL DEFAULT '0',
144 `JerricainFuel` smallint(5) NOT NULL DEFAULT '0',
145 `Lang1` smallint(5) NOT NULL DEFAULT '0',
146 `Lang2` smallint(5) NOT NULL DEFAULT '0',
147 `LangState1` smallint(5) NOT NULL DEFAULT '10',
148 `LangState2` int(5) NOT NULL DEFAULT '0',
149 `LangTrainTime` smallint(5) NOT NULL DEFAULT '0',
150 `Work` smallint(5) NOT NULL DEFAULT '0',
151 `Mobi1` int(11) NOT NULL DEFAULT '0',
152 `Mobi2` int(11) NOT NULL DEFAULT '0',
153 `Mobi3` int(11) NOT NULL DEFAULT '0',
154 `Mobi4` int(11) NOT NULL DEFAULT '0',
155 `Mobi5` int(11) NOT NULL DEFAULT '0',
156 `CanRobTime` int(11) NOT NULL DEFAULT '0',
157 `CanRobTimeCar` int(11) NOT NULL DEFAULT '0',
158 `CanRobTimePocket` int(11) NOT NULL DEFAULT '0',
159 `CanRobTimeBizz` int(11) NOT NULL DEFAULT '0',
160 `CanRobTimeAtm` int(11) NOT NULL DEFAULT '0',
161 `CanRobTimeTrunk` int(11) NOT NULL DEFAULT '0',
162 `Locked` smallint(5) NOT NULL DEFAULT '0',
163 `Email` varchar(64) CHARACTER SET utf8 NOT NULL,
164 `CombatStyle` smallint(5) NOT NULL DEFAULT '5',
165 `Tokens` float(10,5) NOT NULL DEFAULT '0.00000',
166 `Ip` varchar(16) NOT NULL DEFAULT '0.0.0.0',
167 `LastLog` int(11) NOT NULL DEFAULT '0',
168 `Inscription` int(11) NOT NULL DEFAULT '0',
169 `Connected` smallint(5) NOT NULL DEFAULT '0',
170 `Bag` smallint(5) NOT NULL DEFAULT '1',
171 `DutyTime` int(11) NOT NULL DEFAULT '0',
172 `HasVoted1` int(11) NOT NULL DEFAULT '0',
173 `HasVoted2` int(11) NOT NULL DEFAULT '0',
174 `ChangePlaque` smallint(5) NOT NULL DEFAULT '0',
175 `Helper` smallint(5) NOT NULL DEFAULT '0',
176 `JobRemain` smallint(5) NOT NULL DEFAULT '0',
177 `HasCheck` smallint(5) NOT NULL DEFAULT '0',
178 `CheckNumber` smallint(5) NOT NULL DEFAULT '0',
179 `Votes` int(11) NOT NULL DEFAULT '0',
180 `ChangeAge` smallint(5) NOT NULL DEFAULT '0',
181 `ChangeSex` smallint(5) NOT NULL DEFAULT '0',
182 `statut_recup` smallint(5) NOT NULL DEFAULT '0',
183 `Dons` int(11) NOT NULL DEFAULT '0',
184 `InBizz` int(11) NOT NULL DEFAULT '-1',
185 `InSBizz` int(11) NOT NULL DEFAULT '-1',
186 `InGarage` int(11) NOT NULL DEFAULT '-1',
187 `InFaction` int(11) NOT NULL DEFAULT '-1',
188 `InInterior` int(11) NOT NULL DEFAULT '-1',
189 `InHouse` int(11) NOT NULL DEFAULT '-1',
190 `Animator` smallint(5) NOT NULL DEFAULT '0',
191 `TaxiLicense` smallint(5) NOT NULL DEFAULT '0',
192 `Cagnotte` int(11) NOT NULL DEFAULT '0',
193 `SkinCrash` tinyint(5) NOT NULL DEFAULT '0',
194 `DutyCrash` tinyint(5) NOT NULL DEFAULT '0',
195 `active` smallint(5) NOT NULL DEFAULT '0',
196 `dog` int(11) NOT NULL DEFAULT '0',
197 `rankjob` int(11) NOT NULL DEFAULT '0',
198 `note1` varchar(32) NOT NULL DEFAULT 'Aucun',
199 `note1s` int(11) NOT NULL DEFAULT '0',
200 `note2` varchar(32) NOT NULL DEFAULT 'Aucun',
201 `note2s` int(11) NOT NULL DEFAULT '0',
202 `note3` varchar(32) NOT NULL DEFAULT 'Aucun',
203 `note3s` int(11) NOT NULL DEFAULT '0',
204 `note4` varchar(32) NOT NULL DEFAULT 'Aucun',
205 `note4s` int(11) NOT NULL DEFAULT '0',
206 `note5` varchar(32) NOT NULL DEFAULT 'Aucun',
207 `note5s` int(11) NOT NULL DEFAULT '0',
208 `note6` varchar(32) NOT NULL DEFAULT 'Aucun',
209 `note6s` int(11) NOT NULL DEFAULT '0',
210 `note7` varchar(32) NOT NULL DEFAULT 'Aucun',
211 `note7s` int(11) NOT NULL DEFAULT '0',
212 `note8` varchar(32) NOT NULL DEFAULT 'Aucun',
213 `note8s` int(11) NOT NULL DEFAULT '0',
214 `note9` varchar(32) NOT NULL DEFAULT 'Aucun',
215 `note9s` int(11) NOT NULL DEFAULT '0',
216 `note10` varchar(32) NOT NULL DEFAULT 'Aucun',
217 `note10s` int(11) NOT NULL DEFAULT '0',
218 `Proprio1` int(11) NOT NULL DEFAULT '-1',
219 `Proprio2` int(11) NOT NULL DEFAULT '-1',
220 `Proprio3` int(11) NOT NULL DEFAULT '-1',
221 `SkinCrash1` int(11) NOT NULL DEFAULT '0',
222 `SkinCrash2` int(11) NOT NULL DEFAULT '0',
223 `SkinCrash3` int(11) NOT NULL DEFAULT '0',
224 `SkinCrash4` int(11) NOT NULL DEFAULT '0',
225 `Skin1` int(11) NOT NULL DEFAULT '0',
226 `Skin2` int(11) NOT NULL DEFAULT '0',
227 `Skin3` int(11) NOT NULL DEFAULT '0',
228 `Skin4` int(11) NOT NULL DEFAULT '0',
229 `Jetons` int(11) NOT NULL DEFAULT '0',
230 `Maladie` int(11) NOT NULL DEFAULT '0',
231 `Act1` int(11) NOT NULL DEFAULT '0',
232 `Act2` int(11) NOT NULL DEFAULT '0',
233 `Act3` int(11) NOT NULL DEFAULT '0',
234 `Act4` int(11) NOT NULL DEFAULT '0',
235 `Act5` int(11) NOT NULL DEFAULT '0',
236 PRIMARY KEY (`id`)
237) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
238
239/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
240/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
241/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;