text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : Local
  Source Server Version : 50141
  Source Host           : localhost:3306
  Source Database       : logon
  
  Target Server Type    : MYSQL
  Target Server Version : 50141
  File Encoding         : 65001
  
  Date: 2010-04-17 15:01:59
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  -- ----------------------------
  -- Table structure for `account`
  -- ----------------------------
  DROP TABLE IF EXISTS `account`;
  CREATE TABLE `account` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
    `username` varchar(32) NOT NULL DEFAULT '',
    `sha_pass_hash` varchar(40) NOT NULL DEFAULT '',
    `gmlevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `sessionkey` longtext,
    `v` longtext,
    `s` longtext,
    `email` text,
    `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_ip` varchar(30) NOT NULL DEFAULT '0.0.0.0',
    `failed_logins` int(11) unsigned NOT NULL DEFAULT '0',
    `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `active_realm_id` int(11) unsigned NOT NULL DEFAULT '0',
    `expansion` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `mutetime` bigint(40) unsigned NOT NULL DEFAULT '0',
    `locale` tinyint(3) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `idx_username` (`username`),
    KEY `idx_gmlevel` (`gmlevel`)
  ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';
  
  -- ----------------------------
  -- Records of account
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `account_banned`
  -- ----------------------------
  DROP TABLE IF EXISTS `account_banned`;
  CREATE TABLE `account_banned` (
    `id` int(11) NOT NULL DEFAULT '0' COMMENT 'Account id',
    `bandate` bigint(40) NOT NULL DEFAULT '0',
    `unbandate` bigint(40) NOT NULL DEFAULT '0',
    `bannedby` varchar(50) NOT NULL,
    `banreason` varchar(255) NOT NULL,
    `active` tinyint(4) NOT NULL DEFAULT '1',
    PRIMARY KEY (`id`,`bandate`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Ban List';
  
  -- ----------------------------
  -- Records of account_banned
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `autobroadcast`
  -- ----------------------------
  DROP TABLE IF EXISTS `autobroadcast`;
  CREATE TABLE `autobroadcast` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `text` longtext NOT NULL,
    `next` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of autobroadcast
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `ip_banned`
  -- ----------------------------
  DROP TABLE IF EXISTS `ip_banned`;
  CREATE TABLE `ip_banned` (
    `ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
    `bandate` bigint(40) NOT NULL,
    `unbandate` bigint(40) NOT NULL,
    `bannedby` varchar(50) NOT NULL DEFAULT '[Console]',
    `banreason` varchar(255) NOT NULL DEFAULT 'no reason',
    PRIMARY KEY (`ip`,`bandate`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Banned IPs';
  
  -- ----------------------------
  -- Records of ip_banned
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `realmcharacters`
  -- ----------------------------
  DROP TABLE IF EXISTS `realmcharacters`;
  CREATE TABLE `realmcharacters` (
    `realmid` int(11) unsigned NOT NULL DEFAULT '0',
    `acctid` bigint(20) unsigned NOT NULL,
    `numchars` tinyint(3) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`realmid`,`acctid`),
    KEY `acctid` (`acctid`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm Character Tracker';
  
  -- ----------------------------
  -- Records of realmcharacters
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `realmlist`
  -- ----------------------------
  DROP TABLE IF EXISTS `realmlist`;
  CREATE TABLE `realmlist` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(32) NOT NULL DEFAULT '',
    `address` varchar(32) NOT NULL DEFAULT '127.0.0.1',
    `port` int(11) NOT NULL DEFAULT '8085',
    `icon` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `realmflags` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT 'Supported masks: 0x1 (invalid, not show in realm list), 0x2 (offline, set by mangosd), 0x4 (show version and build), 0x20 (new players), 0x40 (recommended)',
    `timezone` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `population` float unsigned NOT NULL DEFAULT '0',
    `realmbuilds` varchar(64) NOT NULL DEFAULT '',
    PRIMARY KEY (`id`),
    UNIQUE KEY `idx_name` (`name`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System';
  
  -- ----------------------------
  -- Records of realmlist
  -- ----------------------------
  INSERT INTO `realmlist` VALUES ('1', 'DiamondCore', '127.0.0.1', '8085', '1', '2', '1', '0', '0', '11723 ');
  
  -- ----------------------------
  -- Table structure for `uptime`
  -- ----------------------------
  DROP TABLE IF EXISTS `uptime`;
  CREATE TABLE `uptime` (
    `realmid` int(11) unsigned NOT NULL,
    `starttime` bigint(20) unsigned NOT NULL DEFAULT '0',
    `startstring` varchar(64) NOT NULL DEFAULT '',
    `uptime` bigint(20) unsigned NOT NULL DEFAULT '0',
    `maxplayers` smallint(5) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`realmid`,`starttime`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';
  
  -- ----------------------------
  -- Records of uptime
  -- ----------------------------
  