logs_ip_actions
The `logs_ip_actions` table
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | INT | UNSIGNED | PRI | NO | AUTO_INCREMENT | Unique Identifier | |
| account_id | INT | UNSIGNED | NO | Account ID | |||
| character_guid | INT | UNSIGNED | NO | Character Guid | |||
| type | TINYINT | UNSIGNED | NO | ||||
| ip | VARCHAR(15) | SIGNED | NO | 127.0.0.1 | |||
| systemnote | TEXT | SIGNED | YES | Notes inserted by system | |||
| unixtime | INT | UNSIGNED | NO | Unixtime | |||
| time | TIMESTAMP | SIGNED | NO | CURRENT_TIMESTAMP | Timestamp | ||
| comment | TEXT | SIGNED | YES | Allows users to add a comment |
Description of the fields
id
field-no-description|1
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