DB/Schema: Rename _questrelation tables to _queststarter and _involvedrelation to _questender, for creature and gameobject

1 files changed, 28 insertions, 0 deletions

diff --git a/sql/updates/world/2013_08_05_02_world_quest_relation_tables.sql b/sql/updates/world/2013_08_05_02_world_quest_relation_tables.sql
new file mode 100644
index 00000000000..a7d2af1725a
--- /dev/null
+++ b/sql/updates/world/2013_08_05_02_world_quest_relation_tables.sql
@@ -0,0 +1,28 @@
+ALTER TABLE `creature_questrelation`       RENAME `creature_queststarter`;
+ALTER TABLE `creature_involvedrelation`    RENAME `creature_questender`;
+ALTER TABLE `gameobject_questrelation`     RENAME `gameobject_queststarter`;
+ALTER TABLE `gameobject_involvedrelation`  RENAME `gameobject_questender`;
+
+UPDATE `command` SET
+    `name` = 'reload gameobject_queststarter',
+    `help` = 'Syntax: .reload gameobject_queststarter\nReload gameobject_queststarter table.'
+WHERE
+    `name` = 'reload gameobject_questrelation';
+
+UPDATE `command` SET
+    `name` = 'reload gameobject_questender',
+    `help` = 'Syntax: .reload gameobject_questender\nReload gameobject_questender table.'
+WHERE
+    `name` = 'reload gameobject_questrelation';
+
+UPDATE `command` SET
+    `name` = 'reload creature_queststarter',
+    `help` = 'Syntax: .reload creature_queststarter\nReload creature_queststarter table.'
+WHERE
+    `name` = 'reload creature_questrelation';
+
+UPDATE `command` SET
+    `name` = 'reload creature_questender',
+    `help` = 'Syntax: .reload creature_questender\nReload creature_questender table.'
+WHERE
+    `name` = 'reload creature_involvedrelation';