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

1 files changed, 45 insertions, 0 deletions

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;