|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'guild_eventlog' table for MaNGOSOne
This table holds information about changes in guilds membership.
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| guildid | int(11) unsigned | NO | PRI | NULL | Id of related guild. [See guild.guildid]. | |
| LogGuid | int(11) unsigned | NO | PRI | NULL | A unique identifier given to each log entry to distinguish it. | |
| EventType | tinyint(1) unsigned | NO | NULL | The Guild Event Type. | ||
| PlayerGuid1 | int(11) unsigned | NO | MUL | NULL | Guid of character who made the change. [See character.guid] | |
| PlayerGuid2 | int(11) unsigned | NO | MUL | NULL | Guid of character who was "changed". [See character.guid] | |
| NewRank | tinyint(2) unsigned | NO | NULL | Id of new rank of PlayerGuid2. [See guild_rank.rid] | ||
| TimeStamp | bigint(20) unsigned | NO | NULL | Unix timestamp of when the event happened. |
Description of the fields
guildid int(11) unsigned
Id of related guild. [See guild.guildid].
LogGuid int(11) unsigned
A unique identifier given to each log entry to distinguish one entry from another. Two guild event logs can NOT have same GUID.
EventType tinyint(1) unsigned
The Guild Event Type:
| Value | Meaning |
|---|---|
| 1 | GUILD_EVENT_LOG_INVITE_PLAYER |
| 2 | GUILD_EVENT_LOG_JOIN_GUILD |
| 3 | GUILD_EVENT_LOG_PROMOTE_PLAYER |
| 4 | GUILD_EVENT_LOG_DEMOTE_PLAYER |
| 5 | GUILD_EVENT_LOG_UNINVITE_PLAYER |
| 6 | GUILD_EVENT_LOG_LEAVE_GUILD |
PlayerGuid1 int(11) unsigned
Guid of character who made the change. [See character.guid]
PlayerGuid2 int(11) unsigned
Guid of character who was "changed". [See character.guid]
NewRank tinyint(2) unsigned
Id of new rank of PlayerGuid2. [See guild_rank.rid]
TimeStamp bigint(20) unsigned
Unix timestamp of when the event happened.
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now