From 1248efda221006b4c154f1edbd0619e2e4aac69a Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 11 Jun 2023 11:03:25 +0200 Subject: DB: Convert smallint to int for VerifiedBuild closes #29013 by CraftedRO --- sql/updates/world/3.3.5/2023_06_11_04_world.sql | 35 +++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 sql/updates/world/3.3.5/2023_06_11_04_world.sql (limited to 'sql') 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; -- cgit v1.2.3