1 /*Table structure for table `arena_team` */
3 DROP TABLE IF EXISTS `arena_team`;
5 CREATE TABLE `arena_team` (
6 `arenateamid` int(10) unsigned NOT NULL default '0',
7 `name` char(255) NOT NULL,
8 `captainguid` int(10) unsigned NOT NULL default '0',
9 `type` tinyint(3) unsigned NOT NULL default '0',
10 `EmblemStyle` int(10) unsigned NOT NULL default '0',
11 `EmblemColor` int(10) unsigned NOT NULL default '0',
12 `BorderStyle` int(10) unsigned NOT NULL default '0',
13 `BorderColor` int(10) unsigned NOT NULL default '0',
14 `BackgroundColor` int(10) unsigned NOT NULL default '0',
15 PRIMARY KEY (`arenateamid`)
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18 /*Table structure for table `arena_team_member` */
20 DROP TABLE IF EXISTS `arena_team_member`;
22 CREATE TABLE `arena_team_member` (
23 `arenateamid` int(10) unsigned NOT NULL default '0',
24 `guid` int(10) unsigned NOT NULL default '0',
25 `played_week` int(10) unsigned NOT NULL default '0',
26 `wons_week` int(10) unsigned NOT NULL default '0',
27 `played_season` int(10) unsigned NOT NULL default '0',
28 `wons_season` int(10) unsigned NOT NULL default '0'
29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31 /*Table structure for table `arena_team_stats` */
33 DROP TABLE IF EXISTS `arena_team_stats`;
35 CREATE TABLE `arena_team_stats` (
36 `arenateamid` int(10) unsigned NOT NULL default '0',
37 `rating` int(10) unsigned NOT NULL default '0',
38 `games` int(10) unsigned NOT NULL default '0',
39 `wins` int(10) unsigned NOT NULL default '0',
40 `played` int(10) unsigned NOT NULL default '0',
41 `wins2` int(10) unsigned NOT NULL default '0',
42 `rank` int(10) unsigned NOT NULL default '0',
43 PRIMARY KEY (`arenateamid`)
44 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;