logs_ip_actions
The `logs_ip_actions` 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