CREATE TABLE `uchome_happyfarm_nc` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`Status` text NOT NULL,
`reclaim` int(11) NOT NULL DEFAULT '6',
`exp` int(11) NOT NULL DEFAULT '0',
`taskid` int(11) NOT NULL DEFAULT '0',
`package` text,
`fruit` text,
`tools` text,
`decorative` text,
`dog` text,
`Weed` text,
`pest` text,
`water` text,
`badnum` int(11) NOT NULL DEFAULT '50',
`activeItem` int(11) NOT NULL DEFAULT '90001',
`repertory` text NOT NULL,
`log` text NOT NULL,
`healthmode` text NOT NULL,
`chris` INT NOT NULL DEFAULT '0',
`zong` INT3 NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |