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

1 files changed, 1 insertions, 0 deletions

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`;