Core/Support: Drop parts of the support system since Blizz switched to a browser based ticket system

3 files changed, 25 insertions, 0 deletions

diff --git a/sql/updates/auth/2015_07_08_01_auth.sql b/sql/updates/auth/2015_07_08_01_auth.sql
new file mode 100644
index 00000000000..1d755dbb86d
--- /dev/null
+++ b/sql/updates/auth/2015_07_08_01_auth.sql
@@ -0,0 +1 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (383, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 754, 755, 756, 758, 759, 760, 830);
diff --git a/sql/updates/characters/2015_07_08_00_characters.sql b/sql/updates/characters/2015_07_08_00_characters.sql
new file mode 100644
index 00000000000..2beacc60feb
--- /dev/null
+++ b/sql/updates/characters/2015_07_08_00_characters.sql
@@ -0,0 +1,3 @@
+DROP TABLE IF EXISTS `gm_ticket`;
+DROP TABLE IF EXISTS `gm_survey`;
+DROP TABLE IF EXISTS `gm_subsurvey`;
diff --git a/sql/updates/world/2015_07_08_00_world.sql b/sql/updates/world/2015_07_08_00_world.sql
new file mode 100644
index 00000000000..1c20d309551
--- /dev/null
+++ b/sql/updates/world/2015_07_08_00_world.sql
@@ -0,0 +1,21 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (2000, 2001, 2002, 2008, 2010, 2019, 2026, 2029, 2030);
+
+DELETE FROM `command` WHERE `name` IN (
+'go ticket',
+'ticket assign',
+'ticket close',
+'ticket closedlist',
+'ticket comment',
+'ticket delete',
+'ticket escalate',
+'ticket escalatedlist',
+'ticket list',
+'ticket onlinelist',
+'ticket reset gm',
+'ticket response',
+'ticket response append',
+'ticket response appendln',
+'ticket unassign',
+'ticket viewid',
+'ticket viewname'
+);