From 9bda35c7dff12460cc9702212693911fdfb9d7ca Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 30 Jul 2010 15:15:07 +0200 Subject: Killed the last blob field (corpse) --HG-- branch : trunk --- sql/base/characters_database.sql | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'sql/base/characters_database.sql') 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`) -- cgit v1.2.3