henna.sql 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  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
  23. (1, 'symbol_s+1c-3_d', 4445, 10, 5100, '0', '1', '-3', '0', '0', '0'),
  24. (2, 'symbol_s+1d-3_d', 4446, 10, 5100, '0', '1', '0', '0', '-3', '0'),
  25. (3, 'symbol_c+1s-3_d', 4447, 10, 5100, '0', '-3', '1', '0', '0', '0'),
  26. (4, 'symbol_c+1d-3_d', 4448, 10, 5100, '0', '0', '1', '0', '-3', '0'),
  27. (5, 'symbol_d+1s-3_d', 4449, 10, 5100, '0', '-3', '0', '0', '1', '0'),
  28. (6, 'symbol_d+1c-3_d', 4450, 10, 5100, '0', '0', '-3', '0', '1', '0'),
  29. (7, 'symbol_i+1m-3_d', 4451, 10, 5100, '1', '0', '0', '-3', '0', '0'),
  30. (8, 'symbol_i+1w-3_d', 4452, 10, 5100, '1', '0', '0', '0', '0', '-3'),
  31. (9, 'symbol_m+1i-3_d', 4453, 10, 5100, '-3', '0', '0', '1', '0', '0'),
  32. (10, 'symbol_m+1w-3_d', 4454, 10, 5100, '0', '0', '0', '1', '0', '-3'),
  33. (11, 'symbol_w+1i-3_d', 4455, 10, 5100, '-3', '0', '0', '0', '0', '1'),
  34. (12, 'symbol_w+1m-3_d', 4456, 10, 5100, '0', '0', '0', '-3', '0', '1'),
  35. (13, 'symbol_s+1c-2_d', 4457, 10, 12000, '0', '1', '-2', '0', '0', '0'),
  36. (14, 'symbol_s+1d-2_d', 4458, 10, 12000, '0', '1', '0', '0', '-2', '0'),
  37. (15, 'symbol_c+1s-2_d', 4459, 10, 12000, '0', '-2', '1', '0', '0', '0'),
  38. (16, 'symbol_c+1d-2_d', 4460, 10, 12000, '0', '0', '1', '0', '-2', '0'),
  39. (17, 'symbol_d+1s-2_d', 4461, 10, 12000, '0', '-2', '0', '0', '1', '0'),
  40. (18, 'symbol_d+1c-2_d', 4462, 10, 12000, '0', '0', '-2', '0', '1', '0'),
  41. (19, 'symbol_i+1m-2_d', 4463, 10, 12000, '1', '0', '0', '-2', '0', '0'),
  42. (20, 'symbol_i+1w-2_d', 4464, 10, 12000, '1', '0', '0', '0', '0', '-2'),
  43. (21, 'symbol_m+1i-2_d', 4465, 10, 12000, '-2', '0', '0', '1', '0', '0'),
  44. (22, 'symbol_m+1w-2_d', 4466, 10, 12000, '0', '0', '0', '1', '0', '-2'),
  45. (23, 'symbol_w+1i-2_d', 4467, 10, 12000, '-2', '0', '0', '0', '0', '1'),
  46. (24, 'symbol_w+1m-2_d', 4468, 10, 12000, '0', '0', '0', '-2', '0', '1'),
  47. (25, 'symbol_s+1c-1_d', 4469, 10, 35000, '0', '1', '-1', '0', '0', '0'),
  48. (26, 'symbol_s+1d-1_d', 4470, 10, 35000, '0', '1', '0', '0', '-1', '0'),
  49. (27, 'symbol_c+1s-1_d', 4471, 10, 35000, '0', '-1', '1', '0', '0', '0'),
  50. (28, 'symbol_c+1d-1_d', 4472, 10, 35000, '0', '0', '1', '0', '-1', '0'),
  51. (29, 'symbol_d+1s-1_d', 4473, 10, 35000, '0', '-1', '0', '0', '1', '0'),
  52. (30, 'symbol_d+1c-1_d', 4474, 10, 35000, '0', '0', '-1', '0', '1', '0'),
  53. (31, 'symbol_i+1m-1_d', 4475, 10, 35000, '1', '0', '0', '-1', '0', '0'),
  54. (32, 'symbol_i+1w-1_d', 4476, 10, 35000, '1', '0', '0', '0', '0', '-1'),
  55. (33, 'symbol_m+1i-1_d', 4477, 10, 35000, '-1', '0', '0', '1', '0', '0'),
  56. (34, 'symbol_m+1w-1_d', 4478, 10, 35000, '0', '0', '0', '1', '0', '-1'),
  57. (35, 'symbol_w+1i-1_d', 4479, 10, 35000, '-1', '0', '0', '0', '0', '1'),
  58. (36, 'symbol_w+1m-1_d', 4480, 10, 35000, '0', '0', '0', '-1', '0', '1'),
  59. (37, 'symbol_s+1c-3_c', 4481, 10, 12000, '0', '1', '-3', '0', '0', '0'),
  60. (38, 'symbol_s+1d-3_c', 4482, 10, 24600, '0', '1', '0', '0', '-3', '0'),
  61. (39, 'symbol_c+1s-3_c', 4483, 10, 24600, '0', '-3', '1', '0', '0', '0'),
  62. (40, 'symbol_c+1d-3_c', 4484, 10, 24600, '0', '0', '1', '0', '-3', '0'),
  63. (41, 'symbol_d+1s-3_c', 4485, 10, 30000, '0', '-3', '0', '0', '1', '0'),
  64. (42, 'symbol_d+1c-3_c', 4486, 10, 30000, '0', '0', '-3', '0', '1', '0'),
  65. (43, 'symbol_i+1m-3_c', 4487, 10, 30000, '1', '0', '0', '-3', '0', '0'),
  66. (44, 'symbol_i+1w-3_c', 4488, 10, 30000, '1', '0', '0', '0', '0', '-3'),
  67. (45, 'symbol_m+1i-3_c', 4489, 10, 30000, '-3', '0', '0', '1', '0', '0'),
  68. (46, 'symbol_m+1w-3_c', 4490, 10, 12000, '0', '0', '0', '1', '0', '-3'),
  69. (47, 'symbol_w+1i-3_c', 4491, 10, 30000, '-3', '0', '0', '0', '0', '1'),
  70. (48, 'symbol_w+1m-3_c', 4492, 10, 12000, '0', '0', '0', '-3', '0', '1'),
  71. (49, 'symbol_s+1c-2_c', 4493, 10, 24600, '0', '1', '-2', '0', '0', '0'),
  72. (50, 'symbol_s+1d-2_c', 4494, 10, 30000, '0', '1', '0', '0', '-2', '0'),
  73. (51, 'symbol_c+1s-2_c', 4495, 10, 35000, '0', '-2', '1', '0', '0', '0'),
  74. (52, 'symbol_c+1d-2_c', 4496, 10, 35000, '0', '0', '1', '0', '-2', '0'),
  75. (53, 'symbol_d+1s-2_c', 4497, 10, 36000, '0', '-2', '0', '0', '1', '0'),
  76. (54, 'symbol_d+1c-2_c', 4498, 10, 36000, '0', '0', '-2', '0', '1', '0'),
  77. (55, 'symbol_i+1m-2_c', 4499, 10, 50000, '1', '0', '0', '-2', '0', '0'),
  78. (56, 'symbol_i+1w-2_c', 4500, 10, 36000, '1', '0', '0', '0', '0', '-2'),
  79. (57, 'symbol_m+1i-2_c', 4501, 10, 36000, '-2', '0', '0', '1', '0', '0'),
  80. (58, 'symbol_m+1w-2_c', 4502, 10, 21000, '0', '0', '0', '1', '0', '-2'),
  81. (59, 'symbol_w+1i-2_c', 4503, 10, 30000, '-2', '0', '0', '0', '0', '1'),
  82. (60, 'symbol_w+1m-2_c', 4504, 10, 36000, '0', '0', '0', '-2', '0', '1'),
  83. (61, 'symbol_s+2c-4_c', 4505, 10, 24600, '0', '2', '-4', '0', '0', '0'),
  84. (62, 'symbol_s+2d-4_c', 4506, 10, 24600, '0', '2', '0', '0', '-4', '0'),
  85. (63, 'symbol_c+2s-4_c', 4507, 10, 24600, '0', '-4', '2', '0', '0', '0'),
  86. (64, 'symbol_c+2d-4_c', 4508, 10, 24600, '0', '0', '2', '0', '-4', '0'),
  87. (65, 'symbol_d+2s-4_c', 4509, 10, 24600, '0', '-4', '0', '0', '2', '0'),
  88. (66, 'symbol_d+2c-4_c', 4510, 10, 24600, '0', '0', '-4', '0', '2', '0'),
  89. (67, 'symbol_i+2m-4_c', 4511, 10, 24600, '2', '0', '0', '-4', '0', '0'),
  90. (68, 'symbol_i+2w-4_c', 4512, 10, 24600, '2', '0', '0', '0', '0', '-4'),
  91. (69, 'symbol_m+2i-4_c', 4513, 10, 24600, '-4', '0', '0', '2', '0', '0'),
  92. (70, 'symbol_m+2w-4_c', 4514, 10, 30000, '0', '0', '0', '2', '0', '-4'),
  93. (71, 'symbol_w+2i-4_c', 4515, 10, 30000, '-4', '0', '0', '0', '0', '2'),
  94. (72, 'symbol_w+2m-4_c', 4516, 10, 30000, '0', '0', '0', '-4', '0', '2'),
  95. (73, 'symbol_s+2c-3_c', 4517, 10, 30000, '0', '2', '-3', '0', '0', '0'),
  96. (74, 'symbol_s+2d-3_c', 4518, 10, 35000, '0', '2', '0', '0', '-3', '0'),
  97. (75, 'symbol_c+2s-3_c', 4519, 10, 35000, '0', '-3', '2', '0', '0', '0'),
  98. (76, 'symbol_c+2d-3_c', 4520, 10, 35000, '0', '0', '2', '0', '-3', '0'),
  99. (77, 'symbol_d+2s-3_c', 4521, 10, 27000, '0', '-3', '0', '0', '2', '0'),
  100. (78, 'symbol_d+2c-3_c', 4522, 10, 27000, '0', '0', '-3', '0', '2', '0'),
  101. (79, 'symbol_i+2m-3_c', 4523, 10, 27000, '2', '0', '0', '-3', '0', '0'),
  102. (80, 'symbol_i+2w-3_c', 4524, 10, 30000, '2', '0', '0', '0', '0', '-3'),
  103. (81, 'symbol_m+2i-3_c', 4525, 10, 30000, '-3', '0', '0', '2', '0', '0'),
  104. (82, 'symbol_m+2w-3_c', 4526, 10, 30000, '0', '0', '0', '2', '0', '-3'),
  105. (83, 'symbol_w+2i-3_c', 4527, 10, 30000, '-3', '0', '0', '0', '0', '2'),
  106. (84, 'symbol_w+2m-3_c', 4528, 10, 30000, '0', '0', '0', '-3', '0', '2'),
  107. (85, 'symbol_s+3c-5_c', 4529, 10, 30000, '0', '3', '-5', '0', '0', '0'),
  108. (86, 'symbol_s+3d-5_c', 4530, 10, 30000, '0', '3', '0', '0', '-5', '0'),
  109. (87, 'symbol_c+3s-5_c', 4531, 10, 30000, '0', '-5', '3', '0', '0', '0'),
  110. (88, 'symbol_c+3d-5_c', 4532, 10, 30000, '0', '0', '3', '0', '-5', '0'),
  111. (89, 'symbol_d+3s-5_c', 4533, 10, 30000, '0', '-5', '0', '0', '3', '0'),
  112. (90, 'symbol_d+3c-5_c', 4534, 10, 30000, '0', '0', '-5', '0', '3', '0'),
  113. (91, 'symbol_i+3m-5_c', 4535, 10, 30000, '3', '0', '0', '-5', '0', '0'),
  114. (92, 'symbol_i+3w-5_c', 4536, 10, 30000, '3', '0', '0', '0', '0', '-5'),
  115. (93, 'symbol_m+3i-5_c', 4537, 10, 30000, '-5', '0', '0', '3', '0', '0'),
  116. (94, 'symbol_m+3w-5_c', 4538, 10, 30000, '0', '0', '0', '3', '0', '-5'),
  117. (95, 'symbol_w+3i-5_c', 4539, 10, 30000, '-5', '0', '0', '0', '0', '3'),
  118. (96, 'symbol_w+3m-5_c', 4540, 10, 30000, '0', '0', '0', '-5', '0', '3'),
  119. (97, 'symbol_s+3c-4_c', 4541, 10, 30000, '0', '3', '-4', '0', '0', '0'),
  120. (98, 'symbol_s+3d-4_c', 4542, 10, 30000, '0', '3', '0', '0', '-4', '0'),
  121. (99, 'symbol_c+3s-4_c', 4543, 10, 50000, '0', '-4', '3', '0', '0', '0'),
  122. (100, 'symbol_c+3d-4_c', 4544, 10, 50000, '0', '0', '3', '0', '-4', '0'),
  123. (101, 'symbol_d+3s-4_c', 4545, 10, 50000, '0', '-4', '0', '0', '3', '0'),
  124. (102, 'symbol_d+3c-4_c', 4546, 10, 50000, '0', '0', '-4', '0', '3', '0'),
  125. (103, 'symbol_i+3m-4_c', 4547, 10, 50000, '3', '0', '0', '-4', '0', '0'),
  126. (104, 'symbol_i+3w-4_c', 4548, 10, 50000, '3', '0', '0', '0', '0', '-4'),
  127. (105, 'symbol_m+3i-4_c', 4549, 10, 50000, '-4', '0', '0', '3', '0', '0'),
  128. (106, 'symbol_m+3w-4_c', 4550, 10, 50000, '0', '0', '0', '3', '0', '-4'),
  129. (107, 'symbol_w+3i-4_c', 4551, 10, 50000, '-4', '0', '0', '0', '0', '3'),
  130. (108, 'symbol_w+3m-4_c', 4552, 10, 50000, '0', '0', '0', '-4', '0', '3'),
  131. (109, 'symbol_s+4c-6_c', 4565, 10, 36000, '0', '4', '-6', '0', '0', '0'),
  132. (110, 'symbol_s+4d-6_c', 4566, 10, 36000, '0', '4', '0', '0', '-6', '0'),
  133. (111, 'symbol_c+4s-6_c', 4567, 10, 50000, '0', '-6', '4', '0', '0', '0'),
  134. (112, 'symbol_c+4d-6_c', 4568, 10, 50000, '0', '0', '4', '0', '-6', '0'),
  135. (113, 'symbol_d+4s-6_c', 4569, 10, 30000, '0', '-6', '0', '0', '4', '0'),
  136. (114, 'symbol_d+4c-6_c', 4570, 10, 36000, '0', '0', '-6', '0', '4', '0'),
  137. (115, 'symbol_i+4m-6_c', 4571, 10, 36000, '4', '0', '0', '-6', '0', '0'),
  138. (116, 'symbol_i+4w-6_c', 4572, 10, 30000, '4', '0', '0', '0', '0', '-6'),
  139. (117, 'symbol_m+4i-6_c', 4573, 10, 36000, '-6', '0', '0', '4', '0', '0'),
  140. (118, 'symbol_m+4w-6_c', 4574, 10, 36000, '0', '0', '0', '4', '0', '-6'),
  141. (119, 'symbol_w+4i-6_c', 4575, 10, 36000, '-6', '0', '0', '0', '0', '4'),
  142. (120, 'symbol_w+4m-6_c', 4576, 10, 30000, '0', '0', '0', '-6', '0', '4'),
  143. (121, 'symbol_s+4c-5_c', 4577, 10, 36000, '0', '4', '-5', '0', '0', '0'),
  144. (122, 'symbol_s+4d-5_c', 4578, 10, 90000, '0', '4', '0', '0', '-5', '0'),
  145. (123, 'symbol_c+4s-5_c', 4579, 10, 90000, '0', '-5', '4', '0', '0', '0'),
  146. (124, 'symbol_c+4d-5_c', 4580, 10, 90000, '0', '0', '4', '0', '-5', '0'),
  147. (125, 'symbol_d+4s-5_c', 4581, 10, 36000, '0', '-5', '0', '0', '4', '0'),
  148. (126, 'symbol_d+4c-5_c', 4582, 10, 36000, '0', '0', '-5', '0', '4', '0'),
  149. (127, 'symbol_i+4m-5_c', 4583, 10, 90000, '4', '0', '0', '-5', '0', '0'),
  150. (128, 'symbol_i+4w-5_c', 4584, 10, 36000, '4', '0', '0', '0', '0', '-5'),
  151. (129, 'symbol_m+4i-5_c', 4585, 10, 90000, '-5', '0', '0', '4', '0', '0'),
  152. (130, 'symbol_m+4w-5_c', 4586, 10, 90000, '0', '0', '0', '4', '0', '-5'),
  153. (131, 'symbol_w+4i-5_c', 4587, 10, 36000, '-5', '0', '0', '0', '0', '4'),
  154. (132, 'symbol_w+4m-5_c', 4588, 10, 36000, '0', '0', '0', '-5', '0', '4'),
  155. (133, 'symbol_s+1c-1_c', 4553, 10, 50000, '0', '1', '-1', '0', '0', '0'),
  156. (134, 'symbol_s+1d-1_c', 4554, 10, 50000, '0', '1', '0', '0', '-1', '0'),
  157. (135, 'symbol_c+1s-1_c', 4555, 10, 50000, '0', '-1', '1', '0', '0', '0'),
  158. (136, 'symbol_c+1d-1_c', 4556, 10, 50000, '0', '0', '1', '0', '-1', '0'),
  159. (137, 'symbol_d+1s-1_c', 4557, 10, 50000, '0', '-1', '0', '0', '1', '0'),
  160. (138, 'symbol_d+1c-1_c', 4558, 10, 50000, '0', '0', '-1', '0', '1', '0'),
  161. (139, 'symbol_i+1m-1_c', 4559, 10, 90000, '1', '0', '0', '-1', '0', '0'),
  162. (140, 'symbol_i+1w-1_c', 4560, 10, 50000, '1', '0', '0', '0', '0', '-1'),
  163. (141, 'symbol_m+1i-1_c', 4561, 10, 50000, '-1', '0', '0', '1', '0', '0'),
  164. (142, 'symbol_m+1w-1_c', 4562, 10, 50000, '0', '0', '0', '1', '0', '-1'),
  165. (143, 'symbol_w+1i-1_c', 4563, 10, 50000, '-1', '0', '0', '0', '0', '1'),
  166. (144, 'symbol_w+1m-1_c', 4564, 10, 50000, '0', '0', '0', '-1', '0', '1'),
  167. (145, 'symbol_s+2c-2_c', 4589, 10, 60000, '0', '2', '-2', '0', '0', '0'),
  168. (146, 'symbol_s+2d-2_c', 4590, 10, 60000, '0', '2', '0', '0', '-2', '0'),
  169. (147, 'symbol_c+2s-2_c', 4591, 10, 60000, '0', '-2', '2', '0', '0', '0'),
  170. (148, 'symbol_c+2d-2_c', 4592, 10, 60000, '0', '0', '2', '0', '-2', '0'),
  171. (149, 'symbol_d+2s-2_c', 4593, 10, 60000, '0', '-2', '0', '0', '2', '0'),
  172. (150, 'symbol_d+2c-2_c', 4594, 10, 60000, '0', '0', '-2', '0', '2', '0'),
  173. (151, 'symbol_i+2m-2_c', 4595, 10, 60000, '2', '0', '0', '-2', '0', '0'),
  174. (152, 'symbol_i+2w-2_c', 4596, 10, 90000, '2', '0', '0', '0', '0', '-2'),
  175. (153, 'symbol_m+2i-2_c', 4597, 10, 60000, '-2', '0', '0', '2', '0', '0'),
  176. (154, 'symbol_m+2w-2_c', 4598, 10, 60000, '0', '0', '0', '2', '0', '-2'),
  177. (155, 'symbol_w+2i-2_c', 4599, 10, 60000, '-2', '0', '0', '0', '0', '2'),
  178. (156, 'symbol_w+2m-2_c', 4600, 10, 60000, '0', '0', '0', '-2', '0', '2'),
  179. (157, 'symbol_s+3c-3_c', 4601, 10, 90000, '0', '3', '-3', '0', '0', '0'),
  180. (158, 'symbol_s+3d-3_c', 4602, 10, 90000, '0', '3', '0', '0', '-3', '0'),
  181. (159, 'symbol_c+3s-3_c', 4603, 10, 90000, '0', '-3', '3', '0', '0', '0'),
  182. (160, 'symbol_c+3d-3_c', 4604, 10, 90000, '0', '0', '3', '0', '-3', '0'),
  183. (161, 'symbol_d+3s-3_c', 4605, 10, 90000, '0', '-3', '0', '0', '3', '0'),
  184. (162, 'symbol_d+3c-3_c', 4606, 10, 90000, '0', '0', '-3', '0', '3', '0'),
  185. (163, 'symbol_i+3m-3_c', 4607, 10, 90000, '3', '0', '0', '-3', '0', '0'),
  186. (164, 'symbol_i+3w-3_c', 4608, 10, 90000, '3', '0', '0', '0', '0', '-3'),
  187. (165, 'symbol_m+3i-3_c', 4609, 10, 90000, '-3', '0', '0', '3', '0', '0'),
  188. (166, 'symbol_m+3w-3_c', 4610, 10, 90000, '0', '0', '0', '3', '0', '-3'),
  189. (167, 'symbol_w+3i-3_c', 4611, 10, 90000, '-3', '0', '0', '0', '0', '3'),
  190. (168, 'symbol_w+3m-3_c', 4612, 10, 90000, '0', '0', '0', '-3', '0', '3'),
  191. (169, 'symbol_s+4c-4_c', 4613, 10, 145000, '0', '4', '-4', '0', '0', '0'),
  192. (170, 'symbol_s+4d-4_c', 4614, 10, 145000, '0', '4', '0', '0', '-4', '0'),
  193. (171, 'symbol_c+4s-4_c', 4615, 10, 145000, '0', '-4', '4', '0', '0', '0'),
  194. (172, 'symbol_c+4d-4_c', 4616, 10, 145000, '0', '0', '4', '0', '-4', '0'),
  195. (173, 'symbol_d+4s-4_c', 4617, 10, 145000, '0', '-4', '0', '0', '4', '0'),
  196. (174, 'symbol_d+4c-4_c', 4618, 10, 145000, '0', '0', '-4', '0', '4', '0'),
  197. (175, 'symbol_i+4m-4_c', 4619, 10, 145000, '4', '0', '0', '-4', '0', '0'),
  198. (176, 'symbol_i+4w-4_c', 4620, 10, 145000, '4', '0', '0', '0', '0', '-4'),
  199. (177, 'symbol_m+4i-4_c', 4621, 10, 145000, '-4', '0', '0', '4', '0', '0'),
  200. (178, 'symbol_m+4w-4_c', 4622, 10, 145000, '0', '0', '0', '4', '0', '-4'),
  201. (179, 'symbol_w+4i-4_c', 4623, 10, 145000, '-4', '0', '0', '0', '0', '4'),
  202. (180, 'symbol_w+4m-4_c', 4624, 10, 145000, '0', '0', '0', '-4', '0', '4');