From 9f5ca0bf29f3dd123045af8761800730701888f1 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 3 Apr 2011 13:18:21 +0200 Subject: Core/DBC: Implemented achievement_dbc db table for filling in missing achievements and added sample data --- sql/base/world_database.sql | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) (limited to 'sql/base/world_database.sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 2d17676e89b..3fdec661001 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -75,6 +75,38 @@ LOCK TABLES `achievement_criteria_data` WRITE; /*!40000 ALTER TABLE `achievement_criteria_data` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `achievement_dbc` +-- + +DROP TABLE IF EXISTS `achievement_dbc`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `achievement_dbc` ( + `ID` int(10) unsigned NOT NULL, + `requiredFaction` int(11) NOT NULL DEFAULT '-1', + `mapID` int(11) NOT NULL DEFAULT '-1', + `points` int(10) unsigned NOT NULL DEFAULT '0', + `flags` int(10) unsigned NOT NULL DEFAULT '0', + `count` int(10) unsigned NOT NULL DEFAULT '0', + `refAchievement` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `achievement_dbc` +-- + +LOCK TABLES `achievement_dbc` WRITE; +/*!40000 ALTER TABLE `achievement_dbc` DISABLE KEYS */; +INSERT INTO `achievement_dbc` VALUES +(3696,-1,-1,0,2,1,0), -- Earned the right to represent a city in the Argent Tournament +(4788,-1,-1,0,2,1,0), -- Is exalted with The Aldor or has any of exalted rewards +(4789,-1,-1,0,2,1,0); -- Is exalted with The Scryers or has any of exalted rewards +/*!40000 ALTER TABLE `achievement_dbc` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `achievement_reward` -- -- cgit v1.2.3