DB:Auth:account banned 548: Difference between revisions
Jump to navigation
Jump to search
(Created page with "placeholder") |
(Final) |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
{| align="right" | |||
|- | |||
| __TOC__ | |||
|} | |||
{{Back-to:Auth_18414}} | |||
<big>'''The `account_banned` table'''</big> | |||
This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire. | |||
<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 `sf_auth`.`Untitled` ( | |||
`id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Account id', | |||
`bandate` int UNSIGNED NOT NULL DEFAULT 0, | |||
`unbandate` int UNSIGNED NOT NULL DEFAULT 0, | |||
`bannedby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, | |||
`banreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, | |||
`active` tinyint UNSIGNED NOT NULL DEFAULT 1, | |||
PRIMARY KEY (`id`, `bandate`) USING BTREE | |||
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Ban List' ROW_FORMAT = Dynamic; | |||
; | |||
</pre> | |||
<big>'''Description of the fields'''</big> | |||
==== id ==== | |||
The account ID. | |||
==== bandate==== | |||
The date when the account was banned, in Unix time. | |||
==== unbandate==== | |||
The date when the account will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban. | |||
==== bannedby ==== | |||
The GM character's name who banned that account. If banned from the console, then it will be empty (until improved). | |||
==== banreason ==== | |||
The reason for the ban. | |||
==== active ==== | |||
Boolean 0 or 1 controlling if the ban is currently active or not. |
Latest revision as of 21:00, 2 August 2023
Back to auth database list of tables.
The `account_banned` table
This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire.
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 `sf_auth`.`Untitled` ( `id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Account id', `bandate` int UNSIGNED NOT NULL DEFAULT 0, `unbandate` int UNSIGNED NOT NULL DEFAULT 0, `bannedby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `banreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `active` tinyint UNSIGNED NOT NULL DEFAULT 1, PRIMARY KEY (`id`, `bandate`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Ban List' ROW_FORMAT = Dynamic; ;
Description of the fields
id
The account ID.
bandate
The date when the account was banned, in Unix time.
unbandate
The date when the account will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban.
bannedby
The GM character's name who banned that account. If banned from the console, then it will be empty (until improved).
banreason
The reason for the ban.
active
Boolean 0 or 1 controlling if the ban is currently active or not.