From f10d9916f13926ec00537dcf9b0cb809ced3b53a Mon Sep 17 00:00:00 2001 From: megamage Date: Fri, 5 Jun 2009 14:54:37 -0500 Subject: *Rename the quest sql because too many people ask why their quest systems are broken. --HG-- branch : trunk --- sql/updates/3747_mangos_7945_01_quest_template.sql | 9 +++++++++ sql/updates/7945_01_mangos_quest_template.sql | 11 ----------- 2 files changed, 9 insertions(+), 11 deletions(-) create mode 100644 sql/updates/3747_mangos_7945_01_quest_template.sql delete mode 100644 sql/updates/7945_01_mangos_quest_template.sql (limited to 'sql') diff --git a/sql/updates/3747_mangos_7945_01_quest_template.sql b/sql/updates/3747_mangos_7945_01_quest_template.sql new file mode 100644 index 00000000000..ab28ccd50f3 --- /dev/null +++ b/sql/updates/3747_mangos_7945_01_quest_template.sql @@ -0,0 +1,9 @@ +ALTER TABLE quest_template + ADD COLUMN `DetailsEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmote4`, + ADD COLUMN `DetailsEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay1`, + ADD COLUMN `DetailsEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay2`, + ADD COLUMN `DetailsEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay3`, + ADD COLUMN `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmote4`, + ADD COLUMN `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay1`, + ADD COLUMN `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay2`, + ADD COLUMN `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay3`; diff --git a/sql/updates/7945_01_mangos_quest_template.sql b/sql/updates/7945_01_mangos_quest_template.sql deleted file mode 100644 index 2c4b9a30157..00000000000 --- a/sql/updates/7945_01_mangos_quest_template.sql +++ /dev/null @@ -1,11 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7908_03_mangos_creature_template_addon required_7945_01_mangos_quest_template bit; - -ALTER TABLE quest_template - ADD COLUMN `DetailsEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmote4`, - ADD COLUMN `DetailsEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay1`, - ADD COLUMN `DetailsEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay2`, - ADD COLUMN `DetailsEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay3`, - ADD COLUMN `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmote4`, - ADD COLUMN `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay1`, - ADD COLUMN `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay2`, - ADD COLUMN `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay3`; -- cgit v1.2.3