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/updates/9092_characters_corpse.sql | 39 ++++++++++++++++++++++++++++++++++
 1 file changed, 39 insertions(+)
 create mode 100644 sql/updates/9092_characters_corpse.sql

(limited to 'sql/updates')

diff --git a/sql/updates/9092_characters_corpse.sql b/sql/updates/9092_characters_corpse.sql
new file mode 100644
index 00000000000..0a7bfa497b3
--- /dev/null
+++ b/sql/updates/9092_characters_corpse.sql
@@ -0,0 +1,39 @@
+ALTER TABLE `corpse`
+ ADD COLUMN `displayId` int(10) unsigned NOT NULL default '0' AFTER `phaseMask`,
+ ADD COLUMN `itemCache` text NOT NULL AFTER `displayId`,
+ ADD COLUMN `bytes1` int(10) unsigned NOT NULL default '0' AFTER `itemCache`,
+ ADD COLUMN `bytes2` int(10) unsigned NOT NULL default '0' AFTER `bytes1`,
+ ADD COLUMN `guild` int(10) unsigned NOT NULL default '0' AFTER `bytes2`,
+ ADD COLUMN `flags` int(10) unsigned NOT NULL default '0' AFTER `guild`,
+ ADD COLUMN `dynFlags` int(10) unsigned NOT NULL default '0' AFTER `flags`;
+
+UPDATE `corpse` SET
+`displayId` = SUBSTRING(`data`,
+length(SUBSTRING_INDEX(`data`,' ',10))+2,
+length(SUBSTRING_INDEX(`data`,' ',10+1))-length(SUBSTRING_INDEX(data,' ',10))-1),
+
+`itemCache` = SUBSTRING(`data`,
+length(SUBSTRING_INDEX(`data`,' ',11))+2,
+length(SUBSTRING_INDEX(`data`,' ',29+1))-length(SUBSTRING_INDEX(data,' ',11))-1),
+
+`bytes1` = SUBSTRING(`data`,
+length(SUBSTRING_INDEX(`data`,' ',30))+2,
+length(SUBSTRING_INDEX(`data`,' ',30+1))-length(SUBSTRING_INDEX(data,' ',30))-1),
+
+`bytes2` = SUBSTRING(`data`,
+length(SUBSTRING_INDEX(`data`,' ',31))+2,
+length(SUBSTRING_INDEX(`data`,' ',31+1))-length(SUBSTRING_INDEX(data,' ',31))-1),
+
+`guild` = SUBSTRING(`data`,
+length(SUBSTRING_INDEX(`data`,' ',32))+2,
+length(SUBSTRING_INDEX(`data`,' ',32+1))-length(SUBSTRING_INDEX(data,' ',32))-1),
+
+`flags` = SUBSTRING(`data`,
+length(SUBSTRING_INDEX(`data`,' ',33))+2,
+length(SUBSTRING_INDEX(`data`,' ',33+1))-length(SUBSTRING_INDEX(data,' ',33))-1),
+
+`dynFlags` = SUBSTRING(`data`,
+length(SUBSTRING_INDEX(`data`,' ',34))+2,
+length(SUBSTRING_INDEX(`data`,' ',34+1))-length(SUBSTRING_INDEX(data,' ',34))-1);
+
+ALTER TABLE `corpse` DROP `data`;
-- 
cgit v1.2.3