| id |
int(11)
|
|
|
|
| name_aegis |
varchar(24)
|
utf8mb4_general_ci
|
|
|
| name_english |
text
|
utf8mb4_general_ci
|
|
|
| name_japanese |
text
|
utf8mb4_general_ci
|
|
|
| level |
smallint(6)
|
|
|
|
| hp |
int(11)
|
|
|
|
| sp |
mediumint(9)
|
|
|
|
| base_exp |
int(11)
|
|
|
|
| job_exp |
int(11)
|
|
|
|
| mvp_exp |
int(11)
|
|
|
|
| attack |
smallint(6)
|
|
|
|
| attack2 |
smallint(6)
|
|
|
|
| defense |
smallint(6)
|
|
|
|
| magic_defense |
smallint(6)
|
|
|
|
| resistance |
smallint(6)
|
|
|
|
| magic_resistance |
smallint(6)
|
|
|
|
| str |
smallint(6)
|
|
|
|
| agi |
smallint(6)
|
|
|
|
| vit |
smallint(6)
|
|
|
|
| int |
smallint(6)
|
|
|
|
| dex |
smallint(6)
|
|
|
|
| luk |
smallint(6)
|
|
|
|
| attack_range |
tinyint(4)
|
|
|
|
| skill_range |
tinyint(4)
|
|
|
|
| chase_range |
tinyint(4)
|
|
|
|
| size |
varchar(24)
|
utf8mb4_general_ci
|
|
|
| race |
varchar(24)
|
utf8mb4_general_ci
|
|
|
| racegroup_goblin |
tinyint(1)
|
|
|
|
| racegroup_kobold |
tinyint(1)
|
|
|
|
| racegroup_orc |
tinyint(1)
|
|
|
|
| racegroup_golem |
tinyint(1)
|
|
|
|
| racegroup_guardian |
tinyint(1)
|
|
|
|
| racegroup_ninja |
tinyint(1)
|
|
|
|
| racegroup_gvg |
tinyint(1)
|
|
|
|
| racegroup_battlefield |
tinyint(1)
|
|
|
|
| racegroup_treasure |
tinyint(1)
|
|
|
|
| racegroup_biolab |
tinyint(1)
|
|
|
|
| racegroup_manuk |
tinyint(1)
|
|
|
|
| racegroup_splendide |
tinyint(1)
|
|
|
|
| racegroup_scaraba |
tinyint(1)
|
|
|
|
| racegroup_ogh_atk_def |
tinyint(1)
|
|
|
|
| racegroup_ogh_hidden |
tinyint(1)
|
|
|
|
| racegroup_bio5_swordman_thief |
tinyint(1)
|
|
|
|
| racegroup_bio5_acolyte_merchant |
tinyint(1)
|
|
|
|
| racegroup_bio5_mage_archer |
tinyint(1)
|
|
|
|
| racegroup_bio5_mvp |
tinyint(1)
|
|
|
|
| racegroup_clocktower |
tinyint(1)
|
|
|
|
| racegroup_thanatos |
tinyint(1)
|
|
|
|
| racegroup_faceworm |
tinyint(1)
|
|
|
|
| racegroup_hearthunter |
tinyint(1)
|
|
|
|
| racegroup_rockridge |
tinyint(1)
|
|
|
|
| racegroup_werner_lab |
tinyint(1)
|
|
|
|
| racegroup_temple_demon |
tinyint(1)
|
|
|
|
| racegroup_illusion_vampire |
tinyint(1)
|
|
|
|
| racegroup_malangdo |
tinyint(1)
|
|
|
|
| racegroup_ep172alpha |
tinyint(1)
|
|
|
|
| racegroup_ep172beta |
tinyint(1)
|
|
|
|
| racegroup_ep172bath |
tinyint(1)
|
|
|
|
| racegroup_illusion_turtle |
tinyint(1)
|
|
|
|
| racegroup_rachel_sanctuary |
tinyint(1)
|
|
|
|
| racegroup_illusion_luanda |
tinyint(1)
|
|
|
|
| racegroup_illusion_frozen |
tinyint(1)
|
|
|
|
| racegroup_illusion_moonlight |
tinyint(1)
|
|
|
|
| racegroup_ep16_def |
tinyint(1)
|
|
|
|
| racegroup_edda_arunafeltz |
tinyint(1)
|
|
|
|
| racegroup_lasagna |
tinyint(1)
|
|
|
|
| racegroup_glast_heim_abyss |
tinyint(1)
|
|
|
|
| racegroup_destroyed_valkyrie_realm |
tinyint(1)
|
|
|
|
| racegroup_encroached_gephenia |
tinyint(1)
|
|
|
|
| element |
varchar(24)
|
utf8mb4_general_ci
|
|
|
| element_level |
tinyint(4)
|
|
|
|
| walk_speed |
smallint(6)
|
|
|
|
| attack_delay |
smallint(6)
|
|
|
|
| attack_motion |
smallint(6)
|
|
|
|
| damage_motion |
smallint(6)
|
|
|
|
| damage_taken |
smallint(6)
|
|
|
|
| groupid |
smallint(6)
|
|
|
|
| title |
text
|
utf8mb4_general_ci
|
|
|
| ai |
varchar(2)
|
utf8mb4_general_ci
|
|
|
| class |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mode_canmove |
tinyint(1)
|
|
|
|
| mode_looter |
tinyint(1)
|
|
|
|
| mode_aggressive |
tinyint(1)
|
|
|
|
| mode_assist |
tinyint(1)
|
|
|
|
| mode_castsensoridle |
tinyint(1)
|
|
|
|
| mode_norandomwalk |
tinyint(1)
|
|
|
|
| mode_nocast |
tinyint(1)
|
|
|
|
| mode_canattack |
tinyint(1)
|
|
|
|
| mode_castsensorchase |
tinyint(1)
|
|
|
|
| mode_changechase |
tinyint(1)
|
|
|
|
| mode_angry |
tinyint(1)
|
|
|
|
| mode_changetargetmelee |
tinyint(1)
|
|
|
|
| mode_changetargetchase |
tinyint(1)
|
|
|
|
| mode_targetweak |
tinyint(1)
|
|
|
|
| mode_randomtarget |
tinyint(1)
|
|
|
|
| mode_ignoremelee |
tinyint(1)
|
|
|
|
| mode_ignoremagic |
tinyint(1)
|
|
|
|
| mode_ignoreranged |
tinyint(1)
|
|
|
|
| mode_mvp |
tinyint(1)
|
|
|
|
| mode_ignoremisc |
tinyint(1)
|
|
|
|
| mode_knockbackimmune |
tinyint(1)
|
|
|
|
| mode_teleportblock |
tinyint(1)
|
|
|
|
| mode_fixeditemdrop |
tinyint(1)
|
|
|
|
| mode_detector |
tinyint(1)
|
|
|
|
| mode_statusimmune |
tinyint(1)
|
|
|
|
| mode_skillimmune |
tinyint(1)
|
|
|
|
| mvpdrop1_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mvpdrop1_rate |
smallint(9)
|
|
|
|
| mvpdrop1_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mvpdrop1_index |
tinyint(2)
|
|
|
|
| mvpdrop2_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mvpdrop2_rate |
smallint(9)
|
|
|
|
| mvpdrop2_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mvpdrop2_index |
tinyint(2)
|
|
|
|
| mvpdrop3_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mvpdrop3_rate |
smallint(9)
|
|
|
|
| mvpdrop3_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mvpdrop3_index |
tinyint(2)
|
|
|
|
| drop1_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop1_rate |
smallint(9)
|
|
|
|
| drop1_nosteal |
tinyint(1)
|
|
|
|
| drop1_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop1_index |
tinyint(2)
|
|
|
|
| drop2_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop2_rate |
smallint(9)
|
|
|
|
| drop2_nosteal |
tinyint(1)
|
|
|
|
| drop2_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop2_index |
tinyint(2)
|
|
|
|
| drop3_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop3_rate |
smallint(9)
|
|
|
|
| drop3_nosteal |
tinyint(1)
|
|
|
|
| drop3_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop3_index |
tinyint(2)
|
|
|
|
| drop4_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop4_rate |
smallint(9)
|
|
|
|
| drop4_nosteal |
tinyint(1)
|
|
|
|
| drop4_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop4_index |
tinyint(2)
|
|
|
|
| drop5_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop5_rate |
smallint(9)
|
|
|
|
| drop5_nosteal |
tinyint(1)
|
|
|
|
| drop5_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop5_index |
tinyint(2)
|
|
|
|
| drop6_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop6_rate |
smallint(9)
|
|
|
|
| drop6_nosteal |
tinyint(1)
|
|
|
|
| drop6_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop6_index |
tinyint(2)
|
|
|
|
| drop7_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop7_rate |
smallint(9)
|
|
|
|
| drop7_nosteal |
tinyint(1)
|
|
|
|
| drop7_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop7_index |
tinyint(2)
|
|
|
|
| drop8_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop8_rate |
smallint(9)
|
|
|
|
| drop8_nosteal |
tinyint(1)
|
|
|
|
| drop8_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop8_index |
tinyint(2)
|
|
|
|
| drop9_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop9_rate |
smallint(9)
|
|
|
|
| drop9_nosteal |
tinyint(1)
|
|
|
|
| drop9_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop9_index |
tinyint(2)
|
|
|
|
| drop10_item |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop10_rate |
smallint(9)
|
|
|
|
| drop10_nosteal |
tinyint(1)
|
|
|
|
| drop10_option |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drop10_index |
tinyint(2)
|
|
|
|
