henna.sql 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. --
  2. -- Table structure for table `henna`
  3. --
  4. DROP TABLE IF EXISTS henna;
  5. CREATE TABLE henna (
  6. symbol_id int(11) NOT NULL default '0',
  7. symbol_name varchar(45) default NULL,
  8. dye_id int(11) default NULL,
  9. dye_amount int(11) default NULL,
  10. price int(11) default NULL,
  11. stat_INT decimal(11,0) default NULL,
  12. stat_STR decimal(11,0) default NULL,
  13. stat_CON decimal(11,0) default NULL,
  14. stat_MEM decimal(11,0) default NULL,
  15. stat_DEX decimal(11,0) default NULL,
  16. stat_WIT decimal(11,0) default NULL,
  17. PRIMARY KEY (symbol_id)
  18. ) TYPE=MyISAM;
  19. --
  20. -- Dumping data for table `henna`
  21. --
  22. INSERT INTO henna VALUES (1,'symbol_s1c3_d',4445,10,1,0,1,-3,0,0,0);
  23. INSERT INTO henna VALUES (2,'symbol_s1d3_d',4446,10,1,0,1,0,0,-3,0);
  24. INSERT INTO henna VALUES (3,'symbol_c1s3_d',4447,10,1,0,-3,1,0,0,0);
  25. INSERT INTO henna VALUES (4,'symbol_c1d3_d',4448,10,1,0,0,1,0,-3,0);
  26. INSERT INTO henna VALUES (5,'symbol_d1s3_d',4449,10,1,0,-3,0,0,1,0);
  27. INSERT INTO henna VALUES (6,'symbol_d1c3_d',4450,10,1,0,0,-3,0,1,0);
  28. INSERT INTO henna VALUES (7,'symbol_i1m3_d',4451,10,1,1,0,0,-3,0,0);
  29. INSERT INTO henna VALUES (8,'symbol_i1w3_d',4452,10,1,1,0,0,0,0,-3);
  30. INSERT INTO henna VALUES (9,'symbol_m1i3_d',4453,10,1,-3,0,0,1,0,0);
  31. INSERT INTO henna VALUES (10,'symbol_m1w3_d',4454,10,1,0,0,0,1,0,-3);
  32. INSERT INTO henna VALUES (11,'symbol_w1i3_d',4455,10,1,-3,0,0,0,0,1);
  33. INSERT INTO henna VALUES (12,'symbol_w1m3_d',4456,10,1,0,0,0,-3,0,1);
  34. INSERT INTO henna VALUES (13,'symbol_s1c2_d',4457,10,1,0,1,-2,0,0,0);
  35. INSERT INTO henna VALUES (14,'symbol_s1d2_d',4458,10,1,0,1,0,0,-2,0);
  36. INSERT INTO henna VALUES (15,'symbol_c1s2_d',4459,10,1,0,-2,1,0,0,0);
  37. INSERT INTO henna VALUES (16,'symbol_c1d2_d',4460,10,1,0,0,1,0,-2,0);
  38. INSERT INTO henna VALUES (17,'symbol_d1s2_d',4461,10,1,0,-2,0,0,1,0);
  39. INSERT INTO henna VALUES (18,'symbol_d1c2_d',4462,10,1,0,0,-2,0,1,0);
  40. INSERT INTO henna VALUES (19,'symbol_i1m2_d',4463,10,1,1,0,0,-2,0,0);
  41. INSERT INTO henna VALUES (20,'symbol_i1w2_d',4464,10,1,1,0,0,0,0,-2);
  42. INSERT INTO henna VALUES (21,'symbol_m1i2_d',4465,10,1,-2,0,0,1,0,0);
  43. INSERT INTO henna VALUES (22,'symbol_m1w2_d',4466,10,1,0,0,0,1,0,-2);
  44. INSERT INTO henna VALUES (23,'symbol_w1i2_d',4467,10,1,-2,0,0,0,0,1);
  45. INSERT INTO henna VALUES (24,'symbol_w1m2_d',4468,10,1,0,0,0,-2,0,1);
  46. INSERT INTO henna VALUES (25,'symbol_s1c1_d',4469,10,1,0,1,-1,0,0,0);
  47. INSERT INTO henna VALUES (26,'symbol_s1d1_d',4470,10,1,0,1,0,0,-1,0);
  48. INSERT INTO henna VALUES (27,'symbol_c1s1_d',4471,10,1,0,-1,1,0,0,0);
  49. INSERT INTO henna VALUES (28,'symbol_c1d1_d',4472,10,1,0,0,1,0,-1,0);
  50. INSERT INTO henna VALUES (29,'symbol_d1s1_d',4473,10,1,0,-1,0,0,1,0);
  51. INSERT INTO henna VALUES (30,'symbol_d1c1_d',4474,10,1,0,0,-1,0,1,0);
  52. INSERT INTO henna VALUES (31,'symbol_i1m1_d',4475,10,1,1,0,0,-1,0,0);
  53. INSERT INTO henna VALUES (32,'symbol_i1w1_d',4476,10,1,1,0,0,0,0,-1);
  54. INSERT INTO henna VALUES (33,'symbol_m1i1_d',4477,10,1,-1,0,0,1,0,0);
  55. INSERT INTO henna VALUES (34,'symbol_m1w1_d',4478,10,1,0,0,0,1,0,-1);
  56. INSERT INTO henna VALUES (35,'symbol_w1i1_d',4479,10,1,-1,0,0,0,0,1);
  57. INSERT INTO henna VALUES (36,'symbol_w1m1_d',4480,10,1,0,0,0,-1,0,1);
  58. INSERT INTO henna VALUES (37,'symbol_s1c3_c',4481,10,1,0,1,-3,0,0,0);
  59. INSERT INTO henna VALUES (38,'symbol_s1d3_c',4482,10,1,0,1,0,0,-3,0);
  60. INSERT INTO henna VALUES (39,'symbol_c1s3_c',4483,10,1,0,-3,1,0,0,0);
  61. INSERT INTO henna VALUES (40,'symbol_c1c3_c',4484,10,1,0,0,1,0,-3,0);
  62. INSERT INTO henna VALUES (41,'symbol_d1s3_c',4485,10,1,0,-3,0,0,1,0);
  63. INSERT INTO henna VALUES (42,'symbol_d1c3_c',4486,10,1,0,0,-3,0,1,0);
  64. INSERT INTO henna VALUES (43,'symbol_i1m3_c',4487,10,1,1,0,0,-3,0,0);
  65. INSERT INTO henna VALUES (44,'symbol_i1w3_c',4488,10,1,1,0,0,0,0,-3);
  66. INSERT INTO henna VALUES (45,'symbol_m1i3_c',4489,10,1,-3,0,0,1,0,0);
  67. INSERT INTO henna VALUES (46,'symbol_m1w3_c',4490,10,1,0,0,0,1,0,-3);
  68. INSERT INTO henna VALUES (47,'symbol_w1i3_c',4491,10,1,-3,0,0,0,0,1);
  69. INSERT INTO henna VALUES (48,'symbol_w1m3_c',4492,10,1,0,0,0,-3,0,1);
  70. INSERT INTO henna VALUES (49,'symbol_s1c2_c',4493,10,1,0,1,-2,0,0,0);
  71. INSERT INTO henna VALUES (50,'symbol_s1d2_c',4494,10,1,0,1,0,0,-2,0);
  72. INSERT INTO henna VALUES (51,'symbol_c1s2_c',4495,10,1,0,-2,1,0,0,0);
  73. INSERT INTO henna VALUES (52,'symbol_c1c2_c',4496,10,1,0,0,1,0,-2,0);
  74. INSERT INTO henna VALUES (53,'symbol_d1s2_c',4497,10,1,0,-2,0,0,1,0);
  75. INSERT INTO henna VALUES (54,'symbol_d1c2_c',4498,10,1,0,0,-2,0,1,0);
  76. INSERT INTO henna VALUES (55,'symbol_i1m2_c',4499,10,1,1,0,0,-2,0,0);
  77. INSERT INTO henna VALUES (56,'symbol_i1w2_c',4500,10,1,1,0,0,0,0,-2);
  78. INSERT INTO henna VALUES (57,'symbol_m1i2_c',4501,10,1,-2,0,0,1,0,0);
  79. INSERT INTO henna VALUES (58,'symbol_m1w2_c',4502,10,1,0,0,0,1,0,-2);
  80. INSERT INTO henna VALUES (59,'symbol_w1i2_c',4503,10,1,-2,0,0,0,0,1);
  81. INSERT INTO henna VALUES (60,'symbol_w1m2_c',4504,10,1,0,0,0,-2,0,1);
  82. INSERT INTO henna VALUES (61,'symbol_s2c4_c',4505,10,1,0,2,-4,0,0,0);
  83. INSERT INTO henna VALUES (62,'symbol_s2d4_c',4506,10,1,0,2,0,0,-4,0);
  84. INSERT INTO henna VALUES (63,'symbol_c2s4_c',4507,10,1,0,-4,2,0,0,0);
  85. INSERT INTO henna VALUES (64,'symbol_c2c4_c',4508,10,1,0,0,2,0,-4,0);
  86. INSERT INTO henna VALUES (65,'symbol_d2s4_c',4509,10,1,0,-4,0,0,2,0);
  87. INSERT INTO henna VALUES (66,'symbol_d2c4_c',4510,10,1,0,0,-4,0,2,0);
  88. INSERT INTO henna VALUES (67,'symbol_i2m4_c',4511,10,1,2,0,0,-4,0,0);
  89. INSERT INTO henna VALUES (68,'symbol_i2w4_c',4512,10,1,2,0,0,0,0,-4);
  90. INSERT INTO henna VALUES (69,'symbol_m2i4_c',4513,10,1,-4,0,0,2,0,0);
  91. INSERT INTO henna VALUES (70,'symbol_m2w4_c',4514,10,1,0,0,0,2,0,-4);
  92. INSERT INTO henna VALUES (71,'symbol_w2i4_c',4515,10,1,-4,0,0,0,0,2);
  93. INSERT INTO henna VALUES (72,'symbol_w2m4_c',4516,10,1,0,0,0,-4,0,2);
  94. INSERT INTO henna VALUES (73,'symbol_s2c3_c',4517,10,1,0,2,-3,0,0,0);
  95. INSERT INTO henna VALUES (74,'symbol_s2d3_c',4518,10,1,0,2,0,0,-3,0);
  96. INSERT INTO henna VALUES (75,'symbol_c2s3_c',4519,10,1,0,-3,2,0,0,0);
  97. INSERT INTO henna VALUES (76,'symbol_c2c3_c',4520,10,1,0,0,2,0,-3,0);
  98. INSERT INTO henna VALUES (77,'symbol_d2s3_c',4521,10,1,0,-3,0,0,2,0);
  99. INSERT INTO henna VALUES (78,'symbol_d2c3_c',4522,10,1,0,0,-3,0,2,0);
  100. INSERT INTO henna VALUES (79,'symbol_i2m3_c',4523,10,1,2,0,0,-3,0,0);
  101. INSERT INTO henna VALUES (80,'symbol_i2w3_c',4524,10,1,2,0,0,0,0,-3);
  102. INSERT INTO henna VALUES (81,'symbol_m2i3_c',4525,10,1,-3,0,0,2,0,0);
  103. INSERT INTO henna VALUES (82,'symbol_m2w3_c',4526,10,1,0,0,0,2,0,-3);
  104. INSERT INTO henna VALUES (83,'symbol_w2i3_c',4527,10,1,-3,0,0,0,0,2);
  105. INSERT INTO henna VALUES (84,'symbol_w2m3_c',4528,10,1,0,0,0,-3,0,2);
  106. INSERT INTO henna VALUES (85,'symbol_s3c5_c',4529,10,1,0,3,-5,0,0,0);
  107. INSERT INTO henna VALUES (86,'symbol_s3d5_c',4530,10,1,0,3,0,0,-5,0);
  108. INSERT INTO henna VALUES (87,'symbol_c3s5_c',4531,10,1,0,-5,3,0,0,0);
  109. INSERT INTO henna VALUES (88,'symbol_c3c5_c',4532,10,1,0,0,3,0,-5,0);
  110. INSERT INTO henna VALUES (89,'symbol_d3s5_c',4533,10,1,0,-5,0,0,3,0);
  111. INSERT INTO henna VALUES (90,'symbol_d3c5_c',4534,10,1,0,0,-5,0,3,0);
  112. INSERT INTO henna VALUES (91,'symbol_i3m5_c',4535,10,1,3,0,0,-5,0,0);
  113. INSERT INTO henna VALUES (92,'symbol_i3w5_c',4536,10,1,3,0,0,0,0,-5);
  114. INSERT INTO henna VALUES (93,'symbol_m3i5_c',4537,10,1,-5,0,0,3,0,0);
  115. INSERT INTO henna VALUES (94,'symbol_m3w5_c',4538,10,1,0,0,0,3,0,-5);
  116. INSERT INTO henna VALUES (95,'symbol_w3i5_c',4539,10,1,-5,0,0,0,0,3);
  117. INSERT INTO henna VALUES (96,'symbol_w3m5_c',4540,10,1,0,0,0,-5,0,3);
  118. INSERT INTO henna VALUES (97,'symbol_s3c4_c',4541,10,1,0,3,-4,0,0,0);
  119. INSERT INTO henna VALUES (98,'symbol_s3d4_c',4542,10,1,0,3,0,0,-4,0);
  120. INSERT INTO henna VALUES (99,'symbol_c3s4_c',4543,10,1,0,-4,3,0,0,0);
  121. INSERT INTO henna VALUES (100,'symbol_c3c4_c',4544,10,1,0,0,3,0,-4,0);
  122. INSERT INTO henna VALUES (101,'symbol_d3s4_c',4545,10,1,0,-4,0,0,3,0);
  123. INSERT INTO henna VALUES (102,'symbol_d3c4_c',4546,10,1,0,0,-4,0,3,0);
  124. INSERT INTO henna VALUES (103,'symbol_i3m4_c',4547,10,1,3,0,0,-4,0,0);
  125. INSERT INTO henna VALUES (104,'symbol_i3w4_c',4548,10,1,3,0,0,0,0,-4);
  126. INSERT INTO henna VALUES (105,'symbol_m3i4_c',4549,10,1,-4,0,0,3,0,0);
  127. INSERT INTO henna VALUES (106,'symbol_m3w4_c',4550,10,1,0,0,0,3,0,-4);
  128. INSERT INTO henna VALUES (107,'symbol_w3i4_c',4551,10,1,-4,0,0,0,0,3);
  129. INSERT INTO henna VALUES (108,'symbol_w3m4_c',4552,10,1,0,0,0,-4,0,3);
  130. INSERT INTO henna VALUES (109,'symbol_s4c6_c',4565,10,1,0,4,-6,0,0,0);
  131. INSERT INTO henna VALUES (110,'symbol_s4d6_c',4566,10,1,0,4,0,0,-6,0);
  132. INSERT INTO henna VALUES (111,'symbol_c4s6_c',4567,10,1,0,-6,4,0,0,0);
  133. INSERT INTO henna VALUES (112,'symbol_c4c6_c',4568,10,1,0,0,4,0,-6,0);
  134. INSERT INTO henna VALUES (113,'symbol_d4s6_c',4569,10,1,0,-6,0,0,4,0);
  135. INSERT INTO henna VALUES (114,'symbol_d4c6_c',4570,10,1,0,0,-6,0,4,0);
  136. INSERT INTO henna VALUES (115,'symbol_i4m6_c',4571,10,1,4,0,0,-6,0,0);
  137. INSERT INTO henna VALUES (116,'symbol_i4w6_c',4572,10,1,4,0,0,0,0,-6);
  138. INSERT INTO henna VALUES (117,'symbol_m4i6_c',4573,10,1,-6,0,0,4,0,0);
  139. INSERT INTO henna VALUES (118,'symbol_m4w6_c',4574,10,1,0,0,0,4,0,-6);
  140. INSERT INTO henna VALUES (119,'symbol_w4i6_c',4575,10,1,-6,0,0,0,0,4);
  141. INSERT INTO henna VALUES (120,'symbol_w4m6_c',4576,10,1,0,0,0,-6,0,4);
  142. INSERT INTO henna VALUES (121,'symbol_s4c5_c',4577,10,1,0,4,-5,0,0,0);
  143. INSERT INTO henna VALUES (122,'symbol_s4d5_c',4578,10,1,0,4,0,0,-5,0);
  144. INSERT INTO henna VALUES (123,'symbol_c4s5_c',4579,10,1,0,-5,4,0,0,0);
  145. INSERT INTO henna VALUES (124,'symbol_c4c5_c',4580,10,1,0,0,4,0,-5,0);
  146. INSERT INTO henna VALUES (125,'symbol_d4s5_c',4581,10,1,0,-5,0,0,4,0);
  147. INSERT INTO henna VALUES (126,'symbol_d4c5_c',4582,10,1,0,0,-5,0,4,0);
  148. INSERT INTO henna VALUES (127,'symbol_i4m5_c',4583,10,1,4,0,0,-5,0,0);
  149. INSERT INTO henna VALUES (128,'symbol_i4w5_c',4584,10,1,4,0,0,0,0,-5);
  150. INSERT INTO henna VALUES (129,'symbol_m4i5_c',4585,10,1,-5,0,0,4,0,0);
  151. INSERT INTO henna VALUES (130,'symbol_m4w5_c',4586,10,1,0,0,0,4,0,-5);
  152. INSERT INTO henna VALUES (131,'symbol_w4i5_c',4587,10,1,-5,0,0,0,0,4);
  153. INSERT INTO henna VALUES (132,'symbol_w4m5_c',4588,10,1,0,0,0,-5,0,4);
  154. INSERT INTO henna VALUES (133,'symbol_s1c1_c',4553,10,1,0,1,-1,0,0,0);
  155. INSERT INTO henna VALUES (134,'symbol_s1d1_c',4554,10,1,0,1,0,0,-1,0);
  156. INSERT INTO henna VALUES (135,'symbol_c1s1_c',4555,10,1,0,-1,1,0,0,0);
  157. INSERT INTO henna VALUES (136,'symbol_c1c1_c',4556,10,1,0,0,1,0,-1,0);
  158. INSERT INTO henna VALUES (137,'symbol_d1s1_c',4557,10,1,0,-1,0,0,1,0);
  159. INSERT INTO henna VALUES (138,'symbol_d1c1_c',4558,10,1,0,0,-1,0,1,0);
  160. INSERT INTO henna VALUES (139,'symbol_i1m1_c',4559,10,1,1,0,0,-1,0,0);
  161. INSERT INTO henna VALUES (140,'symbol_i1w1_c',4560,10,1,1,0,0,0,0,-1);
  162. INSERT INTO henna VALUES (141,'symbol_m1i1_c',4561,10,1,-1,0,0,1,0,0);
  163. INSERT INTO henna VALUES (142,'symbol_m1w1_c',4562,10,1,0,0,0,1,0,-1);
  164. INSERT INTO henna VALUES (143,'symbol_w1i1_c',4563,10,1,-1,0,0,0,0,1);
  165. INSERT INTO henna VALUES (144,'symbol_w1m1_c',4564,10,1,0,0,0,-1,0,1);
  166. INSERT INTO henna VALUES (145,'symbol_s2c2_c',4589,10,1,0,2,-2,0,0,0);
  167. INSERT INTO henna VALUES (146,'symbol_s2d2_c',4590,10,1,0,2,0,0,-2,0);
  168. INSERT INTO henna VALUES (147,'symbol_c2s2_c',4591,10,1,0,-2,2,0,0,0);
  169. INSERT INTO henna VALUES (148,'symbol_c2c2_c',4592,10,1,0,0,2,0,-2,0);
  170. INSERT INTO henna VALUES (149,'symbol_d2s2_c',4593,10,1,0,-2,0,0,2,0);
  171. INSERT INTO henna VALUES (150,'symbol_d2c2_c',4594,10,1,0,0,-2,0,2,0);
  172. INSERT INTO henna VALUES (151,'symbol_i2m2_c',4595,10,1,2,0,0,-2,0,0);
  173. INSERT INTO henna VALUES (152,'symbol_i2w2_c',4596,10,1,2,0,0,0,0,-2);
  174. INSERT INTO henna VALUES (153,'symbol_m2i2_c',4597,10,1,-2,0,0,2,0,0);
  175. INSERT INTO henna VALUES (154,'symbol_m2w2_c',4598,10,1,0,0,0,2,0,-2);
  176. INSERT INTO henna VALUES (155,'symbol_w2i2_c',4599,10,1,-2,0,0,0,0,2);
  177. INSERT INTO henna VALUES (156,'symbol_w2m2_c',4600,10,1,0,0,0,-2,0,2);
  178. INSERT INTO henna VALUES (157,'symbol_s3c3_c',4601,10,1,0,3,-3,0,0,0);
  179. INSERT INTO henna VALUES (158,'symbol_s3d3_c',4602,10,1,0,3,0,0,-3,0);
  180. INSERT INTO henna VALUES (159,'symbol_c3s3_c',4603,10,1,0,-3,3,0,0,0);
  181. INSERT INTO henna VALUES (160,'symbol_c3c3_c',4604,10,1,0,0,3,0,-3,0);
  182. INSERT INTO henna VALUES (161,'symbol_d3s3_c',4605,10,1,0,-3,0,0,3,0);
  183. INSERT INTO henna VALUES (162,'symbol_d3c3_c',4606,10,1,0,0,-3,0,3,0);
  184. INSERT INTO henna VALUES (163,'symbol_i3m3_c',4607,10,1,3,0,0,-3,0,0);
  185. INSERT INTO henna VALUES (164,'symbol_i3w3_c',4608,10,1,3,0,0,0,0,-3);
  186. INSERT INTO henna VALUES (165,'symbol_m3i3_c',4609,10,1,-3,0,0,3,0,0);
  187. INSERT INTO henna VALUES (166,'symbol_m3w3_c',4610,10,1,0,0,0,3,0,-3);
  188. INSERT INTO henna VALUES (167,'symbol_w3i3_c',4611,10,1,-3,0,0,0,0,3);
  189. INSERT INTO henna VALUES (168,'symbol_w3m3_c',4612,10,1,0,0,0,-3,0,3);
  190. INSERT INTO henna VALUES (169,'symbol_s4c4_c',4613,10,628000,0,4,-4,0,0,0);
  191. INSERT INTO henna VALUES (170,'symbol_s4d4_c',4614,10,628000,0,4,0,0,-4,0);
  192. INSERT INTO henna VALUES (171,'symbol_c4s4_c',4615,10,628000,0,-4,4,0,0,0);
  193. INSERT INTO henna VALUES (172,'symbol_c4c4_c',4616,10,628000,0,0,4,0,-4,0);
  194. INSERT INTO henna VALUES (173,'symbol_d4s4_c',4617,10,628000,0,-4,0,0,4,0);
  195. INSERT INTO henna VALUES (174,'symbol_d4c4_c',4618,10,628000,0,0,-4,0,4,0);
  196. INSERT INTO henna VALUES (175,'symbol_i4m4_c',4619,10,628000,4,0,0,-4,0,0);
  197. INSERT INTO henna VALUES (176,'symbol_i4w4_c',4620,10,628000,4,0,0,0,0,-4);
  198. INSERT INTO henna VALUES (177,'symbol_m4i4_c',4621,10,628000,-4,0,0,4,0,0);
  199. INSERT INTO henna VALUES (178,'symbol_m4w4_c',4622,10,628000,0,0,0,4,0,-4);
  200. INSERT INTO henna VALUES (179,'symbol_w4i4_c',4623,10,628000,-4,0,0,0,0,4);
  201. INSERT INTO henna VALUES (180,'symbol_w4m4_c',4624,10,628000,0,0,0,-4,0,4);