From dfd224931aa0366045aba2b7c50539a7b53e3c66 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 27 Sep 2024 20:05:36 +0200 Subject: Core/DataStores: Removed overriding field sign type based on db2 column compression (cherry picked from commit 89f490bdcdf88c2576c17218926e89b1082ae682) # Conflicts: # sql/updates/auth/cata_classic/2024_09_27_00_hotfixes.sql # src/server/game/Achievements/CriteriaHandler.cpp # src/server/game/DataStores/DB2LoadInfo.h # src/server/game/DataStores/DB2Stores.cpp # src/server/game/DataStores/DB2Stores.h # src/server/game/DataStores/DB2Structure.h # src/server/game/DataStores/DBCEnums.h # src/server/game/Entities/Item/AzeriteItem/AzeriteEmpoweredItem.cpp # src/server/game/Entities/Item/ItemBonusMgr.cpp # src/server/game/Entities/Player/Player.cpp # src/server/game/Spells/TraitMgr.cpp --- .../cata_classic/2024_09_30_00_hotfixes.sql | 45 ++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 sql/updates/hotfixes/cata_classic/2024_09_30_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/cata_classic/2024_09_30_00_hotfixes.sql b/sql/updates/hotfixes/cata_classic/2024_09_30_00_hotfixes.sql new file mode 100644 index 00000000000..40e2fab5717 --- /dev/null +++ b/sql/updates/hotfixes/cata_classic/2024_09_30_00_hotfixes.sql @@ -0,0 +1,45 @@ +ALTER TABLE `achievement` + CHANGE `UiOrder` `UiOrder` SMALLINT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `achievement_category` + CHANGE `UiOrder` `UiOrder` TINYINT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `area_trigger` + CHANGE `ContinentID` `ContinentID` SMALLINT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `chr_customization_choice` + CHANGE `ChrCustomizationOptionID` `ChrCustomizationOptionID` INT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `chr_model` + CHANGE `DisplayID` `DisplayID` INT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `chr_race_x_chr_model` + CHANGE `ChrRacesID` `ChrRacesID` INT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `dungeon_encounter` + CHANGE `MapID` `MapID` SMALLINT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `item_currency_cost` + CHANGE `ItemID` `ItemID` INT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `item_modified_appearance` + CHANGE `ItemID` `ItemID` INT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `journal_encounter_section` + CHANGE `Type` `Type` TINYINT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `skill_line_ability` + CHANGE `SkillLine` `SkillLine` SMALLINT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `skill_race_class_info` + CHANGE `SkillID` `SkillID` SMALLINT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `ui_map` + CHANGE `ParentUiMapID` `ParentUiMapID` INT UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `System` `System` TINYINT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `ui_map_assignment` + CHANGE `UiMapID` `UiMapID` INT UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `ui_map_link` + CHANGE `ParentUiMapID` `ParentUiMapID` INT UNSIGNED DEFAULT 0 NOT NULL; -- cgit v1.2.3