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/base/world_database.sql | |
| 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/base/world_database.sql')
| -rw-r--r-- | sql/base/world_database.sql | 14 |
1 files changed, 6 insertions, 8 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 7720b40f901..efca1c78603 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -25,20 +25,18 @@ DROP TABLE IF EXISTS `access_requirement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `access_requirement` ( - `id` bigint(20) unsigned NOT NULL COMMENT 'Identifier', + `mapId` mediumint(8) unsigned NOT NULL, + `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', `level_min` tinyint(3) unsigned NOT NULL DEFAULT '0', - `heroic_level_min` tinyint(3) unsigned NOT NULL DEFAULT '0', `level_max` tinyint(3) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `item2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `heroic_key` mediumint(8) unsigned NOT NULL DEFAULT '0', - `heroic_key2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `quest_done` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_done_A` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_done_H` mediumint(8) unsigned NOT NULL DEFAULT '0', + `completed_achievement` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest_failed_text` text, - `heroic_quest_done` mediumint(8) unsigned NOT NULL DEFAULT '0', - `heroic_quest_failed_text` text, `comment` text, - PRIMARY KEY (`id`) + PRIMARY KEY (`mapId`,`difficulty`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Access Requirements'; /*!40101 SET character_set_client = @saved_cs_client */; |