Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 556: Line 556:
 
|-
 
|-
 
| X || UID || bigint(20)u ||
 
| X || UID || bigint(20)u ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: game_stats
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u ||
 +
|-
 +
|  || startTime || timestamp ||
 +
|-
 +
|  || gameType || enum('0','1','2','3') ||
 +
|-
 +
|  || gameMod || tinyint(3)u ||
 +
|-
 +
|  || host || mediumint(8)u ||
 +
|-
 +
|  || mapId || mediumint(8)u ||
 +
|-
 +
|  || gameName || varchar(128) ||
 +
|-
 +
|  || validity || tinyint(4) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: global_rating
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u ||
 +
|-
 +
|  || meam || float ||
 +
|-
 +
|  || deviation || float ||
 +
|-
 +
|  || numGames || smallint(4)u ||
 +
|-
 +
|  || is_active || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: invalid_game_reasons
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || tinyint(4)+1 ||
 +
|-
 +
|  || message || varchar(100) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: jwt_users
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
| U || username || varchar(20) ||
 +
|-
 +
|  || public_key || varchar(100) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder1v1_rating
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u ||
 +
|-
 +
|  || meam || float ||
 +
|-
 +
|  || deviation || float ||
 +
|-
 +
|  || numGames || smallint(4)u ||
 +
|-
 +
|  || winGames || smallint(4)u ||
 +
|-
 +
|  || is_active || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_division
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u ||
 +
|-
 +
| U || name || varchar(255) ||
 +
|-
 +
|  || league || tinyint(3)u ||
 +
|-
 +
|  || threshold || int(10)u ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_divisions
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(11)+1 ||
 +
|-
 +
| U || name || varchar(255) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_map
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || smallint(5)u+1 ||
 +
|-
 +
| U || idmap || mediumint(8)u ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_season_1
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(11)+1 ||
 +
|-
 +
| U || idUser || mediumint(8)u ||
 +
|-
 +
|  || league || tinyint(1)u ||
 +
|-
 +
|  || division || smallint(5)u ||
 +
|-
 +
|  || score || smallint(5) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_season_2
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(11)+1 ||
 +
|-
 +
| U || idUser || mediumint(8)u ||
 +
|-
 +
|  || league || tinyint(1)u ||
 +
|-
 +
|  || division || smallint(5)u ||
 +
|-
 +
|  || score || smallint(5) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_season_3
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(11)+1 ||
 +
|-
 +
| U || idUser || mediumint(8)u ||
 +
|-
 +
|  || league || tinyint(1)u ||
 +
|-
 +
|  || division || smallint(5)u ||
 +
|-
 +
|  || score || smallint(5) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_season_3_safe
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(11)+1 ||
 +
|-
 +
| U || idUser || mediumint(8)u ||
 +
|-
 +
|  || league || tinyint(1)u ||
 +
|-
 +
|  || division || smallint(5)u ||
 +
|-
 +
|  || score || smallint(5) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_season_4
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(11)+1 ||
 +
|-
 +
| U || idUser || mediumint(8)u ||
 +
|-
 +
|  || league || tinyint(1)u ||
 +
|-
 +
|  || division || smallint(5)u ||
 +
|-
 +
|  || score || smallint(5) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: ladder_season_5
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(11)+1 ||
 +
|-
 +
| U || idUser || mediumint(8)u ||
 +
|-
 +
|  || league || tinyint(1)u ||
 +
|-
 +
|  || division || smallint(5)u ||
 +
|-
 +
|  || score || float u ||
 
|}
 
|}

Revision as of 07:45, 2 September 2016

Server db-Tables

( X = Primary Key, U = Unique Key, u = unsigned, +1 = auto increment )