Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 834: Line 834:
 
|-
 
|-
 
|  || score || float u ||
 
|  || score || float u ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: lobby_admin
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || user_id || int(11) ||
 +
|-
 +
|  || group || tinyint(4) || 0 - no privileges; 1 - moderator, can delete/edit comments and approve broken maps reports; 2 - admin, same as moderator plus can add global bans
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: lobby_ban
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || idUser || mediumint(8)u ||
 +
|-
 +
|  || reason || varchar(255) ||
 +
|-
 +
|  || expires_at || datetime ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: login
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u+1 ||
 +
|-
 +
| U || login || varchar(20) ||
 +
|-
 +
|  || password || char(77) ||
 +
|-
 +
|  || salt || char(16) ||
 +
|-
 +
| U || email || varchar(254) ||
 +
|-
 +
|  || ip || varchar(15) ||
 +
|-
 +
| U || steamid || bigint(20)u ||
 +
|-
 +
|  || create_time || timestamp ||
 +
|-
 +
|  || update_time || timestamp ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: login_with_duplicated_users
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u+1 ||
 +
|-
 +
| U || login || varchar(20) ||
 +
|-
 +
|  || password || char(77) ||
 +
|-
 +
|  || salt || char(16) ||
 +
|-
 +
| U || email || varchar(254) ||
 +
|-
 +
|  || ip || varchar(15) ||
 +
|-
 +
| U || steamid || bigint(20)u ||
 
|}
 
|}

Revision as of 08:02, 2 September 2016

Server db-Tables

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