From 941904d5ea5f8f385c6fcc0fa5eb45a9ef6e8eaf Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
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

