DB:Auth:account banned 548: Difference between revisions
Jump to navigation
Jump to search
(Created page with "placeholder") |
No edit summary |
||
Line 1: | Line 1: | ||
{| align="right" | |||
|- | |||
| __TOC__ | |||
|} | |||
{{Back-to:Auth_18414}} | |||
<big>'''The `account_banned` table'''</big> | |||
This table holds banned users | |||
<big>'''Structure'''</big> | |||
{| border="1" | |||
|'''Field''' | |||
|'''Type''' | |||
|'''Attributes''' | |||
|'''Key''' | |||
|'''Null''' | |||
|'''Default''' | |||
|'''Extra''' | |||
|'''Comment''' | |||
|- | |||
|[[#id|id]] | |||
|int(10) | |||
|unsigned | |||
|PRI | |||
|NO | |||
| | |||
| | |||
| | |||
|- | |||
|[[#bandate|bandate]] | |||
|int(10) | |||
|unsigned | |||
| | |||
|NO | |||
| | |||
| | |||
| | |||
|- | |||
|[[#unbandate|unbandate]] | |||
|int(10) | |||
|unsigned | |||
| | |||
|NO | |||
| | |||
| | |||
| | |||
|- | |||
|[[#bannedby|bannedby]] | |||
|varchar(50) | |||
|unsigned | |||
| | |||
|NO | |||
| | |||
| | |||
| | |||
|- | |||
|[[#banreason|banreason]] | |||
|varchar(255) | |||
|unsigned | |||
| | |||
|NO | |||
| | |||
| | |||
| | |||
|- | |||
|[[#active|active]] | |||
|tinyint(5) | |||
|unsigned | |||
| | |||
|NO | |||
|<nowiki>-1</nowiki> | |||
| | |||
| | |||
|} | |||
<br> <big>'''DB Structure'''</big> | |||
<br> | |||
{| border="1"<br> | |||
<pre style="color: red"> | |||
CREATE TABLE `account_banned` ( | |||
`id` INT NOT NULL, | |||
`gmlevel` TINYINT NOT NULL, | |||
`RealmID` INT NOT NULL DEFAULT -1, | |||
PRIMARY KEY (`id`, `RealmID`) USING BTREE | |||
) | |||
COLLATE='utf8_general_ci' | |||
ENGINE=InnoDB | |||
; | |||
</pre> | |||
<big>'''Description of the fields'''</big> | |||
==== id ==== | |||
The account ID. | |||
==== gmlevel ==== | |||
The account security level. Different levels have access to different commands. The individual level required for a command is defined in the command table in each realm. | |||
==== RealmID ==== | |||
The Realm ID. |
Revision as of 20:54, 2 August 2023
Back to auth database list of tables.
The `account_banned` table
This table holds banned users
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
id | int(10) | unsigned | PRI | NO | |||
bandate | int(10) | unsigned | NO | ||||
unbandate | int(10) | unsigned | NO | ||||
bannedby | varchar(50) | unsigned | NO | ||||
banreason | varchar(255) | unsigned | NO | ||||
active | tinyint(5) | unsigned | NO | -1 |
DB Structure
CREATE TABLE `account_banned` ( `id` INT NOT NULL, `gmlevel` TINYINT NOT NULL, `RealmID` INT NOT NULL DEFAULT -1, PRIMARY KEY (`id`, `RealmID`) USING BTREE ) COLLATE='utf8_general_ci' ENGINE=InnoDB ;
Description of the fields
id
The account ID.
gmlevel
The account security level. Different levels have access to different commands. The individual level required for a command is defined in the command table in each realm.
RealmID
The Realm ID.