1 DROP TABLE IF EXISTS `character_aura`;
2 CREATE TABLE `character_aura` (
3 `guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
4 `spell` int(11) unsigned NOT NULL default '0',
5 `effect_index` int(11) unsigned NOT NULL default '0',
6 `remaintime` int(11) NOT NULL default '0',
8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';