text: 
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  DROP TABLE IF EXISTS `character_achievement`;
  CREATE TABLE `character_achievement` (
    `guid` int(10) unsigned NOT NULL,
    `achievement` smallint(5) unsigned NOT NULL,
    `date` int(10) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`guid`,`achievement`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `character_achievement` WRITE;
  /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
  INSERT INTO `character_achievement` VALUES (4,457,1304281812),(4,467,1304281813),(4,1407,1304281813),(6,6,1304281937),(6,7,1304281937),(6,8,1304281937),(6,9,1304281937),(6,10,1304281937),(6,11,1304281937),(6,12,1304281937),(6,13,1304281937),(6,16,1304281937),(6,460,1304281937),(6,477,1304384438),(6,727,1304283035),(6,889,1304376977),(6,890,1304377609),(6,891,1304376977),(6,892,1304377609),(6,2716,1304375441),(6,4826,1304281937),(6,4989,1304281937),(6,5095,1304384438),(6,5151,1304281937),(6,5152,1304281937),(6,5153,1304281937),(6,5154,1304281937),(6,5155,1304281937),(6,5156,1304281937),(6,5157,1304281937),(7,463,1304283226),(8,6,1304285918),(8,7,1304285918),(8,8,1304285918),(8,9,1304285918),(8,10,1304285918),(8,11,1304291402),(8,12,1304296344),(8,13,1304296344),(8,16,1304377564),(8,42,1304384912),(8,43,1304384912),(8,44,1304384912),(8,45,1304384912),(8,46,1304384912),(8,131,1304285918),(8,132,1304285918),(8,461,1304296344),(8,546,1304384970),(8,605,1305924384),(8,621,1304293571),(8,627,1304384912),(8,727,1304296412),(8,728,1304384912),(8,736,1304384911),(8,750,1304384912),(8,761,1304384911),(8,765,1304384912),(8,766,1304384912),(8,768,1304384912),(8,769,1304384912),(8,770,1304384912),(8,771,1304384912),(8,772,1304384912),(8,773,1304384911),(8,774,1304384912),(8,775,1304384911),(8,776,1304384912),(8,777,1304384911),(8,778,1304384911),(8,779,1304384911),(8,780,1304384912),(8,781,1304384912),(8,782,1304384912),(8,802,1304384912),(8,841,1304384912),(8,842,1304384912),(8,843,1304384911),(8,844,1304384912),(8,845,1304384912),(8,846,1304384912),(8,847,1304384912),(8,848,1304384912),(8,849,1304384911),(8,850,1304384912),(8,851,1304384911),(8,852,1304384911),(8,853,1304384911),(8,854,1304384912),(8,855,1304384912),(8,856,1304384912),(8,857,1304384911),(8,858,1304384911),(8,859,1304384911),(8,860,1304384911),(8,861,1304384911),(8,862,1304384911),(8,863,1304384911),(8,864,1304384911),(8,865,1304384911),(8,866,1304384911),(8,867,1304384912),(8,868,1304384911),(8,889,1304285918),(8,890,1304295864),(8,891,1304285918),(8,892,1304296653),(8,1017,1306034326),(8,1176,1306366725),(8,1263,1304384912),(8,1264,1304384912),(8,1265,1304384912),(8,1266,1304384912),(8,1267,1304384912),(8,1268,1304384912),(8,1269,1304384912),(8,1270,1304384912),(8,1457,1304384912),(8,1795,1304296484),(8,1796,1304296487),(8,1797,1304296489),(8,1798,1304296491),(8,1799,1304296495),(8,2141,1304987185),(8,4396,1306365214),(8,4534,1306629221),(8,4825,1304384912),(8,4826,1304296344),(8,4827,1304384912),(8,4863,1304384912),(8,4864,1304384912),(8,4865,1304384912),(8,4866,1304384912),(8,4867,1304384912),(8,4868,1304384912),(8,4989,1304296344),(8,4995,1304384912),(8,4996,1304384912),(8,5151,1304296344),(8,5152,1304296344),(8,5153,1304296344),(8,5154,1304296344),(8,5155,1304296344),(8,5156,1304296344),(8,5157,1304296344),(8,5180,1304431895),(8,5372,1304288692),(8,5373,1304288692),(8,5471,1307575262),(9,459,1304379810),(9,1406,1304379810),(10,6,1304541452),(10,7,1304541452),(10,8,1304541452),(10,9,1304541452),(10,10,1304541452),(10,11,1304541452),(10,12,1304541452),(10,13,1304541452),(10,16,1304543542),(10,462,1304541452),(10,727,1304380829),(10,889,1306522819),(10,890,1306522819),(10,891,1306522819),(10,892,1306522822),(10,1408,1304541452),(10,4826,1304541490),(10,4989,1304541490),(10,5151,1304541490),(10,5152,1304541490),(10,5153,1304541490),(10,5154,1304541490),(10,5155,1304541490),(10,5156,1304541490),(10,5157,1304541490),(10,5180,1306522824),(17,621,1304557822),(17,727,1304545881),(20,621,1304557892),(22,6,1304894063),(22,7,1305057829),(22,891,1305063346),(24,6,1304545515),(24,7,1304545515),(24,8,1304545515),(24,9,1304545515),(24,10,1304545515),(24,11,1304545515),(24,12,1304545515),(24,13,1304545515),(24,16,1306237628),(24,1404,1304545515),(24,4826,1304545515),(24,4989,1304545515),(24,5151,1304545515),(24,5152,1304545515),(24,5153,1304545515),(24,5154,1304545515),(24,5155,1304545515),(24,5156,1304545515),(24,5157,1304545515),(34,6,1306190982),(34,7,1306249276),(35,6,1306238449),(35,7,1306238449),(35,8,1306238449),(35,9,1306238449),(35,10,1306238449),(35,11,1306238449),(35,12,1306238449),(35,13,1306238449),(35,16,1306238626),(35,430,1306239709),(35,465,1306238450),(35,696,1306239338),(35,885,1306239782),(35,889,1306239641),(35,890,1306239643),(35,891,1306239642),(35,892,1306239649),(35,2141,1306239787),(35,3096,1306239347),(35,4826,1306238450),(35,4989,1306238450),(35,5151,1306238450),(35,5152,1306238450),(35,5153,1306238450),(35,5154,1306238450),(35,5155,1306238450),(35,5156,1306238450),(35,5157,1306238450),(35,5180,1306239650),(36,6,1306358330),(36,7,1306358330),(36,8,1306358330),(36,9,1306358330),(36,10,1306358330),(36,11,1306358330),(36,12,1306358330),(36,13,1306358330),(36,16,1306360941),(36,545,1306447355),(36,556,1306508963),(36,557,1306508963),(36,605,1306443303),(36,610,1306446975),(36,622,1306445985),(36,696,1306359120),(36,727,1306361064),(36,883,1306757052),(36,885,1306359395),(36,886,1306363047),(36,889,1306359377),(36,890,1306359378),(36,891,1306359377),(36,892,1306359379),(36,964,1306850564),(36,1176,1306366725),(36,1177,1306446582),(36,1869,1306445985),(36,2078,1306441529),(36,2081,1306359434),(36,2141,1306359415),(36,2142,1306363097),(36,2716,1306358571),(36,3096,1306359127),(36,3218,1306757038),(36,3756,1306756786),(36,3757,1306756776),(36,4396,1306365214),(36,4404,1306510420),(36,4530,1306445809),(36,4534,1306614616),(36,4576,1306445809),(36,4583,1306445809),(36,4584,1306445809),(36,4597,1306445809),(36,4600,1306756768),(36,4625,1306359387),(36,4626,1306359405),(36,4627,1306359429),(36,4826,1306358330),(36,4832,1306359149),(36,4861,1306363169),(36,4989,1306358330),(36,5023,1306445809),(36,5151,1306358330),(36,5152,1306358330),(36,5153,1306358330),(36,5154,1306358330),(36,5155,1306358330),(36,5156,1306358330),(36,5157,1306358330),(36,5180,1306359379),(36,5187,1306363189),(36,5188,1306363169),(36,5372,1306508963),(36,5373,1306508963),(38,6,1306442916),(38,7,1306442916),(38,8,1306442916),(38,9,1306442916),(38,10,1306442916),(38,11,1306442916),(38,12,1306442916),(38,13,1306442916),(38,16,1306443436),(38,556,1306444187),(38,557,1306444187),(38,727,1306443673),(38,889,1306444378),(38,890,1306444378),(38,891,1306444378),(38,892,1306444382),(38,1410,1306442916),(38,2716,1306443913),(38,4826,1306442916),(38,4989,1306442916),(38,5158,1306442916),(38,5160,1306442916),(38,5161,1306442916),(38,5162,1306442916),(38,5163,1306442916),(38,5164,1306442916),(38,5165,1306442916),(38,5180,1306444384),(38,5372,1306444187),(38,5373,1306444187),(39,464,1306514055),(39,1409,1306514055),(41,6,1306560785),(41,7,1306560785),(41,8,1306560785),(41,9,1306560785),(41,10,1306560785),(41,11,1306560785),(41,12,1306560785),(41,13,1306560785),(41,16,1306561697),(41,4826,1306560785),(41,4989,1306560785),(41,5151,1306560785),(41,5152,1306560785),(41,5153,1306560785),(41,5154,1306560785),(41,5155,1306560785),(41,5156,1306560785),(41,5157,1306560785),(43,6,1306562388),(43,7,1306562388),(43,8,1306562388),(43,9,1306562388),(43,10,1306562388),(43,11,1306562388),(43,12,1306562388),(43,13,1306562388),(43,458,1306562388),(43,4826,1306562388),(43,4989,1306562388),(43,5151,1306562388),(43,5152,1306562388),(43,5153,1306562388),(43,5154,1306562388),(43,5155,1306562388),(43,5156,1306562388),(43,5157,1306562388),(50,466,1306756361),(50,1412,1306756361),(51,6,1306769565),(51,7,1306769565),(51,8,1306769565),(51,9,1306769565),(51,10,1306769565),(51,11,1306769565),(51,12,1306769565),(51,621,1306770734),(51,692,1306769998),(51,693,1306770121),(51,694,1306769743),(51,696,1306769763),(51,697,1306770383),(51,698,1306770166),(51,776,1307149480),(51,885,1306771353),(51,889,1306771344),(51,890,1306771345),(51,891,1306771344),(51,892,1306771346),(51,1176,1306790540),(51,1177,1306791093),(51,1178,1306791361),(51,1180,1306791539),(51,2078,1307573552),(51,2716,1306771088),(51,2925,1306785026),(51,2930,1306785026),(51,4849,1306786241),(51,5089,1306791088),(51,5092,1306790535),(51,5116,1306786241),(51,5121,1306786390),(51,5123,1306786514),(51,5305,1306786514),(51,5313,1306786390),(51,5372,1306770429),(51,5373,1306770429),(51,5409,1306786241),(51,5410,1306786514),(51,5411,1306786390),(51,5462,1306786241),(51,5463,1306786514),(51,5464,1306786390),(54,6,1306843824),(54,7,1306843824),(54,8,1306843824),(54,9,1306843824),(54,10,1306843824),(54,11,1306843824),(54,12,1306843824),(54,13,1306843824),(54,889,1306844006),(54,890,1306844006),(54,891,1306844006),(54,892,1306844008),(54,4826,1306843824),(54,4989,1306843824),(54,5151,1306843824),(54,5152,1306843824),(54,5153,1306843824),(54,5154,1306843824),(54,5155,1306843824),(54,5156,1306843824),(54,5157,1306843824),(54,5180,1306844008),(55,6,1306849201),(55,7,1306849201),(55,8,1306849201),(55,9,1306849201),(55,10,1306849201),(55,131,1306849201),(55,132,1306849201),(55,889,1306849181),(55,891,1306849181),(56,6,1307238650),(56,7,1307238650),(56,8,1307238650),(56,9,1307238650),(56,10,1307238650),(56,11,1307238650),(56,12,1307238650),(56,727,1307238662),(56,889,1307238909),(56,890,1307238909),(56,891,1307238909),(56,892,1307238911),(56,2716,1307238949);
  /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  