--
-- Database: `test`
--

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

--
-- Table structure for table `block_logs`
--

CREATE TABLE IF NOT EXISTS `block_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` int(10) unsigned DEFAULT NULL,
  `world_id` int(10) unsigned DEFAULT NULL,
  `player_id` int(10) unsigned DEFAULT NULL,
  `type` tinyint(3) unsigned DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `y` smallint(6) DEFAULT NULL,
  `z` int(11) DEFAULT NULL,
  `block_id` smallint(6) DEFAULT NULL,
  `block_data` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `xyz` (`world_id`,`x`,`y`,`z`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

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

--
-- Table structure for table `chests`
--

CREATE TABLE IF NOT EXISTS `chests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` int(10) unsigned DEFAULT NULL,
  `world_id` int(10) unsigned NOT NULL DEFAULT '0',
  `player_id` int(10) unsigned DEFAULT NULL,
  `x` int(11) NOT NULL DEFAULT '0',
  `y` smallint(6) NOT NULL DEFAULT '0',
  `z` int(11) NOT NULL DEFAULT '0',
  `last_player_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`world_id`,`x`,`y`,`z`),
  KEY `player_id` (`player_id`),
  KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

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

--
-- Table structure for table `chest_access_logs`
--

CREATE TABLE IF NOT EXISTS `chest_access_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` int(10) unsigned DEFAULT NULL,
  `player_id` int(10) unsigned DEFAULT NULL,
  `chest_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chest_id` (`chest_id`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

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

--
-- Table structure for table `chest_contents`
--

CREATE TABLE IF NOT EXISTS `chest_contents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `chest_id` int(10) unsigned DEFAULT NULL,
  `slot_id` tinyint(3) unsigned DEFAULT NULL,
  `item_id` smallint(5) unsigned DEFAULT NULL,
  `item_durability` tinyint(3) unsigned DEFAULT NULL,
  `item_count` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chest_id` (`chest_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

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

--
-- Table structure for table `login_logs`
--

CREATE TABLE IF NOT EXISTS `login_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` int(10) unsigned DEFAULT NULL,
  `world_id` int(10) unsigned DEFAULT NULL,
  `player_id` int(10) unsigned DEFAULT NULL,
  `ip` int(10) unsigned DEFAULT NULL,
  `type` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

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

--
-- Table structure for table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` int(10) unsigned DEFAULT NULL,
  `name` varchar(32) NOT NULL DEFAULT '',
  `last_ip` int(10) unsigned DEFAULT NULL,
  `last_login` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

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

--
-- Table structure for table `worlds`
--

CREATE TABLE IF NOT EXISTS `worlds` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` int(10) unsigned DEFAULT NULL,
  `name` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;