Core/Gossip: Revert renaming/changing types part of 853df91048330f3066e7adb14019bfe5b0ffa019

Closes #21186

1 files changed, 24 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_02_01_00_world.sql b/sql/updates/world/master/2018_02_01_00_world.sql
new file mode 100644
index 00000000000..55c863a5964
--- /dev/null
+++ b/sql/updates/world/master/2018_02_01_00_world.sql
@@ -0,0 +1,24 @@
+ALTER TABLE `gossip_menu`
+  CHANGE `MenuID` `MenuId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  CHANGE `TextID` `TextId` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+
+ALTER TABLE `gossip_menu_option`
+  CHANGE `MenuID` `MenuId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  CHANGE `OptionID` `OptionIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  CHANGE `OptionNpcflag` `OptionNpcFlag` bigint(20) UNSIGNED NOT NULL DEFAULT '0';
+
+ALTER TABLE `gossip_menu_option_action`
+  CHANGE `MenuID` `MenuId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  CHANGE `OptionID` `OptionIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+
+ALTER TABLE `gossip_menu_option_box`
+  CHANGE `MenuID` `MenuId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  CHANGE `OptionID` `OptionIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+
+ALTER TABLE `gossip_menu_option_trainer`
+  CHANGE `MenuID` `MenuId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  CHANGE `OptionID` `OptionIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+
+ALTER TABLE `gossip_menu_option_locale`
+  CHANGE `MenuID` `MenuId` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+  CHANGE `OptionID` `OptionIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0';