diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2018_02_01_00_world.sql | 24 |
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'; |