Difference between revisions of "Server Info"

From FA Forever Wiki
Jump to: navigation, search
Line 1,393: Line 1,393:
 
|-
 
|-
 
|  || ranked || tinyint(4) ||
 
|  || ranked || tinyint(4) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1371 tutorial_sections]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
|  || id || int(10)u+1 ||
 +
|-
 +
|  || section || varchar(45) ||
 +
|-
 +
|  || description || varchar(100) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1385 tutorials]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || section || int(10)u ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || description || varchar(255) ||
 +
|-
 +
|  || url || varchar(45) ||
 +
|-
 +
|  || map || varchar(100) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1404 unique_id_users]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || user_id || mediumint(8)u ||
 +
|-
 +
| X || uniqueid_hash || char(32) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1417 uniqueid]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || mediumint(8)u+1 ||
 +
|-
 +
| U || hash || char(32) ||
 +
|-
 +
|  || uuid || varchar(255) ||
 +
|-
 +
|  || mem_SerialNumber || varchar(255) ||
 +
|-
 +
|  || deviceID || varchar(255) ||
 +
|-
 +
|  || manufacturer || varchar(255) ||
 +
|-
 +
|  || name || varchar(255) ||
 +
|-
 +
|  || processorId || varchar(255) ||
 +
|-
 +
|  || SMBIOSBIOSVersion || varchar(255) ||
 +
|-
 +
|  || serialNumber || varchar(255) ||
 +
|-
 +
|  || volumeSerialNumber || varchar(255) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1440 uniqueid_exempt]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || user_id || mediumint(8)u ||
 +
|-
 +
|  || reason || varchar(255) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1467 updates_balancetesting]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1481 updates_balancetesting_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1499 updates_blackops]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1513 updates_blackops_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1531 updates_civilians]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1545 updates_civilians_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1563 updates_claustrophobia]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1577 updates_claustrophobia_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1595 updates_coop]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1609 updates_coop_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1627 updates_diamond]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1641 updates_diamond_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1659 updates_engyredesign]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1673 updates_engyredesign_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1690 updates_faf]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1704 updates_faf_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1722 updates_gw]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1736 updates_gw_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1754 updates_koth]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1768 updates_koth_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1786 updates_labwars]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1800 updates_labwars_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1818 updates_matchmaker]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1832 updates_matchmaker_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1850 updates_murderparty]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1864 updates_murderparty_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1882 updates_nomads]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1896 updates_nomads_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1914 updates_phantomx]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1928 updates_phantomx_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1946 updates_supremeDestruction]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1960 updates_supremeDestruction_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1978 updates_vanilla]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L1992 updates_vanilla_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2010 updates_wyvern]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2024 updates_wyvern_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2041 updates_xtremewars]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| U || id || smallint(5)u+1 ||
 +
|-
 +
|  || filename || varchar(45) ||
 +
|-
 +
|  || path || varchar(45) ||
 +
|}
 +
 +
:
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2055 updates_xtremewars_files]
 +
|-
 +
|style="padding:0;border:none"|
 +
:
 +
|-
 +
!scope="col"|PK||Field||Type||Comment
 +
|-
 +
| X || id || int(10)u+1 ||
 +
|-
 +
|  || fileId || smallint(5)u ||
 +
|-
 +
|  || version || int(11) ||
 +
|-
 +
|  || name || varchar(45) ||
 +
|-
 +
|  || md5 || varchar(45) ||
 +
|-
 +
|  || obselete || tinyint(1) ||
 +
|}
 +
 +
 +
{|class="wikitable collapsible collapsed" style="border:none;margin:0"
 +
|-
 +
!colspan="4"|Table: [https://github.com/FAForever/db/blob/develop/db-structure.sql#L2073 vault_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 delete maps from vault
 
|}
 
|}

Revision as of 01:33, 4 September 2016

Server db-Tables

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