diff options
| author | Shauren <none@none> | 2010-07-30 15:15:07 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-07-30 15:15:07 +0200 |
| commit | 9bda35c7dff12460cc9702212693911fdfb9d7ca (patch) | |
| tree | cd670a74cc580a0b33b35ab60e1e85d41d62e8ea /sql/base/characters_database.sql | |
| parent | 6624da055aab91750966a8f016568782da833923 (diff) | |
Killed the last blob field (corpse)
--HG--
branch : trunk
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 07ae8a0359a..f7b0b40ef5b 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1211,7 +1211,13 @@ CREATE TABLE `corpse` ( `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier', `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', `phaseMask` smallint(5) unsigned NOT NULL default '1', - `data` longtext, + `displayId` int(10) unsigned NOT NULL default '0', + `itemCache` text NOT NULL AFTER `displayId`, + `bytes1` int(10) unsigned NOT NULL default '0', + `bytes2` int(10) unsigned NOT NULL default '0', + `guild` int(10) unsigned NOT NULL default '0', + `flags` int(10) unsigned NOT NULL default '0', + `dynFlags` int(10) unsigned NOT NULL default '0', `time` bigint(20) unsigned NOT NULL default '0', `corpse_type` tinyint(3) unsigned NOT NULL default '0', `instance` int(11) unsigned NOT NULL default '0', @@ -1720,7 +1726,7 @@ CREATE TABLE `item_instance` ( `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'; + `playedTime` int(10) unsigned NOT NULL default '0', `text` longtext, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) |