DROP TABLE IF EXISTS `character_arena_stats`;
CREATE TABLE `character_arena_stats` (
   `guid` int(10) NOT NULL,
   `slot` tinyint(3) NOT NULL,
   `personalRating` smallint(5) NOT NULL,
   `matchMakerRating` smallint(5) NOT NULL,
   PRIMARY KEY (`guid`,`slot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `guild_member`;
CREATE TABLE `guild_member` (
   `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator',
   `guid` int(10) unsigned NOT NULL,
   `rank` tinyint(3) unsigned NOT NULL,
   `pnote` varchar(31) NOT NULL DEFAULT '',
   `offnote` varchar(31) NOT NULL DEFAULT '',
   `BankResetTimeMoney` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemMoney` int(10) unsigned NOT NULL DEFAULT '0',
   `BankResetTimeTab0` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemSlotsTab0` int(10) unsigned NOT NULL DEFAULT '0',
   `BankResetTimeTab1` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemSlotsTab1` int(10) unsigned NOT NULL DEFAULT '0',
   `BankResetTimeTab2` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemSlotsTab2` int(10) unsigned NOT NULL DEFAULT '0',
   `BankResetTimeTab3` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemSlotsTab3` int(10) unsigned NOT NULL DEFAULT '0',
   `BankResetTimeTab4` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemSlotsTab4` int(10) unsigned NOT NULL DEFAULT '0',
   `BankResetTimeTab5` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemSlotsTab5` int(10) unsigned NOT NULL DEFAULT '0',
   `BankResetTimeTab6` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemSlotsTab6` int(10) unsigned NOT NULL DEFAULT '0',
   `BankResetTimeTab7` int(10) unsigned NOT NULL DEFAULT '0',
   `BankRemSlotsTab7` int(10) unsigned NOT NULL DEFAULT '0',
   UNIQUE KEY `guid_key` (`guid`),
   KEY `guildid_key` (`guildid`),
   KEY `guildid_rank_key` (`guildid`,`rank`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';