diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 6 | ||||
| -rw-r--r-- | sql/base/characters_database.sql | 70 |
2 files changed, 48 insertions, 28 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 28b6f4b94bd..de9bd0c726d 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,6 +1,6 @@ -- MySQL dump 10.15 Distrib 10.0.15-MariaDB, for Win64 (x86) -- --- Host: localhost Database: authdum +-- Host: localhost Database: auth -- ------------------------------------------------------ -- Server version 10.0.15-MariaDB @@ -252,7 +252,7 @@ CREATE TABLE `battlenet_components` ( LOCK TABLES `battlenet_components` WRITE; /*!40000 ALTER TABLE `battlenet_components` DISABLE KEYS */; -INSERT INTO `battlenet_components` VALUES ('Bnet','Mc64',37165),('Bnet','Win',37165),('Bnet','Wn64',37165),('WoW','base',19057),('WoW','deDE',0),('WoW','enGB',0),('WoW','enUS',0),('WoW','esES',0),('WoW','esMX',0),('WoW','frFR',0),('WoW','koKR',0),('WoW','Mc64',19342),('WoW','ruRU',0),('WoW','Win',19342),('WoW','Wn64',19342),('WoW','zhCN',0),('WoW','zhTW',0); +INSERT INTO `battlenet_components` VALUES ('Bnet','Mc64',37165),('Bnet','Win',37165),('Bnet','Wn64',37165),('WoW','base',19057),('WoW','deDE',0),('WoW','enCN',0),('WoW','enGB',0),('WoW','enTW',0),('WoW','enUS',0),('WoW','esES',0),('WoW','esMX',0),('WoW','frFR',0),('WoW','itIT',0),('WoW','koKR',0),('WoW','Mc64',19342),('WoW','ptBR',0),('WoW','ptPT',0),('WoW','ruRU',0),('WoW','Win',19342),('WoW','Wn64',19342),('WoW','zhCN',0),('WoW','zhTW',0); /*!40000 ALTER TABLE `battlenet_components` ENABLE KEYS */; UNLOCK TABLES; @@ -621,4 +621,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2014-12-27 18:09:09 +-- Dump completed on 2014-12-28 23:10:07 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index dff9589e540..88327122f26 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -408,7 +408,7 @@ DROP TABLE IF EXISTS `character_achievement_progress`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_achievement_progress` ( `guid` bigint(20) unsigned NOT NULL, - `criteria` smallint(5) unsigned NOT NULL, + `criteria` int(10) unsigned NOT NULL, `counter` bigint(20) unsigned NOT NULL, `date` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`criteria`) @@ -636,11 +636,13 @@ DROP TABLE IF EXISTS `character_currency`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_currency` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `currency` smallint(5) unsigned NOT NULL, - `total_count` int(10) unsigned NOT NULL, - `week_count` int(10) unsigned NOT NULL, - PRIMARY KEY (`guid`,`currency`) + `CharacterGuid` bigint(20) unsigned NOT NULL DEFAULT '0', + `Currency` smallint(5) unsigned NOT NULL, + `Quantity` int(10) unsigned NOT NULL, + `WeeklyQuantity` int(10) unsigned NOT NULL, + `TrackedQuantity` int(10) unsigned NOT NULL, + `Flags` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`CharacterGuid`,`Currency`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -941,21 +943,11 @@ DROP TABLE IF EXISTS `character_queststatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_queststatus` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', - `status` tinyint(3) unsigned NOT NULL DEFAULT '0', - `explored` tinyint(3) unsigned NOT NULL DEFAULT '0', - `timer` int(10) unsigned NOT NULL DEFAULT '0', - `mobcount1` smallint(5) unsigned NOT NULL DEFAULT '0', - `mobcount2` smallint(5) unsigned NOT NULL DEFAULT '0', - `mobcount3` smallint(5) unsigned NOT NULL DEFAULT '0', - `mobcount4` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount1` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount2` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount3` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount4` smallint(5) unsigned NOT NULL DEFAULT '0', - `playercount` smallint(5) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`quest`) + `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + `quest` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `timer` INT(10) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`, `quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -969,6 +961,31 @@ LOCK TABLES `character_queststatus` WRITE; UNLOCK TABLES; -- +-- Table structure for table `character_queststatus_objectives` +-- + +DROP TABLE IF EXISTS `character_queststatus_objectives`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_queststatus_objectives` ( + `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + `quest` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `objective` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `data` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`, `quest`, `objective`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 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_daily` -- @@ -1346,7 +1363,9 @@ CREATE TABLE `characters` ( `position_z` float NOT NULL DEFAULT '0', `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `instance_id` int(10) unsigned NOT NULL DEFAULT '0', - `instance_mode_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', + `dungeonDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '1', + `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '14', + `legacyRaidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '3', `orientation` float NOT NULL DEFAULT '0', `taximask` text NOT NULL, `online` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -1714,8 +1733,9 @@ CREATE TABLE `groups` ( `icon7` binary(16) NOT NULL, `icon8` binary(16) NOT NULL, `groupType` tinyint(3) unsigned NOT NULL, - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', - `raiddifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', + `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '1', + `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '14', + `legacyRaidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '3', `masterLooterGuid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`guid`), KEY `leaderGuid` (`leaderGuid`) @@ -1801,7 +1821,7 @@ DROP TABLE IF EXISTS `guild_achievement_progress`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guild_achievement_progress` ( `guildId` bigint(20) unsigned NOT NULL, - `criteria` smallint(5) unsigned NOT NULL, + `criteria` int(10) unsigned NOT NULL, `counter` bigint(20) unsigned NOT NULL, `date` int(10) unsigned NOT NULL DEFAULT '0', `completedGuid` bigint(20) unsigned NOT NULL DEFAULT '0', |