From 9f5ca0bf29f3dd123045af8761800730701888f1 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
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

---
 .../world/2011_04_03_07_achievement_dbc.sql        | 31 ++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100644 sql/updates/world/2011_04_03_07_achievement_dbc.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2011_04_03_07_achievement_dbc.sql b/sql/updates/world/2011_04_03_07_achievement_dbc.sql
new file mode 100644
index 00000000000..1f764a75458
--- /dev/null
+++ b/sql/updates/world/2011_04_03_07_achievement_dbc.sql
@@ -0,0 +1,31 @@
+--
+-- 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;
-- 
cgit v1.2.3