· 7 years ago · Dec 26, 2018, 11:42 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : lag
5Source Server Version : 50628
6Source Host : localhost:3306
7Source Database : jj
8
9Target Server Type : MYSQL
10Target Server Version : 50628
11File Encoding : 65001
12
13Date: 2018-06-24 15:05:38
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `banlog`
20-- ----------------------------
21DROP TABLE IF EXISTS `banlog`;
22CREATE TABLE `banlog` (
23 `UserID` int(11) NOT NULL,
24 `BannedByID` int(11) NOT NULL,
25 `Time` int(11) NOT NULL,
26 `Reason` text NOT NULL,
27 `Date` int(11) NOT NULL,
28 `IP` text NOT NULL,
29 `IsBan` tinyint(1) NOT NULL
30) ENGINE=MyISAM DEFAULT CHARSET=latin1;
31
32-- ----------------------------
33-- Records of banlog
34-- ----------------------------
35INSERT INTO `banlog` VALUES ('3', '1', '100', 'pq eu quero', '152963114', '127.0.0.1', '1');
36INSERT INTO `banlog` VALUES ('3', '1', '1', 'hack', '152963136', '', '1');
37INSERT INTO `banlog` VALUES ('3', '1', '0', '', '152963141', '', '0');
38INSERT INTO `banlog` VALUES ('3', '1', '666', 'pq s', '152963143', '', '1');
39INSERT INTO `banlog` VALUES ('3', '1', '0', '', '152963146', '', '0');
40INSERT INTO `banlog` VALUES ('3', '1', '1', 'hack', '152963148', '127.0.0.1', '1');
41
42-- ----------------------------
43-- Table structure for `cafeposts`
44-- ----------------------------
45DROP TABLE IF EXISTS `cafeposts`;
46CREATE TABLE `cafeposts` (
47 `PostID` int(11) NOT NULL AUTO_INCREMENT,
48 `TopicID` int(11) NOT NULL,
49 `AuthorID` int(11) NOT NULL,
50 `Post` text NOT NULL,
51 `Date` int(11) NOT NULL,
52 `Points` int(11) NOT NULL,
53 `Votes` text NOT NULL,
54 PRIMARY KEY (`PostID`)
55) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
56
57-- ----------------------------
58-- Records of cafeposts
59-- ----------------------------
60INSERT INTO `cafeposts` VALUES ('9', '7', '1', 'Xpto Xpto', '83128381', '0', ' ');
61INSERT INTO `cafeposts` VALUES ('10', '7', '1', 'mama mia', '1529634140', '0', '1');
62INSERT INTO `cafeposts` VALUES ('11', '1', '1', 'bbb', '1529639869', '0', '1');
63INSERT INTO `cafeposts` VALUES ('12', '9', '1', 'bbb', '1529809352', '0', '2');
64INSERT INTO `cafeposts` VALUES ('13', '9', '1', 'ccc', '1529809354', '0', '2');
65INSERT INTO `cafeposts` VALUES ('14', '9', '1', 'ddd', '1529809356', '0', '2');
66INSERT INTO `cafeposts` VALUES ('15', '9', '1', 'eee', '1529809358', '0', '2');
67
68-- ----------------------------
69-- Table structure for `cafetopics`
70-- ----------------------------
71DROP TABLE IF EXISTS `cafetopics`;
72CREATE TABLE `cafetopics` (
73 `TopicID` int(11) NOT NULL AUTO_INCREMENT,
74 `Title` text NOT NULL,
75 `AuthorID` int(11) NOT NULL,
76 `Langue` text NOT NULL,
77 PRIMARY KEY (`TopicID`)
78) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
79
80-- ----------------------------
81-- Records of cafetopics
82-- ----------------------------
83INSERT INTO `cafetopics` VALUES ('7', 'Xpto', '1', 'BR');
84INSERT INTO `cafetopics` VALUES ('8', 'aaa', '1', 'BR');
85INSERT INTO `cafetopics` VALUES ('9', 'aaa', '1', 'BR');
86
87-- ----------------------------
88-- Table structure for `election`
89-- ----------------------------
90DROP TABLE IF EXISTS `election`;
91CREATE TABLE `election` (
92 `UserID` int(11) NOT NULL,
93 `Fur` int(11) NOT NULL,
94 `Langue` text NOT NULL,
95 `Votes` text NOT NULL,
96 `VotesCount` int(11) NOT NULL,
97 `Look` text NOT NULL,
98 `Slogan` text NOT NULL,
99 `Discourse` text NOT NULL,
100 `Mayor` int(11) NOT NULL,
101 `President` int(11) NOT NULL
102) ENGINE=MyISAM DEFAULT CHARSET=latin1;
103
104-- ----------------------------
105-- Records of election
106-- ----------------------------
107INSERT INTO `election` VALUES ('3', '53', 'BR', '127.0.0.1', '1', '53;0,0,0,0,0,0,0,0,0', 'Votem em mim !', '', '0', '1');
108
109-- ----------------------------
110-- Table structure for `friend`
111-- ----------------------------
112DROP TABLE IF EXISTS `friend`;
113CREATE TABLE `friend` (
114 `UserID` int(11) NOT NULL,
115 `FriendID` int(11) NOT NULL,
116 UNIQUE KEY `UserID` (`UserID`,`FriendID`)
117) ENGINE=InnoDB DEFAULT CHARSET=latin1;
118
119-- ----------------------------
120-- Records of friend
121-- ----------------------------
122INSERT INTO `friend` VALUES ('1', '3');
123INSERT INTO `friend` VALUES ('3', '1');
124INSERT INTO `friend` VALUES ('3', '4');
125INSERT INTO `friend` VALUES ('4', '3');
126
127-- ----------------------------
128-- Table structure for `ignored`
129-- ----------------------------
130DROP TABLE IF EXISTS `ignored`;
131CREATE TABLE `ignored` (
132 `UserID` int(11) NOT NULL,
133 `IgnoreID` int(11) NOT NULL,
134 UNIQUE KEY `UserID` (`UserID`,`IgnoreID`)
135) ENGINE=InnoDB DEFAULT CHARSET=latin1;
136
137-- ----------------------------
138-- Records of ignored
139-- ----------------------------
140
141-- ----------------------------
142-- Table structure for `ipbans`
143-- ----------------------------
144DROP TABLE IF EXISTS `ipbans`;
145CREATE TABLE `ipbans` (
146 `IP` text NOT NULL,
147 `Time` int(11) NOT NULL
148) ENGINE=InnoDB DEFAULT CHARSET=latin1;
149
150-- ----------------------------
151-- Records of ipbans
152-- ----------------------------
153
154-- ----------------------------
155-- Table structure for `loginlog`
156-- ----------------------------
157DROP TABLE IF EXISTS `loginlog`;
158CREATE TABLE `loginlog` (
159 `Username` varchar(255) NOT NULL,
160 `IP` varchar(255) NOT NULL,
161 UNIQUE KEY `Username` (`Username`,`IP`)
162) ENGINE=MyISAM DEFAULT CHARSET=latin1;
163
164-- ----------------------------
165-- Records of loginlog
166-- ----------------------------
167INSERT INTO `loginlog` VALUES ('*Hack', '127.0.0.1');
168INSERT INTO `loginlog` VALUES ('*Souris', '127.0.0.1');
169INSERT INTO `loginlog` VALUES ('*Wees', '127.0.0.1');
170INSERT INTO `loginlog` VALUES ('*Weeslleey', '127.0.0.1');
171INSERT INTO `loginlog` VALUES ('A33', '127.0.0.1');
172INSERT INTO `loginlog` VALUES ('Anta', '127.0.0.1');
173INSERT INTO `loginlog` VALUES ('Dicrapio', '127.0.0.1');
174INSERT INTO `loginlog` VALUES ('Figaro', '127.0.0.1');
175INSERT INTO `loginlog` VALUES ('Hatoa', '127.0.0.1');
176INSERT INTO `loginlog` VALUES ('Ice', '127.0.0.1');
177INSERT INTO `loginlog` VALUES ('Leonid', '127.0.0.1');
178INSERT INTO `loginlog` VALUES ('Ncnesbchyup', '127.0.0.1');
179INSERT INTO `loginlog` VALUES ('Wees', '127.0.0.1');
180INSERT INTO `loginlog` VALUES ('Weeslleey', '1');
181INSERT INTO `loginlog` VALUES ('Weeslleey', '127.0.0.1');
182INSERT INTO `loginlog` VALUES ('Weeslleey#0000', '127.0.0.1');
183INSERT INTO `loginlog` VALUES ('Weeslleey#5272', '127.0.0.1');
184INSERT INTO `loginlog` VALUES ('Weeslleeyx', '127.0.0.1');
185INSERT INTO `loginlog` VALUES ('Xpto', '127.0.0.1');
186INSERT INTO `loginlog` VALUES ('Xpto', '127.0.0.2');
187INSERT INTO `loginlog` VALUES ('Xpto#0000', '127.0.0.1');
188
189-- ----------------------------
190-- Table structure for `mapeditor`
191-- ----------------------------
192DROP TABLE IF EXISTS `mapeditor`;
193CREATE TABLE `mapeditor` (
194 `Code` int(11) NOT NULL AUTO_INCREMENT,
195 `AuthorID` int(11) NOT NULL,
196 `XML` longtext NOT NULL,
197 `YesVotes` int(11) NOT NULL,
198 `NoVotes` int(11) NOT NULL,
199 `Perma` int(11) NOT NULL,
200 PRIMARY KEY (`Code`)
201) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
202
203-- ----------------------------
204-- Records of mapeditor
205-- ----------------------------
206INSERT INTO `mapeditor` VALUES ('1', '1', '<C><P /><Z><S><S X=\"342\" L=\"380\" Y=\"326\" H=\"138\" P=\"0,0,0.3,0.2,0,0,0,0\" T=\"0\" /></S><D /><O /></Z></C>', '0', '0', '22');
207INSERT INTO `mapeditor` VALUES ('2', '1', '<C><P P=\"\" /><Z><S><S X=\"351\" L=\"326\" Y=\"333\" H=\"139\" P=\"0,0,0.3,0.2,0,0,0,0\" T=\"0\" /></S><D><T X=\"404\" Y=\"263\" /><F X=\"321\" Y=\"259\" /><P X=\"217\" P=\"0,0\" T=\"0\" Y=\"266\" /></D><O><O C=\"6\" X=\"285\" P=\"0\" Y=\"219\" /></O></Z></C>', '2', '4', '9');
208INSERT INTO `mapeditor` VALUES ('3', '1', '<C><P IP=\"x_transformice/x_salon801/x_ap_cabane2.png,100,200\" /><Z><S><S X=\"346\" L=\"438\" Y=\"365\" H=\"58\" P=\"0,0,0.3,0.2,0,0,0,0\" T=\"0\" /></S><D /><O /></Z></C>', '0', '0', '22');
209INSERT INTO `mapeditor` VALUES ('4', '1', '<C><P /><Z><S><S X=\"356\" L=\"339\" Y=\"324\" H=\"58\" P=\"0,0,0.3,0.2,0,0,0,0\" T=\"0\" /></S><D><T X=\"344\" Y=\"300\" /><F X=\"397\" Y=\"287\" /></D><O /></Z></C>', '0', '0', '0');
210
211-- ----------------------------
212-- Table structure for `tribe`
213-- ----------------------------
214DROP TABLE IF EXISTS `tribe`;
215CREATE TABLE `tribe` (
216 `Code` int(11) NOT NULL AUTO_INCREMENT,
217 `Name` text NOT NULL,
218 `Message` text NOT NULL,
219 `House` int(11) NOT NULL,
220 `Ranks` text,
221 PRIMARY KEY (`Code`)
222) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
223
224-- ----------------------------
225-- Records of tribe
226-- ----------------------------
227INSERT INTO `tribe` VALUES ('1', 'Teste', 'A LELEK', '2', '${trad#TG_0}|0,0,0,0,0,0,0,0,0,0;${trad#TG_1}|0,0,0,0,0,0,0,0,0,0;${trad#TG_2}|0,0,0,0,0,0,0,0,0,0;${trad#TG_3}|0,0,0,0,0,0,0,0,0,0;${trad#TG_4}|0,0,0,0,1,0,0,0,0,0;${trad#TG_5}|0,0,0,0,1,0,1,0,0,0;${trad#TG_6}|0,0,0,0,1,0,1,1,0,0;${trad#TG_7}|0,0,0,0,1,0,1,1,1,0;${trad#TG_8}|0,1,1,1,1,1,1,1,1,1;${trad#TG_9}|1,1,1,1,1,1,1,1,1,1');
228INSERT INTO `tribe` VALUES ('9', 'test', 'test', '0', '${trad#TG_0}|0,0,0,0,0,0,0,0,0,0;${trad#TG_1}|0,0,0,0,0,0,0,0,0,0;${trad#TG_2}|0,0,0,0,0,0,0,0,0,0;${trad#TG_3}|0,0,0,0,0,0,0,0,0,0;${trad#TG_4}|0,0,0,0,1,0,0,0,0,0;${trad#TG_5}|0,0,0,0,1,0,1,0,0,0;${trad#TG_6}|0,0,0,0,1,0,1,1,0,0;${trad#TG_7}|0,0,0,0,1,0,1,1,1,0;${trad#TG_8}|0,1,1,1,1,1,1,1,1,1;${trad#TG_9}|1,1,1,1,1,1,1,1,1,1');
229INSERT INTO `tribe` VALUES ('10', 'xpto', '', '0', '${trad#TG_0}|0,0,0,0,0,0,0,0,0,0;${trad#TG_1}|0,0,0,0,0,0,0,0,0,0;${trad#TG_2}|0,0,0,0,0,0,0,0,0,0;${trad#TG_3}|0,0,0,0,0,0,0,0,0,0;${trad#TG_4}|0,0,0,0,1,0,0,0,0,0;${trad#TG_5}|0,0,0,0,1,0,1,0,0,0;${trad#TG_6}|0,0,0,0,1,0,1,1,0,0;${trad#TG_7}|0,0,0,0,1,0,1,1,1,0;${trad#TG_8}|0,1,1,1,1,1,1,1,1,1;${trad#TG_9}|1,1,1,1,1,1,1,1,1,1');
230INSERT INTO `tribe` VALUES ('11', 'abc', '', '0', '${trad#TG_0}|0,0,0,0,0,0,0,0,0,0;${trad#TG_1}|0,0,0,0,0,0,0,0,0,0;${trad#TG_2}|0,0,0,0,0,0,0,0,0,0;${trad#TG_3}|0,0,0,0,0,0,0,0,0,0;${trad#TG_4}|0,0,0,0,1,0,0,0,0,0;${trad#TG_5}|0,0,0,0,1,0,1,0,0,0;${trad#TG_6}|0,0,0,0,1,0,1,1,0,0;${trad#TG_7}|0,0,0,0,1,0,1,1,1,0;${trad#TG_8}|0,1,1,1,1,1,1,1,1,1;${trad#TG_9}|1,1,1,1,1,1,1,1,1,1');
231INSERT INTO `tribe` VALUES ('14', 'Nothing', '', '0', '${trad#TG_0}|0,0,0,0,0,0,0,0,0,0;${trad#TG_1}|0,0,0,0,0,0,0,0,0,0;${trad#TG_2}|0,0,0,0,0,0,0,0,0,0;${trad#TG_3}|0,0,0,0,0,0,0,0,0,0;${trad#TG_4}|0,0,0,0,1,0,0,0,0,0;${trad#TG_5}|0,0,0,0,1,0,1,0,0,0;${trad#TG_6}|0,0,0,0,1,0,1,1,0,0;${trad#TG_7}|0,0,0,0,1,0,1,1,1,0;${trad#TG_8}|0,1,1,1,1,1,1,1,1,1;${trad#TG_9}|1,1,1,1,1,1,1,1,1,1');
232
233-- ----------------------------
234-- Table structure for `tribehistoric`
235-- ----------------------------
236DROP TABLE IF EXISTS `tribehistoric`;
237CREATE TABLE `tribehistoric` (
238 `ID` int(11) NOT NULL AUTO_INCREMENT,
239 `TribeCode` int(11) NOT NULL,
240 `Type` int(11) NOT NULL,
241 `Date` int(11) NOT NULL,
242 `Informations` text NOT NULL,
243 PRIMARY KEY (`ID`)
244) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
245
246-- ----------------------------
247-- Records of tribehistoric
248-- ----------------------------
249INSERT INTO `tribehistoric` VALUES ('1', '1', '1', '25495469', '{\"auteur\":\"xpto#0000\",\"tribu\":\"xpto\"}');
250INSERT INTO `tribehistoric` VALUES ('2', '1', '1', '25495472', '{\"auteur\":\"xpto#0000\",\"tribu\":\"abc\"}');
251INSERT INTO `tribehistoric` VALUES ('21', '14', '1', '25496408', '{\"auteur\":\"xpto#0000\",\"tribu\":\"Nothing\"}');
252INSERT INTO `tribehistoric` VALUES ('22', '14', '2', '25496408', '{\"auteur\":\"xpto#0000\",\"membreAjoute\":\"weeslleey#5272\"}');
253
254-- ----------------------------
255-- Table structure for `users`
256-- ----------------------------
257DROP TABLE IF EXISTS `users`;
258CREATE TABLE `users` (
259 `PlayerID` int(11) NOT NULL AUTO_INCREMENT,
260 `Username` text NOT NULL,
261 `NameID` smallint(4) NOT NULL,
262 `Password` text NOT NULL,
263 `PrivLevel` int(11) NOT NULL,
264 `TitleNumber` int(11) NOT NULL,
265 `FirstCount` int(11) NOT NULL,
266 `CheeseCount` int(11) NOT NULL,
267 `ShamanCheeses` int(11) NOT NULL,
268 `ShopCheeses` int(11) NOT NULL,
269 `ShopFraises` int(11) NOT NULL,
270 `ShamanSaves` int(11) NOT NULL,
271 `HardModeSaves` int(11) NOT NULL,
272 `DivineModeSaves` int(11) NOT NULL,
273 `BootcampCount` int(11) NOT NULL,
274 `ShamanType` int(11) NOT NULL,
275 `Look` text NOT NULL,
276 `MouseColor` text NOT NULL,
277 `ShamanColor` text NOT NULL,
278 `RegDate` int(11) NOT NULL,
279 `CheeseTitleList` text NOT NULL,
280 `FirstTitleList` text NOT NULL,
281 `BootcampTitleList` text NOT NULL,
282 `ShamanTitleList` text NOT NULL,
283 `HardModeTitleList` text NOT NULL,
284 `DivineModeTitleList` text NOT NULL,
285 `ShopTitleList` text NOT NULL,
286 `SpecialTitleList` text NOT NULL,
287 `ShopItems` text NOT NULL,
288 `ShamanItems` text NOT NULL,
289 `ShamanEquipedItems` text NOT NULL,
290 `Clothes` text NOT NULL,
291 `ShopBadges` text NOT NULL,
292 `TotemItemCount` int(11) NOT NULL,
293 `Totem` text NOT NULL,
294 `BanHours` int(11) NOT NULL,
295 `Email` text NOT NULL,
296 `MapCrew` int(11) NOT NULL,
297 `LuaDev` int(11) NOT NULL,
298 `FunCorp` int(11) NOT NULL,
299 `ShamanLevel` int(11) NOT NULL,
300 `ShamanExp` int(11) NOT NULL,
301 `ShamanExpNext` int(11) NOT NULL,
302 `Skills` text NOT NULL,
303 `LastOn` int(11) NOT NULL,
304 `Gender` int(11) NOT NULL,
305 `MarriageID` int(11) NOT NULL,
306 `LastDivorceTimer` int(11) NOT NULL,
307 `TribeCode` int(11) NOT NULL,
308 `TribeRank` int(11) NOT NULL,
309 `Karma` int(11) NOT NULL,
310 `TribunalCorrect` int(11) NOT NULL,
311 `TribunalIncorrect` int(11) NOT NULL,
312 `ElectionVoted` int(11) NOT NULL,
313 `Gifts` text NOT NULL,
314 `Messages` text NOT NULL,
315 `SurvivorStats` text NOT NULL,
316 `RacingStats` text NOT NULL,
317 `ShamanBadges` text NOT NULL,
318 `EquipedShamanBadge` int(11) NOT NULL,
319 `Consumables` text NOT NULL,
320 `EquipedConsumables` text NOT NULL,
321 `Letters` text NOT NULL,
322 `Pet` int(11) NOT NULL,
323 `PetEnd` int(11) NOT NULL,
324 `IceCoins` int(11) NOT NULL,
325 `IceTokens` int(11) NOT NULL,
326 `VipTime` int(11) NOT NULL,
327 `Time` int(11) NOT NULL,
328 `GodFather` int(11) NOT NULL,
329 `RoundsCount` int(11) NOT NULL,
330 `MuteTime` int(11) NOT NULL,
331 `MuteReason` text NOT NULL,
332 `PermaBanned` tinyint(1) NOT NULL,
333 `BanTime` int(11) NOT NULL,
334 `BanReason` text NOT NULL,
335 `NameColor` text NOT NULL,
336 PRIMARY KEY (`PlayerID`)
337) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
338
339-- ----------------------------
340-- Records of users
341-- ----------------------------
342INSERT INTO `users` VALUES ('1', 'Weeslleey', '0', '2pyv6EbBT/fMyRRt9T4ud9ghzxKmO/OR8fHI6YGppUg=', '10', '401', '84', '75', '16', '28956', '5479', '11', '0', '0', '7', '1', '87;0,0,0,0,0,14_b60400,26,0,4', '78583a', '95d9d6', '1440293565', '5.1,6.1', '9.1,10.1', '256.1,257.1,258.1,259.1', '1.1', '', '', '115.2,116.2,117.2,118.2,119.2,120.2,121.2,122.2,123.2,124.2,125.2,126.2', '', '2232,504_FFFFFF,78_000000+FFFFFF+000000,205_000000+FFFFFF,103_00F1F1,335,405,601_00FFDB+E0A81C,2104,2253,21,403,211,325,415,602,10130,123,610,2235,626,701,2267_,2290,523_FFFFFF,0,2287,93_fa97d1+ffffff+2a2018,109_654526,228_171614+fa97d1+fa97d1+e2e2e2,431_f5e7dc,703_,37_b60400,110_,316_b60400,514_b60400,627_bb521+fd8d21,2254,364_cda681+f89d9c+ee8680,417_b04f48+ffffff,506_854c34+854c34+b04f48+ee8680,712_,2295,804', '206,2810,406,1704,1002,701,601,106,307,403', '403', '00/54;37_b60400,10,0,16_b60400,31_f5e7dc,14_b60400,27_bb521+fd8d21,0/78583a/95d9d6|01/54;37_b60400,10,0,16_b60400,31_f5e7dc,14_b60400,27_bb521+fd8d21,0/78583a/95d9d6|03/95;0,9_654526,0,64_cda681+f89d9c+ee8680,17_b04f48+ffffff,6_854c34+854c34+b04f48+ee8680,0,12,0/78583a/95d9d6', '196:1;68:1;6:4;70:1;145:4;17:4;147:1;20:1;149:1;153:1;185:1;154:2;189:1', '0', '', '0', 'wesleyalvessilva6112@gmail.com', '1', '1', '1', '201', '47', '292215', '1:1;20:1;68:1;149:1', '25497725', '0', '4', '0', '1', '2', '0', '0', '0', '0', '', '', '0,0,0,0', '19,7,7,7', '13,23,16,28,20,24,21,3,17,22', '23', '0:4;1:198;2:199;3:199;4:196;2308:200;5:199;6:199;7:200;8:199;9:199;10:199;11:199;12:200;13:200;14:199;15:199;16:199;17:200;18:200;19:200;20:199;21:199;22:200;407:200;23:199;24:199;25:22;2202:3;26:199;2330:200;27:200;28:199;2332:200;29:200;30:200;31:199;800:199;32:200;801:199;33:199;34:200;35:199;2340:200;2343:9200;2346:199;2349:200;2351:200;2232:199;2234:199;2239:199;2240:200;2241:200;2246:199;2247:200;2250:198;2378:200;2379:199;2252:200;2253:9200;2254:250;2255:199;2256:200;2257:9192;2258:200;2259:199;2260:8750;2261:9200;2262:200', '', '', '0', '1529863507', '607', '3', '0', '82293', '0', '2626', '0', '', '0', '0', '', '4AFF00');
343INSERT INTO `users` VALUES ('3', 'Weeslleey', '5272', '2pyv6EbBT/fMyRRt9T4ud9ghzxKmO/OR8fHI6YGppUg=', '1', '0', '0', '0', '0', '10000', '10000', '0', '0', '0', '0', '0', '1;0,0,0,0,0,0,0,0,0', '78583a', '95d9d6', '1529626988', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', '0', 'xpto@gmail.com', '0', '0', '0', '200', '0', '289200', '', '25496412', '0', '0', '0', '14', '0', '0', '0', '0', '0', '', '', '0,0,0,0', '0,0,0,0', '', '0', '', '', '', '0', '1529784727', '0', '0', '0', '1251', '0', '38', '0', '', '0', '0', '\'', '');
344INSERT INTO `users` VALUES ('4', 'Xpto', '0', '2pyv6EbBT/fMyRRt9T4ud9ghzxKmO/OR8fHI6YGppUg=', '1', '0', '0', '0', '2', '9000', '10000', '0', '0', '0', '0', '0', '1;0,0,0,0,0,0,0,0,0', '78583a', '95d9d6', '1529718023', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', '0', 'xpto@gmail.com', '0', '0', '0', '200', '0', '289200', '', '25497465', '2', '1', '0', '14', '9', '0', '0', '0', '0', '', '', '0,0,0,0', '0,0,0,0', '', '0', '', '', '', '0', '1529847908', '0', '0', '0', '1728', '0', '48', '0', '', '0', '0', '', '');
345DROP TRIGGER IF EXISTS `create_tribe`;
346DELIMITER ;;
347CREATE TRIGGER `create_tribe` BEFORE INSERT ON `tribe` FOR EACH ROW BEGIN
348 SET NEW.Ranks = '${trad#TG_0}|0,0,0,0,0,0,0,0,0,0;${trad#TG_1}|0,0,0,0,0,0,0,0,0,0;${trad#TG_2}|0,0,0,0,0,0,0,0,0,0;${trad#TG_3}|0,0,0,0,0,0,0,0,0,0;${trad#TG_4}|0,0,0,0,1,0,0,0,0,0;${trad#TG_5}|0,0,0,0,1,0,1,0,0,0;${trad#TG_6}|0,0,0,0,1,0,1,1,0,0;${trad#TG_7}|0,0,0,0,1,0,1,1,1,0;${trad#TG_8}|0,1,1,1,1,1,1,1,1,1;${trad#TG_9}|1,1,1,1,1,1,1,1,1,1';
349END
350;;
351DELIMITER ;
352DROP TRIGGER IF EXISTS `delete_tribe`;
353DELIMITER ;;
354CREATE TRIGGER `delete_tribe` BEFORE DELETE ON `tribe` FOR EACH ROW BEGIN
355 DELETE FROM tribehistoric WHERE TribeCode = OLD.Code;
356 UPDATE Users SET TribeCode = 0, TribeRank = 0 WHERE TribeCode = OLD.Code;
357END
358;;
359DELIMITER ;