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';