hs创建read表和reply表MySQL代码

puyuetian 乐天 关注 九级站长 创始人
发表于水吧版块
CREATE TABLE `pk_read` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `sortid` int(11) NOT NULL DEFAULT '0',
 `label` text COMMENT '标签',
 `uid` int(11) NOT NULL,
 `title` text CHARACTER SET utf8mb4 NOT NULL,
 `content` longtext CHARACTER SET utf8mb4 NOT NULL,
 `looknum` int(11) NOT NULL DEFAULT '0',
 `zannum` int(11) NOT NULL DEFAULT '0',
 `posttime` int(11) NOT NULL,
 `postip` varchar(255) DEFAULT NULL COMMENT '发布人的ip',
 `readlevel` int(11) NOT NULL DEFAULT '0',
 `replyuid` int(11) unsigned NOT NULL DEFAULT '3',
 `replycontent` text CHARACTER SET utf8mb4,
 `replytime` int(11) unsigned NOT NULL DEFAULT '0',
 `replyip` varchar(255) DEFAULT NULL COMMENT '最后回复人的ip',
 `top` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文章置顶',
 `high` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文章精华',
 `locked` tinyint(3) NOT NULL DEFAULT '0',
 `replyafterlook` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '回复后可见',
 `data` longtext COMMENT '文章其他数据',
 `del` tinyint(1) NOT NULL DEFAULT '0',
 `fs` int(11) DEFAULT '1',
 `activetime` int(11) NOT NULL DEFAULT '0',
 `replyid` int(11) NOT NULL DEFAULT '0',
 `apptype` varchar(255) DEFAULT NULL,
 `jvhuo_gid` int(11) NOT NULL DEFAULT '0' COMMENT '聚货网相关联商品id',
 `lastedituid` int(11) NOT NULL DEFAULT '0',
 `lastedittime` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `sortid` (`sortid`),
 KEY `del` (`del`),
 KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE `pk_reply` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `rid` int(11) NOT NULL,
 `uid` int(11) NOT NULL,
 `content` text CHARACTER SET utf8mb4 NOT NULL,
 `posttime` int(11) NOT NULL,
 `postip` varchar(255) DEFAULT NULL COMMENT '发布人的ip',
 `zannum` int(11) NOT NULL DEFAULT '0',
 `top` tinyint(3) NOT NULL DEFAULT '0',
 `del` tinyint(1) NOT NULL DEFAULT '0',
 `fnum` int(11) DEFAULT '0',
 `data` longtext,
 PRIMARY KEY (`id`),
 KEY `rid` (`rid`),
 KEY `uid` (`uid`),
 KEY `del` (`del`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
grant select,insert,update,delete on *.* to "test1"@"%" Identified by "abc";
update user set password=password('123456') where user='root' and host='127.0.0.1';

评论列表 评论
mnet mnet 四级站长 VIP 2#
emotion
共0条回复,点击查看回复
发布评论

评论: hs创建read表和reply表MySQL代码

已有0次打赏
(0) 分享
分享

请保存二维码或复制链接进行分享

取消