Command 548: Difference between revisions
Jump to navigation
Jump to search
(Update structure and add DB structure.) |
(Derp) |
||
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> | ||
Revision as of 20:12, 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 |
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.