aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/world
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/world')
-rw-r--r--sql/updates/world/2013_08_05_02_world_quest_relation_tables.sql28
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';