| # Table: CARTOONPET # 卡通宠物表 CREATE TABLE `CARTOONPET` ( `CARTOONID` int(10) unsigned NOT NULL auto_increment, #ID `NAME` char(32) NOT NULL default 0, #名字 `NPCID` int(10) unsigned NOT NULL default 0, #种类 `MASTERID` int(10) unsigned NOT NULL default 0, #主人ID `MASTERNAME` char(32) NOT NULL default , #主人名字 `LEVEL` tinyint(3) unsigned NOT NULL default 0, #等级 `EXP` int(10) unsigned NOT NULL default 0, #经验 `MAXEXP` int(10) unsigned NOT NULL default 0, #升级经验 `ADDEXP` int(10) unsigned NOT NULL default 0, #积累经验 `STATE` tinyint(3) unsigned NOT NULL default 0, #状态 `ADOPTER` char(32) NOT NULL default , #领养人 `TIME` int(10) unsigned NOT NULL default 0, #剩余时间 `SP` int(10) unsigned NOT NULL default 0, #没用 `MAXSP` int(10) unsigned NOT NULL default 0, #没用 `MASTERLEVEL` int(10) unsigned NOT NULL default 0, #主人等级 `REPAIR` tinyint(3) unsigned NOT NULL default 0, #自动修理设置 `SYSADOPT` int(10) unsigned NOT NULL default 0, #系统领养设置 `AUTOADOPT` tinyint(3) unsigned NOT NULL default 0, #自动领养设置 `AUTOCHARGE` tinyint(3) unsigned NOT NULL default 0, #自动充值设置 `STARTADOPT` int(10) unsigned NOT NULL default 0, #开始领养时间 `ADOPTCOUNT` int(10) unsigned NOT NULL default 0, #领养计时 PRIMARY KEY (`CARTOONID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |