diff options
Diffstat (limited to 'docs/logs_ip_actions.md')
| -rw-r--r-- | docs/logs_ip_actions.md | 40 |
1 files changed, 29 insertions, 11 deletions
diff --git a/docs/logs_ip_actions.md b/docs/logs_ip_actions.md index e138f19..91b3b35 100644 --- a/docs/logs_ip_actions.md +++ b/docs/logs_ip_actions.md @@ -4,23 +4,23 @@ **The \`logs\_ip\_actions\` table** -## Structure +**Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|---------------------|-------------|------------|-----|------|-------------------|----------------|-------------------------------| +| ------------------- | ----------- | ---------- | --- | ---- | ----------------- | -------------- | ----------------------------- | | [id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | Unique Identifier | | [account_id][2] | INT | UNSIGNED | | NO | | | Account ID | | [character_guid][3] | INT | UNSIGNED | | NO | | | Character Guid | | [type][4] | TINYINT | UNSIGNED | | NO | | | | -| [ip][5] | VARCHAR(15) | | | NO | 127.0.0.1 | | | -| [systemnote][6] | TEXT | | | YES | | | Notes inserted by system | +| [ip][5] | VARCHAR(15) | SIGNED | | NO | 127.0.0.1 | | | +| [systemnote][6] | TEXT | SIGNED | | YES | | | Notes inserted by system | | [unixtime][7] | INT | UNSIGNED | | NO | | | Unixtime | -| [time][8] | TIMESTAMP | | | NO | CURRENT_TIMESTAMP | | Timestamp | -| [comment][9] | TEXT | | | YES | | | Allows users to add a comment | +| [time][8] | TIMESTAMP | SIGNED | | NO | CURRENT_TIMESTAMP | | Timestamp | +| [comment][9] | TEXT | SIGNED | | YES | | | Allows users to add a comment | [1]: #id -[2]: #account_id -[3]: #character_guid +[2]: #accountid +[3]: #characterguid [4]: #type [5]: #ip [6]: #systemnote @@ -28,22 +28,40 @@ [8]: #time [9]: #comment -## Description of the fields +**Description of the fields** ### id -### account_id +`field-no-description|1` -### character_guid +### account\_id + +`field-no-description|2` + +### character\_guid + +`field-no-description|3` ### type +`field-no-description|4` + ### ip +`field-no-description|5` + ### systemnote +`field-no-description|6` + ### unixtime +`field-no-description|7` + ### time +`field-no-description|8` + ### comment + +`field-no-description|9` |