· 9 years ago · Nov 13, 2016, 03:54 PM
1CREATE TABLE IF NOT EXISTS `mob_db` (
2 `ID` mediumint(9) unsigned NOT NULL DEFAULT '0',
3 `Sprite` text NOT NULL,
4 `kName` text NOT NULL,
5 `iName` text NOT NULL,
6 `LV` tinyint(6) unsigned NOT NULL DEFAULT '0',
7 `HP` int(9) unsigned NOT NULL DEFAULT '0',
8 `SP` mediumint(9) unsigned NOT NULL DEFAULT '0',
9 `EXP` mediumint(9) unsigned NOT NULL DEFAULT '0',
10 `JEXP` mediumint(9) unsigned NOT NULL DEFAULT '0',
11 `Range1` tinyint(4) unsigned NOT NULL DEFAULT '0',
12 `ATK1` smallint(6) unsigned NOT NULL DEFAULT '0',
13 `ATK2` smallint(6) unsigned NOT NULL DEFAULT '0',
14 `DEF` smallint(6) unsigned NOT NULL DEFAULT '0',
15 `MDEF` smallint(6) unsigned NOT NULL DEFAULT '0',
16 `STR` smallint(6) unsigned NOT NULL DEFAULT '0',
17 `AGI` smallint(6) unsigned NOT NULL DEFAULT '0',
18 `VIT` smallint(6) unsigned NOT NULL DEFAULT '0',
19 `INT` smallint(6) unsigned NOT NULL DEFAULT '0',
20 `DEX` smallint(6) unsigned NOT NULL DEFAULT '0',
21 `LUK` smallint(6) unsigned NOT NULL DEFAULT '0',
22 `Range2` tinyint(4) unsigned NOT NULL DEFAULT '0',
23 `Range3` tinyint(4) unsigned NOT NULL DEFAULT '0',
24 `Scale` tinyint(4) unsigned NOT NULL DEFAULT '0',
25 `Race` tinyint(4) unsigned NOT NULL DEFAULT '0',
26 `Element` tinyint(4) unsigned NOT NULL DEFAULT '0',
27 `Mode` smallint(6) unsigned NOT NULL DEFAULT '0',
28 `Speed` smallint(6) unsigned NOT NULL DEFAULT '0',
29 `aDelay` smallint(6) unsigned NOT NULL DEFAULT '0',
30 `aMotion` smallint(6) unsigned NOT NULL DEFAULT '0',
31 `dMotion` smallint(6) unsigned NOT NULL DEFAULT '0',
32 `MEXP` mediumint(9) unsigned NOT NULL DEFAULT '0',
33 `MVP1id` smallint(9) unsigned NOT NULL DEFAULT '0',
34 `MVP1per` smallint(9) unsigned NOT NULL DEFAULT '0',
35 `MVP2id` smallint(9) unsigned NOT NULL DEFAULT '0',
36 `MVP2per` smallint(9) unsigned NOT NULL DEFAULT '0',
37 `MVP3id` smallint(9) unsigned NOT NULL DEFAULT '0',
38 `MVP3per` smallint(9) unsigned NOT NULL DEFAULT '0',
39 `Drop1id` smallint(9) unsigned NOT NULL DEFAULT '0',
40 `Drop1per` smallint(9) unsigned NOT NULL DEFAULT '0',
41 `Drop2id` smallint(9) unsigned NOT NULL DEFAULT '0',
42 `Drop2per` smallint(9) unsigned NOT NULL DEFAULT '0',
43 `Drop3id` smallint(9) unsigned NOT NULL DEFAULT '0',
44 `Drop3per` smallint(9) unsigned NOT NULL DEFAULT '0',
45 `Drop4id` smallint(9) unsigned NOT NULL DEFAULT '0',
46 `Drop4per` smallint(9) unsigned NOT NULL DEFAULT '0',
47 `Drop5id` smallint(9) unsigned NOT NULL DEFAULT '0',
48 `Drop5per` smallint(9) unsigned NOT NULL DEFAULT '0',
49 `Drop6id` smallint(9) unsigned NOT NULL DEFAULT '0',
50 `Drop6per` smallint(9) unsigned NOT NULL DEFAULT '0',
51 `Drop7id` smallint(9) unsigned NOT NULL DEFAULT '0',
52 `Drop7per` smallint(9) unsigned NOT NULL DEFAULT '0',
53 `Drop8id` smallint(9) unsigned NOT NULL DEFAULT '0',
54 `Drop8per` smallint(9) unsigned NOT NULL DEFAULT '0',
55 `Drop9id` smallint(9) unsigned NOT NULL DEFAULT '0',
56 `Drop9per` smallint(9) unsigned NOT NULL DEFAULT '0',
57 `DropCardid` smallint(9) unsigned NOT NULL DEFAULT '0',
58 `DropCardper` smallint(9) unsigned NOT NULL DEFAULT '0',
59 PRIMARY KEY (`ID`)
60) ENGINE=MyISAM DEFAULT CHARSET=latin1;