aboutsummaryrefslogtreecommitdiff
path: root/sql/characters.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/characters.sql')
-rw-r--r--sql/characters.sql2478
1 files changed, 1239 insertions, 1239 deletions
diff --git a/sql/characters.sql b/sql/characters.sql
index f42dfe764de..f695ac2fc55 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -1,1239 +1,1239 @@
--- MySQL dump 10.11
---
--- Host: localhost Database: characters
--- ------------------------------------------------------
--- Server version 5.0.45-Debian_1ubuntu3.1-log
-
-/*!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 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `arena_team`
---
-
-DROP TABLE IF EXISTS `arena_team`;
-CREATE TABLE `arena_team` (
- `arenateamid` int(10) unsigned NOT NULL default '0',
- `name` char(255) NOT NULL,
- `captainguid` int(10) unsigned NOT NULL default '0',
- `type` tinyint(3) unsigned NOT NULL default '0',
- `BackgroundColor` int(10) unsigned NOT NULL default '0',
- `EmblemStyle` int(10) unsigned NOT NULL default '0',
- `EmblemColor` int(10) unsigned NOT NULL default '0',
- `BorderStyle` int(10) unsigned NOT NULL default '0',
- `BorderColor` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`arenateamid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `arena_team`
---
-
-LOCK TABLES `arena_team` WRITE;
-/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
-/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `arena_team_member`
---
-
-DROP TABLE IF EXISTS `arena_team_member`;
-CREATE TABLE `arena_team_member` (
- `arenateamid` int(10) unsigned NOT NULL default '0',
- `guid` int(10) unsigned NOT NULL default '0',
- `played_week` int(10) unsigned NOT NULL default '0',
- `wons_week` int(10) unsigned NOT NULL default '0',
- `played_season` int(10) unsigned NOT NULL default '0',
- `wons_season` int(10) unsigned NOT NULL default '0',
- `points_to_add` int(10) unsigned NOT NULL default '0'
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `arena_team_member`
---
-
-LOCK TABLES `arena_team_member` WRITE;
-/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
-/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `arena_team_stats`
---
-
-DROP TABLE IF EXISTS `arena_team_stats`;
-CREATE TABLE `arena_team_stats` (
- `arenateamid` int(10) unsigned NOT NULL default '0',
- `rating` int(10) unsigned NOT NULL default '0',
- `games` int(10) unsigned NOT NULL default '0',
- `wins` int(10) unsigned NOT NULL default '0',
- `played` int(10) unsigned NOT NULL default '0',
- `wins2` int(10) unsigned NOT NULL default '0',
- `rank` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`arenateamid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `arena_team_stats`
---
-
-LOCK TABLES `arena_team_stats` WRITE;
-/*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
-/*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `auctionhouse`
---
-
-DROP TABLE IF EXISTS `auctionhouse`;
-CREATE TABLE `auctionhouse` (
- `id` int(11) unsigned NOT NULL default '0',
- `auctioneerguid` int(11) unsigned NOT NULL default '0',
- `itemguid` int(11) unsigned NOT NULL default '0',
- `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
- `itemowner` int(11) unsigned NOT NULL default '0',
- `buyoutprice` int(11) NOT NULL default '0',
- `time` bigint(40) NOT NULL default '0',
- `buyguid` int(11) unsigned NOT NULL default '0',
- `lastbid` int(11) NOT NULL default '0',
- `startbid` int(11) NOT NULL default '0',
- `deposit` int(11) NOT NULL default '0',
- `location` tinyint(3) unsigned NOT NULL default '3',
- PRIMARY KEY (`id`),
- UNIQUE KEY `item_guid` (`itemguid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `auctionhouse`
---
-
-LOCK TABLES `auctionhouse` WRITE;
-/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
-/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `bugreport`
---
-
-DROP TABLE IF EXISTS `bugreport`;
-CREATE TABLE `bugreport` (
- `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
- `type` varchar(255) NOT NULL default '',
- `content` varchar(255) NOT NULL default '',
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
-
---
--- Dumping data for table `bugreport`
---
-
-LOCK TABLES `bugreport` WRITE;
-/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
-/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `characters`
---
-
-DROP TABLE IF EXISTS `characters`;
-CREATE TABLE `characters` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
- `data` longtext,
- `name` varchar(12) NOT NULL default '',
- `race` tinyint(3) unsigned NOT NULL default '0',
- `class` tinyint(3) unsigned NOT NULL default '0',
- `position_x` float NOT NULL default '0',
- `position_y` float NOT NULL default '0',
- `position_z` float NOT NULL default '0',
- `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
- `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `orientation` float NOT NULL default '0',
- `taximask` longtext,
- `online` tinyint(3) unsigned NOT NULL default '0',
- `cinematic` tinyint(3) unsigned NOT NULL default '0',
- `totaltime` int(11) unsigned NOT NULL default '0',
- `leveltime` int(11) unsigned NOT NULL default '0',
- `logout_time` bigint(20) unsigned NOT NULL default '0',
- `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
- `rest_bonus` float NOT NULL default '0',
- `resettalents_cost` int(11) unsigned NOT NULL default '0',
- `resettalents_time` bigint(20) unsigned NOT NULL default '0',
- `trans_x` float NOT NULL default '0',
- `trans_y` float NOT NULL default '0',
- `trans_z` float NOT NULL default '0',
- `trans_o` float NOT NULL default '0',
- `transguid` bigint(20) unsigned NOT NULL default '0',
- `gmstate` tinyint(3) unsigned NOT NULL default '0',
- `stable_slots` tinyint(1) unsigned NOT NULL default '0',
- `at_login` int(11) unsigned NOT NULL default '0',
- `zone` int(11) unsigned NOT NULL default '0',
- `death_expire_time` bigint(20) unsigned NOT NULL default '0',
- `taxi_path` text,
- PRIMARY KEY (`guid`),
- KEY `idx_account` (`account`),
- KEY `idx_online` (`online`),
- KEY `idx_name` (`name`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `characters`
---
-
-LOCK TABLES `characters` WRITE;
-/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
-/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_action`
---
-
-DROP TABLE IF EXISTS `character_action`;
-CREATE TABLE `character_action` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `button` tinyint(3) unsigned NOT NULL default '0',
- `action` smallint(5) unsigned NOT NULL default '0',
- `type` tinyint(3) unsigned NOT NULL default '0',
- `misc` tinyint(3) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`,`button`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_action`
---
-
-LOCK TABLES `character_action` WRITE;
-/*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_aura`
---
-
-DROP TABLE IF EXISTS `character_aura`;
-CREATE TABLE `character_aura` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
- `spell` int(11) unsigned NOT NULL default '0',
- `effect_index` int(11) unsigned NOT NULL default '0',
- `amount` int(11) NOT NULL default '0',
- `maxduration` int(11) NOT NULL default '0',
- `remaintime` int(11) NOT NULL default '0',
- `remaincharges` int(11) NOT NULL default '0',
- PRIMARY KEY (`guid`,`spell`,`effect_index`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_aura`
---
-
-LOCK TABLES `character_aura` WRITE;
-/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_declinedname`
---
-
-DROP TABLE IF EXISTS `character_declinedname`;
-CREATE TABLE `character_declinedname` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `genitive` varchar(15) NOT NULL default '',
- `dative` varchar(15) NOT NULL default '',
- `accusative` varchar(15) NOT NULL default '',
- `instrumental` varchar(15) NOT NULL default '',
- `prepositional` varchar(15) NOT NULL default '',
- PRIMARY KEY (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-
---
--- Dumping data for table `character_declinedname`
---
-
-LOCK TABLES `character_declinedname` WRITE;
-/*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_gifts`
---
-
-DROP TABLE IF EXISTS `character_gifts`;
-CREATE TABLE `character_gifts` (
- `guid` int(20) unsigned NOT NULL default '0',
- `item_guid` int(11) unsigned NOT NULL default '0',
- `entry` int(20) unsigned NOT NULL default '0',
- `flags` int(20) unsigned NOT NULL default '0',
- PRIMARY KEY (`item_guid`),
- KEY `idx_guid` (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `character_gifts`
---
-
-LOCK TABLES `character_gifts` WRITE;
-/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_homebind`
---
-
-DROP TABLE IF EXISTS `character_homebind`;
-CREATE TABLE `character_homebind` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
- `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
- `position_x` float NOT NULL default '0',
- `position_y` float NOT NULL default '0',
- `position_z` float NOT NULL default '0',
- PRIMARY KEY (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_homebind`
---
-
-LOCK TABLES `character_homebind` WRITE;
-/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_instance`
---
-
-DROP TABLE IF EXISTS `character_instance`;
-CREATE TABLE `character_instance` (
- `guid` int(11) unsigned NOT NULL default '0',
- `instance` int(11) unsigned NOT NULL default '0',
- `permanent` tinyint(1) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`,`instance`),
- KEY `instance` (`instance`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `character_instance`
---
-
-LOCK TABLES `character_instance` WRITE;
-/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_inventory`
---
-
-DROP TABLE IF EXISTS `character_inventory`;
-CREATE TABLE `character_inventory` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `bag` int(11) unsigned NOT NULL default '0',
- `slot` tinyint(3) unsigned NOT NULL default '0',
- `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
- `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
- PRIMARY KEY (`item`),
- KEY `idx_guid` (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_inventory`
---
-
-LOCK TABLES `character_inventory` WRITE;
-/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_pet`
---
-
-DROP TABLE IF EXISTS `character_pet`;
-CREATE TABLE `character_pet` (
- `id` int(11) unsigned NOT NULL default '0',
- `entry` int(11) unsigned NOT NULL default '0',
- `owner` int(11) unsigned NOT NULL default '0',
- `modelid` int(11) unsigned default '0',
- `CreatedBySpell` int(11) unsigned NOT NULL default '0',
- `PetType` tinyint(3) unsigned NOT NULL default '0',
- `level` int(11) unsigned NOT NULL default '1',
- `exp` int(11) unsigned NOT NULL default '0',
- `Reactstate` tinyint(1) unsigned NOT NULL default '0',
- `loyaltypoints` int(11) NOT NULL default '0',
- `loyalty` int(11) unsigned NOT NULL default '0',
- `trainpoint` int(11) NOT NULL default '0',
- `name` varchar(100) default 'Pet',
- `renamed` tinyint(1) unsigned NOT NULL default '0',
- `slot` int(11) unsigned NOT NULL default '0',
- `curhealth` int(11) unsigned NOT NULL default '1',
- `curmana` int(11) unsigned NOT NULL default '0',
- `curhappiness` int(11) unsigned NOT NULL default '0',
- `savetime` bigint(20) unsigned NOT NULL default '0',
- `resettalents_cost` int(11) unsigned NOT NULL default '0',
- `resettalents_time` bigint(20) unsigned NOT NULL default '0',
- `abdata` longtext,
- `teachspelldata` longtext,
- PRIMARY KEY (`id`),
- KEY `owner` (`owner`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
-
---
--- Dumping data for table `character_pet`
---
-
-LOCK TABLES `character_pet` WRITE;
-/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_pet_declinedname`
---
-
-DROP TABLE IF EXISTS `character_pet_declinedname`;
-CREATE TABLE `character_pet_declinedname` (
- `id` int(11) unsigned NOT NULL default '0',
- `owner` int(11) unsigned NOT NULL default '0',
- `genitive` varchar(12) NOT NULL default '',
- `dative` varchar(12) NOT NULL default '',
- `accusative` varchar(12) NOT NULL default '',
- `instrumental` varchar(12) NOT NULL default '',
- `prepositional` varchar(12) NOT NULL default '',
- PRIMARY KEY (`id`),
- KEY owner_key (`owner`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-
---
--- Dumping data for table `character_pet_declinedname`
---
-
-LOCK TABLES `character_pet_declinedname` WRITE;
-/*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_queststatus`
---
-
-DROP TABLE IF EXISTS `character_queststatus`;
-CREATE TABLE `character_queststatus` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
- `status` int(11) unsigned NOT NULL default '0',
- `rewarded` tinyint(1) unsigned NOT NULL default '0',
- `explored` tinyint(1) unsigned NOT NULL default '0',
- `timer` bigint(20) unsigned NOT NULL default '0',
- `mobcount1` int(11) unsigned NOT NULL default '0',
- `mobcount2` int(11) unsigned NOT NULL default '0',
- `mobcount3` int(11) unsigned NOT NULL default '0',
- `mobcount4` int(11) unsigned NOT NULL default '0',
- `itemcount1` int(11) unsigned NOT NULL default '0',
- `itemcount2` int(11) unsigned NOT NULL default '0',
- `itemcount3` int(11) unsigned NOT NULL default '0',
- `itemcount4` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`,`quest`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_queststatus`
---
-
-LOCK TABLES `character_queststatus` WRITE;
-/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_queststatus_daily`
---
-
-DROP TABLE IF EXISTS `character_queststatus_daily`;
-CREATE TABLE `character_queststatus_daily` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
- `time` bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`,`quest`),
- KEY `idx_guid` (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_queststatus_daily`
---
-
-LOCK TABLES `character_queststatus_daily` WRITE;
-/*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_reputation`
---
-
-DROP TABLE IF EXISTS `character_reputation`;
-CREATE TABLE `character_reputation` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `faction` int(11) unsigned NOT NULL default '0',
- `standing` int(11) NOT NULL default '0',
- `flags` int(11) NOT NULL default '0',
- PRIMARY KEY (`guid`,`faction`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_reputation`
---
-
-LOCK TABLES `character_reputation` WRITE;
-/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_social`
---
-
-DROP TABLE IF EXISTS `character_social`;
-CREATE TABLE `character_social` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
- `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
- `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
- `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
- PRIMARY KEY (`guid`,`friend`,`flags`),
- KEY `guid` (`guid`),
- KEY `friend` (`friend`),
- KEY `guid_flags` (`guid`,`flags`),
- KEY `friend_flags` (`friend`,`flags`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_social`
---
-
-LOCK TABLES `character_social` WRITE;
-/*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_spell`
---
-
-DROP TABLE IF EXISTS `character_spell`;
-CREATE TABLE `character_spell` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
- `slot` int(11) unsigned NOT NULL default '0',
- `active` tinyint(3) unsigned NOT NULL default '1',
- `disabled` tinyint(3) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`,`spell`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_spell`
---
-
-LOCK TABLES `character_spell` WRITE;
-/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_spell_cooldown`
---
-
-DROP TABLE IF EXISTS `character_spell_cooldown`;
-CREATE TABLE `character_spell_cooldown` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
- `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
- `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
- `time` bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`,`spell`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `character_spell_cooldown`
---
-
-LOCK TABLES `character_spell_cooldown` WRITE;
-/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_ticket`
---
-
-DROP TABLE IF EXISTS `character_ticket`;
-CREATE TABLE `character_ticket` (
- `ticket_id` int(11) unsigned NOT NULL auto_increment,
- `guid` int(11) unsigned NOT NULL default '0',
- `ticket_text` text,
- `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`ticket_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_ticket`
---
-
-LOCK TABLES `character_ticket` WRITE;
-/*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_tutorial`
---
-
-DROP TABLE IF EXISTS `character_tutorial`;
-CREATE TABLE `character_tutorial` (
- `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
- `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
- `tut0` int(11) unsigned NOT NULL default '0',
- `tut1` int(11) unsigned NOT NULL default '0',
- `tut2` int(11) unsigned NOT NULL default '0',
- `tut3` int(11) unsigned NOT NULL default '0',
- `tut4` int(11) unsigned NOT NULL default '0',
- `tut5` int(11) unsigned NOT NULL default '0',
- `tut6` int(11) unsigned NOT NULL default '0',
- `tut7` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`account`,`realmid`),
- KEY acc_key (`account`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
-
---
--- Dumping data for table `character_tutorial`
---
-
-LOCK TABLES `character_tutorial` WRITE;
-/*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `corpse`
---
-
-DROP TABLE IF EXISTS `corpse`;
-CREATE TABLE `corpse` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
- `position_x` float NOT NULL default '0',
- `position_y` float NOT NULL default '0',
- `position_z` float NOT NULL default '0',
- `orientation` float NOT NULL default '0',
- `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
- `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
- `data` longtext,
- `time` bigint(20) unsigned NOT NULL default '0',
- `corpse_type` tinyint(3) unsigned NOT NULL default '0',
- `instance` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`),
- KEY `idx_type` (`corpse_type`),
- KEY `instance` (`instance`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
-
---
--- Dumping data for table `corpse`
---
-
-LOCK TABLES `corpse` WRITE;
-/*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
-/*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `groups`
---
-
-DROP TABLE IF EXISTS `groups`;
-CREATE TABLE `groups` (
- `leaderGuid` int(11) unsigned NOT NULL,
- `mainTank` int(11) unsigned NOT NULL,
- `mainAssistant` int(11) unsigned NOT NULL,
- `lootMethod` tinyint(4) unsigned NOT NULL,
- `looterGuid` int(11) unsigned NOT NULL,
- `lootThreshold` tinyint(4) unsigned NOT NULL,
- `icon1` int(11) unsigned NOT NULL,
- `icon2` int(11) unsigned NOT NULL,
- `icon3` int(11) unsigned NOT NULL,
- `icon4` int(11) unsigned NOT NULL,
- `icon5` int(11) unsigned NOT NULL,
- `icon6` int(11) unsigned NOT NULL,
- `icon7` int(11) unsigned NOT NULL,
- `icon8` int(11) unsigned NOT NULL,
- `isRaid` tinyint(1) unsigned NOT NULL,
- `difficulty` tinyint(3) unsigned NOT NULL default '0',
- PRIMARY KEY (`leaderGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
-
---
--- Dumping data for table `groups`
---
-
-LOCK TABLES `groups` WRITE;
-/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
-/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
-UNLOCK TABLES;
-
--- ----------------------------
--- Table structure for group_instance
--- ----------------------------
-DROP TABLE IF EXISTS `group_instance`;
-CREATE TABLE `group_instance` (
- `leaderGuid` int(11) unsigned NOT NULL default '0',
- `instance` int(11) unsigned NOT NULL default '0',
- `permanent` tinyint(1) unsigned NOT NULL default '0',
- PRIMARY KEY (`leaderGuid`,`instance`),
- KEY `instance` (`instance`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `group_instance`
---
-
-LOCK TABLES `group_instance` WRITE;
-/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
-/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `group_member`
---
-
-DROP TABLE IF EXISTS `group_member`;
-CREATE TABLE `group_member` (
- `leaderGuid` int(11) unsigned NOT NULL,
- `memberGuid` int(11) unsigned NOT NULL,
- `assistant` tinyint(1) unsigned NOT NULL,
- `subgroup` smallint(6) unsigned NOT NULL,
- PRIMARY KEY (`leaderGuid`,`memberGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
-
---
--- Dumping data for table `group_member`
---
-
-LOCK TABLES `group_member` WRITE;
-/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
-/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild`
---
-
-DROP TABLE IF EXISTS `guild`;
-CREATE TABLE `guild` (
- `guildid` int(6) unsigned NOT NULL default '0',
- `name` varchar(255) NOT NULL default '',
- `leaderguid` int(6) unsigned NOT NULL default '0',
- `EmblemStyle` int(5) NOT NULL default '0',
- `EmblemColor` int(5) NOT NULL default '0',
- `BorderStyle` int(5) NOT NULL default '0',
- `BorderColor` int(5) NOT NULL default '0',
- `BackgroundColor` int(5) NOT NULL default '0',
- `info` text NOT NULL,
- `motd` varchar(255) NOT NULL default '',
- `createdate` datetime default NULL,
- `BankMoney` bigint(20) NOT NULL default '0',
- PRIMARY KEY (`guildid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
-
---
--- Dumping data for table `guild`
---
-
-LOCK TABLES `guild` WRITE;
-/*!40000 ALTER TABLE `guild` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild_bank_eventlog`
---
-
-DROP TABLE IF EXISTS `guild_bank_eventlog`;
-CREATE TABLE `guild_bank_eventlog` (
- `guildid` int(11) unsigned NOT NULL default '0',
- `LogGuid` int(11) unsigned NOT NULL default '0',
- `LogEntry` tinyint(1) unsigned NOT NULL default '0',
- `TabId` tinyint(1) unsigned NOT NULL default '0',
- `PlayerGuid` int(11) unsigned NOT NULL default '0',
- `ItemOrMoney` int(11) unsigned NOT NULL default '0',
- `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
- `DestTabId` tinyint(1) unsigned NOT NULL default '0',
- `TimeStamp` bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (`guildid`,`LogGuid`),
- KEY `guildid_key` (`guildid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `guild_bank_eventlog`
---
-
-LOCK TABLES `guild_bank_eventlog` WRITE;
-/*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild_bank_item`
---
-
-DROP TABLE IF EXISTS `guild_bank_item`;
-CREATE TABLE `guild_bank_item` (
- `guildid` int(11) unsigned NOT NULL default '0',
- `TabId` tinyint(1) unsigned NOT NULL default '0',
- `SlotId` tinyint(3) unsigned NOT NULL default '0',
- `item_guid` int(11) unsigned NOT NULL default '0',
- `item_entry` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`guildid`,`tabid`,`slotid`),
- KEY `guildid_key` (`guildid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `guild_bank_item`
---
-
-LOCK TABLES `guild_bank_item` WRITE;
-/*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild_bank_right`
---
-
-DROP TABLE IF EXISTS `guild_bank_right`;
-CREATE TABLE `guild_bank_right` (
- `guildid` int(11) unsigned NOT NULL default '0',
- `TabId` tinyint(1) unsigned NOT NULL default '0',
- `rid` int(11) unsigned NOT NULL default '0',
- `gbright` tinyint(3) unsigned NOT NULL default '0',
- `SlotPerDay` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`guildid`,`TabId`,`rid`),
- KEY `guildid_key` (`guildid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `guild_bank_right`
---
-
-LOCK TABLES `guild_bank_right` WRITE;
-/*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild_bank_tab`
---
-
-DROP TABLE IF EXISTS `guild_bank_tab`;
-CREATE TABLE `guild_bank_tab` (
- `guildid` int(11) unsigned NOT NULL default '0',
- `TabId` tinyint(1) unsigned NOT NULL default '0',
- `TabName` varchar(100) NOT NULL default '',
- `TabIcon` varchar(100) NOT NULL default '',
- `TabText` varchar(500) NOT NULL default '',
- PRIMARY KEY (`guildid`,`TabId`),
- KEY `guildid_key` (`guildid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `guild_bank_tab`
---
-
-LOCK TABLES `guild_bank_tab` WRITE;
-/*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild_eventlog`
---
-
-DROP TABLE IF EXISTS `guild_eventlog`;
-CREATE TABLE `guild_eventlog` (
- `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
- `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
- `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
- `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
- `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
- `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
- `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
-) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog';
-
---
--- Dumping data for table `guild_eventlog`
---
-
-LOCK TABLES `guild_eventlog` WRITE;
-/*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild_member`
---
-
-DROP TABLE IF EXISTS `guild_member`;
-CREATE TABLE `guild_member` (
- `guildid` int(6) unsigned NOT NULL default '0',
- `guid` int(11) unsigned NOT NULL default '0',
- `rank` tinyint(2) unsigned NOT NULL default '0',
- `pnote` varchar(255) NOT NULL default '',
- `offnote` varchar(255) NOT NULL default '',
- `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
- `BankRemMoney` int(11) unsigned NOT NULL default '0',
- `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
- `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
- `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
- `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
- `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
- `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
- `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
- `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
- `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
- `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
- `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
- `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
- KEY `guildid_key` (`guildid`),
- KEY `guildid_rank_key` (`guildid`,`rank`),
- KEY `guid_key` (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
-
---
--- Dumping data for table `guild_member`
---
-
-LOCK TABLES `guild_member` WRITE;
-/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild_rank`
---
-
-DROP TABLE IF EXISTS `guild_rank`;
-CREATE TABLE `guild_rank` (
- `guildid` int(6) unsigned NOT NULL default '0',
- `rid` int(11) unsigned NOT NULL,
- `rname` varchar(255) NOT NULL default '',
- `rights` int(3) unsigned NOT NULL default '0',
- `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`guildid`,`rid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
-
---
--- Dumping data for table `guild_rank`
---
-
-LOCK TABLES `guild_rank` WRITE;
-/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `instance`
---
-
-DROP TABLE IF EXISTS `instance`;
-CREATE TABLE `instance` (
- `id` int(11) unsigned NOT NULL default '0',
- `map` int(11) unsigned NOT NULL default '0',
- `resettime` bigint(40) NOT NULL default '0',
- `difficulty` tinyint(1) unsigned NOT NULL default '0',
- `data` longtext,
- PRIMARY KEY (`id`),
- KEY `map` (`map`),
- KEY `resettime` (`resettime`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `instance`
---
-
-LOCK TABLES `instance` WRITE;
-/*!40000 ALTER TABLE `instance` DISABLE KEYS */;
-/*!40000 ALTER TABLE `instance` ENABLE KEYS */;
-UNLOCK TABLES;
-
--- ----------------------------
--- Table structure for instance_reset
--- ----------------------------
-DROP TABLE IF EXISTS `instance_reset`;
-CREATE TABLE `instance_reset` (
- `mapid` int(11) unsigned NOT NULL default '0',
- `resettime` bigint(40) NOT NULL default '0',
- PRIMARY KEY (`mapid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `instance_reset`
---
-
-LOCK TABLES `instance_reset` WRITE;
-/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
-/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance`
---
-
-DROP TABLE IF EXISTS `item_instance`;
-CREATE TABLE `item_instance` (
- `guid` int(11) unsigned NOT NULL default '0',
- `owner_guid` int(11) unsigned NOT NULL default '0',
- `data` longtext,
- PRIMARY KEY (`guid`),
- KEY `idx_owner_guid` (`owner_guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
-
---
--- Dumping data for table `item_instance`
---
-
-LOCK TABLES `item_instance` WRITE;
-/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_text`
---
-
-DROP TABLE IF EXISTS `item_text`;
-CREATE TABLE `item_text` (
- `id` int(11) unsigned NOT NULL default '0',
- `text` longtext,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
-
---
--- Dumping data for table `item_text`
---
-
-LOCK TABLES `item_text` WRITE;
-/*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `mail`
---
-
-DROP TABLE IF EXISTS `mail`;
-CREATE TABLE `mail` (
- `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
- `messageType` tinyint(3) unsigned NOT NULL default '0',
- `stationery` tinyint(3) NOT NULL default '41',
- `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
- `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
- `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
- `subject` longtext,
- `itemTextId` int(11) unsigned NOT NULL default '0',
- `has_items` tinyint(3) unsigned NOT NULL default '0',
- `expire_time` bigint(40) NOT NULL default '0',
- `deliver_time` bigint(40) NOT NULL default '0',
- `money` int(11) unsigned NOT NULL default '0',
- `cod` int(11) unsigned NOT NULL default '0',
- `checked` tinyint(3) unsigned NOT NULL default '0',
- PRIMARY KEY (`id`),
- KEY `idx_receiver` (`receiver`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
-
---
--- Dumping data for table `mail`
---
-
-LOCK TABLES `mail` WRITE;
-/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
-/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `mail_items`
---
-
-DROP TABLE IF EXISTS `mail_items`;
-CREATE TABLE `mail_items` (
- `mail_id` int(11) NOT NULL default '0',
- `item_guid` int(11) NOT NULL default '0',
- `item_template` int(11) NOT NULL default '0',
- `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
- PRIMARY KEY (`mail_id`,`item_guid`),
- KEY `idx_receiver` (`receiver`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-
---
--- Dumping data for table `mail_items`
---
-
-LOCK TABLES `mail_items` WRITE;
-/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
-/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `pet_aura`
---
-
-DROP TABLE IF EXISTS `pet_aura`;
-CREATE TABLE `pet_aura` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
- `spell` int(11) unsigned NOT NULL default '0',
- `effect_index` int(11) unsigned NOT NULL default '0',
- `amount` int(11) NOT NULL default '0',
- `maxduration` int(11) NOT NULL default '0',
- `remaintime` int(11) NOT NULL default '0',
- `remaincharges` int(11) NOT NULL default '0',
- PRIMARY KEY (`guid`,`spell`,`effect_index`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
-
---
--- Dumping data for table `pet_aura`
---
-
-LOCK TABLES `pet_aura` WRITE;
-/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
-/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `pet_spell`
---
-
-DROP TABLE IF EXISTS `pet_spell`;
-CREATE TABLE `pet_spell` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
- `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
- `slot` int(11) unsigned NOT NULL default '0',
- `active` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`,`spell`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
-
---
--- Dumping data for table `pet_spell`
---
-
-LOCK TABLES `pet_spell` WRITE;
-/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
-/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `pet_spell_cooldown`
---
-
-DROP TABLE IF EXISTS `pet_spell_cooldown`;
-CREATE TABLE `pet_spell_cooldown` (
- `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
- `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
- `time` bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (`guid`,`spell`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `pet_spell_cooldown`
---
-
-LOCK TABLES `pet_spell_cooldown` WRITE;
-/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
-/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `petition`
---
-
-DROP TABLE IF EXISTS `petition`;
-CREATE TABLE `petition` (
- `ownerguid` int(10) unsigned NOT NULL,
- `petitionguid` int(10) unsigned default '0',
- `name` varchar(255) NOT NULL default '',
- `type` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`ownerguid`,`type`),
- UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
-
---
--- Dumping data for table `petition`
---
-
-LOCK TABLES `petition` WRITE;
-/*!40000 ALTER TABLE `petition` DISABLE KEYS */;
-/*!40000 ALTER TABLE `petition` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `petition_sign`
---
-
-DROP TABLE IF EXISTS `petition_sign`;
-CREATE TABLE `petition_sign` (
- `ownerguid` int(10) unsigned NOT NULL,
- `petitionguid` int(11) unsigned NOT NULL default '0',
- `playerguid` int(11) unsigned NOT NULL default '0',
- `player_account` int(11) unsigned NOT NULL default '0',
- `type` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`petitionguid`,`playerguid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
---
--- Dumping data for table `petition_sign`
---
-
-LOCK TABLES `petition_sign` WRITE;
-/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
-/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `saved_variables`
---
-DROP TABLE IF EXISTS `saved_variables`;
-CREATE TABLE `saved_variables` (
- `NextArenaPointDistributionTime` timestamp NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
-
---
--- Dumping data for table `saved_variables`
---
-
-LOCK TABLES `saved_variables` WRITE;
-/*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
-/*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
-UNLOCK TABLES;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!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 */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2008-01-10 11:37:06
+-- MySQL dump 10.11
+--
+-- Host: localhost Database: characters
+-- ------------------------------------------------------
+-- Server version 5.0.45-Debian_1ubuntu3.1-log
+
+/*!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 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `arena_team`
+--
+
+DROP TABLE IF EXISTS `arena_team`;
+CREATE TABLE `arena_team` (
+ `arenateamid` int(10) unsigned NOT NULL default '0',
+ `name` char(255) NOT NULL,
+ `captainguid` int(10) unsigned NOT NULL default '0',
+ `type` tinyint(3) unsigned NOT NULL default '0',
+ `BackgroundColor` int(10) unsigned NOT NULL default '0',
+ `EmblemStyle` int(10) unsigned NOT NULL default '0',
+ `EmblemColor` int(10) unsigned NOT NULL default '0',
+ `BorderStyle` int(10) unsigned NOT NULL default '0',
+ `BorderColor` int(10) unsigned NOT NULL default '0',
+ PRIMARY KEY (`arenateamid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `arena_team`
+--
+
+LOCK TABLES `arena_team` WRITE;
+/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
+/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `arena_team_member`
+--
+
+DROP TABLE IF EXISTS `arena_team_member`;
+CREATE TABLE `arena_team_member` (
+ `arenateamid` int(10) unsigned NOT NULL default '0',
+ `guid` int(10) unsigned NOT NULL default '0',
+ `played_week` int(10) unsigned NOT NULL default '0',
+ `wons_week` int(10) unsigned NOT NULL default '0',
+ `played_season` int(10) unsigned NOT NULL default '0',
+ `wons_season` int(10) unsigned NOT NULL default '0',
+ `points_to_add` int(10) unsigned NOT NULL default '0'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `arena_team_member`
+--
+
+LOCK TABLES `arena_team_member` WRITE;
+/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
+/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `arena_team_stats`
+--
+
+DROP TABLE IF EXISTS `arena_team_stats`;
+CREATE TABLE `arena_team_stats` (
+ `arenateamid` int(10) unsigned NOT NULL default '0',
+ `rating` int(10) unsigned NOT NULL default '0',
+ `games` int(10) unsigned NOT NULL default '0',
+ `wins` int(10) unsigned NOT NULL default '0',
+ `played` int(10) unsigned NOT NULL default '0',
+ `wins2` int(10) unsigned NOT NULL default '0',
+ `rank` int(10) unsigned NOT NULL default '0',
+ PRIMARY KEY (`arenateamid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `arena_team_stats`
+--
+
+LOCK TABLES `arena_team_stats` WRITE;
+/*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
+/*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `auctionhouse`
+--
+
+DROP TABLE IF EXISTS `auctionhouse`;
+CREATE TABLE `auctionhouse` (
+ `id` int(11) unsigned NOT NULL default '0',
+ `auctioneerguid` int(11) unsigned NOT NULL default '0',
+ `itemguid` int(11) unsigned NOT NULL default '0',
+ `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
+ `itemowner` int(11) unsigned NOT NULL default '0',
+ `buyoutprice` int(11) NOT NULL default '0',
+ `time` bigint(40) NOT NULL default '0',
+ `buyguid` int(11) unsigned NOT NULL default '0',
+ `lastbid` int(11) NOT NULL default '0',
+ `startbid` int(11) NOT NULL default '0',
+ `deposit` int(11) NOT NULL default '0',
+ `location` tinyint(3) unsigned NOT NULL default '3',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `item_guid` (`itemguid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `auctionhouse`
+--
+
+LOCK TABLES `auctionhouse` WRITE;
+/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
+/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `bugreport`
+--
+
+DROP TABLE IF EXISTS `bugreport`;
+CREATE TABLE `bugreport` (
+ `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
+ `type` varchar(255) NOT NULL default '',
+ `content` varchar(255) NOT NULL default '',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
+
+--
+-- Dumping data for table `bugreport`
+--
+
+LOCK TABLES `bugreport` WRITE;
+/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
+/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `characters`
+--
+
+DROP TABLE IF EXISTS `characters`;
+CREATE TABLE `characters` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
+ `data` longtext,
+ `name` varchar(12) NOT NULL default '',
+ `race` tinyint(3) unsigned NOT NULL default '0',
+ `class` tinyint(3) unsigned NOT NULL default '0',
+ `position_x` float NOT NULL default '0',
+ `position_y` float NOT NULL default '0',
+ `position_z` float NOT NULL default '0',
+ `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
+ `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `orientation` float NOT NULL default '0',
+ `taximask` longtext,
+ `online` tinyint(3) unsigned NOT NULL default '0',
+ `cinematic` tinyint(3) unsigned NOT NULL default '0',
+ `totaltime` int(11) unsigned NOT NULL default '0',
+ `leveltime` int(11) unsigned NOT NULL default '0',
+ `logout_time` bigint(20) unsigned NOT NULL default '0',
+ `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
+ `rest_bonus` float NOT NULL default '0',
+ `resettalents_cost` int(11) unsigned NOT NULL default '0',
+ `resettalents_time` bigint(20) unsigned NOT NULL default '0',
+ `trans_x` float NOT NULL default '0',
+ `trans_y` float NOT NULL default '0',
+ `trans_z` float NOT NULL default '0',
+ `trans_o` float NOT NULL default '0',
+ `transguid` bigint(20) unsigned NOT NULL default '0',
+ `gmstate` int(11) unsigned NOT NULL default '0',
+ `stable_slots` tinyint(1) unsigned NOT NULL default '0',
+ `at_login` int(11) unsigned NOT NULL default '0',
+ `zone` int(11) unsigned NOT NULL default '0',
+ `death_expire_time` bigint(20) unsigned NOT NULL default '0',
+ `taxi_path` text,
+ PRIMARY KEY (`guid`),
+ KEY `idx_account` (`account`),
+ KEY `idx_online` (`online`),
+ KEY `idx_name` (`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `characters`
+--
+
+LOCK TABLES `characters` WRITE;
+/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
+/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_action`
+--
+
+DROP TABLE IF EXISTS `character_action`;
+CREATE TABLE `character_action` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `button` tinyint(3) unsigned NOT NULL default '0',
+ `action` smallint(5) unsigned NOT NULL default '0',
+ `type` tinyint(3) unsigned NOT NULL default '0',
+ `misc` tinyint(3) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`button`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_action`
+--
+
+LOCK TABLES `character_action` WRITE;
+/*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_aura`
+--
+
+DROP TABLE IF EXISTS `character_aura`;
+CREATE TABLE `character_aura` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
+ `spell` int(11) unsigned NOT NULL default '0',
+ `effect_index` int(11) unsigned NOT NULL default '0',
+ `amount` int(11) NOT NULL default '0',
+ `maxduration` int(11) NOT NULL default '0',
+ `remaintime` int(11) NOT NULL default '0',
+ `remaincharges` int(11) NOT NULL default '0',
+ PRIMARY KEY (`guid`,`spell`,`effect_index`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_aura`
+--
+
+LOCK TABLES `character_aura` WRITE;
+/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_declinedname`
+--
+
+DROP TABLE IF EXISTS `character_declinedname`;
+CREATE TABLE `character_declinedname` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `genitive` varchar(15) NOT NULL default '',
+ `dative` varchar(15) NOT NULL default '',
+ `accusative` varchar(15) NOT NULL default '',
+ `instrumental` varchar(15) NOT NULL default '',
+ `prepositional` varchar(15) NOT NULL default '',
+ PRIMARY KEY (`guid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
+
+--
+-- Dumping data for table `character_declinedname`
+--
+
+LOCK TABLES `character_declinedname` WRITE;
+/*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_gifts`
+--
+
+DROP TABLE IF EXISTS `character_gifts`;
+CREATE TABLE `character_gifts` (
+ `guid` int(20) unsigned NOT NULL default '0',
+ `item_guid` int(11) unsigned NOT NULL default '0',
+ `entry` int(20) unsigned NOT NULL default '0',
+ `flags` int(20) unsigned NOT NULL default '0',
+ PRIMARY KEY (`item_guid`),
+ KEY `idx_guid` (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `character_gifts`
+--
+
+LOCK TABLES `character_gifts` WRITE;
+/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_homebind`
+--
+
+DROP TABLE IF EXISTS `character_homebind`;
+CREATE TABLE `character_homebind` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
+ `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
+ `position_x` float NOT NULL default '0',
+ `position_y` float NOT NULL default '0',
+ `position_z` float NOT NULL default '0',
+ PRIMARY KEY (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_homebind`
+--
+
+LOCK TABLES `character_homebind` WRITE;
+/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_instance`
+--
+
+DROP TABLE IF EXISTS `character_instance`;
+CREATE TABLE `character_instance` (
+ `guid` int(11) unsigned NOT NULL default '0',
+ `instance` int(11) unsigned NOT NULL default '0',
+ `permanent` tinyint(1) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`instance`),
+ KEY `instance` (`instance`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `character_instance`
+--
+
+LOCK TABLES `character_instance` WRITE;
+/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_inventory`
+--
+
+DROP TABLE IF EXISTS `character_inventory`;
+CREATE TABLE `character_inventory` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `bag` int(11) unsigned NOT NULL default '0',
+ `slot` tinyint(3) unsigned NOT NULL default '0',
+ `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
+ `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
+ PRIMARY KEY (`item`),
+ KEY `idx_guid` (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_inventory`
+--
+
+LOCK TABLES `character_inventory` WRITE;
+/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_pet`
+--
+
+DROP TABLE IF EXISTS `character_pet`;
+CREATE TABLE `character_pet` (
+ `id` int(11) unsigned NOT NULL default '0',
+ `entry` int(11) unsigned NOT NULL default '0',
+ `owner` int(11) unsigned NOT NULL default '0',
+ `modelid` int(11) unsigned default '0',
+ `CreatedBySpell` int(11) unsigned NOT NULL default '0',
+ `PetType` tinyint(3) unsigned NOT NULL default '0',
+ `level` int(11) unsigned NOT NULL default '1',
+ `exp` int(11) unsigned NOT NULL default '0',
+ `Reactstate` tinyint(1) unsigned NOT NULL default '0',
+ `loyaltypoints` int(11) NOT NULL default '0',
+ `loyalty` int(11) unsigned NOT NULL default '0',
+ `trainpoint` int(11) NOT NULL default '0',
+ `name` varchar(100) default 'Pet',
+ `renamed` tinyint(1) unsigned NOT NULL default '0',
+ `slot` int(11) unsigned NOT NULL default '0',
+ `curhealth` int(11) unsigned NOT NULL default '1',
+ `curmana` int(11) unsigned NOT NULL default '0',
+ `curhappiness` int(11) unsigned NOT NULL default '0',
+ `savetime` bigint(20) unsigned NOT NULL default '0',
+ `resettalents_cost` int(11) unsigned NOT NULL default '0',
+ `resettalents_time` bigint(20) unsigned NOT NULL default '0',
+ `abdata` longtext,
+ `teachspelldata` longtext,
+ PRIMARY KEY (`id`),
+ KEY `owner` (`owner`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
+
+--
+-- Dumping data for table `character_pet`
+--
+
+LOCK TABLES `character_pet` WRITE;
+/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_pet_declinedname`
+--
+
+DROP TABLE IF EXISTS `character_pet_declinedname`;
+CREATE TABLE `character_pet_declinedname` (
+ `id` int(11) unsigned NOT NULL default '0',
+ `owner` int(11) unsigned NOT NULL default '0',
+ `genitive` varchar(12) NOT NULL default '',
+ `dative` varchar(12) NOT NULL default '',
+ `accusative` varchar(12) NOT NULL default '',
+ `instrumental` varchar(12) NOT NULL default '',
+ `prepositional` varchar(12) NOT NULL default '',
+ PRIMARY KEY (`id`),
+ KEY owner_key (`owner`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
+
+--
+-- Dumping data for table `character_pet_declinedname`
+--
+
+LOCK TABLES `character_pet_declinedname` WRITE;
+/*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_queststatus`
+--
+
+DROP TABLE IF EXISTS `character_queststatus`;
+CREATE TABLE `character_queststatus` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
+ `status` int(11) unsigned NOT NULL default '0',
+ `rewarded` tinyint(1) unsigned NOT NULL default '0',
+ `explored` tinyint(1) unsigned NOT NULL default '0',
+ `timer` bigint(20) unsigned NOT NULL default '0',
+ `mobcount1` int(11) unsigned NOT NULL default '0',
+ `mobcount2` int(11) unsigned NOT NULL default '0',
+ `mobcount3` int(11) unsigned NOT NULL default '0',
+ `mobcount4` int(11) unsigned NOT NULL default '0',
+ `itemcount1` int(11) unsigned NOT NULL default '0',
+ `itemcount2` int(11) unsigned NOT NULL default '0',
+ `itemcount3` int(11) unsigned NOT NULL default '0',
+ `itemcount4` int(11) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`quest`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_queststatus`
+--
+
+LOCK TABLES `character_queststatus` WRITE;
+/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_queststatus_daily`
+--
+
+DROP TABLE IF EXISTS `character_queststatus_daily`;
+CREATE TABLE `character_queststatus_daily` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
+ `time` bigint(20) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`quest`),
+ KEY `idx_guid` (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_queststatus_daily`
+--
+
+LOCK TABLES `character_queststatus_daily` WRITE;
+/*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_reputation`
+--
+
+DROP TABLE IF EXISTS `character_reputation`;
+CREATE TABLE `character_reputation` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `faction` int(11) unsigned NOT NULL default '0',
+ `standing` int(11) NOT NULL default '0',
+ `flags` int(11) NOT NULL default '0',
+ PRIMARY KEY (`guid`,`faction`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_reputation`
+--
+
+LOCK TABLES `character_reputation` WRITE;
+/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_social`
+--
+
+DROP TABLE IF EXISTS `character_social`;
+CREATE TABLE `character_social` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
+ `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
+ `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
+ `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
+ PRIMARY KEY (`guid`,`friend`,`flags`),
+ KEY `guid` (`guid`),
+ KEY `friend` (`friend`),
+ KEY `guid_flags` (`guid`,`flags`),
+ KEY `friend_flags` (`friend`,`flags`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_social`
+--
+
+LOCK TABLES `character_social` WRITE;
+/*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_spell`
+--
+
+DROP TABLE IF EXISTS `character_spell`;
+CREATE TABLE `character_spell` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
+ `slot` int(11) unsigned NOT NULL default '0',
+ `active` tinyint(3) unsigned NOT NULL default '1',
+ `disabled` tinyint(3) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`spell`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_spell`
+--
+
+LOCK TABLES `character_spell` WRITE;
+/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_spell_cooldown`
+--
+
+DROP TABLE IF EXISTS `character_spell_cooldown`;
+CREATE TABLE `character_spell_cooldown` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
+ `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
+ `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
+ `time` bigint(20) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`spell`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `character_spell_cooldown`
+--
+
+LOCK TABLES `character_spell_cooldown` WRITE;
+/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_ticket`
+--
+
+DROP TABLE IF EXISTS `character_ticket`;
+CREATE TABLE `character_ticket` (
+ `ticket_id` int(11) unsigned NOT NULL auto_increment,
+ `guid` int(11) unsigned NOT NULL default '0',
+ `ticket_text` text,
+ `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY (`ticket_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_ticket`
+--
+
+LOCK TABLES `character_ticket` WRITE;
+/*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `character_tutorial`
+--
+
+DROP TABLE IF EXISTS `character_tutorial`;
+CREATE TABLE `character_tutorial` (
+ `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
+ `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
+ `tut0` int(11) unsigned NOT NULL default '0',
+ `tut1` int(11) unsigned NOT NULL default '0',
+ `tut2` int(11) unsigned NOT NULL default '0',
+ `tut3` int(11) unsigned NOT NULL default '0',
+ `tut4` int(11) unsigned NOT NULL default '0',
+ `tut5` int(11) unsigned NOT NULL default '0',
+ `tut6` int(11) unsigned NOT NULL default '0',
+ `tut7` int(11) unsigned NOT NULL default '0',
+ PRIMARY KEY (`account`,`realmid`),
+ KEY acc_key (`account`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_tutorial`
+--
+
+LOCK TABLES `character_tutorial` WRITE;
+/*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `corpse`
+--
+
+DROP TABLE IF EXISTS `corpse`;
+CREATE TABLE `corpse` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
+ `position_x` float NOT NULL default '0',
+ `position_y` float NOT NULL default '0',
+ `position_z` float NOT NULL default '0',
+ `orientation` float NOT NULL default '0',
+ `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
+ `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
+ `data` longtext,
+ `time` bigint(20) unsigned NOT NULL default '0',
+ `corpse_type` tinyint(3) unsigned NOT NULL default '0',
+ `instance` int(11) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`),
+ KEY `idx_type` (`corpse_type`),
+ KEY `instance` (`instance`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
+
+--
+-- Dumping data for table `corpse`
+--
+
+LOCK TABLES `corpse` WRITE;
+/*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
+/*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `groups`
+--
+
+DROP TABLE IF EXISTS `groups`;
+CREATE TABLE `groups` (
+ `leaderGuid` int(11) unsigned NOT NULL,
+ `mainTank` int(11) unsigned NOT NULL,
+ `mainAssistant` int(11) unsigned NOT NULL,
+ `lootMethod` tinyint(4) unsigned NOT NULL,
+ `looterGuid` int(11) unsigned NOT NULL,
+ `lootThreshold` tinyint(4) unsigned NOT NULL,
+ `icon1` int(11) unsigned NOT NULL,
+ `icon2` int(11) unsigned NOT NULL,
+ `icon3` int(11) unsigned NOT NULL,
+ `icon4` int(11) unsigned NOT NULL,
+ `icon5` int(11) unsigned NOT NULL,
+ `icon6` int(11) unsigned NOT NULL,
+ `icon7` int(11) unsigned NOT NULL,
+ `icon8` int(11) unsigned NOT NULL,
+ `isRaid` tinyint(1) unsigned NOT NULL,
+ `difficulty` tinyint(3) unsigned NOT NULL default '0',
+ PRIMARY KEY (`leaderGuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
+
+--
+-- Dumping data for table `groups`
+--
+
+LOCK TABLES `groups` WRITE;
+/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
+/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
+UNLOCK TABLES;
+
+-- ----------------------------
+-- Table structure for group_instance
+-- ----------------------------
+DROP TABLE IF EXISTS `group_instance`;
+CREATE TABLE `group_instance` (
+ `leaderGuid` int(11) unsigned NOT NULL default '0',
+ `instance` int(11) unsigned NOT NULL default '0',
+ `permanent` tinyint(1) unsigned NOT NULL default '0',
+ PRIMARY KEY (`leaderGuid`,`instance`),
+ KEY `instance` (`instance`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `group_instance`
+--
+
+LOCK TABLES `group_instance` WRITE;
+/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
+/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `group_member`
+--
+
+DROP TABLE IF EXISTS `group_member`;
+CREATE TABLE `group_member` (
+ `leaderGuid` int(11) unsigned NOT NULL,
+ `memberGuid` int(11) unsigned NOT NULL,
+ `assistant` tinyint(1) unsigned NOT NULL,
+ `subgroup` smallint(6) unsigned NOT NULL,
+ PRIMARY KEY (`leaderGuid`,`memberGuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
+
+--
+-- Dumping data for table `group_member`
+--
+
+LOCK TABLES `group_member` WRITE;
+/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
+/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `guild`
+--
+
+DROP TABLE IF EXISTS `guild`;
+CREATE TABLE `guild` (
+ `guildid` int(6) unsigned NOT NULL default '0',
+ `name` varchar(255) NOT NULL default '',
+ `leaderguid` int(6) unsigned NOT NULL default '0',
+ `EmblemStyle` int(5) NOT NULL default '0',
+ `EmblemColor` int(5) NOT NULL default '0',
+ `BorderStyle` int(5) NOT NULL default '0',
+ `BorderColor` int(5) NOT NULL default '0',
+ `BackgroundColor` int(5) NOT NULL default '0',
+ `info` text NOT NULL,
+ `motd` varchar(255) NOT NULL default '',
+ `createdate` datetime default NULL,
+ `BankMoney` bigint(20) NOT NULL default '0',
+ PRIMARY KEY (`guildid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
+
+--
+-- Dumping data for table `guild`
+--
+
+LOCK TABLES `guild` WRITE;
+/*!40000 ALTER TABLE `guild` DISABLE KEYS */;
+/*!40000 ALTER TABLE `guild` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `guild_bank_eventlog`
+--
+
+DROP TABLE IF EXISTS `guild_bank_eventlog`;
+CREATE TABLE `guild_bank_eventlog` (
+ `guildid` int(11) unsigned NOT NULL default '0',
+ `LogGuid` int(11) unsigned NOT NULL default '0',
+ `LogEntry` tinyint(1) unsigned NOT NULL default '0',
+ `TabId` tinyint(1) unsigned NOT NULL default '0',
+ `PlayerGuid` int(11) unsigned NOT NULL default '0',
+ `ItemOrMoney` int(11) unsigned NOT NULL default '0',
+ `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
+ `DestTabId` tinyint(1) unsigned NOT NULL default '0',
+ `TimeStamp` bigint(20) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guildid`,`LogGuid`),
+ KEY `guildid_key` (`guildid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `guild_bank_eventlog`
+--
+
+LOCK TABLES `guild_bank_eventlog` WRITE;
+/*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
+/*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `guild_bank_item`
+--
+
+DROP TABLE IF EXISTS `guild_bank_item`;
+CREATE TABLE `guild_bank_item` (
+ `guildid` int(11) unsigned NOT NULL default '0',
+ `TabId` tinyint(1) unsigned NOT NULL default '0',
+ `SlotId` tinyint(3) unsigned NOT NULL default '0',
+ `item_guid` int(11) unsigned NOT NULL default '0',
+ `item_entry` int(11) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guildid`,`tabid`,`slotid`),
+ KEY `guildid_key` (`guildid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `guild_bank_item`
+--
+
+LOCK TABLES `guild_bank_item` WRITE;
+/*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
+/*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `guild_bank_right`
+--
+
+DROP TABLE IF EXISTS `guild_bank_right`;
+CREATE TABLE `guild_bank_right` (
+ `guildid` int(11) unsigned NOT NULL default '0',
+ `TabId` tinyint(1) unsigned NOT NULL default '0',
+ `rid` int(11) unsigned NOT NULL default '0',
+ `gbright` tinyint(3) unsigned NOT NULL default '0',
+ `SlotPerDay` int(11) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guildid`,`TabId`,`rid`),
+ KEY `guildid_key` (`guildid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `guild_bank_right`
+--
+
+LOCK TABLES `guild_bank_right` WRITE;
+/*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
+/*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `guild_bank_tab`
+--
+
+DROP TABLE IF EXISTS `guild_bank_tab`;
+CREATE TABLE `guild_bank_tab` (
+ `guildid` int(11) unsigned NOT NULL default '0',
+ `TabId` tinyint(1) unsigned NOT NULL default '0',
+ `TabName` varchar(100) NOT NULL default '',
+ `TabIcon` varchar(100) NOT NULL default '',
+ `TabText` varchar(500) NOT NULL default '',
+ PRIMARY KEY (`guildid`,`TabId`),
+ KEY `guildid_key` (`guildid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `guild_bank_tab`
+--
+
+LOCK TABLES `guild_bank_tab` WRITE;
+/*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
+/*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `guild_eventlog`
+--
+
+DROP TABLE IF EXISTS `guild_eventlog`;
+CREATE TABLE `guild_eventlog` (
+ `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
+ `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
+ `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
+ `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
+ `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
+ `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
+ `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
+) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog';
+
+--
+-- Dumping data for table `guild_eventlog`
+--
+
+LOCK TABLES `guild_eventlog` WRITE;
+/*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
+/*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `guild_member`
+--
+
+DROP TABLE IF EXISTS `guild_member`;
+CREATE TABLE `guild_member` (
+ `guildid` int(6) unsigned NOT NULL default '0',
+ `guid` int(11) unsigned NOT NULL default '0',
+ `rank` tinyint(2) unsigned NOT NULL default '0',
+ `pnote` varchar(255) NOT NULL default '',
+ `offnote` varchar(255) NOT NULL default '',
+ `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
+ `BankRemMoney` int(11) unsigned NOT NULL default '0',
+ `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
+ `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
+ `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
+ `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
+ `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
+ `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
+ `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
+ `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
+ `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
+ `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
+ `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
+ `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
+ KEY `guildid_key` (`guildid`),
+ KEY `guildid_rank_key` (`guildid`,`rank`),
+ KEY `guid_key` (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
+
+--
+-- Dumping data for table `guild_member`
+--
+
+LOCK TABLES `guild_member` WRITE;
+/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
+/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `guild_rank`
+--
+
+DROP TABLE IF EXISTS `guild_rank`;
+CREATE TABLE `guild_rank` (
+ `guildid` int(6) unsigned NOT NULL default '0',
+ `rid` int(11) unsigned NOT NULL,
+ `rname` varchar(255) NOT NULL default '',
+ `rights` int(3) unsigned NOT NULL default '0',
+ `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guildid`,`rid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
+
+--
+-- Dumping data for table `guild_rank`
+--
+
+LOCK TABLES `guild_rank` WRITE;
+/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
+/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `instance`
+--
+
+DROP TABLE IF EXISTS `instance`;
+CREATE TABLE `instance` (
+ `id` int(11) unsigned NOT NULL default '0',
+ `map` int(11) unsigned NOT NULL default '0',
+ `resettime` bigint(40) NOT NULL default '0',
+ `difficulty` tinyint(1) unsigned NOT NULL default '0',
+ `data` longtext,
+ PRIMARY KEY (`id`),
+ KEY `map` (`map`),
+ KEY `resettime` (`resettime`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `instance`
+--
+
+LOCK TABLES `instance` WRITE;
+/*!40000 ALTER TABLE `instance` DISABLE KEYS */;
+/*!40000 ALTER TABLE `instance` ENABLE KEYS */;
+UNLOCK TABLES;
+
+-- ----------------------------
+-- Table structure for instance_reset
+-- ----------------------------
+DROP TABLE IF EXISTS `instance_reset`;
+CREATE TABLE `instance_reset` (
+ `mapid` int(11) unsigned NOT NULL default '0',
+ `resettime` bigint(40) NOT NULL default '0',
+ PRIMARY KEY (`mapid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `instance_reset`
+--
+
+LOCK TABLES `instance_reset` WRITE;
+/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
+/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `item_instance`
+--
+
+DROP TABLE IF EXISTS `item_instance`;
+CREATE TABLE `item_instance` (
+ `guid` int(11) unsigned NOT NULL default '0',
+ `owner_guid` int(11) unsigned NOT NULL default '0',
+ `data` longtext,
+ PRIMARY KEY (`guid`),
+ KEY `idx_owner_guid` (`owner_guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
+
+--
+-- Dumping data for table `item_instance`
+--
+
+LOCK TABLES `item_instance` WRITE;
+/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
+/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `item_text`
+--
+
+DROP TABLE IF EXISTS `item_text`;
+CREATE TABLE `item_text` (
+ `id` int(11) unsigned NOT NULL default '0',
+ `text` longtext,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
+
+--
+-- Dumping data for table `item_text`
+--
+
+LOCK TABLES `item_text` WRITE;
+/*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
+/*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `mail`
+--
+
+DROP TABLE IF EXISTS `mail`;
+CREATE TABLE `mail` (
+ `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
+ `messageType` tinyint(3) unsigned NOT NULL default '0',
+ `stationery` tinyint(3) NOT NULL default '41',
+ `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
+ `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
+ `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
+ `subject` longtext,
+ `itemTextId` int(11) unsigned NOT NULL default '0',
+ `has_items` tinyint(3) unsigned NOT NULL default '0',
+ `expire_time` bigint(40) NOT NULL default '0',
+ `deliver_time` bigint(40) NOT NULL default '0',
+ `money` int(11) unsigned NOT NULL default '0',
+ `cod` int(11) unsigned NOT NULL default '0',
+ `checked` tinyint(3) unsigned NOT NULL default '0',
+ PRIMARY KEY (`id`),
+ KEY `idx_receiver` (`receiver`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
+
+--
+-- Dumping data for table `mail`
+--
+
+LOCK TABLES `mail` WRITE;
+/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
+/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `mail_items`
+--
+
+DROP TABLE IF EXISTS `mail_items`;
+CREATE TABLE `mail_items` (
+ `mail_id` int(11) NOT NULL default '0',
+ `item_guid` int(11) NOT NULL default '0',
+ `item_template` int(11) NOT NULL default '0',
+ `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
+ PRIMARY KEY (`mail_id`,`item_guid`),
+ KEY `idx_receiver` (`receiver`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
+
+--
+-- Dumping data for table `mail_items`
+--
+
+LOCK TABLES `mail_items` WRITE;
+/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
+/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `pet_aura`
+--
+
+DROP TABLE IF EXISTS `pet_aura`;
+CREATE TABLE `pet_aura` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
+ `spell` int(11) unsigned NOT NULL default '0',
+ `effect_index` int(11) unsigned NOT NULL default '0',
+ `amount` int(11) NOT NULL default '0',
+ `maxduration` int(11) NOT NULL default '0',
+ `remaintime` int(11) NOT NULL default '0',
+ `remaincharges` int(11) NOT NULL default '0',
+ PRIMARY KEY (`guid`,`spell`,`effect_index`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
+
+--
+-- Dumping data for table `pet_aura`
+--
+
+LOCK TABLES `pet_aura` WRITE;
+/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `pet_spell`
+--
+
+DROP TABLE IF EXISTS `pet_spell`;
+CREATE TABLE `pet_spell` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+ `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
+ `slot` int(11) unsigned NOT NULL default '0',
+ `active` int(11) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`spell`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
+
+--
+-- Dumping data for table `pet_spell`
+--
+
+LOCK TABLES `pet_spell` WRITE;
+/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `pet_spell_cooldown`
+--
+
+DROP TABLE IF EXISTS `pet_spell_cooldown`;
+CREATE TABLE `pet_spell_cooldown` (
+ `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
+ `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
+ `time` bigint(20) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`spell`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `pet_spell_cooldown`
+--
+
+LOCK TABLES `pet_spell_cooldown` WRITE;
+/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `petition`
+--
+
+DROP TABLE IF EXISTS `petition`;
+CREATE TABLE `petition` (
+ `ownerguid` int(10) unsigned NOT NULL,
+ `petitionguid` int(10) unsigned default '0',
+ `name` varchar(255) NOT NULL default '',
+ `type` int(10) unsigned NOT NULL default '0',
+ PRIMARY KEY (`ownerguid`,`type`),
+ UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
+
+--
+-- Dumping data for table `petition`
+--
+
+LOCK TABLES `petition` WRITE;
+/*!40000 ALTER TABLE `petition` DISABLE KEYS */;
+/*!40000 ALTER TABLE `petition` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `petition_sign`
+--
+
+DROP TABLE IF EXISTS `petition_sign`;
+CREATE TABLE `petition_sign` (
+ `ownerguid` int(10) unsigned NOT NULL,
+ `petitionguid` int(11) unsigned NOT NULL default '0',
+ `playerguid` int(11) unsigned NOT NULL default '0',
+ `player_account` int(11) unsigned NOT NULL default '0',
+ `type` int(10) unsigned NOT NULL default '0',
+ PRIMARY KEY (`petitionguid`,`playerguid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
+--
+-- Dumping data for table `petition_sign`
+--
+
+LOCK TABLES `petition_sign` WRITE;
+/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
+/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `saved_variables`
+--
+DROP TABLE IF EXISTS `saved_variables`;
+CREATE TABLE `saved_variables` (
+ `NextArenaPointDistributionTime` timestamp NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
+
+--
+-- Dumping data for table `saved_variables`
+--
+
+LOCK TABLES `saved_variables` WRITE;
+/*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
+/*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!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 */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2008-01-10 11:37:06