|
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 'character_whispers' table for MaNGOSZero
This table is used to store whispers that have been sent by players.
By default it only stores whispers made in reply to tickets raised by players, but can be changed in mangos.conf to store all whispers.
It can also be completely disabled by the same setting.
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| id | int(11) unsigned | NO | PRI | NULL | 'auto_increment' | The unique id of this whisper message |
| to_guid | int(10) | NO | NULL | The GUID of the character receiving the whisper. [See character.guid]. | ||
| from_guid | int(10) | NO | NULL | The GUID of the character sending the whisper. [See character.guid]. | ||
| message | varchar(256) | NO | {Blank String} | The body text of the whisper message | ||
| regarding_ticket_id | int(11) unsigned | NO | '0' | The id of the ticket this whisper relates to. [See character_ticket.ticket_id]. | ||
| sent_on | timestamp | NO | 'CURRENT_TIMESTAMP' | Stores the time when this whisper was sent. |
Description of the fields
id int(11) unsigned
The unique id of this whisper message
to_guid int(10)
The GUID of the character receiving the whisper. [See character.guid].
from_guid int(10)
The GUID of the character sending the whisper. [See character.guid].
message varchar(256)
The body text of the whisper message
regarding_ticket_id int(11) unsigned
The id of the ticket this whisper relates to. [See character_ticket.ticket_id].
sent_on timestamp
Stores the time when this whisper was sent.
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