bZMrXrhr

1DROP TABLE IF EXISTS `armory_character_stats`;
2CREATE TABLE `armory_character_stats` (
3  `guid` int(11) NOT NULL,
4  `data` longtext NOT NULL,
5  save_date bigint not null,
6  PRIMARY KEY  (`guid`)
7) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='World of Warcraft Armory table';
8
9DROP TABLE IF EXISTS `character_feed_log`;
10CREATE TABLE `character_feed_log` (
11  `guid` int(11) NOT NULL,
12  `type` smallint(1) NOT NULL,
13  `data` int(11) NOT NULL,
14  `date` int(11) default NULL,
15  `counter` int(11) NOT NULL,
16  `difficulty` smallint(6) default '-1',
17  PRIMARY KEY  (`guid`,`type`,`data`)
18) ENGINE=MyISAM DEFAULT CHARSET=utf8;
19ALTER TABLE `character_feed_log` ADD `item_guid` INT NOT NULL ;
20
21DROP TABLE IF EXISTS `armory_game_chart`;
22CREATE TABLE `armory_game_chart` (
23  `gameid` int(11) NOT NULL,
24  `teamid` int(11) NOT NULL,
25  `guid` int(11) NOT NULL,
26  `changeType` int(11) NOT NULL,
27  `ratingChange` int(11) NOT NULL,
28  `teamRating` int(11) NOT NULL,
29  `damageDone` int(11) NOT NULL,
30  `deaths` int(11) NOT NULL,
31  `healingDone` int(11) NOT NULL,
32  `damageTaken` int(11) NOT NULL,
33  `healingTaken` int(11) NOT NULL,
34  `killingBlows` int(11) NOT NULL,
35  `mapId` int(11) NOT NULL,
36  `start` int(11) NOT NULL,
37  `end` int(11) NOT NULL,
38  PRIMARY KEY  (`gameid`,`teamid`,`guid`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='WoWArmory Game Chart';