· 7 years ago · Jan 08, 2019, 12:28 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Servidor: localhost
6-- Tempo de Geração: 29/09/2018 às 17:46
7-- Versão do servidor: 5.5.58-0ubuntu0.14.04.1
8-- Versão do PHP: 5.5.9-1ubuntu4.22
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-- Banco de dados: `globalfolk860`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estrutura para tabela `accounts`
27--
28
29CREATE TABLE IF NOT EXISTS `accounts` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `name` varchar(32) NOT NULL DEFAULT '',
32 `password` varchar(255) NOT NULL,
33 `premdays` int(11) NOT NULL DEFAULT '0',
34 `lastday` int(10) unsigned NOT NULL DEFAULT '0',
35 `email` varchar(255) NOT NULL DEFAULT '',
36 `key` varchar(20) NOT NULL DEFAULT '0',
37 `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
38 `warnings` int(11) NOT NULL DEFAULT '0',
39 `group_id` int(11) NOT NULL DEFAULT '1',
40 `page_lastday` int(11) NOT NULL,
41 `email_new` varchar(255) NOT NULL,
42 `email_new_time` int(15) NOT NULL,
43 `created` int(11) NOT NULL DEFAULT '0',
44 `rlname` varchar(255) NOT NULL DEFAULT '',
45 `location` varchar(255) NOT NULL DEFAULT '',
46 `page_access` int(11) NOT NULL DEFAULT '0',
47 `email_code` varchar(255) NOT NULL DEFAULT '0',
48 `next_email` int(11) NOT NULL DEFAULT '0',
49 `premium_points` int(11) NOT NULL DEFAULT '0',
50 `vote` int(11) NOT NULL,
51 `last_post` int(11) NOT NULL DEFAULT '0',
52 `flag` varchar(255) NOT NULL,
53 `viptime` int(15) NOT NULL DEFAULT '0',
54 `vip_time` int(15) NOT NULL DEFAULT '0',
55 `vipdays` int(15) NOT NULL DEFAULT '0',
56 `salt` varchar(255) NOT NULL DEFAULT '',
57 PRIMARY KEY (`id`),
58 UNIQUE KEY `name` (`name`)
59) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9686698 ;
60
61--
62-- Fazendo dump de dados para tabela `accounts`
63--
64
65INSERT INTO `accounts` (`id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `viptime`, `vip_time`, `vipdays`, `salt`) VALUES
66(1, '1', '356a192b7913b04c54574d18c28d46e6395428ab', 65535, 0, 'hjuhf@hotmail.com', 'cd3aacdb0a47c2067fed', 0, 0, 1, 1275095419, '', 0, 0, '', '', 3, '0', 0, 0, 0, 1274912789, '', 0, 0, 0, ''),
67(1225909, 'RYY', '18a98c35f49808b45edadc75fb1b25ebfd4037d6', 0, 0, 'kanskjsdadjk@lsajdksdla.com', '', 0, 0, 1, 1536616376, '', 0, 1536144282, '', '', 0, '0', 0, 0, 0, 0, '', 0, 0, 0, ''),
68(1703122, 'TESTE', '64e41586b9608df4f7be38cc33bce7072bd29a05', 0, 0, 'Hshdhdhdhd@hdjdjdj.com', '', 0, 0, 1, 1536440713, '', 0, 1536440701, '', '', 0, '0', 0, 0, 0, 0, '', 0, 0, 0, ''),
69(2292277, 'GABGABGAB', 'b8c8d5ed301e3893e9f93b513f8723adf36600ef', 0, 0, 'gabriel96almeida@gmail.com', '', 0, 0, 1, 1536574230, '', 0, 1536012443, '', '', 6, '0', 0, 0, 0, 0, '', 0, 0, 0, ''),
70(4018522, 'JARDIM', 'c3c2db04b7be3ffba712f5841da0f1600a5ce0b6', 0, 0, 'jardim.lucas@hotmail.com', '', 0, 0, 1, 1536403551, '', 0, 1536403541, '', '', 0, '0', 0, 0, 0, 0, '', 0, 0, 0, ''),
71(5147490, 'ACCOUNT', 'c08caec523b18e2cbc6db5641f94d099dc3a0fa7', 0, 0, 'kjlask@kljskjsa.com', '', 0, 0, 1, 1536529079, '', 0, 1536529072, '', '', 0, '0', 0, 0, 0, 0, '', 0, 0, 0, ''),
72(8882854, '12345', 'f1b699cc9af3eeb98e5de244ca7802ae38e77bae', 0, 0, 'akdadks@kljsklasda.com', '', 0, 0, 1, 1536288489, '', 0, 1536286427, '', '', 0, '0', 0, 0, 0, 0, '', 0, 0, 0, ''),
73(8985851, 'EUMAISVC', '17195f303a219e77b8a2f959a2e05e199c505950', 0, 0, 'danielkielse@gmail.com', '', 0, 0, 1, 1536111291, '', 0, 1536111284, '', '', 0, '0', 0, 0, 0, 0, '', 0, 0, 0, ''),
74(9481787, 'DANIEL085', '7e58477773d846b94d746d29d9bebe392ca5aac9', 0, 0, 'daniel.165@hotmail.com', '', 0, 0, 1, 0, '', 0, 1536017036, '', '', 0, '0', 0, 0, 0, 0, '', 0, 0, 0, '');
75
76--
77-- Gatilhos `accounts`
78--
79DROP TRIGGER IF EXISTS `ondelete_accounts`;
80DELIMITER //
81CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`
82 FOR EACH ROW BEGIN
83 DELETE FROM `bans` WHERE `type` IN (3, 4) AND `value` = OLD.`id`;
84END
85//
86DELIMITER ;
87
88-- --------------------------------------------------------
89
90--
91-- Estrutura para tabela `account_viplist`
92--
93
94CREATE TABLE IF NOT EXISTS `account_viplist` (
95 `account_id` int(11) NOT NULL,
96 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
97 `player_id` int(11) NOT NULL,
98 UNIQUE KEY `account_id_2` (`account_id`,`player_id`),
99 KEY `account_id` (`account_id`),
100 KEY `player_id` (`player_id`),
101 KEY `world_id` (`world_id`)
102) ENGINE=InnoDB DEFAULT CHARSET=latin1;
103
104-- --------------------------------------------------------
105
106--
107-- Estrutura para tabela `bans`
108--
109
110CREATE TABLE IF NOT EXISTS `bans` (
111 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
112 `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
113 `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
114 `param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)',
115 `active` tinyint(1) NOT NULL DEFAULT '1',
116 `expires` int(11) NOT NULL,
117 `reason` int(10) NOT NULL DEFAULT '0',
118 `added` int(10) unsigned NOT NULL,
119 `admin_id` int(10) unsigned NOT NULL DEFAULT '0',
120 `comment` text NOT NULL,
121 `action` int(10) unsigned NOT NULL DEFAULT '0',
122 `statement` varchar(255) NOT NULL DEFAULT '',
123 PRIMARY KEY (`id`),
124 KEY `type` (`type`,`value`),
125 KEY `active` (`active`)
126) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
127
128-- --------------------------------------------------------
129
130--
131-- Estrutura para tabela `environment_killers`
132--
133
134CREATE TABLE IF NOT EXISTS `environment_killers` (
135 `kill_id` int(11) NOT NULL,
136 `name` varchar(255) NOT NULL,
137 KEY `kill_id` (`kill_id`)
138) ENGINE=InnoDB DEFAULT CHARSET=latin1;
139
140--
141-- Fazendo dump de dados para tabela `environment_killers`
142--
143
144INSERT INTO `environment_killers` (`kill_id`, `name`) VALUES
145(23, 'a cyclops'),
146(24, 'a cyclops'),
147(25, 'a cyclops drone');
148
149-- --------------------------------------------------------
150
151--
152-- Estrutura para tabela `global_storage`
153--
154
155CREATE TABLE IF NOT EXISTS `global_storage` (
156 `key` varchar(32) NOT NULL DEFAULT '0',
157 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
158 `value` varchar(255) NOT NULL DEFAULT '0',
159 UNIQUE KEY `key` (`key`,`world_id`)
160) ENGINE=InnoDB DEFAULT CHARSET=latin1;
161
162--
163-- Fazendo dump de dados para tabela `global_storage`
164--
165
166INSERT INTO `global_storage` (`key`, `world_id`, `value`) VALUES
167('100075', 0, '1'),
168('1226364', 0, '1'),
169('1827050', 0, '1'),
170('1827056', 0, '1'),
171('2003352', 0, '1'),
172('2833006', 0, '1'),
173('2833012', 0, '1'),
174('3637105', 0, '1'),
175('3637111', 0, '1'),
176('415029', 0, '1'),
177('415030', 0, '0.123424'),
178('415031', 0, '1'),
179('5417282', 0, '1'),
180('6775248', 0, '1'),
181('8986306', 0, '1'),
182('9451985', 0, '1'),
183('9602305', 0, '1');
184
185-- --------------------------------------------------------
186
187--
188-- Estrutura para tabela `guilds`
189--
190
191CREATE TABLE IF NOT EXISTS `guilds` (
192 `id` int(11) NOT NULL AUTO_INCREMENT,
193 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
194 `name` varchar(255) NOT NULL,
195 `ownerid` int(11) NOT NULL,
196 `creationdata` int(11) NOT NULL,
197 `checkdata` int(11) NOT NULL,
198 `motd` varchar(255) NOT NULL,
199 `balance` bigint(20) unsigned NOT NULL,
200 `description` text NOT NULL,
201 `logo_gfx_name` varchar(255) NOT NULL DEFAULT '',
202 PRIMARY KEY (`id`),
203 UNIQUE KEY `name` (`name`,`world_id`)
204) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
205
206--
207-- Gatilhos `guilds`
208--
209DROP TRIGGER IF EXISTS `oncreate_guilds`;
210DELIMITER //
211CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds`
212 FOR EACH ROW BEGIN
213 INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);
214 INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
215 INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
216END
217//
218DELIMITER ;
219DROP TRIGGER IF EXISTS `ondelete_guilds`;
220DELIMITER //
221CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds`
222 FOR EACH ROW BEGIN
223 UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
224END
225//
226DELIMITER ;
227
228-- --------------------------------------------------------
229
230--
231-- Estrutura para tabela `guild_invites`
232--
233
234CREATE TABLE IF NOT EXISTS `guild_invites` (
235 `player_id` int(11) NOT NULL DEFAULT '0',
236 `guild_id` int(11) NOT NULL DEFAULT '0',
237 UNIQUE KEY `player_id` (`player_id`,`guild_id`),
238 KEY `guild_id` (`guild_id`)
239) ENGINE=InnoDB DEFAULT CHARSET=latin1;
240
241-- --------------------------------------------------------
242
243--
244-- Estrutura para tabela `guild_kills`
245--
246
247CREATE TABLE IF NOT EXISTS `guild_kills` (
248 `id` int(11) NOT NULL AUTO_INCREMENT,
249 `guild_id` int(11) NOT NULL,
250 `war_id` int(11) NOT NULL,
251 `death_id` int(11) NOT NULL,
252 PRIMARY KEY (`id`),
253 KEY `guild_kills_ibfk_1` (`war_id`),
254 KEY `guild_kills_ibfk_2` (`death_id`),
255 KEY `guild_kills_ibfk_3` (`guild_id`)
256) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
257
258-- --------------------------------------------------------
259
260--
261-- Estrutura para tabela `guild_ranks`
262--
263
264CREATE TABLE IF NOT EXISTS `guild_ranks` (
265 `id` int(11) NOT NULL AUTO_INCREMENT,
266 `guild_id` int(11) NOT NULL,
267 `name` varchar(255) NOT NULL,
268 `level` int(11) NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
269 PRIMARY KEY (`id`),
270 KEY `guild_id` (`guild_id`)
271) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
272
273-- --------------------------------------------------------
274
275--
276-- Estrutura para tabela `guild_wars`
277--
278
279CREATE TABLE IF NOT EXISTS `guild_wars` (
280 `id` int(11) NOT NULL AUTO_INCREMENT,
281 `guild_id` int(11) NOT NULL,
282 `enemy_id` int(11) NOT NULL,
283 `begin` bigint(20) NOT NULL DEFAULT '0',
284 `end` bigint(20) NOT NULL DEFAULT '0',
285 `frags` int(10) unsigned NOT NULL DEFAULT '0',
286 `payment` bigint(20) unsigned NOT NULL DEFAULT '0',
287 `guild_kills` int(10) unsigned NOT NULL DEFAULT '0',
288 `enemy_kills` int(10) unsigned NOT NULL DEFAULT '0',
289 `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
290 PRIMARY KEY (`id`),
291 KEY `status` (`status`),
292 KEY `guild_id` (`guild_id`),
293 KEY `enemy_id` (`enemy_id`)
294) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
295
296-- --------------------------------------------------------
297
298--
299-- Estrutura para tabela `houses`
300--
301
302CREATE TABLE IF NOT EXISTS `houses` (
303 `id` int(10) unsigned NOT NULL,
304 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
305 `owner` int(11) NOT NULL,
306 `paid` int(10) unsigned NOT NULL DEFAULT '0',
307 `warnings` int(11) NOT NULL DEFAULT '0',
308 `lastwarning` int(10) unsigned NOT NULL DEFAULT '0',
309 `name` varchar(255) NOT NULL,
310 `town` int(10) unsigned NOT NULL DEFAULT '0',
311 `size` int(10) unsigned NOT NULL DEFAULT '0',
312 `price` int(10) unsigned NOT NULL DEFAULT '0',
313 `rent` int(10) unsigned NOT NULL DEFAULT '0',
314 `doors` int(10) unsigned NOT NULL DEFAULT '0',
315 `beds` int(10) unsigned NOT NULL DEFAULT '0',
316 `tiles` int(10) unsigned NOT NULL DEFAULT '0',
317 `guild` tinyint(1) unsigned NOT NULL DEFAULT '0',
318 `clear` tinyint(1) unsigned NOT NULL DEFAULT '0',
319 UNIQUE KEY `id` (`id`,`world_id`)
320) ENGINE=InnoDB DEFAULT CHARSET=latin1;
321
322--
323-- Fazendo dump de dados para tabela `houses`
324--
325
326
327-- --------------------------------------------------------
328
329--
330-- Estrutura para tabela `house_auctions`
331--
332
333CREATE TABLE IF NOT EXISTS `house_auctions` (
334 `house_id` int(10) unsigned NOT NULL,
335 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
336 `player_id` int(11) NOT NULL,
337 `bid` int(10) unsigned NOT NULL DEFAULT '0',
338 `limit` int(10) unsigned NOT NULL DEFAULT '0',
339 `endtime` bigint(20) unsigned NOT NULL DEFAULT '0',
340 UNIQUE KEY `house_id` (`house_id`,`world_id`),
341 KEY `player_id` (`player_id`)
342) ENGINE=InnoDB DEFAULT CHARSET=latin1;
343
344-- --------------------------------------------------------
345
346--
347-- Estrutura para tabela `house_data`
348--
349
350CREATE TABLE IF NOT EXISTS `house_data` (
351 `house_id` int(10) unsigned NOT NULL,
352 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
353 `data` longblob NOT NULL,
354 UNIQUE KEY `house_id` (`house_id`,`world_id`)
355) ENGINE=InnoDB DEFAULT CHARSET=latin1;
356
357--
358-- Fazendo dump de dados para tabela `house_data`
359--
360
361-- --------------------------------------------------------
362
363--
364-- Estrutura para tabela `house_lists`
365--
366
367CREATE TABLE IF NOT EXISTS `house_lists` (
368 `house_id` int(10) unsigned NOT NULL,
369 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
370 `listid` int(11) NOT NULL,
371 `list` text NOT NULL,
372 UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
373) ENGINE=InnoDB DEFAULT CHARSET=latin1;
374
375-- --------------------------------------------------------
376
377--
378-- Estrutura para tabela `killers`
379--
380
381CREATE TABLE IF NOT EXISTS `killers` (
382 `id` int(11) NOT NULL AUTO_INCREMENT,
383 `death_id` int(11) NOT NULL,
384 `final_hit` tinyint(1) unsigned NOT NULL DEFAULT '0',
385 `unjustified` tinyint(1) unsigned NOT NULL DEFAULT '0',
386 `war` int(11) NOT NULL DEFAULT '0',
387 PRIMARY KEY (`id`),
388 KEY `death_id` (`death_id`)
389) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
390
391--
392-- Fazendo dump de dados para tabela `killers`
393--
394
395INSERT INTO `killers` (`id`, `death_id`, `final_hit`, `unjustified`, `war`) VALUES
396(23, 16, 1, 0, 0),
397(24, 17, 1, 0, 0),
398(25, 17, 0, 0, 0);
399
400-- --------------------------------------------------------
401
402--
403-- Estrutura para tabela `login_history`
404--
405
406CREATE TABLE IF NOT EXISTS `login_history` (
407 `account_id` int(11) NOT NULL DEFAULT '0',
408 `player_id` int(11) NOT NULL DEFAULT '0',
409 `type` tinyint(1) NOT NULL DEFAULT '0',
410 `login` tinyint(1) NOT NULL DEFAULT '0',
411 `ip` int(11) NOT NULL DEFAULT '0',
412 `date` int(11) NOT NULL DEFAULT '0',
413 KEY `player_id` (`player_id`)
414) ENGINE=InnoDB DEFAULT CHARSET=latin1;
415
416-- --------------------------------------------------------
417
418--
419-- Estrutura para tabela `market_history`
420--
421
422CREATE TABLE IF NOT EXISTS `market_history` (
423 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
424 `player_id` int(11) NOT NULL,
425 `sale` tinyint(1) NOT NULL DEFAULT '0',
426 `itemtype` int(10) unsigned NOT NULL,
427 `amount` smallint(5) unsigned NOT NULL,
428 `price` int(10) unsigned NOT NULL DEFAULT '0',
429 `expires_at` bigint(20) unsigned NOT NULL,
430 `inserted` bigint(20) unsigned NOT NULL,
431 `state` tinyint(1) unsigned NOT NULL,
432 PRIMARY KEY (`id`),
433 KEY `player_id` (`player_id`,`sale`)
434) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
435
436-- --------------------------------------------------------
437
438--
439-- Estrutura para tabela `market_offers`
440--
441
442CREATE TABLE IF NOT EXISTS `market_offers` (
443 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
444 `player_id` int(11) NOT NULL,
445 `sale` tinyint(1) NOT NULL DEFAULT '0',
446 `itemtype` int(10) unsigned NOT NULL,
447 `amount` smallint(5) unsigned NOT NULL,
448 `created` bigint(20) unsigned NOT NULL,
449 `anonymous` tinyint(1) NOT NULL DEFAULT '0',
450 `price` int(10) unsigned NOT NULL DEFAULT '0',
451 PRIMARY KEY (`id`),
452 KEY `sale` (`sale`,`itemtype`),
453 KEY `created` (`created`),
454 KEY `player_id` (`player_id`)
455) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
456
457-- --------------------------------------------------------
458
459--
460-- Estrutura para tabela `PagSeguroTransacoes`
461--
462
463CREATE TABLE IF NOT EXISTS `PagSeguroTransacoes` (
464 `TransacaoID` varchar(36) NOT NULL,
465 `VendedorEmail` varchar(200) NOT NULL,
466 `Referencia` varchar(200) DEFAULT NULL,
467 `TipoFrete` char(2) DEFAULT NULL,
468 `ValorFrete` decimal(10,2) DEFAULT NULL,
469 `Extras` decimal(10,2) DEFAULT NULL,
470 `Anotacao` text,
471 `TipoPagamento` varchar(50) NOT NULL,
472 `StatusTransacao` varchar(50) NOT NULL,
473 `CliNome` varchar(200) NOT NULL,
474 `CliEmail` varchar(200) NOT NULL,
475 `CliEndereco` varchar(200) NOT NULL,
476 `CliNumero` varchar(10) DEFAULT NULL,
477 `CliComplemento` varchar(100) DEFAULT NULL,
478 `CliBairro` varchar(100) NOT NULL,
479 `CliCidade` varchar(100) NOT NULL,
480 `CliEstado` char(2) NOT NULL,
481 `CliCEP` varchar(9) NOT NULL,
482 `CliTelefone` varchar(14) DEFAULT NULL,
483 `NumItens` int(11) NOT NULL,
484 `Data` datetime NOT NULL,
485 `ProdQuantidade_x` int(5) NOT NULL,
486 `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
487 UNIQUE KEY `TransacaoID` (`TransacaoID`,`StatusTransacao`),
488 KEY `Referencia` (`Referencia`),
489 KEY `status` (`status`)
490) ENGINE=MyISAM DEFAULT CHARSET=latin1;
491
492-- --------------------------------------------------------
493
494--
495-- Estrutura para tabela `pagsegurotransacoes`
496--
497
498CREATE TABLE IF NOT EXISTS `pagsegurotransacoes` (
499 `TransacaoID` varchar(36) NOT NULL,
500 `VendedorEmail` varchar(200) NOT NULL,
501 `Referencia` varchar(200) DEFAULT NULL,
502 `TipoFrete` char(2) DEFAULT NULL,
503 `ValorFrete` decimal(10,2) DEFAULT NULL,
504 `Extras` decimal(10,2) DEFAULT NULL,
505 `Anotacao` text,
506 `TipoPagamento` varchar(50) NOT NULL,
507 `StatusTransacao` varchar(50) NOT NULL,
508 `CliNome` varchar(200) NOT NULL,
509 `CliEmail` varchar(200) NOT NULL,
510 `CliEndereco` varchar(200) NOT NULL,
511 `CliNumero` varchar(10) DEFAULT NULL,
512 `CliComplemento` varchar(100) DEFAULT NULL,
513 `CliBairro` varchar(100) NOT NULL,
514 `CliCidade` varchar(100) NOT NULL,
515 `CliEstado` char(2) NOT NULL,
516 `CliCEP` varchar(9) NOT NULL,
517 `CliTelefone` varchar(14) DEFAULT NULL,
518 `NumItens` int(11) NOT NULL,
519 `Data` datetime NOT NULL,
520 `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
521 UNIQUE KEY `TransacaoID` (`TransacaoID`,`StatusTransacao`),
522 KEY `Referencia` (`Referencia`),
523 KEY `status` (`status`)
524) ENGINE=MyISAM DEFAULT CHARSET=latin1;
525
526-- --------------------------------------------------------
527
528--
529-- Estrutura para tabela `players`
530--
531
532CREATE TABLE IF NOT EXISTS `players` (
533 `id` int(11) NOT NULL AUTO_INCREMENT,
534 `name` varchar(255) NOT NULL,
535 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
536 `group_id` int(11) NOT NULL DEFAULT '1',
537 `account_id` int(11) NOT NULL DEFAULT '0',
538 `level` int(11) NOT NULL DEFAULT '1',
539 `vocation` int(11) NOT NULL DEFAULT '0',
540 `health` int(11) NOT NULL DEFAULT '150',
541 `healthmax` int(11) NOT NULL DEFAULT '150',
542 `experience` bigint(20) NOT NULL DEFAULT '0',
543 `lookbody` int(11) NOT NULL DEFAULT '0',
544 `lookfeet` int(11) NOT NULL DEFAULT '0',
545 `lookhead` int(11) NOT NULL DEFAULT '0',
546 `looklegs` int(11) NOT NULL DEFAULT '0',
547 `looktype` int(11) NOT NULL DEFAULT '136',
548 `lookaddons` int(11) NOT NULL DEFAULT '0',
549 `lookmount` int(11) NOT NULL DEFAULT '0',
550 `maglevel` int(11) NOT NULL DEFAULT '0',
551 `mana` int(11) NOT NULL DEFAULT '0',
552 `manamax` int(11) NOT NULL DEFAULT '0',
553 `manaspent` int(11) NOT NULL DEFAULT '0',
554 `soul` int(10) unsigned NOT NULL DEFAULT '0',
555 `town_id` int(11) NOT NULL DEFAULT '0',
556 `posx` int(11) NOT NULL DEFAULT '0',
557 `posy` int(11) NOT NULL DEFAULT '0',
558 `posz` int(11) NOT NULL DEFAULT '0',
559 `conditions` blob NOT NULL,
560 `cap` int(11) NOT NULL DEFAULT '0',
561 `sex` int(11) NOT NULL DEFAULT '0',
562 `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',
563 `lastip` int(10) unsigned NOT NULL DEFAULT '0',
564 `save` tinyint(1) NOT NULL DEFAULT '1',
565 `skull` tinyint(1) unsigned NOT NULL DEFAULT '0',
566 `skulltime` int(11) NOT NULL DEFAULT '0',
567 `rank_id` int(11) NOT NULL DEFAULT '0',
568 `guildnick` varchar(255) NOT NULL DEFAULT '',
569 `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',
570 `blessings` tinyint(2) NOT NULL DEFAULT '0',
571 `pvp_blessing` tinyint(1) NOT NULL DEFAULT '0',
572 `balance` bigint(20) NOT NULL DEFAULT '0',
573 `stamina` bigint(20) NOT NULL DEFAULT '151200000' COMMENT 'stored in miliseconds',
574 `direction` int(11) NOT NULL DEFAULT '2',
575 `loss_experience` int(11) NOT NULL DEFAULT '100',
576 `loss_mana` int(11) NOT NULL DEFAULT '100',
577 `loss_skills` int(11) NOT NULL DEFAULT '100',
578 `loss_containers` int(11) NOT NULL DEFAULT '100',
579 `loss_items` int(11) NOT NULL DEFAULT '100',
580 `premend` int(11) NOT NULL DEFAULT '0' COMMENT 'NOT IN USE BY THE SERVER',
581 `online` tinyint(1) NOT NULL DEFAULT '0',
582 `marriage` int(10) unsigned NOT NULL DEFAULT '0',
583 `promotion` int(11) NOT NULL DEFAULT '0',
584 `deleted` tinyint(1) NOT NULL DEFAULT '0',
585 `description` varchar(255) NOT NULL DEFAULT '',
586 `created` int(11) NOT NULL DEFAULT '0',
587 `nick_verify` int(11) NOT NULL DEFAULT '0',
588 `old_name` varchar(255) NOT NULL DEFAULT '',
589 `hide_char` int(11) NOT NULL DEFAULT '0',
590 `worldtransfer` int(11) NOT NULL DEFAULT '0',
591 `comment` text NOT NULL,
592 `rep` int(11) NOT NULL DEFAULT '0',
593 `show_quests` tinyint(4) NOT NULL DEFAULT '1',
594 `show_skills` tinyint(4) NOT NULL DEFAULT '1',
595 `stars` int(11) NOT NULL DEFAULT '0',
596 `show_bars` tinyint(4) NOT NULL DEFAULT '1',
597 `show_eq` tinyint(4) NOT NULL DEFAULT '1',
598 `show_outfit` tinyint(4) NOT NULL DEFAULT '1',
599 `ip` varchar(17) NOT NULL DEFAULT '0',
600 `viewers` int(11) NOT NULL DEFAULT '0',
601 `broadcasting` int(11) NOT NULL DEFAULT '0',
602 PRIMARY KEY (`id`),
603 UNIQUE KEY `name` (`name`,`deleted`),
604 KEY `account_id` (`account_id`),
605 KEY `group_id` (`group_id`),
606 KEY `online` (`online`),
607 KEY `deleted` (`deleted`)
608) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=66 ;
609
610--
611-- Fazendo dump de dados para tabela `players`
612--
613
614INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `lookmount`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `pvp_blessing`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`, `rep`, `show_quests`, `show_skills`, `stars`, `show_bars`, `show_eq`, `show_outfit`, `ip`, `viewers`, `broadcasting`) VALUES
615(1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1536286012, 788266648, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 0, 1, 1, 0, 1, 1, 1, '0', 0, 0),
616(2, 'Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 0, 1, 1, 0, 1, 1, 1, '0', 0, 0),
617(3, 'Sorcerer Sample', 0, 1, 1, 22, 1, 245, 245, 148538, 0, 0, 0, 0, 136, 0, 0, 17, 395, 395, 1209, 12, 2, 32343, 32226, 7, '', 520, 0, 1536689031, 1312510653, 1, 4, 0, 0, '', 1536689075, 0, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 0, 1, 1, 0, 1, 1, 1, '0', 0, 0),
618(4, 'Druid Sample', 0, 1, 1, 10, 2, 185, 185, 9300, 117, 0, 114, 115, 136, 0, 0, 0, 35, 35, 0, 0, 2, 32366, 32235, 7, 0x010004000002ffffffff03007d00001a000000001b00000000fe, 400, 0, 1536689016, 1312510653, 1, 4, 0, 0, '', 1536689020, 0, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 0, 1, 1, 0, 1, 1, 1, '0', 0, 0),
619(5, 'Paladin Sample', 0, 1, 1, 10, 3, 185, 185, 9300, 0, 0, 0, 0, 136, 0, 0, 0, 35, 35, 0, 0, 1, 32369, 32235, 7, 0x010004000002ffffffff0320cb00001a000000001b00000000fe, 400, 0, 1536689024, 1312510653, 1, 4, 0, 0, '', 1536689027, 0, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 0, 1, 1, 0, 1, 1, 1, '0', 0, 0),
620(33, 'GOD Gabriel', 0, 6, 2292277, 10, 3, 185, 185, 9300, 0, 0, 0, 0, 302, 0, 0, 0, 35, 35, 0, 0, 2, 32347, 32226, 7, 0x010000400002ffffffff03ffffffff1a000000001b00000000fe, 400, 1, 1536529410, 788266648, 1, 4, 0, 0, '', 1536529442, 0, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 1536143089, 0, '', 0, 0, '', 0, 1, 1, 0, 1, 1, 1, '0', 0, 0);
621
622--
623-- Gatilhos `players`
624--
625DROP TRIGGER IF EXISTS `oncreate_players`;
626DELIMITER //
627CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
628 FOR EACH ROW BEGIN
629 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
630 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
631 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
632 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
633 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
634 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
635 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
636END
637//
638DELIMITER ;
639DROP TRIGGER IF EXISTS `ondelete_players`;
640DELIMITER //
641CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players`
642 FOR EACH ROW BEGIN
643 DELETE FROM `bans` WHERE `type` IN (2, 5) AND `value` = OLD.`id`;
644 UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
645END
646//
647DELIMITER ;
648
649-- --------------------------------------------------------
650
651--
652-- Estrutura para tabela `player_advances`
653--
654
655CREATE TABLE IF NOT EXISTS `player_advances` (
656 `id` int(11) NOT NULL AUTO_INCREMENT,
657 `cid` int(11) DEFAULT NULL,
658 `skill` int(11) DEFAULT NULL,
659 `oldlevel` int(11) DEFAULT NULL,
660 `newlevel` int(11) DEFAULT NULL,
661 `time` int(11) DEFAULT NULL,
662 UNIQUE KEY `id` (`id`),
663 KEY `cid` (`cid`)
664) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
665
666-- --------------------------------------------------------
667
668--
669-- Estrutura para tabela `player_deaths`
670--
671
672CREATE TABLE IF NOT EXISTS `player_deaths` (
673 `id` int(11) NOT NULL AUTO_INCREMENT,
674 `player_id` int(11) NOT NULL,
675 `date` bigint(20) unsigned NOT NULL,
676 `level` int(10) unsigned NOT NULL,
677 PRIMARY KEY (`id`),
678 KEY `date` (`date`),
679 KEY `player_id` (`player_id`)
680) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
681
682--
683-- Fazendo dump de dados para tabela `player_deaths`
684--
685
686INSERT INTO `player_deaths` (`id`, `player_id`, `date`, `level`) VALUES
687(16, 3, 1536591188, 20),
688(17, 3, 1536591737, 23);
689
690-- --------------------------------------------------------
691
692--
693-- Estrutura para tabela `player_depotitems`
694--
695
696CREATE TABLE IF NOT EXISTS `player_depotitems` (
697 `player_id` int(11) NOT NULL,
698 `sid` int(11) NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
699 `pid` int(11) NOT NULL DEFAULT '0',
700 `itemtype` int(11) NOT NULL,
701 `count` int(11) NOT NULL DEFAULT '0',
702 `attributes` blob NOT NULL,
703 UNIQUE KEY `player_id_2` (`player_id`,`sid`),
704 KEY `player_id` (`player_id`)
705) ENGINE=InnoDB DEFAULT CHARSET=latin1;
706
707-- --------------------------------------------------------
708
709--
710-- Estrutura para tabela `player_inboxitems`
711--
712
713CREATE TABLE IF NOT EXISTS `player_inboxitems` (
714 `player_id` int(11) NOT NULL,
715 `sid` int(11) NOT NULL,
716 `pid` int(11) NOT NULL DEFAULT '0',
717 `itemtype` smallint(6) NOT NULL,
718 `count` smallint(5) NOT NULL DEFAULT '0',
719 `attributes` blob NOT NULL,
720 UNIQUE KEY `player_id_2` (`player_id`,`sid`),
721 KEY `player_id` (`player_id`)
722) ENGINE=InnoDB DEFAULT CHARSET=latin1;
723
724-- --------------------------------------------------------
725
726--
727-- Estrutura para tabela `player_items`
728--
729
730CREATE TABLE IF NOT EXISTS `player_items` (
731 `player_id` int(11) NOT NULL DEFAULT '0',
732 `pid` int(11) NOT NULL DEFAULT '0',
733 `sid` int(11) NOT NULL DEFAULT '0',
734 `itemtype` int(11) NOT NULL DEFAULT '0',
735 `count` int(11) NOT NULL DEFAULT '0',
736 `attributes` blob NOT NULL,
737 UNIQUE KEY `player_id_2` (`player_id`,`sid`),
738 KEY `player_id` (`player_id`)
739) ENGINE=InnoDB DEFAULT CHARSET=latin1;
740
741--
742-- Fazendo dump de dados para tabela `player_items`
743--
744
745INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES
746(3, 1, 101, 2457, 1, ''),
747(3, 3, 102, 1987, 1, ''),
748(3, 4, 103, 2463, 1, ''),
749(3, 5, 104, 2525, 1, ''),
750(3, 6, 105, 2188, 1, ''),
751(3, 7, 106, 2647, 1, ''),
752(3, 8, 107, 2643, 1, ''),
753(3, 9, 108, 2124, 1, ''),
754(4, 1, 101, 2457, 1, ''),
755(4, 2, 102, 2173, 1, 0x8001000700636861726765730201000000),
756(4, 3, 103, 1988, 1, ''),
757(4, 4, 104, 2463, 1, ''),
758(4, 5, 105, 2525, 1, ''),
759(4, 6, 106, 2182, 1, ''),
760(4, 7, 107, 2647, 1, ''),
761(4, 8, 108, 2643, 1, ''),
762(4, 9, 109, 2124, 1, ''),
763(4, 103, 110, 7620, 1, 0x0f01),
764(4, 103, 111, 7618, 1, 0x0f01),
765(4, 103, 112, 2789, 25, 0x0f19),
766(4, 103, 113, 2152, 3, ''),
767(4, 103, 114, 2120, 1, ''),
768(5, 1, 101, 2457, 1, ''),
769(5, 2, 102, 2173, 1, 0x8001000700636861726765730201000000),
770(5, 3, 103, 1988, 1, ''),
771(5, 4, 104, 2463, 1, ''),
772(5, 5, 105, 2525, 1, ''),
773(5, 6, 106, 2389, 3, 0x0f01),
774(5, 7, 107, 2647, 1, ''),
775(5, 8, 108, 2643, 1, ''),
776(5, 9, 109, 2124, 1, ''),
777(5, 103, 110, 2789, 25, 0x0f19),
778(5, 103, 111, 2554, 1, ''),
779(5, 103, 112, 2120, 1, ''),
780(33, 1, 101, 2457, 1, ''),
781(33, 2, 102, 2173, 1, 0x8001000700636861726765730201000000),
782(33, 3, 103, 1988, 1, ''),
783(33, 4, 104, 2463, 1, ''),
784(33, 5, 105, 2525, 1, ''),
785(33, 6, 106, 2389, 1, 0x0f01),
786(33, 7, 107, 2647, 1, ''),
787(33, 8, 108, 2643, 1, ''),
788(33, 9, 109, 2124, 1, ''),
789(33, 103, 110, 2160, 100, 0x0f64),
790(33, 103, 111, 7620, 1, 0x0f01),
791(33, 103, 112, 7618, 1, 0x0f01),
792(33, 103, 113, 2789, 25, 0x0f19),
793(33, 103, 114, 2160, 100, 0x0f64),
794(33, 103, 115, 2554, 1, ''),
795(33, 103, 116, 2120, 1, '');
796
797-- --------------------------------------------------------
798
799--
800-- Estrutura para tabela `player_killers`
801--
802
803CREATE TABLE IF NOT EXISTS `player_killers` (
804 `kill_id` int(11) NOT NULL,
805 `player_id` int(11) NOT NULL,
806 KEY `kill_id` (`kill_id`),
807 KEY `player_id` (`player_id`)
808) ENGINE=InnoDB DEFAULT CHARSET=latin1;
809
810-- --------------------------------------------------------
811
812--
813-- Estrutura para tabela `player_namelocks`
814--
815
816CREATE TABLE IF NOT EXISTS `player_namelocks` (
817 `player_id` int(11) NOT NULL DEFAULT '0',
818 `name` varchar(255) NOT NULL,
819 `new_name` varchar(255) NOT NULL,
820 `date` bigint(20) NOT NULL DEFAULT '0',
821 KEY `player_id` (`player_id`)
822) ENGINE=InnoDB DEFAULT CHARSET=latin1;
823
824-- --------------------------------------------------------
825
826--
827-- Estrutura para tabela `player_skills`
828--
829
830CREATE TABLE IF NOT EXISTS `player_skills` (
831 `player_id` int(11) NOT NULL DEFAULT '0',
832 `skillid` tinyint(2) NOT NULL DEFAULT '0',
833 `value` int(10) unsigned NOT NULL DEFAULT '0',
834 `count` int(10) unsigned NOT NULL DEFAULT '0',
835 UNIQUE KEY `player_id_2` (`player_id`,`skillid`),
836 KEY `player_id` (`player_id`)
837) ENGINE=InnoDB DEFAULT CHARSET=latin1;
838
839--
840-- Fazendo dump de dados para tabela `player_skills`
841--
842
843INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
844(2, 0, 10, 0),
845(2, 1, 10, 0),
846(2, 2, 10, 0),
847(2, 3, 10, 0),
848(2, 4, 10, 0),
849(2, 5, 10, 0),
850(2, 6, 10, 0),
851(3, 0, 10, 0),
852(3, 1, 10, 0),
853(3, 2, 10, 0),
854(3, 3, 10, 0),
855(3, 4, 10, 0),
856(3, 5, 20, 3962),
857(3, 6, 10, 0),
858(4, 0, 10, 0),
859(4, 1, 10, 0),
860(4, 2, 10, 0),
861(4, 3, 10, 0),
862(4, 4, 10, 0),
863(4, 5, 10, 0),
864(4, 6, 10, 0),
865(5, 0, 10, 0),
866(5, 1, 10, 0),
867(5, 2, 10, 0),
868(5, 3, 10, 0),
869(5, 4, 10, 0),
870(5, 5, 10, 0),
871(5, 6, 10, 0),
872(33, 0, 10, 0),
873(33, 1, 10, 0),
874(33, 2, 10, 0),
875(33, 3, 10, 0),
876(33, 4, 10, 0),
877(33, 5, 10, 0),
878(33, 6, 10, 0);
879
880-- --------------------------------------------------------
881
882--
883-- Estrutura para tabela `player_spells`
884--
885
886CREATE TABLE IF NOT EXISTS `player_spells` (
887 `player_id` int(11) NOT NULL,
888 `name` varchar(255) NOT NULL,
889 UNIQUE KEY `player_id_2` (`player_id`,`name`),
890 KEY `player_id` (`player_id`)
891) ENGINE=InnoDB DEFAULT CHARSET=latin1;
892
893-- --------------------------------------------------------
894
895--
896-- Estrutura para tabela `player_statements`
897--
898
899CREATE TABLE IF NOT EXISTS `player_statements` (
900 `id` int(11) NOT NULL AUTO_INCREMENT,
901 `player_id` int(11) NOT NULL,
902 `channel_id` int(11) NOT NULL DEFAULT '0',
903 `text` varchar(255) NOT NULL,
904 `date` bigint(20) NOT NULL DEFAULT '0',
905 PRIMARY KEY (`id`),
906 KEY `player_id` (`player_id`),
907 KEY `channel_id` (`channel_id`)
908) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
909
910--
911-- Fazendo dump de dados para tabela `player_statements`
912--
913
914INSERT INTO `player_statements` (`id`, `player_id`, `channel_id`, `text`, `date`) VALUES
915(15, 3, 0, 'account', 1536540553),
916(16, 3, 0, '!aol', 1536591200);
917
918-- --------------------------------------------------------
919
920--
921-- Estrutura para tabela `player_storage`
922--
923
924CREATE TABLE IF NOT EXISTS `player_storage` (
925 `player_id` int(11) NOT NULL DEFAULT '0',
926 `key` varchar(32) NOT NULL DEFAULT '0',
927 `value` varchar(255) NOT NULL DEFAULT '0',
928 UNIQUE KEY `player_id_2` (`player_id`,`key`),
929 KEY `player_id` (`player_id`)
930) ENGINE=InnoDB DEFAULT CHARSET=latin1;
931
932--
933-- Fazendo dump de dados para tabela `player_storage`
934--
935
936INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES
937(3, '100117', '-1'),
938(3, '100120', '1'),
939(3, '50000', '1'),
940(4, '50000', '1'),
941(5, '50000', '1'),
942(33, '100117', '-1'),
943(33, '50000', '1');
944
945-- --------------------------------------------------------
946
947--
948-- Estrutura para tabela `player_viplist`
949--
950
951CREATE TABLE IF NOT EXISTS `player_viplist` (
952 `player_id` int(11) NOT NULL,
953 `vip_id` int(11) NOT NULL,
954 UNIQUE KEY `player_id_2` (`player_id`,`vip_id`),
955 KEY `player_id` (`player_id`),
956 KEY `vip_id` (`vip_id`)
957) ENGINE=InnoDB DEFAULT CHARSET=latin1;
958
959-- --------------------------------------------------------
960
961--
962-- Estrutura para tabela `server_config`
963--
964
965CREATE TABLE IF NOT EXISTS `server_config` (
966 `config` varchar(35) NOT NULL DEFAULT '',
967 `value` varchar(255) NOT NULL DEFAULT '',
968 UNIQUE KEY `config` (`config`)
969) ENGINE=InnoDB DEFAULT CHARSET=latin1;
970
971--
972-- Fazendo dump de dados para tabela `server_config`
973--
974
975INSERT INTO `server_config` (`config`, `value`) VALUES
976('db_version', '37'),
977('encryption', '2');
978
979-- --------------------------------------------------------
980
981--
982-- Estrutura para tabela `server_motd`
983--
984
985CREATE TABLE IF NOT EXISTS `server_motd` (
986 `id` int(10) unsigned NOT NULL,
987 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
988 `text` text NOT NULL,
989 UNIQUE KEY `id` (`id`,`world_id`)
990) ENGINE=InnoDB DEFAULT CHARSET=latin1;
991
992--
993-- Fazendo dump de dados para tabela `server_motd`
994--
995
996INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES
997(1, 0, 'Welcome to The Forgotten Server!'),
998(2, 0, 'Obrigado por se conectar, esperamos que tenha um bom jogo!');
999
1000-- --------------------------------------------------------
1001
1002--
1003-- Estrutura para tabela `server_record`
1004--
1005
1006CREATE TABLE IF NOT EXISTS `server_record` (
1007 `record` int(11) NOT NULL,
1008 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1009 `timestamp` bigint(20) NOT NULL,
1010 UNIQUE KEY `record` (`record`,`world_id`,`timestamp`)
1011) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1012
1013--
1014-- Fazendo dump de dados para tabela `server_record`
1015--
1016
1017INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES
1018(1, 0, 1470247090),
1019(2, 0, 1536012480),
1020(3, 0, 1536144309),
1021(4, 0, 1536160733),
1022(5, 0, 1536177954),
1023(6, 0, 1536181889),
1024(7, 0, 1536182092),
1025(8, 0, 1536182125);
1026
1027-- --------------------------------------------------------
1028
1029--
1030-- Estrutura para tabela `server_reports`
1031--
1032
1033CREATE TABLE IF NOT EXISTS `server_reports` (
1034 `id` int(11) NOT NULL AUTO_INCREMENT,
1035 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1036 `player_id` int(11) NOT NULL DEFAULT '1',
1037 `posx` int(11) NOT NULL DEFAULT '0',
1038 `posy` int(11) NOT NULL DEFAULT '0',
1039 `posz` int(11) NOT NULL DEFAULT '0',
1040 `timestamp` bigint(20) NOT NULL DEFAULT '0',
1041 `report` text NOT NULL,
1042 `reads` int(11) NOT NULL DEFAULT '0',
1043 PRIMARY KEY (`id`),
1044 KEY `world_id` (`world_id`),
1045 KEY `reads` (`reads`),
1046 KEY `player_id` (`player_id`)
1047) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1048
1049-- --------------------------------------------------------
1050
1051--
1052-- Estrutura para tabela `tiles`
1053--
1054
1055CREATE TABLE IF NOT EXISTS `tiles` (
1056 `id` int(10) unsigned NOT NULL,
1057 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1058 `house_id` int(10) unsigned NOT NULL,
1059 `x` int(5) unsigned NOT NULL,
1060 `y` int(5) unsigned NOT NULL,
1061 `z` tinyint(2) unsigned NOT NULL,
1062 UNIQUE KEY `id` (`id`,`world_id`),
1063 KEY `x` (`x`,`y`,`z`),
1064 KEY `house_id` (`house_id`,`world_id`)
1065) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1066
1067-- --------------------------------------------------------
1068
1069--
1070-- Estrutura para tabela `tile_items`
1071--
1072
1073CREATE TABLE IF NOT EXISTS `tile_items` (
1074 `tile_id` int(10) unsigned NOT NULL,
1075 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1076 `sid` int(11) NOT NULL,
1077 `pid` int(11) NOT NULL DEFAULT '0',
1078 `itemtype` int(11) NOT NULL,
1079 `count` int(11) NOT NULL DEFAULT '0',
1080 `attributes` blob NOT NULL,
1081 UNIQUE KEY `tile_id` (`tile_id`,`world_id`,`sid`),
1082 KEY `sid` (`sid`)
1083) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1084
1085-- --------------------------------------------------------
1086
1087--
1088-- Estrutura para tabela `tile_store`
1089--
1090
1091CREATE TABLE IF NOT EXISTS `tile_store` (
1092 `house_id` int(10) unsigned NOT NULL,
1093 `world_id` tinyint(4) unsigned NOT NULL DEFAULT '0',
1094 `data` longblob NOT NULL,
1095 KEY `house_id` (`house_id`)
1096) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1097
1098-- --------------------------------------------------------
1099
1100--
1101-- Estrutura para tabela `zaypay_payment`
1102--
1103
1104CREATE TABLE IF NOT EXISTS `zaypay_payment` (
1105 `payID` bigint(30) NOT NULL,
1106 `account_id` int(20) NOT NULL,
1107 `status` varchar(255) NOT NULL,
1108 PRIMARY KEY (`payID`)
1109) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1110
1111-- --------------------------------------------------------
1112
1113--
1114-- Estrutura para tabela `z_bug_tracker`
1115--
1116
1117CREATE TABLE IF NOT EXISTS `z_bug_tracker` (
1118 `account` varchar(255) NOT NULL,
1119 `type` int(11) NOT NULL,
1120 `status` int(11) NOT NULL,
1121 `text` text NOT NULL,
1122 `id` int(11) NOT NULL,
1123 `subject` varchar(255) NOT NULL,
1124 `reply` int(11) NOT NULL,
1125 `who` int(11) NOT NULL,
1126 `uid` int(11) NOT NULL AUTO_INCREMENT,
1127 `tag` int(11) NOT NULL,
1128 PRIMARY KEY (`uid`)
1129) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
1130
1131-- --------------------------------------------------------
1132
1133--
1134-- Estrutura para tabela `z_changelog`
1135--
1136
1137CREATE TABLE IF NOT EXISTS `z_changelog` (
1138 `id` int(11) NOT NULL AUTO_INCREMENT,
1139 `type` varchar(255) NOT NULL DEFAULT '',
1140 `where` varchar(255) NOT NULL DEFAULT '',
1141 `date` int(11) NOT NULL DEFAULT '0',
1142 `description` varchar(255) NOT NULL,
1143 PRIMARY KEY (`id`)
1144) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1145
1146-- --------------------------------------------------------
1147
1148--
1149-- Estrutura para tabela `z_forum`
1150--
1151
1152CREATE TABLE IF NOT EXISTS `z_forum` (
1153 `id` int(11) NOT NULL AUTO_INCREMENT,
1154 `sticky` tinyint(1) NOT NULL DEFAULT '0',
1155 `closed` tinyint(1) NOT NULL DEFAULT '0',
1156 `first_post` int(11) NOT NULL DEFAULT '0',
1157 `last_post` int(11) NOT NULL DEFAULT '0',
1158 `section` int(3) NOT NULL DEFAULT '0',
1159 `replies` int(20) NOT NULL DEFAULT '0',
1160 `views` int(20) NOT NULL DEFAULT '0',
1161 `author_aid` int(20) NOT NULL DEFAULT '0',
1162 `author_guid` int(20) NOT NULL DEFAULT '0',
1163 `post_text` text NOT NULL,
1164 `post_topic` varchar(255) NOT NULL,
1165 `post_smile` tinyint(1) NOT NULL DEFAULT '0',
1166 `post_date` int(20) NOT NULL DEFAULT '0',
1167 `last_edit_aid` int(20) NOT NULL DEFAULT '0',
1168 `edit_date` int(20) NOT NULL DEFAULT '0',
1169 `post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
1170 `icon_id` tinyint(4) NOT NULL DEFAULT '1',
1171 PRIMARY KEY (`id`),
1172 KEY `section` (`section`)
1173) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
1174
1175-- --------------------------------------------------------
1176
1177--
1178-- Estrutura para tabela `z_monsters`
1179--
1180
1181CREATE TABLE IF NOT EXISTS `z_monsters` (
1182 `hide_creature` tinyint(1) NOT NULL DEFAULT '0',
1183 `name` varchar(255) NOT NULL,
1184 `mana` int(11) NOT NULL,
1185 `exp` int(11) NOT NULL,
1186 `health` int(11) NOT NULL,
1187 `speed_lvl` int(11) NOT NULL DEFAULT '1',
1188 `use_haste` tinyint(1) NOT NULL,
1189 `voices` text NOT NULL,
1190 `immunities` varchar(255) NOT NULL,
1191 `summonable` tinyint(1) NOT NULL,
1192 `convinceable` tinyint(1) NOT NULL,
1193 `race` varchar(255) NOT NULL,
1194 `gfx_name` varchar(255) NOT NULL
1195) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1196
1197--
1198-- Fazendo dump de dados para tabela `z_monsters`
1199--
1200
1201
1202-- --------------------------------------------------------
1203
1204--
1205-- Estrutura para tabela `z_news_tickers`
1206--
1207
1208CREATE TABLE IF NOT EXISTS `z_news_tickers` (
1209 `date` int(11) NOT NULL DEFAULT '1',
1210 `author` int(11) NOT NULL,
1211 `image_id` int(3) NOT NULL DEFAULT '0',
1212 `text` text NOT NULL,
1213 `hide_ticker` tinyint(1) NOT NULL
1214) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1215
1216--
1217-- Fazendo dump de dados para tabela `z_news_tickers`
1218--
1219
1220INSERT INTO `z_news_tickers` (`date`, `author`, `image_id`, `text`, `hide_ticker`) VALUES
1221(1274867862, 1, 1, 'Site online e funcional!', 1),
1222(1536380063, 2292277, 3, 'Server Funcionando', 0);
1223
1224-- --------------------------------------------------------
1225
1226--
1227-- Estrutura para tabela `z_ots_comunication`
1228--
1229
1230CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
1231 `id` int(11) NOT NULL AUTO_INCREMENT,
1232 `name` varchar(255) NOT NULL,
1233 `type` varchar(255) NOT NULL,
1234 `action` varchar(255) NOT NULL,
1235 `param1` varchar(255) NOT NULL,
1236 `param2` varchar(255) NOT NULL,
1237 `param3` varchar(255) NOT NULL,
1238 `param4` varchar(255) NOT NULL,
1239 `param5` varchar(255) NOT NULL,
1240 `param6` varchar(255) NOT NULL,
1241 `param7` varchar(255) NOT NULL,
1242 `delete_it` int(2) NOT NULL DEFAULT '1',
1243 PRIMARY KEY (`id`)
1244) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
1245
1246-- --------------------------------------------------------
1247
1248--
1249-- Estrutura para tabela `z_polls`
1250--
1251
1252CREATE TABLE IF NOT EXISTS `z_polls` (
1253 `id` int(11) NOT NULL AUTO_INCREMENT,
1254 `question` varchar(255) NOT NULL,
1255 `end` int(11) NOT NULL,
1256 `start` int(11) NOT NULL,
1257 `answers` int(11) NOT NULL,
1258 `votes_all` int(11) NOT NULL,
1259 PRIMARY KEY (`id`)
1260) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1261
1262-- --------------------------------------------------------
1263
1264--
1265-- Estrutura para tabela `z_polls_answers`
1266--
1267
1268CREATE TABLE IF NOT EXISTS `z_polls_answers` (
1269 `poll_id` int(11) NOT NULL,
1270 `answer_id` int(11) NOT NULL,
1271 `answer` varchar(255) NOT NULL,
1272 `votes` int(11) NOT NULL
1273) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1274
1275-- --------------------------------------------------------
1276
1277--
1278-- Estrutura para tabela `z_shop_history_item`
1279--
1280
1281CREATE TABLE IF NOT EXISTS `z_shop_history_item` (
1282 `id` int(11) NOT NULL AUTO_INCREMENT,
1283 `to_name` varchar(255) NOT NULL DEFAULT '0',
1284 `to_account` int(11) NOT NULL DEFAULT '0',
1285 `from_nick` varchar(255) NOT NULL,
1286 `from_account` int(11) NOT NULL DEFAULT '0',
1287 `price` int(11) NOT NULL DEFAULT '0',
1288 `offer_id` int(11) NOT NULL DEFAULT '0',
1289 `trans_state` varchar(255) NOT NULL,
1290 `trans_start` int(11) NOT NULL DEFAULT '0',
1291 `trans_real` int(11) NOT NULL DEFAULT '0',
1292 PRIMARY KEY (`id`)
1293) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
1294
1295--
1296-- Fazendo dump de dados para tabela `z_shop_history_item`
1297--
1298
1299INSERT INTO `z_shop_history_item` (`id`, `to_name`, `to_account`, `from_nick`, `from_account`, `price`, `offer_id`, `trans_state`, `trans_start`, `trans_real`) VALUES
1300(1, 'Administer', 5028381, '', 5028381, 10, 0, 'realized', 1274909244, 1274909270),
1301(2, 'Administer', 5028381, '', 5028381, 10, 0, 'realized', 1274909252, 1274909270),
1302(3, 'Administer', 5028381, '', 5028381, 10, 0, 'realized', 1274909260, 1274909270),
1303(4, 'Administer', 5028381, '', 5028381, 10, 0, 'realized', 1274909294, 1274909301),
1304(5, 'Administer', 5028381, '', 5028381, 10, 0, 'realized', 1274909300, 1274909301),
1305(6, 'Administer', 5028381, '', 5028381, 10, 0, 'realized', 1274909488, 1274909518),
1306(7, 'Administer', 5028381, '', 5028381, 10, 0, 'realized', 1274912368, 1274975030);
1307
1308-- --------------------------------------------------------
1309
1310--
1311-- Estrutura para tabela `z_shop_history_pacc`
1312--
1313
1314CREATE TABLE IF NOT EXISTS `z_shop_history_pacc` (
1315 `id` int(11) NOT NULL AUTO_INCREMENT,
1316 `to_name` varchar(255) NOT NULL DEFAULT '0',
1317 `to_account` int(11) NOT NULL DEFAULT '0',
1318 `from_nick` varchar(255) NOT NULL,
1319 `from_account` int(11) NOT NULL DEFAULT '0',
1320 `price` int(11) NOT NULL DEFAULT '0',
1321 `pacc_days` int(11) NOT NULL DEFAULT '0',
1322 `trans_state` varchar(255) NOT NULL,
1323 `trans_start` int(11) NOT NULL DEFAULT '0',
1324 `trans_real` int(11) NOT NULL DEFAULT '0',
1325 PRIMARY KEY (`id`)
1326) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
1327
1328--
1329-- Fazendo dump de dados para tabela `z_shop_history_pacc`
1330--
1331
1332INSERT INTO `z_shop_history_pacc` (`id`, `to_name`, `to_account`, `from_nick`, `from_account`, `price`, `pacc_days`, `trans_state`, `trans_start`, `trans_real`) VALUES
1333(1, 'Testadr', 4865579, '', 4865579, 1, 3, 'realized', 1536378242, 1536378242);
1334
1335-- --------------------------------------------------------
1336
1337--
1338-- Estrutura para tabela `z_shop_offer`
1339--
1340
1341CREATE TABLE IF NOT EXISTS `z_shop_offer` (
1342 `id` int(11) NOT NULL AUTO_INCREMENT,
1343 `points` int(11) NOT NULL DEFAULT '0',
1344 `itemid1` int(11) NOT NULL DEFAULT '0',
1345 `count1` int(11) NOT NULL DEFAULT '0',
1346 `itemid2` int(11) NOT NULL DEFAULT '0',
1347 `count2` int(11) NOT NULL DEFAULT '0',
1348 `offer_type` varchar(255) DEFAULT NULL,
1349 `offer_description` text NOT NULL,
1350 `offer_name` varchar(255) NOT NULL,
1351 `pid` int(11) NOT NULL DEFAULT '0',
1352 PRIMARY KEY (`id`)
1353) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
1354
1355--
1356-- Fazendo dump de dados para tabela `z_shop_offer`
1357--
1358
1359INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`, `pid`) VALUES
1360(3, 5, 0, 10, 0, 0, 'pacc', 'Adiciona 10 dias de premium à sua conta.', '10 Dias Premium', 0),
1361(4, 10, 0, 30, 0, 0, 'pacc', 'Adiciona 30 dias de premium à sua conta.', '30 Dias Premium', 0),
1362(5, 1, 1996, 1, 0, 0, 'item', 'Bag teste', 'Gray Bag', 0);
1363
1364-- --------------------------------------------------------
1365
1366--
1367-- Estrutura para tabela `z_spells`
1368--
1369
1370CREATE TABLE IF NOT EXISTS `z_spells` (
1371 `name` varchar(255) NOT NULL,
1372 `spell` varchar(255) NOT NULL,
1373 `spell_type` varchar(255) NOT NULL,
1374 `mana` int(11) NOT NULL DEFAULT '0',
1375 `lvl` int(11) NOT NULL DEFAULT '0',
1376 `mlvl` int(11) NOT NULL DEFAULT '0',
1377 `soul` int(11) NOT NULL DEFAULT '0',
1378 `pacc` varchar(255) NOT NULL,
1379 `vocations` varchar(255) NOT NULL,
1380 `conj_count` int(11) NOT NULL DEFAULT '0',
1381 `hide_spell` int(11) NOT NULL DEFAULT '0'
1382) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1383
1384--
1385-- Restrições para dumps de tabelas
1386--
1387
1388--
1389-- Restrições para tabelas `account_viplist`
1390--
1391ALTER TABLE `account_viplist`
1392 ADD CONSTRAINT `account_viplist_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
1393 ADD CONSTRAINT `account_viplist_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1394
1395--
1396-- Restrições para tabelas `environment_killers`
1397--
1398ALTER TABLE `environment_killers`
1399 ADD CONSTRAINT `environment_killers_ibfk_1` FOREIGN KEY (`kill_id`) REFERENCES `killers` (`id`) ON DELETE CASCADE;
1400
1401--
1402-- Restrições para tabelas `guild_invites`
1403--
1404ALTER TABLE `guild_invites`
1405 ADD CONSTRAINT `guild_invites_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
1406 ADD CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
1407
1408--
1409-- Restrições para tabelas `guild_kills`
1410--
1411ALTER TABLE `guild_kills`
1412 ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
1413 ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
1414 ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
1415
1416--
1417-- Restrições para tabelas `guild_ranks`
1418--
1419ALTER TABLE `guild_ranks`
1420 ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
1421
1422--
1423-- Restrições para tabelas `guild_wars`
1424--
1425ALTER TABLE `guild_wars`
1426 ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
1427 ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
1428
1429--
1430-- Restrições para tabelas `house_auctions`
1431--
1432ALTER TABLE `house_auctions`
1433 ADD CONSTRAINT `house_auctions_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE,
1434 ADD CONSTRAINT `house_auctions_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1435
1436--
1437-- Restrições para tabelas `house_data`
1438--
1439ALTER TABLE `house_data`
1440 ADD CONSTRAINT `house_data_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;
1441
1442--
1443-- Restrições para tabelas `house_lists`
1444--
1445ALTER TABLE `house_lists`
1446 ADD CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;
1447
1448--
1449-- Restrições para tabelas `killers`
1450--
1451ALTER TABLE `killers`
1452 ADD CONSTRAINT `killers_ibfk_1` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE;
1453
1454--
1455-- Restrições para tabelas `login_history`
1456--
1457ALTER TABLE `login_history`
1458 ADD CONSTRAINT `login_history_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`);
1459
1460--
1461-- Restrições para tabelas `market_history`
1462--
1463ALTER TABLE `market_history`
1464 ADD CONSTRAINT `market_history_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1465
1466--
1467-- Restrições para tabelas `market_offers`
1468--
1469ALTER TABLE `market_offers`
1470 ADD CONSTRAINT `market_offers_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1471
1472--
1473-- Restrições para tabelas `players`
1474--
1475ALTER TABLE `players`
1476 ADD CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;
1477
1478--
1479-- Restrições para tabelas `player_advances`
1480--
1481ALTER TABLE `player_advances`
1482 ADD CONSTRAINT `player_advances_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
1483
1484--
1485-- Restrições para tabelas `player_deaths`
1486--
1487ALTER TABLE `player_deaths`
1488 ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1489
1490--
1491-- Restrições para tabelas `player_depotitems`
1492--
1493ALTER TABLE `player_depotitems`
1494 ADD CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1495
1496--
1497-- Restrições para tabelas `player_inboxitems`
1498--
1499ALTER TABLE `player_inboxitems`
1500 ADD CONSTRAINT `player_inboxitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1501
1502--
1503-- Restrições para tabelas `player_items`
1504--
1505ALTER TABLE `player_items`
1506 ADD CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1507
1508--
1509-- Restrições para tabelas `player_killers`
1510--
1511ALTER TABLE `player_killers`
1512 ADD CONSTRAINT `player_killers_ibfk_1` FOREIGN KEY (`kill_id`) REFERENCES `killers` (`id`) ON DELETE CASCADE,
1513 ADD CONSTRAINT `player_killers_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1514
1515--
1516-- Restrições para tabelas `player_namelocks`
1517--
1518ALTER TABLE `player_namelocks`
1519 ADD CONSTRAINT `player_namelocks_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1520
1521--
1522-- Restrições para tabelas `player_skills`
1523--
1524ALTER TABLE `player_skills`
1525 ADD CONSTRAINT `player_skills_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1526
1527--
1528-- Restrições para tabelas `player_spells`
1529--
1530ALTER TABLE `player_spells`
1531 ADD CONSTRAINT `player_spells_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1532
1533--
1534-- Restrições para tabelas `player_statements`
1535--
1536ALTER TABLE `player_statements`
1537 ADD CONSTRAINT `player_statements_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1538
1539--
1540-- Restrições para tabelas `player_storage`
1541--
1542ALTER TABLE `player_storage`
1543 ADD CONSTRAINT `player_storage_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1544
1545--
1546-- Restrições para tabelas `player_viplist`
1547--
1548ALTER TABLE `player_viplist`
1549 ADD CONSTRAINT `player_viplist_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
1550 ADD CONSTRAINT `player_viplist_ibfk_2` FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1551
1552--
1553-- Restrições para tabelas `server_reports`
1554--
1555ALTER TABLE `server_reports`
1556 ADD CONSTRAINT `server_reports_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1557
1558--
1559-- Restrições para tabelas `tiles`
1560--
1561ALTER TABLE `tiles`
1562 ADD CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;
1563
1564--
1565-- Restrições para tabelas `tile_items`
1566--
1567ALTER TABLE `tile_items`
1568 ADD CONSTRAINT `tile_items_ibfk_1` FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE;
1569
1570--
1571-- Restrições para tabelas `tile_store`
1572--
1573ALTER TABLE `tile_store`
1574 ADD CONSTRAINT `tile_store_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE;
1575
1576/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1577/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1578/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;