-- MySQL dump 10.13 Distrib 8.0.43, for Linux (x86_64)

--

-- Host: localhost Database: characters

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

-- Server version 8.0.43-0ubuntu0.22.04.2

/*!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 */;

/*!50503 SET NAMES utf8mb4 */;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `account_data` (

`accountId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',

`type` tinyint unsigned NOT NULL DEFAULT '0',

`time` int unsigned NOT NULL DEFAULT '0',

`data` blob NOT NULL,

PRIMARY KEY (`accountId`,`type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `account_instance_times` (

`accountId` int unsigned NOT NULL,

`instanceId` int unsigned NOT NULL DEFAULT '0',

`releaseTime` bigint unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`accountId`,`instanceId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `account_tutorial` (

`accountId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',

`tut0` int unsigned NOT NULL DEFAULT '0',

`tut1` int unsigned NOT NULL DEFAULT '0',

`tut2` int unsigned NOT NULL DEFAULT '0',

`tut3` int unsigned NOT NULL DEFAULT '0',

`tut4` int unsigned NOT NULL DEFAULT '0',

`tut5` int unsigned NOT NULL DEFAULT '0',

`tut6` int unsigned NOT NULL DEFAULT '0',

`tut7` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`accountId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `addons` (

`name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`crc` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

INSERT INTO `addons` VALUES

('Blizzard_AchievementUI',1276933997),

('Blizzard_ArenaUI',1276933997),

('Blizzard_AuctionUI',1276933997),

('Blizzard_BarbershopUI',1276933997),

('Blizzard_BattlefieldMinimap',1276933997),

('Blizzard_BindingUI',1276933997),

('Blizzard_Calendar',1276933997),

('Blizzard_CombatLog',1276933997),

('Blizzard_CombatText',1276933997),

('Blizzard_DebugTools',1276933997),

('Blizzard_GlyphUI',1276933997),

('Blizzard_GMChatUI',1276933997),

('Blizzard_GMSurveyUI',1276933997),

('Blizzard_GuildBankUI',1276933997),

('Blizzard_InspectUI',1276933997),

('Blizzard_ItemSocketingUI',1276933997),

('Blizzard_MacroUI',1276933997),

('Blizzard_RaidUI',1276933997),

('Blizzard_TalentUI',1276933997),

('Blizzard_TimeManager',1276933997),

('Blizzard_TokenUI',1276933997),

('Blizzard_TradeSkillUI',1276933997),

('Blizzard_TrainerUI',1276933997);

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `arena_team` (

`arenaTeamId` int unsigned NOT NULL DEFAULT '0',

`name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`captainGuid` int unsigned NOT NULL DEFAULT '0',

`type` tinyint unsigned NOT NULL DEFAULT '0',

`rating` smallint unsigned NOT NULL DEFAULT '0',

`seasonGames` smallint unsigned NOT NULL DEFAULT '0',

`seasonWins` smallint unsigned NOT NULL DEFAULT '0',

`weekGames` smallint unsigned NOT NULL DEFAULT '0',

`weekWins` smallint unsigned NOT NULL DEFAULT '0',

`rank` int unsigned NOT NULL DEFAULT '0',

`backgroundColor` int unsigned NOT NULL DEFAULT '0',

`emblemStyle` tinyint unsigned NOT NULL DEFAULT '0',

`emblemColor` int unsigned NOT NULL DEFAULT '0',

`borderStyle` tinyint unsigned NOT NULL DEFAULT '0',

`borderColor` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`arenaTeamId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `arena_team_member` (

`arenaTeamId` int unsigned NOT NULL DEFAULT '0',

`guid` int unsigned NOT NULL DEFAULT '0',

`weekGames` smallint unsigned NOT NULL DEFAULT '0',

`weekWins` smallint unsigned NOT NULL DEFAULT '0',

`seasonGames` smallint unsigned NOT NULL DEFAULT '0',

`seasonWins` smallint unsigned NOT NULL DEFAULT '0',

`personalRating` smallint unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`arenaTeamId`,`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 `auctionbidders`

--

DROP TABLE IF EXISTS `auctionbidders`;

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

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `auctionbidders` (

`id` int unsigned NOT NULL DEFAULT '0',

`bidderguid` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`,`bidderguid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--

-- Dumping data for table `auctionbidders`

--

LOCK TABLES `auctionbidders` WRITE;

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

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

UNLOCK TABLES;

--

-- Table structure for table `auctionhouse`

--

DROP TABLE IF EXISTS `auctionhouse`;

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

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `auctionhouse` (

`id` int unsigned NOT NULL DEFAULT '0',

`houseid` tinyint unsigned NOT NULL DEFAULT '7',

`itemguid` int unsigned NOT NULL DEFAULT '0',

`itemowner` int unsigned NOT NULL DEFAULT '0',

`buyoutprice` int unsigned NOT NULL DEFAULT '0',

`time` int unsigned NOT NULL DEFAULT '0',

`buyguid` int unsigned NOT NULL DEFAULT '0',

`lastbid` int unsigned NOT NULL DEFAULT '0',

`startbid` int unsigned NOT NULL DEFAULT '0',

`deposit` int unsigned NOT NULL DEFAULT '0',

`Flags` tinyint unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `item_guid` (`itemguid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `banned_addons` (

`Id` int unsigned NOT NULL AUTO_INCREMENT,

`Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`Version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `battleground_deserters` (

`guid` int unsigned NOT NULL COMMENT 'characters.guid',

`type` tinyint unsigned NOT NULL COMMENT 'type of the desertion',

`datetime` datetime NOT NULL COMMENT 'datetime of the desertion'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `bugreport` (

`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',

`type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `calendar_events` (

`id` bigint unsigned NOT NULL DEFAULT '0',

`creator` int unsigned NOT NULL DEFAULT '0',

`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`type` tinyint unsigned NOT NULL DEFAULT '4',

`dungeon` int NOT NULL DEFAULT '-1',

`eventtime` int unsigned NOT NULL DEFAULT '0',

`flags` int unsigned NOT NULL DEFAULT '0',

`time2` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `calendar_invites` (

`id` bigint unsigned NOT NULL DEFAULT '0',

`event` bigint unsigned NOT NULL DEFAULT '0',

`invitee` int unsigned NOT NULL DEFAULT '0',

`sender` int unsigned NOT NULL DEFAULT '0',

`status` tinyint unsigned NOT NULL DEFAULT '0',

`statustime` int unsigned NOT NULL DEFAULT '0',

`rank` tinyint unsigned NOT NULL DEFAULT '0',

`text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `channels` (

`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,

`team` int unsigned NOT NULL,

`announce` tinyint unsigned NOT NULL DEFAULT '1',

`ownership` tinyint unsigned NOT NULL DEFAULT '1',

`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,

`bannedList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,

`lastUsed` int unsigned NOT NULL,

PRIMARY KEY (`name`,`team`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_account_data` (

`guid` int unsigned NOT NULL DEFAULT '0',

`type` tinyint unsigned NOT NULL DEFAULT '0',

`time` int unsigned NOT NULL DEFAULT '0',

`data` blob NOT NULL,

PRIMARY KEY (`guid`,`type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_achievement` (

`guid` int unsigned NOT NULL,

`achievement` smallint unsigned NOT NULL,

`date` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`,`achievement`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_achievement_progress` (

`guid` int unsigned NOT NULL,

`criteria` smallint unsigned NOT NULL,

`counter` int unsigned NOT NULL,

`date` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`,`criteria`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_action` (

`guid` int unsigned NOT NULL DEFAULT '0',

`spec` tinyint unsigned NOT NULL DEFAULT '0',

`button` tinyint unsigned NOT NULL DEFAULT '0',

`action` int unsigned NOT NULL DEFAULT '0',

`type` tinyint unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`,`spec`,`button`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_arena_stats` (

`guid` int unsigned NOT NULL DEFAULT '0',

`slot` tinyint unsigned NOT NULL DEFAULT '0',

`matchMakerRating` smallint unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`,`slot`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_aura` (

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

`casterGuid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',

`itemGuid` bigint unsigned NOT NULL DEFAULT '0',

`spell` mediumint unsigned NOT NULL DEFAULT '0',

`effectMask` tinyint unsigned NOT NULL DEFAULT '0',

`recalculateMask` tinyint unsigned NOT NULL DEFAULT '0',

`stackCount` tinyint unsigned NOT NULL DEFAULT '1',

`amount0` int NOT NULL DEFAULT '0',

`amount1` int NOT NULL DEFAULT '0',

`amount2` int NOT NULL DEFAULT '0',

`base_amount0` int NOT NULL DEFAULT '0',

`base_amount1` int NOT NULL DEFAULT '0',

`base_amount2` int NOT NULL DEFAULT '0',

`maxDuration` int NOT NULL DEFAULT '0',

`remainTime` int NOT NULL DEFAULT '0',

`remainCharges` tinyint unsigned NOT NULL DEFAULT '0',

`critChance` float NOT NULL DEFAULT '0',

`applyResilience` tinyint NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_banned` (

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

`bandate` int unsigned NOT NULL DEFAULT '0',

`unbandate` int unsigned NOT NULL DEFAULT '0',

`bannedby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`banreason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`active` tinyint unsigned NOT NULL DEFAULT '1',

PRIMARY KEY (`guid`,`bandate`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_battleground_data` (

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

`instanceId` int unsigned NOT NULL COMMENT 'Instance Identifier',

`team` smallint 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 unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',

`taxiStart` int unsigned NOT NULL DEFAULT '0',

`taxiEnd` int unsigned NOT NULL DEFAULT '0',

`mountSpell` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_battleground_random` (

`guid` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_declinedname` (

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

`genitive` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`dative` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`accusative` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`instrumental` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`prepositional` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

PRIMARY KEY (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_equipmentsets` (

`guid` int unsigned NOT NULL DEFAULT '0',

`setguid` bigint unsigned NOT NULL AUTO_INCREMENT,

`setindex` tinyint unsigned NOT NULL DEFAULT '0',

`name` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`iconname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`ignore_mask` int unsigned NOT NULL DEFAULT '0',

`item0` int unsigned NOT NULL DEFAULT '0',

`item1` int unsigned NOT NULL DEFAULT '0',

`item2` int unsigned NOT NULL DEFAULT '0',

`item3` int unsigned NOT NULL DEFAULT '0',

`item4` int unsigned NOT NULL DEFAULT '0',

`item5` int unsigned NOT NULL DEFAULT '0',

`item6` int unsigned NOT NULL DEFAULT '0',

`item7` int unsigned NOT NULL DEFAULT '0',

`item8` int unsigned NOT NULL DEFAULT '0',

`item9` int unsigned NOT NULL DEFAULT '0',

`item10` int unsigned NOT NULL DEFAULT '0',

`item11` int unsigned NOT NULL DEFAULT '0',

`item12` int unsigned NOT NULL DEFAULT '0',

`item13` int unsigned NOT NULL DEFAULT '0',

`item14` int unsigned NOT NULL DEFAULT '0',

`item15` int unsigned NOT NULL DEFAULT '0',

`item16` int unsigned NOT NULL DEFAULT '0',

`item17` int unsigned NOT NULL DEFAULT '0',

`item18` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`setguid`),

UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`),

KEY `Idx_setindex` (`setindex`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_fishingsteps` (

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

`fishingSteps` tinyint unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_gifts` (

`guid` int unsigned NOT NULL DEFAULT '0',

`item_guid` int unsigned NOT NULL DEFAULT '0',

`entry` int unsigned NOT NULL DEFAULT '0',

`flags` int unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`item_guid`),

KEY `idx_guid` (`guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_glyphs` (

`guid` int unsigned NOT NULL,

`talentGroup` tinyint unsigned NOT NULL DEFAULT '0',

`glyph1` smallint unsigned DEFAULT '0',

`glyph2` smallint unsigned DEFAULT '0',

`glyph3` smallint unsigned DEFAULT '0',

`glyph4` smallint unsigned DEFAULT '0',

`glyph5` smallint unsigned DEFAULT '0',

`glyph6` smallint unsigned DEFAULT '0',

PRIMARY KEY (`guid`,`talentGroup`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_homebind` (

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

`mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',

`zoneId` smallint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_instance` (

`guid` int unsigned NOT NULL DEFAULT '0',

`instance` int unsigned NOT NULL DEFAULT '0',

`permanent` tinyint unsigned NOT NULL DEFAULT '0',

`extendState` tinyint unsigned NOT NULL DEFAULT '1',

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

KEY `instance` (`instance`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_inventory` (

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

`bag` int unsigned NOT NULL DEFAULT '0',

`slot` tinyint unsigned NOT NULL DEFAULT '0',

`item` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_pet` (

`id` int unsigned NOT NULL DEFAULT '0',

`entry` int unsigned NOT NULL DEFAULT '0',

`owner` int unsigned NOT NULL DEFAULT '0',

`modelid` int unsigned DEFAULT '0',

`CreatedBySpell` mediumint unsigned NOT NULL DEFAULT '0',

`PetType` tinyint unsigned NOT NULL DEFAULT '0',

`level` smallint unsigned NOT NULL DEFAULT '1',

`exp` int unsigned NOT NULL DEFAULT '0',

`Reactstate` tinyint unsigned NOT NULL DEFAULT '0',

`name` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pet',

`renamed` tinyint unsigned NOT NULL DEFAULT '0',

`slot` tinyint unsigned NOT NULL DEFAULT '0',

`curhealth` int unsigned NOT NULL DEFAULT '1',

`curmana` int unsigned NOT NULL DEFAULT '0',

`curhappiness` int unsigned NOT NULL DEFAULT '0',

`savetime` int unsigned NOT NULL DEFAULT '0',

`abdata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,

PRIMARY KEY (`id`),

KEY `owner` (`owner`),

KEY `idx_slot` (`slot`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_pet_declinedname` (

`id` int unsigned NOT NULL DEFAULT '0',

`owner` int unsigned NOT NULL DEFAULT '0',

`genitive` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`dative` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`accusative` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`instrumental` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

`prepositional` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

PRIMARY KEY (`id`),

KEY `owner_key` (`owner`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!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 */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `character_queststatus` (

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

`quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',

`status` tinyint unsigned NOT NULL DEFAULT '0',

`explored` tinyint unsigned NOT NULL DEFAULT '0',

`timer` int unsigned NOT NULL DEFAULT '0',

`mobcount1` smallint unsigned NOT NULL DEFAULT '0',

`mobcount2` smallint unsigned NOT NULL DEFAULT '0',

`mobcount3` smallint unsigned NOT NULL DEFAULT '0',

`mobcount4` smallint unsigned NOT NULL DEFAULT '0',

`itemcount1` smallint unsigned NOT NULL DEFAULT '0',

`itemcount2` smallint unsigned NOT NULL DEFAULT '0',

`itemcount3` smallint unsigned NOT NULL DEFAULT '0',

`itemcount4` smallint unsigned NOT NULL DEFAULT '0',

`itemcount5` smallint unsigned NOT NULL DEFAULT '0',

`itemcount6` smallint unsigned NOT NULL DEFAULT '0',

`playercount` smallint unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`guid`,`quest`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System';

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

--

-- Dumping data for table `character_queststatus`

--