diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 7 | ||||
| -rw-r--r-- | sql/updates/7834_characters_characters.sql | 22 |
2 files changed, 27 insertions, 2 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index bec2793647c..a36764752e6 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -327,7 +327,6 @@ DROP TABLE IF EXISTS `characters`; CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier', - `data` longtext, `name` varchar(12) NOT NULL default '', `race` tinyint(3) unsigned NOT NULL default '0', `class` tinyint(3) unsigned NOT NULL default '0', @@ -385,9 +384,13 @@ CREATE TABLE `characters` ( `power5` int(10) unsigned NOT NULL default'0', `power6` int(10) unsigned NOT NULL default'0', `power7` int(10) unsigned NOT NULL default'0', + `latency` int(11) unsigned NOT NULL default '0', `speccount` tinyint(3) unsigned NOT NULL default 1, `activespec` tinyint(3) unsigned NOT NULL default 0, - `latency` int(11) unsigned NOT NULL default '0', + `exploredZones` longtext, + `equipmentCache` longtext, + `ammoId` int(10) UNSIGNED NOT NULL default '0', + `knownTitles` longtext, PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), 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; |