DATABASE RESETADA OFICIAL.sql

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

DATABASE RESETADA OFICIAL.sql
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Jul 25, 2015 as 04:34 
-- Versão do Servidor: 5.1.41
-- Versão do PHP: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Banco de Dados: `wodbo`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(32) NOT NULL DEFAULT '',
 `password` varchar(255) NOT NULL,
 `salt` varchar(40) NOT NULL DEFAULT '',
 `premdays` int(11) NOT NULL DEFAULT '0',
 `lastday` int(10) unsigned NOT NULL DEFAULT '0',
 `email` varchar(255) NOT NULL DEFAULT '',
 `key` varchar(32) NOT NULL DEFAULT '0',
 `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
 `warnings` int(11) NOT NULL DEFAULT '0',
 `group_id` int(11) NOT NULL DEFAULT '1',
 `email_new` varchar(255) NOT NULL DEFAULT '',
 `email_new_time` int(11) NOT NULL DEFAULT '0',
 `rlname` varchar(255) NOT NULL DEFAULT '',
 `location` varchar(255) NOT NULL DEFAULT '',
 `page_access` int(11) NOT NULL DEFAULT '0',
 `email_code` varchar(255) NOT NULL DEFAULT '',
 `next_email` int(11) NOT NULL DEFAULT '0',
 `premium_points` int(11) NOT NULL DEFAULT '0',
 `create_date` int(11) NOT NULL DEFAULT '0',
 `create_ip` int(11) NOT NULL DEFAULT '0',
 `last_post` int(11) NOT NULL DEFAULT '0',
 `flag` varchar(80) NOT NULL DEFAULT '',
 `vote` int(11) NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Extraindo dados da tabela `accounts`
--
INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `email_new`, `email_new_time`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `create_date`, `create_ip`, `last_post`, `flag`, `vote`) VALUES
(1, '1', '514f0c1a5e675d08e98eb6899effdce80bb5b494', '', 65535, 1437852761, '', '0', 0, 0, 1, '', 0, '', '', 3, '', 0, 0, 0, 0, 0, 'unknown', 0),
(12, '210197', 'aa543cd445456ffed7d03133b12075072a3ecaef', '', 23, 1437852761, 'bruno213@live.com', '', 0, 0, 1, '', 0, '', '', 6, '', 0, 0, 1436793491, -1283561320, 0, 'br', 0);
--
-- Gatilhos `accounts`
--
DROP TRIGGER IF EXISTS `ondelete_accounts`;
DELIMITER //
CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`
 FOR EACH ROW BEGIN
	DELETE FROM `bans` WHERE `type` IN (3, 4) AND `value` = OLD.`id`;
END
//
DELIMITER ;
-- --------------------------------------------------------
--
-- Estrutura da tabela `account_viplist`
--
CREATE TABLE IF NOT EXISTS `account_viplist` (
 `account_id` int(11) NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `player_id` int(11) NOT NULL,
 UNIQUE KEY `account_id_2` (`account_id`,`player_id`),
 KEY `account_id` (`account_id`),
 KEY `player_id` (`player_id`),
 KEY `world_id` (`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `account_viplist`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
 `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
 `param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)',
 `active` tinyint(1) NOT NULL DEFAULT '1',
 `expires` int(11) NOT NULL,
 `added` int(10) unsigned NOT NULL,
 `admin_id` int(10) unsigned NOT NULL DEFAULT '0',
 `comment` text NOT NULL,
 `reason` int(10) unsigned NOT NULL DEFAULT '0',
 `action` int(10) unsigned NOT NULL DEFAULT '0',
 `statement` varchar(255) NOT NULL DEFAULT '',
 PRIMARY KEY (`id`),
 KEY `type` (`type`,`value`),
 KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Extraindo dados da tabela `bans`
--
INSERT INTO `bans` (`id`, `type`, `value`, `param`, `active`, `expires`, `added`, `admin_id`, `comment`, `reason`, `action`, `statement`) VALUES
(1, 2, 63, 2, 1, -1, 1437057538, 32, 'namelock xD', 0, 1, '');
-- --------------------------------------------------------
--
-- Estrutura da tabela `environment_killers`
--
CREATE TABLE IF NOT EXISTS `environment_killers` (
 `kill_id` int(11) NOT NULL,
 `name` varchar(255) NOT NULL,
 KEY `kill_id` (`kill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `environment_killers`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `global_storage`
--
CREATE TABLE IF NOT EXISTS `global_storage` (
 `key` varchar(32) NOT NULL DEFAULT '0',
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `value` varchar(255) NOT NULL DEFAULT '0',
 UNIQUE KEY `key` (`key`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `global_storage`
--
INSERT INTO `global_storage` (`key`, `world_id`, `value`) VALUES
('0', 0, '-1'),
('1000', 0, '56'),
('140120', 0, '0'),
('140121', 0, '0'),
('180400', 0, '0'),
('34370', 0, '0'),
('34371', 0, '2'),
('34372', 0, '0'),
('34373', 0, '0'),
('runEventJoining', 0, '-1');
-- --------------------------------------------------------
--
-- Estrutura da tabela `guilds`
--
CREATE TABLE IF NOT EXISTS `guilds` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `name` varchar(255) NOT NULL,
 `ownerid` int(11) NOT NULL,
 `creationdata` int(11) NOT NULL,
 `checkdata` int(11) NOT NULL,
 `motd` varchar(255) NOT NULL,
 `balance` bigint(20) unsigned NOT NULL,
 `description` text NOT NULL,
 `guild_logo` mediumblob,
 `create_ip` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Extraindo dados da tabela `guilds`
--
--
-- Gatilhos `guilds`
--
DROP TRIGGER IF EXISTS `oncreate_guilds`;
DELIMITER //
CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds`
 FOR EACH ROW BEGIN
	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);
	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `ondelete_guilds`;
DELIMITER //
CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds`
 FOR EACH ROW BEGIN
	UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
END
//
DELIMITER ;
-- --------------------------------------------------------
--
-- Estrutura da tabela `guild_invites`
--
CREATE TABLE IF NOT EXISTS `guild_invites` (
 `player_id` int(11) NOT NULL DEFAULT '0',
 `guild_id` int(11) NOT NULL DEFAULT '0',
 UNIQUE KEY `player_id` (`player_id`,`guild_id`),
 KEY `guild_id` (`guild_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `guild_invites`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `guild_kills`
--
CREATE TABLE IF NOT EXISTS `guild_kills` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `guild_id` int(11) NOT NULL,
 `war_id` int(11) NOT NULL,
 `death_id` int(11) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `guild_kills_ibfk_1`
(`war_id`),
 KEY `guild_kills_ibfk_2` (`death_id`),
 KEY `guild_kills_ibfk_3` (`guild_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Extraindo dados da tabela `guild_kills`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `guild_ranks`
--
CREATE TABLE IF NOT EXISTS `guild_ranks` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `guild_id` int(11) NOT NULL,
 `name` varchar(255) NOT NULL,
 `level` int(11) NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
 PRIMARY KEY (`id`),
 KEY `guild_id` (`guild_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Extraindo dados da tabela `guild_ranks`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `guild_wars`
--
CREATE TABLE IF NOT EXISTS `guild_wars` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `guild_id` int(11) NOT NULL,
 `enemy_id` int(11) NOT NULL,
 `begin` bigint(20) NOT NULL DEFAULT '0',
 `end` bigint(20) NOT NULL DEFAULT '0',
 `frags` int(10) unsigned NOT NULL DEFAULT '0',
 `payment` bigint(20) unsigned NOT NULL DEFAULT '0',
 `guild_kills` int(10) unsigned NOT NULL DEFAULT '0',
 `enemy_kills` int(10) unsigned NOT NULL DEFAULT '0',
 `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `status` (`status`),
 KEY `guild_id` (`guild_id`),
 KEY `enemy_id` (`enemy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Extraindo dados da tabela `guild_wars`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `houses`
--
CREATE TABLE IF NOT EXISTS `houses` (
 `id` int(10) unsigned NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `owner` int(11) NOT NULL,
 `paid` int(10) unsigned NOT NULL DEFAULT '0',
 `warnings` int(11) NOT NULL DEFAULT '0',
 `lastwarning` int(10) unsigned NOT NULL DEFAULT '0',
 `name` varchar(255) NOT NULL,
 `town` int(10) unsigned NOT NULL DEFAULT '0',
 `size` int(10) unsigned NOT NULL DEFAULT '0',
 `price` int(10) unsigned NOT NULL DEFAULT '0',
 `rent` int(10) unsigned NOT NULL DEFAULT '0',
 `doors` int(10) unsigned NOT NULL DEFAULT '0',
 `beds` int(10) unsigned NOT NULL DEFAULT '0',
 `tiles` int(10) unsigned NOT NULL DEFAULT '0',
 `guild` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `clear` tinyint(1) unsigned NOT NULL DEFAULT '0',
 UNIQUE KEY `id` (`id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `houses`
--
INSERT INTO `houses` (`id`, `world_id`, `owner`, `paid`, `warnings`, `lastwarning`, `name`, `town`, `size`, `price`, `rent`, `doors`, `beds`, `tiles`, `guild`, `clear`) VALUES
(1, 0, 41, 0, 0, 1436805918, 'Unnamed House #1', 1, 57, 850000, 0, 1, 2, 85, 0, 0),
(2, 0, 0, 0, 0, 0, 'Unnamed House #2', 1, 23, 360000, 0, 1, 2, 36, 0, 0),
(3, 0, 0, 0, 0, 0, 'Unnamed House #3', 1, 23, 360000, 0, 1, 2, 36, 0, 0),
(4, 0, 0, 0, 0, 0, 'Unnamed House #4', 1, 23, 360000, 0, 1, 2, 36, 0, 0),
(5, 0, 0, 0, 0, 0, 'Unnamed House #5', 1, 23, 360000, 0, 1, 2, 36, 0, 0),
(6, 0, 0, 0, 0, 0, 'Unnamed House #6', 1, 18, 300000, 0, 1, 2, 30, 0, 0),
(7, 0, 0, 0, 0, 0, 'Unnamed House #7', 1, 18, 300000, 0, 1, 2, 30, 0, 0),
(8, 0, 0, 0, 0, 0, 'Unnamed House #8', 1, 14, 250000, 0, 1, 2, 25, 0, 0),
(9, 0, 0, 0, 0, 0, 'Unnamed House #9', 1, 14, 250000, 0, 1, 2, 25, 0, 0),
(10, 0, 0, 0, 0, 0, 'Unnamed House #10', 1, 52, 710000, 0, 1, 2, 71, 0, 0),
(11, 0, 0, 0, 0, 0, 'Unnamed House #11', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(12, 0, 0, 0, 0, 0, 'Unnamed House #12', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(13, 0, 0, 0, 0, 0, 'Unnamed House #13', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(14, 0, 0, 0, 0, 0, 'Unnamed House #14', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(15, 0, 0, 0, 0, 0, 'Unnamed House #15', 1, 10, 210000, 0, 1, 2, 21, 0, 0),
(16, 0, 0, 0, 0, 0, 'Unnamed House #16', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(17, 0, 0, 0, 0, 0, 'Unnamed House #17', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(18, 0, 0, 0, 0, 0, 'Unnamed House #18', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(19, 0, 0, 0, 0, 0, 'Unnamed House #19', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(20, 0, 0, 0, 0, 0, 'Unnamed House #20', 1, 14, 260000, 0, 1, 2, 26, 0, 0),
(21, 0, 0, 0, 0, 0, 'Unnamed House #21', 1, 18, 310000, 0, 1, 2, 31, 0, 0),
(22, 0, 0, 0, 0, 0, 'Unnamed House #22', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(23, 0, 0, 0, 0, 0, 'Unnamed House #23', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(24, 0, 0, 0, 0, 0, 'Unnamed House #24', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(25, 0, 0, 0, 0, 0, 'Unnamed House #25', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(26, 0, 0, 0, 0, 0, 'Unnamed House #26', 1, 14, 260000, 0, 1, 2, 26, 0, 0),
(27, 0, 0, 0, 0, 0, 'Unnamed House #27', 1, 18, 310000, 0, 1, 2, 31, 0, 0),
(28, 0, 0, 0, 0, 0, 'Unnamed House #28', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(29, 0, 0, 0, 0, 0, 'Unnamed House #29', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(30, 0, 0, 0, 0, 0, 'Unnamed House #30', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(31, 0, 0, 0, 0, 0, 'Unnamed House #31', 1, 10, 200000, 0, 1, 2, 20, 0, 0),
(32, 0, 0, 0, 0, 0, 'Unnamed House #32', 1, 14, 230000, 0, 1, 2, 23, 0, 0),
(33, 0, 0, 0, 0, 0, 'Unnamed House #33', 1, 18, 310000, 0, 1, 2, 31, 0, 0),
(34, 0, 0, 0, 0, 0, 'Unnamed House #34', 1, 13, 240000, 0, 1, 2, 24, 0, 0),
(35, 0, 0, 0, 0, 0, 'Unnamed House #35', 1, 13, 240000, 0, 1, 2, 24, 0, 0),
(36, 0, 0, 0, 0, 0, 'Unnamed House #36', 1, 13, 240000, 0, 0, 2, 24, 0, 0),
(37, 0, 0, 0, 0, 0, 'Unnamed House #37', 1, 13, 240000, 0, 0, 2, 24, 0, 0),
(38, 0, 0, 0, 0, 0, 'Unnamed House #38', 1, 13, 240000, 0, 1, 2, 24, 0, 0),
(39, 0, 0, 0, 0, 0, 'Unnamed House #39', 1, 13, 240000, 0, 1, 2, 24, 0, 0),
(40, 0, 0, 0, 0, 0, 'Unnamed House #40', 1, 13, 250000, 0, 1, 2, 25, 0, 0),
(41, 0, 0, 0, 0, 0, 'Unnamed House #41', 1, 13, 250000, 0, 1, 2, 25, 0, 0),
(42, 0, 0, 0, 0, 0, 'Unnamed House #42', 1, 8, 180000, 0, 1, 2, 18, 0, 0),
(43, 0, 0, 0, 0, 0, 'Unnamed House #43', 1, 13, 240000, 0, 1, 2, 24, 0, 0),
(44, 0, 0, 0, 0, 0, 'Unnamed House #44', 1, 18, 330000, 0, 1, 2, 33, 0, 0),
(45, 0, 0, 0, 0, 0, 'Unnamed House #45', 1, 18, 300000, 0, 1, 2, 30, 0, 0),
(46, 0, 0, 0, 0, 0, 'Unnamed House #46', 1, 18, 300000, 0, 1, 2, 30, 0, 0),
(47, 0, 0, 0, 0, 0, 'Unnamed House #47', 1, 16, 300000, 0, 1, 2, 30, 0, 0),
(48, 0, 0, 0, 0, 0, 'Unnamed House #48', 1, 16, 300000, 0, 1, 2, 30, 0, 0),
(49, 0, 55, 0, 0, 1436811077, 'Unnamed House #49', 1, 47, 730000, 0, 1, 2, 73, 0, 0),
(50, 0, 64, 0, 0, 1436957153, 'Unnamed House #50', 1, 47, 730000, 0, 1, 2, 73, 0, 0),
(51, 0, 0, 0, 0, 0, 'Unnamed House #51', 1, 47, 730000, 0, 1, 2, 73, 0, 0),
(52, 0, 0, 0, 0, 0, 'Unnamed House #52', 1, 48, 740000, 0, 1, 2, 74, 0, 0),
(53, 0, 0, 0, 0, 0, 'Unnamed House #53', 1, 45, 650000, 0, 1, 4, 65, 0, 0),
(54, 0, 0, 0, 0, 0, 'Unnamed House #54', 1, 45, 650000, 0, 1, 4, 65, 0, 0),
(55, 0, 0, 0, 0, 0, 'Unnamed House #55', 1, 45, 650000, 0, 1, 4, 65, 0, 0),
(56, 0, 0, 0, 0, 0, 'Unnamed House #56', 1, 45, 640000, 0, 1, 4, 64, 0, 0),
(57, 0, 0, 0, 0, 0, 'Unnamed House #57', 1, 45, 640000, 0, 1, 4, 64, 0, 0),
(58, 0, 0, 0, 0, 0, 'Unnamed House #58', 1, 45, 640000, 0, 1, 4, 64, 0, 0),
(59, 0, 0, 0, 0, 0, 'Unnamed House #59', 1, 18, 300000, 0, 1, 2, 30, 0, 0),
(60, 0, 0, 0, 0, 0, 'Unnamed House #60', 1, 18, 300000, 0, 1, 2, 30, 0, 0),
(61, 0, 0, 0, 0, 0, 'Unnamed House #61', 1, 64, 870000, 0, 1, 4, 87, 0, 0),
(62, 0, 0, 0, 0, 0, 'Unnamed House #62', 1, 61, 840000, 0, 1, 4, 84, 0, 0),
(63, 0, 0, 0, 0, 0, 'Unnamed House #63', 1, 68, 920000, 0, 1, 4, 92, 0, 0),
(64, 0, 0, 0, 0, 0, 'Unnamed House #64', 1, 56, 770000, 0, 1, 4, 77, 0, 0),
(65, 0, 0, 0, 0, 0, 'Unnamed House #65', 1, 57, 850000, 0, 1, 2, 85, 0, 0),
(66, 0, 0, 0, 0, 0, 'Unnamed House #66', 1, 22, 360000, 0, 1, 2, 36, 0, 0),
(67, 0, 0, 0, 0, 0, 'Unnamed House #67', 1, 26, 410000, 0, 1, 2, 41, 0, 0),
(68, 0, 0, 0, 0, 0, 'Unnamed House #68', 1, 26, 400000, 0, 1, 2, 40, 0, 0),
(69, 0, 0, 0, 0, 0, 'Unnamed
House #69', 1, 22, 350000, 0, 1, 2, 35, 0, 0),
(70, 0, 0, 0, 0, 0, 'Unnamed House #70', 1, 22, 360000, 0, 1, 2, 36, 0, 0),
(71, 0, 0, 0, 0, 0, 'Unnamed House #71', 1, 22, 360000, 0, 1, 2, 36, 0, 0),
(72, 0, 0, 0, 0, 0, 'Unnamed House #72', 1, 22, 350000, 0, 1, 2, 35, 0, 0),
(73, 0, 0, 0, 0, 0, 'Unnamed House #73', 1, 22, 350000, 0, 1, 2, 35, 0, 0),
(74, 0, 0, 0, 0, 0, 'Unnamed House #74', 1, 18, 300000, 0, 1, 2, 30, 0, 0),
(75, 0, 0, 0, 0, 0, 'Unnamed House #75', 1, 22, 350000, 0, 1, 2, 35, 0, 0),
(76, 0, 0, 0, 0, 0, 'Unnamed House #76', 1, 48, 700000, 0, 1, 2, 70, 0, 0),
(78, 0, 0, 0, 0, 0, 'Unnamed House #78', 1, 52, 800000, 0, 1, 2, 80, 0, 0),
(79, 0, 0, 0, 0, 0, 'Unnamed House #79', 1, 52, 800000, 0, 1, 2, 80, 0, 0),
(80, 0, 0, 0, 0, 0, 'Unnamed House #80', 1, 52, 800000, 0, 1, 2, 80, 0, 0),
(81, 0, 0, 0, 0, 0, 'Unnamed House #81', 1, 102, 1600000, 0, 2, 6, 160, 0, 0),
(82, 0, 0, 0, 0, 0, 'Unnamed House #82', 1, 102, 1600000, 0, 2, 6, 160, 0, 0),
(83, 0, 0, 0, 0, 0, 'Unnamed House #83', 1, 102, 1600000, 0, 2, 6, 160, 0, 0),
(84, 0, 0, 0, 0, 0, 'Unnamed House #84', 1, 52, 800000, 0, 1, 2, 80, 0, 0),
(85, 0, 0, 0, 0, 0, 'Unnamed House #85', 2, 13, 240000, 0, 1, 2, 24, 0, 0),
(86, 0, 0, 0, 0, 0, 'Unnamed House #86', 2, 13, 250000, 0, 1, 2, 25, 0, 0),
(87, 0, 0, 0, 0, 0, 'Unnamed House #87', 2, 25, 390000, 0, 1, 2, 39, 0, 0),
(88, 0, 0, 0, 0, 0, 'Unnamed House #88', 2, 10, 200000, 0, 1, 2, 20, 0, 0),
(89, 0, 0, 0, 0, 0, 'Unnamed House #89', 2, 10, 200000, 0, 1, 2, 20, 0, 0),
(90, 0, 0, 0, 0, 0, 'Unnamed House #90', 2, 10, 210000, 0, 1, 2, 21, 0, 0),
(91, 0, 0, 0, 0, 0, 'Unnamed House #91', 2, 10, 210000, 0, 1, 2, 21, 0, 0),
(92, 0, 0, 0, 0, 0, 'Unnamed House #92', 2, 16, 280000, 0, 2, 2, 28, 0, 0),
(94, 0, 0, 0, 0, 0, 'Unnamed House #94', 2, 22, 350000, 0, 1, 2, 35, 0, 0),
(95, 0, 0, 0, 0, 0, 'Unnamed House #95', 2, 22, 350000, 0, 1, 2, 35, 0, 0),
(96, 0, 0, 0, 0, 0, 'Unnamed House #96', 2, 22, 350000, 0, 1, 2, 35, 0, 0),
(97, 0, 0, 0, 0, 0, 'Unnamed House #97', 2, 22, 350000, 0, 1, 2, 35, 0, 0),
(98, 0, 0, 0, 0, 0, 'Unnamed House #98', 2, 22, 350000, 0, 1, 2, 35, 0, 0),
(99, 0, 0, 0, 0, 0, 'Unnamed House #99', 2, 14, 250000, 0, 1, 2, 25, 0, 0),
(100, 0, 0, 0, 0, 0, 'Unnamed House #100', 2, 14, 250000, 0, 1, 2, 25, 0, 0),
(101, 0, 0, 0, 0, 0, 'Unnamed House #101', 2, 14, 250000, 0, 1, 2, 25, 0, 0),
(102, 0, 0, 0, 0, 0, 'Unnamed House #102', 2, 14, 250000, 0, 1, 2, 25, 0, 0),
(103, 0, 0, 0, 0, 0, 'Unnamed House #103', 2, 14, 250000, 0, 1, 2, 25, 0, 0),
(104, 0, 0, 0, 0, 0, 'Unnamed House #104', 1, 18, 310000, 0, 1, 2, 31, 0, 0),
(105, 0, 0, 0, 0, 0, 'Unnamed House #105', 3, 24, 400000, 0, 1, 4, 40, 0, 0),
(106, 0, 0, 0, 0, 0, 'Unnamed House #106', 3, 7, 170000, 0, 1, 2, 17, 0, 0),
(107, 0, 0, 0, 0, 0, 'Unnamed House #107', 3, 7, 170000, 0, 1, 2, 17, 0, 0),
(108, 0, 0, 0, 0, 0, 'Unnamed House #108', 3, 7, 170000, 0, 1, 2, 17, 0, 0),
(109, 0, 0, 0, 0, 0, 'Unnamed House #109', 3, 23, 370000, 0, 1, 2, 37, 0, 0),
(110, 0, 0, 0, 0, 0, 'Unnamed House #110', 3, 23, 370000, 0, 1, 2, 37, 0, 0),
(111, 0, 0, 0, 0, 0, 'Unnamed House #111', 3, 23, 370000, 0, 1, 2, 37, 0, 0),
(112, 0, 0, 0, 0, 0, 'Unnamed House #112', 3, 77, 1140000, 0, 1, 4, 114, 0, 0),
(113, 0, 0, 0, 0, 0, 'Unnamed House #113', 3, 77, 1140000, 0, 1, 4, 114, 0, 0),
(114, 0, 0, 0, 0, 0, 'Unnamed House #114', 3, 77, 1140000, 0, 1, 4, 114, 0, 0),
(115, 0, 0, 0, 0, 0, 'Unnamed House #115', 3, 59, 810000, 0, 1, 4, 81, 0, 0),
(116, 0, 0, 0, 0, 0, 'Unnamed House #116', 3, 159, 2100000, 0, 2, 6, 210, 0, 0),
(117, 0, 0, 0, 0, 0, 'Unnamed House #117', 3, 67, 900000, 0, 1, 4, 90, 0, 0),
(118, 0, 0, 0, 0, 0, 'Unnamed House #118', 3, 33, 490000, 0, 1, 2, 49, 0, 0),
(119, 0, 0, 0, 0, 0, 'Unnamed House #119', 3, 33, 490000, 0, 1, 2, 49, 0, 0),
(120, 0, 0, 0, 0, 0, 'Unnamed House #120', 3, 68, 900000, 0, 1, 4, 90, 0, 0),
(121, 0, 0, 0, 0, 0, 'Unnamed House #121', 3, 38, 540000, 0, 1, 2, 54, 0, 0),
(122, 0, 0, 0, 0, 0, 'Unnamed House #122', 4, 66, 1020000, 0, 2, 4, 102, 0, 0),
(123, 0, 0, 0, 0, 0, 'Unnamed House #123', 4, 66, 1020000, 0, 2, 4, 102, 0, 0),
(124, 0, 0, 0, 0, 0, 'Unnamed House #124', 4, 66, 1020000, 0, 2, 4, 102, 0, 0),
(126, 0, 0, 0, 0, 0, 'Unnamed House #126', 7, 57, 910000, 0, 2, 4, 91, 0, 0),
(127, 0, 0, 0, 0, 0, 'Unnamed House #127', 7, 57, 910000, 0, 2, 4, 91, 0, 0),
(128, 0, 0, 0, 0, 0, 'Unnamed House #128', 7, 57, 900000, 0, 1, 4, 90, 0, 0),
(129, 0, 0, 0, 0, 0, 'Unnamed House #129', 7, 57, 890000, 0, 0, 4, 89, 0, 0),
(130, 0, 0, 0, 0, 0, 'Unnamed House #130', 7, 30, 450000, 0, 1, 2, 45, 0, 0),
(131, 0, 0, 0, 0, 0, 'Unnamed House #131', 7, 30, 460000, 0, 1, 2, 46, 0, 0),
(132, 0, 0, 0, 0, 0, 'Unnamed House #132', 7, 30, 450000, 0, 1, 2, 45, 0, 0),
(133, 0, 0, 0, 0, 0, 'Unnamed House #133', 7, 30, 460000, 0, 1, 2, 46, 0, 0),
(134, 0, 0, 0, 0, 0, 'Unnamed House #134', 7, 30, 450000, 0, 1, 2, 45, 0, 0),
(135, 0, 0, 0, 0, 0, 'Unnamed House #135', 7, 30, 460000, 0, 1, 2, 46, 0, 0),
(136, 0, 0, 0, 0, 0, 'Unnamed House #136', 7, 30, 450000, 0, 1, 2, 45, 0, 0),
(137, 0, 0, 0, 0, 0, 'Unnamed House #137', 7, 30, 460000, 0, 1, 2, 46, 0, 0),
(138, 0, 0, 0, 0, 0, 'Unnamed House #138', 7, 8, 180000, 0, 1, 2, 18, 0, 0),
(139, 0, 0, 0, 0, 0, 'Unnamed House #139', 7, 8, 180000, 0, 1, 2, 18, 0, 0),
(140, 0, 0, 0, 0, 0, 'Unnamed House #140', 7, 8, 180000, 0, 1, 2, 18, 0, 0),
(141, 0, 0, 0, 0, 0, 'Unnamed House #141', 7, 8, 190000, 0, 1, 2, 19, 0, 0),
(142, 0, 0, 0, 0, 0, 'Unnamed House #142', 7, 8, 190000, 0, 1, 2, 19, 0, 0),
(143, 0, 0, 0, 0, 0, 'Unnamed House #143', 7, 8, 190000, 0, 1, 2, 19, 0, 0),
(144, 0, 0, 0, 0, 0, 'Unnamed House #144', 7, 67, 1050000, 0, 1, 4, 105, 0, 0),
(145, 0, 0, 0, 0, 0, 'Unnamed House #145', 7, 8, 150000, 0, 1, 0, 15, 0, 0),
(146, 0, 0, 0, 0, 0, 'Unnamed House #146', 7, 8, 150000, 0, 1, 0, 15, 0, 0),
(147, 0, 0, 0, 0, 0, 'Unnamed House #147', 7, 8, 150000, 0, 1, 0, 15, 0, 0),
(148, 0, 0, 0, 0, 0, 'Unnamed House #148', 8, 23, 360000, 0, 1, 2, 36, 0, 0),
(149, 0, 0, 0, 0, 0, 'Unnamed House #149', 8, 23, 360000, 0, 1, 2, 36, 0, 0),
(150, 0, 0, 0, 0, 0, 'Unnamed House #150', 8, 32, 550000, 0, 2, 2, 55, 0, 0),
(151, 0, 0, 0, 0, 0, 'Unnamed House #151', 8, 32, 550000, 0, 2, 2, 55, 0, 0),
(152, 0, 0, 0, 0, 0, 'Unnamed House #152', 8, 32, 550000, 0, 2, 2, 55, 0, 0),
(153, 0, 0, 0, 0, 0, 'Unnamed House #153', 8, 26, 410000, 0, 1, 2, 41, 0, 0),
(154, 0, 0, 0, 0, 0, 'Unnamed House #154', 8, 26, 410000, 0, 1, 2, 41, 0, 0),
(155, 0, 0, 0, 0, 0, 'Unnamed House #155', 8, 26, 410000, 0, 1, 2, 41, 0, 0),
(156, 0, 0, 0, 0, 0, 'Unnamed House #156', 8, 18, 300000, 0, 1, 2, 30, 0, 0),
(157, 0, 0, 0, 0, 0, 'Unnamed House #157', 8, 13, 250000, 0, 1, 2, 25, 0, 0),
(158, 0, 0, 0, 0, 0, 'Unnamed House #158', 8, 13, 250000, 0, 1, 2, 25, 0, 0),
(159, 0, 0, 0, 0, 0, 'Unnamed House #159', 8, 13, 250000, 0, 1, 2, 25, 0, 0),
(160, 0, 0, 0, 0, 0, 'Unnamed House #160', 8, 18, 300000, 0, 1, 2, 30, 0, 0),
(161, 0, 0, 0, 0, 0, 'Unnamed House #161', 8, 18, 300000, 0, 1, 2, 30, 0, 0);
-- --------------------------------------------------------
--
-- Estrutura da tabela `house_auctions`
--
CREATE TABLE IF NOT EXISTS `house_auctions` (
 `house_id` int(10) unsigned NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `player_id` int(11) NOT NULL,
 `bid` int(10) unsigned NOT NULL DEFAULT '0',
 `limit` int(10) unsigned NOT NULL DEFAULT '0',
 `endtime` bigint(20) unsigned NOT NULL DEFAULT '0',
 UNIQUE KEY `house_id` (`house_id`,`world_id`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `house_auctions`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `house_data`
--
CREATE TABLE IF NOT EXISTS `house_data` (
 `house_id` int(10) unsigned NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `data` longblob NOT NULL,
 UNIQUE KEY `house_id` (`house_id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo
dados da tabela `house_data`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `house_lists`
--
CREATE TABLE IF NOT EXISTS `house_lists` (
 `house_id` int(10) unsigned NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `listid` int(11) NOT NULL,
 `list` text NOT NULL,
 UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `house_lists`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `killers`
--
CREATE TABLE IF NOT EXISTS `killers` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `death_id` int(11) NOT NULL,
 `final_hit` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `unjustified` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `war` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `death_id` (`death_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Extraindo dados da tabela `killers`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `pagsegurotransacoes`
--
CREATE TABLE IF NOT EXISTS `pagsegurotransacoes` (
 `TransacaoID` varchar(36) NOT NULL,
 `VendedorEmail` varchar(200) NOT NULL,
 `Referencia` varchar(200) DEFAULT NULL,
 `TipoFrete` char(2) DEFAULT NULL,
 `ValorFrete` decimal(10,2) DEFAULT NULL,
 `Extras` decimal(10,2) DEFAULT NULL,
 `Anotacao` text,
 `TipoPagamento` varchar(50) NOT NULL,
 `StatusTransacao` varchar(50) NOT NULL,
 `CliNome` varchar(200) NOT NULL,
 `CliEmail` varchar(200) NOT NULL,
 `CliEndereco` varchar(200) NOT NULL,
 `CliNumero` varchar(10) DEFAULT NULL,
 `CliComplemento` varchar(100) DEFAULT NULL,
 `CliBairro` varchar(100) NOT NULL,
 `CliCidade` varchar(100) NOT NULL,
 `CliEstado` char(2) NOT NULL,
 `CliCEP` varchar(9) NOT NULL,
 `CliTelefone` varchar(14) DEFAULT NULL,
 `NumItens` int(11) NOT NULL,
 `Data` datetime NOT NULL,
 `ProdQuantidade_x` int(5) NOT NULL,
 `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
 UNIQUE KEY `TransacaoID` (`TransacaoID`,`StatusTransacao`),
 KEY `Referencia` (`Referencia`),
 KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `pagsegurotransacoes`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `players`
--
CREATE TABLE IF NOT EXISTS `players` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(255) NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `group_id` int(11) NOT NULL DEFAULT '1',
 `account_id` int(11) NOT NULL DEFAULT '0',
 `level` int(11) NOT NULL DEFAULT '1',
 `vocation` int(11) NOT NULL DEFAULT '0',
 `health` int(11) NOT NULL DEFAULT '150',
 `healthmax` int(11) NOT NULL DEFAULT '150',
 `experience` bigint(20) NOT NULL DEFAULT '0',
 `lookbody` int(11) NOT NULL DEFAULT '0',
 `lookfeet` int(11) NOT NULL DEFAULT '0',
 `lookhead` int(11) NOT NULL DEFAULT '0',
 `looklegs` int(11) NOT NULL DEFAULT '0',
 `looktype` int(11) NOT NULL DEFAULT '136',
 `lookaddons` int(11) NOT NULL DEFAULT '0',
 `maglevel` int(11) NOT NULL DEFAULT '0',
 `mana` int(11) NOT NULL DEFAULT '0',
 `manamax` int(11) NOT NULL DEFAULT '0',
 `manaspent` int(11) NOT NULL DEFAULT '0',
 `soul` int(10) unsigned NOT NULL DEFAULT '0',
 `town_id` int(11) NOT NULL DEFAULT '0',
 `posx` int(11) NOT NULL DEFAULT '0',
 `posy` int(11) NOT NULL DEFAULT '0',
 `posz` int(11) NOT NULL DEFAULT '0',
 `conditions` blob NOT NULL,
 `cap` int(11) NOT NULL DEFAULT '0',
 `sex` int(11) NOT NULL DEFAULT '0',
 `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',
 `lastip` int(10) unsigned NOT NULL DEFAULT '0',
 `save` tinyint(1) NOT NULL DEFAULT '1',
 `skull` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `skulltime` int(11) NOT NULL DEFAULT '0',
 `rank_id` int(11) NOT NULL DEFAULT '0',
 `guildnick` varchar(255) NOT NULL DEFAULT '',
 `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',
 `blessings` tinyint(2) NOT NULL DEFAULT '0',
 `balance` bigint(20) NOT NULL DEFAULT '0',
 `stamina` bigint(20) NOT NULL DEFAULT '151200000' COMMENT 'stored in miliseconds',
 `direction` int(11) NOT NULL DEFAULT '2',
 `loss_experience` int(11) NOT NULL DEFAULT '100',
 `loss_mana` int(11) NOT NULL DEFAULT '100',
 `loss_skills` int(11) NOT NULL DEFAULT '100',
 `loss_containers` int(11) NOT NULL DEFAULT '100',
 `loss_items` int(11) NOT NULL DEFAULT '100',
 `premend` int(11) NOT NULL DEFAULT '0' COMMENT 'NOT IN USE BY THE SERVER',
 `online` tinyint(1) NOT NULL DEFAULT '0',
 `marriage` int(10) unsigned NOT NULL DEFAULT '0',
 `promotion` int(11) NOT NULL DEFAULT '0',
 `deleted` int(11) NOT NULL DEFAULT '0',
 `description` varchar(255) NOT NULL DEFAULT '',
 `comment` text NOT NULL,
 `create_ip` int(11) NOT NULL DEFAULT '0',
 `create_date` int(11) NOT NULL DEFAULT '0',
 `hide_char` int(11) NOT NULL DEFAULT '0',
 `signature` text NOT NULL,
 `cast` tinyint(4) NOT NULL DEFAULT '0',
 `castViewers` int(11) NOT NULL DEFAULT '0',
 `castDescription` varchar(255) NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`,`deleted`),
 KEY `account_id` (`account_id`),
 KEY `group_id` (`group_id`),
 KEY `online` (`online`),
 KEY `deleted` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=82 ;
--
-- Extraindo dados da tabela `players`
--
INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `signature`, `cast`, `castViewers`, `castDescription`) VALUES
(2, 'Account Manager', 0, 1, 1, 1, 1, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559479, 1677764800, 1, 4, 0, 0, '', 1422559485, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(3, 'Goku Sample', 0, 1, 1, 1, 1, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559479, 1677764800, 1, 4, 0, 0, '', 1422559485, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(4, 'Vegeta Sample', 0, 1, 1, 1, 17, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559586, 1677764800, 1, 4, 0, 0, '', 1422559693, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(5, 'Piccolo Sample', 0, 1, 1, 1, 32, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559526, 1677764800, 1, 4, 0, 0, '', 1422559544, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(6, 'C17 Sample', 0, 1, 1, 1, 45, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559308, 1677764800, 1, 4, 0, 0, '', 1422559385, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(7, 'Gohan Sample', 0, 1, 1, 1, 57, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559457, 1677764800, 1, 4, 0, 0, '', 1422559479, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(8, 'Trunks Sample', 0, 1, 1, 1, 71, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559544, 1677764800, 1, 4, 0, 0, '', 1422559565, 0, 0, 151200000, 2, 150, 100, 100,
100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(9, 'Cell Sample', 0, 1, 1, 1, 83, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559215, 1677764800, 1, 4, 0, 0, '', 1422559242, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(10, 'Freeza Sample', 0, 1, 1, 1, 95, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559408, 1677764800, 1, 4, 0, 0, '', 1422559457, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(11, 'Majin Boo Sample', 0, 1, 1, 1, 111, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559507, 1677764800, 1, 4, 0, 0, '', 1422559526, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(12, 'Brolly Sample', 0, 1, 1, 1, 127, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559193, 1677764800, 1, 4, 0, 0, '', 1422559215, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(13, 'C18 Sample', 0, 1, 1, 1, 140, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 0, 1422559385, 1677764800, 1, 4, 0, 0, '', 1422559407, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(14, 'Uub Sample', 0, 1, 1, 1, 152, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559565, 1677764800, 1, 4, 0, 0, '', 1422559586, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(15, 'Goten Sample', 0, 1, 1, 1, 164, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559485, 1677764800, 1, 4, 0, 0, '', 1422559506, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(16, 'Chibi Trunks Sample', 0, 1, 1, 1, 178, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559243, 1677764800, 1, 4, 0, 0, '', 1422559261, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(17, 'Cooler Sample', 0, 1, 1, 1, 192, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559262, 1677764800, 1, 4, 0, 0, '', 1422559283, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(18, 'Dende Sample', 0, 1, 1, 1, 206, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559283, 1677764800, 1, 4, 0, 0, '', 1422559308, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(19, 'Tsuful Sample', 0, 1, 1, 1, 218, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560589, 1677764800, 1, 4, 0, 0, '', 1422560591, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(20, 'Kuririn Sample', 0, 1, 1, 1, 244, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560222, 1677764800, 1, 4, 0, 0, '', 1422560247, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(21, 'Pan Sample', 0, 1, 1, 1, 256, 250, 250, 0, 68, 76, 78, 39, 136, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 0, 1422560247, 1677764800, 1, 4, 0, 0, '', 1422560275, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(22, 'Kaio Sample', 0, 1, 1, 1, 268, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560203, 1677764800, 1, 4, 0, 0, '', 1422560222, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(23, 'Videl Sample', 0, 1, 1, 1, 280, 250, 250, 0, 68, 76, 78, 39, 136, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 0, 1422560359, 1677764800, 1, 4, 0, 0, '', 1422560380, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(24, 'Janemba Sample', 0, 1, 1, 1, 292, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560167, 1677764800, 1, 4, 0, 0, '', 1422560185, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(25, 'Tenshinhan Sample', 0, 1, 1, 1, 304, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560333, 1677764800, 1, 4, 0, 0, '', 1422560335, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(26, 'Jenk Sample', 0, 1, 1, 1, 316, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560185, 1677764800, 1, 4, 0, 0, '', 1422560203, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(27, 'Raditz Sample', 0, 1, 1, 1, 328, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560276, 1677764800, 1, 4, 0, 0, '', 1422560294, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(28, 'C16 Sample', 0, 1, 1, 1, 340, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560147, 1677764800, 1, 4, 0, 0, '', 1422560167, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(29, 'Turles Sample', 0, 1, 1, 1, 352, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422560335, 1677764800, 1, 4, 0, 0, '', 1422560359, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(30, 'Bulma Sample', 0, 1, 1, 1, 364, 250, 250, 0, 68, 76, 78, 39, 136, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 0, 1422560124, 1677764800, 1, 4, 0, 0, '', 1422560146, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(31, 'Bardock Sample', 0, 1, 1, 1, 230, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1436740850, 303746388, 1, 4, 0, 0, '', 1436740910, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(51, 'Kramer', 0, 6, 12, 700, 387, 445890, 445890, 5667864800, 0, 0, 0, 0, 447, 0, 0, 342760, 364010, 0, 100, 1, 109, 117, 7, '', 160150, 1, 1437852802, 16777343, 1, 4, 0, 0, '', 1437852817, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', -1283561320, 1436793514, 0, '', 0, 0, ''),
(77, 'Rook Sample', 0, 1, 1, 1, 0, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559479, 1677764800, 1, 4, 0, 0, '', 1422559485, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(78, 'Sorcerer Sample', 0, 1, 1, 1, 1, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559479, 1677764800, 1, 4, 0, 0, '', 1422559485, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(79, 'Druid Sample', 0, 1, 1, 1, 2, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559479, 1677764800, 1, 4, 0, 0, '', 1422559485, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(80, 'Paladin Sample', 0, 1, 1, 1, 3, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559479, 1677764800, 1, 4, 0, 0, '', 1422559485, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, ''),
(81, 'Knight Sample', 0, 1, 1, 1, 4, 250, 250, 0, 68, 76, 78, 39, 128, 0, 0, 250, 250, 0, 100, 1, 655, 399, 7, '', 400, 1, 1422559479, 1677764800, 1, 4, 0, 0, '', 1422559485, 0, 0, 151200000, 2, 150, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 0, 0, '');
--
-- Gatilhos `players`
--
DROP TRIGGER IF EXISTS `oncreate_players`;
DELIMITER //
CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
FOR EACH ROW BEGIN
 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
 INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `ondelete_players`;
DELIMITER //
CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players`
 FOR EACH ROW BEGIN
 DELETE FROM `bans` WHERE `type` IN (2, 5) AND `value` = OLD.`id`;
 UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END
//
DELIMITER ;
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_deaths`
--
CREATE TABLE IF NOT EXISTS `player_deaths` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `player_id` int(11) NOT NULL,
 `date` bigint(20) unsigned NOT NULL,
 `level` int(10) unsigned NOT NULL,
 PRIMARY KEY (`id`),
 KEY `date` (`date`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Extraindo dados da tabela `player_deaths`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_depotitems`
--
CREATE TABLE IF NOT EXISTS `player_depotitems` (
 `player_id` int(11) NOT NULL,
 `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',
 `pid` int(11) NOT NULL DEFAULT '0',
 `itemtype` int(11) NOT NULL,
 `count` int(11) NOT NULL DEFAULT '0',
 `attributes` blob NOT NULL,
 UNIQUE KEY `player_id_2` (`player_id`,`sid`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `player_depotitems`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_items`
--
CREATE TABLE IF NOT EXISTS `player_items` (
 `player_id` int(11) NOT NULL DEFAULT '0',
 `pid` int(11) NOT NULL DEFAULT '0',
 `sid` int(11) NOT NULL DEFAULT '0',
 `itemtype` int(11) NOT NULL DEFAULT '0',
 `count` int(11) NOT NULL DEFAULT '0',
 `attributes` blob NOT NULL,
 UNIQUE KEY `player_id_2` (`player_id`,`sid`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `player_items`
--
INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES
(3, 1, 101, 12634, 1, ''),
(3, 3, 102, 12764, 1, ''),
(3, 4, 103, 12664, 1, ''),
(3, 5, 104, 12776, 100, 0x0f64),
(3, 6, 105, 12698, 1, ''),
(3, 7, 106, 12683, 1, ''),
(3, 8, 107, 12697, 1, ''),
(3, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(3, 10, 109, 12775, 100, 0x0f64),
(3, 102, 110, 2667, 100, 0x0f64),
(4, 1, 101, 12634, 1, ''),
(4, 3, 102, 12764, 1, ''),
(4, 4, 103, 12664, 1, ''),
(4, 5, 104, 12776, 100, 0x0f64),
(4, 6, 105, 12698, 1, ''),
(4, 7, 106, 12683, 1, ''),
(4, 8, 107, 12697, 1, ''),
(4, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(4, 10, 109, 12775, 100, 0x0f64),
(4, 102, 110, 2667, 100, 0x0f64),
(5, 1, 101, 12634, 1, ''),
(5, 3, 102, 12764, 1, ''),
(5, 4, 103, 12664, 1, ''),
(5, 5, 104, 2667, 100, 0x0f64),
(5, 6, 105, 12736, 1, ''),
(5, 7, 106, 12683, 1, ''),
(5, 8, 107, 12697, 1, ''),
(5, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(5, 10, 109, 12737, 1, 0x0f01),
(5, 102, 110, 12776, 100, 0x0f64),
(5, 102, 111, 12775, 100, 0x0f64),
(6, 1, 101, 12634, 1, ''),
(6, 3, 102, 12764, 1, ''),
(6, 4, 103, 12664, 1, ''),
(6, 5, 104, 12776, 100, 0x0f64),
(6, 6, 105, 12698, 1, ''),
(6, 7, 106, 12683, 1, ''),
(6, 8, 107, 12697, 1, ''),
(6, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(6, 10, 109, 12775, 100, 0x0f64),
(6, 102, 110, 2667, 100, 0x0f64),
(7, 1, 101, 12634, 1, ''),
(7, 3, 102, 12764, 1, ''),
(7, 4, 103, 12664, 1, ''),
(7, 5, 104, 12776, 100, 0x0f64),
(7, 6, 105, 12698, 1, ''),
(7, 7, 106, 12683, 1, ''),
(7, 8, 107, 12697, 1, ''),
(7, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(7, 10, 109, 12775, 100, 0x0f64),
(7, 102, 110, 2667, 100, 0x0f64),
(8, 1, 101, 12634, 1, ''),
(8, 3, 102, 12764, 1, ''),
(8, 4, 103, 12664, 1, ''),
(8, 5, 104, 12776, 100, 0x0f64),
(8, 6, 105, 12716, 1, ''),
(8, 7, 106, 12683, 1, ''),
(8, 8, 107, 12697, 1, ''),
(8, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(8, 10, 109, 12775, 100, 0x0f64),
(8, 102, 110, 2667, 100, 0x0f64),
(9, 1, 101, 12634, 1, ''),
(9, 3, 102, 12764, 1, ''),
(9, 4, 103, 12664, 1, ''),
(9, 5, 104, 2667, 100, 0x0f64),
(9, 6, 105, 12736, 1, ''),
(9, 7, 106, 12683, 1, ''),
(9, 8, 107, 12697, 1, ''),
(9, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(9, 10, 109, 12737, 1, 0x0f01),
(9, 102, 110, 12776, 100, 0x0f64),
(9, 102, 111, 12775, 100, 0x0f64),
(10, 1, 101, 12634, 1, ''),
(10, 3, 102, 12764, 1, ''),
(10, 4, 103, 12664, 1, ''),
(10, 5, 104, 12776, 100, 0x0f64),
(10, 6, 105, 12698, 1, ''),
(10, 7, 106, 12683, 1, ''),
(10, 8, 107, 12697, 1, ''),
(10, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(10, 10, 109, 12775, 100, 0x0f64),
(10, 102, 110, 2667, 100, 0x0f64),
(11, 1, 101, 12634, 1, ''),
(11, 3, 102, 12764, 1, ''),
(11, 4, 103, 12664, 1, ''),
(11, 5, 104, 12776, 100, 0x0f64),
(11, 6, 105, 12698, 1, ''),
(11, 7, 106, 12683, 1, ''),
(11, 8, 107, 12697, 1, ''),
(11, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(11, 10, 109, 12775, 100, 0x0f64),
(11, 102, 110, 2667, 100, 0x0f64),
(12, 1, 101, 12634, 1, ''),
(12, 3, 102, 12764, 1, ''),
(12, 4, 103, 12664, 1, ''),
(12, 5, 104, 12776, 100, 0x0f64),
(12, 6, 105, 12698, 1, ''),
(12, 7, 106, 12683, 1, ''),
(12, 8, 107, 12697, 1, ''),
(12, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(12, 10, 109, 12775, 100, 0x0f64),
(12, 102, 110, 2667, 100, 0x0f64),
(13, 1, 101, 12634, 1, ''),
(13, 3, 102, 12764, 1, ''),
(13, 4, 103, 12664, 1, ''),
(13, 5, 104, 12776, 100, 0x0f64),
(13, 6, 105, 12698, 1, ''),
(13, 7, 106, 12683, 1, ''),
(13, 8, 107, 12697, 1, ''),
(13, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(13, 10, 109, 12775, 100, 0x0f64),
(13, 102, 110, 2667, 100, 0x0f64),
(14, 1, 101, 12634, 1, ''),
(14, 3, 102, 12764, 1, ''),
(14, 4, 103, 12664, 1, ''),
(14, 5, 104, 12776, 100, 0x0f64),
(14, 6, 105, 12698, 1, ''),
(14, 7, 106, 12683, 1, ''),
(14, 8, 107, 12697, 1, ''),
(14, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(14, 10, 109, 12775, 100, 0x0f64),
(14, 102, 110, 2667, 100, 0x0f64),
(15, 1, 101, 12634, 1, ''),
(15, 3, 102, 12764, 1, ''),
(15, 4, 103, 12664, 1, ''),
(15, 5, 104, 12776, 100, 0x0f64),
(15, 6, 105, 12698, 1, ''),
(15, 7, 106, 12683, 1, ''),
(15, 8, 107, 12697, 1, ''),
(15, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(15, 10, 109, 12775, 100, 0x0f64),
(15, 102, 110, 2667, 100, 0x0f64),
(16, 1, 101, 12634, 1, ''),
(16, 3, 102, 12764, 1, ''),
(16, 4, 103, 12664, 1, ''),
(16, 5, 104, 12776, 100, 0x0f64),
(16, 6, 105, 12716, 1, ''),
(16, 7, 106, 12683, 1, ''),
(16, 8, 107, 12697, 1, ''),
(16, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(16, 10, 109, 12775, 100, 0x0f64),
(16, 102, 110, 2667, 100, 0x0f64),
(17, 1, 101, 12634, 1, ''),
(17, 3, 102, 12764, 1, ''),
(17, 4, 103, 12664, 1, ''),
(17, 5, 104, 12776, 100, 0x0f64),
(17, 6, 105, 12698, 1, ''),
(17, 7, 106, 12683, 1, ''),
(17, 8, 107, 12697, 1, ''),
(17, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(17, 10, 109, 12775, 100, 0x0f64),
(17, 102, 110, 2667, 100, 0x0f64),
(18, 1, 101, 12634, 1, ''),
(18, 3, 102, 12764, 1, ''),
(18, 4, 103, 12664, 1, ''),
(18, 5, 104, 2667, 100, 0x0f64),
(18, 6, 105, 12736, 1, ''),
(18, 7, 106, 12683, 1, ''),
(18, 8, 107, 12697, 1, ''),
(18, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(18, 10, 109, 12737, 1, 0x0f01),
(18, 102, 110, 12776, 100, 0x0f64),
(18, 102, 111, 12775, 100, 0x0f64),
(19, 1, 101, 12634, 1, ''),
(19, 3, 102, 12764, 1, ''),
(19, 4, 103, 12664, 1, ''),
(19, 5, 104, 12776, 100, 0x0f64),
(19, 6, 105, 12698, 1, ''),
(19, 7, 106, 12683, 1, ''),
(19, 8, 107, 12697, 1, ''),
(19, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(19, 10, 109, 12775, 100, 0x0f64),
(19, 102, 110, 2667, 100, 0x0f64),
(20, 1, 101, 12634, 1, ''),
(20, 3, 102, 12764, 1, ''),
(20, 4, 103, 12664, 1, ''),
(20, 5, 104, 12776, 100, 0x0f64),
(20, 6, 105, 12698, 1, ''),
(20, 7, 106, 12683, 1, ''),
(20, 8, 107, 12697, 1, ''),
(20, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(20, 10, 109, 12775, 100, 0x0f64),
(20, 102, 110, 2667, 100, 0x0f64),
(21, 1, 101, 12634, 1, ''),
(21, 3, 102, 12764, 1, ''),
(21, 4, 103, 12664, 1, ''),
(21, 5, 104, 12776, 100, 0x0f64),
(21, 6, 105, 12698, 1, ''),
(21, 7, 106, 12683, 1, ''),
(21, 8, 107, 12697, 1, ''),
(21, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(21, 10, 109, 12775, 100, 0x0f64),
(21, 102, 110, 2667, 100, 0x0f64),
(22, 1, 101, 12634, 1, ''),
(22, 3, 102, 12764, 1, ''),
(22, 4, 103, 12664, 1, ''),
(22, 5, 104, 2667, 100, 0x0f64),
(22, 6, 105, 12736, 1, ''),
(22, 7, 106, 12683, 1, ''),
(22, 8, 107, 12697, 1, ''),
(22, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(22, 10, 109, 12737, 1, 0x0f01),
(22, 102, 110, 12776, 100, 0x0f64),
(22, 102, 111, 12775, 100, 0x0f64),
(23, 1, 101, 12634, 1, ''),
(23, 3, 102, 12764, 1, ''),
(23, 4, 103, 12664, 1, ''),
(23, 5, 104, 12776, 100, 0x0f64),
(23, 6, 105, 12698, 1, ''),
(23, 7, 106, 12683, 1, ''),
(23, 8, 107, 12697, 1, ''),
(23, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(23, 10, 109, 12775, 100, 0x0f64),
(23, 102, 110, 2667, 100, 0x0f64),
(24, 1, 101, 12634, 1, ''),
(24, 3, 102, 12764, 1, ''),
(24, 4, 103, 12664, 1, ''),
(24, 5, 104, 12776, 100, 0x0f64),
(24, 6, 105, 12716, 1, ''),
(24, 7, 106, 12683, 1, ''),
(24, 8, 107, 12697, 1, ''),
(24, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(24, 10, 109, 12775, 100, 0x0f64),
(24, 102, 110, 2667, 100, 0x0f64),
(25, 1, 101, 12634, 1, ''),
(25, 3, 102, 12764, 1, ''),
(25, 4, 103, 12664, 1, ''),
(25, 5, 104, 12776, 100, 0x0f64),
(25, 6, 105, 12698, 1, ''),
(25, 7, 106, 12683, 1, ''),
(25, 8, 107, 12697, 1, ''),
(25, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(25, 10, 109, 12775, 100, 0x0f64),
(25, 102, 110, 2667, 100, 0x0f64),
(26, 1, 101, 12634, 1, ''),
(26, 3, 102, 12764, 1, ''),
(26, 4, 103, 12664, 1, ''),
(26, 5, 104, 12776, 100, 0x0f64),
(26, 6, 105, 12698, 1, ''),
(26, 7, 106, 12683, 1, ''),
(26, 8, 107, 12697, 1, ''),
(26, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(26, 10, 109, 12775, 100, 0x0f64),
(26, 102, 110, 2667, 100, 0x0f64),
(27, 1, 101, 12634, 1, ''),
(27, 3, 102, 12764, 1, ''),
(27, 4, 103, 12664, 1, ''),
(27, 5, 104, 12776, 100, 0x0f64),
(27, 6, 105, 12698, 1, ''),
(27, 7, 106, 12683, 1, ''),
(27, 8, 107, 12697, 1, ''),
(27, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(27, 10, 109, 12775, 100, 0x0f64),
(27, 102, 110, 2667, 100, 0x0f64),
(28, 1, 101, 12634, 1, ''),
(28, 3, 102, 12764, 1, ''),
(28, 4, 103, 12664, 1, ''),
(28, 5, 104, 12776, 100, 0x0f64),
(28, 6, 105, 12698, 1, ''),
(28, 7, 106, 12683, 1, ''),
(28, 8, 107, 12697, 1, ''),
(28, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(28, 10, 109, 12775, 100, 0x0f64),
(28, 102, 110, 2667, 100, 0x0f64),
(29, 1, 101, 12634, 1, ''),
(29, 3, 102, 12764, 1, ''),
(29, 4, 103, 12664, 1, ''),
(29, 5, 104, 12776, 100, 0x0f64),
(29, 6, 105, 12698, 1, ''),
(29, 7, 106, 12683, 1, ''),
(29, 8, 107, 12697, 1, ''),
(29, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(29, 10, 109, 12775, 100, 0x0f64),
(29, 102, 110, 2667, 100, 0x0f64),
(30, 1, 101, 12634, 1, ''),
(30, 3, 102, 12764, 1, ''),
(30, 4, 103, 12664, 1, ''),
(30, 5, 104, 12776, 100, 0x0f64),
(30, 6, 105, 12698, 1, ''),
(30, 7, 106, 12683, 1, ''),
(30, 8, 107, 12697, 1, ''),
(30, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(30, 10, 109, 12775, 100, 0x0f64),
(30, 102, 110, 2667, 100, 0x0f64),
(31, 1, 101, 12634, 1, ''),
(31, 3, 102, 12764, 1, ''),
(31, 4, 103, 12664, 1, ''),
(31, 5, 104, 12776, 100, 0x0f64),
(31, 6, 105, 12698, 1, ''),
(31, 7, 106, 12683, 1, ''),
(51, 1, 101, 12634, 1, ''),
(51, 3, 102, 2002, 1, ''),
(51, 4, 103, 12664, 1, ''),
(51, 5, 104, 13467, 1, ''),
(51, 6, 105, 13467, 1, ''),
(51, 7, 106, 12683, 1, ''),
(51, 8, 107, 12697, 1, ''),
(51, 9, 108, 12758, 1, 0x8001000700636861726765730201000000),
(51, 10, 109, 12779, 96, 0x0f60),
(51, 102, 110, 12732, 1, ''),
(51, 102, 111, 2667, 100, 0x0f64),
(51, 102, 112, 2376, 1, ''),
(51, 102, 113, 12738, 99, 0x0f63),
(51, 102, 114, 12736, 1, ''),
(51, 102, 115, 12655, 1, ''),
(51, 102, 116, 12779, 100, 0x0f64),
(51, 102, 117, 2160, 90, 0x0f5a),
(51, 102, 118, 12737, 1, 0x0f01),
(51, 102, 119, 2089, 1, ''),
(51, 102, 120, 2092, 1, 0x8001000300616964022c080000),
(51, 102, 121, 2089, 1, ''),
(51, 102, 122, 2088, 1, ''),
(51, 102, 123, 2091, 1, ''),
(51, 102, 124, 2160, 100, 0x0f64),
(51, 102, 125, 2160, 100, 0x0f64);
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_killers`
--
CREATE TABLE IF NOT EXISTS `player_killers` (
 `kill_id` int(11) NOT NULL,
 `player_id` int(11) NOT NULL,
 KEY `kill_id` (`kill_id`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `player_killers`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_namelocks`
--
CREATE TABLE IF NOT EXISTS `player_namelocks` (
 `player_id` int(11) NOT NULL DEFAULT '0',
 `name` varchar(255) NOT NULL,
 `new_name` varchar(255) NOT NULL,
 `date` bigint(20) NOT NULL DEFAULT '0',
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `player_namelocks`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_skills`
--
CREATE TABLE IF NOT EXISTS `player_skills` (
 `player_id` int(11) NOT NULL DEFAULT '0',
 `skillid` tinyint(2) NOT NULL DEFAULT '0',
 `value` int(10) unsigned NOT NULL DEFAULT '0',
 `count` int(10) unsigned NOT NULL DEFAULT '0',
 UNIQUE KEY `player_id_2` (`player_id`,`skillid`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `player_skills`
--
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(3, 0, 10, 0),
(3, 1, 10, 0),
(3, 2, 10, 0),
(3, 3, 10, 0),
(3, 4, 10, 0),
(3, 5, 10, 0),
(3, 6, 10, 0),
(4, 0, 10, 0),
(4, 1, 10, 0),
(4, 2, 10, 0),
(4, 3, 10, 0),
(4, 4, 10, 0),
(4, 5, 10, 0),
(4, 6, 10, 0),
(5, 0, 10, 0),
(5, 1, 10, 0),
(5, 2, 10, 0),
(5, 3, 10, 0),
(5, 4, 10, 0),
(5, 5, 10, 0),
(5, 6, 10, 0),
(6, 0, 10, 0),
(6, 1, 10, 0),
(6, 2, 10, 0),
(6, 3, 10, 0),
(6, 4, 10, 0),
(6, 5, 10, 0),
(6, 6, 10, 0),
(7, 0, 10, 0),
(7, 1, 10, 0),
(7, 2, 10, 0),
(7, 3, 10, 0),
(7, 4, 10, 0),
(7, 5, 10, 0),
(7, 6, 10, 0),
(8, 0, 10, 0),
(8, 1, 10, 0),
(8, 2, 10, 0),
(8, 3, 10, 0),
(8, 4, 10, 0),
(8, 5, 10, 0),
(8, 6, 10, 0),
(9, 0, 10, 0),
(9, 1, 10, 0),
(9, 2, 10, 0),
(9, 3, 10, 0),
(9, 4, 10, 0),
(9, 5, 10, 0),
(9, 6, 10, 0),
(10, 0, 10, 0),
(10, 1, 10, 0),
(10, 2, 10, 0),
(10, 3, 10, 0),
(10, 4, 10, 0),
(10, 5, 10, 0),
(10, 6, 10, 0),
(11, 0, 10, 0),
(11, 1, 10, 0),
(11, 2, 10, 0),
(11, 3, 10, 0),
(11, 4, 10, 0),
(11, 5, 10, 0),
(11,
6, 10, 0),
(12, 0, 10, 0),
(12, 1, 10, 0),
(12, 2, 10, 0),
(12, 3, 10, 0),
(12, 4, 10, 0),
(12, 5, 10, 0),
(12, 6, 10, 0),
(13, 0, 10, 0),
(13, 1, 10, 0),
(13, 2, 10, 0),
(13, 3, 10, 0),
(13, 4, 10, 0),
(13, 5, 10, 0),
(13, 6, 10, 0),
(14, 0, 10, 0),
(14, 1, 10, 0),
(14, 2, 10, 0),
(14, 3, 10, 0),
(14, 4, 10, 0),
(14, 5, 10, 0),
(14, 6, 10, 0),
(15, 0, 10, 0),
(15, 1, 10, 0),
(15, 2, 10, 0),
(15, 3, 10, 0),
(15, 4, 10, 0),
(15, 5, 10, 0),
(15, 6, 10, 0),
(16, 0, 10, 0),
(16, 1, 10, 0),
(16, 2, 10, 0),
(16, 3, 10, 0),
(16, 4, 10, 0),
(16, 5, 10, 0),
(16, 6, 10, 0),
(17, 0, 10, 0),
(17, 1, 10, 0),
(17, 2, 10, 0),
(17, 3, 10, 0),
(17, 4, 10, 0),
(17, 5, 10, 0),
(17, 6, 10, 0),
(18, 0, 10, 0),
(18, 1, 10, 0),
(18, 2, 10, 0),
(18, 3, 10, 0),
(18, 4, 10, 0),
(18, 5, 10, 0),
(18, 6, 10, 0),
(19, 0, 10, 0),
(19, 1, 10, 0),
(19, 2, 10, 0),
(19, 3, 10, 0),
(19, 4, 10, 0),
(19, 5, 10, 0),
(19, 6, 10, 0),
(20, 0, 10, 0),
(20, 1, 10, 0),
(20, 2, 10, 0),
(20, 3, 10, 0),
(20, 4, 10, 0),
(20, 5, 10, 0),
(20, 6, 10, 0),
(21, 0, 10, 0),
(21, 1, 10, 0),
(21, 2, 10, 0),
(21, 3, 10, 0),
(21, 4, 10, 0),
(21, 5, 10, 0),
(21, 6, 10, 0),
(22, 0, 10, 0),
(22, 1, 10, 0),
(22, 2, 10, 0),
(22, 3, 10, 0),
(22, 4, 10, 0),
(22, 5, 10, 0),
(22, 6, 10, 0),
(23, 0, 10, 0),
(23, 1, 10, 0),
(23, 2, 10, 0),
(23, 3, 10, 0),
(23, 4, 10, 0),
(23, 5, 10, 0),
(23, 6, 10, 0),
(24, 0, 10, 0),
(24, 1, 10, 0),
(24, 2, 10, 0),
(24, 3, 10, 0),
(24, 4, 10, 0),
(24, 5, 10, 0),
(24, 6, 10, 0),
(25, 0, 10, 0),
(25, 1, 10, 0),
(25, 2, 10, 0),
(25, 3, 10, 0),
(25, 4, 10, 0),
(25, 5, 10, 0),
(25, 6, 10, 0),
(26, 0, 10, 0),
(26, 1, 10, 0),
(26, 2, 10, 0),
(26, 3, 10, 0),
(26, 4, 10, 0),
(26, 5, 10, 0),
(26, 6, 10, 0),
(27, 0, 10, 0),
(27, 1, 10, 0),
(27, 2, 10, 0),
(27, 3, 10, 0),
(27, 4, 10, 0),
(27, 5, 10, 0),
(27, 6, 10, 0),
(28, 0, 10, 0),
(28, 1, 10, 0),
(28, 2, 10, 0),
(28, 3, 10, 0),
(28, 4, 10, 0),
(28, 5, 10, 0),
(28, 6, 10, 0),
(29, 0, 10, 0),
(29, 1, 10, 0),
(29, 2, 10, 0),
(29, 3, 10, 0),
(29, 4, 10, 0),
(29, 5, 10, 0),
(29, 6, 10, 0),
(30, 0, 10, 0),
(30, 1, 10, 0),
(30, 2, 10, 0),
(30, 3, 10, 0),
(30, 4, 10, 0),
(30, 5, 10, 0),
(30, 6, 10, 0),
(31, 0, 10, 0),
(31, 1, 10, 0),
(31, 2, 10, 0),
(31, 3, 10, 0),
(31, 4, 10, 0),
(31, 5, 10, 0),
(31, 6, 10, 0),
(51, 0, 10, 0),
(51, 1, 10, 0),
(51, 2, 10, 0),
(51, 3, 10, 0),
(51, 4, 10, 0),
(51, 5, 10, 0),
(51, 6, 10, 0),
(77, 0, 10, 0),
(77, 1, 10, 0),
(77, 2, 10, 0),
(77, 3, 10, 0),
(77, 4, 10, 0),
(77, 5, 10, 0),
(77, 6, 10, 0),
(78, 0, 10, 0),
(78, 1, 10, 0),
(78, 2, 10, 0),
(78, 3, 10, 0),
(78, 4, 10, 0),
(78, 5, 10, 0),
(78, 6, 10, 0),
(79, 0, 10, 0),
(79, 1, 10, 0),
(79, 2, 10, 0),
(79, 3, 10, 0),
(79, 4, 10, 0),
(79, 5, 10, 0),
(79, 6, 10, 0),
(80, 0, 10, 0),
(80, 1, 10, 0),
(80, 2, 10, 0),
(80, 3, 10, 0),
(80, 4, 10, 0),
(80, 5, 10, 0),
(80, 6, 10, 0),
(81, 0, 10, 0),
(81, 1, 10, 0),
(81, 2, 10, 0),
(81, 3, 10, 0),
(81, 4, 10, 0),
(81, 5, 10, 0),
(81, 6, 10, 0);
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_spells`
--
CREATE TABLE IF NOT EXISTS `player_spells` (
 `player_id` int(11) NOT NULL,
 `name` varchar(255) NOT NULL,
 UNIQUE KEY `player_id_2` (`player_id`,`name`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `player_spells`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_storage`
--
CREATE TABLE IF NOT EXISTS `player_storage` (
 `player_id` int(11) NOT NULL DEFAULT '0',
 `key` varchar(32) NOT NULL DEFAULT '0',
 `value` varchar(255) NOT NULL DEFAULT '0',
 UNIQUE KEY `player_id_2` (`player_id`,`key`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `player_storage`
--
INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES
(51, '12397', '1437505966'),
(51, '13101', '1436970486'),
(51, '13103', '1436982476'),
(51, '13104', '1436984901'),
(51, '13107', '1436939649'),
(51, '13112', '1436917680'),
(51, '13132', '1436974735'),
(51, '30023', '4'),
(51, '30024', '600'),
(51, '3482101', '0'),
(51, '45382', '1436796283'),
(51, '50000', '1437534011.5'),
(51, '50090', '1'),
(51, '55694', '1436800835'),
(51, '60003', '1'),
(51, '60008', '1'),
(51, '60029', '1'),
(51, '60038', '1'),
(51, '95498', '1');
-- --------------------------------------------------------
--
-- Estrutura da tabela `player_viplist`
--
CREATE TABLE IF NOT EXISTS `player_viplist` (
 `player_id` int(11) NOT NULL,
 `vip_id` int(11) NOT NULL,
 UNIQUE KEY `player_id_2` (`player_id`,`vip_id`),
 KEY `player_id` (`player_id`),
 KEY `vip_id` (`vip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `player_viplist`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `server_config`
--
CREATE TABLE IF NOT EXISTS `server_config` (
 `config` varchar(35) NOT NULL DEFAULT '',
 `value` varchar(255) NOT NULL DEFAULT '',
 UNIQUE KEY `config` (`config`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `server_config`
--
INSERT INTO `server_config` (`config`, `value`) VALUES
('db_version', '27'),
('encryption', '2'),
('vahash_key', '8HY4-465K-TY5B-FA6P');
-- --------------------------------------------------------
--
-- Estrutura da tabela `server_motd`
--
CREATE TABLE IF NOT EXISTS `server_motd` (
 `id` int(10) unsigned NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `text` text NOT NULL,
 UNIQUE KEY `id` (`id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `server_motd`
--
INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES
(1, 0, 'Welcome to The Forgotten Server!'),
(2, 0, 'Welcome on Dragon Ball Night Apocalypse! Enjoy!\nwww.dbna.pl'),
(3, 0, 'Bem-vindo ao DBUniverse, divirta-se!'),
(4, 0, 'Welcome on Dragon Ball Night Apocalypse! Enjoy!\nwww.dbna.pl'),
(5, 0, 'Bem-vindo ao DBUniverse, divirta-se!');
-- --------------------------------------------------------
--
-- Estrutura da tabela `server_record`
--
CREATE TABLE IF NOT EXISTS `server_record` (
 `record` int(11) NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `timestamp` bigint(20) NOT NULL,
 UNIQUE KEY `record` (`record`,`world_id`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `server_record`
--
INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES
(0, 0, 0),
(1, 0, 1436777623),
(2, 0, 1436777933),
(3, 0, 1436779473),
(4, 0, 1436780048),
(5, 0, 1436780148),
(6, 0, 1436784123),
(7, 0, 1436963108);
-- --------------------------------------------------------
--
-- Estrutura da tabela `server_reports`
--
CREATE TABLE IF NOT EXISTS `server_reports` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `player_id` int(11) NOT NULL DEFAULT '1',
 `posx` int(11) NOT NULL DEFAULT '0',
 `posy` int(11) NOT NULL DEFAULT '0',
 `posz` int(11) NOT NULL DEFAULT '0',
 `timestamp` bigint(20) NOT NULL DEFAULT '0',
 `report` text NOT NULL,
 `reads` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `world_id` (`world_id`),
 KEY `reads` (`reads`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Extraindo dados da tabela `server_reports`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `tiles`
--
CREATE TABLE IF NOT EXISTS `tiles` (
 `id` int(10) unsigned NOT NULL,
 `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
 `house_id` int(10) unsigned NOT NULL,
 `x` int(5) unsigned NOT NULL,
 `y` int(5) unsigned
NOT NULL,
 `z` tinyint(2) unsigned NOT NULL,
 UNIQUE KEY `id` (`id`,`world_id`),
 KEY `x` (`x`,`y`,`z`),
 KEY `house_id` (`house_id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Extraindo dados da tabela `tiles`
--
INSERT INTO `tiles` (`id`, `world_id`, `house_id`, `x`, `y`, `z`) VALUES
(0, 0, 1, 115, 183, 7),
(1, 0, 1, 120, 180, 7),
(2, 0, 1, 120, 181, 7),
(3, 0, 2, 84, 177, 7),
(4, 0, 2, 84, 178, 7),
(5, 0, 2, 82, 182, 7),
(6, 0, 3, 78, 177, 7),
(7, 0, 3, 78, 178, 7),
(8, 0, 3, 76, 182, 7),
(9, 0, 4, 72, 177, 7),
(10, 0, 4, 72, 178, 7),
(11, 0, 4, 70, 182, 7),
(12, 0, 5, 46, 181, 7),
(13, 0, 5, 46, 182, 7),
(14, 0, 5, 51, 183, 7),
(15, 0, 6, 73, 172, 7),
(16, 0, 6, 73, 173, 7),
(17, 0, 6, 78, 174, 7),
(18, 0, 7, 73, 167, 7),
(19, 0, 7, 73, 168, 7),
(20, 0, 7, 78, 169, 7),
(21, 0, 8, 79, 158, 7),
(22, 0, 8, 79, 159, 7),
(23, 0, 8, 81, 162, 7),
(24, 0, 9, 84, 158, 7),
(25, 0, 9, 84, 159, 7),
(26, 0, 9, 86, 162, 7),
(27, 0, 10, 79, 151, 7),
(28, 0, 10, 78, 154, 7),
(29, 0, 10, 79, 152, 7),
(30, 0, 11, 89, 163, 7),
(31, 0, 11, 89, 164, 7),
(32, 0, 11, 93, 164, 7),
(33, 0, 12, 89, 159, 7),
(34, 0, 12, 89, 160, 7),
(35, 0, 12, 93, 160, 7),
(36, 0, 13, 89, 155, 7),
(37, 0, 13, 89, 156, 7),
(38, 0, 13, 93, 156, 7),
(39, 0, 14, 89, 151, 7),
(40, 0, 14, 89, 152, 7),
(41, 0, 14, 93, 152, 7),
(42, 0, 15, 100, 151, 7),
(43, 0, 15, 96, 152, 7),
(44, 0, 15, 100, 152, 7),
(45, 0, 16, 89, 151, 6),
(46, 0, 16, 89, 152, 6),
(47, 0, 16, 93, 152, 6),
(48, 0, 17, 89, 155, 6),
(49, 0, 17, 89, 156, 6),
(50, 0, 17, 93, 156, 6),
(51, 0, 18, 89, 159, 6),
(52, 0, 18, 89, 160, 6),
(53, 0, 18, 93, 160, 6),
(54, 0, 19, 89, 163, 6),
(55, 0, 19, 89, 164, 6),
(56, 0, 19, 93, 164, 6),
(57, 0, 20, 101, 158, 6),
(58, 0, 20, 105, 156, 6),
(59, 0, 20, 105, 157, 6),
(60, 0, 21, 101, 163, 6),
(61, 0, 21, 105, 161, 6),
(62, 0, 21, 105, 162, 6),
(63, 0, 22, 89, 151, 5),
(64, 0, 22, 89, 152, 5),
(65, 0, 22, 93, 152, 5),
(66, 0, 23, 89, 155, 5),
(67, 0, 23, 89, 156, 5),
(68, 0, 23, 93, 156, 5),
(69, 0, 24, 89, 159, 5),
(70, 0, 24, 89, 160, 5),
(71, 0, 24, 93, 160, 5),
(72, 0, 25, 89, 163, 5),
(73, 0, 25, 89, 164, 5),
(74, 0, 25, 93, 164, 5),
(75, 0, 26, 101, 158, 5),
(76, 0, 26, 105, 156, 5),
(77, 0, 26, 105, 157, 5),
(78, 0, 27, 101, 163, 5),
(79, 0, 27, 105, 161, 5),
(80, 0, 27, 105, 162, 5),
(81, 0, 28, 89, 151, 4),
(82, 0, 28, 89, 152, 4),
(83, 0, 28, 93, 152, 4),
(84, 0, 29, 89, 155, 4),
(85, 0, 29, 89, 156, 4),
(86, 0, 29, 93, 156, 4),
(87, 0, 30, 89, 159, 4),
(88, 0, 30, 89, 160, 4),
(89, 0, 30, 93, 160, 4),
(90, 0, 31, 89, 163, 4),
(91, 0, 31, 89, 164, 4),
(92, 0, 31, 93, 164, 4),
(93, 0, 32, 101, 158, 4),
(94, 0, 32, 105, 156, 4),
(95, 0, 32, 105, 157, 4),
(96, 0, 33, 101, 163, 4),
(97, 0, 33, 105, 161, 4),
(98, 0, 33, 105, 162, 4),
(99, 0, 34, 56, 193, 6),
(100, 0, 34, 56, 194, 6),
(101, 0, 34, 54, 196, 6),
(102, 0, 35, 62, 193, 6),
(103, 0, 35, 62, 194, 6),
(104, 0, 35, 60, 196, 6),
(105, 0, 36, 56, 199, 6),
(106, 0, 36, 56, 200, 6),
(107, 0, 37, 62, 199, 6),
(108, 0, 37, 62, 200, 6),
(109, 0, 38, 56, 193, 5),
(110, 0, 38, 56, 194, 5),
(111, 0, 38, 54, 196, 5),
(112, 0, 39, 62, 193, 5),
(113, 0, 39, 62, 194, 5),
(114, 0, 39, 60, 196, 5),
(115, 0, 40, 54, 198, 5),
(116, 0, 40, 56, 199, 5),
(117, 0, 40, 56, 200, 5),
(118, 0, 41, 60, 198, 5),
(119, 0, 41, 62, 199, 5),
(120, 0, 41, 62, 200, 5),
(121, 0, 42, 55, 176, 6),
(122, 0, 42, 55, 177, 6),
(123, 0, 42, 57, 178, 6),
(124, 0, 43, 62, 176, 6),
(125, 0, 43, 62, 177, 6),
(126, 0, 43, 64, 179, 6),
(127, 0, 44, 72, 179, 6),
(128, 0, 44, 77, 177, 6),
(129, 0, 44, 77, 178, 6),
(130, 0, 45, 73, 172, 6),
(131, 0, 45, 73, 173, 6),
(132, 0, 45, 78, 174, 6),
(133, 0, 46, 73, 167, 6),
(134, 0, 46, 73, 168, 6),
(135, 0, 46, 78, 169, 6),
(136, 0, 47, 79, 161, 6),
(137, 0, 47, 79, 162, 6),
(138, 0, 47, 81, 163, 6),
(139, 0, 48, 84, 161, 6),
(140, 0, 48, 84, 162, 6),
(141, 0, 48, 86, 163, 6),
(142, 0, 49, 111, 142, 7),
(143, 0, 49, 116, 140, 7),
(144, 0, 49, 116, 141, 7),
(145, 0, 50, 111, 136, 7),
(146, 0, 50, 116, 134, 7),
(147, 0, 50, 116, 135, 7),
(148, 0, 51, 111, 130, 7),
(149, 0, 51, 116, 128, 7),
(150, 0, 51, 116, 129, 7),
(151, 0, 52, 111, 124, 7),
(152, 0, 52, 116, 122, 7),
(153, 0, 52, 116, 123, 7),
(154, 0, 53, 93, 138, 7),
(155, 0, 53, 93, 139, 7),
(156, 0, 53, 96, 132, 7),
(157, 0, 53, 99, 138, 7),
(158, 0, 53, 99, 139, 7),
(159, 0, 54, 88, 132, 7),
(160, 0, 54, 85, 138, 7),
(161, 0, 54, 85, 139, 7),
(162, 0, 54, 91, 138, 7),
(163, 0, 54, 91, 139, 7),
(164, 0, 55, 77, 138, 7),
(165, 0, 55, 77, 139, 7),
(166, 0, 55, 80, 132, 7),
(167, 0, 55, 83, 138, 7),
(168, 0, 55, 83, 139, 7),
(169, 0, 56, 77, 121, 7),
(170, 0, 56, 77, 122, 7),
(171, 0, 56, 83, 121, 7),
(172, 0, 56, 83, 122, 7),
(173, 0, 56, 80, 128, 7),
(174, 0, 57, 85, 121, 7),
(175, 0, 57, 85, 122, 7),
(176, 0, 57, 91, 121, 7),
(177, 0, 57, 91, 122, 7),
(178, 0, 57, 88, 128, 7),
(179, 0, 58, 93, 121, 7),
(180, 0, 58, 93, 122, 7),
(181, 0, 58, 99, 121, 7),
(182, 0, 58, 99, 122, 7),
(183, 0, 58, 96, 128, 7),
(184, 0, 59, 70, 107, 7),
(185, 0, 59, 70, 108, 7),
(186, 0, 59, 75, 109, 7),
(187, 0, 60, 70, 100, 7),
(188, 0, 60, 70, 101, 7),
(189, 0, 60, 75, 102, 7),
(190, 0, 61, 56, 96, 7),
(191, 0, 61, 56, 97, 7),
(192, 0, 61, 56, 104, 7),
(193, 0, 61, 56, 105, 7),
(194, 0, 61, 64, 103, 7),
(195, 0, 62, 69, 84, 7),
(196, 0, 62, 69, 85, 7),
(197, 0, 62, 76, 87, 7),
(198, 0, 62, 76, 88, 7),
(199, 0, 62, 71, 94, 7),
(200, 0, 63, 75, 90, 7),
(201, 0, 63, 75, 91, 7),
(202, 0, 63, 79, 94, 7),
(203, 0, 63, 83, 84, 7),
(204, 0, 63, 83, 85, 7),
(205, 0, 64, 108, 92, 7),
(206, 0, 64, 116, 86, 7),
(207, 0, 64, 116, 87, 7),
(208, 0, 64, 116, 89, 7),
(209, 0, 64, 116, 90, 7),
(210, 0, 65, 116, 93, 7),
(211, 0, 65, 116, 94, 7),
(212, 0, 65, 111, 96, 7),
(213, 0, 66, 49, 119, 7),
(214, 0, 66, 52, 116, 7),
(215, 0, 66, 49, 120, 7),
(216, 0, 67, 41, 119, 7),
(217, 0, 67, 44, 116, 7),
(218, 0, 67, 41, 120, 7),
(219, 0, 68, 41, 110, 7),
(220, 0, 68, 41, 111, 7),
(221, 0, 68, 44, 114, 7),
(222, 0, 69, 49, 110, 7),
(223, 0, 69, 49, 111, 7),
(224, 0, 69, 52, 114, 7),
(225, 0, 70, 48, 119, 6),
(226, 0, 70, 51, 116, 6),
(227, 0, 70, 48, 120, 6),
(228, 0, 71, 41, 119, 6),
(229, 0, 71, 44, 116, 6),
(230, 0, 71, 41, 120, 6),
(231, 0, 72, 41, 110, 6),
(232, 0, 72, 41, 111, 6),
(233, 0, 72, 44, 114, 6),
(234, 0, 73, 48, 110, 6),
(235, 0, 73, 48, 111, 6),
(236, 0, 73, 51, 114, 6),
(237, 0, 74, 50, 117, 5),
(238, 0, 74, 50, 118, 5),
(239, 0, 74, 55, 119, 5),
(240, 0, 75, 41, 119, 5),
(241, 0, 75, 47, 119, 5),
(242, 0, 75, 41, 120, 5),
(243, 0, 76, 53, 110, 5),
(244, 0, 76, 53, 111, 5),
(245, 0, 76, 47, 114, 5),
(246, 0, 78, 262, 594, 7),
(247, 0, 78, 262, 595, 7),
(248, 0, 78, 265, 598, 7),
(249, 0, 79, 271, 594, 7),
(250, 0, 79, 271, 595, 7),
(251, 0, 79, 274, 598, 7),
(252, 0, 80, 280, 594, 7),
(253, 0, 80, 280, 595, 7),
(254, 0, 80, 283, 598, 7),
(255, 0, 81, 88, 618, 7),
(256, 0, 81, 88, 619, 7),
(257, 0, 81, 94, 618, 7),
(258, 0, 81, 94, 619, 7),
(259, 0, 81, 91, 622, 7),
(260, 0, 81, 251, 606, 7),
(261, 0, 81, 251, 607, 7),
(262, 0, 81, 254, 610, 7),
(263, 0, 82, 97, 618, 7),
(264, 0, 82, 97, 619, 7),
(265, 0, 82, 103, 618, 7),
(266, 0, 82, 103, 619, 7),
(267, 0, 82, 100, 622, 7),
(268, 0, 82, 260, 606, 7),
(269, 0, 82, 260, 607, 7),
(270, 0, 82, 263, 610, 7),
(271, 0, 83, 106, 618, 7),
(272, 0, 83, 106, 619, 7),
(273, 0, 83, 109, 622, 7),
(274, 0, 83, 112, 618, 7),
(275, 0, 83, 112, 619, 7),
(276, 0, 83, 271, 606, 7),
(277, 0, 83, 271, 607, 7),
(278, 0, 83, 274, 610, 7),
(279, 0, 84, 280, 606, 7),
(280, 0, 84, 280, 607, 7),
(281, 0, 84, 283, 610, 7),
(282, 0, 85, 450, 633, 7),
(283, 0, 85, 450, 634, 7),
(284, 0, 85, 451, 638, 7),
(285, 0, 86, 487, 634, 7),
(286, 0, 86, 487, 635, 7),
(287, 0, 86, 484, 636, 7),
(288, 0, 87, 446, 643, 7),
(289,
0, 87, 446, 644, 7),
(290, 0, 87, 453, 642, 7),
(291, 0, 88, 437, 625, 6),
(292, 0, 88, 437, 626, 6),
(293, 0, 88, 438, 629, 6),
(294, 0, 89, 441, 625, 6),
(295, 0, 89, 441, 626, 6),
(296, 0, 89, 442, 629, 6),
(297, 0, 90, 439, 642, 6),
(298, 0, 90, 438, 645, 6),
(299, 0, 90, 438, 646, 6),
(300, 0, 91, 443, 642, 6),
(301, 0, 91, 442, 645, 6),
(302, 0, 91, 442, 646, 6),
(303, 0, 92, 481, 623, 6),
(304, 0, 92, 481, 624, 6),
(305, 0, 92, 483, 626, 6),
(306, 0, 92, 484, 626, 6),
(307, 0, 94, 534, 639, 7),
(308, 0, 94, 534, 640, 7),
(309, 0, 94, 535, 642, 7),
(310, 0, 94, 532, 645, 7),
(311, 0, 94, 533, 645, 7),
(312, 0, 95, 526, 639, 7),
(313, 0, 95, 526, 640, 7),
(314, 0, 95, 527, 645, 7),
(315, 0, 95, 528, 645, 7),
(316, 0, 96, 521, 639, 7),
(317, 0, 96, 521, 640, 7),
(318, 0, 96, 522, 645, 7),
(319, 0, 96, 523, 645, 7),
(320, 0, 97, 512, 645, 7),
(321, 0, 97, 512, 646, 7),
(322, 0, 97, 518, 646, 7),
(323, 0, 97, 518, 647, 7),
(324, 0, 98, 512, 650, 7),
(325, 0, 98, 512, 651, 7),
(326, 0, 98, 518, 651, 7),
(327, 0, 98, 515, 654, 7),
(328, 0, 98, 518, 652, 7),
(329, 0, 99, 531, 639, 6),
(330, 0, 99, 531, 640, 6),
(331, 0, 99, 533, 643, 6),
(332, 0, 99, 534, 643, 6),
(333, 0, 99, 535, 641, 6),
(334, 0, 100, 526, 639, 6),
(335, 0, 100, 526, 640, 6),
(336, 0, 100, 528, 643, 6),
(337, 0, 100, 529, 643, 6),
(338, 0, 101, 521, 639, 6),
(339, 0, 101, 521, 640, 6),
(340, 0, 101, 523, 643, 6),
(341, 0, 101, 524, 643, 6),
(342, 0, 102, 512, 645, 6),
(343, 0, 102, 512, 646, 6),
(344, 0, 102, 516, 646, 6),
(345, 0, 102, 516, 647, 6),
(346, 0, 103, 512, 650, 6),
(347, 0, 103, 512, 651, 6),
(348, 0, 103, 514, 654, 6),
(349, 0, 103, 516, 652, 6),
(350, 0, 103, 516, 653, 6),
(351, 0, 104, 94, 99, 7),
(352, 0, 104, 94, 100, 7),
(353, 0, 104, 96, 96, 7),
(354, 0, 105, 354, 941, 7),
(355, 0, 105, 354, 942, 7),
(356, 0, 105, 360, 941, 7),
(357, 0, 105, 360, 942, 7),
(358, 0, 105, 357, 945, 7),
(359, 0, 106, 320, 939, 7),
(360, 0, 106, 323, 938, 7),
(361, 0, 106, 323, 939, 7),
(362, 0, 107, 320, 935, 7),
(363, 0, 107, 323, 934, 7),
(364, 0, 107, 323, 935, 7),
(365, 0, 108, 320, 931, 7),
(366, 0, 108, 323, 930, 7),
(367, 0, 108, 323, 931, 7),
(368, 0, 109, 335, 922, 7),
(369, 0, 109, 333, 926, 7),
(370, 0, 109, 333, 927, 7),
(371, 0, 110, 341, 922, 7),
(372, 0, 110, 339, 926, 7),
(373, 0, 110, 339, 927, 7),
(374, 0, 111, 347, 922, 7),
(375, 0, 111, 345, 926, 7),
(376, 0, 111, 345, 927, 7),
(377, 0, 112, 334, 907, 7),
(378, 0, 112, 334, 908, 7),
(379, 0, 112, 337, 907, 6),
(380, 0, 112, 337, 908, 6),
(381, 0, 112, 335, 914, 7),
(382, 0, 113, 343, 907, 6),
(383, 0, 113, 340, 907, 7),
(384, 0, 113, 343, 908, 6),
(385, 0, 113, 340, 908, 7),
(386, 0, 113, 341, 914, 7),
(387, 0, 114, 346, 907, 7),
(388, 0, 114, 349, 907, 6),
(389, 0, 114, 346, 908, 7),
(390, 0, 114, 349, 908, 6),
(391, 0, 114, 347, 914, 7),
(392, 0, 115, 349, 893, 7),
(393, 0, 115, 346, 901, 7),
(394, 0, 115, 346, 902, 7),
(395, 0, 115, 348, 901, 7),
(396, 0, 115, 348, 902, 7),
(397, 0, 116, 355, 894, 7),
(398, 0, 116, 355, 895, 7),
(399, 0, 116, 362, 898, 7),
(400, 0, 116, 362, 899, 7),
(401, 0, 116, 354, 901, 6),
(402, 0, 116, 354, 902, 6),
(403, 0, 116, 356, 901, 6),
(404, 0, 116, 356, 902, 6),
(405, 0, 117, 376, 923, 7),
(406, 0, 117, 368, 927, 7),
(407, 0, 117, 376, 924, 7),
(408, 0, 117, 376, 930, 7),
(409, 0, 117, 376, 931, 7),
(410, 0, 118, 369, 935, 7),
(411, 0, 118, 376, 933, 7),
(412, 0, 118, 376, 934, 7),
(413, 0, 119, 376, 939, 7),
(414, 0, 119, 369, 941, 7),
(415, 0, 119, 376, 940, 7),
(416, 0, 120, 378, 923, 7),
(417, 0, 120, 378, 924, 7),
(418, 0, 120, 378, 930, 7),
(419, 0, 120, 378, 931, 7),
(420, 0, 120, 386, 927, 7),
(421, 0, 121, 378, 933, 7),
(422, 0, 121, 378, 934, 7),
(423, 0, 121, 386, 935, 7),
(424, 0, 122, 80, 64, 13),
(425, 0, 122, 80, 65, 13),
(426, 0, 122, 80, 64, 14),
(427, 0, 122, 80, 65, 14),
(428, 0, 122, 82, 70, 14),
(429, 0, 122, 83, 70, 14),
(430, 0, 123, 89, 64, 13),
(431, 0, 123, 89, 65, 13),
(432, 0, 123, 89, 64, 14),
(433, 0, 123, 89, 65, 14),
(434, 0, 123, 91, 70, 14),
(435, 0, 123, 92, 70, 14),
(436, 0, 124, 98, 64, 13),
(437, 0, 124, 98, 65, 13),
(438, 0, 124, 98, 64, 14),
(439, 0, 124, 98, 65, 14),
(440, 0, 124, 100, 70, 14),
(441, 0, 124, 101, 70, 14),
(442, 0, 126, 516, 750, 13),
(443, 0, 126, 518, 751, 13),
(444, 0, 126, 514, 754, 12),
(445, 0, 126, 514, 755, 12),
(446, 0, 126, 518, 752, 13),
(447, 0, 126, 516, 756, 13),
(448, 0, 127, 508, 750, 13),
(449, 0, 127, 510, 751, 13),
(450, 0, 127, 506, 754, 12),
(451, 0, 127, 506, 755, 12),
(452, 0, 127, 510, 752, 13),
(453, 0, 127, 508, 756, 13),
(454, 0, 128, 506, 727, 12),
(455, 0, 128, 510, 727, 13),
(456, 0, 128, 506, 728, 12),
(457, 0, 128, 510, 728, 13),
(458, 0, 128, 508, 732, 13),
(459, 0, 129, 514, 727, 12),
(460, 0, 129, 518, 727, 13),
(461, 0, 129, 514, 728, 12),
(462, 0, 129, 518, 728, 13),
(463, 0, 130, 488, 727, 13),
(464, 0, 130, 488, 728, 13),
(465, 0, 130, 492, 731, 13),
(466, 0, 131, 502, 727, 13),
(467, 0, 131, 498, 731, 13),
(468, 0, 131, 502, 728, 13),
(469, 0, 132, 492, 728, 12),
(470, 0, 132, 488, 733, 12),
(471, 0, 132, 488, 734, 12),
(472, 0, 133, 498, 728, 12),
(473, 0, 133, 502, 733, 12),
(474, 0, 133, 502, 734, 12),
(475, 0, 134, 535, 756, 13),
(476, 0, 134, 535, 757, 13),
(477, 0, 134, 539, 760, 13),
(478, 0, 135, 549, 756, 13),
(479, 0, 135, 549, 757, 13),
(480, 0, 135, 545, 760, 13),
(481, 0, 136, 539, 757, 12),
(482, 0, 136, 535, 762, 12),
(483, 0, 136, 535, 763, 12),
(484, 0, 137, 545, 757, 12),
(485, 0, 137, 549, 762, 12),
(486, 0, 137, 549, 763, 12),
(487, 0, 138, 539, 742, 13),
(488, 0, 138, 541, 740, 13),
(489, 0, 138, 541, 741, 13),
(490, 0, 139, 545, 742, 13),
(491, 0, 139, 547, 740, 13),
(492, 0, 139, 547, 741, 13),
(493, 0, 140, 551, 742, 13),
(494, 0, 140, 553, 740, 13),
(495, 0, 140, 553, 741, 13),
(496, 0, 141, 539, 751, 13),
(497, 0, 141, 541, 752, 13),
(498, 0, 141, 541, 753, 13),
(499, 0, 142, 545, 751, 13),
(500, 0, 142, 547, 752, 13),
(501, 0, 142, 547, 753, 13),
(502, 0, 143, 551, 751, 13),
(503, 0, 143, 553, 752, 13),
(504, 0, 143, 553, 753, 13),
(505, 0, 144, 562, 735, 12),
(506, 0, 144, 565, 735, 13),
(507, 0, 144, 562, 736, 12),
(508, 0, 144, 561, 738, 13),
(509, 0, 144, 565, 736, 13),
(510, 0, 145, 553, 733, 13),
(511, 0, 146, 545, 733, 13),
(512, 0, 147, 537, 733, 13),
(513, 0, 148, 733, 1134, 7),
(514, 0, 148, 734, 1134, 7),
(515, 0, 148, 738, 1132, 7),
(516, 0, 149, 733, 1145, 7),
(517, 0, 149, 734, 1145, 7),
(518, 0, 149, 738, 1143, 7),
(519, 0, 150, 746, 1127, 7),
(520, 0, 150, 744, 1128, 7),
(521, 0, 150, 744, 1129, 7),
(522, 0, 150, 746, 1134, 7),
(523, 0, 151, 751, 1127, 7),
(524, 0, 151, 749, 1128, 7),
(525, 0, 151, 749, 1129, 7),
(526, 0, 151, 751, 1134, 7),
(527, 0, 152, 756, 1127, 7),
(528, 0, 152, 754, 1128, 7),
(529, 0, 152, 754, 1129, 7),
(530, 0, 152, 756, 1134, 7),
(531, 0, 153, 746, 1141, 7),
(532, 0, 153, 747, 1147, 7),
(533, 0, 153, 747, 1148, 7),
(534, 0, 154, 751, 1141, 7),
(535, 0, 154, 752, 1147, 7),
(536, 0, 154, 752, 1148, 7),
(537, 0, 155, 756, 1141, 7),
(538, 0, 155, 757, 1147, 7),
(539, 0, 155, 757, 1148, 7),
(540, 0, 156, 788, 1131, 7),
(541, 0, 156, 788, 1132, 7),
(542, 0, 156, 790, 1135, 7),
(543, 0, 157, 790, 1141, 7),
(544, 0, 157, 792, 1143, 7),
(545, 0, 157, 792, 1144, 7),
(546, 0, 158, 796, 1141, 7),
(547, 0, 158, 798, 1143, 7),
(548, 0, 158, 798, 1144, 7),
(549, 0, 159, 802, 1141, 7),
(550, 0, 159, 804, 1143, 7),
(551, 0, 159, 804, 1144, 7),
(552, 0, 160, 807, 1131, 7),
(553, 0, 160, 807, 1132, 7),
(554, 0, 160, 809, 1135, 7),
(555, 0, 161, 815, 1131, 7),
(556, 0, 161, 815, 1132, 7),
(557, 0, 161, 817, 1135, 7);
-- --------------------------------------------------------
--
-- Estrutura da tabela `tile_items`
--
CREATE TABLE IF NOT EXISTS `tile_items` (
 `tile_id` int(10) unsigned NOT NULL,
 `world_id`