|
Server : nginx/1.22.1 System : Linux iZwz9daxib3w3i063fw434Z 3.10.0-1127.19.1.el7.x86_64 #1 SMP Tue Aug 25 17:23:54 UTC 2020 x86_64 User : www ( 1000) PHP Version : 5.6.40 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/www.jkmold.com/phpcms/modules/comment/install/ |
DROP TABLE IF EXISTS `phpcms_comment_data_1`;
CREATE TABLE IF NOT EXISTS `phpcms_comment_data_1` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT '评论ID',
`commentid` char(30) NOT NULL default '' COMMENT '评论ID号',
`siteid` smallint(5) NOT NULL default '0' COMMENT '站点ID',
`userid` int(10) unsigned default '0' COMMENT '用户ID',
`username` varchar(20) default NULL COMMENT '用户名',
`creat_at` int(10) default NULL COMMENT '发布时间',
`ip` varchar(15) default NULL COMMENT '用户IP地址',
`status` tinyint(1) default '0' COMMENT '评论状态{0:未审核,-1:未通过审核,1:通过审核}',
`content` text COMMENT '评论内容',
`direction` tinyint(1) default '0' COMMENT '评论方向{0:无方向,1:正文,2:反方,3:中立}',
`support` mediumint(8) unsigned default '0' COMMENT '支持数',
`reply` tinyint(1) NOT NULL default '0' COMMENT '是否为回复',
PRIMARY KEY (`id`),
KEY `commentid` (`commentid`),
KEY `direction` (`direction`),
KEY `siteid` (`siteid`),
KEY `support` (`support`)
) TYPE=MyISAM;