mirror of
https://github.com/araxiaonline/mod-azerothshard.git
synced 2026-06-13 01:32:21 -04:00
49 lines
1.5 KiB
SQL
49 lines
1.5 KiB
SQL
/*Table structure for table `armory_character_stats` */
|
|
|
|
DROP TABLE IF EXISTS `armory_character_stats`;
|
|
|
|
CREATE TABLE `armory_character_stats` (
|
|
`guid` int(11) NOT NULL,
|
|
`data` longtext NOT NULL,
|
|
`save_date` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`guid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='World of Warcraft Armory table';
|
|
|
|
/*Table structure for table `armory_game_chart` */
|
|
|
|
DROP TABLE IF EXISTS `armory_game_chart`;
|
|
|
|
CREATE TABLE `armory_game_chart` (
|
|
`gameid` int(11) NOT NULL,
|
|
`teamid` int(11) NOT NULL,
|
|
`guid` int(11) NOT NULL,
|
|
`changeType` int(11) NOT NULL,
|
|
`ratingChange` int(11) NOT NULL,
|
|
`teamRating` int(11) NOT NULL,
|
|
`damageDone` int(11) NOT NULL,
|
|
`deaths` int(11) NOT NULL,
|
|
`healingDone` int(11) NOT NULL,
|
|
`damageTaken` int(11) NOT NULL,
|
|
`healingTaken` int(11) NOT NULL,
|
|
`killingBlows` int(11) NOT NULL,
|
|
`mapId` int(11) NOT NULL,
|
|
`start` int(11) NOT NULL,
|
|
`end` int(11) NOT NULL,
|
|
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`gameid`,`teamid`,`guid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='WoWArmory Game Chart';
|
|
|
|
/*Table structure for table `character_feed_log` */
|
|
|
|
DROP TABLE IF EXISTS `character_feed_log`;
|
|
|
|
CREATE TABLE `character_feed_log` (
|
|
`guid` int(11) NOT NULL,
|
|
`type` smallint(1) NOT NULL,
|
|
`data` int(11) NOT NULL,
|
|
`date` int(11) DEFAULT NULL,
|
|
`counter` int(11) NOT NULL,
|
|
`difficulty` smallint(6) DEFAULT '-1',
|
|
`item_guid` int(11) DEFAULT '-1',
|
|
`item_quality` smallint(6) NOT NULL DEFAULT '-1'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |