Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 442: Line 442:
 
| X || id || varchar(36) || The ID of the event
 
| X || id || varchar(36) || The ID of the event
 
|-
 
|-
| || name_key || varchar(255) || The message key for the name of the event.
+
| U || name_key || varchar(255) || The message key for the name of the event.
 
|-
 
|-
 
|  || image_url || varchar(45) || The base URL for the image that represents the event.
 
|  || image_url || varchar(45) || The base URL for the image that represents the event.
 
|-
 
|-
 
|  || type || enum('NUMERIC','TIME') || The type of the event.\nPossible values are:\n"NUMERIC" - Event is a plain number.\n"TIME" - Event is a measure of time.
 
|  || type || enum('NUMERIC','TIME') || The type of the event.\nPossible values are:\n"NUMERIC" - Event is a plain number.\n"TIME" - Event is a measure of time.
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: featured_mods_owners
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u+1 ||
 +
|-
 +
|  || uid || mediumint(8)u ||
 +
|-
 +
|  || moduid || tinyint(3)u ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: friends_and_foes
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || user_id || mediumint(8)u ||
 +
|-
 +
| X || subject_id || mediumint(8)u ||
 +
|-
 +
|  || status || enum('FRIEND','FOE') ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: game_featuredMods
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || tinyint(3)u+1 ||
 +
|-
 +
|  || gamemod || varchar(50) ||
 +
|-
 +
|  || description || text ||
 +
|-
 +
|  || name || varchar(255) ||
 +
|-
 +
|  || publish || tinyint(1) ||
 +
|-
 +
|  || order || smallint(4) || Order in the featured mods list
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: game_player_stats
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || bigint(20)u+1 ||
 +
|-
 +
|  || gameId || bigint(20)u ||
 +
|-
 +
|  || playerId || mediumint(8)u ||
 +
|-
 +
|  || AI || tinyint(1) ||
 +
|-
 +
|  || faction || tinyint(3)u ||
 +
|-
 +
|  || color || tinyint(4) ||
 +
|-
 +
|  || team || tinyint(3) ||
 +
|-
 +
|  || place || tinyint(3)u ||
 +
|-
 +
|  || mean || float u ||
 +
|-
 +
|  || deviation || float u ||
 +
|-
 +
|  || after_mean || float ||
 +
|-
 +
|  || after_deviation || float ||
 +
|-
 +
|  || score || tinyint(3) ||
 +
|-
 +
|  || scoreTime || timestamp ||
 
|}
 
|}

Revision as of 06:36, 2 September 2016

Server db-Tables

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