diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_08_30_01_world_command.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2013_08_30_01_world_command.sql b/sql/updates/world/2013_08_30_01_world_command.sql new file mode 100644 index 00000000000..89f83d7e424 --- /dev/null +++ b/sql/updates/world/2013_08_30_01_world_command.sql @@ -0,0 +1,12 @@ +ALTER TABLE `command` CHANGE `security` `permission` UNSIGNED SMALLINT(5) DEFAULT 0 NOT NULL; + +-- Player commands +UPDATE `command` SET `permission` = 7 WHERE `permission` = 0; +-- Moderator commands +UPDATE `command` SET `permission` = 8 WHERE `permission` = 1; +-- GM commands +UPDATE `command` SET `permission` = 9 WHERE `permission` = 2; +-- administrator commands +UPDATE `command` SET `permission` = 10 WHERE `permission` = 3; +-- console commands +UPDATE `command` SET `permission` = 12 WHERE `permission` = 4; |