diff options
| author | Rat <gmstreetrat@gmail.com> | 2015-04-06 21:03:50 +0200 |
|---|---|---|
| committer | Rat <gmstreetrat@gmail.com> | 2015-04-06 21:03:50 +0200 |
| commit | 9b746368db5634053c918ed8e67349b73a6fbd16 (patch) | |
| tree | 2b7a51041be7c32e5103a7540fcf5069186199d8 /sql/updates/world | |
| parent | 11f6b9af0bb59458721abc8486757ce5e1e4b6b0 (diff) | |
Core/Database: removed old questItem fields
Diffstat (limited to 'sql/updates/world')
| -rw-r--r-- | sql/updates/world/2015_04_06_01_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2015_04_06_02_world.sql | 29 |
2 files changed, 30 insertions, 1 deletions
diff --git a/sql/updates/world/2015_04_06_01_world.sql b/sql/updates/world/2015_04_06_01_world.sql index a47def6c50c..862ee222679 100644 --- a/sql/updates/world/2015_04_06_01_world.sql +++ b/sql/updates/world/2015_04_06_01_world.sql @@ -12,4 +12,4 @@ CREATE TABLE `gameobject_questitem` ( `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;
\ No newline at end of file +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/world/2015_04_06_02_world.sql b/sql/updates/world/2015_04_06_02_world.sql new file mode 100644 index 00000000000..ea118adbb50 --- /dev/null +++ b/sql/updates/world/2015_04_06_02_world.sql @@ -0,0 +1,29 @@ +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`; + |