rendered paste bodyBLOB -> TABLES Conversion
PLAYER_SKILL_INFO -> character_skills table
--
-- Table structure for table `character_skills`
--
CREATE TABLE IF NOT EXISTS `character_queststatus` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Identifier',
`skillid` int(11) unsigned NOT NULL default '0' COMMENT 'Skill Identifier',
`curskill` int(11) unsigned NOT NULL default '0',
`maxskill` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`, `skillid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
PLAYER_EXPLORED_ZONES -> character table, explored_zones field
Add column `explored_zones` to `character` table and continue to store the explored zones as a blob.
alter table character add column `explored_zones` text;