Core/RBAC: Change default db permissions to behave like a server with default config before RBAC conversion

(Missing change from previous commit)

To enable any of the removed config option you should now add the proper role to the proper groups
IE:
AllowTwoSide.Interaction.Mail = 1 --> Add role 19 to group 1 (Add it to players)

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/auth/2013_03_08_00_auth_misc.sql b/sql/updates/auth/2013_03_08_00_auth_misc.sql
new file mode 100644
index 00000000000..85d61beff3d
--- /dev/null
+++ b/sql/updates/auth/2013_03_08_00_auth_misc.sql
@@ -0,0 +1,9 @@
+-- Delete 'Two side mail interaction', 'Allow say chat between factions' and 'Allow channel chat between factions' from Player group
+DELETE FROM `rbac_group_roles` WHERE `groupId` = 1 AND `roleId` IN (19, 28, 30);
+
+-- Delete 'Join channels withou announce' from Moderators group
+DELETE FROM `rbac_group_roles` WHERE `groupId` = 2 AND `roleId` IN (31);
+
+-- Add 'Allow two side charater accounts'
+DELETE FROM `rbac_group_roles` WHERE `roleId` = 34;
+INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (1, 34);