aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/hotfixes/2016_01_03_00_hotfixes.sql160
1 files changed, 160 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2016_01_03_00_hotfixes.sql b/sql/updates/hotfixes/2016_01_03_00_hotfixes.sql
new file mode 100644
index 00000000000..45ab99f7084
--- /dev/null
+++ b/sql/updates/hotfixes/2016_01_03_00_hotfixes.sql
@@ -0,0 +1,160 @@
+--
+-- Table structure for table `player_condition`
+--
+
+DROP TABLE IF EXISTS `player_condition`;
+CREATE TABLE `player_condition` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinLevel` int(10) unsigned NOT NULL DEFAULT '0',
+ `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0',
+ `RaceMask` int(10) unsigned NOT NULL DEFAULT '0',
+ `ClassMask` int(10) unsigned NOT NULL DEFAULT '0',
+ `Gender` int(11) NOT NULL DEFAULT '0',
+ `NativeGender` int(11) NOT NULL DEFAULT '0',
+ `SkillID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `SkillID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `SkillID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `SkillID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinSkill1` int(11) NOT NULL DEFAULT '0',
+ `MinSkill2` int(11) NOT NULL DEFAULT '0',
+ `MinSkill3` int(11) NOT NULL DEFAULT '0',
+ `MinSkill4` int(11) NOT NULL DEFAULT '0',
+ `MaxSkill1` int(11) NOT NULL DEFAULT '0',
+ `MaxSkill2` int(11) NOT NULL DEFAULT '0',
+ `MaxSkill3` int(11) NOT NULL DEFAULT '0',
+ `MaxSkill4` int(11) NOT NULL DEFAULT '0',
+ `SkillLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `LanguageID` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinLanguage` int(10) unsigned NOT NULL DEFAULT '0',
+ `MaxLanguage` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinFactionID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinFactionID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinFactionID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `MaxFactionID` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinReputation1` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinReputation2` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinReputation3` int(10) unsigned NOT NULL DEFAULT '0',
+ `MaxReputation` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReputationLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `Unknown1` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinPVPRank` int(10) unsigned NOT NULL DEFAULT '0',
+ `MaxPVPRank` int(10) unsigned NOT NULL DEFAULT '0',
+ `PvpMedal` int(10) unsigned NOT NULL DEFAULT '0',
+ `PrevQuestLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `PrevQuestID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `PrevQuestID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `PrevQuestID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `PrevQuestID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrQuestLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrQuestID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrQuestID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrQuestID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrQuestID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrentCompletedQuestLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrentCompletedQuestID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrentCompletedQuestID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrentCompletedQuestID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrentCompletedQuestID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemCount1` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemCount2` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemCount3` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemCount4` int(10) unsigned NOT NULL DEFAULT '0',
+ `ItemFlags` int(10) unsigned NOT NULL DEFAULT '0',
+ `Explored1` int(10) unsigned NOT NULL DEFAULT '0',
+ `Explored2` int(10) unsigned NOT NULL DEFAULT '0',
+ `Time1` int(10) unsigned NOT NULL DEFAULT '0',
+ `Time2` int(10) unsigned NOT NULL DEFAULT '0',
+ `AuraSpellLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `AuraSpellID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `AuraSpellID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `AuraSpellID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `AuraSpellID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `WorldStateExpressionID` int(10) unsigned NOT NULL DEFAULT '0',
+ `WeatherID` int(10) unsigned NOT NULL DEFAULT '0',
+ `PartyStatus` int(10) unsigned NOT NULL DEFAULT '0',
+ `LifetimeMaxPVPRank` int(10) unsigned NOT NULL DEFAULT '0',
+ `AchievementLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `Achievement1` int(10) unsigned NOT NULL DEFAULT '0',
+ `Achievement2` int(10) unsigned NOT NULL DEFAULT '0',
+ `Achievement3` int(10) unsigned NOT NULL DEFAULT '0',
+ `Achievement4` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgStatus1` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgStatus2` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgStatus3` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgStatus4` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgCompare1` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgCompare2` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgCompare3` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgCompare4` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgValue1` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgValue2` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgValue3` int(10) unsigned NOT NULL DEFAULT '0',
+ `LfgValue4` int(10) unsigned NOT NULL DEFAULT '0',
+ `AreaLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `AreaID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `AreaID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `AreaID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `AreaID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyID1` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyID2` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyID3` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyID4` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyCount1` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyCount2` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyCount3` int(10) unsigned NOT NULL DEFAULT '0',
+ `CurrencyCount4` int(10) unsigned NOT NULL DEFAULT '0',
+ `QuestKillID` int(10) unsigned NOT NULL DEFAULT '0',
+ `QuestKillLogic` int(10) unsigned NOT NULL DEFAULT '0',
+ `QuestKillMonster1` int(10) unsigned NOT NULL DEFAULT '0',
+ `QuestKillMonster2` int(10) unsigned NOT NULL DEFAULT '0',
+ `QuestKillMonster3` int(10) unsigned NOT NULL DEFAULT '0',
+ `QuestKillMonster4` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinExpansionLevel` int(11) NOT NULL DEFAULT '0',
+ `MaxExpansionLevel` int(11) NOT NULL DEFAULT '0',
+ `MinExpansionTier` int(11) NOT NULL DEFAULT '0',
+ `MaxExpansionTier` int(11) NOT NULL DEFAULT '0',
+ `MinGuildLevel` int(10) unsigned NOT NULL DEFAULT '0',
+ `MaxGuildLevel` int(10) unsigned NOT NULL DEFAULT '0',
+ `PhaseUseFlags` int(10) unsigned NOT NULL DEFAULT '0',
+ `PhaseID` int(10) unsigned NOT NULL DEFAULT '0',
+ `PhaseGroupID` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinAvgItemLevel` int(10) unsigned NOT NULL DEFAULT '0',
+ `MaxAvgItemLevel` int(10) unsigned NOT NULL DEFAULT '0',
+ `MinAvgEquippedItemLevel` int(10) unsigned NOT NULL DEFAULT '0',
+ `MaxAvgEquippedItemLevel` int(10) unsigned NOT NULL DEFAULT '0',
+ `ChrSpecializationIndex` int(11) NOT NULL DEFAULT '0',
+ `ChrSpecializationRole` int(11) NOT NULL DEFAULT '0',
+ `FailureDescription` text,
+ `PowerType` int(11) NOT NULL DEFAULT '0',
+ `PowerTypeComp` int(11) NOT NULL DEFAULT '0',
+ `PowerTypeValue` int(11) NOT NULL DEFAULT '0',
+ `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `player_condition_locale`
+--
+
+DROP TABLE IF EXISTS `player_condition_locale`;
+CREATE TABLE `player_condition_locale` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `locale` varchar(4) NOT NULL,
+ `FailureDescription_lang` text,
+ `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+