Command 548

From Project Skyfire
Revision as of 20:12, 8 August 2021 by Admin (talk | contribs) (Update structure and add DB structure.)
Jump to navigation Jump to search

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.