minions.sql 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  1. --
  2. -- Table structure for table `minions`
  3. --
  4. DROP TABLE IF EXISTS minions;
  5. CREATE TABLE minions (
  6. boss_id int(11) NOT NULL default '0',
  7. minion_id int(11) NOT NULL default '0',
  8. amount int(4) NOT NULL default '0',
  9. PRIMARY KEY (boss_id,minion_id)
  10. ) TYPE=MyISAM;
  11. --
  12. -- Dumping data for table `minions`
  13. --
  14. -- raidbosses
  15. INSERT INTO minions VALUES (10217,10218,3);
  16. INSERT INTO minions VALUES (10217,10219,4);
  17. INSERT INTO minions VALUES (12001,12003,5);
  18. INSERT INTO minions VALUES (10001,10002,2);
  19. INSERT INTO minions VALUES (10001,10003,2);
  20. INSERT INTO minions VALUES (10004,10005,3);
  21. INSERT INTO minions VALUES (10004,10006,1);
  22. INSERT INTO minions VALUES (10007,10008,1);
  23. INSERT INTO minions VALUES (10007,10009,2);
  24. INSERT INTO minions VALUES (10010,10011,3);
  25. INSERT INTO minions VALUES (10010,10012,1);
  26. INSERT INTO minions VALUES (10013,10014,2);
  27. INSERT INTO minions VALUES (10013,10015,2);
  28. INSERT INTO minions VALUES (10016,10017,2);
  29. INSERT INTO minions VALUES (10016,10018,2);
  30. INSERT INTO minions VALUES (10020,10021,1);
  31. INSERT INTO minions VALUES (10020,10022,1);
  32. INSERT INTO minions VALUES (10023,10024,5);
  33. INSERT INTO minions VALUES (10023,10025,5);
  34. INSERT INTO minions VALUES (10026,10027,2);
  35. INSERT INTO minions VALUES (10026,10028,4);
  36. INSERT INTO minions VALUES (10029,10030,2);
  37. INSERT INTO minions VALUES (10029,10031,3);
  38. INSERT INTO minions VALUES (10032,10033,2);
  39. INSERT INTO minions VALUES (10032,10034,6);
  40. INSERT INTO minions VALUES (10035,10036,2);
  41. INSERT INTO minions VALUES (10035,10037,3);
  42. INSERT INTO minions VALUES (10038,10039,1);
  43. INSERT INTO minions VALUES (10038,10040,4);
  44. INSERT INTO minions VALUES (10041,10042,3);
  45. INSERT INTO minions VALUES (10041,10043,1);
  46. INSERT INTO minions VALUES (10044,10045,4);
  47. INSERT INTO minions VALUES (10044,10046,1);
  48. INSERT INTO minions VALUES (10047,10048,2);
  49. INSERT INTO minions VALUES (10047,10049,2);
  50. INSERT INTO minions VALUES (10051,10052,1);
  51. INSERT INTO minions VALUES (10051,10053,1);
  52. INSERT INTO minions VALUES (10054,10055,1);
  53. INSERT INTO minions VALUES (10054,10056,1);
  54. INSERT INTO minions VALUES (10057,10058,2);
  55. INSERT INTO minions VALUES (10057,10059,3);
  56. INSERT INTO minions VALUES (10060,10061,1);
  57. INSERT INTO minions VALUES (10060,10062,1);
  58. INSERT INTO minions VALUES (10064,10065,1);
  59. INSERT INTO minions VALUES (10064,10066,1);
  60. INSERT INTO minions VALUES (10067,10068,1);
  61. INSERT INTO minions VALUES (10067,10069,1);
  62. INSERT INTO minions VALUES (10070,10071,1);
  63. INSERT INTO minions VALUES (10073,10074,1);
  64. INSERT INTO minions VALUES (10076,10077,1);
  65. INSERT INTO minions VALUES (10079,10080,1);
  66. INSERT INTO minions VALUES (10082,10083,1);
  67. INSERT INTO minions VALUES (10085,10086,1);
  68. INSERT INTO minions VALUES (10070,10072,1);
  69. INSERT INTO minions VALUES (10073,10075,1);
  70. INSERT INTO minions VALUES (10076,10078,1);
  71. INSERT INTO minions VALUES (10079,10081,1);
  72. INSERT INTO minions VALUES (10082,10084,1);
  73. INSERT INTO minions VALUES (10085,10087,1);
  74. INSERT INTO minions VALUES (10092,10094,1);
  75. INSERT INTO minions VALUES (10092,10093,1);
  76. INSERT INTO minions VALUES (10089,10091,1);
  77. INSERT INTO minions VALUES (10089,10090,1);
  78. INSERT INTO minions VALUES (10095,10096,1);
  79. INSERT INTO minions VALUES (10095,10097,1);
  80. INSERT INTO minions VALUES (10099,10100,1);
  81. INSERT INTO minions VALUES (10099,10101,1);
  82. INSERT INTO minions VALUES (10103,10104,1);
  83. INSERT INTO minions VALUES (10103,10105,1);
  84. INSERT INTO minions VALUES (10106,10107,1);
  85. INSERT INTO minions VALUES (10106,10108,1);
  86. INSERT INTO minions VALUES (10109,10110,1);
  87. INSERT INTO minions VALUES (10109,10111,1);
  88. INSERT INTO minions VALUES (10112,10113,1);
  89. INSERT INTO minions VALUES (10112,10114,1);
  90. INSERT INTO minions VALUES (10115,10116,1);
  91. INSERT INTO minions VALUES (10115,10117,1);
  92. INSERT INTO minions VALUES (10119,10120,1);
  93. INSERT INTO minions VALUES (10119,10121,1);
  94. INSERT INTO minions VALUES (10122,10123,1);
  95. INSERT INTO minions VALUES (10122,10124,1);
  96. INSERT INTO minions VALUES (10128,10129,1);
  97. INSERT INTO minions VALUES (10128,10130,1);
  98. INSERT INTO minions VALUES (10131,10132,1);
  99. INSERT INTO minions VALUES (10131,10133,1);
  100. INSERT INTO minions VALUES (10134,10135,1);
  101. INSERT INTO minions VALUES (10134,10136,1);
  102. INSERT INTO minions VALUES (10137,10138,1);
  103. INSERT INTO minions VALUES (10137,10139,1);
  104. INSERT INTO minions VALUES (10140,10141,1);
  105. INSERT INTO minions VALUES (10140,10142,1);
  106. INSERT INTO minions VALUES (10143,10144,1);
  107. INSERT INTO minions VALUES (10143,10145,1);
  108. INSERT INTO minions VALUES (10146,10147,1);
  109. INSERT INTO minions VALUES (10146,10148,1);
  110. INSERT INTO minions VALUES (10149,10150,1);
  111. INSERT INTO minions VALUES (10149,10151,1);
  112. INSERT INTO minions VALUES (10152,10153,1);
  113. INSERT INTO minions VALUES (10152,10154,1);
  114. INSERT INTO minions VALUES (10155,10156,1);
  115. INSERT INTO minions VALUES (10155,10157,1);
  116. INSERT INTO minions VALUES (10159,10160,1);
  117. INSERT INTO minions VALUES (10159,10161,1);
  118. INSERT INTO minions VALUES (10163,10164,1);
  119. INSERT INTO minions VALUES (10163,10165,1);
  120. INSERT INTO minions VALUES (10166,10167,1);
  121. INSERT INTO minions VALUES (10166,10168,1);
  122. INSERT INTO minions VALUES (10170,10171,1);
  123. INSERT INTO minions VALUES (10170,10172,1);
  124. INSERT INTO minions VALUES (10173,10174,1);
  125. INSERT INTO minions VALUES (10173,10175,1);
  126. INSERT INTO minions VALUES (10176,10177,1);
  127. INSERT INTO minions VALUES (10176,10178,1);
  128. INSERT INTO minions VALUES (10179,10180,1);
  129. INSERT INTO minions VALUES (10179,10181,1);
  130. INSERT INTO minions VALUES (10182,10183,1);
  131. INSERT INTO minions VALUES (10182,10184,1);
  132. INSERT INTO minions VALUES (10185,10186,1);
  133. INSERT INTO minions VALUES (10185,10187,1);
  134. INSERT INTO minions VALUES (10189,10190,1);
  135. INSERT INTO minions VALUES (10189,10191,1);
  136. INSERT INTO minions VALUES (10192,10193,1);
  137. INSERT INTO minions VALUES (10192,10194,1);
  138. INSERT INTO minions VALUES (10199,10200,1);
  139. INSERT INTO minions VALUES (10199,10201,1);
  140. INSERT INTO minions VALUES (10202,10203,1);
  141. INSERT INTO minions VALUES (10202,10204,1);
  142. INSERT INTO minions VALUES (10205,10206,1);
  143. INSERT INTO minions VALUES (10205,10207,1);
  144. INSERT INTO minions VALUES (10208,10209,1);
  145. INSERT INTO minions VALUES (10208,10210,1);
  146. INSERT INTO minions VALUES (10211,10212,1);
  147. INSERT INTO minions VALUES (10211,10213,1);
  148. INSERT INTO minions VALUES (10214,10215,1);
  149. INSERT INTO minions VALUES (10214,10216,1);
  150. INSERT INTO minions VALUES (10220,10221,1);
  151. INSERT INTO minions VALUES (10220,10222,1);
  152. -- c1 mobs
  153. INSERT INTO minions VALUES (409, 482, 4);
  154. INSERT INTO minions VALUES (687, 688, 4);
  155. INSERT INTO minions VALUES (689, 690, 5);
  156. INSERT INTO minions VALUES (691, 692, 3);
  157. INSERT INTO minions VALUES (693, 694, 4);
  158. INSERT INTO minions VALUES (695, 696, 6);
  159. INSERT INTO minions VALUES (697, 698, 2);
  160. INSERT INTO minions VALUES (701, 702, 4);
  161. INSERT INTO minions VALUES (703, 704, 4);
  162. INSERT INTO minions VALUES (705, 706, 4);
  163. INSERT INTO minions VALUES (707, 708, 3);
  164. INSERT INTO minions VALUES (709, 710, 5);
  165. INSERT INTO minions VALUES (711, 712, 5);
  166. INSERT INTO minions VALUES (713, 714, 3);
  167. INSERT INTO minions VALUES (715, 716, 4);
  168. INSERT INTO minions VALUES (717, 718, 8);
  169. INSERT INTO minions VALUES (761 ,762 ,2);
  170. INSERT INTO minions VALUES (719 ,720 ,8);
  171. INSERT INTO minions VALUES (721 ,722 ,4);
  172. INSERT INTO minions VALUES (763 ,764 ,1);
  173. INSERT INTO minions VALUES (763 ,765 ,1);
  174. INSERT INTO minions VALUES (763 ,766 ,1);