diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/7834_characters_characters.sql | 22 |
1 files changed, 22 insertions, 0 deletions
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; |