From 1dc4f7c745f9f061a545c11c0132a67e5f828702 Mon Sep 17 00:00:00 2001
From: n0n4m3 <none@none>
Date: Sun, 11 Apr 2010 11:00:02 +0400
Subject: Drop characters data blob. Bit thx to hunuza.

--HG--
branch : trunk
---
 sql/updates/7834_characters_characters.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 sql/updates/7834_characters_characters.sql

(limited to 'sql/updates')

diff --git a/sql/updates/7834_characters_characters.sql b/sql/updates/7834_characters_characters.sql
new file mode 100644
index 00000000000..694010bcb42
--- /dev/null
+++ b/sql/updates/7834_characters_characters.sql
@@ -0,0 +1,22 @@
+ALTER TABLE characters
+  ADD COLUMN `exploredZones` longtext AFTER activeSpec,
+  ADD COLUMN `equipmentCache` longtext AFTER exploredZones,
+  ADD COLUMN `ammoId` int(10) UNSIGNED NOT NULL default '0' AFTER equipmentCache,
+  ADD COLUMN `knownTitles` longtext AFTER ammoId;
+
+UPDATE characters SET
+exploredZones = SUBSTRING(data,
+length(SUBSTRING_INDEX(data, ' ', 1041))+2,
+length(SUBSTRING_INDEX(data, ' ', 1168+1))- length(SUBSTRING_INDEX(data, ' ', 1041)) - 1),
+equipmentCache = SUBSTRING(data,
+length(SUBSTRING_INDEX(data, ' ', 283))+2,
+length(SUBSTRING_INDEX(data, ' ', 320+1))- length(SUBSTRING_INDEX(data, ' ', 283)) - 1),
+ammoId = SUBSTRING(data,
+length(SUBSTRING_INDEX(data, ' ', 1198))+2,
+length(SUBSTRING_INDEX(data, ' ', 1198+1))- length(SUBSTRING_INDEX(data, ' ', 1198)) - 1),
+knownTitles = SUBSTRING(data,
+length(SUBSTRING_INDEX(data, ' ', 626))+2,
+length(SUBSTRING_INDEX(data, ' ', 631+1))- length(SUBSTRING_INDEX(data, ' ', 626)) - 1);
+
+ALTER TABLE characters
+  DROP COLUMN data;
-- 
cgit v1.2.3