API tools faq
paste
stoneharry

Untitled

stoneharry
Jul 28th, 2013
229
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.32 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. SQLyog Ultimate v9.10
  3. MySQL - 5.5.28
  4. *********************************************************************
  5. */
  6. /*!40101 SET NAMES utf8 */;
  7.  
  8. create table `creature_names` (
  9. `entry` int (10),
  10. `name` varchar (300),
  11. `subname` varchar (300),
  12. `male_displayid` int (30),
  13. `female_displayid` int (30),
  14. `male_displayid2` int (30),
  15. `female_displayid2` int (30)
  16. );
  17. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('0','Flesh Eater','','987','0','0','0');
  18. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('6','Kobold Vermin','','10913','0','0','0');
  19. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('19','Benny Questgiver','NPC','6074','0','0','0');
  20. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('29','Kanrethad','Master of Death','25275','0','0','0');
  21. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('30','Forest Spider','','382','0','0','0');
  22. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('31','Furbolg','','145','0','0','0');
  23. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('36','Harvest Golem','','367','0','0','0');
  24. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('38','Defias Thug','','5035','5036','0','0');
  25. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('40','Kobold Miner','','373','0','0','0');
  26. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('43','Mine Spider','','368','0','0','0');
  27. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('46','Murloc Forager','','441','0','0','0');
  28. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('48','Skeletal Warrior','','200','0','0','0');
  29. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('49','Lesser Succubus','','159','0','0','0');
  30. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('50','Test','1','100','0','0','0');
  31. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('51','Test','2','100','0','0','0');
  32. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('54','Corina Steele','Weaponsmith','1287','0','0','0');
  33. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('55','Mean Ed the Blacksmith','','17','0','0','0');
  34. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('60','Ruklar the Trapper','','2153','0','0','0');
  35. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('61','Thuros Lightfingers','','3341','0','0','0');
  36. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('62','Gug Fatcandle','','26','0','0','0');
  37. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('65','Peasant Woman','','13','0','0','0');
  38. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('66','Tharynn Bouden','Trade Supplies','1298','0','0','0');
  39. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('67','[UNUSED] Marlon Darnik','Grocer','23','0','0','0');
  40. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('68','Stormwind City Guard','','3167','5446','0','0');
  41. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('69','Timber Wolf','','604','0','0','0');
  42. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('70','[UNUSED] Lower Class Citizen','','13','0','0','0');
  43. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('71','Rankist','','137','0','0','0');
  44. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('72','[UNUSED] Antaris the Trader','','19','0','0','0');
  45. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('73','Veraina the Apothecary','Questgiver','15','0','0','0');
  46. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('74','Kurran Steele','Cloth & Leather Armor Merchant','1289','0','0','0');
  47. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('75','[UNUSED] Vashaum Nightwither','','166','0','0','0');
  48. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('78','Janos Hammerknuckle','Weaponsmith','3275','0','0','0');
  49. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('79','Narg the Taskmaster','','774','0','0','0');
  50. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('80','Kobold Laborer','','365','0','0','0');
  51. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('81','[UNUSED] Luglar the Clogger','','371','0','0','0');
  52. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('82','Crazy Leonetti','','16','0','0','0');
  53. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('87','Forest Troll Berserker','','167','0','0','0');
  54. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('89','Infernal','','169','0','0','0');
  55. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('90','Sea Giant','','791','0','0','0');
  56. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('92','Rock Elemental','','171','0','0','0');
  57. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('93','Centaur','','172','0','0','0');
  58. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('94','Defias Cutpurse','','2361','2362','0','0');
  59. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('95','Defias Smuggler','','4418','4419','0','0');
  60. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('97','Riverpaw Runt','','10791','0','0','0');
  61. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('98','Riverpaw Taskmaster','','376','0','0','0');
  62. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('99','Morgaine the Sly','','3320','0','0','0');
  63. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('100','Gruff Swiftbite','','175','0','0','0');
  64. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('102','Bronze Dragonspawn','','177','0','0','0');
  65. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('103','Garrick Padfoot','','2073','0','0','0');
  66. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('105','Tall Strider','','178','0','0','0');
  67. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('106','Kodo Beast','','179','0','0','0');
  68. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('108','Green Dragonspawn','','181','0','0','0');
  69. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('109','White Dragonspawn','','182','0','0','0');
  70. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('111','Priest','','20','0','0','0');
  71. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('112','Priestess','','14','0','0','0');
  72. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('113','Stonetusk Boar','','503','0','0','0');
  73. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('114','Harvest Watcher','','378','0','0','0');
  74. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('115','Harvest Reaper','','379','0','0','0');
  75. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('116','Westfall Bandit','','2357','2358','0','0');
  76. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('117','Riverpaw Gnoll','','175','0','0','0');
  77. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('118','Prowler','','11415','0','0','0');
  78. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('119','Longsnout','','381','0','0','0');
  79. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('120','Forest Stalker','','366','0','0','0');
  80. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('121','Defias Pathstalker','','2336','2337','0','0');
  81. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('122','Defias Highwayman','','2342','2343','0','0');
  82. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('123','aa','a','123','0','0','0');
  83. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('124','Riverpaw Brute','','384','0','0','0');
  84. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('125','Riverpaw Overseer','','10790','0','0','0');
  85. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('126','Murloc Coastrunner','','983','0','0','0');
  86. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('127','Murloc Tidehunter','','1995','0','0','0');
  87. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('128','Angry Programmer Tweedle Dee','Testing','1415','0','0','0');
  88. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('129','Angry Programmer Tweedle Dum','','138','0','0','0');
  89. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('130','Programmer Vendor','','62','0','0','0');
  90. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('149','[UNUSED] Small Black Dragon Whelp','','387','0','0','0');
  91. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('150','[UNUSED] Brother Milius','Bowyer','190','0','0','0');
  92. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('151','Brog Hamfist','General Supplies','1292','0','0','0');
  93. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('152','Brother Danil','General Supplies','3277','0','0','0');
  94. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('153','Bethina','Baby Murloc Redemption Merchant','14947','0','0','0');
  95. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('154','Greater Fleshripper','','1105','0','0','0');
  96. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('157','Goretusk','','3027','0','0','0');
  97. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('161','[UNUSED] Ander the Monk','','18','0','0','0');
  98. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('163','[UNUSED] Destitute Farmer','','18','0','0','0');
  99. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('165','[UNUSED] Small Child','','390','0','0','0');
  100. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('167','Morhan Coppertongue','Metalsmith','1844','0','0','0');
  101. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('171','Murloc Warrior','','1305','0','0','0');
  102. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('190','Dermot Johns','Cloth & Leather Armor Merchant','3276','0','0','0');
  103. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('192','Ice Troll','','195','0','0','0');
  104. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('193','Blue Dragonspawn','','196','0','0','0');
  105. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('196','Eagan Peltskinner','','3251','0','0','0');
  106. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('197','Major McBride','','1859','0','0','0');
  107. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('198','Khelden Bremen','Mage Trainer','5001','0','0','0');
  108. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('199','Young Fleshripper','','410','0','0','0');
  109. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('200','Shambling Skeleton UNUSED','','158','0','0','0');
  110. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('201','Brittlebones Skeleton','','11400','0','0','0');
  111. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('202','Skeletal Horror','','9786','0','0','0');
  112. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('203','Skeletal Mage','','9783','0','0','0');
  113. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('204','[UNUSED] Cackle Flamebone','','200','0','0','0');
  114. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('205','Nightbane Dark Runner','','736','0','0','0');
  115. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('206','Nightbane Vile Fang','','522','0','0','0');
  116. insert into `creature_names` (`entry`, `name`, `subname`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`) values('207','[UNUSED] Riverpaw Hideflayer','','376','0','0','0');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!