1 DROP TABLE IF EXISTS `character_kill`;
2 CREATE TABLE `character_kill` (
3 `guid` int(11) NOT NULL default '0',
4 `victim_guid` int(11) NOT NULL default '0',
5 `count` tinyint(3) NOT NULL default '0',
6 PRIMARY KEY (`guid`,`victim_guid`)
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Kills Yesterday';