· 10 years ago · Sep 27, 2016, 07:26 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.9
3-- http://www.phpmyadmin.net
4--
5-- Client : 127.0.0.1
6-- Généré le : Lun 27 Octobre 2014 à 19:41
7-- Version du serveur : 5.6.17
8-- Version de PHP : 5.5.12
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 : `roleplay_css`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `adm_site_rp`
27--
28
29CREATE TABLE IF NOT EXISTS `adm_site_rp` (
30`id` int(11) NOT NULL,
31 `username` varchar(32) NOT NULL,
32 `rank` int(1) NOT NULL
33) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
34
35--
36-- Contenu de la table `adm_site_rp`
37--
38
39INSERT INTO `adm_site_rp` (`id`, `username`, `rank`) VALUES
40(1, 'Kiwi06', 1),
41(2, 'Wana', 1),
42(3, 'Pounet', 1),
43(4, 'D3AD-ON3', 1);
44
45-- --------------------------------------------------------
46
47--
48-- Structure de la table `ban`
49--
50
51CREATE TABLE IF NOT EXISTS `ban` (
52`id` int(11) NOT NULL,
53 `steamip` varchar(64) NOT NULL DEFAULT 'inconnu',
54 `raison` varchar(256) NOT NULL,
55 `adminsteamid` varchar(64) NOT NULL DEFAULT 'inconnu',
56 `adminname` varchar(32) DEFAULT 'inconnu',
57 `bantimestamp` int(10) NOT NULL DEFAULT '0'
58) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
59
60--
61-- Contenu de la table `ban`
62--
63
64INSERT INTO `ban` (`id`, `steamip`, `raison`, `adminsteamid`, `adminname`, `bantimestamp`) VALUES
65(1, 'STEAM_0:1:24880709', 'Tu as assez volé comme ça ...', 'STEAM_1:0:26739102', 'Wana', 0),
66(2, 'STEAM_0:0:34532112', 'Les OCG ne sont pas le bienvenus.', 'STEAM_1:0:26739102', 'Wana', 0),
67(3, 'STEAM_0:0:24894729', 'Les OCG ne sont pas les bienvenus.', 'STEAM_1:0:26739102', 'Wana', 0),
68(4, 'STEAM_0:1:40008662', 'Les OCG ne sont pas les bienvenus.', 'STEAM_1:0:26739102', 'Wana', 0),
69(5, 'STEAM_0:0:39153814', 'Les OCG ne sont pas les bienvenus.', 'STEAM_1:0:26739102', 'Wana', 0),
70(6, 'STEAM_0:1:82934572', 'Les OCG ne sont pas les bienvenus.', 'STEAM_1:0:26739102', 'Wana', 0);
71
72-- --------------------------------------------------------
73
74--
75-- Structure de la table `item`
76--
77
78CREATE TABLE IF NOT EXISTS `item` (
79`id` int(11) NOT NULL,
80 `steamid` varchar(64) NOT NULL DEFAULT 'inconnu',
81 `name` varchar(32) NOT NULL DEFAULT 'inconnu',
82 `usp` int(100) NOT NULL DEFAULT '0',
83 `glock18` int(100) NOT NULL DEFAULT '0',
84 `deagle` int(100) NOT NULL DEFAULT '0',
85 `p228` int(100) NOT NULL DEFAULT '0',
86 `dualberettas` int(100) NOT NULL DEFAULT '0',
87 `fiveseven` int(100) NOT NULL DEFAULT '0',
88 `mp5` int(100) NOT NULL DEFAULT '0',
89 `tmp` int(100) NOT NULL DEFAULT '0',
90 `p90` int(100) NOT NULL DEFAULT '0',
91 `mac10` int(100) NOT NULL DEFAULT '0',
92 `ump45` int(100) NOT NULL DEFAULT '0',
93 `m3` int(100) NOT NULL DEFAULT '0',
94 `xm1014` int(100) NOT NULL DEFAULT '0',
95 `ak47` int(100) NOT NULL DEFAULT '0',
96 `sg552` int(100) NOT NULL DEFAULT '0',
97 `m4a1` int(100) NOT NULL DEFAULT '0',
98 `aug` int(100) NOT NULL DEFAULT '0',
99 `galilar` int(100) NOT NULL DEFAULT '0',
100 `famas` int(100) NOT NULL DEFAULT '0',
101 `scout` int(100) NOT NULL DEFAULT '0',
102 `awp` int(100) NOT NULL DEFAULT '0',
103 `g3sg1` int(100) NOT NULL DEFAULT '0',
104 `sg550` int(100) NOT NULL DEFAULT '0',
105 `m249` int(100) NOT NULL DEFAULT '0',
106 `munitions` int(100) NOT NULL DEFAULT '0',
107 `munitionsincendiaire` int(100) NOT NULL DEFAULT '0',
108 `munitionsperforante` int(100) NOT NULL DEFAULT '0',
109 `munitionscaoutchouc` int(100) NOT NULL DEFAULT '0',
110 `munitionsexplosive` int(100) NOT NULL DEFAULT '0',
111 `hegrenade` int(100) NOT NULL DEFAULT '0',
112 `gss` int(100) NOT NULL DEFAULT '0',
113 `smokegrenade` int(100) NOT NULL DEFAULT '0',
114 `c4` int(100) NOT NULL DEFAULT '0',
115 `kevlarleger` int(100) NOT NULL DEFAULT '0',
116 `kevlarlourd` int(100) NOT NULL DEFAULT '0',
117 `kevlarmilitaire` int(100) NOT NULL DEFAULT '0',
118 `troussesoin` int(100) NOT NULL DEFAULT '0',
119 `defibrillateur` int(100) NOT NULL DEFAULT '0',
120 `antiinfectieux` int(100) NOT NULL DEFAULT '0',
121 `joint` int(100) NOT NULL DEFAULT '0',
122 `shit` int(100) NOT NULL DEFAULT '0',
123 `meth` int(100) NOT NULL DEFAULT '0',
124 `heroine` int(100) NOT NULL DEFAULT '0',
125 `cocaine` int(100) NOT NULL DEFAULT '0',
126 `tgv` int(100) NOT NULL DEFAULT '0',
127 `sirop` int(100) NOT NULL DEFAULT '0',
128 `remede` int(100) NOT NULL DEFAULT '0',
129 `ticketgratter` int(100) NOT NULL DEFAULT '0',
130 `rapido` int(100) NOT NULL DEFAULT '0',
131 `loto` int(100) NOT NULL DEFAULT '0',
132 `imprimante` int(100) NOT NULL DEFAULT '0',
133 `crackdigicode` int(100) NOT NULL DEFAULT '0',
134 `ubercharge` int(100) NOT NULL DEFAULT '0',
135 `couteau` int(100) NOT NULL DEFAULT '0',
136 `ceintureexplosive` int(100) NOT NULL DEFAULT '0',
137 `sativex` int(100) NOT NULL DEFAULT '0',
138 `dragonne` int(100) NOT NULL DEFAULT '0',
139 `ceinture` int(100) NOT NULL DEFAULT '0',
140 `carteprepayee` int(100) NOT NULL DEFAULT '0',
141 `bidonfuel` int(100) NOT NULL DEFAULT '0',
142 `actionhopital` int(100) NOT NULL DEFAULT '0',
143 `actionammunation` int(100) NOT NULL DEFAULT '0',
144 `actionimmobilier` int(100) NOT NULL DEFAULT '0',
145 `actionnightclub` int(100) NOT NULL DEFAULT '0',
146 `actioncybercafe` int(100) NOT NULL DEFAULT '0',
147 `actionbankofamerica` int(100) NOT NULL DEFAULT '0',
148 `actioncontrebande` int(100) NOT NULL DEFAULT '0',
149 `actionburaliste` int(100) NOT NULL DEFAULT '0',
150 `actionroyalindustries` int(100) NOT NULL DEFAULT '0',
151 `encre` int(100) NOT NULL DEFAULT '0',
152 `lampetorche` int(100) NOT NULL DEFAULT '0',
153 `bombegraffiti` int(100) NOT NULL DEFAULT '0',
154 `countgraffiti` int(100) NOT NULL DEFAULT '0',
155 `propscanette` int(100) NOT NULL DEFAULT '0',
156 `propschaise` int(100) NOT NULL DEFAULT '0',
157 `propscanape` int(100) NOT NULL DEFAULT '0',
158 `propsbiblio` int(100) NOT NULL DEFAULT '0',
159 `propsbarriere` int(100) NOT NULL DEFAULT '0',
160 `propsplot` int(100) NOT NULL DEFAULT '0',
161 `propsarmoire` int(100) NOT NULL DEFAULT '0',
162 `propsdistributeur` int(100) NOT NULL DEFAULT '0',
163 `propsplante` int(100) NOT NULL DEFAULT '0',
164 `propspoutre` int(100) NOT NULL DEFAULT '0',
165 `propscloture` int(100) NOT NULL DEFAULT '0',
166 `propsglobe` int(100) NOT NULL DEFAULT '0',
167 `modelgraffiti1` int(100) NOT NULL DEFAULT '0',
168 `modelgraffiti2` int(100) NOT NULL DEFAULT '0',
169 `modelgraffiti3` int(100) NOT NULL DEFAULT '0',
170 `modelgraffiti4` int(100) NOT NULL DEFAULT '0',
171 `modelgraffiti5` int(100) NOT NULL DEFAULT '0',
172 `modelgraffiti6` int(100) NOT NULL DEFAULT '0',
173 `modelgraffiti7` int(100) NOT NULL DEFAULT '0',
174 `modelgraffiti8` int(100) NOT NULL DEFAULT '0',
175 `modelgraffiti9` int(100) NOT NULL DEFAULT '0',
176 `modelgraffiti10` int(100) NOT NULL DEFAULT '0'
177) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
178
179--
180-- Contenu de la table `item`
181--
182
183INSERT INTO `item` (`id`, `steamid`, `name`, `usp`, `glock18`, `deagle`, `p228`, `dualberettas`, `fiveseven`, `mp5`, `tmp`, `p90`, `mac10`, `ump45`, `m3`, `xm1014`, `ak47`, `sg552`, `m4a1`, `aug`, `galilar`, `famas`, `scout`, `awp`, `g3sg1`, `sg550`, `m249`, `munitions`, `munitionsincendiaire`, `munitionsperforante`, `munitionscaoutchouc`, `munitionsexplosive`, `hegrenade`, `gss`, `smokegrenade`, `c4`, `kevlarleger`, `kevlarlourd`, `kevlarmilitaire`, `troussesoin`, `defibrillateur`, `antiinfectieux`, `joint`, `shit`, `meth`, `heroine`, `cocaine`, `tgv`, `sirop`, `remede`, `ticketgratter`, `rapido`, `loto`, `imprimante`, `crackdigicode`, `ubercharge`, `couteau`, `ceintureexplosive`, `sativex`, `dragonne`, `ceinture`, `carteprepayee`, `bidonfuel`, `actionhopital`, `actionammunation`, `actionimmobilier`, `actionnightclub`, `actioncybercafe`, `actionbankofamerica`, `actioncontrebande`, `actionburaliste`, `actionroyalindustries`, `encre`, `lampetorche`, `bombegraffiti`, `countgraffiti`, `propscanette`, `propschaise`, `propscanape`, `propsbiblio`, `propsbarriere`, `propsplot`, `propsarmoire`, `propsdistributeur`, `propsplante`, `propspoutre`, `propscloture`, `propsglobe`, `modelgraffiti1`, `modelgraffiti2`, `modelgraffiti3`, `modelgraffiti4`, `modelgraffiti5`, `modelgraffiti6`, `modelgraffiti7`, `modelgraffiti8`, `modelgraffiti9`, `modelgraffiti10`) VALUES
184(1, 'STEAM_0:0:26739102', '.:[MGF]:. Wana', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 10100, 10100, 100, 100, 10100, 10100, 10100, 10100, 100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10100, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 100, 10, 10, 10, 10, 10, 10, 10, 10, 10, 100, 0, 5, 991, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 8, 9, 10, 10, 10, 9, 10, 9, 9, 9),
185(2, 'STEAM_0:0:41250573', '.:[MGF]:. Gros Tony', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
186
187-- --------------------------------------------------------
188
189--
190-- Structure de la table `job`
191--
192
193CREATE TABLE IF NOT EXISTS `job` (
194`id` int(11) NOT NULL,
195 `capital` int(100) NOT NULL DEFAULT '500000',
196 `previouscapital` int(100) NOT NULL DEFAULT '500000',
197 `previousbourse` float NOT NULL DEFAULT '0',
198 `note` varchar(4096) NOT NULL DEFAULT 'none'
199) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=latin1;
200
201--
202-- Contenu de la table `job`
203--
204
205INSERT INTO `job` (`id`, `capital`, `previouscapital`, `previousbourse`, `note`) VALUES
206(1, 465143, -1, -1, 'none'),
207(2, 493050, -1, -1, 'none'),
208(3, 493200, -1, -1, 'none'),
209(4, 493200, 500000, 0, 'none'),
210(5, 583343, -1, -1, 'none'),
211(6, 493200, 500000, 0, 'none'),
212(7, 493200, -1, -1, 'none'),
213(8, 493200, 500000, 0, 'none'),
214(9, 492950, 500000, 0, 'none'),
215(10, 493294, 500000, 0, 'none'),
216(11, 493150, 500000, 0, 'none'),
217(12, 493200, -1, -1, 'none'),
218(13, 493200, 500000, 0, 'none'),
219(14, 493150, 500000, 0, 'none'),
220(15, -1350, -1, -1, 'none'),
221(101, 1913480, 500000, 0, 'none');
222
223-- --------------------------------------------------------
224
225--
226-- Structure de la table `lotery`
227--
228
229CREATE TABLE IF NOT EXISTS `lotery` (
230`id` int(11) NOT NULL,
231 `lotery` int(100) NOT NULL DEFAULT '100000'
232) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
233
234--
235-- Contenu de la table `lotery`
236--
237
238INSERT INTO `lotery` (`id`, `lotery`) VALUES
239(1, 100000);
240
241-- --------------------------------------------------------
242
243--
244-- Structure de la table `player`
245--
246
247CREATE TABLE IF NOT EXISTS `player` (
248`id` int(11) NOT NULL,
249 `steamid` varchar(64) NOT NULL DEFAULT 'inconnu',
250 `firstip` varchar(64) NOT NULL DEFAULT '0.0.0.0',
251 `lastip` varchar(64) NOT NULL DEFAULT '0.0.0.0',
252 `name` varchar(64) NOT NULL DEFAULT 'inconnu',
253 `money` int(100) NOT NULL DEFAULT '0',
254 `bank` int(100) NOT NULL DEFAULT '5000',
255 `jobid` int(2) NOT NULL DEFAULT '0',
256 `gradeid` int(2) NOT NULL DEFAULT '0',
257 `gradeidspecial` int(1) NOT NULL DEFAULT '0',
258 `viptime` int(10) NOT NULL DEFAULT '0',
259 `timedeco` int(10) NOT NULL DEFAULT '0',
260 `timeingame` int(10) NOT NULL DEFAULT '0',
261 `birthday` int(10) NOT NULL DEFAULT '0',
262 `timejail` int(100) NOT NULL DEFAULT '0',
263 `levelcut` int(3) NOT NULL DEFAULT '0',
264 `permislourd` int(1) NOT NULL DEFAULT '0',
265 `permisleger` int(1) NOT NULL DEFAULT '0',
266 `cb` int(1) NOT NULL DEFAULT '0',
267 `rib` int(1) NOT NULL DEFAULT '0',
268 `fuel` int(3) NOT NULL DEFAULT '100',
269 `karma` int(3) NOT NULL DEFAULT '100',
270 `maladie` varchar(128) NOT NULL DEFAULT 'none',
271 `chirurgie` varchar(128) NOT NULL DEFAULT 'none',
272 `groupe` int(1) NOT NULL DEFAULT '0',
273 `appart` varchar(64) NOT NULL DEFAULT 'none',
274 `exp` int(3) NOT NULL DEFAULT '0',
275 `credit` int(100) NOT NULL DEFAULT '50',
276 `confiance` int(1) NOT NULL DEFAULT '0',
277 `casier` varchar(4096) NOT NULL DEFAULT 'none',
278 `ratio` varchar(64) NOT NULL DEFAULT '0:0',
279 `admin` int(1) NOT NULL DEFAULT '0',
280 `mute` int(1) NOT NULL DEFAULT '0',
281 `gag` int(1) NOT NULL DEFAULT '0',
282 `faim` int(4) NOT NULL DEFAULT '5000'
283) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
284
285--
286-- Contenu de la table `player`
287--
288
289INSERT INTO `player` (`id`, `steamid`, `firstip`, `lastip`, `name`, `money`, `bank`, `jobid`, `gradeid`, `gradeidspecial`, `viptime`, `timedeco`, `timeingame`, `birthday`, `timejail`, `levelcut`, `permislourd`, `permisleger`, `cb`, `rib`, `fuel`, `karma`, `maladie`, `chirurgie`, `groupe`, `appart`, `exp`, `credit`, `confiance`, `casier`, `ratio`, `admin`, `mute`, `gag`, `faim`) VALUES
290(1, 'STEAM_0:0:26739102', '192.168.1.10', '192.168.1.10', '.:[MGF]:. Wana', 1327, 507534, 9, 1, 0, -1, 1414373571, 33504, 1411393605, 0, 100, 1, 1, 1, 1, 71, 100, 'none', 'none', 1, 'none', 100, 49, 1, 'none', '21:35', 1, 0, 0, 3500),
291(2, 'STEAM_0:0:41250573', '82.125.145.227', '92.134.8.14', '.:[MGF]:. Gros Tony', 699, 503410, 1, 1, 1, -1, 1414373859, 8647, 1411835934, 0, 96, 1, 1, 1, 1, 57, 80, 'none', 'none', 0, 'none', 0, 46, 1, 'none', '20:9', 1, 0, 0, 4000);
292
293-- --------------------------------------------------------
294
295--
296-- Structure de la table `police`
297--
298
299CREATE TABLE IF NOT EXISTS `police` (
300`id` int(11) NOT NULL,
301 `motif` varchar(128) NOT NULL DEFAULT 'none',
302 `amende` int(100) NOT NULL DEFAULT '0',
303 `temps` int(100) NOT NULL DEFAULT '0'
304) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
305
306--
307-- Contenu de la table `police`
308--
309
310INSERT INTO `police` (`id`, `motif`, `amende`, `temps`) VALUES
311(1, 'meurtre', 600, 360),
312(2, 'agression', 300, 360),
313(3, 'vol', 300, 360),
314(4, 'intrusion', 200, 0),
315(5, 'refus', 200, 0),
316(6, 'permis', 200, 0),
317(7, 'stupefiant', 200, 0),
318(8, 'arme', 200, 0),
319(9, 'argent', 200, 0),
320(10, 'sonore', 180, 0),
321(11, 'outrage', 180, 0),
322(12, 'arnaque', 180, 0),
323(13, 'recele', 180, 0),
324(14, 'evasion', 200, 360),
325(15, 'gav', 0, 0);
326
327-- --------------------------------------------------------
328
329--
330-- Structure de la table `preference`
331--
332
333CREATE TABLE IF NOT EXISTS `preference` (
334`id` int(11) NOT NULL,
335 `nationalite` varchar(64) NOT NULL DEFAULT 'none',
336 `sexe` int(1) NOT NULL DEFAULT '0',
337 `steamid` varchar(64) NOT NULL DEFAULT 'inconnu',
338 `jetpack` int(1) NOT NULL DEFAULT '1',
339 `skin` varchar(128) NOT NULL DEFAULT 'none',
340 `skincut` varchar(64) NOT NULL DEFAULT 'weapon_knife',
341 `graffiti` varchar(64) NOT NULL DEFAULT 'none',
342 `affichergrade` int(1) NOT NULL DEFAULT '1'
343) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
344
345--
346-- Contenu de la table `preference`
347--
348
349INSERT INTO `preference` (`id`, `nationalite`, `sexe`, `steamid`, `jetpack`, `skin`, `skincut`, `graffiti`, `affichergrade`) VALUES
350(1, 'Algérienne', 1, 'STEAM_0:0:26739102', 1, 'none', 'weapon_knife_butterfly', '2pac', 1),
351(2, 'Américaine', 2, 'STEAM_0:0:41250573', 1, 'none', 'weapon_knife', 'none', 1);
352
353-- --------------------------------------------------------
354
355--
356-- Structure de la table `prix`
357--
358
359CREATE TABLE IF NOT EXISTS `prix` (
360`id` int(11) NOT NULL,
361 `itemid` int(4) NOT NULL,
362 `prix` int(100) NOT NULL DEFAULT '1',
363 `defaut` int(100) NOT NULL DEFAULT '1'
364) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=latin1;
365
366--
367-- Contenu de la table `prix`
368--
369
370INSERT INTO `prix` (`id`, `itemid`, `prix`, `defaut`) VALUES
371(1, 401, 45, 45),
372(2, 402, 80, 80),
373(3, 403, 120, 120),
374(4, 404, 125, 125),
375(5, 405, 250, 250),
376(6, 406, 300, 300),
377(7, 601, 250, 250),
378(8, 602, 200, 200),
379(9, 603, 325, 325),
380(10, 604, 300, 300),
381(11, 605, 400, 400),
382(12, 606, 300, 300),
383(13, 607, 325, 325),
384(14, 608, 750, 750),
385(15, 609, 625, 625),
386(16, 610, 1175, 1175),
387(17, 611, 700, 700),
388(18, 612, 850, 850),
389(19, 613, 850, 850),
390(20, 614, 1500, 1500),
391(21, 615, 1250, 1250),
392(22, 616, 1750, 1750),
393(23, 617, 1550, 1550),
394(24, 618, 1750, 1750),
395(25, 619, 1000, 1000),
396(26, 620, 1125, 1125),
397(27, 621, 1350, 1350),
398(28, 622, 1375, 1375),
399(29, 623, 2375, 2375),
400(30, 624, 2500, 2500),
401(31, 625, 2600, 2600),
402(32, 626, 2850, 2850),
403(33, 627, 2875, 2875),
404(34, 628, 2850, 2850),
405(35, 629, 0, 2500),
406(36, 630, 2500, 2500),
407(37, 631, 1450, 1450),
408(38, 632, 150, 150),
409(39, 633, 100, 100),
410(40, 634, 150, 150),
411(41, 635, 300, 300),
412(42, 636, 220, 220),
413(43, 638, 179, 179),
414(44, 639, 250, 250),
415(45, 645, 200, 200),
416(46, 646, 25, 25),
417(47, 647, 125, 125),
418(48, 648, 250, 250),
419(49, 649, 500, 500),
420(50, 650, 80, 80),
421(51, 651, 200, 200),
422(52, 652, 140, 140),
423(53, 653, 170, 170),
424(54, 901, 50, 50),
425(55, 902, 150, 150),
426(56, 903, 250, 250),
427(57, 904, 300, 300),
428(58, 905, 400, 400),
429(59, 906, 450, 450),
430(60, 1001, 320, 320),
431(61, 1002, 120, 120),
432(62, 1003, 460, 460),
433(63, 1110, 340, 340),
434(64, 1111, 460, 460),
435(65, 1301, 650, 650),
436(66, 1302, 2500, 2500),
437(67, 1303, 4750, 4750),
438(68, 1304, 5750, 5750),
439(69, 1305, 90, 90),
440(70, 1306, 720, 720),
441(71, 1307, 45, 45),
442(72, 1308, 340, 340),
443(73, 1401, 10, 10),
444(74, 1402, 100, 100),
445(75, 1403, 1000, 1000),
446(76, 1417, 15, 15),
447(77, 1418, 120, 120),
448(78, 1419, 60, 60),
449(79, 1420, 85, 85),
450(80, 1421, 10, 10),
451(81, 1422, 150, 150),
452(82, 1423, 150, 150),
453(83, 1424, 150, 150),
454(84, 1425, 150, 150),
455(85, 1426, 150, 150),
456(86, 1427, 150, 150),
457(87, 1428, 150, 150),
458(88, 1429, 150, 150),
459(89, 1430, 150, 150),
460(90, 1431, 150, 150),
461(91, 1432, 150, 150),
462(92, 1433, 90, 90),
463(93, 1434, 90, 90),
464(94, 1435, 90, 90),
465(95, 1436, 90, 90),
466(96, 1437, 90, 90),
467(97, 1438, 90, 90),
468(98, 1439, 90, 90),
469(99, 1440, 90, 90),
470(100, 1441, 90, 90),
471(101, 1442, 90, 90),
472(174, 1402, 100, 100),
473(175, 1403, 1000, 1000),
474(176, 1417, 15, 15),
475(177, 1418, 120, 120),
476(178, 1419, 60, 60),
477(179, 1420, 85, 85),
478(180, 1421, 10, 10),
479(181, 1422, 150, 150),
480(182, 1423, 150, 150),
481(183, 1424, 150, 150),
482(184, 1425, 150, 150),
483(185, 1426, 150, 150),
484(186, 1427, 150, 150),
485(187, 1428, 150, 150),
486(188, 1429, 150, 150),
487(189, 1430, 150, 150),
488(190, 1431, 150, 150),
489(191, 1432, 150, 150),
490(192, 1433, 90, 90),
491(193, 1434, 90, 90),
492(194, 1435, 90, 90),
493(195, 1436, 90, 90),
494(196, 1437, 90, 90),
495(197, 1438, 90, 90),
496(198, 1439, 90, 90),
497(199, 1440, 90, 90),
498(200, 1441, 90, 90),
499(201, 1442, 90, 90),
500(202, 654, 300, 300);
501
502-- --------------------------------------------------------
503
504--
505-- Structure de la table `salaire`
506--
507
508CREATE TABLE IF NOT EXISTS `salaire` (
509`id` int(11) NOT NULL,
510 `jobid` int(2) NOT NULL,
511 `gradeid` int(1) NOT NULL,
512 `salaire` int(100) NOT NULL DEFAULT '50'
513) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=latin1;
514
515--
516-- Contenu de la table `salaire`
517--
518
519INSERT INTO `salaire` (`id`, `jobid`, `gradeid`, `salaire`) VALUES
520(1, 0, 0, 50),
521(2, 1, 1, 704),
522(3, 1, 2, 50),
523(4, 1, 3, 50),
524(5, 1, 4, 50),
525(6, 1, 5, 50),
526(7, 1, 6, 50),
527(8, 1, 7, 50),
528(9, 2, 1, 50),
529(10, 2, 2, 50),
530(11, 2, 3, 50),
531(12, 2, 4, 50),
532(13, 2, 5, 50),
533(14, 3, 1, 50),
534(15, 3, 2, 50),
535(16, 3, 3, 50),
536(17, 3, 4, 50),
537(18, 3, 5, 50),
538(19, 4, 1, 50),
539(20, 4, 2, 50),
540(21, 4, 3, 50),
541(22, 4, 4, 50),
542(23, 4, 5, 50),
543(24, 5, 1, 50),
544(25, 5, 2, 50),
545(26, 5, 3, 50),
546(27, 5, 4, 50),
547(28, 6, 1, 50),
548(29, 6, 2, 50),
549(30, 6, 3, 50),
550(31, 6, 4, 50),
551(32, 6, 5, 50),
552(33, 7, 1, 50),
553(34, 7, 2, 50),
554(35, 7, 3, 50),
555(36, 7, 4, 50),
556(37, 7, 5, 50),
557(38, 7, 6, 50),
558(39, 8, 1, 50),
559(40, 8, 2, 50),
560(41, 8, 3, 50),
561(42, 8, 4, 50),
562(43, 8, 5, 50),
563(44, 9, 1, 50),
564(45, 9, 2, 50),
565(46, 9, 3, 50),
566(47, 9, 4, 50),
567(48, 9, 5, 50),
568(49, 10, 1, 50),
569(50, 10, 2, 50),
570(51, 10, 3, 50),
571(52, 10, 4, 50),
572(53, 10, 5, 50),
573(54, 11, 1, 50),
574(55, 11, 2, 50),
575(56, 11, 3, 50),
576(57, 11, 4, 50),
577(58, 11, 5, 50),
578(59, 12, 1, 50),
579(60, 12, 2, 50),
580(61, 12, 3, 50),
581(62, 12, 4, 50),
582(63, 12, 5, 50),
583(64, 13, 1, 50),
584(65, 13, 2, 50),
585(66, 13, 3, 50),
586(67, 13, 4, 50),
587(68, 13, 5, 50),
588(69, 14, 1, 50),
589(70, 14, 2, 50),
590(71, 14, 3, 50),
591(72, 14, 4, 50),
592(73, 14, 5, 50),
593(74, 15, 1, 50),
594(75, 15, 2, 50),
595(76, 15, 3, 50),
596(77, 15, 4, 50),
597(78, 15, 5, 50);
598
599-- --------------------------------------------------------
600
601--
602-- Structure de la table `succes`
603--
604
605CREATE TABLE IF NOT EXISTS `succes` (
606`id` int(11) NOT NULL,
607 `steamid` varchar(64) NOT NULL DEFAULT 'inconnu',
608 `nbkill` int(100) NOT NULL DEFAULT '0',
609 `succesyoda` int(1) NOT NULL DEFAULT '0',
610 `succescarteidentite` int(1) NOT NULL DEFAULT '0'
611) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
612
613--
614-- Contenu de la table `succes`
615--
616
617INSERT INTO `succes` (`id`, `steamid`, `nbkill`, `succesyoda`, `succescarteidentite`) VALUES
618(1, 'STEAM_0:0:26739102', 4, 1, 0),
619(2, 'STEAM_0:0:41250573', 2, 0, 0);
620
621-- --------------------------------------------------------
622
623--
624-- Structure de la table `time`
625--
626
627CREATE TABLE IF NOT EXISTS `time` (
628`id` int(11) NOT NULL,
629 `hour1` int(2) NOT NULL DEFAULT '0',
630 `hour2` int(1) NOT NULL DEFAULT '1',
631 `day` int(2) NOT NULL DEFAULT '1',
632 `month` int(2) NOT NULL DEFAULT '1',
633 `years` int(4) NOT NULL DEFAULT '2014'
634) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
635
636--
637-- Contenu de la table `time`
638--
639
640INSERT INTO `time` (`id`, `hour1`, `hour2`, `day`, `month`, `years`) VALUES
641(1, 0, 8, 21, 5, 2014);
642
643--
644-- Index pour les tables exportées
645--
646
647--
648-- Index pour la table `adm_site_rp`
649--
650ALTER TABLE `adm_site_rp`
651 ADD PRIMARY KEY (`id`);
652
653--
654-- Index pour la table `ban`
655--
656ALTER TABLE `ban`
657 ADD PRIMARY KEY (`id`);
658
659--
660-- Index pour la table `item`
661--
662ALTER TABLE `item`
663 ADD PRIMARY KEY (`id`);
664
665--
666-- Index pour la table `job`
667--
668ALTER TABLE `job`
669 ADD PRIMARY KEY (`id`);
670
671--
672-- Index pour la table `lotery`
673--
674ALTER TABLE `lotery`
675 ADD PRIMARY KEY (`id`);
676
677--
678-- Index pour la table `player`
679--
680ALTER TABLE `player`
681 ADD PRIMARY KEY (`id`);
682
683--
684-- Index pour la table `police`
685--
686ALTER TABLE `police`
687 ADD PRIMARY KEY (`id`);
688
689--
690-- Index pour la table `preference`
691--
692ALTER TABLE `preference`
693 ADD PRIMARY KEY (`id`);
694
695--
696-- Index pour la table `prix`
697--
698ALTER TABLE `prix`
699 ADD PRIMARY KEY (`id`);
700
701--
702-- Index pour la table `salaire`
703--
704ALTER TABLE `salaire`
705 ADD PRIMARY KEY (`id`);
706
707--
708-- Index pour la table `succes`
709--
710ALTER TABLE `succes`
711 ADD PRIMARY KEY (`id`);
712
713--
714-- Index pour la table `time`
715--
716ALTER TABLE `time`
717 ADD PRIMARY KEY (`id`);
718
719--
720-- AUTO_INCREMENT pour les tables exportées
721--
722
723--
724-- AUTO_INCREMENT pour la table `adm_site_rp`
725--
726ALTER TABLE `adm_site_rp`
727MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
728--
729-- AUTO_INCREMENT pour la table `ban`
730--
731ALTER TABLE `ban`
732MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
733--
734-- AUTO_INCREMENT pour la table `item`
735--
736ALTER TABLE `item`
737MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
738--
739-- AUTO_INCREMENT pour la table `job`
740--
741ALTER TABLE `job`
742MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=102;
743--
744-- AUTO_INCREMENT pour la table `lotery`
745--
746ALTER TABLE `lotery`
747MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
748--
749-- AUTO_INCREMENT pour la table `player`
750--
751ALTER TABLE `player`
752MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
753--
754-- AUTO_INCREMENT pour la table `police`
755--
756ALTER TABLE `police`
757MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
758--
759-- AUTO_INCREMENT pour la table `preference`
760--
761ALTER TABLE `preference`
762MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
763--
764-- AUTO_INCREMENT pour la table `prix`
765--
766ALTER TABLE `prix`
767MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=203;
768--
769-- AUTO_INCREMENT pour la table `salaire`
770--
771ALTER TABLE `salaire`
772MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=79;
773--
774-- AUTO_INCREMENT pour la table `succes`
775--
776ALTER TABLE `succes`
777MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
778--
779-- AUTO_INCREMENT pour la table `time`
780--
781ALTER TABLE `time`
782MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
783/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
784/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
785/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;