Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 269: Line 269:
 
|  || status_code || enum('unfiled','filed','dismissed') ||   
 
|  || status_code || enum('unfiled','filed','dismissed') ||   
 
|-
 
|-
|  || url || varchar(255) ||
+
|  || url || varchar(255) || If status is filed, then this should be a reference to a github issue
 
|-
 
|-
|  || create_time || Timestamp ||
+
|  || create_time || Timestamp || When this entry was created
 
|-
 
|-
|  || update_time || Timestamp ||
+
|  || update_time || Timestamp || When this entry was update
 
|}
 
|}
  
Line 327: Line 327:
 
|-
 
|-
 
|  || update_time || Timestamp || When this entry was updated
 
|  || update_time || Timestamp || When this entry was updated
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: clan_list
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || clan_id ||  int(11)+1 ||
 +
|-
 +
|  || create_date || timestamp || 
 +
|-
 +
|  || status || int(1) || 
 +
|-
 +
|  || clan_name || varchar(40) || 
 +
|-
 +
|  || clan_tag || varchar(3) || 
 +
|-
 +
|  || clan_founder_id || mediumint(8) || 
 +
|-
 +
|  || clan_leader_id || mediumint(8) || 
 +
|-
 +
|  || clan_desc || text || 
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: clan_members
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || clan_id ||  int(11) ||
 +
|-
 +
| X || player_id ||  int(11) ||
 +
|-
 +
|  || join_clan_date || timestamp || 
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: coop_leaderboard
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id ||  mediumint(8)u+1 ||
 +
|-
 +
|  || mission ||  smallint(6)u ||
 +
|-
 +
|  || gameuid ||  bigint(20)u ||
 +
|-
 +
|  || secondary ||  tinyint(3)u ||
 +
|-
 +
|  || time || time || 
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: coop_map
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id ||  mediumint(8)u+1 ||
 +
|-
 +
|  || type ||  tinyint(3)u ||
 +
|-
 +
|  || name ||  varchar(40) ||
 +
|-
 +
|  || description ||  longtext ||
 +
|-
 +
|  || version ||  decimal(4,0) ||
 +
|-
 +
|  || filename || varchar(200) || 
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: email_domain_blacklist
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || domain || varchar(255) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: event_definitions
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || varchar(36) || The ID of the event
 +
|-
 +
|  || 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.
 +
|-
 +
|  || 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.
 
|}
 
|}

Revision as of 06:06, 2 September 2016

Server db-Tables

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