From ed00534e7c311530e5fbb1ffb567d9459ff4c1f0 Mon Sep 17 00:00:00 2001 From: frozen4 Date: Tue, 21 Jun 2016 20:33:51 +0200 Subject: Core/Items: Implemented item upgrades Closes #17432 --- .../hotfixes/6.x/2016_06_21_00_hotfixes.sql | 27 ++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 sql/updates/hotfixes/6.x/2016_06_21_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/hotfixes/6.x/2016_06_21_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_06_21_00_hotfixes.sql new file mode 100644 index 00000000000..e2ca7d2ce65 --- /dev/null +++ b/sql/updates/hotfixes/6.x/2016_06_21_00_hotfixes.sql @@ -0,0 +1,27 @@ +-- +-- Table structure for table `item_upgrade` +-- +DROP TABLE IF EXISTS `item_upgrade`; +CREATE TABLE `item_upgrade` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemUpgradePathID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLevelBonus` int(10) unsigned NOT NULL DEFAULT '0', + `PrevItemUpgradeID` int(10) unsigned NOT NULL DEFAULT '0', + `CurrencyID` int(10) unsigned NOT NULL DEFAULT '0', + `CurrencyCost` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `ruleset_item_upgrade` +-- +DROP TABLE IF EXISTS `ruleset_item_upgrade`; +CREATE TABLE `ruleset_item_upgrade` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `RulesetID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemUpgradeID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3