-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Fev 08, 2017 as 02:44 
-- 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: `massa`
--

-- --------------------------------------------------------

--
-- 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(20) 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',
  `loot_time` int(15) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Extraindo dados da tabela `accounts`
--

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `loot_time`) VALUES
(1, '1', '1', '', 9999, 1451340395, '', '0', 0, 0, 1, 0),
(2, 'server', 'servename', '', 9999, 1451340395, '', '0', 0, 0, 1, 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 `auction_system`
--

CREATE TABLE IF NOT EXISTS `auction_system` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `cost` int(11) DEFAULT NULL,
  `date` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Extraindo dados da tabela `auction_system`
--


-- --------------------------------------------------------

--
-- 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=1 ;

--
-- Extraindo dados da tabela `bans`
--


-- --------------------------------------------------------

--
-- 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` int(10) unsigned NOT NULL,
  `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`
--


-- --------------------------------------------------------

--
-- 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`,`world_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Extraindo dados da tabela `guilds`
--

INSERT INTO `guilds` (`id`, `world_id`, `name`, `ownerid`, `creationdata`, `checkdata`, `motd`, `balance`) VALUES
(1, 0, 'Staff', 2, 1451340658, 0, 'Your guild has been successfully created, to view all available commands type: !commands. If you would like to remove this message use !cleanmotd and to set new motd use !setmotd text.', 0),
(2, 0, 'Backup Staff', 3, 1451340667, 0, 'Your guild has been successfully created, to view all available commands type: !commands. If you would like to remove this message use !cleanmotd and to set new motd use !setmotd text.', 0);

--
-- 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=7 ;

--
-- Extraindo dados da tabela `guild_ranks`
--

INSERT INTO `guild_ranks` (`id`, `guild_id`, `name`, `level`) VALUES
(1, 1, 'Leader', 3),
(2, 1, 'Vice-Leader', 2),
(3, 1, 'Member', 1),
(4, 2, 'Leader', 3),
(5, 2, 'Vice-Leader', 2),
(6, 2, 'Member', 1);

-- --------------------------------------------------------

--
-- 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=2 ;

--
-- Extraindo dados da tabela `guild_wars`
--

INSERT INTO `guild_wars` (`id`, `guild_id`, `enemy_id`, `begin`, `end`, `frags`, `payment`, `guild_kills`, `enemy_kills`, `status`) VALUES
(1, 2, 1, 1451340698, 0, 100, 0, 0, 0, 1);

-- --------------------------------------------------------

--
-- 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
(268, 0, 0, 0, 0, 0, 'House #0', 1, 16, 42000, 0, 3, 4, 42, 0, 0),
(269, 0, 0, 0, 0, 0, 'House #1', 1, 14, 40000, 0, 2, 4, 40, 0, 0),
(270, 0, 0, 0, 0, 0, 'House #2', 1, 26, 60000, 0, 4, 4, 60, 0, 0),
(273, 0, 0, 0, 0, 0, 'House #3', 1, 41, 96000, 0, 4, 4, 96, 0, 0),
(274, 0, 0, 0, 0, 0, 'House #4', 1, 23, 50000, 0, 3, 1, 50, 0, 0),
(275, 0, 0, 0, 0, 0, 'House #5', 1, 20, 45000, 0, 2, 1, 45, 0, 0),
(276, 0, 0, 0, 0, 0, 'House #6', 1, 11, 30000, 0, 2, 1, 30, 0, 0),
(277, 0, 0, 0, 0, 0, 'House #7', 1, 15, 37000, 0, 1, 1, 37, 0, 0),
(278, 0, 0, 0, 0, 0, 'House #8', 1, 20, 42000, 0, 2, 1, 42, 0, 0),
(279, 0, 0, 0, 0, 0, 'House #9', 1, 29, 56000, 0, 2, 2, 56, 0, 0),
(280, 0, 0, 0, 0, 0, 'House #10', 1, 11, 24000, 0, 1, 1, 24, 0, 0),
(281, 0, 0, 0, 0, 0, 'House #11', 1, 11, 30000, 0, 1, 1, 30, 0, 0),
(282, 0, 0, 0, 0, 0, 'House #12', 1, 11, 25000, 0, 1, 1, 25, 0, 0),
(283, 0, 0, 0, 0, 0, 'House #13', 1, 11, 24000, 0, 1, 1, 24, 0, 0),
(284, 0, 0, 0, 0, 0, 'House #14', 1, 17, 45000, 0, 1, 4, 45, 0, 0),
(285, 0, 0, 0, 0, 0, 'House #15', 1, 17, 41000, 0, 1, 1, 41, 0, 0),
(286, 0, 0, 0, 0, 0, 'House #16', 1, 14, 35000, 0, 2, 1, 35, 0, 0),
(287, 0, 0, 0, 0, 0, 'House #17', 1, 29, 70000, 0, 2, 1, 70, 0, 0),
(288, 0, 0, 0, 0, 0, 'House #18', 1, 19, 51000, 0, 5, 0, 51, 0, 0),
(289, 0, 0, 0, 0, 0, 'House #19', 1, 15, 35000, 0, 1, 0, 35, 0, 0),
(290, 0, 0, 0, 0, 0, 'House #20', 1, 8, 20000, 0, 1, 0, 20, 0, 0),
(291, 0, 0, 0, 0, 0, 'House #21', 1, 19, 42000, 0, 5, 0, 42, 0, 0),
(292, 0, 0, 0, 0, 0, 'House #22', 1, 12, 30000, 0, 3, 0, 30, 0, 0),
(293, 0, 0, 0, 0, 0, 'House #23', 1, 7, 20000, 0, 1, 2, 20, 0, 0),
(294, 0, 0, 0, 0, 0, 'House #24', 1, 4, 15000, 0, 1, 2, 15, 0, 0),
(295, 0, 0, 0, 0, 0, 'House #25', 1, 4, 20000, 0, 1, 2, 20, 0, 0),
(296, 0, 0, 0, 0, 0, 'House #26', 1, 4, 20000, 0, 2, 2, 20, 0, 0),
(297, 0, 0, 0, 0, 0, 'House #27', 1, 4, 15000, 0, 2, 2, 15, 0, 0),
(298, 0, 0, 0, 0, 0, 'House #28', 1, 7, 20000, 0, 2, 2, 20, 0, 0),
(299, 0, 0, 0, 0, 0, 'House #29', 1, 13, 39000, 0, 1, 0, 39, 0, 0),
(300, 0, 0, 0, 0, 0, 'House #30', 1, 8, 24000, 0, 1, 0, 24, 0, 0),
(301, 0, 0, 0, 0, 0, 'House #31', 1, 10, 24000, 0, 1, 0, 24, 0, 0),
(302, 0, 0, 0, 0, 0, 'House #32', 1, 8, 24000, 0, 1, 0, 24, 0, 0),
(303, 0, 0, 0, 0, 0, 'House #33', 1, 334, 652000, 0, 7, 0, 652, 0, 0),
(304, 0, 0, 0, 0, 0, 'House #34', 1, 14, 30000, 0, 2, 2, 30, 0, 0),
(305, 0, 0, 0, 0, 0, 'House #35', 1, 14, 30000, 0, 3, 2, 30, 0, 0),
(306, 0, 0, 0, 0, 0, 'House #36', 1, 14, 30000, 0, 2, 2, 30, 0, 0),
(307, 0, 0, 0, 0, 0, 'House #37', 1, 14, 30000, 0, 3, 2, 30, 0, 0),
(308, 0, 0, 0, 0, 0, 'House #38', 1, 22, 42000, 0, 3, 2, 42, 0, 0),
(309, 0, 0, 0, 0, 0, 'House #39', 1, 14, 30000, 0, 2, 2, 30, 0, 0),
(310, 0, 0, 0, 0, 0, 'House #40', 1, 26, 61000, 0, 7, 2, 61, 0, 0),
(311, 0, 0, 0, 0, 0, 'House #41', 1, 30, 60000, 0, 4, 2, 60, 0, 0),
(312, 0, 0, 0, 0, 0, 'House #42', 1, 18, 35000, 0, 2, 2, 35, 0, 0),
(313, 0, 0, 0, 0, 0, 'House #43', 1, 18, 35000, 0, 2, 2, 35, 0, 0),
(314, 0, 0, 0, 0, 0, 'House #44', 1, 23, 42000, 0, 2, 2, 42, 0, 0),
(315, 0, 0, 0, 0, 0, 'House #45', 1, 18, 35000, 0, 2, 2, 35, 0, 0),
(316, 0, 0, 0, 0, 0, 'House #46', 1, 15, 36000, 0, 2, 2, 36, 0, 0),
(317, 0, 0, 0, 0, 0, 'House #47', 1, 16, 44000, 0, 3, 2, 44, 0, 0),
(318, 0, 0, 0, 0, 0, 'House #48', 1, 16, 45000, 0, 3, 2, 45, 0, 0),
(319, 0, 0, 0, 0, 0, 'House #49', 1, 16, 45000, 0, 3, 2, 45, 0, 0),
(320, 0, 0, 0, 0, 0, 'House #50', 1, 16, 45000, 0, 3, 2, 45, 0, 0),
(321, 0, 0, 0, 0, 0, 'House #51', 1, 40, 84000, 0, 1, 0, 84, 0, 0),
(322, 0, 0, 0, 0, 0, 'House #52', 1, 24, 50000, 0, 3, 0, 50, 0, 0),
(323, 0, 0, 0, 0, 0, 'House #53', 1, 12, 30000, 0, 1, 0, 30, 0, 0),
(324, 0, 0, 0, 0, 0, 'House #54', 1, 12, 30000, 0, 1, 0, 30, 0, 0),
(325, 0, 0, 0, 0, 0, 'House #55', 1, 12, 25000, 0, 4, 0, 25, 0, 0),
(326, 0, 0, 0, 0, 0, 'House #56', 1, 34, 66000, 0, 4, 0, 66, 0, 0),
(327, 0, 0, 0, 0, 0, 'House #57', 1, 15, 35000, 0, 4, 0, 35, 0, 0),
(328, 0, 0, 0, 0, 0, 'House #58', 1, 22, 48000, 0, 2, 0, 48, 0, 0),
(329, 0, 0, 0, 0, 0, 'House #59', 1, 25, 49000, 0, 1, 0, 49, 0, 0),
(330, 0, 0, 0, 0, 0, 'House #60', 1, 9, 20000, 0, 2, 0, 20, 0, 0),
(331, 0, 0, 0, 0, 0, 'House #61', 1, 11, 28000, 0, 1, 0, 28, 0, 0),
(332, 0, 0, 0, 0, 0, 'House #62', 1, 12, 30000, 0, 2, 0, 30, 0, 0),
(333, 0, 0, 0, 0, 0, 'House #63', 1, 9, 20000, 0, 2, 0, 20, 0, 0),
(334, 0, 0, 0, 0, 0, 'House #64', 1, 6, 15000, 0, 2, 0, 15, 0, 0),
(335, 0, 0, 0, 0, 0, 'House #65', 1, 9, 19000, 0, 1, 0, 19, 0, 0),
(336, 0, 0, 0, 0, 0, 'House #66', 1, 13, 33000, 0, 1, 0, 33, 0, 0),
(337, 0, 0, 0, 0, 0, 'House #67', 1, 12, 25000, 0, 1, 0, 25, 0, 0),
(338, 0, 0, 0, 0, 0, 'House #68', 1, 12, 25000, 0, 1, 0, 25, 0, 0),
(339, 0, 0, 0, 0, 0, 'House #69', 1, 9, 20000, 0, 1, 0, 20, 0, 0),
(340, 0, 0, 0, 0, 0, 'House #70', 1, 9, 25000, 0, 2, 0, 25, 0, 0),
(341, 0, 0, 0, 0, 0, 'House #71', 1, 11, 24000, 0, 3, 0, 24, 0, 0),
(342, 0, 0, 0, 0, 0, 'House #72', 1, 12, 21000, 0, 3, 0, 21, 0, 0),
(343, 0, 0, 0, 0, 0, 'House #73', 1, 16, 30000, 0, 2, 0, 30, 0, 0),
(344, 0, 0, 0, 0, 0, 'House #74', 1, 16, 30000, 0, 2, 0, 30, 0, 0),
(345, 0, 0, 0, 0, 0, 'House #75', 1, 15, 35000, 0, 1, 0, 35, 0, 0),
(346, 0, 0, 0, 0, 0, 'House #76', 1, 15, 35000, 0, 1, 0, 35, 0, 0),
(347, 0, 0, 0, 0, 0, 'House #77', 1, 30, 56000, 0, 1, 0, 56, 0, 0),
(348, 0, 0, 0, 0, 0, 'House #78', 1, 12, 30000, 0, 1, 0, 30, 0, 0),
(349, 0, 0, 0, 0, 0, 'House #79', 1, 12, 30000, 0, 1, 0, 30, 0, 0),
(350, 0, 0, 0, 0, 0, 'House #80', 1, 15, 35000, 0, 1, 0, 35, 0, 0),
(351, 0, 0, 0, 0, 0, 'House #81', 1, 98, 193000, 0, 1, 0, 193, 0, 0),
(352, 0, 0, 0, 0, 0, 'House #82', 1, 47, 100000, 0, 1, 0, 100, 0, 0),
(353, 0, 0, 0, 0, 0, 'House #83', 1, 30, 63000, 0, 3, 0, 63, 0, 0),
(354, 0, 0, 0, 0, 0, 'House #84', 1, 36, 74000, 0, 3, 0, 74, 0, 0),
(355, 0, 0, 0, 0, 0, 'House #85', 1, 36, 72000, 0, 3, 0, 72, 0, 0),
(356, 0, 0, 0, 0, 0, 'House #86', 1, 35, 70000, 0, 3, 0, 70, 0, 0),
(357, 0, 0, 0, 0, 0, 'House #87', 1, 24, 48000, 0, 2, 0, 48, 0, 0),
(358, 0, 0, 0, 0, 0, 'House #88', 1, 32, 66000, 0, 3, 0, 66, 0, 0),
(359, 0, 0, 0, 0, 0, 'House #89', 1, 32, 66000, 0, 3, 0, 66, 0, 0),
(360, 0, 0, 0, 0, 0, 'House #90', 1, 42, 64000, 0, 1, 0, 64, 0, 0),
(361, 0, 0, 0, 0, 0, 'House #91', 1, 42, 72000, 0, 1, 0, 72, 0, 0),
(362, 0, 0, 0, 0, 0, 'House #92', 1, 30, 56000, 0, 1, 0, 56, 0, 0),
(363, 0, 0, 0, 0, 0, 'House #93', 1, 15, 30000, 0, 1, 0, 30, 0, 0),
(364, 0, 0, 0, 0, 0, 'House #94', 1, 15, 35000, 0, 1, 0, 35, 0, 0),
(365, 0, 0, 0, 0, 0, 'House #95', 1, 27, 61000, 0, 2, 0, 61, 0, 0),
(366, 0, 0, 0, 0, 0, 'House #96', 1, 5, 18000, 0, 1, 2, 18, 0, 0),
(367, 0, 0, 0, 0, 0, 'House #97', 1, 5, 18000, 0, 1, 2, 18, 0, 0),
(368, 0, 0, 0, 0, 0, 'House #98', 1, 5, 18000, 0, 1, 2, 18, 0, 0),
(369, 0, 0, 0, 0, 0, 'House #99', 1, 5, 24000, 0, 1, 2, 24, 0, 0),
(370, 0, 0, 0, 0, 0, 'House #100', 1, 30, 48000, 0, 1, 0, 48, 0, 0),
(371, 0, 0, 0, 0, 0, 'House #101', 1, 30, 56000, 0, 1, 0, 56, 0, 0),
(372, 0, 0, 0, 0, 0, 'House #102', 1, 18, 44000, 0, 1, 4, 44, 0, 0),
(373, 0, 0, 0, 0, 0, 'House #103', 1, 18, 50000, 0, 1, 4, 50, 0, 0),
(374, 0, 0, 0, 0, 0, 'House #104', 1, 7, 20000, 0, 1, 2, 20, 0, 0),
(375, 0, 0, 0, 0, 0, 'House #105', 1, 10, 28000, 0, 1, 2, 28, 0, 0),
(376, 0, 0, 0, 0, 0, 'House #106', 1, 10, 25000, 0, 1, 2, 25, 0, 0),
(377, 0, 0, 0, 0, 0, 'House #107', 1, 10, 25000, 0, 1, 2, 25, 0, 0),
(378, 0, 0, 0, 0, 0, 'House #108', 1, 24, 60000, 0, 1, 8, 60, 0, 0),
(379, 0, 0, 0, 0, 0, 'House #109', 1, 10, 25000, 0, 1, 2, 25, 0, 0),
(380, 0, 0, 0, 0, 0, 'House #100', 1, 10, 28000, 0, 1, 2, 28, 0, 0),
(381, 0, 0, 0, 0, 0, 'House #111', 1, 10, 25000, 0, 1, 2, 25, 0, 0),
(382, 0, 0, 0, 0, 0, 'House #112', 1, 7, 20000, 0, 1, 2, 20, 0, 0),
(383, 0, 0, 0, 0, 0, 'House #113', 1, 17, 47000, 0, 0, 0, 47, 0, 0),
(384, 0, 0, 0, 0, 0, 'House #114', 1, 28, 54000, 0, 1, 0, 54, 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 `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` tinyint(1) NOT NULL DEFAULT '0',
  `description` varchar(255) NOT NULL DEFAULT '',
  `cast` tinyint(4) NOT NULL DEFAULT '0',
  `castViewers` int(11) NOT NULL DEFAULT '0',
  `castDescription` varchar(255) NOT NULL,
  `auction_balance` int(11) NOT NULL DEFAULT '0',
  `resets` int(11) NOT NULL DEFAULT '0',
  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=9 ;

--
-- 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`, `cast`, `castViewers`, `castDescription`, `auction_balance`, `resets`) VALUES
(1, 'Account Manager', 0, 1, 1, 8, 0, 150, 150, 4200, 0, 0, 0, 0, 302, 3, 4, 150, 150, 0, 100, 1, 10160, 10054, 7, '', 400, 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),
(4, 'Rook Sample', 0, 1, 2, 8, 0, 150, 150, 4200, 0, 0, 0, 0, 110, 0, 4, 150, 150, 0, 100, 1, 10160, 10054, 7, '', 400, 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),
(5, 'Sorcerer Sample', 0, 1, 2, 8, 1, 150, 150, 4200, 0, 0, 0, 0, 110, 0, 4, 150, 150, 0, 100, 1, 10160, 10054, 7, '', 400, 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),
(6, 'Druid Sample', 0, 1, 2, 8, 2, 150, 150, 4200, 0, 0, 0, 0, 110, 0, 4, 150, 150, 0, 100, 1, 10160, 10054, 7, '', 400, 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),
(7, 'Paladin Sample', 0, 1, 2, 8, 3, 150, 150, 4200, 0, 0, 0, 0, 110, 0, 4, 150, 150, 0, 100, 1, 10160, 10054, 7, '', 400, 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),
(8, 'Knight Sample', 0, 1, 2, 8, 4, 150, 150, 4200, 0, 0, 0, 0, 110, 0, 4, 150, 150, 0, 100, 1, 10160, 10054, 7, '', 400, 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);

--
-- 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`
--


-- --------------------------------------------------------

--
-- 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
(1, 0, 10, 0),
(1, 1, 10, 0),
(1, 2, 10, 0),
(1, 3, 10, 0),
(1, 4, 10, 0),
(1, 5, 10, 0),
(1, 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);

-- --------------------------------------------------------

--
-- 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` int(10) unsigned 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`
--


-- --------------------------------------------------------

--
-- 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', '26'),
('encryption', '0'),
('vahash_key', 'ND65-5WPO-UWV5-492I');

-- --------------------------------------------------------

--
-- 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, 'Bem vindo ao LoucoMassa!');

-- --------------------------------------------------------

--
-- 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, 1451340396);

-- --------------------------------------------------------

--
-- 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, 268, 10147, 10059, 7),
(1, 0, 268, 10148, 10059, 7),
(2, 0, 268, 10149, 10059, 7),
(3, 0, 268, 10146, 10063, 7),
(4, 0, 268, 10149, 10063, 7),
(5, 0, 268, 10146, 10064, 7),
(6, 0, 268, 10149, 10064, 7),
(7, 0, 269, 10153, 10059, 7),
(8, 0, 269, 10154, 10059, 7),
(9, 0, 269, 10152, 10064, 7),
(10, 0, 269, 10152, 10065, 7),
(11, 0, 269, 10154, 10064, 7),
(12, 0, 269, 10154, 10065, 7),
(13, 0, 270, 10157, 10059, 7),
(14, 0, 270, 10158, 10059, 7),
(15, 0, 270, 10159, 10059, 7),
(16, 0, 270, 10164, 10062, 7),
(17, 0, 270, 10157, 10064, 7),
(18, 0, 270, 10157, 10065, 7),
(19, 0, 270, 10159, 10064, 7),
(20, 0, 270, 10159, 10065, 7),
(21, 0, 273, 10173, 10053, 7),
(22, 0, 273, 10175, 10052, 7),
(23, 0, 273, 10175, 10053, 7),
(24, 0, 273, 10173, 10056, 7),
(25, 0, 273, 10176, 10051, 7),
(26, 0, 273, 10178, 10051, 7),
(27, 0, 273, 10178, 10052, 7),
(28, 0, 273, 10178, 10053, 7),
(29, 0, 273, 10176, 10056, 7),
(30, 0, 273, 10178, 10056, 7),
(31, 0, 274, 10137, 10031, 7),
(32, 0, 274, 10139, 10035, 7),
(33, 0, 274, 10141, 10035, 7),
(34, 0, 274, 10143, 10032, 7),
(35, 0, 275, 10137, 10026, 7),
(36, 0, 275, 10143, 10027, 7),
(37, 0, 275, 10143, 10028, 7),
(38, 0, 276, 10151, 10026, 7),
(39, 0, 276, 10148, 10028, 7),
(40, 0, 276, 10148, 10029, 7),
(41, 0, 277, 10148, 10032, 7),
(42, 0, 277, 10151, 10035, 7),
(43, 0, 278, 10159, 10029, 7),
(44, 0, 278, 10160, 10031, 7),
(45, 0, 278, 10157, 10033, 7),
(46, 0, 279, 10169, 10034, 7),
(47, 0, 279, 10164, 10037, 7),
(48, 0, 279, 10169, 10039, 7),
(49, 0, 279, 10170, 10037, 7),
(50, 0, 280, 10180, 10027, 7),
(51, 0, 280, 10180, 10031, 7),
(52, 0, 281, 10184, 10029, 7),
(53, 0, 281, 10182, 10032, 7),
(54, 0, 282, 10182, 10038, 7),
(55, 0, 282, 10184, 10036, 7),
(56, 0, 283, 10182, 10042, 7),
(57, 0, 283, 10185, 10041, 7),
(58, 0, 284, 10127, 10062, 7),
(59, 0, 284, 10129, 10062, 7),
(60, 0, 284, 10131, 10062, 7),
(61, 0, 284, 10133, 10062, 7),
(62, 0, 284, 10126, 10064, 7),
(63, 0, 284, 10127, 10064, 7),
(64, 0, 284, 10127, 10065, 7),
(65, 0, 284, 10133, 10064, 7),
(66, 0, 284, 10133, 10065, 7),
(67, 0, 285, 10119, 10063, 7),
(68, 0, 285, 10122, 10066, 7),
(69, 0, 286, 10119, 10070, 7),
(70, 0, 286, 10121, 10070, 7),
(71, 0, 286, 10122, 10073, 7),
(72, 0, 287, 10129, 10070, 7),
(73, 0, 287, 10129, 10071, 7),
(74, 0, 287, 10134, 10071, 7),
(75, 0, 288, 10099, 10074, 7),
(76, 0, 288, 10102, 10072, 7),
(77, 0, 288, 10102, 10073, 7),
(78, 0, 288, 10107, 10075, 7),
(79, 0, 288, 10104, 10077, 7),
(80, 0, 289, 10110, 10069, 7),
(81, 0, 290, 10111, 10066, 7),
(82, 0, 291, 10099, 10065, 7),
(83, 0, 291, 10100, 10067, 7),
(84, 0, 291, 10104, 10065, 7),
(85, 0, 291, 10099, 10069, 7),
(86, 0, 291, 10104, 10069, 7),
(87, 0, 292, 10103, 10059, 7),
(88, 0, 292, 10099, 10061, 7),
(89, 0, 292, 10103, 10061, 7),
(90, 0, 293, 10113, 10055, 7),
(91, 0, 293, 10113, 10056, 7),
(92, 0, 293, 10116, 10056, 7),
(93, 0, 294, 10113, 10052, 7),
(94, 0, 294, 10113, 10053, 7),
(95, 0, 294, 10116, 10053, 7),
(96, 0, 295, 10113, 10049, 7),
(97, 0, 295, 10113, 10050, 7),
(98, 0, 295, 10116, 10050, 7),
(99, 0, 296, 10119, 10049, 7),
(100, 0, 296, 10119, 10050, 7),
(101, 0, 296, 10122, 10049, 7),
(102, 0, 296, 10122, 10050, 7),
(103, 0, 297, 10119, 10052, 7),
(104, 0, 297, 10119, 10053, 7),
(105, 0, 297, 10122, 10052, 7),
(106, 0, 297, 10122, 10053, 7),
(107, 0, 298, 10122, 10055, 7),
(108, 0, 298, 10119, 10056, 7),
(109, 0, 298, 10119, 10057, 7),
(110, 0, 298, 10122, 10056, 7),
(111, 0, 299, 10077, 10030, 7),
(112, 0, 300, 10082, 10028, 7),
(113, 0, 301, 10087, 10027, 7),
(114, 0, 302, 10087, 10034, 7),
(115, 0, 303, 10095, 10030, 6),
(116, 0, 303, 10099, 10026, 6),
(117, 0, 303, 10107, 10026, 6),
(118, 0, 303, 10111, 10030, 6),
(119, 0, 303, 10097, 10034, 6),
(120, 0, 303, 10110, 10034, 6),
(121, 0, 303, 10103, 10039, 7),
(122, 0, 304, 10205, 10023, 7),
(123, 0, 304, 10203, 10027, 7),
(124, 0, 304, 10205, 10024, 7),
(125, 0, 304, 10205, 10027, 7),
(126, 0, 305, 10209, 10022, 7),
(127, 0, 305, 10210, 10023, 7),
(128, 0, 305, 10209, 10027, 7),
(129, 0, 305, 10210, 10024, 7),
(130, 0, 305, 10210, 10027, 7),
(131, 0, 306, 10215, 10023, 7),
(132, 0, 306, 10213, 10027, 7),
(133, 0, 306, 10214, 10027, 7),
(134, 0, 306, 10215, 10024, 7),
(135, 0, 307, 10218, 10022, 7),
(136, 0, 307, 10220, 10023, 7),
(137, 0, 307, 10219, 10027, 7),
(138, 0, 307, 10220, 10024, 7),
(139, 0, 307, 10220, 10027, 7),
(140, 0, 308, 10225, 10022, 7),
(141, 0, 308, 10227, 10023, 7),
(142, 0, 308, 10224, 10027, 7),
(143, 0, 308, 10226, 10027, 7),
(144, 0, 308, 10227, 10024, 7),
(145, 0, 309, 10232, 10023, 7),
(146, 0, 309, 10230, 10027, 7),
(147, 0, 309, 10231, 10027, 7),
(148, 0, 309, 10232, 10024, 7),
(149, 0, 310, 10236, 10022, 7),
(150, 0, 310, 10234, 10027, 7),
(151, 0, 310, 10236, 10027, 7),
(152, 0, 310, 10238, 10027, 7),
(153, 0, 310, 10241, 10022, 7),
(154, 0, 310, 10242, 10023, 7),
(155, 0, 310, 10241, 10025, 7),
(156, 0, 310, 10242, 10024, 7),
(157, 0, 310, 10243, 10024, 7),
(158, 0, 311, 10236, 10033, 7),
(159, 0, 311, 10238, 10033, 7),
(160, 0, 311, 10238, 10034, 7),
(161, 0, 311, 10238, 10035, 7),
(162, 0, 311, 10238, 10039, 7),
(163, 0, 311, 10236, 10041, 7),
(164, 0, 312, 10230, 10033, 7),
(165, 0, 312, 10232, 10034, 7),
(166, 0, 312, 10232, 10035, 7),
(167, 0, 312, 10231, 10039, 7),
(168, 0, 313, 10225, 10033, 7),
(169, 0, 313, 10226, 10039, 7),
(170, 0, 313, 10227, 10037, 7),
(171, 0, 313, 10227, 10038, 7),
(172, 0, 314, 10220, 10033, 7),
(173, 0, 314, 10220, 10039, 7),
(174, 0, 314, 10222, 10037, 7),
(175, 0, 314, 10222, 10038, 7),
(176, 0, 315, 10214, 10033, 7),
(177, 0, 315, 10216, 10034, 7),
(178, 0, 315, 10216, 10035, 7),
(179, 0, 315, 10214, 10039, 7),
(180, 0, 316, 10148, 10060, 6),
(181, 0, 316, 10147, 10064, 6),
(182, 0, 316, 10147, 10065, 6),
(183, 0, 316, 10148, 10066, 6),
(184, 0, 317, 10152, 10060, 6),
(185, 0, 317, 10151, 10064, 6),
(186, 0, 317, 10151, 10065, 6),
(187, 0, 317, 10152, 10066, 6),
(188, 0, 317, 10153, 10066, 6),
(189, 0, 318, 10157, 10060, 6),
(190, 0, 318, 10156, 10064, 6),
(191, 0, 318, 10156, 10065, 6),
(192, 0, 318, 10157, 10066, 6),
(193, 0, 318, 10158, 10066, 6),
(194, 0, 319, 10162, 10061, 6),
(195, 0, 319, 10161, 10065, 6),
(196, 0, 319, 10161, 10066, 6),
(197, 0, 319, 10162, 10067, 6),
(198, 0, 319, 10163, 10067, 6),
(199, 0, 320, 10167, 10061, 6),
(200, 0, 320, 10166, 10067, 6),
(201, 0, 320, 10167, 10067, 6),
(202, 0, 320, 10168, 10065, 6),
(203, 0, 320, 10168, 10066, 6),
(204, 0, 321, 10132, 10062, 6),
(205, 0, 322, 10143, 10055, 6),
(206, 0, 322, 10145, 10049, 6),
(207, 0, 322, 10147, 10053, 6),
(208, 0, 323, 10144, 10042, 6),
(209, 0, 324, 10176, 10032, 6),
(210, 0, 325, 10166, 10032, 6),
(211, 0, 325, 10166, 10033, 6),
(212, 0, 325, 10166, 10035, 6),
(213, 0, 325, 10170, 10034, 6),
(214, 0, 326, 10162, 10028, 6),
(215, 0, 326, 10164, 10031, 6),
(216, 0, 326, 10162, 10033, 6),
(217, 0, 326, 10164, 10032, 6),
(218, 0, 327, 10164, 10039, 6),
(219, 0, 327, 10165, 10036, 6),
(220, 0, 327, 10170, 10038, 6),
(221, 0, 327, 10167, 10040, 6),
(222, 0, 328, 10164, 10031, 5),
(223, 0, 328, 10167, 10031, 5),
(224, 0, 329, 10168, 10034, 5),
(225, 0, 330, 10143, 10049, 5),
(226, 0, 330, 10145, 10051, 5),
(227, 0, 331, 10146, 10053, 5),
(228, 0, 332, 10144, 10046, 5),
(229, 0, 332, 10145, 10046, 5),
(230, 0, 333, 10145, 10044, 4),
(231, 0, 333, 10145, 10045, 4),
(232, 0, 334, 10145, 10047, 4),
(233, 0, 334, 10145, 10048, 4),
(234, 0, 335, 10145, 10051, 4),
(235, 0, 336, 10147, 10052, 4),
(236, 0, 337, 10155, 10052, 4),
(237, 0, 338, 10160, 10052, 4),
(238, 0, 339, 10164, 10052, 4),
(239, 0, 340, 10168, 10052, 4),
(240, 0, 340, 10169, 10052, 4),
(241, 0, 341, 10167, 10047, 4),
(242, 0, 341, 10168, 10047, 4),
(243, 0, 341, 10169, 10047, 4),
(244, 0, 342, 10163, 10047, 4),
(245, 0, 342, 10164, 10047, 4),
(246, 0, 342, 10165, 10047, 4),
(247, 0, 343, 10159, 10046, 4),
(248, 0, 343, 10160, 10046, 4),
(249, 0, 344, 10155, 10046, 4),
(250, 0, 344, 10156, 10046, 4),
(251, 0, 345, 10176, 10096, 7),
(252, 0, 346, 10171, 10101, 7),
(253, 0, 347, 10181, 10104, 7),
(254, 0, 348, 10185, 10096, 7),
(255, 0, 349, 10186, 10101, 7),
(256, 0, 350, 10185, 10106, 7),
(257, 0, 351, 10155, 10106, 7),
(258, 0, 352, 10121, 10128, 7),
(259, 0, 353, 10130, 10003, 7),
(260, 0, 353, 10135, 10002, 7),
(261, 0, 353, 10135, 10003, 7),
(262, 0, 354, 10130, 9995, 7),
(263, 0, 354, 10135, 9994, 7),
(264, 0, 354, 10135, 9995, 7),
(265, 0, 355, 10130, 9987, 7),
(266, 0, 355, 10135, 9985, 7),
(267, 0, 355, 10135, 9986, 7),
(268, 0, 356, 10156, 9983, 7),
(269, 0, 356, 10154, 9988, 7),
(270, 0, 356, 10155, 9988, 7),
(271, 0, 357, 10163, 9988, 7),
(272, 0, 357, 10164, 9988, 7),
(273, 0, 358, 10155, 10002, 7),
(274, 0, 358, 10155, 10003, 7),
(275, 0, 358, 10161, 10002, 7),
(276, 0, 359, 10155, 9995, 7),
(277, 0, 359, 10155, 9996, 7),
(278, 0, 359, 10161, 9995, 7),
(279, 0, 360, 10113, 10202, 7),
(280, 0, 361, 10121, 10202, 7),
(281, 0, 362, 10126, 10190, 7),
(282, 0, 363, 10136, 10187, 7),
(283, 0, 364, 10141, 10187, 7),
(284, 0, 365, 10152, 10186, 7),
(285, 0, 365, 10156, 10186, 7),
(286, 0, 366, 10140, 10177, 7),
(287, 0, 366, 10141, 10177, 7),
(288, 0, 366, 10140, 10181, 7),
(289, 0, 367, 10143, 10177, 7),
(290, 0, 367, 10143, 10181, 7),
(291, 0, 367, 10144, 10177, 7),
(292, 0, 368, 10146, 10177, 7),
(293, 0, 368, 10147, 10177, 7),
(294, 0, 368, 10146, 10181, 7),
(295, 0, 369, 10149, 10177, 7),
(296, 0, 369, 10150, 10177, 7),
(297, 0, 369, 10149, 10181, 7),
(298, 0, 370, 10114, 10185, 7),
(299, 0, 371, 10114, 10179, 7),
(300, 0, 372, 10202, 10055, 6),
(301, 0, 372, 10202, 10056, 6),
(302, 0, 372, 10204, 10058, 6),
(303, 0, 372, 10202, 10062, 6),
(304, 0, 372, 10202, 10063, 6),
(305, 0, 373, 10206, 10056, 6),
(306, 0, 373, 10206, 10062, 6),
(307, 0, 373, 10206, 10063, 6),
(308, 0, 373, 10208, 10055, 6),
(309, 0, 373, 10208, 10056, 6),
(310, 0, 374, 10201, 10043, 7),
(311, 0, 374, 10201, 10044, 7),
(312, 0, 374, 10204, 10044, 7),
(313, 0, 375, 10201, 10047, 7),
(314, 0, 375, 10201, 10048, 7),
(315, 0, 375, 10204, 10049, 7),
(316, 0, 376, 10201, 10052, 7),
(317, 0, 376, 10201, 10053, 7),
(318, 0, 376, 10204, 10054, 7),
(319, 0, 377, 10201, 10057, 7),
(320, 0, 377, 10201, 10058, 7),
(321, 0, 377, 10204, 10058, 7),
(322, 0, 378, 10202, 10062, 7),
(323, 0, 378, 10202, 10063, 7),
(324, 0, 378, 10203, 10062, 7),
(325, 0, 378, 10203, 10063, 7),
(326, 0, 378, 10205, 10061, 7),
(327, 0, 378, 10206, 10062, 7),
(328, 0, 378, 10206, 10063, 7),
(329, 0, 378, 10207, 10062, 7),
(330, 0, 378, 10207, 10063, 7),
(331, 0, 379, 10206, 10058, 7),
(332, 0, 379, 10208, 10057, 7),
(333, 0, 379, 10208, 10058, 7),
(334, 0, 380, 10206, 10054, 7),
(335, 0, 380, 10207, 10052, 7),
(336, 0, 380, 10207, 10053, 7),
(337, 0, 381, 10208, 10047, 7),
(338, 0, 381, 10206, 10049, 7),
(339, 0, 381, 10208, 10048, 7),
(340, 0, 382, 10206, 10044, 7),
(341, 0, 382, 10208, 10043, 7),
(342, 0, 382, 10208, 10044, 7),
(343, 0, 384, 10205, 10059, 5);

-- --------------------------------------------------------

--
-- Estrutura da tabela `tile_items`
--

CREATE TABLE IF NOT EXISTS `tile_items` (
  `tile_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL,
  `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 `tile_id` (`tile_id`,`world_id`,`sid`),
  KEY `sid` (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `tile_items`
--

INSERT INTO `tile_items` (`tile_id`, `world_id`, `sid`, `pid`, `itemtype`, `count`, `attributes`) VALUES
(0, 0, 1, 0, 6436, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202330272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640202000000),
(1, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202330272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640201000000),
(2, 0, 1, 0, 6436, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202330272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640201000000),
(3, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(4, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(5, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(6, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(7, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202331272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(8, 0, 1, 0, 6436, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202331272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(9, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(10, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(11, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(12, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(13, 0, 1, 0, 6436, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202332272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(14, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202332272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(15, 0, 1, 0, 6436, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202332272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(16, 0, 1, 0, 10267, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202332272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640204000000),
(17, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(18, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(19, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(20, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(21, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320393630303020676f6c6420636f696e732e0600646f6f7269640204000000),
(22, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(23, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(24, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320393630303020676f6c6420636f696e732e0600646f6f7269640205000000),
(25, 0, 1, 0, 1878, 1, ''),
(26, 0, 1, 0, 1878, 1, ''),
(27, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(28, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(29, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320393630303020676f6c6420636f696e732e0600646f6f7269640201000000),
(30, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320393630303020676f6c6420636f696e732e0600646f6f7269640203000000),
(31, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(32, 0, 1, 0, 6438, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202334272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(33, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202334272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353030303020676f6c6420636f696e732e0600646f6f7269640203000000),
(34, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202334272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(35, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(36, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202335272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(37, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202335272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(38, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(39, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202336272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(40, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202336272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(41, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202337272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333730303020676f6c6420636f696e732e0600646f6f7269640202000000),
(42, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(43, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(44, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202338272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640202000000),
(45, 0, 1, 0, 1637, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202338272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640201000000),
(46, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(47, 0, 1, 0, 1635, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202339272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353630303020676f6c6420636f696e732e0600646f6f7269640201000000),
(48, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(49, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015200000049742062656c6f6e677320746f20686f7573652027486f757365202339272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353630303020676f6c6420636f696e732e0600646f6f7269640202000000),
(50, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(51, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233130272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640202000000),
(52, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(53, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233131272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(54, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233132272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(55, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(56, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233133272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640201000000),
(57, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(58, 0, 1, 0, 1867, 1, ''),
(59, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233134272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(60, 0, 1, 0, 1867, 1, ''),
(61, 0, 1, 0, 1867, 1, ''),
(62, 0, 1, 0, 1868, 1, ''),
(63, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(64, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(65, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(66, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(67, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(68, 0, 1, 0, 1214, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233135272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343130303020676f6c6420636f696e732e0600646f6f7269640202000000),
(69, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233136272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(70, 0, 1, 0, 6438, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233136272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640203000000),
(71, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(72, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233137272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(73, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233137272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(74, 0, 1, 0, 7814, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(75, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233138272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353130303020676f6c6420636f696e732e0600646f6f7269640203000000),
(76, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233138272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353130303020676f6c6420636f696e732e0600646f6f7269640202000000),
(77, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233138272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353130303020676f6c6420636f696e732e0600646f6f7269640201000000),
(78, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233138272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353130303020676f6c6420636f696e732e0600646f6f7269640205000000),
(79, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233138272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353130303020676f6c6420636f696e732e0600646f6f7269640204000000),
(80, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233139272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(81, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233230272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(82, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233231272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640202000000),
(83, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233231272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640203000000),
(84, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233231272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640205000000),
(85, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233231272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640204000000),
(86, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233231272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640206000000),
(87, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233232272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640203000000),
(88, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233232272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(89, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233232272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640204000000),
(90, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(91, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(92, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233233272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(93, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(94, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(95, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233234272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(96, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(97, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(98, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233235272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(99, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233236272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(100, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233236272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(101, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(102, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(103, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233237272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(104, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233237272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(105, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(106, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(107, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(108, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233238272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(109, 0, 1, 0, 6439, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233238272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(110, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(111, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233239272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333930303020676f6c6420636f696e732e0600646f6f7269640202000000),
(112, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233330272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640202000000),
(113, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233331272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640201000000),
(114, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233332272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640202000000),
(115, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732036353230303020676f6c6420636f696e732e0600646f6f7269640201000000),
(116, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732036353230303020676f6c6420636f696e732e0600646f6f7269640203000000),
(117, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732036353230303020676f6c6420636f696e732e0600646f6f7269640206000000),
(118, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732036353230303020676f6c6420636f696e732e0600646f6f7269640207000000),
(119, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732036353230303020676f6c6420636f696e732e0600646f6f7269640204000000),
(120, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732036353230303020676f6c6420636f696e732e0600646f6f7269640208000000),
(121, 0, 1, 0, 1542, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233333272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732036353230303020676f6c6420636f696e732e0600646f6f7269640202000000),
(122, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(123, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233334272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640203000000),
(124, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(125, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233334272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(126, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233335272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(127, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(128, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233335272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640203000000),
(129, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(130, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233335272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(131, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(132, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233336272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(133, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233336272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(134, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(135, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233337272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(136, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(137, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233337272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640203000000),
(138, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(139, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233337272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(140, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233338272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640201000000),
(141, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(142, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233338272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640204000000),
(143, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233338272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640203000000),
(144, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(145, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(146, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233339272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(147, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233339272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(148, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(149, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233430272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640201000000),
(150, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233430272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640205000000),
(151, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233430272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640207000000),
(152, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233430272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640208000000),
(153, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233430272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640202000000),
(154, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(155, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233430272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640204000000),
(156, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(157, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233430272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640203000000),
(158, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233431272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(159, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233431272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(160, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(161, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(162, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233431272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640204000000),
(163, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233431272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640203000000),
(164, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233432272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(165, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(166, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(167, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233432272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(168, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233433272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(169, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233433272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(170, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(171, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(172, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233434272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640202000000),
(173, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233434272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343230303020676f6c6420636f696e732e0600646f6f7269640201000000),
(174, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(175, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(176, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233435272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640203000000),
(177, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(178, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(179, 0, 1, 0, 10266, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233435272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(180, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233436272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333630303020676f6c6420636f696e732e0600646f6f7269640202000000),
(181, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(182, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(183, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233436272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333630303020676f6c6420636f696e732e0600646f6f7269640201000000),
(184, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233437272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343430303020676f6c6420636f696e732e0600646f6f7269640203000000),
(185, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(186, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(187, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233437272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343430303020676f6c6420636f696e732e0600646f6f7269640201000000),
(188, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233437272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343430303020676f6c6420636f696e732e0600646f6f7269640201000000),
(189, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233438272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(190, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(191, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(192, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233438272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640203000000),
(193, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233438272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(194, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233439272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(195, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(196, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(197, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233439272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(198, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233439272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640203000000),
(199, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233530272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640204000000),
(200, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233530272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640203000000),
(201, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233530272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(202, 0, 1, 0, 7815, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(203, 0, 1, 0, 7816, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(204, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233531272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320383430303020676f6c6420636f696e732e0600646f6f7269640201000000),
(205, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233532272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353030303020676f6c6420636f696e732e0600646f6f7269640204000000),
(206, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233532272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(207, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233532272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(208, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233533272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(209, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233534272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(210, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233535272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(211, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233535272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(212, 0, 1, 0, 10267, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233535272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(213, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233535272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640203000000),
(214, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233536272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640204000000),
(215, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233536272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640205000000),
(216, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233536272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640205000000),
(217, 0, 1, 0, 10267, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233536272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640205000000),
(218, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233537272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(219, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233537272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640204000000),
(220, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233537272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640203000000),
(221, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233537272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(222, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233538272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343830303020676f6c6420636f696e732e0600646f6f7269640202000000),
(223, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233538272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343830303020676f6c6420636f696e732e0600646f6f7269640201000000),
(224, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233539272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343930303020676f6c6420636f696e732e0600646f6f7269640201000000),
(225, 0, 1, 0, 6436, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233630272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(226, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233630272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(227, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233631272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323830303020676f6c6420636f696e732e0600646f6f7269640201000000),
(228, 0, 1, 0, 6436, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233632272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(229, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233632272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(230, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233633272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(231, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233633272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(232, 0, 1, 0, 10265, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233634272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(233, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233634272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(234, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233635272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313930303020676f6c6420636f696e732e0600646f6f7269640201000000),
(235, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233636272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333330303020676f6c6420636f696e732e0600646f6f7269640201000000),
(236, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233637272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(237, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233638272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(238, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233639272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(239, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233730272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640201000000);
INSERT INTO `tile_items` (`tile_id`, `world_id`, `sid`, `pid`, `itemtype`, `count`, `attributes`) VALUES
(240, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233730272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(241, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233731272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640202000000),
(242, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233731272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640203000000),
(243, 0, 1, 0, 6438, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233731272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640203000000),
(244, 0, 1, 0, 10264, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233732272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323130303020676f6c6420636f696e732e0600646f6f7269640203000000),
(245, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233732272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323130303020676f6c6420636f696e732e0600646f6f7269640203000000),
(246, 0, 1, 0, 6438, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233732272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323130303020676f6c6420636f696e732e0600646f6f7269640203000000),
(247, 0, 1, 0, 6438, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233733272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(248, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233733272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(249, 0, 1, 0, 1213, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233734272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(250, 0, 1, 0, 6438, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233734272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(251, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233735272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(252, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233736272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(253, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233737272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353630303020676f6c6420636f696e732e0600646f6f7269640202000000),
(254, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233738272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(255, 0, 1, 0, 1209, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233739272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(256, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233830272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(257, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233831272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732031393330303020676f6c6420636f696e732e0600646f6f7269640202000000),
(258, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f75736520233832272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f7374732031303030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(259, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233833272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363330303020676f6c6420636f696e732e0600646f6f7269640202000000),
(260, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233833272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363330303020676f6c6420636f696e732e0600646f6f7269640203000000),
(261, 0, 1, 0, 6443, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233833272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363330303020676f6c6420636f696e732e0600646f6f7269640201000000),
(262, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233834272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373430303020676f6c6420636f696e732e0600646f6f7269640203000000),
(263, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233834272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373430303020676f6c6420636f696e732e0600646f6f7269640201000000),
(264, 0, 1, 0, 6443, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233834272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373430303020676f6c6420636f696e732e0600646f6f7269640202000000),
(265, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233835272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373230303020676f6c6420636f696e732e0600646f6f7269640204000000),
(266, 0, 1, 0, 6443, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233835272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373230303020676f6c6420636f696e732e0600646f6f7269640203000000),
(267, 0, 1, 0, 1210, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233835272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373230303020676f6c6420636f696e732e0600646f6f7269640201000000),
(268, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233836272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(269, 0, 1, 0, 6442, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233836272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373030303020676f6c6420636f696e732e0600646f6f7269640203000000),
(270, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233836272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373030303020676f6c6420636f696e732e0600646f6f7269640203000000),
(271, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233837272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343830303020676f6c6420636f696e732e0600646f6f7269640201000000),
(272, 0, 1, 0, 6442, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233837272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343830303020676f6c6420636f696e732e0600646f6f7269640202000000),
(273, 0, 1, 0, 6443, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233838272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640202000000),
(274, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233838272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640202000000),
(275, 0, 1, 0, 1209, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233838272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640203000000),
(276, 0, 1, 0, 6443, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233839272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640202000000),
(277, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233839272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640203000000),
(278, 0, 1, 0, 1209, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233839272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363630303020676f6c6420636f696e732e0600646f6f7269640204000000),
(279, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233930272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363430303020676f6c6420636f696e732e0600646f6f7269640201000000),
(280, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233931272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320373230303020676f6c6420636f696e732e0600646f6f7269640201000000),
(281, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233932272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353630303020676f6c6420636f696e732e0600646f6f7269640201000000),
(282, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233933272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(283, 0, 1, 0, 1221, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233934272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320333530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(284, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233935272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640201000000),
(285, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233935272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363130303020676f6c6420636f696e732e0600646f6f7269640202000000),
(286, 0, 1, 0, 1756, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(287, 0, 1, 0, 1757, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(288, 0, 1, 0, 3537, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233936272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313830303020676f6c6420636f696e732e0600646f6f7269640202000000),
(289, 0, 1, 0, 1756, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(290, 0, 1, 0, 3537, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233937272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313830303020676f6c6420636f696e732e0600646f6f7269640201000000),
(291, 0, 1, 0, 1757, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(292, 0, 1, 0, 1756, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(293, 0, 1, 0, 1757, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(294, 0, 1, 0, 3537, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233938272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320313830303020676f6c6420636f696e732e0600646f6f7269640201000000),
(295, 0, 1, 0, 1756, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(296, 0, 1, 0, 1757, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(297, 0, 1, 0, 3537, 1, 0x8002000b006465736372697074696f6e015300000049742062656c6f6e677320746f20686f7573652027486f75736520233939272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323430303020676f6c6420636f696e732e0600646f6f7269640202000000),
(298, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313030272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343830303020676f6c6420636f696e732e0600646f6f7269640201000000),
(299, 0, 1, 0, 1219, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313031272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353630303020676f6c6420636f696e732e0600646f6f7269640201000000),
(300, 0, 1, 0, 3836, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(301, 0, 1, 0, 3837, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(302, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313032272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320343430303020676f6c6420636f696e732e0600646f6f7269640202000000),
(303, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(304, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(305, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313033272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(306, 0, 1, 0, 7819, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(307, 0, 1, 0, 7820, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(308, 0, 1, 0, 3836, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(309, 0, 1, 0, 3837, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(310, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(311, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(312, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313034272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(313, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(314, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(315, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313035272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323830303020676f6c6420636f696e732e0600646f6f7269640202000000),
(316, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(317, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(318, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313036272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(319, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(320, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(321, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313037272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640201000000),
(322, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(323, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(324, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(325, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(326, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313038272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320363030303020676f6c6420636f696e732e0600646f6f7269640202000000),
(327, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(328, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(329, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(330, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(331, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313039272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(332, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(333, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(334, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313030272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323830303020676f6c6420636f696e732e0600646f6f7269640202000000),
(335, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(336, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(337, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(338, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313131272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323530303020676f6c6420636f696e732e0600646f6f7269640202000000),
(339, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(340, 0, 1, 0, 5082, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313132272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320323030303020676f6c6420636f696e732e0600646f6f7269640201000000),
(341, 0, 1, 0, 5496, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(342, 0, 1, 0, 5497, 1, 0x8001000b006465736372697074696f6e01190000004e6f626f647920697320736c656570696e672074686572652e),
(343, 0, 1, 0, 1212, 1, 0x8002000b006465736372697074696f6e015400000049742062656c6f6e677320746f20686f7573652027486f7573652023313134272e204e6f626f6479206f776e73207468697320686f7573652e20497420636f73747320353430303020676f6c6420636f696e732e0600646f6f7269640201000000);

-- --------------------------------------------------------

--
-- Estrutura da tabela `z_ots_comunication`
--

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Extraindo dados da tabela `z_ots_comunication`
--


--
-- Restrições para as tabelas dumpadas
--

--
-- Restrições para a tabela `account_viplist`
--
ALTER TABLE `account_viplist`
  ADD CONSTRAINT `account_viplist_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_viplist_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `environment_killers`
--
ALTER TABLE `environment_killers`
  ADD CONSTRAINT `environment_killers_ibfk_1` FOREIGN KEY (`kill_id`) REFERENCES `killers` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `guild_invites`
--
ALTER TABLE `guild_invites`
  ADD CONSTRAINT `guild_invites_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `guild_kills`
--
ALTER TABLE `guild_kills`
  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `guild_ranks`
--
ALTER TABLE `guild_ranks`
  ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `guild_wars`
--
ALTER TABLE `guild_wars`
  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `house_auctions`
--
ALTER TABLE `house_auctions`
  ADD CONSTRAINT `house_auctions_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `house_auctions_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `house_data`
--
ALTER TABLE `house_data`
  ADD CONSTRAINT `house_data_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `house_lists`
--
ALTER TABLE `house_lists`
  ADD CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `killers`
--
ALTER TABLE `killers`
  ADD CONSTRAINT `killers_ibfk_1` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `players`
--
ALTER TABLE `players`
  ADD CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_deaths`
--
ALTER TABLE `player_deaths`
  ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_depotitems`
--
ALTER TABLE `player_depotitems`
  ADD CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_items`
--
ALTER TABLE `player_items`
  ADD CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_killers`
--
ALTER TABLE `player_killers`
  ADD CONSTRAINT `player_killers_ibfk_1` FOREIGN KEY (`kill_id`) REFERENCES `killers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `player_killers_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_namelocks`
--
ALTER TABLE `player_namelocks`
  ADD CONSTRAINT `player_namelocks_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_skills`
--
ALTER TABLE `player_skills`
  ADD CONSTRAINT `player_skills_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_spells`
--
ALTER TABLE `player_spells`
  ADD CONSTRAINT `player_spells_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_storage`
--
ALTER TABLE `player_storage`
  ADD CONSTRAINT `player_storage_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `player_viplist`
--
ALTER TABLE `player_viplist`
  ADD CONSTRAINT `player_viplist_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `player_viplist_ibfk_2` FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `server_reports`
--
ALTER TABLE `server_reports`
  ADD CONSTRAINT `server_reports_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `tiles`
--
ALTER TABLE `tiles`
  ADD CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;

--
-- Restrições para a tabela `tile_items`
--
ALTER TABLE `tile_items`
  ADD CONSTRAINT `tile_items_ibfk_1` FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
