diff options
| author | Shido <the.keikun@gmail.com> | 2014-05-30 10:13:58 +0800 |
|---|---|---|
| committer | Shido <the.keikun@gmail.com> | 2014-07-10 23:53:21 +0800 |
| commit | 3ecf877ba3f6d92bc323522bd166248464f83f79 (patch) | |
| tree | 610b4a53a6a70e3b8ab3c241145739e6c01b22d7 /sql-files/mob_skill_db2.sql | |
| parent | e98e18ff623ee1da999a04e8f4b7ae282453abd8 (diff) | |
| download | hercules-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_skill_db2.sql')
| -rw-r--r-- | sql-files/mob_skill_db2.sql | 52 |
1 files changed, 26 insertions, 26 deletions
diff --git a/sql-files/mob_skill_db2.sql b/sql-files/mob_skill_db2.sql index b44ad3225..0df6e8de5 100644 --- a/sql-files/mob_skill_db2.sql +++ b/sql-files/mob_skill_db2.sql @@ -1,35 +1,35 @@ -# -# Table structure for table `mob_skill_db2` -# +-- +-- Table structure for table `mob_skill_db2` +-- DROP TABLE IF EXISTS `mob_skill_db2`; CREATE TABLE IF NOT EXISTS `mob_skill_db2` ( - `MOB_ID` smallint(6) NOT NULL, - `INFO` text NOT NULL, - `STATE` text NOT NULL, - `SKILL_ID` smallint(6) NOT NULL, + `MOB_ID` SMALLINT(6) NOT NULL, + `INFO` TEXT NOT NULL, + `STATE` TEXT NOT NULL, + `SKILL_ID` SMALLINT(6) NOT NULL, `SKILL_LV` tinyint(4) NOT NULL, - `RATE` smallint(4) NOT NULL, - `CASTTIME` mediumint(9) NOT NULL, - `DELAY` int(9) NOT NULL, - `CANCELABLE` text NOT NULL, - `TARGET` text NOT NULL, - `CONDITION` text NOT NULL, - `CONDITION_VALUE` text, - `VAL1` mediumint(9) DEFAULT NULL, - `VAL2` mediumint(9) DEFAULT NULL, - `VAL3` mediumint(9) DEFAULT NULL, - `VAL4` mediumint(9) DEFAULT NULL, - `VAL5` mediumint(9) DEFAULT NULL, - `EMOTION` text, - `CHAT` text + `RATE` SMALLINT(4) NOT NULL, + `CASTTIME` MEDIUMINT(9) NOT NULL, + `DELAY` INT(9) NOT NULL, + `CANCELABLE` TEXT NOT NULL, + `TARGET` TEXT NOT NULL, + `CONDITION` TEXT NOT NULL, + `CONDITION_VALUE` TEXT, + `VAL1` MEDIUMINT(9) DEFAULT NULL, + `VAL2` MEDIUMINT(9) DEFAULT NULL, + `VAL3` MEDIUMINT(9) DEFAULT NULL, + `VAL4` MEDIUMINT(9) DEFAULT NULL, + `VAL5` MEDIUMINT(9) DEFAULT NULL, + `EMOTION` TEXT, + `CHAT` TEXT ) ENGINE=MyISAM; -# Mob Skill Database -# -# Structure of Database: -# INSERT INTO `mob_skill_db2` (`MOB_ID`, `INFO`, `STATE`, `SKILL_ID`, `SKILL_LV`, `RATE`, `CASTTIME`, `DELAY`, `CANCELABLE`, `TARGET`, `CONDITION`, `CONDITION_VALUE`, `VAL1`, `VAL2`, `VAL3`, `VAL4`, `VAL5`, `EMOTION`, `CHAT`); -# +-- Mob Skill Database +-- +-- Structure of Database: +-- INSERT INTO `mob_skill_db2` (`MOB_ID`, `INFO`, `STATE`, `SKILL_ID`, `SKILL_LV`, `RATE`, `CASTTIME`, `DELAY`, `CANCELABLE`, `TARGET`, `CONDITION`, `CONDITION_VALUE`, `VAL1`, `VAL2`, `VAL3`, `VAL4`, `VAL5`, `EMOTION`, `CHAT`); + # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@AL_TELEPORT", "idle", 26, 1, 10000, 0, 0, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@AL_TELEPORT", "walk", 26, 1, 500, 0, 5000, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@KN_BRANDISHSPEAR", "attack", 57, 10, 2000, 500, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL); |