Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 935: Line 935:
 
|-
 
|-
 
|  || userid || int(10)u ||
 
|  || userid || int(10)u ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: messages
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
| U || key || varchar(255) ||
 +
|-
 +
| U || language || varchar(2) ||
 +
|-
 +
| U || region || varchar(2) ||
 +
|-
 +
|  || value || text ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: name_history
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || change_time || timestamp ||
 +
|-
 +
| U || user_id || mediumint(8)u ||
 +
|-
 +
|  || previous_name || varchar(20) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: oauth_clients
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || varchar(36) ||
 +
|-
 +
| U || name || varchar(100) ||
 +
|-
 +
| U || client_secret || varchar(55) ||
 +
|-
 +
|  || client_type || enum('confidential','public') ||
 +
|-
 +
|  || redirect_uris || text ||
 +
|-
 +
|  || default_redirect_uri || varchar(2000) ||
 +
|-
 +
|  || default_scope || text ||
 +
|-
 +
|  || icon_url || varchar(2000) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: oauth_tokens
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || token_type || varchar(45) ||
 +
|-
 +
|  || access_token || varchar(36) ||
 +
|-
 +
|  || refresh_token || varchar(36) ||
 +
|-
 +
|  || client_id || varchar(36) ||
 +
|-
 +
|  || scope || text ||
 +
|-
 +
|  || expires || timestamp ||
 +
|-
 +
|  || user_id || int(10)u ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: patchs_table
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || idpatchs_table || int(10)u+1 ||
 +
|-
 +
|  || fromMD5 || varchar(45) ||
 +
|-
 +
|  || toMD5 || varchar(45) ||
 +
|-
 +
|  || patchFile || varchar(200) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: player_achievements
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || player_id || int(10)u ||
 +
|-
 +
|  || achievement_id || varchar(36) ||
 +
|-
 +
|  || current_steps || int(10)u ||
 +
|-
 +
|  || state || enum('HIDDEN','REVEALED','UNLOCKED') ||
 +
|-
 +
|  || create_time || timestamp ||
 +
|-
 +
|  || update_time || timestamp ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: player_events
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || player_id || int(10)u ||
 +
|-
 +
|  || event_id || varchar(36) ||
 +
|-
 +
|  || count || int(10)u ||
 +
|-
 +
|  || create_time || timestamp ||
 +
|-
 +
|  || update_time || timestamp ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: recoveryemails_enc
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || ID || bigint(20)u+1 ||
 +
|-
 +
|  || UserID || mediumint(8)u ||
 +
|-
 +
|  || Key || varchar(32) ||
 +
|-
 +
|  || exptDate || datetime ||
 
|}
 
|}

Revision as of 22:33, 3 September 2016

Server db-Tables

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