From b3f9d5e5af79c3c76043f29aa467c2c619386e0d Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 1 Feb 2018 12:09:58 +0100 Subject: Core/Gossip: Revert renaming/changing types part of 853df91048330f3066e7adb14019bfe5b0ffa019 Closes #21186 --- sql/updates/world/master/2018_02_01_00_world.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/world/master/2018_02_01_00_world.sql (limited to 'sql') 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'; -- cgit v1.2.3