diff options
| author | funjoker <funjoker109@gmail.com> | 2023-11-23 20:15:35 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2023-11-23 20:15:35 +0100 |
| commit | 663c6987526d561d451d61c1dbde97f5bd8712c9 (patch) | |
| tree | d3d3db5dc5a9ee501633cc385113c39956be285f /sql | |
| parent | eab60a253337fd568bcd43617577428a0ca530e4 (diff) | |
Core/DB2: Update GossipNpcOption field names
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/hotfixes/3.4.x/2023_11_23_01_hotfixes.sql | 10 |
1 files changed, 10 insertions, 0 deletions
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`; |