-- MySQL dump 10.13 Distrib 8.0.36, for Linux (x86_64) -- -- Host: localhost Database: characters -- ------------------------------------------------------ -- Server version 8.0.36-0ubuntu0.22.04.1 /*!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` -- 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 */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_daily` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', `time` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`), 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_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 */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_monthly` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), 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_queststatus_monthly` -- LOCK TABLES `character_queststatus_monthly` WRITE; /*!40000 ALTER TABLE `character_queststatus_monthly` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_monthly` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_queststatus_rewarded` -- DROP TABLE IF EXISTS `character_queststatus_rewarded`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_rewarded` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', `active` tinyint unsigned NOT NULL DEFAULT '1', 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_rewarded` -- LOCK TABLES `character_queststatus_rewarded` WRITE; /*!40000 ALTER TABLE `character_queststatus_rewarded` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_rewarded` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_queststatus_seasonal` -- DROP TABLE IF EXISTS `character_queststatus_seasonal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_seasonal` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', `event` int unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier', PRIMARY KEY (`guid`,`quest`), 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_queststatus_seasonal` -- LOCK TABLES `character_queststatus_seasonal` WRITE; /*!40000 ALTER TABLE `character_queststatus_seasonal` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_seasonal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_queststatus_weekly` -- DROP TABLE IF EXISTS `character_queststatus_weekly`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_weekly` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), 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_queststatus_weekly` -- LOCK TABLES `character_queststatus_weekly` WRITE; /*!40000 ALTER TABLE `character_queststatus_weekly` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_weekly` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_reputation` -- DROP TABLE IF EXISTS `character_reputation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_reputation` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `faction` smallint unsigned NOT NULL DEFAULT '0', `standing` int NOT NULL DEFAULT '0', `flags` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`faction`) ) 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_reputation` -- LOCK TABLES `character_reputation` WRITE; /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */; /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_skills` -- DROP TABLE IF EXISTS `character_skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_skills` ( `guid` int unsigned NOT NULL COMMENT 'Global Unique Identifier', `skill` smallint unsigned NOT NULL, `value` smallint unsigned NOT NULL, `max` smallint unsigned NOT NULL, PRIMARY KEY (`guid`,`skill`) ) 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_skills` -- LOCK TABLES `character_skills` WRITE; /*!40000 ALTER TABLE `character_skills` DISABLE KEYS */; /*!40000 ALTER TABLE `character_skills` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_social` -- DROP TABLE IF EXISTS `character_social`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_social` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `friend` int unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', `flags` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', `note` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), KEY `friend` (`friend`) ) 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_social` -- LOCK TABLES `character_social` WRITE; /*!40000 ALTER TABLE `character_social` DISABLE KEYS */; /*!40000 ALTER TABLE `character_social` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_spell` -- DROP TABLE IF EXISTS `character_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `active` tinyint unsigned NOT NULL DEFAULT '1', `disabled` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) ) 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_spell` -- LOCK TABLES `character_spell` WRITE; /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */; /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_spell_cooldown` -- DROP TABLE IF EXISTS `character_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell_cooldown` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `item` int unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', `time` int unsigned NOT NULL DEFAULT '0', `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', `categoryEnd` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_spell_cooldown` -- LOCK TABLES `character_spell_cooldown` WRITE; /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */; /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_stats` -- DROP TABLE IF EXISTS `character_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_stats` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', `maxhealth` int unsigned NOT NULL DEFAULT '0', `maxpower1` int unsigned NOT NULL DEFAULT '0', `maxpower2` int unsigned NOT NULL DEFAULT '0', `maxpower3` int unsigned NOT NULL DEFAULT '0', `maxpower4` int unsigned NOT NULL DEFAULT '0', `maxpower5` int unsigned NOT NULL DEFAULT '0', `maxpower6` int unsigned NOT NULL DEFAULT '0', `maxpower7` int unsigned NOT NULL DEFAULT '0', `strength` int unsigned NOT NULL DEFAULT '0', `agility` int unsigned NOT NULL DEFAULT '0', `stamina` int unsigned NOT NULL DEFAULT '0', `intellect` int unsigned NOT NULL DEFAULT '0', `spirit` int unsigned NOT NULL DEFAULT '0', `armor` int unsigned NOT NULL DEFAULT '0', `resHoly` int unsigned NOT NULL DEFAULT '0', `resFire` int unsigned NOT NULL DEFAULT '0', `resNature` int unsigned NOT NULL DEFAULT '0', `resFrost` int unsigned NOT NULL DEFAULT '0', `resShadow` int unsigned NOT NULL DEFAULT '0', `resArcane` int 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 unsigned NOT NULL DEFAULT '0', `rangedAttackPower` int unsigned NOT NULL DEFAULT '0', `spellPower` int unsigned NOT NULL DEFAULT '0', `resilience` 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_stats` -- LOCK TABLES `character_stats` WRITE; /*!40000 ALTER TABLE `character_stats` DISABLE KEYS */; /*!40000 ALTER TABLE `character_stats` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_talent` -- DROP TABLE IF EXISTS `character_talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_talent` ( `guid` int unsigned NOT NULL, `spell` mediumint unsigned NOT NULL, `talentGroup` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_talent` -- LOCK TABLES `character_talent` WRITE; /*!40000 ALTER TABLE `character_talent` DISABLE KEYS */; /*!40000 ALTER TABLE `character_talent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `characters` -- DROP TABLE IF EXISTS `characters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `characters` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `account` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', `gender` tinyint unsigned NOT NULL DEFAULT '0', `level` tinyint unsigned NOT NULL DEFAULT '0', `xp` int unsigned NOT NULL DEFAULT '0', `money` int unsigned NOT NULL DEFAULT '0', `skin` tinyint unsigned NOT NULL DEFAULT '0', `face` tinyint unsigned NOT NULL DEFAULT '0', `hairStyle` tinyint unsigned NOT NULL DEFAULT '0', `hairColor` tinyint unsigned NOT NULL DEFAULT '0', `facialStyle` tinyint unsigned NOT NULL DEFAULT '0', `bankSlots` tinyint unsigned NOT NULL DEFAULT '0', `restState` tinyint unsigned NOT NULL DEFAULT '0', `playerFlags` int 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 unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `instance_id` int unsigned NOT NULL DEFAULT '0', `instance_mode_mask` tinyint unsigned NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `taximask` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `online` tinyint unsigned NOT NULL DEFAULT '0', `cinematic` tinyint unsigned NOT NULL DEFAULT '0', `totaltime` int unsigned NOT NULL DEFAULT '0', `leveltime` int unsigned NOT NULL DEFAULT '0', `logout_time` int unsigned NOT NULL DEFAULT '0', `is_logout_resting` tinyint unsigned NOT NULL DEFAULT '0', `rest_bonus` float NOT NULL DEFAULT '0', `resettalents_cost` int unsigned NOT NULL DEFAULT '0', `resettalents_time` int 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 unsigned NOT NULL DEFAULT '0', `extra_flags` smallint unsigned NOT NULL DEFAULT '0', `stable_slots` tinyint unsigned NOT NULL DEFAULT '0', `at_login` smallint unsigned NOT NULL DEFAULT '0', `zone` smallint unsigned NOT NULL DEFAULT '0', `death_expire_time` int unsigned NOT NULL DEFAULT '0', `taxi_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `arenaPoints` int unsigned NOT NULL DEFAULT '0', `totalHonorPoints` int unsigned NOT NULL DEFAULT '0', `todayHonorPoints` int unsigned NOT NULL DEFAULT '0', `yesterdayHonorPoints` int unsigned NOT NULL DEFAULT '0', `totalKills` int unsigned NOT NULL DEFAULT '0', `todayKills` smallint unsigned NOT NULL DEFAULT '0', `yesterdayKills` smallint unsigned NOT NULL DEFAULT '0', `chosenTitle` int unsigned NOT NULL DEFAULT '0', `knownCurrencies` bigint unsigned NOT NULL DEFAULT '0', `watchedFaction` int unsigned NOT NULL DEFAULT '0', `drunk` tinyint unsigned NOT NULL DEFAULT '0', `health` int unsigned NOT NULL DEFAULT '0', `power1` int unsigned NOT NULL DEFAULT '0', `power2` int unsigned NOT NULL DEFAULT '0', `power3` int unsigned NOT NULL DEFAULT '0', `power4` int unsigned NOT NULL DEFAULT '0', `power5` int unsigned NOT NULL DEFAULT '0', `power6` int unsigned NOT NULL DEFAULT '0', `power7` int unsigned NOT NULL DEFAULT '0', `latency` mediumint unsigned NOT NULL DEFAULT '0', `talentGroupsCount` tinyint unsigned NOT NULL DEFAULT '1', `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0', `exploredZones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `equipmentCache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ammoId` int unsigned NOT NULL DEFAULT '0', `knownTitles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `actionBars` tinyint unsigned NOT NULL DEFAULT '0', `grantableLevels` tinyint unsigned NOT NULL DEFAULT '0', `deleteInfos_Account` int unsigned DEFAULT NULL, `deleteInfos_Name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleteDate` int unsigned DEFAULT NULL, PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), KEY `idx_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `characters` -- LOCK TABLES `characters` WRITE; /*!40000 ALTER TABLE `characters` DISABLE KEYS */; /*!40000 ALTER TABLE `characters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `corpse` -- DROP TABLE IF EXISTS `corpse`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `corpse` ( `guid` int 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 unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `phaseMask` int unsigned NOT NULL DEFAULT '1', `displayId` int unsigned NOT NULL DEFAULT '0', `itemCache` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `bytes1` int unsigned NOT NULL DEFAULT '0', `bytes2` int unsigned NOT NULL DEFAULT '0', `guildId` int unsigned NOT NULL DEFAULT '0', `flags` tinyint unsigned NOT NULL DEFAULT '0', `dynFlags` tinyint unsigned NOT NULL DEFAULT '0', `time` int unsigned NOT NULL DEFAULT '0', `corpseType` tinyint unsigned NOT NULL DEFAULT '0', `instanceId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier', PRIMARY KEY (`guid`), KEY `idx_type` (`corpseType`), KEY `idx_instance` (`instanceId`), KEY `idx_time` (`time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Death System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `corpse` -- LOCK TABLES `corpse` WRITE; /*!40000 ALTER TABLE `corpse` DISABLE KEYS */; /*!40000 ALTER TABLE `corpse` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `game_event_condition_save` -- DROP TABLE IF EXISTS `game_event_condition_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_condition_save` ( `eventEntry` tinyint unsigned NOT NULL, `condition_id` int unsigned NOT NULL DEFAULT '0', `done` float DEFAULT '0', PRIMARY KEY (`eventEntry`,`condition_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `game_event_condition_save` -- LOCK TABLES `game_event_condition_save` WRITE; /*!40000 ALTER TABLE `game_event_condition_save` DISABLE KEYS */; /*!40000 ALTER TABLE `game_event_condition_save` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `game_event_save` -- DROP TABLE IF EXISTS `game_event_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_save` ( `eventEntry` tinyint unsigned NOT NULL, `state` tinyint unsigned NOT NULL DEFAULT '1', `next_start` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`eventEntry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `game_event_save` -- LOCK TABLES `game_event_save` WRITE; /*!40000 ALTER TABLE `game_event_save` DISABLE KEYS */; /*!40000 ALTER TABLE `game_event_save` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gm_subsurvey` -- DROP TABLE IF EXISTS `gm_subsurvey`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_subsurvey` ( `surveyId` int unsigned NOT NULL AUTO_INCREMENT, `questionId` int unsigned NOT NULL DEFAULT '0', `answer` int unsigned NOT NULL DEFAULT '0', `answerComment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`surveyId`,`questionId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gm_subsurvey` -- LOCK TABLES `gm_subsurvey` WRITE; /*!40000 ALTER TABLE `gm_subsurvey` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_subsurvey` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gm_survey` -- DROP TABLE IF EXISTS `gm_survey`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_survey` ( `surveyId` int unsigned NOT NULL AUTO_INCREMENT, `guid` int unsigned NOT NULL DEFAULT '0', `mainSurvey` int unsigned NOT NULL DEFAULT '0', `comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`surveyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gm_survey` -- LOCK TABLES `gm_survey` WRITE; /*!40000 ALTER TABLE `gm_survey` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_survey` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gm_ticket` -- DROP TABLE IF EXISTS `gm_ticket`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_ticket` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 open, 1 closed, 2 character deleted', `playerGuid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier of ticket creator', `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of ticket creator', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` int unsigned NOT NULL DEFAULT '0', `mapId` smallint 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 unsigned NOT NULL DEFAULT '0', `closedBy` int NOT NULL DEFAULT '0', `assignedTo` int unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `completed` tinyint unsigned NOT NULL DEFAULT '0', `escalated` tinyint unsigned NOT NULL DEFAULT '0', `viewed` tinyint unsigned NOT NULL DEFAULT '0', `needMoreHelp` tinyint unsigned NOT NULL DEFAULT '0', `resolvedBy` int NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gm_ticket` -- LOCK TABLES `gm_ticket` WRITE; /*!40000 ALTER TABLE `gm_ticket` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_ticket` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `group_instance` -- DROP TABLE IF EXISTS `group_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `group_instance` ( `guid` int unsigned NOT NULL DEFAULT '0', `instance` int unsigned NOT NULL DEFAULT '0', `permanent` tinyint unsigned NOT NULL DEFAULT '0', 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 `group_instance` -- LOCK TABLES `group_instance` WRITE; /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */; /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `group_member` -- DROP TABLE IF EXISTS `group_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `group_member` ( `guid` int unsigned NOT NULL, `memberGuid` int unsigned NOT NULL, `memberFlags` tinyint unsigned NOT NULL DEFAULT '0', `subgroup` tinyint unsigned NOT NULL DEFAULT '0', `roles` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`memberGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Groups'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `group_member` -- LOCK TABLES `group_member` WRITE; /*!40000 ALTER TABLE `group_member` DISABLE KEYS */; /*!40000 ALTER TABLE `group_member` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `groups` -- DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `groups` ( `guid` int unsigned NOT NULL, `leaderGuid` int unsigned NOT NULL, `lootMethod` tinyint unsigned NOT NULL, `looterGuid` int unsigned NOT NULL, `lootThreshold` tinyint unsigned NOT NULL, `icon1` bigint unsigned NOT NULL, `icon2` bigint unsigned NOT NULL, `icon3` bigint unsigned NOT NULL, `icon4` bigint unsigned NOT NULL, `icon5` bigint unsigned NOT NULL, `icon6` bigint unsigned NOT NULL, `icon7` bigint unsigned NOT NULL, `icon8` bigint unsigned NOT NULL, `groupType` tinyint unsigned NOT NULL, `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '0', `masterLooterGuid` int unsigned NOT NULL, PRIMARY KEY (`guid`), KEY `leaderGuid` (`leaderGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Groups'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `groups` -- LOCK TABLES `groups` WRITE; /*!40000 ALTER TABLE `groups` DISABLE KEYS */; /*!40000 ALTER TABLE `groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild` -- DROP TABLE IF EXISTS `guild`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild` ( `guildid` int unsigned NOT NULL DEFAULT '0', `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `leaderguid` int unsigned NOT NULL DEFAULT '0', `EmblemStyle` tinyint unsigned NOT NULL DEFAULT '0', `EmblemColor` tinyint unsigned NOT NULL DEFAULT '0', `BorderStyle` tinyint unsigned NOT NULL DEFAULT '0', `BorderColor` tinyint unsigned NOT NULL DEFAULT '0', `BackgroundColor` tinyint unsigned NOT NULL DEFAULT '0', `info` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `motd` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `createdate` int unsigned NOT NULL DEFAULT '0', `BankMoney` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild` -- LOCK TABLES `guild` WRITE; /*!40000 ALTER TABLE `guild` DISABLE KEYS */; /*!40000 ALTER TABLE `guild` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_bank_eventlog` -- DROP TABLE IF EXISTS `guild_bank_eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_eventlog` ( `guildid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator', `LogGuid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column', `TabId` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Guild bank TabId', `EventType` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Event type', `PlayerGuid` int unsigned NOT NULL DEFAULT '0', `ItemOrMoney` int unsigned NOT NULL DEFAULT '0', `ItemStackCount` smallint unsigned NOT NULL DEFAULT '0', `DestTabId` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id', `TimeStamp` int unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`,`TabId`), KEY `guildid_key` (`guildid`), KEY `Idx_PlayerGuid` (`PlayerGuid`), KEY `Idx_LogGuid` (`LogGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_bank_eventlog` -- LOCK TABLES `guild_bank_eventlog` WRITE; /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_bank_item` -- DROP TABLE IF EXISTS `guild_bank_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_item` ( `guildid` int unsigned NOT NULL DEFAULT '0', `TabId` tinyint unsigned NOT NULL DEFAULT '0', `SlotId` tinyint unsigned NOT NULL DEFAULT '0', `item_guid` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`SlotId`), KEY `guildid_key` (`guildid`), KEY `Idx_item_guid` (`item_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_bank_item` -- LOCK TABLES `guild_bank_item` WRITE; /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_bank_right` -- DROP TABLE IF EXISTS `guild_bank_right`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_right` ( `guildid` int unsigned NOT NULL DEFAULT '0', `TabId` tinyint unsigned NOT NULL DEFAULT '0', `rid` tinyint unsigned NOT NULL DEFAULT '0', `gbright` tinyint unsigned NOT NULL DEFAULT '0', `SlotPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`rid`), KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_bank_right` -- LOCK TABLES `guild_bank_right` WRITE; /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_bank_tab` -- DROP TABLE IF EXISTS `guild_bank_tab`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_tab` ( `guildid` int unsigned NOT NULL DEFAULT '0', `TabId` tinyint unsigned NOT NULL DEFAULT '0', `TabName` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `TabIcon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `TabText` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`guildid`,`TabId`), KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_bank_tab` -- LOCK TABLES `guild_bank_tab` WRITE; /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_eventlog` -- DROP TABLE IF EXISTS `guild_eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_eventlog` ( `guildid` int unsigned NOT NULL COMMENT 'Guild Identificator', `LogGuid` int unsigned NOT NULL COMMENT 'Log record identificator - auxiliary column', `EventType` tinyint unsigned NOT NULL COMMENT 'Event type', `PlayerGuid1` int unsigned NOT NULL COMMENT 'Player 1', `PlayerGuid2` int unsigned NOT NULL COMMENT 'Player 2', `NewRank` tinyint unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', `TimeStamp` int unsigned NOT NULL COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`), KEY `Idx_PlayerGuid1` (`PlayerGuid1`), KEY `Idx_PlayerGuid2` (`PlayerGuid2`), KEY `Idx_LogGuid` (`LogGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild Eventlog'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_eventlog` -- LOCK TABLES `guild_eventlog` WRITE; /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_member` -- DROP TABLE IF EXISTS `guild_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_member` ( `guildid` int unsigned NOT NULL COMMENT 'Guild Identificator', `guid` int unsigned NOT NULL, `rank` tinyint unsigned NOT NULL, `pnote` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `offnote` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_member` -- LOCK TABLES `guild_member` WRITE; /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_member_withdraw` -- DROP TABLE IF EXISTS `guild_member_withdraw`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_member_withdraw` ( `guid` int unsigned NOT NULL, `tab0` int unsigned NOT NULL DEFAULT '0', `tab1` int unsigned NOT NULL DEFAULT '0', `tab2` int unsigned NOT NULL DEFAULT '0', `tab3` int unsigned NOT NULL DEFAULT '0', `tab4` int unsigned NOT NULL DEFAULT '0', `tab5` int unsigned NOT NULL DEFAULT '0', `money` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild Member Daily Withdraws'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_member_withdraw` -- LOCK TABLES `guild_member_withdraw` WRITE; /*!40000 ALTER TABLE `guild_member_withdraw` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_member_withdraw` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_rank` -- DROP TABLE IF EXISTS `guild_rank`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_rank` ( `guildid` int unsigned NOT NULL DEFAULT '0', `rid` tinyint unsigned NOT NULL, `rname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `rights` mediumint unsigned NOT NULL DEFAULT '0', `BankMoneyPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`rid`), KEY `Idx_rid` (`rid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_rank` -- LOCK TABLES `guild_rank` WRITE; /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `instance` -- DROP TABLE IF EXISTS `instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `instance` ( `id` int unsigned NOT NULL DEFAULT '0', `map` smallint unsigned NOT NULL DEFAULT '0', `resettime` bigint unsigned NOT NULL DEFAULT '0', `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `completedEncounters` int unsigned NOT NULL DEFAULT '0', `data` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `map` (`map`), KEY `resettime` (`resettime`), KEY `difficulty` (`difficulty`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `instance` -- LOCK TABLES `instance` WRITE; /*!40000 ALTER TABLE `instance` DISABLE KEYS */; /*!40000 ALTER TABLE `instance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `instance_reset` -- DROP TABLE IF EXISTS `instance_reset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `instance_reset` ( `mapid` smallint unsigned NOT NULL DEFAULT '0', `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `resettime` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`mapid`,`difficulty`), KEY `difficulty` (`difficulty`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `instance_reset` -- LOCK TABLES `instance_reset` WRITE; /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */; /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance` -- DROP TABLE IF EXISTS `item_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance` ( `guid` int unsigned NOT NULL DEFAULT '0', `itemEntry` mediumint unsigned NOT NULL DEFAULT '0', `owner_guid` int unsigned NOT NULL DEFAULT '0', `creatorGuid` int unsigned NOT NULL DEFAULT '0', `giftCreatorGuid` int unsigned NOT NULL DEFAULT '0', `count` int unsigned NOT NULL DEFAULT '1', `duration` int NOT NULL DEFAULT '0', `charges` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `flags` mediumint unsigned NOT NULL DEFAULT '0', `enchantments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `randomPropertyId` smallint NOT NULL DEFAULT '0', `durability` smallint unsigned NOT NULL DEFAULT '0', `playedTime` int unsigned NOT NULL DEFAULT '0', `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance` -- LOCK TABLES `item_instance` WRITE; /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_loot_items` -- DROP TABLE IF EXISTS `item_loot_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_loot_items` ( `container_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)', `item_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'loot item entry (item_instance.itemEntry)', `item_count` int NOT NULL DEFAULT '0' COMMENT 'stack size', `item_index` int unsigned NOT NULL DEFAULT '0', `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 NOT NULL DEFAULT '0' COMMENT 'random enchantment added when originally rolled', `rnd_suffix` int NOT NULL DEFAULT '0' COMMENT 'random suffix added when originally rolled' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_loot_items` -- LOCK TABLES `item_loot_items` WRITE; /*!40000 ALTER TABLE `item_loot_items` DISABLE KEYS */; /*!40000 ALTER TABLE `item_loot_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_loot_money` -- DROP TABLE IF EXISTS `item_loot_money`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_loot_money` ( `container_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)', `money` int unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)', PRIMARY KEY (`container_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_loot_money` -- LOCK TABLES `item_loot_money` WRITE; /*!40000 ALTER TABLE `item_loot_money` DISABLE KEYS */; /*!40000 ALTER TABLE `item_loot_money` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_refund_instance` -- DROP TABLE IF EXISTS `item_refund_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_refund_instance` ( `item_guid` int unsigned NOT NULL COMMENT 'Item GUID', `player_guid` int unsigned NOT NULL COMMENT 'Player GUID', `paidMoney` int unsigned NOT NULL DEFAULT '0', `paidExtendedCost` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`item_guid`,`player_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_refund_instance` -- LOCK TABLES `item_refund_instance` WRITE; /*!40000 ALTER TABLE `item_refund_instance` DISABLE KEYS */; /*!40000 ALTER TABLE `item_refund_instance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_soulbound_trade_data` -- DROP TABLE IF EXISTS `item_soulbound_trade_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_soulbound_trade_data` ( `itemGuid` int unsigned NOT NULL COMMENT 'Item GUID', `allowedPlayers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_soulbound_trade_data` -- LOCK TABLES `item_soulbound_trade_data` WRITE; /*!40000 ALTER TABLE `item_soulbound_trade_data` DISABLE KEYS */; /*!40000 ALTER TABLE `item_soulbound_trade_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `lag_reports` -- DROP TABLE IF EXISTS `lag_reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `lag_reports` ( `reportId` int unsigned NOT NULL AUTO_INCREMENT, `guid` int unsigned NOT NULL DEFAULT '0', `lagType` tinyint unsigned NOT NULL DEFAULT '0', `mapId` smallint 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 unsigned NOT NULL DEFAULT '0', `createTime` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`reportId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `lag_reports` -- LOCK TABLES `lag_reports` WRITE; /*!40000 ALTER TABLE `lag_reports` DISABLE KEYS */; /*!40000 ALTER TABLE `lag_reports` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `lfg_data` -- DROP TABLE IF EXISTS `lfg_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `lfg_data` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `dungeon` int unsigned NOT NULL DEFAULT '0', `state` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='LFG Data'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `lfg_data` -- LOCK TABLES `lfg_data` WRITE; /*!40000 ALTER TABLE `lfg_data` DISABLE KEYS */; /*!40000 ALTER TABLE `lfg_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mail` -- DROP TABLE IF EXISTS `mail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `messageType` tinyint unsigned NOT NULL DEFAULT '0', `stationery` tinyint NOT NULL DEFAULT '41', `mailTemplateId` smallint unsigned NOT NULL DEFAULT '0', `sender` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `receiver` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `has_items` tinyint unsigned NOT NULL DEFAULT '0', `expire_time` int unsigned NOT NULL DEFAULT '0', `deliver_time` int unsigned NOT NULL DEFAULT '0', `money` int unsigned NOT NULL DEFAULT '0', `cod` int unsigned NOT NULL DEFAULT '0', `checked` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_receiver` (`receiver`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Mail System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mail` -- LOCK TABLES `mail` WRITE; /*!40000 ALTER TABLE `mail` DISABLE KEYS */; /*!40000 ALTER TABLE `mail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mail_items` -- DROP TABLE IF EXISTS `mail_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail_items` ( `mail_id` int unsigned NOT NULL DEFAULT '0', `item_guid` int unsigned NOT NULL DEFAULT '0', `receiver` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', PRIMARY KEY (`item_guid`), KEY `idx_receiver` (`receiver`), KEY `idx_mail_id` (`mail_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mail_items` -- LOCK TABLES `mail_items` WRITE; /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */; /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pet_aura` -- DROP TABLE IF EXISTS `pet_aura`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_aura` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `casterGuid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', `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` mediumint NOT NULL, `amount1` mediumint NOT NULL, `amount2` mediumint NOT NULL, `base_amount0` mediumint NOT NULL, `base_amount1` mediumint NOT NULL, `base_amount2` mediumint NOT NULL, `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`,`spell`,`effectMask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pet_aura` -- LOCK TABLES `pet_aura` WRITE; /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */; /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pet_spell` -- DROP TABLE IF EXISTS `pet_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_spell` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `active` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pet_spell` -- LOCK TABLES `pet_spell` WRITE; /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */; /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pet_spell_cooldown` -- DROP TABLE IF EXISTS `pet_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_spell_cooldown` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `time` int unsigned NOT NULL DEFAULT '0', `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', `categoryEnd` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pet_spell_cooldown` -- LOCK TABLES `pet_spell_cooldown` WRITE; /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */; /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `petition` -- DROP TABLE IF EXISTS `petition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `petition` ( `ownerguid` int unsigned NOT NULL, `petitionguid` int unsigned DEFAULT '0', `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ownerguid`,`type`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `petition` -- LOCK TABLES `petition` WRITE; /*!40000 ALTER TABLE `petition` DISABLE KEYS */; /*!40000 ALTER TABLE `petition` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `petition_sign` -- DROP TABLE IF EXISTS `petition_sign`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `petition_sign` ( `ownerguid` int unsigned NOT NULL, `petitionguid` int unsigned NOT NULL DEFAULT '0', `playerguid` int unsigned NOT NULL DEFAULT '0', `player_account` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`petitionguid`,`playerguid`), KEY `Idx_playerguid` (`playerguid`), KEY `Idx_ownerguid` (`ownerguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `petition_sign` -- LOCK TABLES `petition_sign` WRITE; /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */; /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pool_quest_save` -- DROP TABLE IF EXISTS `pool_quest_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pool_quest_save` ( `pool_id` int unsigned NOT NULL DEFAULT '0', `quest_id` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`pool_id`,`quest_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pool_quest_save` -- LOCK TABLES `pool_quest_save` WRITE; /*!40000 ALTER TABLE `pool_quest_save` DISABLE KEYS */; /*!40000 ALTER TABLE `pool_quest_save` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pvpstats_battlegrounds` -- DROP TABLE IF EXISTS `pvpstats_battlegrounds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pvpstats_battlegrounds` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `winner_faction` tinyint NOT NULL, `bracket_id` tinyint unsigned NOT NULL, `type` tinyint unsigned NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pvpstats_battlegrounds` -- LOCK TABLES `pvpstats_battlegrounds` WRITE; /*!40000 ALTER TABLE `pvpstats_battlegrounds` DISABLE KEYS */; /*!40000 ALTER TABLE `pvpstats_battlegrounds` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pvpstats_players` -- DROP TABLE IF EXISTS `pvpstats_players`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pvpstats_players` ( `battleground_id` bigint unsigned NOT NULL, `character_guid` int unsigned NOT NULL, `winner` bit(1) NOT NULL, `score_killing_blows` mediumint unsigned NOT NULL, `score_deaths` mediumint unsigned NOT NULL, `score_honorable_kills` mediumint unsigned NOT NULL, `score_bonus_honor` mediumint unsigned NOT NULL, `score_damage_done` mediumint unsigned NOT NULL, `score_healing_done` mediumint unsigned NOT NULL, `attr_1` mediumint unsigned NOT NULL DEFAULT '0', `attr_2` mediumint unsigned NOT NULL DEFAULT '0', `attr_3` mediumint unsigned NOT NULL DEFAULT '0', `attr_4` mediumint unsigned NOT NULL DEFAULT '0', `attr_5` mediumint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`battleground_id`,`character_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pvpstats_players` -- LOCK TABLES `pvpstats_players` WRITE; /*!40000 ALTER TABLE `pvpstats_players` DISABLE KEYS */; /*!40000 ALTER TABLE `pvpstats_players` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `quest_tracker` -- DROP TABLE IF EXISTS `quest_tracker`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_tracker` ( `id` mediumint unsigned NOT NULL DEFAULT '0', `character_guid` int unsigned NOT NULL DEFAULT '0', `quest_accept_time` datetime NOT NULL, `quest_complete_time` datetime DEFAULT NULL, `quest_abandon_time` datetime DEFAULT NULL, `completed_by_gm` tinyint(1) NOT NULL DEFAULT '0', `core_hash` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `core_revision` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `quest_tracker` -- LOCK TABLES `quest_tracker` WRITE; /*!40000 ALTER TABLE `quest_tracker` DISABLE KEYS */; /*!40000 ALTER TABLE `quest_tracker` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reserved_name` -- DROP TABLE IF EXISTS `reserved_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reserved_name` ( `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player Reserved Names'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reserved_name` -- LOCK TABLES `reserved_name` WRITE; /*!40000 ALTER TABLE `reserved_name` DISABLE KEYS */; /*!40000 ALTER TABLE `reserved_name` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `respawn` -- DROP TABLE IF EXISTS `respawn`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `respawn` ( `type` smallint unsigned NOT NULL, `spawnId` int unsigned NOT NULL, `respawnTime` bigint unsigned NOT NULL, `mapId` smallint unsigned NOT NULL, `instanceId` int unsigned NOT NULL, PRIMARY KEY (`type`,`spawnId`,`instanceId`), KEY `idx_instance` (`instanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Stored respawn times'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `respawn` -- LOCK TABLES `respawn` WRITE; /*!40000 ALTER TABLE `respawn` DISABLE KEYS */; /*!40000 ALTER TABLE `respawn` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `updates` -- DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_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 unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of all applied updates in this database.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `updates` -- LOCK TABLES `updates` WRITE; /*!40000 ALTER TABLE `updates` DISABLE KEYS */; INSERT INTO `updates` VALUES ('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 21:44:15',0), ('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0), ('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0), ('2015_06_26_00_characters_335.sql','C2CC6E50AFA1ACCBEBF77CC519AAEB09F3BBAEBC','ARCHIVED','2015-07-13 23:49:22',0), ('2015_08_26_00_characters_335.sql','C7D6A3A00FECA3EBFF1E71744CA40D3076582374','ARCHIVED','2015-08-26 21:00:00',0), ('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0), ('2015_10_06_00_characters.sql','16842FDD7E8547F2260D3312F53EFF8761EFAB35','ARCHIVED','2015-10-06 16:06:38',0), ('2015_10_07_00_characters.sql','E15AB463CEBE321001D7BFDEA4B662FF618728FD','ARCHIVED','2015-10-07 23:32:00',0), ('2015_10_12_00_characters.sql','D6F9927BDED72AD0A81D6EC2C6500CBC34A39FA2','ARCHIVED','2015-10-12 15:35:47',0), ('2015_10_28_00_characters.sql','622A9CA8FCE690429EBE23BA071A37C7A007BF8B','ARCHIVED','2015-10-19 14:32:22',0), ('2015_10_29_00_characters_335.sql','4555A7F35C107E54C13D74D20F141039ED42943E','ARCHIVED','2015-10-29 17:05:43',0), ('2015_11_03_00_characters.sql','CC045717B8FDD9733351E52A5302560CD08AAD57','ARCHIVED','2015-10-12 15:23:33',0), ('2015_11_07_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 00:42:36',0), ('2016_02_10_00_characters.sql','F1B4DA202819CABC7319A4470A2D224A34609E97','ARCHIVED','2016-02-10 00:00:00',0), ('2016_03_13_2016_01_05_00_characters.sql','0EAD24977F40DE2476B4567DA2B477867CC0DA1A','ARCHIVED','2016-03-13 20:03:56',0), ('2016_04_11_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 03:18:17',0), ('2016_09_13_00_characters.sql','27A04615B11B2CFC3A26778F52F74C071E4F9C54','ARCHIVED','2016-07-06 18:55:18',0), ('2016_10_16_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-10-16 14:02:49',0), ('2016_10_30_00_characters.sql','7E2D5B226907B5A9AF320797F46E86DC27B7EC90','ARCHIVED','2016-10-30 00:00:00',0), ('2017_04_03_00_characters.sql','CB072C56692C9FBF170C4036F15773DD86D368B5','ARCHIVED','2017-04-03 00:00:00',0), ('2017_04_12_00_characters.sql','4FE3C6866A6DCD4926D451F6009464D290C2EF1F','ARCHIVED','2017-04-12 00:00:00',0), ('2017_04_12_01_characters.sql','5A8A1215E3A2356722F52CD7A64BBE03D21FBEA3','ARCHIVED','2017-04-12 00:00:00',0), ('2017_04_19_00_characters.sql','CE06FA9005C8A8EE4BDD925520278A5D83E87485','ARCHIVED','2017-04-19 00:07:40',0), ('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',0), ('2017_11_27_00_characters.sql','6FF1F84B8985ADFC7FF97F0BF8E53403CF13C320','ARCHIVED','2017-11-27 22:08:42',0), ('2018_01_13_00_characters.sql','E3C0DA9995BA71ED5A267294470CD03DC51862DD','ARCHIVED','2018-01-13 00:00:00',0), ('2018_02_19_00_characters.sql','FE5C5F9B88F0791549DDE680942493781E2269E6','ARCHIVED','2018-02-18 19:49:38',0), ('2018_04_24_00_characters.sql','77264AB7BEF421C0A4BB81EEAFD0D8C1CBCA840F','ARCHIVED','2018-04-20 09:38:10',0), ('2018_07_09_00_characters.sql','6F3EA22DD5E4CD9F9C60C4332B147E3DBF2E8A44','ARCHIVED','2018-07-09 18:19:18',0), ('2018_11_09_00_characters.sql','50429D68E6EBD1149CDA14A9EA642BC06A1FAE3D','ARCHIVED','2018-11-09 20:49:47',0), ('2019_03_19_00_characters.sql','1FD394E354CB9E854ABDC8CFD02329240AE07C3F','ARCHIVED','2019-03-19 07:17:45',0), ('2019_04_15_00_characters.sql','942FB57BF890E523B35B9BFEF3686CB0AA52B795','ARCHIVED','2019-04-15 06:16:09',0), ('2019_05_15_00_characters.sql','A12F21C8044C8BC8E2AA17F4C6CEB8B722CBC714','ARCHIVED','2019-05-15 06:13:20',0), ('2019_06_15_00_characters.sql','32DA6E004D7DD6EFFB0BB26238D17F6CC9E51DE6','ARCHIVED','2019-06-15 07:33:45',0), ('2019_07_14_00_characters.sql','A141F4F15BDF0320483921429871D4C572BD7E2D','ARCHIVED','2019-07-04 00:00:00',0), ('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 00:00:00',0), ('2019_07_15_01_characters.sql','5D383B026AB9EDE7114F249D206DE7E432E19468','ARCHIVED','2019-07-15 00:00:00',0), ('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0), ('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0), ('2019_09_15_00_characters.sql','75F3355AF6E9C0A2CAF5F523D87208C726C9D042','ARCHIVED','2019-09-15 09:21:36',0), ('2019_10_18_00_characters.sql','143669FB0AA803C7287A4FF4ABE85F45F63369E5','ARCHIVED','2019-10-18 08:37:37',0), ('2019_11_16_00_characters.sql','F29BBE2869E2187B278B27236A3D156B849F0E43','ARCHIVED','2019-11-16 12:06:06',0), ('2019_12_15_00_characters.sql','2EE449B59D56F884796B5D43C89B7C73DBF53939','ARCHIVED','2019-12-15 18:26:21',0), ('2020_01_15_00_characters.sql','CCA31041B25FC4BD631D07BB2E42B3C8F32465F0','ARCHIVED','2020-01-15 07:45:18',0), ('2020_02_15_00_characters.sql','645EDA60CDD479B3D1E78D2D89DAB5D6EA1FB7BC','ARCHIVED','2020-02-15 17:36:05',0), ('2020_03_16_00_characters.sql','A38437DA80F6A5D35958A09CFC74EE1CDC465BA8','ARCHIVED','2020-03-16 08:47:49',0), ('2020_04_15_00_characters.sql','61F7DE3B81C7E479FFF9463A39DF568826926F39','ARCHIVED','2020-04-15 11:03:56',0), ('2020_05_15_00_characters.sql','F1C2FECAA4EB623560914E7758E0BB8364CA135A','ARCHIVED','2020-05-15 08:55:56',0), ('2020_06_15_00_characters.sql','99C4F85580421E928003380D8F992C4EF5E627DF','ARCHIVED','2020-06-15 07:48:08',0), ('2020_07_15_00_characters.sql','D87627DC6E4D222F68A1F56F0B3B986EF9A590EF','ARCHIVED','2020-07-15 10:35:41',0), ('2020_08_15_00_characters.sql','70979D488ACD23DEB8E45D31C3ADC690A1B81F79','ARCHIVED','2020-08-15 09:34:44',0), ('2020_08_22_00_characters.sql','78251072C9281D98BC4EAC523DA0858C9F8425D9','ARCHIVED','2020-08-22 16:27:27',0), ('2020_09_02_00_characters.sql','627F320D58A42F401AB10ABA927F2B37C1981576','ARCHIVED','2020-09-02 17:41:04',0), ('2020_09_15_00_characters.sql','1B650E8C815E29AE261238B010BC9EB35BD49A25','ARCHIVED','2020-09-15 19:35:18',0), ('2020_09_27_00_characters.sql','441A0E8717165067D13B206F6925EEEA774262F3','ARCHIVED','2020-09-27 00:27:19',0), ('2020_10_15_00_characters.sql','72F769B6EFFA4C2C5E08235C89EF2629C0FA82EF','ARCHIVED','2020-10-15 07:33:14',0), ('2020_11_16_00_characters.sql','6389519BF44A6EC61E744E6A9727E9448337A276','ARCHIVED','2020-11-16 13:37:22',0), ('2020_12_15_00_characters.sql','650EE26F85517977FBDEB42CCB97CEFA6462502E','ARCHIVED','2020-12-15 22:47:26',0), ('2021_01_15_00_characters.sql','4D3A4C71ACD4CB04B014C300E1D0B33C0699DBE7','ARCHIVED','2021-01-15 08:29:32',0), ('2021_02_15_00_characters.sql','53D94CFC60329E7BD036B77D4B298785AF57AD79','ARCHIVED','2021-02-15 12:37:46',0), ('2021_03_15_00_characters.sql','D6274D688A3E2A4F727B565481D99A49E9C642D4','ARCHIVED','2021-03-15 17:31:39',0), ('2021_04_16_00_characters.sql','0EBBF50CE3EB1197973E403C2F1D60881BB497FD','ARCHIVED','2021-04-16 21:23:03',0), ('2021_05_14_00_characters.sql','9834A657E1E1F650E9A7E4E793BAB3E2AFF65293','ARCHIVED','2021-05-14 12:20:33',0), ('2021_06_15_00_characters.sql','4432846E2B0769C01E2B333EEDD90ABA44BF2BC1','ARCHIVED','2021-06-15 11:53:33',0), ('2021_07_15_00_characters.sql','2ACFF71253DEA0F059476AEA52A55196E6D5DCFE','ARCHIVED','2021-07-15 07:32:48',0), ('2021_07_18_00_characters.sql','0BA579ED21F4E75AC2B4797421B5029568B3F6E2','ARCHIVED','2021-07-18 11:55:00',0), ('2021_08_15_00_characters.sql','A8A32D47C65FB6A0C7995F8342D85B6A50C6C63F','ARCHIVED','2021-08-15 16:59:31',0), ('2021_09_28_00_characters.sql','A57869AE14FFFA935AB57318F65F4F1217AA2421','ARCHIVED','2021-09-28 20:48:10',0), ('2021_10_15_00_characters.sql','174355CFEA8FADA50B731F54E028561AFCF46AA6','ARCHIVED','2021-10-15 08:43:41',0), ('2021_11_15_00_characters.sql','4C911C08E2E7A22E9A2FFC0AAC05481574D8048E','ARCHIVED','2021-11-15 16:22:37',0), ('2021_12_16_00_characters.sql','C250DF213B43FC2186520C3901C0A1FBF522BBDF','ARCHIVED','2021-12-16 21:17:10',0), ('2022_01_15_00_characters.sql','351DEB60A6BB87FD9ED5D097E15ADBC32424C58A','ARCHIVED','2022-01-15 18:05:55',0), ('2022_02_16_00_characters.sql','3086FE1DB569830190013FE0129F9CF072C12D6A','ARCHIVED','2022-02-16 21:52:01',0), ('2022_04_14_00_characters.sql','FFFF611BE95F047CD853701136452BF8D28C3130','ARCHIVED','2022-04-14 16:24:35',0), ('2022_06_01_00_characters.sql','F33CA4F6F0A685CE1F42F0106269F3C39E31F1B0','ARCHIVED','2022-06-01 10:50:50',0), ('2022_08_15_00_characters.sql','B2468D3323AB51872385A0B36EF66688C4F661EA','ARCHIVED','2022-08-15 11:21:17',0), ('2022_10_17_00_characters.sql','3E50C54495FE2653EB2F5F9120B17D124D70CEDE','ARCHIVED','2022-10-17 09:02:28',0), ('2023_01_16_00_characters.sql','2667390C8E0EC1E5CDE16784BFCD8F8749C7D73E','ARCHIVED','2023-01-16 11:06:30',0), ('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','ARCHIVED','2023-01-16 14:51:30',0), ('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2023-02-05 15:58:32',0), ('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0), ('2023_06_14_00_characters.sql','0595B21DCFC0A04F2D8DF1F7BC018C758895DBE5','ARCHIVED','2023-06-14 19:34:24',0), ('2023_09_10_00_characters.sql','5DE09CA31B5168CF3622CB462816B6C598893D96','ARCHIVED','2023-09-10 12:23:34',0), ('2024_01_21_00_characters.sql','4D27D8DAC9F78795DB6938B54F32502EF8D8AAE6','ARCHIVED','2024-01-21 11:38:22',0), ('2024_02_05_00_characters.sql','1777CBCA822AD85777DA4A390DF7AAF41AF68EBD','ARCHIVED','2024-02-05 12:17:19',0), ('2024_04_10_00_characters.sql','E0D6E19ACE6759332402FA27C23B0F7745C49742','ARCHIVED','2024-04-10 16:07:02',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `updates_include` -- DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `updates_include` -- LOCK TABLES `updates_include` WRITE; /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */; INSERT INTO `updates_include` VALUES ('$/sql/custom/characters','RELEASED'), ('$/sql/old/3.3.5a/characters','ARCHIVED'), ('$/sql/updates/characters','RELEASED'); /*!40000 ALTER TABLE `updates_include` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `warden_action` -- DROP TABLE IF EXISTS `warden_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `warden_action` ( `wardenId` smallint unsigned NOT NULL, `action` tinyint unsigned DEFAULT NULL, PRIMARY KEY (`wardenId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `warden_action` -- LOCK TABLES `warden_action` WRITE; /*!40000 ALTER TABLE `warden_action` DISABLE KEYS */; /*!40000 ALTER TABLE `warden_action` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `worldstates` -- DROP TABLE IF EXISTS `worldstates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `worldstates` ( `entry` int unsigned NOT NULL DEFAULT '0', `value` int unsigned NOT NULL DEFAULT '0', `comment` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Variable Saves'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `worldstates` -- LOCK TABLES `worldstates` WRITE; /*!40000 ALTER TABLE `worldstates` DISABLE KEYS */; INSERT INTO `worldstates` VALUES (1,0,NULL), (2,0,NULL), (3,0,NULL), (4,0,NULL), (5,0,NULL), (6,0,NULL), (7,0,NULL), (8,0,NULL), (9,0,NULL), (10,0,NULL), (11,0,NULL), (12,0,NULL), (13,0,NULL), (14,0,NULL), (15,0,NULL), (16,0,NULL), (17,0,NULL), (18,0,NULL), (19,0,NULL), (20,0,NULL), (21,0,NULL), (22,0,NULL), (23,0,NULL), (24,0,NULL), (25,0,NULL), (26,0,NULL), (27,0,NULL), (28,0,NULL), (29,0,NULL), (30,0,NULL), (31,0,NULL), (32,0,NULL), (33,0,NULL), (34,0,NULL), (35,0,NULL), (36,0,NULL), (37,0,NULL), (38,0,NULL), (39,0,NULL), (40,0,NULL), (41,0,NULL), (42,0,NULL), (43,0,NULL), (44,0,NULL), (45,0,NULL), (46,0,NULL), (47,0,NULL), (48,0,NULL), (49,0,NULL), (50,0,NULL), (51,0,NULL), (52,0,NULL), (53,0,NULL), (54,0,NULL), (55,0,NULL), (56,0,NULL), (57,0,NULL), (58,0,NULL), (59,0,NULL), (60,0,NULL), (61,0,NULL), (62,0,NULL), (63,0,NULL), (64,0,NULL), (65,0,NULL), (66,0,NULL), (67,0,NULL), (68,0,NULL), (69,0,NULL), (3781,0,NULL), (3801,0,NULL), (3802,0,NULL), (20001,0,'NextArenaPointDistributionTime'), (20002,0,'NextWeeklyQuestResetTime'), (20003,0,'NextBGRandomDailyResetTime'), (20004,0,'cleaning_flags'), (20006,0,'NextGuildDailyResetTime'), (20007,0,'NextMonthlyQuestResetTime'), (20008,0,'NextDailyQuestResetTime'); /*!40000 ALTER TABLE `worldstates` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'characters' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-04-10 16:07:06