diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mangos.sql | 10 | ||||
| -rw-r--r-- | sql/updates/7945_01_mangos_quest_template.sql | 11 |
2 files changed, 20 insertions, 1 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index e8455a0c4ee..346495436d3 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, `creature_ai_version` varchar(120) default NULL, - `required_7908_03_mangos_creature_template_addon` bit(1) default NULL + `required_7945_01_mangos_quest_template` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -13264,12 +13264,20 @@ CREATE TABLE `quest_template` ( `DetailsEmote2` smallint(5) unsigned NOT NULL default '0', `DetailsEmote3` smallint(5) unsigned NOT NULL default '0', `DetailsEmote4` smallint(5) unsigned NOT NULL default '0', + `DetailsEmoteDelay1` int(11) unsigned NOT NULL default '0', + `DetailsEmoteDelay2` int(11) unsigned NOT NULL default '0', + `DetailsEmoteDelay3` int(11) unsigned NOT NULL default '0', + `DetailsEmoteDelay4` int(11) unsigned NOT NULL default '0', `IncompleteEmote` smallint(5) unsigned NOT NULL default '0', `CompleteEmote` smallint(5) unsigned NOT NULL default '0', `OfferRewardEmote1` smallint(5) unsigned NOT NULL default '0', `OfferRewardEmote2` smallint(5) unsigned NOT NULL default '0', `OfferRewardEmote3` smallint(5) unsigned NOT NULL default '0', `OfferRewardEmote4` smallint(5) unsigned NOT NULL default '0', + `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL default '0', + `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL default '0', + `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL default '0', + `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0', `StartScript` mediumint(8) unsigned NOT NULL default '0', `CompleteScript` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`entry`) diff --git a/sql/updates/7945_01_mangos_quest_template.sql b/sql/updates/7945_01_mangos_quest_template.sql new file mode 100644 index 00000000000..2c4b9a30157 --- /dev/null +++ b/sql/updates/7945_01_mangos_quest_template.sql @@ -0,0 +1,11 @@ +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`; |