From 88659dcebf9f033cd99e87595151f42fbcd96310 Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 26 Jan 2022 23:49:42 +0100 Subject: Core/Gossip: Sync naming and db structure with 3.3.5 --- sql/updates/world/master/2022_01_26_45_world.sql | 29 ++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 sql/updates/world/master/2022_01_26_45_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_01_26_45_world.sql b/sql/updates/world/master/2022_01_26_45_world.sql new file mode 100644 index 00000000000..aacba892b94 --- /dev/null +++ b/sql/updates/world/master/2022_01_26_45_world.sql @@ -0,0 +1,29 @@ +ALTER TABLE `gossip_menu` RENAME COLUMN `MenuId` TO `MenuID`; +ALTER TABLE `gossip_menu` RENAME COLUMN `TextId` TO `TextID`; + +ALTER TABLE `gossip_menu_option` RENAME COLUMN `MenuId` TO `MenuID`; +ALTER TABLE `gossip_menu_option` RENAME COLUMN `OptionIndex` TO `OptionID`; +ALTER TABLE `gossip_menu_option` RENAME COLUMN `OptionBroadcastTextId` TO `OptionBroadcastTextID`; +ALTER TABLE `gossip_menu_option` ADD `ActionMenuID` int(10) unsigned NOT NULL DEFAULT 0 AFTER `OptionNpcFlag`; +ALTER TABLE `gossip_menu_option` ADD `ActionPoiID` int(10) unsigned NOT NULL DEFAULT 0 AFTER `ActionMenuID`; +ALTER TABLE `gossip_menu_option` ADD `BoxCoded` tinyint(3) unsigned NOT NULL DEFAULT 0 AFTER `ActionPoiID`; +ALTER TABLE `gossip_menu_option` ADD `BoxMoney` int(10) unsigned NOT NULL DEFAULT 0 AFTER `BoxCoded`; +ALTER TABLE `gossip_menu_option` ADD `BoxText` mediumtext AFTER `BoxMoney`; +ALTER TABLE `gossip_menu_option` ADD `BoxBroadcastTextID` int(10) unsigned NOT NULL DEFAULT 0 AFTER `BoxText`; + +ALTER TABLE `gossip_menu_option_locale` RENAME COLUMN `MenuId` TO `MenuID`; +ALTER TABLE `gossip_menu_option_locale` RENAME COLUMN `OptionIndex` TO `OptionID`; + +UPDATE `gossip_menu_option` gmo + LEFT JOIN `gossip_menu_option_action` gmoa ON gmo.`MenuID` = gmoa.`MenuId` AND gmo.`OptionID` = gmoa.`OptionIndex` + LEFT JOIN `gossip_menu_option_box` gmob ON gmo.`MenuId` = gmoa.`MenuId` AND gmo.`OptionID` = gmoa.`OptionIndex` + SET gmo.`ActionMenuID` = COALESCE(gmoa.`ActionMenuId`, 0), gmo.`ActionPoiID` = COALESCE(gmoa.`ActionPoiId`, 0), + gmo.`BoxCoded` = COALESCE(gmob.`BoxCoded`, 0), gmo.`BoxMoney` = COALESCE(gmob.`BoxMoney`, 0), gmo.`BoxText` = gmob.`BoxText`, gmo.`BoxBroadcastTextID` = COALESCE(gmob.`BoxBroadcastTextId`, 0); + +DROP TABLE `gossip_menu_option_action`; +DROP TABLE `gossip_menu_option_box`; + +ALTER TABLE `creature_trainer` RENAME COLUMN `CreatureId` TO `CreatureID`; +ALTER TABLE `creature_trainer` RENAME COLUMN `TrainerId` TO `TrainerID`; +ALTER TABLE `creature_trainer` RENAME COLUMN `MenuId` TO `MenuID`; +ALTER TABLE `creature_trainer` RENAME COLUMN `OptionIndex` TO `OptionID`; -- cgit v1.2.3