diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2023_06_11_04_world.sql | 35 |
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; |