From 1c0b0f825c70c2fee8c3c5280e5015275056624e Mon Sep 17 00:00:00 2001 From: ShinDarth Date: Sun, 21 Jun 2015 13:32:51 +0200 Subject: DB/World schema backport: move questItem* fields to *_questitem tables --- sql/updates/world/2015_06_29_00_world_335.sql | 44 +++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 sql/updates/world/2015_06_29_00_world_335.sql (limited to 'sql') 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`; -- cgit v1.2.3