From 941904d5ea5f8f385c6fcc0fa5eb45a9ef6e8eaf Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 23 Dec 2014 00:25:43 +0100 Subject: Core/Items: Updated item stat calculations * Implemented item modifiers * Implemented item bonuses --- sql/base/characters_database.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'sql/base/characters_database.sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 29f14fa7b39..dff9589e540 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2213,6 +2213,10 @@ CREATE TABLE `item_instance` ( `durability` smallint(5) unsigned NOT NULL DEFAULT '0', `playedTime` int(10) unsigned NOT NULL DEFAULT '0', `text` text, + `transmogrification` int(10) unsigned NOT NULL DEFAULT '0', + `upgradeId` int(10) unsigned NOT NULL DEFAULT '0', + `enchantIllusion` int(10) unsigned NOT NULL DEFAULT '0', + `bonusListIDs` text, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item System'; -- cgit v1.2.3