-- MySQL dump 10.16 Distrib 10.1.6-MariaDB, for Win64 (AMD64)

--

-- Host: localhost Database: characters

-- ------------------------------------------------------

-- Server version 5.7.14-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 `account_data`

--

DROP TABLE IF EXISTS `account_data`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `account_data`

--

LOCK TABLES `account_data` WRITE;

/*!40000 ALTER TABLE `account_data` DISABLE KEYS */;

/*!40000 ALTER TABLE `account_data` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `account_instance_times`

--

DROP TABLE IF EXISTS `account_instance_times`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `account_instance_times`

--

LOCK TABLES `account_instance_times` WRITE;

/*!40000 ALTER TABLE `account_instance_times` DISABLE KEYS */;

/*!40000 ALTER TABLE `account_instance_times` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `account_tutorial`

--

DROP TABLE IF EXISTS `account_tutorial`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `account_tutorial`

--

LOCK TABLES `account_tutorial` WRITE;

/*!40000 ALTER TABLE `account_tutorial` DISABLE KEYS */;

/*!40000 ALTER TABLE `account_tutorial` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `addons`

--

DROP TABLE IF EXISTS `addons`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `addons` (

`name` varchar(120) NOT NULL DEFAULT '',

`crc` int(10) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Addons';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `addons`

--

LOCK TABLES `addons` WRITE;

/*!40000 ALTER TABLE `addons` DISABLE KEYS */;

/*!40000 ALTER TABLE `addons` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `arena_team`

--

DROP TABLE IF EXISTS `arena_team`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `arena_team` (

`arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0',

`name` varchar(24) 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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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 `auctionhouse`

--

DROP TABLE IF EXISTS `auctionhouse`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 KEY `item_guid` (`itemguid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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 `banned_addons`

--

DROP TABLE IF EXISTS `banned_addons`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `banned_addons` (

`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`Name` varchar(255) NOT NULL,

`Version` varchar(255) NOT NULL DEFAULT '',

`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`Id`),

UNIQUE KEY `idx_name_ver` (`Name`,`Version`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `banned_addons`

--

LOCK TABLES `banned_addons` WRITE;

/*!40000 ALTER TABLE `banned_addons` DISABLE KEYS */;

/*!40000 ALTER TABLE `banned_addons` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `battleground_deserters`

--

DROP TABLE IF EXISTS `battleground_deserters`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `battleground_deserters`

--

LOCK TABLES `battleground_deserters` WRITE;

/*!40000 ALTER TABLE `battleground_deserters` DISABLE KEYS */;

/*!40000 ALTER TABLE `battleground_deserters` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `bugreport`

--

DROP TABLE IF EXISTS `bugreport`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `bugreport` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',

`type` longtext NOT NULL,

`content` longtext NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Debug System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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 `calendar_events`

--

DROP TABLE IF EXISTS `calendar_events`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `calendar_events` (

`id` bigint(20) unsigned NOT NULL DEFAULT '0',

`creator` int(10) unsigned NOT NULL DEFAULT '0',

`title` varchar(255) NOT NULL DEFAULT '',

`description` varchar(255) 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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `calendar_events`

--

LOCK TABLES `calendar_events` WRITE;

/*!40000 ALTER TABLE `calendar_events` DISABLE KEYS */;

/*!40000 ALTER TABLE `calendar_events` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `calendar_invites`

--

DROP TABLE IF EXISTS `calendar_invites`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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) NOT NULL DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `calendar_invites`

--

LOCK TABLES `calendar_invites` WRITE;

/*!40000 ALTER TABLE `calendar_invites` DISABLE KEYS */;

/*!40000 ALTER TABLE `calendar_invites` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `channels`

--

DROP TABLE IF EXISTS `channels`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `channels` (

`name` varchar(128) 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) DEFAULT NULL,

`bannedList` text,

`lastUsed` int(10) unsigned NOT NULL,

PRIMARY KEY (`name`,`team`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `channels`

--

LOCK TABLES `channels` WRITE;

/*!40000 ALTER TABLE `channels` DISABLE KEYS */;

/*!40000 ALTER TABLE `channels` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_account_data`

--

DROP TABLE IF EXISTS `character_account_data`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_account_data`

--

LOCK TABLES `character_account_data` WRITE;

/*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_achievement`

--

DROP TABLE IF EXISTS `character_achievement`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_achievement`

--

LOCK TABLES `character_achievement` WRITE;

/*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_achievement_progress`

--

DROP TABLE IF EXISTS `character_achievement_progress`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_achievement_progress`

--

LOCK TABLES `character_achievement_progress` WRITE;

/*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_action`

--

DROP TABLE IF EXISTS `character_action`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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_arena_stats`

--

DROP TABLE IF EXISTS `character_arena_stats`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_arena_stats`

--

LOCK TABLES `character_arena_stats` WRITE;

/*!40000 ALTER TABLE `character_arena_stats` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_arena_stats` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_aura`

--

DROP TABLE IF EXISTS `character_aura`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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',

`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`,`spell`,`effectMask`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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_banned`

--

DROP TABLE IF EXISTS `character_banned`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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) NOT NULL,

`banreason` varchar(255) NOT NULL,

`active` tinyint(3) unsigned NOT NULL DEFAULT '1',

PRIMARY KEY (`guid`,`bandate`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_banned`

--

LOCK TABLES `character_banned` WRITE;

/*!40000 ALTER TABLE `character_banned` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_banned` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_battleground_data`

--

DROP TABLE IF EXISTS `character_battleground_data`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8 COMMENT='Player System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_battleground_data`

--

LOCK TABLES `character_battleground_data` WRITE;

/*!40000 ALTER TABLE `character_battleground_data` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_battleground_data` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_battleground_random`

--

DROP TABLE IF EXISTS `character_battleground_random`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `character_battleground_random` (

`guid` int(10) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_battleground_random`

--

LOCK TABLES `character_battleground_random` WRITE;

/*!40000 ALTER TABLE `character_battleground_random` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_battleground_random` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_declinedname`

--

DROP TABLE IF EXISTS `character_declinedname`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `character_declinedname` (

`guid` int(10) 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=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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_equipmentsets`

--

DROP TABLE IF EXISTS `character_equipmentsets`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `character_equipmentsets` (

`guid` int(10) NOT NULL DEFAULT '0',

`setguid` bigint(20) NOT NULL AUTO_INCREMENT,

`setindex` tinyint(3) unsigned NOT NULL DEFAULT '0',

`name` varchar(31) NOT NULL,

`iconname` varchar(100) 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 KEY `idx_set` (`guid`,`setguid`,`setindex`),

KEY `Idx_setindex` (`setindex`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_equipmentsets`

--

LOCK TABLES `character_equipmentsets` WRITE;

/*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_fishingsteps`

--

DROP TABLE IF EXISTS `character_fishingsteps`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `character_fishingsteps` (

`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',

`fishingSteps` tinyint(3) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_fishingsteps`

--

LOCK TABLES `character_fishingsteps` WRITE;

/*!40000 ALTER TABLE `character_fishingsteps` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_fishingsteps` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_gifts`

--

DROP TABLE IF EXISTS `character_gifts`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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`),

KEY `idx_guid` (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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_glyphs`

--

DROP TABLE IF EXISTS `character_glyphs`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `character_glyphs` (

`guid` int(10) unsigned NOT NULL,

`talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0',

`glyph1` smallint(5) unsigned DEFAULT '0',

`glyph2` smallint(5) unsigned DEFAULT '0',

`glyph3` smallint(5) unsigned DEFAULT '0',

`glyph4` smallint(5) unsigned DEFAULT '0',

`glyph5` smallint(5) unsigned DEFAULT '0',

`glyph6` smallint(5) unsigned DEFAULT '0',

PRIMARY KEY (`guid`,`talentGroup`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_glyphs`

--

LOCK TABLES `character_glyphs` WRITE;

/*!40000 ALTER TABLE `character_glyphs` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_glyphs` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `character_homebind`

--

DROP TABLE IF EXISTS `character_homebind`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8 COMMENT='Player System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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',

`extendState` tinyint(2) unsigned NOT NULL DEFAULT '1',

PRIMARY KEY (`guid`,`instance`),

KEY `instance` (`instance`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 KEY `guid` (`guid`,`bag`,`slot`),

KEY `idx_guid` (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 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) 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,

PRIMARY KEY (`id`),

KEY `owner` (`owner`),

KEY `idx_slot` (`slot`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `character_pet_declinedname` (

`id` int(10) unsigned NOT NULL DEFAULT '0',

`owner` int(10) 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=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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 CHARSET=utf8 COMMENT='Player System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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`),

KEY `idx_guid` (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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_queststatus_monthly`

--

DROP TABLE IF EXISTS `character_queststatus_monthly`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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`),

KEY `idx_guid` (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `character_queststatus_monthly`

--

LOCK TABLES `character_queststatus_monthly` WRITE;

/*!40000 ALTER TABLE `character_queststatus_monthly` DISABLE KEYS */;

/*!40000 ALTER TABLE `character_queststatus_monthly` ENABLE KEYS */;