# logs\_ip\_actions

[<-Back-to:Auth](database-auth.md)

**The \`logs\_ip\_actions\` table**

## Structure

| Field               | Type        | Attributes | Key | Null | Default           | Extra          | Comment                       |
|---------------------|-------------|------------|-----|------|-------------------|----------------|-------------------------------|
| [id][1]             | int(10)     | unsigned   | PRI | NO   |                   | auto_increment | Unique Identifier             |
| [account_id][2]     | int(10)     | unsigned   |     | NO   |                   |                | Account ID                    |
| [character_guid][3] | int(10)     | unsigned   |     | NO   |                   |                | Character Guid                |
| [type][4]           | tinyint(3)  | unsigned   |     | NO   |                   |                |                               |
| [ip][5]             | varchar(15) |            |     | NO   | 127.0.0.1         |                |                               |
| [systemnote][6]     | text        |            |     | YES  |                   |                | Notes inserted by system      |
| [unixtime][7]       | int(10)     | unsigned   |     | NO   |                   |                | Unixtime                      |
| [time][8]           | timestamp   |            |     | NO   | CURRENT_TIMESTAMP |                | Timestamp                     |
| [comment][9]        | text        |            |     | YES  |                   |                | Allows users to add a comment |

[1]: #id
[2]: #account_id
[3]: #character_guid
[4]: #type
[5]: #ip
[6]: #systemnote
[7]: #unixtime
[8]: #time
[9]: #comment

## Description of the fields

### id

### account_id

### character_guid

### type

### ip

### systemnote

### unixtime

### time

### comment