From f39a66d082031753046627a7ecbe695aa984e422 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 14 Jun 2014 17:13:11 +0200 Subject: SQL: Renamed files to match the naming rules --- .../auth/2014_04_26_00_auth_rbac_permissions.sql | 10 ++++++++++ sql/updates/auth/2014_04_26_00_rbac_permissions.sql | 10 ---------- .../auth/2014_04_28_00_auth_rbac_permissions.sql | 21 +++++++++++++++++++++ sql/updates/auth/2014_04_28_00_rbac_permissions.sql | 21 --------------------- 4 files changed, 31 insertions(+), 31 deletions(-) create mode 100644 sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql delete mode 100644 sql/updates/auth/2014_04_26_00_rbac_permissions.sql create mode 100644 sql/updates/auth/2014_04_28_00_auth_rbac_permissions.sql delete mode 100644 sql/updates/auth/2014_04_28_00_rbac_permissions.sql (limited to 'sql/updates/auth') diff --git a/sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql b/sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql new file mode 100644 index 00000000000..11beed8f106 --- /dev/null +++ b/sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql @@ -0,0 +1,10 @@ +SET @id = 614; + +-- Add new permissions +DELETE FROM `rbac_permissions` WHERE `id`=@id; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(@id, 'Command: broadcast_text'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@id; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(196, @id); diff --git a/sql/updates/auth/2014_04_26_00_rbac_permissions.sql b/sql/updates/auth/2014_04_26_00_rbac_permissions.sql deleted file mode 100644 index 11beed8f106..00000000000 --- a/sql/updates/auth/2014_04_26_00_rbac_permissions.sql +++ /dev/null @@ -1,10 +0,0 @@ -SET @id = 614; - --- Add new permissions -DELETE FROM `rbac_permissions` WHERE `id`=@id; -INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(@id, 'Command: broadcast_text'); - -DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@id; -INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES -(196, @id); diff --git a/sql/updates/auth/2014_04_28_00_auth_rbac_permissions.sql b/sql/updates/auth/2014_04_28_00_auth_rbac_permissions.sql new file mode 100644 index 00000000000..290052764dd --- /dev/null +++ b/sql/updates/auth/2014_04_28_00_auth_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); diff --git a/sql/updates/auth/2014_04_28_00_rbac_permissions.sql b/sql/updates/auth/2014_04_28_00_rbac_permissions.sql deleted file mode 100644 index 290052764dd..00000000000 --- a/sql/updates/auth/2014_04_28_00_rbac_permissions.sql +++ /dev/null @@ -1,21 +0,0 @@ -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); -- cgit v1.2.3