aboutsummaryrefslogtreecommitdiff
path: root/sql/base/characters_database.sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2014-12-23 00:25:43 +0100
committerShauren <shauren.trinity@gmail.com>2014-12-23 00:25:43 +0100
commit941904d5ea5f8f385c6fcc0fa5eb45a9ef6e8eaf (patch)
tree80bd9817b169d86d95c60627c49cafdb373c2086 /sql/base/characters_database.sql
parent6c6e4d4328526ccfcd9049efbf9033fe47de41a6 (diff)
Core/Items: Updated item stat calculations
* Implemented item modifiers * Implemented item bonuses
Diffstat (limited to 'sql/base/characters_database.sql')
-rw-r--r--sql/base/characters_database.sql4
1 files changed, 4 insertions, 0 deletions
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';