/*
Navicat MySQL Data Transfer

Source Server         : Death Dreams
Source Server Version : 50045
Source Host           : death-dreams.de:3306
Source Database       : realmd

Target Server Type    : MYSQL
Target Server Version : 50045
File Encoding         : 65001

Date: 2010-05-26 08:24:26
*/

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',
  `I` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';

-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES ('1', 'ADMINISTRATOR', 'a34b29541b87b7e4823683ce6c7bf6ae68beaaac', '3', 'C155C118AA5602FA7D3FB4656425D820E6A8BB400EBA414E2668C509F7551631D2348606611239DE', '1AC258351FBB1AD0E1CFA5C9C679E0BD2497F718171298A880D1C9B9E60C285A', 'F79A6CB489F6DC97269799834FE7BCE3D3B931E844ED78307E4F507137042C95', '', '2006-04-25 12:18:56', '127.0.0.1', '0', '0', '2010-04-08 15:54:51', '0', '2', '0', '0', null);
INSERT INTO `account` VALUES ('2', 'GAMEMASTER', '7841e21831d7c6bc0b57fbe7151eb82bd65ea1f9', '2', '', '0', '0', '', '2006-04-25 12:18:56', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0', '2', '0', '0', null);
INSERT INTO `account` VALUES ('3', 'MODERATOR', 'a7f5fbff0b4eec2d6b6e78e38e8312e64d700008', '1', '', '0', '0', '', '2006-04-25 12:19:35', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0', '2', '0', '0', null);
INSERT INTO `account` VALUES ('4', 'PLAYER', '3ce8a96d17c5ae88a30681024e86279f1a38c041', '0', '', '0', '0', '', '2006-04-25 12:19:35', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0', '2', '0', '0', null);
INSERT INTO `account` VALUES ('5', 'TESTI', '5c8ce74be7fe7ee9f15e95f1b63cc1156ff24074', '0', null, null, null, null, '2010-04-08 20:55:45', '0.0.0.0', '0', '0', '0000-00-00 00:00:00', '0', '2', '0', '0', null);
INSERT INTO `account` VALUES ('9', 'drugstar500', '308bed557b6130972a1bb6b18f2f23a433d3eeca', '3', '1D0CB7D80C5A1C9305F5DBABC0CD178F4AF6279763160F8DA8563A43D9DE1DF0A95922E6C2988ECE', '57571F27180F4A29C5A9615AE4BF326FAF76EF1AA5198AEE9D652CAEF3C934FE', 'D48C099DAA379064D46B5ED906775A598936745C8EA42E5291D85C535F3BB215', 'test@test.de', '2010-05-24 22:43:48', '########', '0', '0', '2010-05-26 08:13:01', '0', '2', '0', '3', null);
INSERT INTO `account` VALUES ('10', 'darkrider', '4ed5350e42c6d0e1b508a37739a7ff4f3ce61202', '3', 'DBE31C9E69A5B146B0810D6EE79DB87E86D0F0968F19E931EAD85208023CCC43152E6B909DFB07B3', '610A645A9216A1778EFBD5C28E2C9AB45192337C7BB831EF2E587C8A43F51366', 'EC479007970AF8B00A9FA81F607E73C9B8DE5898A5BAA4AB0BCD225F5B6FE911', 'test@test.de', '2010-05-25 13:04:12', '############', '0', '0', '2010-05-25 13:20:04', '0', '2', '0', '3', null);

-- ----------------------------
-- 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 `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
-- ----------------------------
INSERT INTO `realmcharacters` VALUES ('1', '1', '1');

-- ----------------------------
-- Table structure for `realmd_db_version`
-- ----------------------------
DROP TABLE IF EXISTS `realmd_db_version`;
CREATE TABLE `realmd_db_version` (
  `required_9010_01_realmd_realmlist` bit(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';

-- ----------------------------
-- Records of realmd_db_version
-- ----------------------------
INSERT INTO `realmd_db_version` VALUES (null);

-- ----------------------------
-- 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',
  `color` tinyint(3) unsigned NOT NULL default '2',
  `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', 'Revolution of Darkness All-GM', '127.0.0.1', '8085', '1', '0', '2', '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
-- ----------------------------
INSERT INTO `uptime` VALUES ('1', '1270715013', '2010-04-08 03:23:33', '1200', '1');
INSERT INTO `uptime` VALUES ('1', '1270725158', '2010-04-08 06:12:38', '31201', '1');
INSERT INTO `uptime` VALUES ('1', '1274730981', '2010-05-24 21:56:21', '4201', '0');
INSERT INTO `uptime` VALUES ('1', '1274736296', '2010-05-24 23:24:56', '49798', '0');
INSERT INTO `uptime` VALUES ('1', '1274786364', '2010-05-25 13:19:24', '0', '0');
INSERT INTO `uptime` VALUES ('1', '1274787109', '2010-05-25 13:31:49', '2401', '0');
INSERT INTO `uptime` VALUES ('1', '1274789999', '2010-05-25 14:19:59', '61797', '0');
INSERT INTO `uptime` VALUES ('1', '1274853128', '2010-05-26 07:52:08', '1800', '0');