· 8 years ago · May 15, 2018, 06:14 AM
1DROP TABLE IF EXISTS `odinms`.`pokemon`;
2CREATE TABLE `odinms`.`pokemon` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `monsterid` int(11) NOT NULL DEFAULT '0',
5 `characterid` int(11) NOT NULL DEFAULT '0',
6 `level` smallint(3) NOT NULL DEFAULT '1',
7 `exp` int(11) NOT NULL DEFAULT '0',
8 `name` varchar(255) NOT NULL DEFAULT '',
9 `nature` tinyint(3) NOT NULL DEFAULT '0',
10 `active` tinyint(1) NOT NULL DEFAULT '0',
11 `accountid` int(11) NOT NULL DEFAULT '0',
12 `itemid` int(11) NOT NULL DEFAULT '0',
13 `gender` tinyint(2) NOT NULL DEFAULT '-1',
14 `hpiv` tinyint(3) NOT NULL DEFAULT '-1',
15 `atkiv` tinyint(3) NOT NULL DEFAULT '-1',
16 `defiv` tinyint(3) NOT NULL DEFAULT '-1',
17 `spatkiv` tinyint(3) NOT NULL DEFAULT '-1',
18 `spdefiv` tinyint(3) NOT NULL DEFAULT '-1',
19 `speediv` tinyint(3) NOT NULL DEFAULT '-1',
20 `evaiv` tinyint(3) NOT NULL DEFAULT '-1',
21 `acciv` tinyint(3) NOT NULL DEFAULT '-1',
22 `ability` tinyint(2) NOT NULL DEFAULT '-1',
23 PRIMARY KEY (`id`),
24 KEY `id` (`id`),
25 KEY `characterid` (`characterid`)
26) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;