From ade1bbdd62f980e7c1284f4f39dbd7f1fbf98860 Mon Sep 17 00:00:00 2001
From: Shauren <none@none>
Date: Thu, 29 Jul 2010 18:11:41 +0200
Subject: 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
---
 sql/base/world_database.sql | 14 ++++++--------
 1 file changed, 6 insertions(+), 8 deletions(-)

(limited to 'sql/base/world_database.sql')

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 */;
 
-- 
cgit v1.2.3

