DB: Change world VerifiedBuild fields to int

1 files changed, 49 insertions, 0 deletions

diff --git a/sql/updates/world/master/2020_02_18_00_world.sql b/sql/updates/world/master/2020_02_18_00_world.sql
new file mode 100644
index 00000000000..1fa27b5ba41
--- /dev/null
+++ b/sql/updates/world/master/2020_02_18_00_world.sql
@@ -0,0 +1,49 @@
+ALTER TABLE `creature` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_equip_template` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_model_info` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_questitem` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template_locale` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template_model` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template_scaling` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_questitem` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_template` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_template_locale` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `gossip_menu` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `gossip_menu_option` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `lfg_dungeon_template` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_vendor` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `page_text` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `page_text_locale` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `playerchoice`MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `playerchoice_locale` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `playerchoice_response` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `playerchoice_response_locale` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `playerchoice_response_reward` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `playerchoice_response_reward_currency` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `playerchoice_response_reward_faction` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `playerchoice_response_reward_item` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `points_of_interest` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `points_of_interest_locale` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_details` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_greeting` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_greeting_locale` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_objectives` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_objectives_locale` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_offer_reward` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_offer_reward_locale` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_poi` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_poi_points` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_request_items` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_request_items_locale` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_locale` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_visual_effect` MODIFY `VerifiedBuild` INT(10) NOT NULL DEFAULT '0';
+ALTER TABLE `scenario_poi` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `scenario_poi_points` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `spell_target_position` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `trainer` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `trainer_locale` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `trainer_spell` MODIFY `VerifiedBuild` int(11) NOT NULL DEFAULT '0';