From 663c6987526d561d451d61c1dbde97f5bd8712c9 Mon Sep 17 00:00:00 2001 From: funjoker Date: Thu, 23 Nov 2023 20:15:35 +0100 Subject: Core/DB2: Update GossipNpcOption field names --- sql/updates/hotfixes/3.4.x/2023_11_23_01_hotfixes.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/hotfixes/3.4.x/2023_11_23_01_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/3.4.x/2023_11_23_01_hotfixes.sql b/sql/updates/hotfixes/3.4.x/2023_11_23_01_hotfixes.sql new file mode 100644 index 00000000000..7d5941f0dbb --- /dev/null +++ b/sql/updates/hotfixes/3.4.x/2023_11_23_01_hotfixes.sql @@ -0,0 +1,10 @@ +ALTER TABLE `gossip_npc_option` +CHANGE COLUMN `Field34146722002` `Unk341_1` INT(10) NOT NULL DEFAULT '0' AFTER `LFGDungeonsID`, +CHANGE COLUMN `Field34146722003` `Unk341_2` INT(10) NOT NULL DEFAULT '0' AFTER `Unk341_1`, +CHANGE COLUMN `Field34146722004` `Unk341_3` INT(10) NOT NULL DEFAULT '0' AFTER `Unk341_2`, +CHANGE COLUMN `Field34146722005` `Unk341_4` INT(10) NOT NULL DEFAULT '0' AFTER `Unk341_3`, +CHANGE COLUMN `Field34146722006` `Unk341_5` INT(10) NOT NULL DEFAULT '0' AFTER `Unk341_4`, +CHANGE COLUMN `Field34146722007` `Unk341_6` INT(10) NOT NULL DEFAULT '0' AFTER `Unk341_5`, +CHANGE COLUMN `Field34146722008` `Unk341_7` INT(10) NOT NULL DEFAULT '0' AFTER `Unk341_6`, +CHANGE COLUMN `Field34146722009` `Unk341_8` INT(10) NOT NULL DEFAULT '0' AFTER `Unk341_7`, +CHANGE COLUMN `Field34146722010` `Unk341_9` INT(10) NOT NULL DEFAULT '0' AFTER `Unk341_8`; -- cgit v1.2.3