Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 1,178: Line 1,178:
 
|-
 
|-
 
|  || expDate || datetime ||
 
|  || expDate || datetime ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: swiss_tournaments
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u+1 ||
 +
|-
 +
|  || name || varchar(100) ||
 +
|-
 +
|  || host || mediumint(8)u ||
 +
|-
 +
|  || description || varchar(500) ||
 +
|-
 +
|  || minplayer || smallint(6) ||
 +
|-
 +
|  || maxplayer || smallint(6) ||
 +
|-
 +
|  || minrating || int(11) ||
 +
|-
 +
|  || maxrating || int(11) ||
 +
|-
 +
|  || tourney_date || datetime ||
 +
|-
 +
|  || tourney_state || tinyint(4) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: swiss_tournaments_players
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || smallint(5)u+1 ||
 +
|-
 +
| U || idtourney || mediumint(8)u ||
 +
|-
 +
| U || iduser || mediumint(8)u ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: map
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(5)u+1 ||
 +
|-
 +
|  || display_name || varchar(100) ||
 +
|-
 +
|  || map_type || varchar(15) ||
 +
|-
 +
|  || battle_type || varchar(15) ||
 +
|-
 +
|  || author || mediumint(8)u ||
 +
|-
 +
|  || create_time || timestamp ||
 +
|-
 +
|  || update_time || timestamp ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1184 map_version]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u+1 ||
 +
|-
 +
|  || description || longtext ||
 +
|-
 +
|  || max_players || decimal(2,0) ||
 +
|-
 +
|  || width || decimal(4,0) ||
 +
|-
 +
|  || heigth || decimal(4,0) ||
 +
|-
 +
|  || version || decimal(4,0) ||
 +
|-
 +
|  || filename || varchar(200) ||
 +
|-
 +
|  || ranked || tinyint(1) ||
 +
|-
 +
|  || hidden || tinyint(1) ||
 +
|-
 +
|  || map_id || mediumint(8)u ||
 +
|-
 +
|  || create_time || timestamp ||
 +
|-
 +
|  || update_time || timestamp ||
 
|}
 
|}

Revision as of 23:45, 3 September 2016

Server db-Tables

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