CREATE TABLE `character_quests` ( `char_id` int(11) NOT NULL default '0', `name` varchar(40) NOT NULL default '', `var` varchar(20) NOT NULL default '', `value` varchar(255) default NULL, PRIMARY KEY (`char_id`,`name`,`var`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1