cannot import mobdb.sql
# Monster Database
#
# Structure of Database :
# REPLACE INTO `mob_db` VALUES ( ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);
# Note: Keep the Sprite_Name field as it is (in the game client). You may change Name,JName field though
REPLACE INTO `mob_db`
VALUES ( 1001, 'SCORPION', 'Scorpion', 'Scorpion', 24, 1109, NULL , 287, 176, 1, 80, 135, 30, NULL , 1, 24, 24, 5, 52, 5, 10, 12, NULL , 4, 23, 0x3195, 200, 1564, 864, 576, NULL , NULL , NULL , NULL , NULL , NULL , NULL , 990, 70, 904, 5500, 757, 57, 943, 210, 7041, 100, 508, 200, 625, 20, NULL , NULL , NULL , NULL , 4068, 1 ) ;
MySQL :
#1048 - Column 'SP' cannot be null