Command 548: Difference between revisions
Jump to navigation
Jump to search
(Update structure and add DB structure.) |
(Add missing table entry) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 39: | Line 39: | ||
|signed | |signed | ||
| | | | ||
| | |YES | ||
| | | | ||
| | | | ||
| Line 47: | Line 47: | ||
{| border="1"<br> | {| border="1"<br> | ||
<pre style="color: red"> | <pre style="color: red"> | ||
CREATE TABLE `command` ( | CREATE TABLE `command` ( | ||
`name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', | `name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', | ||
| Line 60: | Line 58: | ||
ROW_FORMAT=FIXED | ROW_FORMAT=FIXED | ||
; | ; | ||
</pre> | |||
<br> <big>'''Description of the fields'''</big> | <br> <big>'''Description of the fields'''</big> | ||
Latest revision as of 20:16, 8 August 2021
Back to world database list of tables.
The `command` table
Holds help and permission information for commands. This table does NOT create new commands. It only sets / overrides the permission and provides a help text.
Structure
| Field | Type | Attribute | Key | Null | Default | Comment |
| name | varchar(50) | signed | PRI | NO | ||
| permission | smallint(5) | unsigned | NO | 0 | ||
| help | longtext | signed | YES |
DB Structure
CREATE TABLE `command` ( `name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `permission` SMALLINT NOT NULL DEFAULT '0', `help` LONGTEXT NULL COLLATE 'utf8_general_ci', PRIMARY KEY (`name`) USING BTREE ) COMMENT='Chat System' COLLATE='utf8_general_ci' ENGINE=MyISAM ROW_FORMAT=FIXED ;
Description of the fields
name
Name of the command.
permission
The permission required to use the command. Corresponds with rbac_permissions.id in the auth-database.
help
The in-game syntax for proper use of the command.