blob: 91b3b3596944a3452d86b72726ea99b831e2c7b6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
# 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 | 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) | SIGNED | | NO | 127.0.0.1 | | |
| [systemnote][6] | TEXT | SIGNED | | YES | | | Notes inserted by system |
| [unixtime][7] | INT | UNSIGNED | | NO | | | Unixtime |
| [time][8] | TIMESTAMP | SIGNED | | NO | CURRENT_TIMESTAMP | | Timestamp |
| [comment][9] | TEXT | SIGNED | | YES | | | Allows users to add a comment |
[1]: #id
[2]: #accountid
[3]: #characterguid
[4]: #type
[5]: #ip
[6]: #systemnote
[7]: #unixtime
[8]: #time
[9]: #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`
|
