/*
Navicat MySQL Data Transfer

Source Server         : Versus Linux
Source Server Version : 50547
Source Host           : localhost:3306
Source Database       : characters

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

Date: 2016-05-22 04:26:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `account_data`
-- ----------------------------
DROP TABLE IF EXISTS `account_data`;
CREATE TABLE `account_data` (
`accountId`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Account Identifier' ,
`type`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`data`  blob NOT NULL ,
PRIMARY KEY (`accountId`, `type`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `account_instance_times`
-- ----------------------------
DROP TABLE IF EXISTS `account_instance_times`;
CREATE TABLE `account_instance_times` (
`accountId`  int(10) UNSIGNED NOT NULL ,
`instanceId`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`releaseTime`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`accountId`, `instanceId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `account_tutorial`
-- ----------------------------
DROP TABLE IF EXISTS `account_tutorial`;
CREATE TABLE `account_tutorial` (
`accountId`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Account Identifier' ,
`tut0`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tut1`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tut2`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tut3`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tut4`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tut5`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tut6`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tut7`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`accountId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `addons`
-- ----------------------------
DROP TABLE IF EXISTS `addons`;
CREATE TABLE `addons` (
`name`  varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`crc`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`name`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Addons'

;

-- ----------------------------
-- Table structure for `arena_team`
-- ----------------------------
DROP TABLE IF EXISTS `arena_team`;
CREATE TABLE `arena_team` (
`arenaTeamId`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`name`  varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`captainGuid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`rating`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`seasonGames`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`seasonWins`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`weekGames`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`weekWins`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`rank`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`backgroundColor`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`emblemStyle`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`emblemColor`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`borderStyle`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`borderColor`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`arenaTeamId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `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 ,
`weekGames`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`weekWins`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`seasonGames`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`seasonWins`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`personalRating`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`arenaTeamId`, `guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `armory_achievement`
-- ----------------------------
DROP TABLE IF EXISTS `armory_achievement`;
CREATE TABLE `armory_achievement` (
`id`  int(11) NOT NULL ,
`factionFlag`  int(11) NOT NULL ,
`parentAchievement`  int(11) NOT NULL ,
`name_de_de`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name_zh_cn`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name_en_gb`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name_es_es`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name_fr_fr`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name_ru_ru`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description_de_de`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description_zh_cn`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description_en_gb`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description_es_es`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description_fr_fr`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description_ru_ru`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`categoryId`  smallint(6) NOT NULL ,
`points`  smallint(2) NOT NULL ,
`OrderInCategory`  smallint(6) NOT NULL ,
`flags`  mediumint(9) NOT NULL ,
`iconID`  int(11) NOT NULL ,
`iconname`  varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`titleReward_de_de`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`titleReward_zh_cn`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`titleReward_en_gb`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`titleReward_es_es`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`titleReward_fr_fr`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`titleReward_ru_ru`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dungeonDifficulty`  smallint(1) NOT NULL DEFAULT '-1' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Achievements table'

;

-- ----------------------------
-- Table structure for `auctionhouse`
-- ----------------------------
DROP TABLE IF EXISTS `auctionhouse`;
CREATE TABLE `auctionhouse` (
`id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`houseid`  tinyint(3) UNSIGNED NOT NULL DEFAULT 7 ,
`itemguid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`itemowner`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`buyoutprice`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`buyguid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lastbid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`startbid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`deposit`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`),
UNIQUE INDEX `item_guid` (`itemguid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `banned_addons`
-- ----------------------------
DROP TABLE IF EXISTS `banned_addons`;
CREATE TABLE `banned_addons` (
`Id`  int(10) UNSIGNED NOT NULL ,
`Name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`Version`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`Timestamp`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
PRIMARY KEY (`Id`),
UNIQUE INDEX `idx_name_ver` (`Name`, `Version`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `battleground_deserters`
-- ----------------------------
DROP TABLE IF EXISTS `battleground_deserters`;
CREATE TABLE `battleground_deserters` (
`guid`  int(10) UNSIGNED NOT NULL COMMENT 'characters.guid' ,
`type`  tinyint(3) UNSIGNED NOT NULL COMMENT 'type of the desertion' ,
`datetime`  datetime NOT NULL COMMENT 'datetime of the desertion' 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `bugreport`
-- ----------------------------
DROP TABLE IF EXISTS `bugreport`;
CREATE TABLE `bugreport` (
`id`  int(10) UNSIGNED NOT NULL COMMENT 'Identifier' ,
`type`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`content`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Debug System'

;

-- ----------------------------
-- Table structure for `calendar_events`
-- ----------------------------
DROP TABLE IF EXISTS `calendar_events`;
CREATE TABLE `calendar_events` (
`id`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
`creator`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`title`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`description`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type`  tinyint(1) UNSIGNED NOT NULL DEFAULT 4 ,
`dungeon`  int(10) NOT NULL DEFAULT '-1' ,
`eventtime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`flags`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`time2`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `calendar_invites`
-- ----------------------------
DROP TABLE IF EXISTS `calendar_invites`;
CREATE TABLE `calendar_invites` (
`id`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
`event`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
`invitee`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`sender`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`status`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 ,
`statustime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`rank`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 ,
`text`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `channels`
-- ----------------------------
DROP TABLE IF EXISTS `channels`;
CREATE TABLE `channels` (
`name`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`team`  int(10) UNSIGNED NOT NULL ,
`announce`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 ,
`ownership`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 ,
`password`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`bannedList`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`lastUsed`  int(10) UNSIGNED NOT NULL ,
PRIMARY KEY (`name`, `team`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Channel System'

;

-- ----------------------------
-- Table structure for `character_account_data`
-- ----------------------------
DROP TABLE IF EXISTS `character_account_data`;
CREATE TABLE `character_account_data` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`data`  blob NOT NULL ,
PRIMARY KEY (`guid`, `type`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_achievement`
-- ----------------------------
DROP TABLE IF EXISTS `character_achievement`;
CREATE TABLE `character_achievement` (
`guid`  int(10) UNSIGNED NOT NULL ,
`achievement`  smallint(5) UNSIGNED NOT NULL ,
`date`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `achievement`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_achievement_progress`
-- ----------------------------
DROP TABLE IF EXISTS `character_achievement_progress`;
CREATE TABLE `character_achievement_progress` (
`guid`  int(10) UNSIGNED NOT NULL ,
`criteria`  smallint(5) UNSIGNED NOT NULL ,
`counter`  int(10) UNSIGNED NOT NULL ,
`date`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `criteria`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_action`
-- ----------------------------
DROP TABLE IF EXISTS `character_action`;
CREATE TABLE `character_action` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`spec`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`button`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`action`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `spec`, `button`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_arena_stats`
-- ----------------------------
DROP TABLE IF EXISTS `character_arena_stats`;
CREATE TABLE `character_arena_stats` (
`guid`  int(10) NOT NULL ,
`slot`  tinyint(3) NOT NULL ,
`matchMakerRating`  smallint(5) NOT NULL ,
PRIMARY KEY (`guid`, `slot`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_aura`
-- ----------------------------
DROP TABLE IF EXISTS `character_aura`;
CREATE TABLE `character_aura` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`casterGuid`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Full Global Unique Identifier' ,
`itemGuid`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
`spell`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`effectMask`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`recalculateMask`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`stackCount`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 ,
`amount0`  int(11) NOT NULL DEFAULT 0 ,
`amount1`  int(11) NOT NULL DEFAULT 0 ,
`amount2`  int(11) NOT NULL DEFAULT 0 ,
`base_amount0`  int(11) NOT NULL DEFAULT 0 ,
`base_amount1`  int(11) NOT NULL DEFAULT 0 ,
`base_amount2`  int(11) NOT NULL DEFAULT 0 ,
`maxDuration`  int(11) NOT NULL DEFAULT 0 ,
`remainTime`  int(11) NOT NULL DEFAULT 0 ,
`remainCharges`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `casterGuid`, `itemGuid`, `spell`, `effectMask`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_banned`
-- ----------------------------
DROP TABLE IF EXISTS `character_banned`;
CREATE TABLE `character_banned` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`bandate`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`unbandate`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`bannedby`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`banreason`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`active`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 ,
PRIMARY KEY (`guid`, `bandate`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Ban List'

;

-- ----------------------------
-- Table structure for `character_battleground_data`
-- ----------------------------
DROP TABLE IF EXISTS `character_battleground_data`;
CREATE TABLE `character_battleground_data` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`instanceId`  int(10) UNSIGNED NOT NULL COMMENT 'Instance Identifier' ,
`team`  smallint(5) UNSIGNED NOT NULL ,
`joinX`  float NOT NULL DEFAULT 0 ,
`joinY`  float NOT NULL DEFAULT 0 ,
`joinZ`  float NOT NULL DEFAULT 0 ,
`joinO`  float NOT NULL DEFAULT 0 ,
`joinMapId`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Map Identifier' ,
`taxiStart`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`taxiEnd`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`mountSpell`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_battleground_random`
-- ----------------------------
DROP TABLE IF EXISTS `character_battleground_random`;
CREATE TABLE `character_battleground_random` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_declinedname`
-- ----------------------------
DROP TABLE IF EXISTS `character_declinedname`;
CREATE TABLE `character_declinedname` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`genitive`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dative`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`accusative`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`instrumental`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`prepositional`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_equipmentsets`
-- ----------------------------
DROP TABLE IF EXISTS `character_equipmentsets`;
CREATE TABLE `character_equipmentsets` (
`guid`  int(10) NOT NULL DEFAULT 0 ,
`setguid`  bigint(20) NOT NULL ,
`setindex`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`name`  varchar(31) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`iconname`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`ignore_mask`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item0`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item1`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item2`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item3`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item4`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item5`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item6`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item7`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item8`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item9`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item10`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item11`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item12`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item13`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item14`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item15`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item16`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item17`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item18`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`setguid`),
UNIQUE INDEX `idx_set` (`guid`, `setguid`, `setindex`) USING BTREE ,
INDEX `Idx_setindex` (`setindex`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_gifts`
-- ----------------------------
DROP TABLE IF EXISTS `character_gifts`;
CREATE TABLE `character_gifts` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`item_guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`entry`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`flags`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`item_guid`),
INDEX `idx_guid` (`guid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_glyphs`
-- ----------------------------
DROP TABLE IF EXISTS `character_glyphs`;
CREATE TABLE `character_glyphs` (
`guid`  int(10) UNSIGNED NOT NULL ,
`talentGroup`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`glyph1`  smallint(5) UNSIGNED NULL DEFAULT 0 ,
`glyph2`  smallint(5) UNSIGNED NULL DEFAULT 0 ,
`glyph3`  smallint(5) UNSIGNED NULL DEFAULT 0 ,
`glyph4`  smallint(5) UNSIGNED NULL DEFAULT 0 ,
`glyph5`  smallint(5) UNSIGNED NULL DEFAULT 0 ,
`glyph6`  smallint(5) UNSIGNED NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `talentGroup`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_homebind`
-- ----------------------------
DROP TABLE IF EXISTS `character_homebind`;
CREATE TABLE `character_homebind` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`mapId`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Map Identifier' ,
`zoneId`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Zone Identifier' ,
`posX`  float NOT NULL DEFAULT 0 ,
`posY`  float NOT NULL DEFAULT 0 ,
`posZ`  float NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_instance`
-- ----------------------------
DROP TABLE IF EXISTS `character_instance`;
CREATE TABLE `character_instance` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`instance`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`permanent`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `instance`),
INDEX `instance` (`instance`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_inventory`
-- ----------------------------
DROP TABLE IF EXISTS `character_inventory`;
CREATE TABLE `character_inventory` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`bag`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`slot`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`item`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Item Global Unique Identifier' ,
PRIMARY KEY (`item`),
UNIQUE INDEX `guid` (`guid`, `bag`, `slot`) USING BTREE ,
INDEX `idx_guid` (`guid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_pet`
-- ----------------------------
DROP TABLE IF EXISTS `character_pet`;
CREATE TABLE `character_pet` (
`id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`entry`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`owner`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`modelid`  int(10) UNSIGNED NULL DEFAULT 0 ,
`CreatedBySpell`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`PetType`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`level`  smallint(5) UNSIGNED NOT NULL DEFAULT 1 ,
`exp`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`Reactstate`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`name`  varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Pet' ,
`renamed`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`slot`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`curhealth`  int(10) UNSIGNED NOT NULL DEFAULT 1 ,
`curmana`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`curhappiness`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`savetime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`abdata`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`id`),
INDEX `owner` (`owner`) USING BTREE ,
INDEX `idx_slot` (`slot`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Pet System'

;

-- ----------------------------
-- Table structure for `character_pet_declinedname`
-- ----------------------------
DROP TABLE IF EXISTS `character_pet_declinedname`;
CREATE TABLE `character_pet_declinedname` (
`id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`owner`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`genitive`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dative`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`accusative`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`instrumental`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`prepositional`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`),
INDEX `owner_key` (`owner`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_queststatus`
-- ----------------------------
DROP TABLE IF EXISTS `character_queststatus`;
CREATE TABLE `character_queststatus` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`quest`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quest Identifier' ,
`status`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`explored`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`timer`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`mobcount1`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`mobcount2`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`mobcount3`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`mobcount4`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`itemcount1`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`itemcount2`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`itemcount3`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`itemcount4`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`playercount`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `quest`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_queststatus_daily`
-- ----------------------------
DROP TABLE IF EXISTS `character_queststatus_daily`;
CREATE TABLE `character_queststatus_daily` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`quest`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quest Identifier' ,
`time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `quest`),
INDEX `idx_guid` (`guid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_queststatus_monthly`
-- ----------------------------
DROP TABLE IF EXISTS `character_queststatus_monthly`;
CREATE TABLE `character_queststatus_monthly` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`quest`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quest Identifier' ,
PRIMARY KEY (`guid`, `quest`),
INDEX `idx_guid` (`guid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_queststatus_rewarded`
-- ----------------------------
DROP TABLE IF EXISTS `character_queststatus_rewarded`;
CREATE TABLE `character_queststatus_rewarded` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`quest`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quest Identifier' ,
`active`  tinyint(10) UNSIGNED NOT NULL DEFAULT 1 ,
PRIMARY KEY (`guid`, `quest`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_queststatus_seasonal`
-- ----------------------------
DROP TABLE IF EXISTS `character_queststatus_seasonal`;
CREATE TABLE `character_queststatus_seasonal` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`quest`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quest Identifier' ,
`event`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Event Identifier' ,
PRIMARY KEY (`guid`, `quest`),
INDEX `idx_guid` (`guid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_queststatus_weekly`
-- ----------------------------
DROP TABLE IF EXISTS `character_queststatus_weekly`;
CREATE TABLE `character_queststatus_weekly` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`quest`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quest Identifier' ,
PRIMARY KEY (`guid`, `quest`),
INDEX `idx_guid` (`guid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_reputation`
-- ----------------------------
DROP TABLE IF EXISTS `character_reputation`;
CREATE TABLE `character_reputation` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`faction`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`standing`  int(11) NOT NULL DEFAULT 0 ,
`flags`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `faction`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_skills`
-- ----------------------------
DROP TABLE IF EXISTS `character_skills`;
CREATE TABLE `character_skills` (
`guid`  int(10) UNSIGNED NOT NULL COMMENT 'Global Unique Identifier' ,
`skill`  smallint(5) UNSIGNED NOT NULL ,
`value`  smallint(5) UNSIGNED NOT NULL ,
`max`  smallint(5) UNSIGNED NOT NULL ,
PRIMARY KEY (`guid`, `skill`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_social`
-- ----------------------------
DROP TABLE IF EXISTS `character_social`;
CREATE TABLE `character_social` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier' ,
`friend`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Friend Global Unique Identifier' ,
`flags`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Friend Flags' ,
`note`  varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Friend Note' ,
PRIMARY KEY (`guid`, `friend`, `flags`),
INDEX `friend` (`friend`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_spell`
-- ----------------------------
DROP TABLE IF EXISTS `character_spell`;
CREATE TABLE `character_spell` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`spell`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Spell Identifier' ,
`active`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 ,
`disabled`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `spell`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `character_spell_cooldown`
-- ----------------------------
DROP TABLE IF EXISTS `character_spell_cooldown`;
CREATE TABLE `character_spell_cooldown` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part' ,
`spell`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Spell Identifier' ,
`item`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Item Identifier' ,
`time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`categoryId`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Spell category Id' ,
`categoryEnd`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `spell`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_stats`
-- ----------------------------
DROP TABLE IF EXISTS `character_stats`;
CREATE TABLE `character_stats` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part' ,
`maxhealth`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`maxpower1`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`maxpower2`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`maxpower3`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`maxpower4`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`maxpower5`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`maxpower6`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`maxpower7`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`strength`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`agility`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`stamina`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`intellect`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`spirit`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`armor`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`resHoly`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`resFire`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`resNature`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`resFrost`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`resShadow`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`resArcane`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`blockPct`  float UNSIGNED NOT NULL DEFAULT 0 ,
`dodgePct`  float UNSIGNED NOT NULL DEFAULT 0 ,
`parryPct`  float UNSIGNED NOT NULL DEFAULT 0 ,
`critPct`  float UNSIGNED NOT NULL DEFAULT 0 ,
`rangedCritPct`  float UNSIGNED NOT NULL DEFAULT 0 ,
`spellCritPct`  float UNSIGNED NOT NULL DEFAULT 0 ,
`attackPower`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`rangedAttackPower`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`spellPower`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`resilience`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `character_talent`
-- ----------------------------
DROP TABLE IF EXISTS `character_talent`;
CREATE TABLE `character_talent` (
`guid`  int(10) UNSIGNED NOT NULL ,
`spell`  mediumint(8) UNSIGNED NOT NULL ,
`talentGroup`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `spell`, `talentGroup`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `characters`
-- ----------------------------
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`account`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Account Identifier' ,
`name`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`race`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`class`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`gender`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`level`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`xp`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`money`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`playerBytes`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`playerBytes2`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`playerFlags`  int(10) 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`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Map Identifier' ,
`instance_id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`instance_mode_mask`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`orientation`  float NOT NULL DEFAULT 0 ,
`taximask`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`online`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`cinematic`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`totaltime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`leveltime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`logout_time`  int(10) 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(10) UNSIGNED NOT NULL DEFAULT 0 ,
`resettalents_time`  int(10) 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`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`extra_flags`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`stable_slots`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`at_login`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`zone`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`death_expire_time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`taxi_path`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`arenaPoints`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`totalHonorPoints`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`todayHonorPoints`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`yesterdayHonorPoints`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`totalKills`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`todayKills`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`yesterdayKills`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`chosenTitle`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`knownCurrencies`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
`watchedFaction`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`drunk`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`health`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`power1`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`power2`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`power3`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`power4`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`power5`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`power6`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`power7`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`latency`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`talentGroupsCount`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 ,
`activeTalentGroup`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`exploredZones`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`equipmentCache`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`ammoId`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`knownTitles`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`actionBars`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`grantableLevels`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`deleteInfos_Account`  int(10) UNSIGNED NULL DEFAULT NULL ,
`deleteInfos_Name`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`deleteDate`  int(10) UNSIGNED NULL DEFAULT NULL ,
`XPRate`  int(10) NOT NULL DEFAULT 3 ,
PRIMARY KEY (`guid`),
INDEX `idx_account` (`account`) USING BTREE ,
INDEX `idx_online` (`online`) USING BTREE ,
INDEX `idx_name` (`name`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `corpse`
-- ----------------------------
DROP TABLE IF EXISTS `corpse`;
CREATE TABLE `corpse` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier' ,
`posX`  float NOT NULL DEFAULT 0 ,
`posY`  float NOT NULL DEFAULT 0 ,
`posZ`  float NOT NULL DEFAULT 0 ,
`orientation`  float NOT NULL DEFAULT 0 ,
`mapId`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Map Identifier' ,
`phaseMask`  int(10) UNSIGNED NOT NULL DEFAULT 1 ,
`displayId`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`itemCache`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`bytes1`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`bytes2`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`guildId`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`flags`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`dynFlags`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`corpseType`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`instanceId`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Instance Identifier' ,
PRIMARY KEY (`guid`),
INDEX `idx_type` (`corpseType`) USING BTREE ,
INDEX `idx_instance` (`instanceId`) USING BTREE ,
INDEX `idx_time` (`time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Death System'

;

-- ----------------------------
-- Table structure for `creature_respawn`
-- ----------------------------
DROP TABLE IF EXISTS `creature_respawn`;
CREATE TABLE `creature_respawn` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`respawnTime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`mapId`  smallint(10) UNSIGNED NOT NULL DEFAULT 0 ,
`instanceId`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Instance Identifier' ,
PRIMARY KEY (`guid`, `instanceId`),
INDEX `idx_instance` (`instanceId`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Grid Loading System'

;

-- ----------------------------
-- Table structure for `custom_transmogrification`
-- ----------------------------
DROP TABLE IF EXISTS `custom_transmogrification`;
CREATE TABLE `custom_transmogrification` (
`GUID`  int(10) UNSIGNED NOT NULL COMMENT 'Item guidLow' ,
`FakeEntry`  int(10) UNSIGNED NOT NULL COMMENT 'Item entry' ,
`Owner`  int(10) UNSIGNED NOT NULL COMMENT 'Player guidLow' ,
PRIMARY KEY (`GUID`),
INDEX `Owner` (`Owner`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='6_2'

;

-- ----------------------------
-- Table structure for `custom_transmogrification_sets`
-- ----------------------------
DROP TABLE IF EXISTS `custom_transmogrification_sets`;
CREATE TABLE `custom_transmogrification_sets` (
`Owner`  int(10) UNSIGNED NOT NULL COMMENT 'Player guidlow' ,
`PresetID`  tinyint(3) UNSIGNED NOT NULL COMMENT 'Preset identifier' ,
`SetName`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'SetName' ,
`SetData`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'Slot1 Entry1 Slot2 Entry2' ,
PRIMARY KEY (`Owner`, `PresetID`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='6_1'

;

-- ----------------------------
-- Table structure for `game_event_condition_save`
-- ----------------------------
DROP TABLE IF EXISTS `game_event_condition_save`;
CREATE TABLE `game_event_condition_save` (
`eventEntry`  tinyint(3) UNSIGNED NOT NULL ,
`condition_id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`done`  float NULL DEFAULT 0 ,
PRIMARY KEY (`eventEntry`, `condition_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `game_event_save`
-- ----------------------------
DROP TABLE IF EXISTS `game_event_save`;
CREATE TABLE `game_event_save` (
`eventEntry`  tinyint(3) UNSIGNED NOT NULL ,
`state`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 ,
`next_start`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`eventEntry`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `gameobject_respawn`
-- ----------------------------
DROP TABLE IF EXISTS `gameobject_respawn`;
CREATE TABLE `gameobject_respawn` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`respawnTime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`mapId`  smallint(10) UNSIGNED NOT NULL DEFAULT 0 ,
`instanceId`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Instance Identifier' ,
PRIMARY KEY (`guid`, `instanceId`),
INDEX `idx_instance` (`instanceId`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Grid Loading System'

;

-- ----------------------------
-- Table structure for `gm_subsurvey`
-- ----------------------------
DROP TABLE IF EXISTS `gm_subsurvey`;
CREATE TABLE `gm_subsurvey` (
`surveyId`  int(10) UNSIGNED NOT NULL ,
`questionId`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`answer`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`answerComment`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`surveyId`, `questionId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `gm_survey`
-- ----------------------------
DROP TABLE IF EXISTS `gm_survey`;
CREATE TABLE `gm_survey` (
`surveyId`  int(10) UNSIGNED NOT NULL ,
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`mainSurvey`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`comment`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`createTime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`surveyId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `gm_ticket`
-- ----------------------------
DROP TABLE IF EXISTS `gm_ticket`;
CREATE TABLE `gm_ticket` (
`id`  int(10) UNSIGNED NOT NULL ,
`type`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 open, 1 closed, 2 character deleted' ,
`playerGuid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier of ticket creator' ,
`name`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Name of ticket creator' ,
`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`createTime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`mapId`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`posX`  float NOT NULL DEFAULT 0 ,
`posY`  float NOT NULL DEFAULT 0 ,
`posZ`  float NOT NULL DEFAULT 0 ,
`lastModifiedTime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`closedBy`  int(10) NOT NULL DEFAULT 0 ,
`assignedTo`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'GUID of admin to whom ticket is assigned' ,
`comment`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`response`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`completed`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`escalated`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`viewed`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`needMoreHelp`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`resolvedBy`  int(10) NOT NULL DEFAULT 0 COMMENT 'GUID of GM who resolved the ticket' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `group_instance`
-- ----------------------------
DROP TABLE IF EXISTS `group_instance`;
CREATE TABLE `group_instance` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`instance`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`permanent`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `instance`),
INDEX `instance` (`instance`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `group_member`
-- ----------------------------
DROP TABLE IF EXISTS `group_member`;
CREATE TABLE `group_member` (
`guid`  int(10) UNSIGNED NOT NULL ,
`memberGuid`  int(10) UNSIGNED NOT NULL ,
`memberFlags`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`subgroup`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`roles`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`memberGuid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Groups'

;

-- ----------------------------
-- Table structure for `groups`
-- ----------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
`guid`  int(10) UNSIGNED NOT NULL ,
`leaderGuid`  int(10) UNSIGNED NOT NULL ,
`lootMethod`  tinyint(3) UNSIGNED NOT NULL ,
`looterGuid`  int(10) UNSIGNED NOT NULL ,
`lootThreshold`  tinyint(3) UNSIGNED NOT NULL ,
`icon1`  bigint(20) UNSIGNED NOT NULL ,
`icon2`  bigint(20) UNSIGNED NOT NULL ,
`icon3`  bigint(20) UNSIGNED NOT NULL ,
`icon4`  bigint(20) UNSIGNED NOT NULL ,
`icon5`  bigint(20) UNSIGNED NOT NULL ,
`icon6`  bigint(20) UNSIGNED NOT NULL ,
`icon7`  bigint(20) UNSIGNED NOT NULL ,
`icon8`  bigint(20) UNSIGNED NOT NULL ,
`groupType`  tinyint(3) UNSIGNED NOT NULL ,
`difficulty`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`raidDifficulty`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`masterLooterGuid`  int(10) UNSIGNED NOT NULL ,
PRIMARY KEY (`guid`),
INDEX `leaderGuid` (`leaderGuid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Groups'

;

-- ----------------------------
-- Table structure for `guild`
-- ----------------------------
DROP TABLE IF EXISTS `guild`;
CREATE TABLE `guild` (
`guildid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`name`  varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`leaderguid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`EmblemStyle`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`EmblemColor`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`BorderStyle`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`BorderColor`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`BackgroundColor`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`info`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`motd`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`createdate`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`BankMoney`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guildid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Guild System'

;

-- ----------------------------
-- Table structure for `guild_bank_eventlog`
-- ----------------------------
DROP TABLE IF EXISTS `guild_bank_eventlog`;
CREATE TABLE `guild_bank_eventlog` (
`guildid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Guild Identificator' ,
`LogGuid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Log record identificator - auxiliary column' ,
`TabId`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Guild bank TabId' ,
`EventType`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Event type' ,
`PlayerGuid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`ItemOrMoney`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`ItemStackCount`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`DestTabId`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Destination Tab Id' ,
`TimeStamp`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Event UNIX time' ,
PRIMARY KEY (`guildid`, `LogGuid`, `TabId`),
INDEX `guildid_key` (`guildid`) USING BTREE ,
INDEX `Idx_PlayerGuid` (`PlayerGuid`) USING BTREE ,
INDEX `Idx_LogGuid` (`LogGuid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `guild_bank_item`
-- ----------------------------
DROP TABLE IF EXISTS `guild_bank_item`;
CREATE TABLE `guild_bank_item` (
`guildid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`TabId`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`SlotId`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`item_guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guildid`, `TabId`, `SlotId`),
INDEX `guildid_key` (`guildid`) USING BTREE ,
INDEX `Idx_item_guid` (`item_guid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `guild_bank_right`
-- ----------------------------
DROP TABLE IF EXISTS `guild_bank_right`;
CREATE TABLE `guild_bank_right` (
`guildid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`TabId`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`rid`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`gbright`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`SlotPerDay`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guildid`, `TabId`, `rid`),
INDEX `guildid_key` (`guildid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `guild_bank_tab`
-- ----------------------------
DROP TABLE IF EXISTS `guild_bank_tab`;
CREATE TABLE `guild_bank_tab` (
`guildid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`TabId`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`TabName`  varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`TabIcon`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`TabText`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`guildid`, `TabId`),
INDEX `guildid_key` (`guildid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `guild_eventlog`
-- ----------------------------
DROP TABLE IF EXISTS `guild_eventlog`;
CREATE TABLE `guild_eventlog` (
`guildid`  int(10) UNSIGNED NOT NULL COMMENT 'Guild Identificator' ,
`LogGuid`  int(10) UNSIGNED NOT NULL COMMENT 'Log record identificator - auxiliary column' ,
`EventType`  tinyint(3) UNSIGNED NOT NULL COMMENT 'Event type' ,
`PlayerGuid1`  int(10) UNSIGNED NOT NULL COMMENT 'Player 1' ,
`PlayerGuid2`  int(10) UNSIGNED NOT NULL COMMENT 'Player 2' ,
`NewRank`  tinyint(3) UNSIGNED NOT NULL COMMENT 'New rank(in case promotion/demotion)' ,
`TimeStamp`  int(10) UNSIGNED NOT NULL COMMENT 'Event UNIX time' ,
PRIMARY KEY (`guildid`, `LogGuid`),
INDEX `Idx_PlayerGuid1` (`PlayerGuid1`) USING BTREE ,
INDEX `Idx_PlayerGuid2` (`PlayerGuid2`) USING BTREE ,
INDEX `Idx_LogGuid` (`LogGuid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Guild Eventlog'

;

-- ----------------------------
-- Table structure for `guild_member`
-- ----------------------------
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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`offnote`  varchar(31) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
UNIQUE INDEX `guid_key` (`guid`) USING BTREE ,
INDEX `guildid_key` (`guildid`) USING BTREE ,
INDEX `guildid_rank_key` (`guildid`, `rank`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Guild System'

;

-- ----------------------------
-- Table structure for `guild_member_withdraw`
-- ----------------------------
DROP TABLE IF EXISTS `guild_member_withdraw`;
CREATE TABLE `guild_member_withdraw` (
`guid`  int(10) UNSIGNED NOT NULL ,
`tab0`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tab1`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tab2`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tab3`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tab4`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tab5`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`money`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Guild Member Daily Withdraws'

;

-- ----------------------------
-- Table structure for `guild_rank`
-- ----------------------------
DROP TABLE IF EXISTS `guild_rank`;
CREATE TABLE `guild_rank` (
`guildid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`rid`  tinyint(3) UNSIGNED NOT NULL ,
`rname`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`rights`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`BankMoneyPerDay`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guildid`, `rid`),
INDEX `Idx_rid` (`rid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Guild System'

;

-- ----------------------------
-- Table structure for `instance`
-- ----------------------------
DROP TABLE IF EXISTS `instance`;
CREATE TABLE `instance` (
`id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`map`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`resettime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`difficulty`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`completedEncounters`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`data`  tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
INDEX `map` (`map`) USING BTREE ,
INDEX `resettime` (`resettime`) USING BTREE ,
INDEX `difficulty` (`difficulty`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `instance_reset`
-- ----------------------------
DROP TABLE IF EXISTS `instance_reset`;
CREATE TABLE `instance_reset` (
`mapid`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`difficulty`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`resettime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`mapid`, `difficulty`),
INDEX `difficulty` (`difficulty`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `item_instance`
-- ----------------------------
DROP TABLE IF EXISTS `item_instance`;
CREATE TABLE `item_instance` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`itemEntry`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`owner_guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`creatorGuid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`giftCreatorGuid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`count`  int(10) UNSIGNED NOT NULL DEFAULT 1 ,
`duration`  int(10) NOT NULL DEFAULT 0 ,
`charges`  tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`flags`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`enchantments`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`randomPropertyId`  smallint(5) NOT NULL DEFAULT 0 ,
`durability`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`playedTime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`text`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`guid`),
INDEX `idx_owner_guid` (`owner_guid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Item System'

;

-- ----------------------------
-- Table structure for `item_loot_items`
-- ----------------------------
DROP TABLE IF EXISTS `item_loot_items`;
CREATE TABLE `item_loot_items` (
`container_id`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'guid of container (item_instance.guid)' ,
`item_id`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'loot item entry (item_instance.itemEntry)' ,
`item_count`  int(10) NOT NULL DEFAULT 0 COMMENT 'stack size' ,
`follow_rules`  tinyint(1) NOT NULL DEFAULT 0 COMMENT 'follow loot rules' ,
`ffa`  tinyint(1) NOT NULL DEFAULT 0 COMMENT 'free-for-all' ,
`blocked`  tinyint(1) NOT NULL DEFAULT 0 ,
`counted`  tinyint(1) NOT NULL DEFAULT 0 ,
`under_threshold`  tinyint(1) NOT NULL DEFAULT 0 ,
`needs_quest`  tinyint(1) NOT NULL DEFAULT 0 COMMENT 'quest drop' ,
`rnd_prop`  int(10) NOT NULL DEFAULT 0 COMMENT 'random enchantment added when originally rolled' ,
`rnd_suffix`  int(10) NOT NULL DEFAULT 0 COMMENT 'random suffix added when originally rolled' 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `item_loot_money`
-- ----------------------------
DROP TABLE IF EXISTS `item_loot_money`;
CREATE TABLE `item_loot_money` (
`container_id`  int(10) NOT NULL DEFAULT 0 COMMENT 'guid of container (item_instance.guid)' ,
`money`  int(10) NOT NULL DEFAULT 0 COMMENT 'money loot (in copper)' 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `item_refund_instance`
-- ----------------------------
DROP TABLE IF EXISTS `item_refund_instance`;
CREATE TABLE `item_refund_instance` (
`item_guid`  int(10) UNSIGNED NOT NULL COMMENT 'Item GUID' ,
`player_guid`  int(10) UNSIGNED NOT NULL COMMENT 'Player GUID' ,
`paidMoney`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`paidExtendedCost`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`item_guid`, `player_guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Item Refund System'

;

-- ----------------------------
-- Table structure for `item_soulbound_trade_data`
-- ----------------------------
DROP TABLE IF EXISTS `item_soulbound_trade_data`;
CREATE TABLE `item_soulbound_trade_data` (
`itemGuid`  int(10) UNSIGNED NOT NULL COMMENT 'Item GUID' ,
`allowedPlayers`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade' ,
PRIMARY KEY (`itemGuid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Item Refund System'

;

-- ----------------------------
-- Table structure for `lag_reports`
-- ----------------------------
DROP TABLE IF EXISTS `lag_reports`;
CREATE TABLE `lag_reports` (
`reportId`  int(10) UNSIGNED NOT NULL ,
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lagType`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`mapId`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`posX`  float NOT NULL DEFAULT 0 ,
`posY`  float NOT NULL DEFAULT 0 ,
`posZ`  float NOT NULL DEFAULT 0 ,
`latency`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`createTime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`reportId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player System'

;

-- ----------------------------
-- Table structure for `lfg_data`
-- ----------------------------
DROP TABLE IF EXISTS `lfg_data`;
CREATE TABLE `lfg_data` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`dungeon`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`state`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='LFG Data'

;

-- ----------------------------
-- Table structure for `link_recup`
-- ----------------------------
DROP TABLE IF EXISTS `link_recup`;
CREATE TABLE `link_recup` (
`guid`  int(11) NOT NULL ,
`type`  int(11) NOT NULL ,
`subtype`  int(11) NOT NULL ,
`numparam`  bigint(20) NOT NULL ,
`txtparam`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`guid`, `type`, `subtype`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `lottery`
-- ----------------------------
DROP TABLE IF EXISTS `lottery`;
CREATE TABLE `lottery` (
`guid`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`accountid`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`registertime`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
`faction`  int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`ip`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`accountid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `mail`
-- ----------------------------
DROP TABLE IF EXISTS `mail`;
CREATE TABLE `mail` (
`id`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Identifier' ,
`messageType`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`stationery`  tinyint(3) NOT NULL DEFAULT 41 ,
`mailTemplateId`  smallint(5) UNSIGNED NOT NULL DEFAULT 0 ,
`sender`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier' ,
`receiver`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier' ,
`subject`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`body`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`has_items`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`expire_time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`deliver_time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`money`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`cod`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`checked`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`),
INDEX `idx_receiver` (`receiver`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Mail System'

;

-- ----------------------------
-- Table structure for `mail_items`
-- ----------------------------
DROP TABLE IF EXISTS `mail_items`;
CREATE TABLE `mail_items` (
`mail_id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`item_guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`receiver`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier' ,
PRIMARY KEY (`item_guid`),
INDEX `idx_receiver` (`receiver`) USING BTREE ,
INDEX `idx_mail_id` (`mail_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `pet_aura`
-- ----------------------------
DROP TABLE IF EXISTS `pet_aura`;
CREATE TABLE `pet_aura` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`casterGuid`  bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Full Global Unique Identifier' ,
`spell`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`effectMask`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`recalculateMask`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`stackCount`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 ,
`amount0`  mediumint(8) NOT NULL ,
`amount1`  mediumint(8) NOT NULL ,
`amount2`  mediumint(8) NOT NULL ,
`base_amount0`  mediumint(8) NOT NULL ,
`base_amount1`  mediumint(8) NOT NULL ,
`base_amount2`  mediumint(8) NOT NULL ,
`maxDuration`  int(11) NOT NULL DEFAULT 0 ,
`remainTime`  int(11) NOT NULL DEFAULT 0 ,
`remainCharges`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `casterGuid`, `spell`, `effectMask`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Pet System'

;

-- ----------------------------
-- Table structure for `pet_spell`
-- ----------------------------
DROP TABLE IF EXISTS `pet_spell`;
CREATE TABLE `pet_spell` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
`spell`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Spell Identifier' ,
`active`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `spell`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Pet System'

;

-- ----------------------------
-- Table structure for `pet_spell_cooldown`
-- ----------------------------
DROP TABLE IF EXISTS `pet_spell_cooldown`;
CREATE TABLE `pet_spell_cooldown` (
`guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part' ,
`spell`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Spell Identifier' ,
`time`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`categoryId`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Spell category Id' ,
`categoryEnd`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`guid`, `spell`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `petition`
-- ----------------------------
DROP TABLE IF EXISTS `petition`;
CREATE TABLE `petition` (
`ownerguid`  int(10) UNSIGNED NOT NULL ,
`petitionguid`  int(10) UNSIGNED NULL DEFAULT 0 ,
`name`  varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`type`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`ownerguid`, `type`),
UNIQUE INDEX `index_ownerguid_petitionguid` (`ownerguid`, `petitionguid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Guild System'

;

-- ----------------------------
-- Table structure for `petition_sign`
-- ----------------------------
DROP TABLE IF EXISTS `petition_sign`;
CREATE TABLE `petition_sign` (
`ownerguid`  int(10) UNSIGNED NOT NULL ,
`petitionguid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`playerguid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`player_account`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`petitionguid`, `playerguid`),
INDEX `Idx_playerguid` (`playerguid`) USING BTREE ,
INDEX `Idx_ownerguid` (`ownerguid`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Guild System'

;

-- ----------------------------
-- Table structure for `pool_quest_save`
-- ----------------------------
DROP TABLE IF EXISTS `pool_quest_save`;
CREATE TABLE `pool_quest_save` (
`pool_id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`quest_id`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`pool_id`, `quest_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `pvpstats_battlegrounds`
-- ----------------------------
DROP TABLE IF EXISTS `pvpstats_battlegrounds`;
CREATE TABLE `pvpstats_battlegrounds` (
`id`  bigint(20) UNSIGNED NOT NULL ,
`winner_faction`  tinyint(4) NOT NULL ,
`bracket_id`  tinyint(3) UNSIGNED NOT NULL ,
`type`  tinyint(3) UNSIGNED NOT NULL ,
`date`  datetime NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `pvpstats_players`
-- ----------------------------
DROP TABLE IF EXISTS `pvpstats_players`;
CREATE TABLE `pvpstats_players` (
`battleground_id`  bigint(20) UNSIGNED NOT NULL ,
`character_guid`  int(10) UNSIGNED NOT NULL ,
`winner`  bit(1) NOT NULL ,
`score_killing_blows`  mediumint(8) UNSIGNED NOT NULL ,
`score_deaths`  mediumint(8) UNSIGNED NOT NULL ,
`score_honorable_kills`  mediumint(8) UNSIGNED NOT NULL ,
`score_bonus_honor`  mediumint(8) UNSIGNED NOT NULL ,
`score_damage_done`  mediumint(8) UNSIGNED NOT NULL ,
`score_healing_done`  mediumint(8) UNSIGNED NOT NULL ,
`attr_1`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`attr_2`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`attr_3`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`attr_4`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`attr_5`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`battleground_id`, `character_guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `quest_tracker`
-- ----------------------------
DROP TABLE IF EXISTS `quest_tracker`;
CREATE TABLE `quest_tracker` (
`id`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`character_guid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`quest_accept_time`  datetime NOT NULL ,
`quest_complete_time`  datetime NULL DEFAULT NULL ,
`quest_abandon_time`  datetime NULL DEFAULT NULL ,
`completed_by_gm`  tinyint(1) NOT NULL DEFAULT 0 ,
`core_hash`  varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' ,
`core_revision`  varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `recup_guilde`
-- ----------------------------
DROP TABLE IF EXISTS `recup_guilde`;
CREATE TABLE `recup_guilde` (
`dest_guid`  int(11) NOT NULL ,
`server_id`  int(11) NOT NULL ,
`status`  int(11) NOT NULL ,
`guild_name`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`guildrecup_id`  int(11) NOT NULL ,
PRIMARY KEY (`dest_guid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `recup_list`
-- ----------------------------
DROP TABLE IF EXISTS `recup_list`;
CREATE TABLE `recup_list` (
`groupe`  int(11) NOT NULL ,
`type`  int(11) NOT NULL ,
`id`  int(11) NOT NULL ,
`qte`  int(11) NOT NULL 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `recup_log`
-- ----------------------------
DROP TABLE IF EXISTS `recup_log`;
CREATE TABLE `recup_log` (
`guid`  int(11) NOT NULL ,
`server_id`  int(11) NOT NULL ,
`dest_guid`  int(11) NOT NULL ,
`pseudo_orig`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`guid`, `server_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `recup_pack_guilde`
-- ----------------------------
DROP TABLE IF EXISTS `recup_pack_guilde`;
CREATE TABLE `recup_pack_guilde` (
`id`  int(11) NOT NULL ,
`name`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `recup_rules`
-- ----------------------------
DROP TABLE IF EXISTS `recup_rules`;
CREATE TABLE `recup_rules` (
`guild`  int(11) NOT NULL ,
`groupe`  int(11) NOT NULL ,
`type`  int(11) NOT NULL ,
`value`  int(11) NOT NULL ,
PRIMARY KEY (`guild`, `type`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `recup_server`
-- ----------------------------
DROP TABLE IF EXISTS `recup_server`;
CREATE TABLE `recup_server` (
`id`  int(11) NOT NULL ,
`name`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`realmlist`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`realm`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`seuil_pc`  int(11) NOT NULL ,
`seuil_pc_guilde`  int(11) NOT NULL ,
`taux_pc`  int(11) NOT NULL ,
`ilevel`  int(11) NOT NULL ,
`extension`  int(11) NOT NULL DEFAULT 3 ,
`groupe`  int(11) NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `recup_stuff_remplace`
-- ----------------------------
DROP TABLE IF EXISTS `recup_stuff_remplace`;
CREATE TABLE `recup_stuff_remplace` (
`id`  int(11) NOT NULL ,
`new_id`  int(11) NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `reserved_name`
-- ----------------------------
DROP TABLE IF EXISTS `reserved_name`;
CREATE TABLE `reserved_name` (
`name`  varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`name`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Player Reserved Names'

;

-- ----------------------------
-- Table structure for `updates`
-- ----------------------------
DROP TABLE IF EXISTS `updates`;
CREATE TABLE `updates` (
`name`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'filename with extension of the update.' ,
`hash`  char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'sha1 hash of the sql file.' ,
`state`  enum('RELEASED','ARCHIVED') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.' ,
`timestamp`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.' ,
`speed`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'time the query takes to apply in ms.' ,
PRIMARY KEY (`name`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='List of all applied updates in this database.'

;

-- ----------------------------
-- Table structure for `updates_include`
-- ----------------------------
DROP TABLE IF EXISTS `updates_include`;
CREATE TABLE `updates_include` (
`path`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.' ,
`state`  enum('RELEASED','ARCHIVED') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.' ,
PRIMARY KEY (`path`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='List of directories where we want to include sql updates.'

;

-- ----------------------------
-- Table structure for `warden_action`
-- ----------------------------
DROP TABLE IF EXISTS `warden_action`;
CREATE TABLE `warden_action` (
`wardenId`  smallint(5) UNSIGNED NOT NULL ,
`action`  tinyint(3) UNSIGNED NULL DEFAULT NULL ,
PRIMARY KEY (`wardenId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Table structure for `worldstates`
-- ----------------------------
DROP TABLE IF EXISTS `worldstates`;
CREATE TABLE `worldstates` (
`entry`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`value`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`comment`  tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`entry`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Variable Saves'

;
