diff options
| author | Shauren <none@none> | 2010-07-30 13:15:31 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-07-30 13:15:31 +0200 |
| commit | 77fc91bde85b44298ab6694236d1f6c9ece3cd34 (patch) | |
| tree | c55096ae0c45ea545fba415d0a1525fdfb25add1 /sql/base | |
| parent | c227065fc0396cbca91cff9bc4e140eef9e70f2b (diff) | |
Deleted data blob in item_instance
Fixed issues with displaying sockets/enchants/durability on heroic items
--HG--
branch : trunk
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 7bd03bffb07..07ae8a0359a 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1711,7 +1711,16 @@ DROP TABLE IF EXISTS `item_instance`; CREATE TABLE `item_instance` ( `guid` int(11) unsigned NOT NULL default '0', `owner_guid` int(11) unsigned NOT NULL default '0', - `data` longtext, + `creatorGuid` int(10) unsigned NOT NULL default '0', + `giftCreatorGuid` int(10) unsigned NOT NULL default '0', + `count` int(10) unsigned NOT NULL default '1', + `duration` int(10) unsigned NOT NULL default '0', + `charges` text NOT NULL, + `flags` int(10) unsigned NOT NULL default '0', + `enchantments` text NOT NULL, + `randomPropertyId` int(11) NOT NULL default '0', + `durability` int(10) unsigned NOT NULL default '0', + `playedTime` int(10) unsigned NOT NULL default '0'; `text` longtext, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) |