-- MySQL dump 10.13 Distrib 8.0.36, for Linux (x86_64) -- -- Host: localhost Database: characters -- ------------------------------------------------------ -- Server version 8.0.36-0ubuntu0.20.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` bigint 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 `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` bigint 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` bigint 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 `auction_bidders` -- DROP TABLE IF EXISTS `auction_bidders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auction_bidders` ( `auctionId` int unsigned NOT NULL, `playerGuid` bigint unsigned NOT NULL, PRIMARY KEY (`auctionId`,`playerGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auction_bidders` -- LOCK TABLES `auction_bidders` WRITE; /*!40000 ALTER TABLE `auction_bidders` DISABLE KEYS */; /*!40000 ALTER TABLE `auction_bidders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auction_items` -- DROP TABLE IF EXISTS `auction_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auction_items` ( `auctionId` int unsigned NOT NULL, `itemGuid` bigint unsigned NOT NULL, PRIMARY KEY (`auctionId`,`itemGuid`), UNIQUE KEY `idx_itemGuid` (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auction_items` -- LOCK TABLES `auction_items` WRITE; /*!40000 ALTER TABLE `auction_items` DISABLE KEYS */; /*!40000 ALTER TABLE `auction_items` 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', `auctionHouseId` int unsigned NOT NULL DEFAULT '0', `owner` bigint unsigned NOT NULL DEFAULT '0', `bidder` bigint unsigned NOT NULL DEFAULT '0', `minBid` bigint unsigned NOT NULL DEFAULT '0', `buyoutOrUnitPrice` bigint unsigned NOT NULL DEFAULT '0', `deposit` bigint unsigned NOT NULL DEFAULT '0', `bidAmount` bigint unsigned NOT NULL DEFAULT '0', `startTime` bigint NOT NULL DEFAULT '0', `endTime` bigint NOT NULL DEFAULT '0', `serverFlags` tinyint 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 `auctionhouse` -- LOCK TABLES `auctionhouse` WRITE; /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */; /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blackmarket_auctions` -- DROP TABLE IF EXISTS `blackmarket_auctions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blackmarket_auctions` ( `marketId` int NOT NULL DEFAULT '0', `currentBid` bigint unsigned NOT NULL DEFAULT '0', `time` bigint NOT NULL DEFAULT '0', `numBids` int NOT NULL DEFAULT '0', `bidder` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`marketId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blackmarket_auctions` -- LOCK TABLES `blackmarket_auctions` WRITE; /*!40000 ALTER TABLE `blackmarket_auctions` DISABLE KEYS */; /*!40000 ALTER TABLE `blackmarket_auctions` 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` ( `EventID` bigint unsigned NOT NULL DEFAULT '0', `Owner` bigint 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 '', `EventType` tinyint unsigned NOT NULL DEFAULT '4', `TextureID` int NOT NULL DEFAULT '-1', `Date` bigint NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', `LockDate` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`EventID`) ) 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` ( `InviteID` bigint unsigned NOT NULL DEFAULT '0', `EventID` bigint unsigned NOT NULL DEFAULT '0', `Invitee` bigint unsigned NOT NULL DEFAULT '0', `Sender` bigint unsigned NOT NULL DEFAULT '0', `Status` tinyint unsigned NOT NULL DEFAULT '0', `ResponseTime` bigint NOT NULL DEFAULT '0', `ModerationRank` tinyint unsigned NOT NULL DEFAULT '0', `Note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`InviteID`) ) 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_unicode_ci NOT NULL, `team` int unsigned NOT NULL, `announce` tinyint unsigned NOT NULL DEFAULT '1', `ownership` tinyint unsigned NOT NULL DEFAULT '1', `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bannedList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `lastUsed` bigint 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` bigint unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', `time` bigint 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` bigint unsigned NOT NULL, `achievement` int unsigned NOT NULL, `date` bigint 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` bigint unsigned NOT NULL, `criteria` int unsigned NOT NULL, `counter` bigint unsigned NOT NULL, `date` bigint 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` bigint unsigned NOT NULL DEFAULT '0', `spec` tinyint unsigned NOT NULL DEFAULT '0', `traitConfigId` int NOT NULL DEFAULT '0', `button` tinyint unsigned NOT NULL DEFAULT '0', `action` bigint unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spec`,`traitConfigId`,`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` bigint 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', `itemGuid` binary(16) NOT NULL, `spell` int unsigned NOT NULL, `effectMask` int unsigned NOT NULL, `recalculateMask` int unsigned NOT NULL DEFAULT '0', `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `stackCount` tinyint unsigned NOT NULL DEFAULT '1', `maxDuration` int NOT NULL DEFAULT '0', `remainTime` int NOT NULL DEFAULT '0', `remainCharges` tinyint unsigned NOT NULL DEFAULT '0', `castItemId` int unsigned NOT NULL DEFAULT '0', `castItemLevel` int NOT NULL DEFAULT '-1', 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_aura_effect` -- DROP TABLE IF EXISTS `character_aura_effect`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_aura_effect` ( `guid` bigint unsigned NOT NULL, `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', `itemGuid` binary(16) NOT NULL, `spell` int unsigned NOT NULL, `effectMask` int unsigned NOT NULL, `effectIndex` tinyint unsigned NOT NULL, `amount` int NOT NULL DEFAULT '0', `baseAmount` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`,`effectIndex`) ) 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_effect` -- LOCK TABLES `character_aura_effect` WRITE; /*!40000 ALTER TABLE `character_aura_effect` DISABLE KEYS */; /*!40000 ALTER TABLE `character_aura_effect` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_aura_stored_location` -- DROP TABLE IF EXISTS `character_aura_stored_location`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_aura_stored_location` ( `Guid` bigint unsigned NOT NULL COMMENT 'Global Unique Identifier of Player', `Spell` int unsigned NOT NULL COMMENT 'Spell Identifier', `MapId` int unsigned NOT NULL COMMENT 'Map Id', `PositionX` float NOT NULL COMMENT 'position x', `PositionY` float NOT NULL COMMENT 'position y', `PositionZ` float NOT NULL COMMENT 'position z', `Orientation` float NOT NULL COMMENT 'Orientation', 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_aura_stored_location` -- LOCK TABLES `character_aura_stored_location` WRITE; /*!40000 ALTER TABLE `character_aura_stored_location` DISABLE KEYS */; /*!40000 ALTER TABLE `character_aura_stored_location` 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `bandate` bigint NOT NULL DEFAULT '0', `unbandate` bigint 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` bigint 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', `queueId` bigint unsigned 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` bigint 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_cuf_profiles` -- DROP TABLE IF EXISTS `character_cuf_profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_cuf_profiles` ( `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Guid', `id` tinyint unsigned NOT NULL COMMENT 'Profile Id (0-4)', `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Profile Name', `frameHeight` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Height', `frameWidth` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Width', `sortBy` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Sort By', `healthText` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Health Text', `boolOptions` int unsigned NOT NULL DEFAULT '0' COMMENT 'Many Configurable Bool Options', `topPoint` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame top alignment', `bottomPoint` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame bottom alignment', `leftPoint` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame left alignment', `topOffset` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from top', `bottomOffset` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from bottom', `leftOffset` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from left', PRIMARY KEY (`guid`,`id`), KEY `index` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_cuf_profiles` -- LOCK TABLES `character_cuf_profiles` WRITE; /*!40000 ALTER TABLE `character_cuf_profiles` DISABLE KEYS */; /*!40000 ALTER TABLE `character_cuf_profiles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_currency` -- DROP TABLE IF EXISTS `character_currency`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_currency` ( `CharacterGuid` bigint unsigned NOT NULL DEFAULT '0', `Currency` smallint unsigned NOT NULL, `Quantity` int unsigned NOT NULL, `WeeklyQuantity` int unsigned NOT NULL, `TrackedQuantity` int unsigned NOT NULL, `IncreasedCapQuantity` int unsigned NOT NULL DEFAULT '0', `EarnedQuantity` int unsigned NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL, PRIMARY KEY (`CharacterGuid`,`Currency`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_currency` -- LOCK TABLES `character_currency` WRITE; /*!40000 ALTER TABLE `character_currency` DISABLE KEYS */; /*!40000 ALTER TABLE `character_currency` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_customizations` -- DROP TABLE IF EXISTS `character_customizations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_customizations` ( `guid` bigint unsigned NOT NULL, `chrCustomizationOptionID` int unsigned NOT NULL, `chrCustomizationChoiceID` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`chrCustomizationOptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_customizations` -- LOCK TABLES `character_customizations` WRITE; /*!40000 ALTER TABLE `character_customizations` DISABLE KEYS */; /*!40000 ALTER TABLE `character_customizations` 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` bigint 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` bigint 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', `AssignedSpecIndex` int NOT NULL DEFAULT '-1', `item0` bigint unsigned NOT NULL DEFAULT '0', `item1` bigint unsigned NOT NULL DEFAULT '0', `item2` bigint unsigned NOT NULL DEFAULT '0', `item3` bigint unsigned NOT NULL DEFAULT '0', `item4` bigint unsigned NOT NULL DEFAULT '0', `item5` bigint unsigned NOT NULL DEFAULT '0', `item6` bigint unsigned NOT NULL DEFAULT '0', `item7` bigint unsigned NOT NULL DEFAULT '0', `item8` bigint unsigned NOT NULL DEFAULT '0', `item9` bigint unsigned NOT NULL DEFAULT '0', `item10` bigint unsigned NOT NULL DEFAULT '0', `item11` bigint unsigned NOT NULL DEFAULT '0', `item12` bigint unsigned NOT NULL DEFAULT '0', `item13` bigint unsigned NOT NULL DEFAULT '0', `item14` bigint unsigned NOT NULL DEFAULT '0', `item15` bigint unsigned NOT NULL DEFAULT '0', `item16` bigint unsigned NOT NULL DEFAULT '0', `item17` bigint unsigned NOT NULL DEFAULT '0', `item18` bigint 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_favorite_auctions` -- DROP TABLE IF EXISTS `character_favorite_auctions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_favorite_auctions` ( `guid` bigint unsigned NOT NULL, `order` int unsigned NOT NULL DEFAULT '0', `itemId` int unsigned NOT NULL DEFAULT '0', `itemLevel` int unsigned NOT NULL DEFAULT '0', `battlePetSpeciesId` int unsigned NOT NULL DEFAULT '0', `suffixItemNameDescriptionId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_favorite_auctions` -- LOCK TABLES `character_favorite_auctions` WRITE; /*!40000 ALTER TABLE `character_favorite_auctions` DISABLE KEYS */; /*!40000 ALTER TABLE `character_favorite_auctions` 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` bigint 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_garrison` -- DROP TABLE IF EXISTS `character_garrison`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison` ( `guid` bigint unsigned NOT NULL, `siteLevelId` int unsigned NOT NULL DEFAULT '0', `followerActivationsRemainingToday` 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_garrison` -- LOCK TABLES `character_garrison` WRITE; /*!40000 ALTER TABLE `character_garrison` DISABLE KEYS */; /*!40000 ALTER TABLE `character_garrison` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_garrison_blueprints` -- DROP TABLE IF EXISTS `character_garrison_blueprints`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison_blueprints` ( `guid` bigint unsigned NOT NULL, `buildingId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`buildingId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_garrison_blueprints` -- LOCK TABLES `character_garrison_blueprints` WRITE; /*!40000 ALTER TABLE `character_garrison_blueprints` DISABLE KEYS */; /*!40000 ALTER TABLE `character_garrison_blueprints` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_garrison_buildings` -- DROP TABLE IF EXISTS `character_garrison_buildings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison_buildings` ( `guid` bigint unsigned NOT NULL, `plotInstanceId` int unsigned NOT NULL DEFAULT '0', `buildingId` int unsigned NOT NULL DEFAULT '0', `timeBuilt` bigint NOT NULL, `active` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`plotInstanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_garrison_buildings` -- LOCK TABLES `character_garrison_buildings` WRITE; /*!40000 ALTER TABLE `character_garrison_buildings` DISABLE KEYS */; /*!40000 ALTER TABLE `character_garrison_buildings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_garrison_follower_abilities` -- DROP TABLE IF EXISTS `character_garrison_follower_abilities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison_follower_abilities` ( `dbId` bigint unsigned NOT NULL, `abilityId` int unsigned NOT NULL, `slot` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`dbId`,`abilityId`,`slot`), CONSTRAINT `fk_foll_dbid` FOREIGN KEY (`dbId`) REFERENCES `character_garrison_followers` (`dbId`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_garrison_follower_abilities` -- LOCK TABLES `character_garrison_follower_abilities` WRITE; /*!40000 ALTER TABLE `character_garrison_follower_abilities` DISABLE KEYS */; /*!40000 ALTER TABLE `character_garrison_follower_abilities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_garrison_followers` -- DROP TABLE IF EXISTS `character_garrison_followers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison_followers` ( `dbId` bigint unsigned NOT NULL, `guid` bigint unsigned NOT NULL, `followerId` int unsigned NOT NULL, `quality` int unsigned NOT NULL DEFAULT '2', `level` int unsigned NOT NULL DEFAULT '90', `itemLevelWeapon` int unsigned NOT NULL DEFAULT '600', `itemLevelArmor` int unsigned NOT NULL DEFAULT '600', `xp` int unsigned NOT NULL DEFAULT '0', `currentBuilding` int unsigned NOT NULL DEFAULT '0', `currentMission` int unsigned NOT NULL DEFAULT '0', `status` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`dbId`), UNIQUE KEY `idx_guid_id` (`guid`,`followerId`), CONSTRAINT `fk_foll_owner` FOREIGN KEY (`guid`) REFERENCES `characters` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_garrison_followers` -- LOCK TABLES `character_garrison_followers` WRITE; /*!40000 ALTER TABLE `character_garrison_followers` DISABLE KEYS */; /*!40000 ALTER TABLE `character_garrison_followers` 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` bigint unsigned NOT NULL DEFAULT '0', `item_guid` bigint 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` bigint unsigned NOT NULL, `talentGroup` tinyint unsigned NOT NULL DEFAULT '0', `glyphId` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`talentGroup`,`glyphId`) ) 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` bigint 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', `orientation` 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_lock` -- DROP TABLE IF EXISTS `character_instance_lock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_instance_lock` ( `guid` bigint unsigned NOT NULL, `mapId` int unsigned NOT NULL, `lockId` int unsigned NOT NULL, `instanceId` int unsigned DEFAULT NULL, `difficulty` tinyint unsigned DEFAULT NULL, `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `completedEncountersMask` int unsigned DEFAULT NULL, `entranceWorldSafeLocId` int unsigned DEFAULT NULL, `expiryTime` bigint unsigned DEFAULT NULL, `extended` tinyint unsigned DEFAULT NULL, PRIMARY KEY (`guid`,`mapId`,`lockId`), UNIQUE KEY `uk_character_instanceId` (`guid`,`instanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_instance_lock` -- LOCK TABLES `character_instance_lock` WRITE; /*!40000 ALTER TABLE `character_instance_lock` DISABLE KEYS */; /*!40000 ALTER TABLE `character_instance_lock` 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `bag` bigint unsigned NOT NULL DEFAULT '0', `slot` tinyint unsigned NOT NULL DEFAULT '0', `item` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier', PRIMARY KEY (`item`), UNIQUE KEY `uk_location` (`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` bigint unsigned NOT NULL DEFAULT '0', `modelid` int unsigned DEFAULT '0', `CreatedBySpell` int 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` smallint NOT NULL DEFAULT '-1', `curhealth` int unsigned NOT NULL DEFAULT '1', `curmana` int unsigned NOT NULL DEFAULT '0', `savetime` int unsigned NOT NULL DEFAULT '0', `abdata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `specialization` smallint unsigned NOT NULL DEFAULT '0', 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_pvp_talent` -- DROP TABLE IF EXISTS `character_pvp_talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_pvp_talent` ( `guid` bigint unsigned NOT NULL, `talentId0` int unsigned NOT NULL, `talentId1` int unsigned NOT NULL, `talentId2` int unsigned NOT NULL, `talentId3` int unsigned NOT NULL, `talentGroup` tinyint unsigned NOT NULL 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_pvp_talent` -- LOCK TABLES `character_pvp_talent` WRITE; /*!40000 ALTER TABLE `character_pvp_talent` DISABLE KEYS */; /*!40000 ALTER TABLE `character_pvp_talent` 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` bigint unsigned NOT NULL DEFAULT '0', `quest` int unsigned NOT NULL DEFAULT '0', `status` tinyint unsigned NOT NULL DEFAULT '0', `explored` tinyint unsigned NOT NULL DEFAULT '0', `acceptTime` bigint NOT NULL DEFAULT '0', `endTime` bigint 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', `time` bigint 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` bigint 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_objectives` -- DROP TABLE IF EXISTS `character_queststatus_objectives`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_objectives` ( `guid` bigint unsigned NOT NULL DEFAULT '0', `quest` int unsigned NOT NULL DEFAULT '0', `objective` tinyint unsigned NOT NULL DEFAULT '0', `data` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`,`objective`) ) 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_objectives` -- LOCK TABLES `character_queststatus_objectives` WRITE; /*!40000 ALTER TABLE `character_queststatus_objectives` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_objectives` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_queststatus_objectives_criteria` -- DROP TABLE IF EXISTS `character_queststatus_objectives_criteria`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_objectives_criteria` ( `guid` bigint unsigned NOT NULL, `questObjectiveId` int unsigned NOT NULL, PRIMARY KEY (`guid`,`questObjectiveId`) ) 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_objectives_criteria` -- LOCK TABLES `character_queststatus_objectives_criteria` WRITE; /*!40000 ALTER TABLE `character_queststatus_objectives_criteria` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_objectives_criteria` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_queststatus_objectives_criteria_progress` -- DROP TABLE IF EXISTS `character_queststatus_objectives_criteria_progress`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_objectives_criteria_progress` ( `guid` bigint unsigned NOT NULL, `criteriaId` int unsigned NOT NULL, `counter` bigint unsigned NOT NULL, `date` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`criteriaId`) ) 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_objectives_criteria_progress` -- LOCK TABLES `character_queststatus_objectives_criteria_progress` WRITE; /*!40000 ALTER TABLE `character_queststatus_objectives_criteria_progress` DISABLE KEYS */; /*!40000 ALTER TABLE `character_queststatus_objectives_criteria_progress` 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` bigint 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` bigint 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', `completedTime` bigint 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_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` bigint 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` bigint 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` bigint unsigned NOT NULL COMMENT 'Global Unique Identifier', `skill` smallint unsigned NOT NULL, `value` smallint unsigned NOT NULL, `max` smallint unsigned NOT NULL, `professionSlot` tinyint NOT NULL DEFAULT '-1', 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `friend` bigint 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `spell` int 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_charges` -- DROP TABLE IF EXISTS `character_spell_charges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell_charges` ( `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier', `rechargeStart` bigint NOT NULL DEFAULT '0', `rechargeEnd` bigint NOT NULL DEFAULT '0', KEY `idx_guid` (`guid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_spell_charges` -- LOCK TABLES `character_spell_charges` WRITE; /*!40000 ALTER TABLE `character_spell_charges` DISABLE KEYS */; /*!40000 ALTER TABLE `character_spell_charges` 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', `spell` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `item` int unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', `time` bigint NOT NULL DEFAULT '0', `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', `categoryEnd` bigint 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_spell_favorite` -- DROP TABLE IF EXISTS `character_spell_favorite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell_favorite` ( `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `spell` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', 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_favorite` -- LOCK TABLES `character_spell_favorite` WRITE; /*!40000 ALTER TABLE `character_spell_favorite` DISABLE KEYS */; /*!40000 ALTER TABLE `character_spell_favorite` 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` bigint 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', `maxpower8` int unsigned NOT NULL DEFAULT '0', `maxpower9` int unsigned NOT NULL DEFAULT '0', `maxpower10` 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', `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', `mastery` float NOT NULL DEFAULT '0', `versatility` int 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` bigint unsigned NOT NULL, `talentId` int unsigned NOT NULL, `talentGroup` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`talentId`,`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 `character_trait_config` -- DROP TABLE IF EXISTS `character_trait_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_trait_config` ( `guid` bigint unsigned NOT NULL, `traitConfigId` int NOT NULL, `type` int NOT NULL, `chrSpecializationId` int DEFAULT NULL, `combatConfigFlags` int DEFAULT NULL, `localIdentifier` int DEFAULT NULL, `skillLineId` int DEFAULT NULL, `traitSystemId` int DEFAULT NULL, `name` varchar(260) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`,`traitConfigId`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_trait_config` -- LOCK TABLES `character_trait_config` WRITE; /*!40000 ALTER TABLE `character_trait_config` DISABLE KEYS */; /*!40000 ALTER TABLE `character_trait_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_trait_entry` -- DROP TABLE IF EXISTS `character_trait_entry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_trait_entry` ( `guid` bigint unsigned NOT NULL, `traitConfigId` int NOT NULL, `traitNodeId` int NOT NULL, `traitNodeEntryId` int NOT NULL, `rank` int NOT NULL DEFAULT '0', `grantedRanks` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`traitConfigId`,`traitNodeId`,`traitNodeEntryId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_trait_entry` -- LOCK TABLES `character_trait_entry` WRITE; /*!40000 ALTER TABLE `character_trait_entry` DISABLE KEYS */; /*!40000 ALTER TABLE `character_trait_entry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_transmog_outfits` -- DROP TABLE IF EXISTS `character_transmog_outfits`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_transmog_outfits` ( `guid` bigint NOT NULL DEFAULT '0', `setguid` bigint NOT NULL AUTO_INCREMENT, `setindex` tinyint unsigned NOT NULL DEFAULT '0', `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `iconname` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ignore_mask` int NOT NULL DEFAULT '0', `appearance0` int NOT NULL DEFAULT '0', `appearance1` int NOT NULL DEFAULT '0', `appearance2` int NOT NULL DEFAULT '0', `appearance3` int NOT NULL DEFAULT '0', `appearance4` int NOT NULL DEFAULT '0', `appearance5` int NOT NULL DEFAULT '0', `appearance6` int NOT NULL DEFAULT '0', `appearance7` int NOT NULL DEFAULT '0', `appearance8` int NOT NULL DEFAULT '0', `appearance9` int NOT NULL DEFAULT '0', `appearance10` int NOT NULL DEFAULT '0', `appearance11` int NOT NULL DEFAULT '0', `appearance12` int NOT NULL DEFAULT '0', `appearance13` int NOT NULL DEFAULT '0', `appearance14` int NOT NULL DEFAULT '0', `appearance15` int NOT NULL DEFAULT '0', `appearance16` int NOT NULL DEFAULT '0', `appearance17` int NOT NULL DEFAULT '0', `appearance18` int NOT NULL DEFAULT '0', `mainHandEnchant` int NOT NULL DEFAULT '0', `offHandEnchant` int 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_transmog_outfits` -- LOCK TABLES `character_transmog_outfits` WRITE; /*!40000 ALTER TABLE `character_transmog_outfits` DISABLE KEYS */; /*!40000 ALTER TABLE `character_transmog_outfits` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `character_void_storage` -- DROP TABLE IF EXISTS `character_void_storage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_void_storage` ( `itemId` bigint unsigned NOT NULL, `playerGuid` bigint unsigned NOT NULL, `itemEntry` int unsigned NOT NULL, `slot` tinyint unsigned NOT NULL, `creatorGuid` bigint unsigned NOT NULL DEFAULT '0', `randomBonusListId` int unsigned NOT NULL DEFAULT '0', `fixedScalingLevel` int unsigned DEFAULT '0', `artifactKnowledgeLevel` int unsigned DEFAULT '0', `context` tinyint unsigned NOT NULL DEFAULT '0', `bonusListIDs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`itemId`), UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`), KEY `idx_player` (`playerGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `character_void_storage` -- LOCK TABLES `character_void_storage` WRITE; /*!40000 ALTER TABLE `character_void_storage` DISABLE KEYS */; /*!40000 ALTER TABLE `character_void_storage` 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` bigint 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, `slot` tinyint unsigned NOT NULL DEFAULT '0', `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` bigint unsigned NOT NULL DEFAULT '0', `inventorySlots` tinyint unsigned NOT NULL DEFAULT '16', `bankSlots` tinyint unsigned NOT NULL DEFAULT '0', `restState` tinyint unsigned NOT NULL DEFAULT '0', `playerFlags` int unsigned NOT NULL DEFAULT '0', `playerFlagsEx` 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', `dungeonDifficulty` tinyint unsigned NOT NULL DEFAULT '1', `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '14', `legacyRaidDifficulty` tinyint unsigned NOT NULL DEFAULT '3', `orientation` float NOT NULL DEFAULT '0', `taximask` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `online` tinyint unsigned NOT NULL DEFAULT '0', `createTime` bigint NOT NULL DEFAULT '0', `createMode` tinyint 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` bigint 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` bigint NOT NULL DEFAULT '0', `numRespecs` tinyint unsigned NOT NULL DEFAULT '0', `primarySpecialization` 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` bigint unsigned NOT NULL DEFAULT '0', `extra_flags` smallint unsigned NOT NULL DEFAULT '0', `summonedPetNumber` int unsigned NOT NULL DEFAULT '0', `at_login` smallint unsigned NOT NULL DEFAULT '0', `zone` smallint unsigned NOT NULL DEFAULT '0', `death_expire_time` bigint NOT NULL DEFAULT '0', `taxi_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `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', `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', `power8` int unsigned NOT NULL DEFAULT '0', `power9` int unsigned NOT NULL DEFAULT '0', `power10` int unsigned NOT NULL DEFAULT '0', `latency` int unsigned NOT NULL DEFAULT '0', `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0', `lootSpecId` int unsigned NOT NULL DEFAULT '0', `exploredZones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `equipmentCache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `knownTitles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `actionBars` 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` bigint DEFAULT NULL, `honor` int unsigned NOT NULL DEFAULT '0', `honorLevel` int unsigned NOT NULL DEFAULT '1', `honorRestState` tinyint unsigned NOT NULL DEFAULT '2', `honorRestBonus` float NOT NULL DEFAULT '0', `lastLoginBuild` int unsigned NOT NULL DEFAULT '0', `personalTabardEmblemStyle` int NOT NULL DEFAULT '-1', `personalTabardEmblemColor` int NOT NULL DEFAULT '-1', `personalTabardBorderStyle` int NOT NULL DEFAULT '-1', `personalTabardBorderColor` int NOT NULL DEFAULT '-1', `personalTabardBackgroundColor` int NOT NULL DEFAULT '-1', 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` bigint 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', `displayId` int unsigned NOT NULL DEFAULT '0', `itemCache` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', `gender` tinyint 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 `corpse_customizations` -- DROP TABLE IF EXISTS `corpse_customizations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `corpse_customizations` ( `ownerGuid` bigint unsigned NOT NULL, `chrCustomizationOptionID` int unsigned NOT NULL, `chrCustomizationChoiceID` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ownerGuid`,`chrCustomizationOptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `corpse_customizations` -- LOCK TABLES `corpse_customizations` WRITE; /*!40000 ALTER TABLE `corpse_customizations` DISABLE KEYS */; /*!40000 ALTER TABLE `corpse_customizations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `corpse_phases` -- DROP TABLE IF EXISTS `corpse_phases`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `corpse_phases` ( `OwnerGuid` bigint unsigned NOT NULL DEFAULT '0', `PhaseId` int unsigned NOT NULL, PRIMARY KEY (`OwnerGuid`,`PhaseId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `corpse_phases` -- LOCK TABLES `corpse_phases` WRITE; /*!40000 ALTER TABLE `corpse_phases` DISABLE KEYS */; /*!40000 ALTER TABLE `corpse_phases` 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` bigint 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_bug` -- DROP TABLE IF EXISTS `gm_bug`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_bug` ( `id` int unsigned NOT NULL, `playerGuid` bigint unsigned NOT NULL, `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` bigint 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', `facing` float NOT NULL DEFAULT '0', `closedBy` bigint NOT NULL DEFAULT '0', `assignedTo` bigint 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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gm_bug` -- LOCK TABLES `gm_bug` WRITE; /*!40000 ALTER TABLE `gm_bug` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_bug` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gm_complaint` -- DROP TABLE IF EXISTS `gm_complaint`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_complaint` ( `id` int unsigned NOT NULL, `playerGuid` bigint unsigned NOT NULL, `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` bigint 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', `facing` float NOT NULL DEFAULT '0', `targetCharacterGuid` bigint unsigned NOT NULL, `reportType` int NOT NULL DEFAULT '0', `reportMajorCategory` int NOT NULL DEFAULT '0', `reportMinorCategoryFlags` int NOT NULL DEFAULT '0', `reportLineIndex` int NOT NULL, `closedBy` bigint NOT NULL DEFAULT '0', `assignedTo` bigint 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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gm_complaint` -- LOCK TABLES `gm_complaint` WRITE; /*!40000 ALTER TABLE `gm_complaint` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_complaint` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gm_complaint_chatlog` -- DROP TABLE IF EXISTS `gm_complaint_chatlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_complaint_chatlog` ( `complaintId` int unsigned NOT NULL, `lineId` int unsigned NOT NULL, `timestamp` bigint NOT NULL, `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`complaintId`,`lineId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gm_complaint_chatlog` -- LOCK TABLES `gm_complaint_chatlog` WRITE; /*!40000 ALTER TABLE `gm_complaint_chatlog` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_complaint_chatlog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gm_suggestion` -- DROP TABLE IF EXISTS `gm_suggestion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_suggestion` ( `id` int unsigned NOT NULL, `playerGuid` bigint unsigned NOT NULL, `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` bigint 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', `facing` float NOT NULL DEFAULT '0', `closedBy` bigint NOT NULL DEFAULT '0', `assignedTo` bigint 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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gm_suggestion` -- LOCK TABLES `gm_suggestion` WRITE; /*!40000 ALTER TABLE `gm_suggestion` DISABLE KEYS */; /*!40000 ALTER TABLE `gm_suggestion` 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` bigint 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` bigint unsigned NOT NULL, `lootMethod` tinyint unsigned NOT NULL, `looterGuid` bigint unsigned NOT NULL, `lootThreshold` tinyint unsigned NOT NULL, `icon1` binary(16) NOT NULL, `icon2` binary(16) NOT NULL, `icon3` binary(16) NOT NULL, `icon4` binary(16) NOT NULL, `icon5` binary(16) NOT NULL, `icon6` binary(16) NOT NULL, `icon7` binary(16) NOT NULL, `icon8` binary(16) NOT NULL, `groupType` smallint unsigned NOT NULL, `difficulty` tinyint unsigned NOT NULL DEFAULT '1', `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '14', `legacyRaidDifficulty` tinyint unsigned NOT NULL DEFAULT '3', `masterLooterGuid` bigint 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` bigint unsigned NOT NULL DEFAULT '0', `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `leaderguid` bigint 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(256) 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_achievement` -- DROP TABLE IF EXISTS `guild_achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_achievement` ( `guildId` bigint unsigned NOT NULL, `achievement` int unsigned NOT NULL, `date` bigint NOT NULL DEFAULT '0', `guids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`guildId`,`achievement`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_achievement` -- LOCK TABLES `guild_achievement` WRITE; /*!40000 ALTER TABLE `guild_achievement` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_achievement` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guild_achievement_progress` -- DROP TABLE IF EXISTS `guild_achievement_progress`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_achievement_progress` ( `guildId` bigint unsigned NOT NULL, `criteria` int unsigned NOT NULL, `counter` bigint unsigned NOT NULL, `date` bigint NOT NULL DEFAULT '0', `completedGuid` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildId`,`criteria`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guild_achievement_progress` -- LOCK TABLES `guild_achievement_progress` WRITE; /*!40000 ALTER TABLE `guild_achievement_progress` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_achievement_progress` 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` bigint 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` bigint unsigned NOT NULL DEFAULT '0', `ItemOrMoney` bigint unsigned NOT NULL DEFAULT '0', `ItemStackCount` smallint unsigned NOT NULL DEFAULT '0', `DestTabId` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id', `TimeStamp` bigint 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` bigint unsigned NOT NULL DEFAULT '0', `TabId` tinyint unsigned NOT NULL DEFAULT '0', `SlotId` tinyint unsigned NOT NULL DEFAULT '0', `item_guid` bigint 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` bigint unsigned NOT NULL DEFAULT '0', `TabId` tinyint unsigned NOT NULL DEFAULT '0', `rid` tinyint unsigned NOT NULL DEFAULT '0', `gbright` tinyint NOT NULL DEFAULT '0', `SlotPerDay` int 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` bigint 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` bigint 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` bigint unsigned NOT NULL COMMENT 'Player 1', `PlayerGuid2` bigint unsigned NOT NULL COMMENT 'Player 2', `NewRank` tinyint unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', `TimeStamp` bigint 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` bigint unsigned NOT NULL COMMENT 'Guild Identificator', `guid` bigint 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` bigint 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', `tab6` int unsigned NOT NULL DEFAULT '0', `tab7` int unsigned NOT NULL DEFAULT '0', `money` bigint 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_newslog` -- DROP TABLE IF EXISTS `guild_newslog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_newslog` ( `guildid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator', `LogGuid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column', `EventType` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Event type', `PlayerGuid` bigint unsigned NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', `Value` int unsigned NOT NULL DEFAULT '0', `TimeStamp` bigint NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`), 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_newslog` -- LOCK TABLES `guild_newslog` WRITE; /*!40000 ALTER TABLE `guild_newslog` DISABLE KEYS */; /*!40000 ALTER TABLE `guild_newslog` 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` bigint unsigned NOT NULL DEFAULT '0', `rid` tinyint unsigned NOT NULL, `RankOrder` tinyint unsigned NOT NULL DEFAULT '0', `rname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `rights` int 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` ( `instanceId` int unsigned NOT NULL, `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `completedEncountersMask` int unsigned DEFAULT NULL, `entranceWorldSafeLocId` int unsigned DEFAULT NULL, PRIMARY KEY (`instanceId`) ) 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 `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` bigint unsigned NOT NULL DEFAULT '0', `itemEntry` int unsigned NOT NULL DEFAULT '0', `owner_guid` bigint unsigned NOT NULL DEFAULT '0', `creatorGuid` bigint unsigned NOT NULL DEFAULT '0', `giftCreatorGuid` bigint 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` int unsigned NOT NULL DEFAULT '0', `enchantments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `randomBonusListId` int unsigned NOT NULL DEFAULT '0', `durability` smallint unsigned NOT NULL DEFAULT '0', `playedTime` int unsigned NOT NULL DEFAULT '0', `createTime` bigint NOT NULL DEFAULT '0', `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `battlePetSpeciesId` int unsigned NOT NULL DEFAULT '0', `battlePetBreedData` int unsigned NOT NULL DEFAULT '0', `battlePetLevel` smallint unsigned NOT NULL DEFAULT '0', `battlePetDisplayId` int unsigned NOT NULL DEFAULT '0', `context` tinyint unsigned NOT NULL DEFAULT '0', `bonusListIDs` 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_instance_artifact` -- DROP TABLE IF EXISTS `item_instance_artifact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_artifact` ( `itemGuid` bigint unsigned NOT NULL, `xp` bigint unsigned NOT NULL DEFAULT '0', `artifactAppearanceId` int unsigned NOT NULL DEFAULT '0', `artifactTierId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_artifact` -- LOCK TABLES `item_instance_artifact` WRITE; /*!40000 ALTER TABLE `item_instance_artifact` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_artifact` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance_artifact_powers` -- DROP TABLE IF EXISTS `item_instance_artifact_powers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_artifact_powers` ( `itemGuid` bigint unsigned NOT NULL, `artifactPowerId` int unsigned NOT NULL, `purchasedRank` tinyint unsigned DEFAULT '0', PRIMARY KEY (`itemGuid`,`artifactPowerId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_artifact_powers` -- LOCK TABLES `item_instance_artifact_powers` WRITE; /*!40000 ALTER TABLE `item_instance_artifact_powers` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_artifact_powers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance_azerite` -- DROP TABLE IF EXISTS `item_instance_azerite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_azerite` ( `itemGuid` bigint unsigned NOT NULL, `xp` bigint unsigned NOT NULL DEFAULT '0', `level` int unsigned NOT NULL DEFAULT '1', `knowledgeLevel` int unsigned NOT NULL DEFAULT '0', `selectedAzeriteEssences1specId` int unsigned DEFAULT '0', `selectedAzeriteEssences1azeriteEssenceId1` int unsigned DEFAULT '0', `selectedAzeriteEssences1azeriteEssenceId2` int unsigned DEFAULT '0', `selectedAzeriteEssences1azeriteEssenceId3` int unsigned DEFAULT '0', `selectedAzeriteEssences1azeriteEssenceId4` int unsigned DEFAULT '0', `selectedAzeriteEssences2specId` int unsigned DEFAULT '0', `selectedAzeriteEssences2azeriteEssenceId1` int unsigned DEFAULT '0', `selectedAzeriteEssences2azeriteEssenceId2` int unsigned DEFAULT '0', `selectedAzeriteEssences2azeriteEssenceId3` int unsigned DEFAULT '0', `selectedAzeriteEssences2azeriteEssenceId4` int unsigned DEFAULT '0', `selectedAzeriteEssences3specId` int unsigned DEFAULT '0', `selectedAzeriteEssences3azeriteEssenceId1` int unsigned DEFAULT '0', `selectedAzeriteEssences3azeriteEssenceId2` int unsigned DEFAULT '0', `selectedAzeriteEssences3azeriteEssenceId3` int unsigned DEFAULT '0', `selectedAzeriteEssences3azeriteEssenceId4` int unsigned DEFAULT '0', `selectedAzeriteEssences4specId` int unsigned DEFAULT '0', `selectedAzeriteEssences4azeriteEssenceId1` int unsigned DEFAULT '0', `selectedAzeriteEssences4azeriteEssenceId2` int unsigned DEFAULT '0', `selectedAzeriteEssences4azeriteEssenceId3` int unsigned DEFAULT '0', `selectedAzeriteEssences4azeriteEssenceId4` int unsigned DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_azerite` -- LOCK TABLES `item_instance_azerite` WRITE; /*!40000 ALTER TABLE `item_instance_azerite` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_azerite` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance_azerite_empowered` -- DROP TABLE IF EXISTS `item_instance_azerite_empowered`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_azerite_empowered` ( `itemGuid` bigint unsigned NOT NULL, `azeritePowerId1` int NOT NULL, `azeritePowerId2` int NOT NULL, `azeritePowerId3` int NOT NULL, `azeritePowerId4` int NOT NULL, `azeritePowerId5` int NOT NULL, PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_azerite_empowered` -- LOCK TABLES `item_instance_azerite_empowered` WRITE; /*!40000 ALTER TABLE `item_instance_azerite_empowered` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_azerite_empowered` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance_azerite_milestone_power` -- DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_azerite_milestone_power` ( `itemGuid` bigint unsigned NOT NULL, `azeriteItemMilestonePowerId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`,`azeriteItemMilestonePowerId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_azerite_milestone_power` -- LOCK TABLES `item_instance_azerite_milestone_power` WRITE; /*!40000 ALTER TABLE `item_instance_azerite_milestone_power` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_azerite_milestone_power` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance_azerite_unlocked_essence` -- DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_azerite_unlocked_essence` ( `itemGuid` bigint unsigned NOT NULL, `azeriteEssenceId` int unsigned NOT NULL DEFAULT '0', `rank` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`,`azeriteEssenceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_azerite_unlocked_essence` -- LOCK TABLES `item_instance_azerite_unlocked_essence` WRITE; /*!40000 ALTER TABLE `item_instance_azerite_unlocked_essence` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_azerite_unlocked_essence` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance_gems` -- DROP TABLE IF EXISTS `item_instance_gems`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_gems` ( `itemGuid` bigint unsigned NOT NULL, `gemItemId1` int unsigned NOT NULL DEFAULT '0', `gemBonuses1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `gemContext1` tinyint unsigned NOT NULL DEFAULT '0', `gemScalingLevel1` int unsigned NOT NULL DEFAULT '0', `gemItemId2` int unsigned NOT NULL DEFAULT '0', `gemBonuses2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `gemContext2` tinyint unsigned NOT NULL DEFAULT '0', `gemScalingLevel2` int unsigned NOT NULL DEFAULT '0', `gemItemId3` int unsigned NOT NULL DEFAULT '0', `gemBonuses3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `gemContext3` tinyint unsigned NOT NULL DEFAULT '0', `gemScalingLevel3` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_gems` -- LOCK TABLES `item_instance_gems` WRITE; /*!40000 ALTER TABLE `item_instance_gems` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_gems` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance_modifiers` -- DROP TABLE IF EXISTS `item_instance_modifiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_modifiers` ( `itemGuid` bigint unsigned NOT NULL, `fixedScalingLevel` int unsigned DEFAULT '0', `artifactKnowledgeLevel` int unsigned DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_modifiers` -- LOCK TABLES `item_instance_modifiers` WRITE; /*!40000 ALTER TABLE `item_instance_modifiers` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_modifiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_instance_transmog` -- DROP TABLE IF EXISTS `item_instance_transmog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_transmog` ( `itemGuid` bigint unsigned NOT NULL, `itemModifiedAppearanceAllSpecs` int NOT NULL DEFAULT '0', `itemModifiedAppearanceSpec1` int NOT NULL DEFAULT '0', `itemModifiedAppearanceSpec2` int NOT NULL DEFAULT '0', `itemModifiedAppearanceSpec3` int NOT NULL DEFAULT '0', `itemModifiedAppearanceSpec4` int NOT NULL DEFAULT '0', `itemModifiedAppearanceSpec5` int NOT NULL DEFAULT '0', `spellItemEnchantmentAllSpecs` int NOT NULL DEFAULT '0', `spellItemEnchantmentSpec1` int NOT NULL DEFAULT '0', `spellItemEnchantmentSpec2` int NOT NULL DEFAULT '0', `spellItemEnchantmentSpec3` int NOT NULL DEFAULT '0', `spellItemEnchantmentSpec4` int NOT NULL DEFAULT '0', `spellItemEnchantmentSpec5` int NOT NULL DEFAULT '0', `secondaryItemModifiedAppearanceAllSpecs` int NOT NULL DEFAULT '0', `secondaryItemModifiedAppearanceSpec1` int NOT NULL DEFAULT '0', `secondaryItemModifiedAppearanceSpec2` int NOT NULL DEFAULT '0', `secondaryItemModifiedAppearanceSpec3` int NOT NULL DEFAULT '0', `secondaryItemModifiedAppearanceSpec4` int NOT NULL DEFAULT '0', `secondaryItemModifiedAppearanceSpec5` int NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_instance_transmog` -- LOCK TABLES `item_instance_transmog` WRITE; /*!40000 ALTER TABLE `item_instance_transmog` DISABLE KEYS */; /*!40000 ALTER TABLE `item_instance_transmog` 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` bigint 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_bonus` int unsigned NOT NULL DEFAULT '0' COMMENT 'random bonus list added when originally rolled', `context` tinyint unsigned NOT NULL DEFAULT '0', `bonus_list_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Space separated list of bonus list ids', PRIMARY KEY (`container_id`,`item_id`) ) 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` bigint 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` bigint unsigned NOT NULL COMMENT 'Item GUID', `player_guid` bigint unsigned NOT NULL COMMENT 'Player GUID', `paidMoney` bigint 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` bigint 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 `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` bigint 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `receiver` bigint 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` bigint NOT NULL DEFAULT '0', `deliver_time` bigint NOT NULL DEFAULT '0', `money` bigint unsigned NOT NULL DEFAULT '0', `cod` bigint 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` bigint unsigned NOT NULL DEFAULT '0', `item_guid` bigint unsigned NOT NULL DEFAULT '0', `receiver` bigint 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; /*!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 COMMENT 'Global Unique Identifier', `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', `spell` int unsigned NOT NULL, `effectMask` int unsigned NOT NULL, `recalculateMask` int unsigned NOT NULL DEFAULT '0', `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `stackCount` tinyint unsigned NOT NULL DEFAULT '1', `maxDuration` int NOT NULL DEFAULT '0', `remainTime` int NOT NULL DEFAULT '0', `remainCharges` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`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_aura_effect` -- DROP TABLE IF EXISTS `pet_aura_effect`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_aura_effect` ( `guid` int unsigned NOT NULL COMMENT 'Global Unique Identifier', `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', `spell` int unsigned NOT NULL, `effectMask` int unsigned NOT NULL, `effectIndex` tinyint unsigned NOT NULL, `amount` int NOT NULL DEFAULT '0', `baseAmount` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`,`effectIndex`) ) 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_effect` -- LOCK TABLES `pet_aura_effect` WRITE; /*!40000 ALTER TABLE `pet_aura_effect` DISABLE KEYS */; /*!40000 ALTER TABLE `pet_aura_effect` 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` int 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_charges` -- DROP TABLE IF EXISTS `pet_spell_charges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_spell_charges` ( `guid` int unsigned NOT NULL, `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier', `rechargeStart` bigint NOT NULL DEFAULT '0', `rechargeEnd` bigint NOT NULL DEFAULT '0', KEY `idx_guid` (`guid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pet_spell_charges` -- LOCK TABLES `pet_spell_charges` WRITE; /*!40000 ALTER TABLE `pet_spell_charges` DISABLE KEYS */; /*!40000 ALTER TABLE `pet_spell_charges` 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` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `time` bigint NOT NULL DEFAULT '0', `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', `categoryEnd` bigint 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` bigint unsigned NOT NULL, `petitionguid` bigint unsigned DEFAULT '0', `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`ownerguid`), 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` bigint unsigned NOT NULL, `petitionguid` bigint unsigned NOT NULL DEFAULT '0', `playerguid` bigint unsigned NOT NULL DEFAULT '0', `player_account` int 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` int 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` bigint unsigned NOT NULL, `winner` bit(1) NOT NULL, `score_killing_blows` int unsigned NOT NULL, `score_deaths` int unsigned NOT NULL, `score_honorable_kills` int unsigned NOT NULL, `score_bonus_honor` int unsigned NOT NULL, `score_damage_done` int unsigned NOT NULL, `score_healing_done` int unsigned NOT NULL, `attr_1` int unsigned NOT NULL DEFAULT '0', `attr_2` int unsigned NOT NULL DEFAULT '0', `attr_3` int unsigned NOT NULL DEFAULT '0', `attr_4` int unsigned NOT NULL DEFAULT '0', `attr_5` int 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` int unsigned NOT NULL DEFAULT '0', `character_guid` bigint 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', PRIMARY KEY (`id`,`character_guid`) ) 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_unicode_ci NOT NULL DEFAULT '', 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` bigint unsigned NOT NULL, `respawnTime` bigint 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 ('2014_10_20_00_characters.sql','A5882DA0979CF4DAE33DA011EBAA006C24BE7230','ARCHIVED','2015-03-21 15:55:55',0), ('2014_10_23_00_characters.sql','E2AC4758133EE19B7F08464A445802154D1261C8','ARCHIVED','2015-03-21 15:55:55',0), ('2014_10_23_01_characters.sql','20029E6323D9773B32C34D84FFED1711CC60F09F','ARCHIVED','2015-03-21 15:55:55',0), ('2014_10_23_02_characters.sql','8A7A16886EE71E7ACDDB3DDA6D0ECAC2FD2FDCA8','ARCHIVED','2015-03-21 15:55:55',0), ('2014_10_24_00_characters.sql','D008FE81AE844FCA686439D6ECC5108FB0DD1EB9','ARCHIVED','2015-03-21 15:55:55',0), ('2014_10_25_00_characters.sql','A39C7BE46686B54776BDAB9D7A882D91EDEC51A4','ARCHIVED','2015-03-21 15:55:55',0), ('2014_10_26_00_characters.sql','C787954CC35FE34B4101FDE6527F14C027F4947C','ARCHIVED','2015-03-21 15:55:55',0), ('2014_11_12_00_characters.sql','B160BB2313F1BD5F3B076A5A9279DC10D4796E34','ARCHIVED','2015-03-21 15:55:55',0), ('2014_12_23_00_characters.sql','3D9D648B2387B357F4BD090B33F80682F7924882','ARCHIVED','2015-03-21 15:55:55',0), ('2014_12_28_00_characters.sql','5362922FF4483A336311D73082A5727309CD9219','ARCHIVED','2015-03-21 15:55:55',0), ('2014_12_31_00_characters.sql','498DDF2DD936CF156D74A8208DC93DCE9FCAB5AA','ARCHIVED','2015-03-21 15:55:55',0), ('2015_01_02_00_characters.sql','E5940BE836F253982E07930120422E598D08BDE1','ARCHIVED','2015-03-21 15:55:55',0), ('2015_01_10_00_characters.sql','30796056C8623699B2FE1BF626A19D38262E9284','ARCHIVED','2015-03-21 15:55:55',0), ('2015_01_16_00_characters.sql','96642760A54C8D799AAFE438049A63AA521656F2','ARCHIVED','2015-03-21 15:55:55',0), ('2015_01_27_00_characters.sql','EB710E3EB9F2CAFD84AB62CDC84E898403A80A4F','ARCHIVED','2015-03-21 15:55:55',0), ('2015_02_13_00_characters.sql','405BEB4ED207DC6076442A37EE2AFB1F21E274A0','ARCHIVED','2015-03-21 15:55:55',0), ('2015_02_13_01_characters.sql','35F582D4F33BF55D1685A1BA89273ED895FD09C5','ARCHIVED','2015-03-21 15:55:55',0), ('2015_02_17_00_characters.sql','8D21FC5A55BF8B55D6DCDCE5F02CF2B640230E94','ARCHIVED','2015-03-21 15:55:55',0), ('2015_03_10_00_characters.sql','E565B89B145C340067742DFF2DEF1B74F5F1BD4E','ARCHIVED','2015-03-21 15:55:55',0), ('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 15:55:55',0), ('2015_03_20_01_characters.sql','20BD68468C57FCF7E665B4DA185DCD52FACE8B3F','ARCHIVED','2015-03-21 15:55:55',0), ('2015_03_20_02_characters.sql','0296995DCD3676BA9AE6024CA7C91C5F39D927A3','ARCHIVED','2015-03-21 15:56:46',0), ('2015_03_29_00_characters.sql','95D6A46BB746A8BD3EE3FE2086DF1A07F7C33B92','ARCHIVED','2015-05-02 15:43:06',0), ('2015_04_21_00_characters.sql','F2032B9BF4EDA7EDE5065554724ED392FD91657D','ARCHIVED','2015-05-02 15:43:06',0), ('2015_04_28_00_characters.sql','949F62DB3A3461D420A1230ECF7A6A3ED6435703','ARCHIVED','2015-05-02 15:43:06',0), ('2015_05_08_00_characters.sql','0F14B7821618D1C872625B6EDDAA9A667B211167','ARCHIVED','2015-07-10 19:32:17',0), ('2015_05_22_00_characters.sql','65B82152413FAB23BE413656E59A486A74447FF7','ARCHIVED','2015-07-10 19:32:17',0), ('2015_07_08_00_characters.sql','DAB25360ACB5244C8F8E6214CF6BD97160588A5B','ARCHIVED','2015-07-10 19:32:17',0), ('2015_07_11_00_characters.sql','B421B6C0E57BD0FD587071358863D9DABF4BA849','ARCHIVED','2015-07-13 21:50:02',0), ('2015_07_12_00_characters.sql','E98E7FD61EF6426E7EDE8ED9AD8C15D8D7132589','ARCHIVED','2015-07-13 21:50:02',0), ('2015_07_28_00_characters.sql','0711BC3A658D189EF71B0CB68DCFF2E9B781C4A0','ARCHIVED','2015-07-29 16:23:56',0), ('2015_08_08_00_characters.sql','EA12BB2DC24FAF2300A96D0888A45BBEA158D5DC','ARCHIVED','2015-08-08 16:34:07',0), ('2015_08_12_00_characters.sql','4FD7F89FE5DA51D4E0C33E520719986AA3EBD31B','ARCHIVED','2015-08-12 12:35:20',0), ('2015_09_05_00_characters.sql','4C22BB29365BE4B6B95E64DAD84B63CA002304EA','ARCHIVED','2015-09-05 12:35:20',0), ('2015_09_09_00_characters.sql','AFC32E693BC17CFD9A17919FE5317B8FE337ACAD','ARCHIVED','2015-09-09 12:35:20',0), ('2015_09_10_00_characters.sql','4555A7F35C107E54C13D74D20F141039ED42943E','ARCHIVED','2015-09-10 22:50:42',0), ('2015_10_16_00_characters.sql','E3A3FFF0CB42F04A8DCF0CE4362143C16E2083AF','ARCHIVED','2015-10-15 21:54:11',0), ('2015_11_06_00_characters_2015_10_12_00.sql','D6F9927BDED72AD0A81D6EC2C6500CBC34A39FA2','ARCHIVED','2015-11-06 23:43:27',0), ('2015_11_08_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2015-11-08 00:51:45',0), ('2015_11_23_00_characters.sql','9FC828E9E48E8E2E9B99A5A0073D6614C5BFC6B5','ARCHIVED','2015-11-22 23:27:34',0), ('2016_01_05_00_characters.sql','0EAD24977F40DE2476B4567DA2B477867CC0DA1A','ARCHIVED','2016-01-04 23:07:40',0), ('2016_04_05_00_characters_2016_02_10_00_characters.sql','F1B4DA202819CABC7319A4470A2D224A34609E97','ARCHIVED','2016-04-05 20:34:41',0), ('2016_04_11_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 02:24:14',0), ('2016_04_11_01_characters.sql','CA90F6D99C1EEA7B25BD58BC8368A8D78234BBEF','ARCHIVED','2016-04-11 18:14:18',0), ('2016_05_07_00_characters.sql','D1DB5557B21A552C935564D829B4E98B98149077','ARCHIVED','2016-05-07 00:00:00',0), ('2016_05_26_00_characters.sql','4179ADC32B96FD8D7D4CF5509A470B1ACE00BE85','ARCHIVED','2016-05-26 17:06:16',0), ('2016_07_16_00_characters.sql','EF267FCB92B383FFB33C700508EAF3FBC1F8AC23','ARCHIVED','2016-07-16 14:45:12',0), ('2016_07_19_00_characters.sql','AA2C516FA81B451071EA82F58F447E9D13E5D1BD','ARCHIVED','2016-07-19 14:36:25',0), ('2016_07_19_01_characters.sql','E9AF46AF4C7CC2E2779E44254AEEDF880D020166','ARCHIVED','2016-07-19 14:36:25',0), ('2016_07_19_02_characters.sql','5B1B334449996F3639C9226F587129E03DC4BF6D','ARCHIVED','2016-07-19 14:36:26',0), ('2016_07_19_03_characters.sql','7787C8A67D720492FED4BF60ADB22D3CDE1C536D','ARCHIVED','2016-07-19 14:36:26',0), ('2016_07_19_04_characters.sql','6D4B536094367AC9EF7CDFF41A4F96EB00B25EE5','ARCHIVED','2016-07-19 14:36:26',0), ('2016_07_19_05_characters.sql','12639268DC5F78CE900B59D5C646B10D70842928','ARCHIVED','2016-07-19 14:36:27',0), ('2016_07_19_06_characters.sql','9F5A4B533E6BFBAA718DE5160E1FDCB8471A88BF','ARCHIVED','2016-07-19 14:36:28',0), ('2016_07_19_07_characters.sql','1E8273FFD4340CBD7BB71D2406E23E9EF7230CFA','ARCHIVED','2016-07-19 14:36:29',0), ('2016_07_19_08_characters.sql','FB41FD2F8A7114FEE154021A9D47488C4B12E2A9','ARCHIVED','2016-07-19 14:36:29',0), ('2016_08_15_00_characters.sql','BF0B5F453384210CD77C54E262A19B888AAA4095','ARCHIVED','2016-08-14 18:14:32',0), ('2016_08_25_00_characters.sql','4AD506C3FCE54238EF452AC07EC562BD41A9D50C','ARCHIVED','2016-08-25 22:54:11',0), ('2016_10_17_00_characters.sql','A0EF594CD73690D46A46031137DB0E895F079235','ARCHIVED','2016-10-16 16:33:05',0), ('2016_10_25_00_characters.sql','CC894484561CE138C10B69D34F7831CEDFAF496B','ARCHIVED','2016-10-25 17:19:35',0), ('2016_11_06_00_characters.sql','C7EC8B65C1BE7722C53BAB79C52C1549054178C0','ARCHIVED','2016-11-06 23:05:44',0), ('2016_12_09_00_characters.sql','2A68E4187CE7F7294CBC3804AC39F48B2727E64E','ARCHIVED','2016-12-09 18:38:46',0), ('2016_12_26_00_characters.sql','D265DE655DDBFC13E2FA1EB021A435A21189B6E4','ARCHIVED','2016-12-26 18:45:15',0), ('2017_01_22_00_characters.sql','62B08B5FB1DA7B207C74DC000C42517A2D6F6BCC','ARCHIVED','2017-01-22 02:06:31',0), ('2017_01_29_00_characters.sql','E7475DCC13A0910FF23BF0EFB731629950A73A0D','ARCHIVED','2017-01-29 15:00:00',0), ('2017_02_26_00_characters_2016_09_13_00_characters.sql','2EF7AD507D097ABC74FF1E98A65BEC03B12E51C6','ARCHIVED','2017-02-26 19:57:47',0), ('2017_04_15_00_characters.sql','F118BA33CD7DDF2EE5673C6749C2965EFFF53C23','ARCHIVED','2017-04-15 12:10:50',0), ('2017_04_19_00_characters.sql','5A36FD9015ED024BC085F995F72DC81B47CD1093','ARCHIVED','2017-04-18 23:16:18',0), ('2017_05_08_00_characters.sql','86B5603EEBE1DE0EA56DBB264257967CFE583F46','ARCHIVED','2017-05-08 23:54:40',0), ('2017_05_14_00_characters.sql','3452261F366BFE76BB59C0AAA674FA1513042899','ARCHIVED','2017-05-14 17:29:04',0), ('2017_05_24_00_characters.sql','02701BF57589CD41456A748AEF425CBB2D3E6AD7','ARCHIVED','2017-05-24 22:00:00',0), ('2017_06_04_00_characters.sql','BC80D2B7515CC6E01701070D2DA466727F36DB5E','ARCHIVED','2017-06-04 14:43:26',0), ('2017_08_20_00_characters.sql','8C5BBF6AEAA6C7DE2F40A7D3878C8187A4729F13','ARCHIVED','2017-08-20 17:00:00',0), ('2017_08_20_01_characters.sql','2F50D5E6BF3888B8C5270D79228A1D0601FAFF1D','ARCHIVED','2017-08-20 17:52:21',0), ('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',0), ('2018_02_03_00_characters.sql','73E9BFD848D7A22F2A7DD89CF64E30E3A8689512','ARCHIVED','2018-02-03 23:52:42',0), ('2018_02_08_00_characters.sql','75FA162A9B85D678B26F972371265F1EC2C75187','ARCHIVED','2018-02-08 22:23:28',0), ('2018_02_19_00_characters.sql','75A0FFAFD0633921708DB0F72F9CC9796ACB960B','ARCHIVED','2018-02-19 22:33:32',0), ('2018_03_04_00_characters.sql','2A4CD2EE2547E718490706FADC78BF36F0DED8D6','ARCHIVED','2018-03-04 18:15:24',0), ('2018_04_28_00_characters.sql','CBD0FDC0F32DE3F456F7CE3D9CAD6933CD6A50F5','ARCHIVED','2018-04-28 12:44:09',0), ('2018_07_28_00_characters.sql','31F66AE7831251A8915625EC7F10FA138AB8B654','ARCHIVED','2018-07-28 18:30:19',0), ('2018_07_31_00_characters.sql','7DA8D4A4534520B23E6F5BBD5B8EE205B799C798','ARCHIVED','2018-07-31 20:54:39',0), ('2018_12_09_00_characters.sql','7FE9641C93ED762597C08F1E9B6649C9EC2F0E47','ARCHIVED','2018-09-18 23:34:29',0), ('2018_12_09_01_characters.sql','C80B936AAD94C58A0F33382CED08CFB4E0B6AC34','ARCHIVED','2018-10-10 22:05:28',0), ('2018_12_09_02_characters.sql','DBBA0C06985CE8AC4E6E7E94BD6B2673E9ADFAE2','ARCHIVED','2018-12-02 17:32:31',0), ('2019_06_08_00_characters.sql','6C5AF52AEF03BC019B96E7A07592C22660F9327B','ARCHIVED','2019-06-03 20:04:47',0), ('2019_06_08_01_characters.sql','55076AFAF4B55DB4E34029C269EE0C84315C31BA','ARCHIVED','2019-06-04 22:11:47',0), ('2019_06_25_00_characters.sql','B8CBF79DEE02B40B01424327D31E52C70335BEC6','ARCHIVED','2019-06-25 22:40:37',0), ('2019_07_15_00_characters.sql','E1C77F604FB2A2FE8B32258CD0C9EC71BEA4F0FF','ARCHIVED','2019-06-25 22:40:37',0), ('2019_10_26_00_characters.sql','F1090ACDEB876A7BB5ED8829373F6305A217949A','ARCHIVED','2019-10-25 23:04:42',0), ('2019_10_26_01_characters.sql','59D5860930D02AB77D2AAA704C564957A9143760','ARCHIVED','2019-10-26 22:04:46',0), ('2019_11_03_00_characters.sql','DC789597F85B890E9A7901B4443DAD9CAEE2A02A','ARCHIVED','2019-11-03 14:13:27',0), ('2019_11_12_00_characters.sql','D4C642B4D48DAE9F56329BDE51C258323A132A91','ARCHIVED','2019-11-12 16:31:29',0), ('2019_11_22_00_characters.sql','95DFA71DBD75542C098CD86E9C0051C9690902F0','ARCHIVED','2019-11-20 15:10:12',0), ('2019_11_30_00_characters.sql','D0678E62B651AECA60C2DD6989BF80BD999AD12B','ARCHIVED','2019-11-29 22:42:01',0), ('2019_12_05_00_characters.sql','EA381C9634A5646A3168F15DF4E06A708A622762','ARCHIVED','2019-12-05 20:56:58',0), ('2020_02_17_00_characters.sql','E1519A81D35F19B48B3C75A83A270CB4BA0B84F2','ARCHIVED','2020-02-17 21:55:17',0), ('2020_04_20_00_characters.sql','977B5E0C894E0A7E80B2A9626F17CA636A69BD22','ARCHIVED','2020-04-20 19:08:18',0), ('2020_04_24_00_characters.sql','85E2E0395A9457A53D73A9E0A7BB39B7E4C429BF','ARCHIVED','2020-04-24 22:04:59',0), ('2020_04_25_00_characters_2017_04_03_00_characters.sql','00FA3EFADAF807AC96619A3FE47216E21C3FCB19','ARCHIVED','2020-04-25 00:00:00',0), ('2020_04_26_00_characters_2017_04_12_00_characters.sql','86AA94DA9B1EA283101100886C10F648C0CE6494','ARCHIVED','2020-04-26 00:00:00',0), ('2020_04_26_01_characters_2017_04_12_01_characters.sql','5A8A1215E3A2356722F52CD7A64BBE03D21FBEA3','ARCHIVED','2020-04-26 00:00:00',0), ('2020_06_12_00_characters.sql','DF16C99EFACA4DFADDDF35644AAC63F9B4AA2BD6','ARCHIVED','2020-06-11 16:24:56',0), ('2020_06_17_00_characters.sql','C3EE0D751E4B97CDF15F3BE27AAAE3646514A358','ARCHIVED','2020-06-17 17:04:56',0), ('2020_08_14_00_characters.sql','355685FF86EE64E2ED9D4B7D1311D53A9C2E0FA5','ARCHIVED','2020-08-14 21:41:24',0), ('2020_10_20_00_characters.sql','744F2A36865761920CE98A6DDE3A3BADF44D1E77','ARCHIVED','2020-10-20 21:36:49',0), ('2020_11_16_00_characters.sql','33D5C7539E239132923D01F4B6EAD5F3EF3EEB69','ARCHIVED','2020-11-16 19:16:31',0), ('2020_12_13_00_characters.sql','6AC743240033DED2C402ECB894A59D79EF607920','ARCHIVED','2020-12-13 18:36:58',0), ('2021_03_27_00_characters_aura_stored_location.sql','BF772ABC2DF186AF0A5DC56D5E824A2F4813BA69','ARCHIVED','2021-03-27 15:53:04',0), ('2021_04_05_00_characters.sql','33D656995E0F3578FFE1A658ED1692CA5310AB30','ARCHIVED','2021-04-05 23:44:54',0), ('2021_05_10_00_characters.sql','0A406242BC18BDA5A65CDE3E2AFEE760D79F819F','ARCHIVED','2021-05-10 23:30:34',0), ('2021_05_11_00_characters.sql','C3F0337CE8363F970AB4FDB9D23BBB7C650A0B0E','ARCHIVED','2021-05-11 15:39:26',0), ('2021_07_04_00_characters.sql','E0E7AD664DDB553E96B457DD9ED8976665E94007','ARCHIVED','2021-07-04 22:23:24',0), ('2021_08_11_00_characters.sql','2137A52A45B045104B97D39626CE3C0214625B17','ARCHIVED','2021-08-11 21:48:57',0), ('2021_08_18_00_characters.sql','5BA1326EE8EC907CDE82E6E8BCB38EA2E661F10A','ARCHIVED','2021-08-18 15:14:17',0), ('2021_10_02_00_characters.sql','31CEACE4E9A4BE58A659A2BDE4A7C51D2DB8AC41','ARCHIVED','2021-10-02 21:21:37',0), ('2021_10_02_01_characters.sql','F97B956F3B5F909294CA399F75B5795A07C4D8EC','ARCHIVED','2021-10-02 21:47:38',0), ('2021_10_15_00_characters.sql','906FECD65CBA7C406969F45FDF28DDEF8AAF8715','ARCHIVED','2021-10-15 10:11:47',0), ('2021_10_16_00_characters.sql','B5A31BB6FBC34512767475EDF13099DEC948EBB7','ARCHIVED','2021-10-16 01:12:20',0), ('2021_11_02_00_characters.sql','A3C0A6DA70CC70803C80685E4E2ED6255156520A','ARCHIVED','2021-11-02 18:11:13',0), ('2021_11_04_00_characters.sql','ED533235ADAD174F91A6B8E51D1046243B78B46D','ARCHIVED','2021-11-04 21:53:04',0), ('2021_11_17_00_characters.sql','03A0AB8ECD8BE5D818D41A8A610097C94A9C7DB9','ARCHIVED','2021-11-17 13:23:17',0), ('2021_12_16_00_characters_2019_07_14_00_characters.sql','DC1A3D3311FCF9106B4D91F8D2C5B893AD66C093','ARCHIVED','2021-12-16 01:06:53',0), ('2021_12_16_01_characters_2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2021-12-16 20:16:25',0), ('2021_12_23_00_characters.sql','7F2BD7CA61CD28D74AD9CA9F06FD7E542837ED3F','ARCHIVED','2021-12-23 19:16:29',0), ('2021_12_31_00_characters.sql','7ECEEB66056C46F89E581ACBB5EC222CB2D8A365','ARCHIVED','2021-12-31 13:53:23',0), ('2021_12_31_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2021-12-31 15:58:32',0), ('2021_12_31_02_characters.sql','C66A367F0AD7A9D6837238C21E91298413BD960C','ARCHIVED','2021-12-31 16:10:30',0), ('2022_01_02_00_characters.sql','5169A5BBACB42E6CEDE405D3C4843FD386CDF92E','ARCHIVED','2022-01-02 21:22:35',0), ('2022_01_09_00_characters.sql','3AC51F589821C17027CBA861EF762A709430CDB3','ARCHIVED','2022-01-09 21:29:45',0), ('2022_01_15_00_characters.sql','884EFB6592DC8A765E0C0BF8BF907B4E4733BB0C','ARCHIVED','2022-01-15 23:24:58',0), ('2022_01_31_00_characters.sql','19551474AA6079F0616B565F254914C5DD9ED1A1','ARCHIVED','2022-01-31 14:32:49',0), ('2022_01_31_01_characters.sql','E0A1FA670F4621AEB594D7ACBA4921CB298F54FF','ARCHIVED','2022-01-31 20:47:59',0), ('2022_01_31_02_characters.sql','6E3A3F02276287DD540BC4C17E246DFB850260D8','ARCHIVED','2022-01-31 21:43:38',0), ('2022_02_28_00_characters_2020_09_27_00_characters.sql','2292A1ED0E7F46DEC41384F75FA6D9461464EEB8','ARCHIVED','2022-02-28 12:43:58',0), ('2022_03_06_00_characters.sql','474AAF9D03E6A56017899C968DC9875368301934','ARCHIVED','2022-03-06 15:12:24',0), ('2022_03_11_00_characters_2021_07_18_00_characters.sql','0BA579ED21F4E75AC2B4797421B5029568B3F6E2','ARCHIVED','2022-03-11 18:56:07',0), ('2022_06_01_00_characters.sql','582AC6E256F8365F83AB70BA165CCC8B218E19FF','ARCHIVED','2022-06-01 21:16:56',0), ('2022_07_03_00_characters.sql','D3F04078C0846BCF7C8330AC20C39B8C3AEE7002','ARCHIVED','2022-07-03 23:37:24',0), ('2022_07_14_00_characters.sql','2EAD57D77FC39F6678F2D2A7D9C24046E6B836D8','ARCHIVED','2022-07-14 21:44:35',0), ('2022_07_25_00_characters.sql','3159BB2F3C346A7881920AB2B1F8108247CF13EE','ARCHIVED','2022-07-25 18:44:10',0), ('2022_08_19_00_characters.sql','1C076A24F2B48F32E8EF835C01F8907CA9E86491','ARCHIVED','2022-08-19 23:43:01',0), ('2022_08_21_00_characters.sql','1D75688392FBDA18CD8494F32CF682DCB49642EC','ARCHIVED','2022-08-21 00:02:03',0), ('2022_09_18_00_characters.sql','A7DF0C1F0E074F3E63A6CDD0AF873A1F3DC33B29','ARCHIVED','2022-09-18 21:48:42',0), ('2022_10_03_00_characters.sql','7B062787230D9158A622EB4AFE7FA6D18AB47BB3','ARCHIVED','2022-10-03 22:32:58',0), ('2022_10_03_01_characters.sql','7CF58BD9CC366301CC992017028568C8774C4BC2','ARCHIVED','2022-10-03 22:36:38',0), ('2022_10_03_02_characters.sql','33135AB3132943F15F4849A16EC5EFEA402F24F6','ARCHIVED','2022-10-03 22:38:27',0), ('2022_11_20_00_characters.sql','4EB8BB24CAF16B0962DF3EF92C77BE05E234CFA6','ARCHIVED','2022-11-20 11:05:20',0), ('2022_12_16_00_characters.sql','36D6220143109ECD37219CC4A84773B31EAE9E50','ARCHIVED','2022-12-16 22:52:19',0), ('2022_12_17_00_characters.sql','3E005BD6B9C60653749B0B3C19CBC497092B9CCB','ARCHIVED','2022-12-17 18:26:43',0), ('2022_12_20_00_characters.sql','75A37A085AF1B953926E4352E439C7916B290924','ARCHIVED','2022-12-20 03:10:07',0), ('2022_12_30_00_characters.sql','5F90C2BFFBB8F6CE0A3327A2CAABCD5CA3C2BA60','ARCHIVED','2022-12-30 22:50:16',0), ('2023_01_28_00_characters.sql','0280F79FD6EC93FFB3CC67B6499CEDA49D582BFC','ARCHIVED','2023-01-28 00:11:03',0), ('2023_01_29_00_characters.sql','24FA9E0F616BF77AC588A25A8A8699903A19A5FE','ARCHIVED','2023-01-29 16:31:12',0), ('2023_02_03_00_characters.sql','A04BA4386B3D5C60407D22CA4BF9A4A6258AA39D','ARCHIVED','2023-02-03 01:13:52',0), ('2023_02_08_00_characters.sql','C9DF607CCE99540F613F5E25E17090176C995C7C','ARCHIVED','2023-02-08 21:41:17',0), ('2023_04_02_00_characters.sql','AAC1B81AFE4716CF4DAB6BCF01D22F421BFAD253','ARCHIVED','2023-04-02 01:02:26',0), ('2023_05_04_00_characters.sql','9AC370E51507F5BD368707E90D8F6BF0FF16CA09','ARCHIVED','2023-05-04 16:17:31',0), ('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0), ('2023_07_14_00_characters.sql','BB44A95A9C4B0C16878A5316AC38E702A8AACDE2','ARCHIVED','2023-07-14 08:24:44',0), ('2023_08_26_00_characters.sql','FA50838609AB5E645FB2DCAC970BD5706F9EFAAF','ARCHIVED','2023-08-26 12:18:22',0), ('2023_09_14_00_characters.sql','DAC56929C724C2971A4476400F2439CBDFAF3C5C','ARCHIVED','2023-09-13 22:20:22',0), ('2023_09_30_00_characters.sql','4326C642870633873F163085D278DB9B7449D9C3','ARCHIVED','2023-09-30 16:34:19',0), ('2023_10_06_00_characters.sql','FFAFF1F0916BB9DC58345466E0BB1A15A4611836','ARCHIVED','2023-10-06 00:40:46',0), ('2023_11_02_00_characters.sql','1A76A843F204901C8598DA5682029E815477E427','ARCHIVED','2023-11-02 18:59:41',0), ('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','ARCHIVED','2023-11-09 00:56:31',0), ('2023_11_15_00_characters.sql','441E0F17DE3E3945307AC400DF86FCDF06C61653','ARCHIVED','2023-11-15 00:53:47',0), ('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','ARCHIVED','2024-02-08 00:56:26',0), ('2024_04_09_00_characters.sql','07AC79B4E489B1CD073852EC57D12939C2A1D4B1','RELEASED','2024-04-09 12:54:11',0), ('2024_04_12_00_characters.sql','043E023F998DA77170C9D2D0162CAA340290B215','RELEASED','2024-04-12 00:23:51',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/10.x/characters','ARCHIVED'), ('$/sql/old/6.x/characters','ARCHIVED'), ('$/sql/old/7/characters','ARCHIVED'), ('$/sql/old/8.x/characters','ARCHIVED'), ('$/sql/old/9.x/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 `world_state_value` -- DROP TABLE IF EXISTS `world_state_value`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `world_state_value` ( `Id` int NOT NULL, `Value` int NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `world_state_value` -- LOCK TABLES `world_state_value` WRITE; /*!40000 ALTER TABLE `world_state_value` DISABLE KEYS */; /*!40000 ALTER TABLE `world_state_value` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `world_variable` -- DROP TABLE IF EXISTS `world_variable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `world_variable` ( `ID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Value` int 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 `world_variable` -- LOCK TABLES `world_variable` WRITE; /*!40000 ALTER TABLE `world_variable` DISABLE KEYS */; INSERT INTO `world_variable` VALUES ('NextBGRandomDailyResetTime',0), ('NextCurrencyResetTime',0), ('NextDailyQuestResetTime',0), ('NextGuildDailyResetTime',0), ('NextGuildWeeklyResetTime',0), ('NextMonthlyQuestResetTime',0), ('NextOldCalendarEventDeletionTime',0), ('NextWeeklyQuestResetTime',0), ('PersistentCharacterCleanFlags',0); /*!40000 ALTER TABLE `world_variable` 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-02-08 0:56:28