You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
166 lines
7.8 KiB
SQL
166 lines
7.8 KiB
SQL
#
|
|
# Table structure for table `mob_db2`
|
|
#
|
|
|
|
DROP TABLE IF EXISTS `mob_db2`;
|
|
CREATE TABLE `mob_db2` (
|
|
`id` int(11) unsigned NOT NULL,
|
|
`name_aegis` varchar(24) DEFAULT NULL,
|
|
`name_english` text DEFAULT NULL,
|
|
`name_japanese` text DEFAULT NULL,
|
|
`level` smallint(6) unsigned DEFAULT NULL,
|
|
`hp` int(11) unsigned DEFAULT NULL,
|
|
`sp` mediumint(9) unsigned DEFAULT NULL,
|
|
`base_exp` int(11) unsigned DEFAULT NULL,
|
|
`job_exp` int(11) unsigned DEFAULT NULL,
|
|
`mvp_exp` int(11) unsigned DEFAULT NULL,
|
|
`attack` smallint(6) unsigned DEFAULT NULL,
|
|
`attack2` smallint(6) unsigned DEFAULT NULL,
|
|
`defense` smallint(6) unsigned DEFAULT NULL,
|
|
`magic_defense` smallint(6) unsigned DEFAULT NULL,
|
|
`str` smallint(6) unsigned DEFAULT NULL,
|
|
`agi` smallint(6) unsigned DEFAULT NULL,
|
|
`vit` smallint(6) unsigned DEFAULT NULL,
|
|
`int` smallint(6) unsigned DEFAULT NULL,
|
|
`dex` smallint(6) unsigned DEFAULT NULL,
|
|
`luk` smallint(6) unsigned DEFAULT NULL,
|
|
`attack_range` tinyint(4) unsigned DEFAULT NULL,
|
|
`skill_range` tinyint(4) unsigned DEFAULT NULL,
|
|
`chase_range` tinyint(4) unsigned DEFAULT NULL,
|
|
`size` varchar(24) DEFAULT NULL,
|
|
`race` varchar(24) DEFAULT NULL,
|
|
`racegroup_goblin` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_kobold` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_orc` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_golem` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_guardian` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_ninja` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_gvg` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_battlefield` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_treasure` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_biolab` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_manuk` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_splendide` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_scaraba` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_ogh_atk_def` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_ogh_hidden` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_bio5_swordman_thief` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_bio5_acolyte_merchant` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_bio5_mage_archer` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_bio5_mvp` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_clocktower` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_thanatos` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_faceworm` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_hearthunter` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_rockridge` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_werner_lab` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_temple_demon` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_illusion_vampire` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_malangdo` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_ep172alpha` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_ep172beta` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_ep172bath` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_illusion_turtle` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_rachel_sanctuary` tinyint(1) unsigned DEFAULT NULL,
|
|
`racegroup_illusion_luanda` tinyint(1) unsigned DEFAULT NULL,
|
|
`element` varchar(24) DEFAULT NULL,
|
|
`element_level` tinyint(4) unsigned DEFAULT NULL,
|
|
`walk_speed` smallint(6) unsigned DEFAULT NULL,
|
|
`attack_delay` smallint(6) unsigned DEFAULT NULL,
|
|
`attack_motion` smallint(6) unsigned DEFAULT NULL,
|
|
`damage_motion` smallint(6) unsigned DEFAULT NULL,
|
|
`damage_taken` smallint(6) unsigned DEFAULT NULL,
|
|
`ai` varchar(2) DEFAULT NULL,
|
|
`class` varchar(50) DEFAULT NULL,
|
|
`mode_canmove` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_looter` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_aggressive` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_assist` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_castsensoridle` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_norandomwalk` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_nocast` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_canattack` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_castsensorchase` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_changechase` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_angry` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_changetargetmelee` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_changetargetchase` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_targetweak` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_randomtarget` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_ignoremelee` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_ignoremagic` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_ignoreranged` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_mvp` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_ignoremisc` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_knockbackimmune` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_teleportblock` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_fixeditemdrop` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_detector` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_statusimmune` tinyint(1) unsigned DEFAULT NULL,
|
|
`mode_skillimmune` tinyint(1) unsigned DEFAULT NULL,
|
|
`mvpdrop1_item` varchar(50) DEFAULT NULL,
|
|
`mvpdrop1_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`mvpdrop1_option` varchar(50) DEFAULT NULL,
|
|
`mvpdrop1_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`mvpdrop2_item` varchar(50) DEFAULT NULL,
|
|
`mvpdrop2_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`mvpdrop2_option` varchar(50) DEFAULT NULL,
|
|
`mvpdrop2_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`mvpdrop3_item` varchar(50) DEFAULT NULL,
|
|
`mvpdrop3_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`mvpdrop3_option` varchar(50) DEFAULT NULL,
|
|
`mvpdrop3_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop1_item` varchar(50) DEFAULT NULL,
|
|
`drop1_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop1_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop1_option` varchar(50) DEFAULT NULL,
|
|
`drop1_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop2_item` varchar(50) DEFAULT NULL,
|
|
`drop2_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop2_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop2_option` varchar(50) DEFAULT NULL,
|
|
`drop2_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop3_item` varchar(50) DEFAULT NULL,
|
|
`drop3_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop3_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop3_option` varchar(50) DEFAULT NULL,
|
|
`drop3_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop4_item` varchar(50) DEFAULT NULL,
|
|
`drop4_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop4_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop4_option` varchar(50) DEFAULT NULL,
|
|
`drop4_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop5_item` varchar(50) DEFAULT NULL,
|
|
`drop5_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop5_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop5_option` varchar(50) DEFAULT NULL,
|
|
`drop5_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop6_item` varchar(50) DEFAULT NULL,
|
|
`drop6_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop6_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop6_option` varchar(50) DEFAULT NULL,
|
|
`drop6_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop7_item` varchar(50) DEFAULT NULL,
|
|
`drop7_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop7_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop7_option` varchar(50) DEFAULT NULL,
|
|
`drop7_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop8_item` varchar(50) DEFAULT NULL,
|
|
`drop8_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop8_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop8_option` varchar(50) DEFAULT NULL,
|
|
`drop8_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop9_item` varchar(50) DEFAULT NULL,
|
|
`drop9_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop9_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop9_option` varchar(50) DEFAULT NULL,
|
|
`drop9_index` tinyint(2) unsigned DEFAULT NULL,
|
|
`drop10_item` varchar(50) DEFAULT NULL,
|
|
`drop10_rate` smallint(9) unsigned DEFAULT NULL,
|
|
`drop10_nosteal` tinyint(1) unsigned DEFAULT NULL,
|
|
`drop10_option` varchar(50) DEFAULT NULL,
|
|
`drop10_index` tinyint(2) unsigned DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY (`name_aegis`)
|
|
) ENGINE=MyISAM;
|