diff options
| author | Meji <alvaro.megias@outlook.com> | 2022-08-13 20:17:58 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-08-13 20:17:58 +0200 |
| commit | 1bbc8592d95978a4c681fa6177c7c457189ef485 (patch) | |
| tree | 550e3397873b815aa5ca6c50073a132fe499fe9b /sql | |
| parent | 1d5696a08bd5afae366b36d257aa06c465a980f2 (diff) | |
Core/Gossips: Added support for FriendshipFactionID (#28192)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_08_13_00_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_08_13_00_world.sql b/sql/updates/world/master/2022_08_13_00_world.sql new file mode 100644 index 00000000000..40db4990405 --- /dev/null +++ b/sql/updates/world/master/2022_08_13_00_world.sql @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS `gossip_menu_addon`; +CREATE TABLE `gossip_menu_addon` ( + `MenuID` INT UNSIGNED NOT NULL DEFAULT 0, + `FriendshipFactionID` INT NOT NULL DEFAULT 0, + `VerifiedBuild` INT NOT NULL DEFAULT 0, + PRIMARY KEY (`MenuID`) +) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +DELETE FROM `gossip_menu_addon` WHERE `MenuID` IN (13332, 13338, 13470, 13475, 13486, 13574, 13593, 13594, 13595); +INSERT INTO `gossip_menu_addon` (`MenuID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES +(13332, 1283, 44908), -- 57298 (Farmer Fung) +(13338, 1279, 44908), -- 57402 (Haohan Mudclaw) +(13470, 1281, 44908), -- 58706 (Gina Mudclaw) +(13475, 1281, 44908), -- 58706 (Gina Mudclaw) +(13486, 1275, 44908), -- 58647 (Ella) +(13574, 1282, 44908), -- 58705 (Fish Fellreed) +(13593, 1280, 44908), -- 58761 (Tina Mudclaw) +(13594, 1277, 44908), -- 58709 (Chee Chee) +(13595, 1276, 44908); -- 58707 (Old Hillpaw) |