All pastes #806277 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-12-05 02:22 UTC
rendered paste body
BLOB -> 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;