summaryrefslogtreecommitdiff
path: root/sql-files/mob_db_re.sql
diff options
context:
space:
mode:
authorShido <the.keikun@gmail.com>2014-05-30 10:13:58 +0800
committerShido <the.keikun@gmail.com>2014-07-10 23:53:21 +0800
commit3ecf877ba3f6d92bc323522bd166248464f83f79 (patch)
tree610b4a53a6a70e3b8ab3c241145739e6c01b22d7 /sql-files/mob_db_re.sql
parente98e18ff623ee1da999a04e8f4b7ae282453abd8 (diff)
downloadhercules-3ecf877ba3f6d92bc323522bd166248464f83f79.tar.gz
hercules-3ecf877ba3f6d92bc323522bd166248464f83f79.tar.bz2
hercules-3ecf877ba3f6d92bc323522bd166248464f83f79.tar.xz
hercules-3ecf877ba3f6d92bc323522bd166248464f83f79.zip
SQL Re-Organization.
Signed-off-by: KeiKun <the.keikun@gmail.com>
Diffstat (limited to 'sql-files/mob_db_re.sql')
-rw-r--r--sql-files/mob_db_re.sql132
1 files changed, 66 insertions, 66 deletions
diff --git a/sql-files/mob_db_re.sql b/sql-files/mob_db_re.sql
index bd2ab084f..8a2863b80 100644
--- a/sql-files/mob_db_re.sql
+++ b/sql-files/mob_db_re.sql
@@ -1,74 +1,74 @@
-#
-# Table structure for table `mob_db`
-#
+--
+-- Table structure for table `mob_db`
+--
DROP TABLE IF EXISTS `mob_db`;
CREATE TABLE `mob_db` (
- `ID` mediumint(9) unsigned NOT NULL default '0',
- `Sprite` text NOT NULL,
- `kName` text NOT NULL,
- `iName` text NOT NULL,
- `LV` tinyint(6) unsigned NOT NULL default '0',
- `HP` int(9) unsigned NOT NULL default '0',
- `SP` mediumint(9) unsigned NOT NULL default '0',
- `EXP` mediumint(9) unsigned NOT NULL default '0',
- `JEXP` mediumint(9) unsigned NOT NULL default '0',
- `Range1` tinyint(4) unsigned NOT NULL default '0',
- `ATK1` smallint(6) unsigned NOT NULL default '0',
- `ATK2` smallint(6) unsigned NOT NULL default '0',
- `DEF` smallint(6) unsigned NOT NULL default '0',
- `MDEF` smallint(6) unsigned NOT NULL default '0',
- `STR` smallint(6) unsigned NOT NULL default '0',
- `AGI` smallint(6) unsigned NOT NULL default '0',
- `VIT` smallint(6) unsigned NOT NULL default '0',
- `INT` smallint(6) unsigned NOT NULL default '0',
- `DEX` smallint(6) unsigned NOT NULL default '0',
- `LUK` smallint(6) unsigned NOT NULL default '0',
- `Range2` tinyint(4) unsigned NOT NULL default '0',
- `Range3` tinyint(4) unsigned NOT NULL default '0',
- `Scale` tinyint(4) unsigned NOT NULL default '0',
- `Race` tinyint(4) unsigned NOT NULL default '0',
- `Element` tinyint(4) unsigned NOT NULL default '0',
- `Mode` smallint(6) unsigned NOT NULL default '0',
- `Speed` smallint(6) unsigned NOT NULL default '0',
- `aDelay` smallint(6) unsigned NOT NULL default '0',
- `aMotion` smallint(6) unsigned NOT NULL default '0',
- `dMotion` smallint(6) unsigned NOT NULL default '0',
- `MEXP` mediumint(9) unsigned NOT NULL default '0',
- `MVP1id` smallint(9) unsigned NOT NULL default '0',
- `MVP1per` smallint(9) unsigned NOT NULL default '0',
- `MVP2id` smallint(9) unsigned NOT NULL default '0',
- `MVP2per` smallint(9) unsigned NOT NULL default '0',
- `MVP3id` smallint(9) unsigned NOT NULL default '0',
- `MVP3per` smallint(9) unsigned NOT NULL default '0',
- `Drop1id` smallint(9) unsigned NOT NULL default '0',
- `Drop1per` smallint(9) unsigned NOT NULL default '0',
- `Drop2id` smallint(9) unsigned NOT NULL default '0',
- `Drop2per` smallint(9) unsigned NOT NULL default '0',
- `Drop3id` smallint(9) unsigned NOT NULL default '0',
- `Drop3per` smallint(9) unsigned NOT NULL default '0',
- `Drop4id` smallint(9) unsigned NOT NULL default '0',
- `Drop4per` smallint(9) unsigned NOT NULL default '0',
- `Drop5id` smallint(9) unsigned NOT NULL default '0',
- `Drop5per` smallint(9) unsigned NOT NULL default '0',
- `Drop6id` smallint(9) unsigned NOT NULL default '0',
- `Drop6per` smallint(9) unsigned NOT NULL default '0',
- `Drop7id` smallint(9) unsigned NOT NULL default '0',
- `Drop7per` smallint(9) unsigned NOT NULL default '0',
- `Drop8id` smallint(9) unsigned NOT NULL default '0',
- `Drop8per` smallint(9) unsigned NOT NULL default '0',
- `Drop9id` smallint(9) unsigned NOT NULL default '0',
- `Drop9per` smallint(9) unsigned NOT NULL default '0',
- `DropCardid` smallint(9) unsigned NOT NULL default '0',
- `DropCardper` smallint(9) unsigned NOT NULL default '0',
- PRIMARY KEY (`ID`)
+ `ID` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Sprite` TEXT NOT NULL,
+ `kName` TEXT NOT NULL,
+ `iName` TEXT NOT NULL,
+ `LV` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `HP` int(9) UNSIGNED NOT NULL DEFAULT '0',
+ `SP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `EXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `JEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Range1` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+ `ATK1` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `ATK2` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `DEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `MDEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `STR` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `AGI` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `VIT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `INT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `DEX` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `LUK` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `Range2` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+ `Range3` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+ `Scale` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+ `Race` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+ `Element` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+ `Mode` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `Speed` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `aDelay` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `aMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `dMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+ `MEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `MVP1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `MVP1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `MVP2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `MVP2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `MVP3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `MVP3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop4id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop4per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop5id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop5per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop6id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop6per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop7id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop7per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop8id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop8per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop9id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `Drop9per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `DropCardid` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ `DropCardper` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`)
) ENGINE=MyISAM;
-# 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.
+-- 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.
REPLACE INTO `mob_db` VALUES (1001,'SCORPION','Scorpion','Scorpion',16,153,1,108,81,1,33,40,16,5,12,15,10,5,19,5,10,12,0,4,23,0x3191,200,1564,864,576,0,0,0,0,0,0,0,990,70,904,5500,757,57,943,210,7041,100,508,200,625,20,0,0,0,0,4068,1);
REPLACE INTO `mob_db` VALUES (1002,'PORING','Poring','Poring',1,60,1,27,20,1,8,9,2,5,6,1,1,0,6,5,10,12,1,3,21,0x83,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,512,150,619,20,0,0,0,0,4001,1);
# REPLACE INTO `mob_db` VALUES (1003,'TESTEGG','Test Egg','Test Egg',2,100000,0,10,10,0,3,9,99,0,1,99,1,1,1,1,10,12,0,4,22,0x0,512,0,512,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);