DB: Convert smallint to int for VerifiedBuild

closes #29013 by CraftedRO

1 files changed, 35 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2023_06_11_04_world.sql b/sql/updates/world/3.3.5/2023_06_11_04_world.sql
new file mode 100644
index 00000000000..258d9a16731
--- /dev/null
+++ b/sql/updates/world/3.3.5/2023_06_11_04_world.sql
@@ -0,0 +1,35 @@
+-- Convert SMALLINT TO INT for VerifiedBuild tables
+ALTER TABLE areatrigger_teleport MODIFY VerifiedBuild INTEGER;
+ALTER TABLE broadcast_text_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE creature_equip_template MODIFY VerifiedBuild INTEGER;
+ALTER TABLE creature_questitem MODIFY VerifiedBuild INTEGER;
+ALTER TABLE creature_template MODIFY VerifiedBuild INTEGER;
+ALTER TABLE creature_template_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE creature_template_resistance MODIFY VerifiedBuild INTEGER;
+ALTER TABLE creature_template_spell MODIFY VerifiedBuild INTEGER;
+ALTER TABLE gameobject MODIFY VerifiedBuild INTEGER;
+ALTER TABLE gameobject_questitem MODIFY VerifiedBuild INTEGER;
+ALTER TABLE gameobject_template MODIFY VerifiedBuild INTEGER;
+ALTER TABLE gameobject_template_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE item_set_names MODIFY VerifiedBuild INTEGER;
+ALTER TABLE item_set_names_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE item_template MODIFY VerifiedBuild INTEGER;
+ALTER TABLE item_template_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE lfg_dungeon_template MODIFY VerifiedBuild INTEGER;
+ALTER TABLE npc_text MODIFY VerifiedBuild INTEGER;
+ALTER TABLE npc_vendor MODIFY VerifiedBuild INTEGER;
+ALTER TABLE page_text_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE points_of_interest MODIFY VerifiedBuild INTEGER;
+ALTER TABLE points_of_interest_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE quest_greeting MODIFY VerifiedBuild INTEGER;
+ALTER TABLE quest_greeting_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE quest_offer_reward_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE quest_poi MODIFY VerifiedBuild INTEGER;
+ALTER TABLE quest_poi_points MODIFY VerifiedBuild INTEGER;
+ALTER TABLE quest_request_items_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE quest_template MODIFY VerifiedBuild INTEGER;
+ALTER TABLE quest_template_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE spell_target_position MODIFY VerifiedBuild INTEGER;
+ALTER TABLE trainer MODIFY VerifiedBuild INTEGER;
+ALTER TABLE trainer_locale MODIFY VerifiedBuild INTEGER;
+ALTER TABLE trainer_spell MODIFY VerifiedBuild INTEGER;