DROP TABLE IF EXISTS `nc`;
CREATE TABLE `nc` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`name` char(20) NOT NULL DEFAULT '',
`username` char(15) NOT NULL DEFAULT '',
`farm` text NOT NULL,
`animal` text NOT NULL,
`dog` text NOT NULL,
`money` int(10) NOT NULL DEFAULT '0',
`nb` int(10) NOT NULL DEFAULT '0',
`ncexp` int(10) NOT NULL DEFAULT '0',
`mcexp` int(10) NOT NULL DEFAULT '0',
`nctask` int(10) NOT NULL DEFAULT '1',
`mctask` int(10) NOT NULL DEFAULT '1',
`ncpackage` text NOT NULL,
`mcpackage` text NOT NULL,
`message` text NOT NULL,
`vip` tinyint(1) NOT NULL DEFAULT '0',
`ncitem` text NOT NULL,
`ncfruit` text NOT NULL,
`logintime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk; |