· 8 years ago · Jul 17, 2018, 11:20 AM
1-- new bg_stats table
2DROP TABLE IF EXISTS `bg_stats`;
3Create table `bg_stats` (
4 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
5 `bg_dammage_done` int(11) DEFAULT '0',
6 `bg_healing_done` int(11) DEFAULT '0',
7 `bg_bonus_honor` int(11) DEFAULT '0',
8 `bg_deaths` int(11) DEFAULT '0',
9 `bg_honorable_kills` int(11) DEFAULT '0',
10 `bg_killing_blows` int(11) DEFAULT '0',
11 PRIMARY KEY (`guid`)
12 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='bg stats';