p5Xt9d79

1-- ----------------------------
2-- Table structure for rp_user_game_stats
3-- ----------------------------
4DROP TABLE IF EXISTS `rp_user_game_stats`;
5CREATE TABLE `rp_user_game_stats` (
6  `user_id` int(11) NOT NULL DEFAULT 0,
7  `brawl_kills` int(11) DEFAULT 0,
8  `brawl_deaths` int(11) DEFAULT 0,
9  `brawl_points` int(11) DEFAULT 0,
10  `brawl_wins` int(11) DEFAULT 0,
11  `brawl_losses` int(11) DEFAULT 0,
12  `ffa_kills` int(11) DEFAULT 0,
13  `ffa_deaths` int(11) DEFAULT 0,
14  `ffa_points` int(11) DEFAULT 0,
15  `ffa_wins` int(11) DEFAULT 0,
16  `ffa_losses` int(11) DEFAULT 0,
17  `mafia_wars_kills` int(11) DEFAULT 0,
18  `mafia_wars_deaths` int(11) DEFAULT 0,
19  `mafia_wars_points` int(11) DEFAULT 0,
20  `mafia_wars_wins` int(11) DEFAULT 0,
21  `mafia_wars_losses` int(11) DEFAULT 0,
22  `colour_wars_kills` int(11) DEFAULT 0,
23  `colour_wars_deaths` int(11) DEFAULT 0,
24  `colour_wars_points` int(11) DEFAULT 0,
25  `colour_wars_wins` int(11) DEFAULT 0,
26  `colour_wars_losses` int(11) DEFAULT 0,
27  `colour_wars_captures` int(11) DEFAULT 0,
28  PRIMARY KEY (`user_id`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30
31-- ----------------------------
32-- Records of rp_user_game_stats
33-- ----------------------------
34INSERT INTO `rp_user_game_stats` VALUES ('1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
35INSERT INTO `rp_user_game_stats` VALUES ('2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
36INSERT INTO `rp_user_game_stats` VALUES ('3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
37INSERT INTO `rp_user_game_stats` VALUES ('4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
38INSERT INTO `rp_user_game_stats` VALUES ('5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
39INSERT INTO `rp_user_game_stats` VALUES ('6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');