diff options
| author | Shauren <none@none> | 2010-07-29 18:11:41 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-07-29 18:11:41 +0200 |
| commit | ade1bbdd62f980e7c1284f4f39dbd7f1fbf98860 (patch) | |
| tree | 791c58dc29d7c226e6bc1837f22b6a6fb1d6b136 /sql/updates | |
| parent | dfe5ae36d33f2cceb6868d4a1d543804f94925b2 (diff) | |
Remade access_requirement table, now each difficulty mode for each instance has its own entry (for future Dungeon Finder development)
Added completed achievement as new requirement type
Removed obsolete access_id from areatrigger_teleport table
Implemented automatic downscaling of raid difficulty when requested mode does not exist
Changed dungeon_difficulty in characters table to instance_mode_mask saving both dungeon and raid difficulty in form (dungeon diff | raid diff << 4)
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/9081_access_requirement.sql | 12 | ||||
| -rw-r--r-- | sql/updates/9081_areatrigger_teleport.sql | 1 | ||||
| -rw-r--r-- | sql/updates/9081_characters_characters.sql | 1 |
3 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/9081_access_requirement.sql b/sql/updates/9081_access_requirement.sql new file mode 100644 index 00000000000..da7e108636a --- /dev/null +++ b/sql/updates/9081_access_requirement.sql @@ -0,0 +1,12 @@ +ALTER TABLE `access_requirement` + DROP PRIMARY KEY, + CHANGE `id` `mapId` mediumint(8) unsigned NOT NULL FIRST, + ADD `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `mapId`, + DROP `heroic_level_min`, + DROP `heroic_key`, + DROP `heroic_key2`, + CHANGE `quest_done` `quest_done_A` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `item2`, + CHANGE `heroic_quest_done` `quest_done_H` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `quest_done_A`, + ADD `completed_achievement` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `quest_done_H`, + DROP `heroic_quest_failed_text`, + ADD PRIMARY KEY(`mapId`,`difficulty`); diff --git a/sql/updates/9081_areatrigger_teleport.sql b/sql/updates/9081_areatrigger_teleport.sql new file mode 100644 index 00000000000..d8df8fafbf9 --- /dev/null +++ b/sql/updates/9081_areatrigger_teleport.sql @@ -0,0 +1 @@ +ALTER TABLE `areatrigger_teleport` DROP `access_id`; diff --git a/sql/updates/9081_characters_characters.sql b/sql/updates/9081_characters_characters.sql new file mode 100644 index 00000000000..1e7b32e47a5 --- /dev/null +++ b/sql/updates/9081_characters_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` CHANGE `dungeon_difficulty` `instance_mode_mask` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 AFTER `instance_id`; |