skill_spellbooks.sql 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. --
  2. -- Table structure for table `skill_spellbooks`
  3. --
  4. DROP TABLE IF EXISTS skill_spellbooks;
  5. CREATE TABLE `skill_spellbooks` (
  6. `skill_id` int(11) NOT NULL default '-1',
  7. `item_id` int(11) NOT NULL default '-1',
  8. KEY `skill_id` (`skill_id`,`item_id`)
  9. ) TYPE=MyISAM;
  10. --
  11. -- Dumping data for table `skill_spellbooks`
  12. --
  13. INSERT INTO `skill_spellbooks` VALUES (2,1512);
  14. INSERT INTO `skill_spellbooks` VALUES (10,3039);
  15. INSERT INTO `skill_spellbooks` VALUES (13,3940);
  16. INSERT INTO `skill_spellbooks` VALUES (15,1513);
  17. INSERT INTO `skill_spellbooks` VALUES (21,1377);
  18. INSERT INTO `skill_spellbooks` VALUES (22,3040);
  19. INSERT INTO `skill_spellbooks` VALUES (25,3038);
  20. INSERT INTO `skill_spellbooks` VALUES (33,3041);
  21. INSERT INTO `skill_spellbooks` VALUES (44,3432);
  22. INSERT INTO `skill_spellbooks` VALUES (45,1378);
  23. INSERT INTO `skill_spellbooks` VALUES (46,3042);
  24. INSERT INTO `skill_spellbooks` VALUES (49,3043);
  25. INSERT INTO `skill_spellbooks` VALUES (58,1096);
  26. INSERT INTO `skill_spellbooks` VALUES (61,1379);
  27. INSERT INTO `skill_spellbooks` VALUES (65,3044);
  28. INSERT INTO `skill_spellbooks` VALUES (67,3045);
  29. INSERT INTO `skill_spellbooks` VALUES (69,3046);
  30. INSERT INTO `skill_spellbooks` VALUES (70,1097);
  31. INSERT INTO `skill_spellbooks` VALUES (72,3047);
  32. INSERT INTO `skill_spellbooks` VALUES (77,1095);
  33. INSERT INTO `skill_spellbooks` VALUES (86,3048);
  34. INSERT INTO `skill_spellbooks` VALUES (91,1294);
  35. INSERT INTO `skill_spellbooks` VALUES (102,1380);
  36. INSERT INTO `skill_spellbooks` VALUES (103,3049);
  37. INSERT INTO `skill_spellbooks` VALUES (105,1381);
  38. INSERT INTO `skill_spellbooks` VALUES (115,1382);
  39. INSERT INTO `skill_spellbooks` VALUES (122,3050);
  40. INSERT INTO `skill_spellbooks` VALUES (123,3051);
  41. INSERT INTO `skill_spellbooks` VALUES (127,3052);
  42. INSERT INTO `skill_spellbooks` VALUES (129,1383);
  43. INSERT INTO `skill_spellbooks` VALUES (230,1384);
  44. INSERT INTO `skill_spellbooks` VALUES (262,3053);
  45. INSERT INTO `skill_spellbooks` VALUES (278,3054);
  46. INSERT INTO `skill_spellbooks` VALUES (279,3055);
  47. INSERT INTO `skill_spellbooks` VALUES (283,3056);
  48. INSERT INTO `skill_spellbooks` VALUES (289,4203);
  49. INSERT INTO `skill_spellbooks` VALUES (1002,1518);
  50. INSERT INTO `skill_spellbooks` VALUES (1003,1519);
  51. INSERT INTO `skill_spellbooks` VALUES (1004,3103);
  52. INSERT INTO `skill_spellbooks` VALUES (1005,1520);
  53. INSERT INTO `skill_spellbooks` VALUES (1006,1521);
  54. INSERT INTO `skill_spellbooks` VALUES (1007,1522);
  55. INSERT INTO `skill_spellbooks` VALUES (1008,3104);
  56. INSERT INTO `skill_spellbooks` VALUES (1009,1523);
  57. INSERT INTO `skill_spellbooks` VALUES (1010,1524);
  58. INSERT INTO `skill_spellbooks` VALUES (1011,1152);
  59. INSERT INTO `skill_spellbooks` VALUES (1012,1053);
  60. INSERT INTO `skill_spellbooks` VALUES (1013,1385);
  61. INSERT INTO `skill_spellbooks` VALUES (1015,1050);
  62. INSERT INTO `skill_spellbooks` VALUES (1016,1514);
  63. INSERT INTO `skill_spellbooks` VALUES (1018,3072);
  64. INSERT INTO `skill_spellbooks` VALUES (1020,3068);
  65. INSERT INTO `skill_spellbooks` VALUES (1027,1054);
  66. INSERT INTO `skill_spellbooks` VALUES (1028,3073);
  67. INSERT INTO `skill_spellbooks` VALUES (1031,1386);
  68. INSERT INTO `skill_spellbooks` VALUES (1032,3094);
  69. INSERT INTO `skill_spellbooks` VALUES (1033,1387);
  70. INSERT INTO `skill_spellbooks` VALUES (1034,3069);
  71. INSERT INTO `skill_spellbooks` VALUES (1035,1388);
  72. INSERT INTO `skill_spellbooks` VALUES (1036,3095);
  73. INSERT INTO `skill_spellbooks` VALUES (1040,1058);
  74. INSERT INTO `skill_spellbooks` VALUES (1042,3070);
  75. INSERT INTO `skill_spellbooks` VALUES (1043,1389);
  76. INSERT INTO `skill_spellbooks` VALUES (1044,1390);
  77. INSERT INTO `skill_spellbooks` VALUES (1045,3096);
  78. INSERT INTO `skill_spellbooks` VALUES (1047,4207);
  79. INSERT INTO `skill_spellbooks` VALUES (1048,3097);
  80. INSERT INTO `skill_spellbooks` VALUES (1049,3071);
  81. INSERT INTO `skill_spellbooks` VALUES (1050,3098);
  82. INSERT INTO `skill_spellbooks` VALUES (1056,3079);
  83. INSERT INTO `skill_spellbooks` VALUES (1059,1391);
  84. INSERT INTO `skill_spellbooks` VALUES (1062,1392);
  85. INSERT INTO `skill_spellbooks` VALUES (1064,3064);
  86. INSERT INTO `skill_spellbooks` VALUES (1068,1048);
  87. INSERT INTO `skill_spellbooks` VALUES (1069,1394);
  88. INSERT INTO `skill_spellbooks` VALUES (1071,3082);
  89. INSERT INTO `skill_spellbooks` VALUES (1072,3080);
  90. INSERT INTO `skill_spellbooks` VALUES (1073,1515);
  91. INSERT INTO `skill_spellbooks` VALUES (1074,3074);
  92. INSERT INTO `skill_spellbooks` VALUES (1075,1397);
  93. INSERT INTO `skill_spellbooks` VALUES (1077,1398);
  94. INSERT INTO `skill_spellbooks` VALUES (1078,1399);
  95. INSERT INTO `skill_spellbooks` VALUES (1083,1400);
  96. INSERT INTO `skill_spellbooks` VALUES (1085,1401);
  97. INSERT INTO `skill_spellbooks` VALUES (1086,3099);
  98. INSERT INTO `skill_spellbooks` VALUES (1087,1402);
  99. INSERT INTO `skill_spellbooks` VALUES (1090,1525);
  100. INSERT INTO `skill_spellbooks` VALUES (1092,1526);
  101. INSERT INTO `skill_spellbooks` VALUES (1095,1527);
  102. INSERT INTO `skill_spellbooks` VALUES (1096,1528);
  103. INSERT INTO `skill_spellbooks` VALUES (1097,1529);
  104. INSERT INTO `skill_spellbooks` VALUES (1099,1530);
  105. INSERT INTO `skill_spellbooks` VALUES (1100,1531);
  106. INSERT INTO `skill_spellbooks` VALUES (1101,1532);
  107. INSERT INTO `skill_spellbooks` VALUES (1102,1533);
  108. INSERT INTO `skill_spellbooks` VALUES (1104,3105);
  109. INSERT INTO `skill_spellbooks` VALUES (1105,1534);
  110. INSERT INTO `skill_spellbooks` VALUES (1107,1535);
  111. INSERT INTO `skill_spellbooks` VALUES (1108,3106);
  112. INSERT INTO `skill_spellbooks` VALUES (1111,1403);
  113. INSERT INTO `skill_spellbooks` VALUES (1126,1404);
  114. INSERT INTO `skill_spellbooks` VALUES (1127,1405);
  115. INSERT INTO `skill_spellbooks` VALUES (1128,1667);
  116. INSERT INTO `skill_spellbooks` VALUES (1129,3057);
  117. INSERT INTO `skill_spellbooks` VALUES (1139,3091);
  118. INSERT INTO `skill_spellbooks` VALUES (1140,3092);
  119. INSERT INTO `skill_spellbooks` VALUES (1141,3093);
  120. INSERT INTO `skill_spellbooks` VALUES (1144,1406);
  121. INSERT INTO `skill_spellbooks` VALUES (1145,1407);
  122. INSERT INTO `skill_spellbooks` VALUES (1146,1408);
  123. INSERT INTO `skill_spellbooks` VALUES (1147,1051);
  124. INSERT INTO `skill_spellbooks` VALUES (1148,3065);
  125. INSERT INTO `skill_spellbooks` VALUES (1151,1516);
  126. INSERT INTO `skill_spellbooks` VALUES (1154,3058);
  127. INSERT INTO `skill_spellbooks` VALUES (1155,3059);
  128. INSERT INTO `skill_spellbooks` VALUES (1156,3060);
  129. INSERT INTO `skill_spellbooks` VALUES (1157,1517);
  130. INSERT INTO `skill_spellbooks` VALUES (1159,3066);
  131. INSERT INTO `skill_spellbooks` VALUES (1160,1409);
  132. INSERT INTO `skill_spellbooks` VALUES (1163,3061);
  133. INSERT INTO `skill_spellbooks` VALUES (1164,1056);
  134. INSERT INTO `skill_spellbooks` VALUES (1167,1410);
  135. INSERT INTO `skill_spellbooks` VALUES (1168,1055);
  136. INSERT INTO `skill_spellbooks` VALUES (1169,3062);
  137. INSERT INTO `skill_spellbooks` VALUES (1170,3063);
  138. INSERT INTO `skill_spellbooks` VALUES (1171,3075);
  139. INSERT INTO `skill_spellbooks` VALUES (1172,1411);
  140. INSERT INTO `skill_spellbooks` VALUES (1174,3083);
  141. INSERT INTO `skill_spellbooks` VALUES (1175,1370);
  142. INSERT INTO `skill_spellbooks` VALUES (1176,3089);
  143. INSERT INTO `skill_spellbooks` VALUES (1178,1371);
  144. INSERT INTO `skill_spellbooks` VALUES (1181,1052);
  145. INSERT INTO `skill_spellbooks` VALUES (1182,1412);
  146. INSERT INTO `skill_spellbooks` VALUES (1183,3084);
  147. INSERT INTO `skill_spellbooks` VALUES (1184,1049);
  148. INSERT INTO `skill_spellbooks` VALUES (1189,1413);
  149. INSERT INTO `skill_spellbooks` VALUES (1191,1414);
  150. INSERT INTO `skill_spellbooks` VALUES (1201,1415);
  151. INSERT INTO `skill_spellbooks` VALUES (1204,1098);
  152. INSERT INTO `skill_spellbooks` VALUES (1206,1099);
  153. INSERT INTO `skill_spellbooks` VALUES (1208,1536);
  154. INSERT INTO `skill_spellbooks` VALUES (1209,1537);
  155. INSERT INTO `skill_spellbooks` VALUES (1210,3107);
  156. INSERT INTO `skill_spellbooks` VALUES (1213,3108);
  157. INSERT INTO `skill_spellbooks` VALUES (1217,3429);
  158. INSERT INTO `skill_spellbooks` VALUES (1218,3430);
  159. INSERT INTO `skill_spellbooks` VALUES (1219,3431);
  160. INSERT INTO `skill_spellbooks` VALUES (1220,1372);
  161. INSERT INTO `skill_spellbooks` VALUES (1222,1416);
  162. INSERT INTO `skill_spellbooks` VALUES (1223,1417);
  163. INSERT INTO `skill_spellbooks` VALUES (1224,1418);
  164. INSERT INTO `skill_spellbooks` VALUES (1225,1668);
  165. INSERT INTO `skill_spellbooks` VALUES (1226,1669);
  166. INSERT INTO `skill_spellbooks` VALUES (1227,1670);
  167. INSERT INTO `skill_spellbooks` VALUES (1228,1671);
  168. INSERT INTO `skill_spellbooks` VALUES (1229,1856);
  169. INSERT INTO `skill_spellbooks` VALUES (1230,3076);
  170. INSERT INTO `skill_spellbooks` VALUES (1231,3081);
  171. INSERT INTO `skill_spellbooks` VALUES (1232,3077);
  172. INSERT INTO `skill_spellbooks` VALUES (1233,3078);
  173. INSERT INTO `skill_spellbooks` VALUES (1234,3067);
  174. INSERT INTO `skill_spellbooks` VALUES (1235,3085);
  175. INSERT INTO `skill_spellbooks` VALUES (1236,3086);
  176. INSERT INTO `skill_spellbooks` VALUES (1237,3087);
  177. INSERT INTO `skill_spellbooks` VALUES (1238,3088);
  178. INSERT INTO `skill_spellbooks` VALUES (1239,3090);
  179. INSERT INTO `skill_spellbooks` VALUES (1240,3100);
  180. INSERT INTO `skill_spellbooks` VALUES (1242,3101);
  181. INSERT INTO `skill_spellbooks` VALUES (1243,3102);
  182. INSERT INTO `skill_spellbooks` VALUES (1244,3115);
  183. INSERT INTO `skill_spellbooks` VALUES (1245,3114);
  184. INSERT INTO `skill_spellbooks` VALUES (1246,3109);
  185. INSERT INTO `skill_spellbooks` VALUES (1247,3110);
  186. INSERT INTO `skill_spellbooks` VALUES (1248,3111);
  187. INSERT INTO `skill_spellbooks` VALUES (1249,3112);
  188. INSERT INTO `skill_spellbooks` VALUES (1250,3113);
  189. INSERT INTO `skill_spellbooks` VALUES (1251,3116);
  190. INSERT INTO `skill_spellbooks` VALUES (1252,3117);
  191. INSERT INTO `skill_spellbooks` VALUES (1253,3118);
  192. INSERT INTO `skill_spellbooks` VALUES (1254,3941);
  193. INSERT INTO `skill_spellbooks` VALUES (1255,3942);
  194. INSERT INTO `skill_spellbooks` VALUES (1256,3943);
  195. INSERT INTO `skill_spellbooks` VALUES (1257,3944);
  196. INSERT INTO `skill_spellbooks` VALUES (1258,4200);
  197. INSERT INTO `skill_spellbooks` VALUES (1259,4201);
  198. INSERT INTO `skill_spellbooks` VALUES (1260,4204);
  199. INSERT INTO `skill_spellbooks` VALUES (1261,4205);
  200. INSERT INTO `skill_spellbooks` VALUES (1262,4206);
  201. INSERT INTO `skill_spellbooks` VALUES (1263,4208);