Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 1,253: Line 1,253:
 
|}
 
|}
  
 
+
:
 
{|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#L1184 map_version]
+
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1179 map_version]
 
|-
 
|-
 
|style="padding:0;border:none"|
 
|style="padding:0;border:none"|
Line 1,286: Line 1,286:
 
|-
 
|-
 
|  || update_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#L1225 table_map_broken]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || broken_id || mediumint(8)u+1 ||
 +
|-
 +
|  || map_id || mediumint(8)u ||
 +
|-
 +
|  || description || text ||
 +
|-
 +
|  || user_id || mediumint(8)u ||
 +
|-
 +
|  || approved || tinyint(1) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1244 table_map_comments]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || comment_id || mediumint(8)u+1 ||
 +
|-
 +
|  || map_id || mediumint(8)u ||
 +
|-
 +
|  || user_id || mediumint(8)u ||
 +
|-
 +
|  || comment_text || text ||
 +
|-
 +
|  || comment_date || timestamp ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1263 table_map_features]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || map_id || mediumint(8)u ||
 +
|-
 +
|  || rating || float ||
 +
|-
 +
|  || voters || text ||
 +
|-
 +
|  || downloads || int(11) ||
 +
|-
 +
|  || times_played || int(11) ||
 +
|-
 +
|  || num_draws || int(11) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1281 table_mod]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u+1 ||
 +
|-
 +
| U || uid || varchar(40) ||
 +
|-
 +
|  || name || varchar(255) ||
 +
|-
 +
|  || version || smallint(5)u ||
 +
|-
 +
|  || author || varchar(100) ||
 +
|-
 +
|  || ui || tinyint(4) ||
 +
|-
 +
|  || date || timestamp ||
 +
|-
 +
|  || downloads || mediumint(8)u ||
 +
|-
 +
|  || likes || mediumint(8)u ||
 +
|-
 +
|  || played || mediumint(8)u ||
 +
|-
 +
|  || decription || varchar(255) ||
 +
|-
 +
|  || filename || varchar(255) ||
 +
|-
 +
|  || icon || varchar(255) ||
 +
|-
 +
|  || likers || longblob ||
 +
|-
 +
|  || ranked || tinyint(4) ||
 
|}
 
|}

Revision as of 00:11, 4 September 2016

Server db-Tables

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