DB/RBAC: Fix rbac_permissions order

1 files changed, 21 insertions, 0 deletions

diff --git a/sql/updates/auth/2014_04_28_00_rbac_permissions.sql b/sql/updates/auth/2014_04_28_00_rbac_permissions.sql
new file mode 100644
index 00000000000..290052764dd
--- /dev/null
+++ b/sql/updates/auth/2014_04_28_00_rbac_permissions.sql
@@ -0,0 +1,21 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (631,632,633,634,635,636,637,638,639,640);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(633, 'Command: reload creature_linked_respawn'),
+(634, 'Command: reload creature_loot_template'),
+(635, 'Command: reload creature_onkill_reputation'),
+(636, 'Command: reload creature_questender'),
+(637, 'Command: reload creature_queststarter'),
+(638, 'Command: reload creature_summon_groups'),
+(639, 'Command: reload creature_template'),
+(640, 'Command: reload creature_text');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (631,632,633,634,635,636,637,638,639,640);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, 633),
+(196, 634),
+(196, 635),
+(196, 636),
+(196, 637),
+(196, 638),
+(196, 639),
+(196, 640);