diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/9743_world_command.sql | 4 | ||||
| -rw-r--r-- | sql/updates/9743_world_lfg_dungeon_encounters.sql | 6 | ||||
| -rw-r--r-- | sql/updates/9743_world_lfg_dungeon_rewards.sql | 12 |
3 files changed, 22 insertions, 0 deletions
diff --git a/sql/updates/9743_world_command.sql b/sql/updates/9743_world_command.sql new file mode 100644 index 00000000000..4309c51db98 --- /dev/null +++ b/sql/updates/9743_world_command.sql @@ -0,0 +1,4 @@ +DELETE FROM `command` WHERE `name` IN ('reload lfg_dungeon_encounters','reload lfg_dungeon_rewards'); +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('reload lfg_dungeon_encounters',3,'Syntax: .reload lfg_dungeon_encounters\nReload lfg_dungeon_encounters table.'), +('reload lfg_dungeon_rewards',3,'Syntax: .reload lfg_dungeon_rewards\nReload lfg_dungeon_rewards table.'); diff --git a/sql/updates/9743_world_lfg_dungeon_encounters.sql b/sql/updates/9743_world_lfg_dungeon_encounters.sql new file mode 100644 index 00000000000..2e436b0edb2 --- /dev/null +++ b/sql/updates/9743_world_lfg_dungeon_encounters.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `lfg_dungeon_encounters`; +CREATE TABLE `lfg_dungeon_encounters` ( + `achievementId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Achievement marking final boss completion', + `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Dungeon entry from dbc', + PRIMARY KEY (`achievementId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/9743_world_lfg_dungeon_rewards.sql b/sql/updates/9743_world_lfg_dungeon_rewards.sql new file mode 100644 index 00000000000..0b762b59aca --- /dev/null +++ b/sql/updates/9743_world_lfg_dungeon_rewards.sql @@ -0,0 +1,12 @@ +DROP TABLE IF EXISTS `lfg_dungeon_rewards`; +CREATE TABLE `lfg_dungeon_rewards` ( + `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Dungeon entry from dbc', + `maxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Max level at which this reward is rewarded', + `firstQuestId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for first dungeon this day', + `firstMoneyVar` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Money multiplier for completing the dungeon first time in a day with less players than max', + `firstXPVar` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Experience multiplier for completing the dungeon first time in a day with less players than max', + `otherQuestId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for Nth dungeon this day', + `otherMoneyVar` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Money multiplier for completing the dungeon Nth time in a day with less players than max', + `otherXPVar` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Experience multiplier for completing the dungeon Nth time in a day with less players than max', + PRIMARY KEY (`dungeonId`,`maxLevel`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; |