56,679
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE IF NOT EXISTS `guestbook` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`tid` smallint(3) NOT NULL,
`uid` int(11) NOT NULL,
`username` varchar(45) NOT NULL,
`mname` varchar(20) NOT NULL DEFAULT '',
`k_orderid` varchar(25) NOT NULL DEFAULT '',
`ip` varchar(15) NOT NULL,
`time` int(11) NOT NULL,
`s_orderid` varchar(25) NOT NULL DEFAULT '',
`cardtype` varchar(45) NOT NULL DEFAULT '',
`cardnumber` varchar(50) NOT NULL DEFAULT '',
`cardpwd` varchar(50) NOT NULL DEFAULT '',
`paytime` varchar(50) NOT NULL DEFAULT '',
`content` text NOT NULL,
`tradeype` varchar(20) NOT NULL DEFAULT '',
`paytype` varchar(50) NOT NULL DEFAULT '',
`paybank` varchar(50) NOT NULL DEFAULT '',
`phonenumber` varchar(50) NOT NULL DEFAULT '',
`accounts` varchar(10) NOT NULL DEFAULT '',
`rechargtime` varchar(20) NOT NULL DEFAULT '',
`userfen` varchar(50) NOT NULL DEFAULT '',
`idcard` varchar(50) NOT NULL DEFAULT '',
`truename` varchar(15) NOT NULL DEFAULT '',
`havejoin` varchar(5) NOT NULL DEFAULT '',
`linkman` varchar(20) NOT NULL DEFAULT '',
`phone` varchar(20) NOT NULL DEFAULT '',
`regemail` varchar(50) NOT NULL DEFAULT '',
`havereply` tinyint(1) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`title` varchar(255) NOT NULL DEFAULT '',
`kfid` smallint(6) NOT NULL,
`replycontent` mediumtext NOT NULL,
`replytime` int(11) NOT NULL,
`replyip` varchar(15) NOT NULL,
`memberlevel` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`qid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;