Merge pull request #14941 from ShinDarth/db_backports3

DB/World schema backport: move questItem* fields to *_questitem tables

1 files changed, 44 insertions, 0 deletions

diff --git a/sql/updates/world/2015_06_29_00_world_335.sql b/sql/updates/world/2015_06_29_00_world_335.sql
new file mode 100644
index 00000000000..c515264e0a7
--- /dev/null
+++ b/sql/updates/world/2015_06_29_00_world_335.sql
@@ -0,0 +1,44 @@
+DROP TABLE IF EXISTS `creature_questitem`;
+CREATE TABLE `creature_questitem` (
+  `CreatureEntry` int(10) unsigned NOT NULL DEFAULT '0',
+  `Idx` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemId` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`CreatureEntry`,`Idx`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `gameobject_questitem`;
+CREATE TABLE `gameobject_questitem` (
+  `GameObjectEntry` int(10) unsigned NOT NULL DEFAULT '0',
+  `Idx` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemId` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`GameObjectEntry`,`Idx`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO gameobject_questitem (`GameObjectEntry`, `Idx`, `ItemId`)
+(SELECT gameobject_template.entry, 0, gameobject_template.questItem1 FROM gameobject_template WHERE gameobject_template.questItem1 != 0);
+INSERT INTO gameobject_questitem (`GameObjectEntry`, `Idx`, `ItemId`)
+(SELECT gameobject_template.entry, 1, gameobject_template.questItem2 FROM gameobject_template WHERE gameobject_template.questItem2 != 0);
+INSERT INTO gameobject_questitem (`GameObjectEntry`, `Idx`, `ItemId`)
+(SELECT gameobject_template.entry, 2, gameobject_template.questItem3 FROM gameobject_template WHERE gameobject_template.questItem3 != 0);
+INSERT INTO gameobject_questitem (`GameObjectEntry`, `Idx`, `ItemId`)
+(SELECT gameobject_template.entry, 3, gameobject_template.questItem4 FROM gameobject_template WHERE gameobject_template.questItem4 != 0);
+INSERT INTO gameobject_questitem (`GameObjectEntry`, `Idx`, `ItemId`)
+(SELECT gameobject_template.entry, 4, gameobject_template.questItem5 FROM gameobject_template WHERE gameobject_template.questItem5 != 0);
+INSERT INTO gameobject_questitem (`GameObjectEntry`, `Idx`, `ItemId`)
+(SELECT gameobject_template.entry, 5, gameobject_template.questItem6 FROM gameobject_template WHERE gameobject_template.questItem6 != 0);
+
+INSERT INTO creature_questitem (`CreatureEntry`, `Idx`, `ItemId`)
+(SELECT creature_template.entry, 0, creature_template.questItem1 FROM creature_template WHERE creature_template.questItem1 != 0);
+INSERT INTO creature_questitem (`CreatureEntry`, `Idx`, `ItemId`)
+(SELECT creature_template.entry, 1, creature_template.questItem2 FROM creature_template WHERE creature_template.questItem2 != 0);
+INSERT INTO creature_questitem (`CreatureEntry`, `Idx`, `ItemId`)
+(SELECT creature_template.entry, 2, creature_template.questItem3 FROM creature_template WHERE creature_template.questItem3 != 0);
+INSERT INTO creature_questitem (`CreatureEntry`, `Idx`, `ItemId`)
+(SELECT creature_template.entry, 3, creature_template.questItem4 FROM creature_template WHERE creature_template.questItem4 != 0);
+INSERT INTO creature_questitem (`CreatureEntry`, `Idx`, `ItemId`)
+(SELECT creature_template.entry, 4, creature_template.questItem5 FROM creature_template WHERE creature_template.questItem5 != 0);
+INSERT INTO creature_questitem (`CreatureEntry`, `Idx`, `ItemId`)
+(SELECT creature_template.entry, 5, creature_template.questItem6 FROM creature_template WHERE creature_template.questItem6 != 0);
+
+ALTER TABLE `creature_template` DROP `questItem1`, DROP `questItem2`, DROP `questItem3`, DROP `questItem4`, DROP `questItem5`, DROP `questItem6`;
+ALTER TABLE `gameobject_template` DROP `questItem1`, DROP `questItem2`, DROP `questItem3`, DROP `questItem4`, DROP `questItem5`, DROP `questItem6`;