Core/RBAC: Move commands security to RBAC (using generic RBAC Permissions)

- Warning: This will break commands for any custom security level

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;