txbjH1LN

1DROP TABLE IF EXISTS `players_reports_status`;
2
3CREATE TABLE `players_reports_status` (
4  `guid` int(10) unsigned NOT NULL DEFAULT '0',
5  `creation_time` int(10) unsigned NOT NULL DEFAULT '0',
6  `average` float NOT NULL DEFAULT '0',
7  `total_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
8  `speed_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
9  `fly_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
10  `jump_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
11  `waterwalk_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
12  `teleportplane_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
13  `climb_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
14  PRIMARY KEY (`guid`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';
16
17DROP TABLE IF EXISTS `daily_players_reports`;
18CREATE TABLE `daily_players_reports` (
19  `guid` int(10) unsigned NOT NULL DEFAULT '0',
20  `creation_time` int(10) unsigned NOT NULL DEFAULT '0',
21  `average` float NOT NULL DEFAULT '0',
22  `total_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
23  `speed_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
24  `fly_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
25  `jump_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
26  `waterwalk_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
27  `teleportplane_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
28  `climb_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
29  PRIMARY KEY (`guid`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';