From 9bda35c7dff12460cc9702212693911fdfb9d7ca Mon Sep 17 00:00:00 2001
From: Shauren <none@none>
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

