Core/Support: Update the support/ticket system to 6.x

Core/Mail: fix a logic error introduced in 829e11b6623f967672143d79cd8d31772f54866d

1 files changed, 77 insertions, 0 deletions

diff --git a/sql/updates/auth/2015_03_10_00_auth.sql b/sql/updates/auth/2015_03_10_00_auth.sql
new file mode 100644
index 00000000000..3206edcbd8d
--- /dev/null
+++ b/sql/updates/auth/2015_03_10_00_auth.sql
@@ -0,0 +1,77 @@
+UPDATE `rbac_permissions` SET `name`='Command: reload support' WHERE  `id`=650;
+
+DELETE FROM `rbac_permissions` WHERE `id` IN (799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES 
+(799, 'Command: .go bugticket'),
+(800, 'Command: .go complaintticket'),
+(801, 'Command: .go suggestionticket'),
+(802, 'Command: .ticket bug'),
+(803, 'Command: .ticket complaint'),
+(804, 'Command: .ticket suggestion'),
+(805, 'Command: .ticket bug assign'),
+(806, 'Command: .ticket bug close'),
+(807, 'Command: .ticket bug closedlist'),
+(808, 'Command: .ticket bug comment'),
+(809, 'Command: .ticket bug delete'),
+(810, 'Command: .ticket bug list'),
+(811, 'Command: .ticket bug unassign'),
+(812, 'Command: .ticket bug view'),
+(813, 'Command: .ticket complaint assign'),
+(814, 'Command: .ticket complaint close'),
+(815, 'Command: .ticket complaint closedlist'),
+(816, 'Command: .ticket complaint comment'),
+(817, 'Command: .ticket complaint delete'),
+(818, 'Command: .ticket complaint list'),
+(819, 'Command: .ticket complaint unassign'),
+(820, 'Command: .ticket complaint view'),
+(821, 'Command: .ticket suggestion assign'),
+(822, 'Command: .ticket suggestion close'),
+(823, 'Command: .ticket suggestion closedlist'),
+(824, 'Command: .ticket suggestion comment'),
+(825, 'Command: .ticket suggestion delete'),
+(826, 'Command: .ticket suggestion list'),
+(827, 'Command: .ticket suggestion unassign'),
+(828, 'Command: .ticket suggestion view'),
+(829, 'Command: .ticket reset all'),
+(830, 'Command: .ticket reset gm'),
+(831, 'Command: .ticket reset bug'),
+(832, 'Command: .ticket reset complaint'),
+(833, 'Command: .ticket reset suggestion');
+
+DELETE FROM `rbac_linked_permissions` WHERE `id` = 198 AND `linkedId` IN (799,800,801,892,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES 
+(198, 799),
+(198, 800),
+(198, 801),
+(198, 802),
+(198, 803),
+(198, 804),
+(197, 805),
+(198, 806),
+(198, 807),
+(198, 808),
+(196, 809),
+(198, 810),
+(197, 811),
+(198, 812),
+(197, 813),
+(198, 814),
+(198, 815),
+(198, 816),
+(196, 817),
+(198, 818),
+(197, 819),
+(198, 820),
+(197, 821),
+(198, 822),
+(198, 823),
+(198, 824),
+(196, 825),
+(198, 826),
+(197, 827),
+(198, 828),
+(196, 829),
+(196, 830),
+(196, 831),
+(196, 832),
+(196, 833);