Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 1,183: Line 1,183:
 
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 
|-
 
|-
!colspan="4"|Table: swiss_tournaments
+
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1125 swiss_tournaments]
 
|-
 
|-
 
|style="padding:0;border:none"|
 
|style="padding:0;border:none"|
Line 1,214: Line 1,214:
 
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 
|-
 
|-
!colspan="4"|Table: swiss_tournaments_players
+
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1147 swiss_tournaments_players]
 
|-
 
|-
 
|style="padding:0;border:none"|
 
|style="padding:0;border:none"|
Line 1,231: Line 1,231:
 
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 
|-
 
|-
!colspan="4"|Table: map
+
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1165 map]
 
|-
 
|-
 
|style="padding:0;border:none"|
 
|style="padding:0;border:none"|
Line 2,257: Line 2,257:
 
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 
|-
 
|-
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2073 vault_admin]
+
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2086 vault_admin]
 
|-
 
|-
 
|style="padding:0;border:none"|
 
|style="padding:0;border:none"|
Line 2,267: Line 2,267:
 
|-
 
|-
 
|  || group || tinyint(4) || 0 - no privileges; 1 - moderator, can delete/edit comments and approve broken maps reports; 2 - admin, same as moderator plus can delete maps from vault
 
|  || group || tinyint(4) || 0 - no privileges; 1 - moderator, can delete/edit comments and approve broken maps reports; 2 - admin, same as moderator plus can delete maps from vault
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2086 version_lobby]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || file || varchar(100) ||
 +
|-
 +
|  || version || varchar(100) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2100 view_global_rating]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u ||
 +
|-
 +
|  || mean || float ||
 +
|-
 +
|  || deviation || float ||
 +
|-
 +
|  || numGames || smallint(4)u ||
 +
|-
 +
|  || is_active || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2116 vm_exempt]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || idUser || mediumint(8)u ||
 +
|-
 +
|  || reason || varchar(255) ||
 
|}
 
|}

Revision as of 01:44, 4 September 2016

Server db-Tables

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