From 34a8baba85bdd86f07730e387144954dd64372ad Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 9 Apr 2021 23:48:59 +0200 Subject: Core/DataStores: Updated db2 structures to 9.0.5 --- .../hotfixes/master/2021_04_09_00_hotfixes.sql | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/hotfixes/master/2021_04_09_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2021_04_09_00_hotfixes.sql b/sql/updates/hotfixes/master/2021_04_09_00_hotfixes.sql new file mode 100644 index 00000000000..d57197330de --- /dev/null +++ b/sql/updates/hotfixes/master/2021_04_09_00_hotfixes.sql @@ -0,0 +1,24 @@ +ALTER TABLE `chr_customization_element` ADD `ChrCustItemGeoModifyID` int(11) NOT NULL DEFAULT '0' AFTER `ChrCustomizationDisplayInfoID`; + +ALTER TABLE `item_bonus_tree_node` + ADD `ItemBonusListGroupID` int(11) NOT NULL DEFAULT '0' AFTER `ChildItemLevelSelectorID`, + ADD `ParentItemBonusTreeNodeID` int(11) NOT NULL DEFAULT '0' AFTER `ItemBonusListGroupID`; + +ALTER TABLE `rand_prop_points` + ADD `DamageReplaceStatF` float NOT NULL DEFAULT '0' AFTER `ID`, + ADD `DamageSecondaryF` float NOT NULL DEFAULT '0' AFTER `DamageReplaceStatF`, + ADD `EpicF1` float NOT NULL DEFAULT '0' AFTER `DamageSecondary`, + ADD `EpicF2` float NOT NULL DEFAULT '0' AFTER `EpicF1`, + ADD `EpicF3` float NOT NULL DEFAULT '0' AFTER `EpicF2`, + ADD `EpicF4` float NOT NULL DEFAULT '0' AFTER `EpicF3`, + ADD `EpicF5` float NOT NULL DEFAULT '0' AFTER `EpicF4`, + ADD `SuperiorF1` float NOT NULL DEFAULT '0' AFTER `Epic5`, + ADD `SuperiorF2` float NOT NULL DEFAULT '0' AFTER `SuperiorF1`, + ADD `SuperiorF3` float NOT NULL DEFAULT '0' AFTER `SuperiorF2`, + ADD `SuperiorF4` float NOT NULL DEFAULT '0' AFTER `SuperiorF3`, + ADD `SuperiorF5` float NOT NULL DEFAULT '0' AFTER `SuperiorF4`, + ADD `GoodF1` float NOT NULL DEFAULT '0' AFTER `SuperiorF5`, + ADD `GoodF2` float NOT NULL DEFAULT '0' AFTER `GoodF1`, + ADD `GoodF3` float NOT NULL DEFAULT '0' AFTER `GoodF2`, + ADD `GoodF4` float NOT NULL DEFAULT '0' AFTER `GoodF3`, + ADD `GoodF5` float NOT NULL DEFAULT '0' AFTER `GoodF4`; -- cgit v1.2.3