问答插件升级v3.0
创建于 2023-11-08 /
357
字体:
[默认]
[大]
[更大]
1. 先到商城后台,左侧 工具->sql控制台 执行以下sql
# v3.0.0
# 问答评论 - 问答
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_comments` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`ask_comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答评论id',
`reply_comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '一级回复评论id',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态(0待审核、1已审核、2已隐藏)',
`md5_key` char(32) NOT NULL DEFAULT '' COMMENT '数据唯一md5key',
`content` text COMMENT '评论内容',
`comments_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论总数',
`give_thumbs_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '点赞总数',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
`upd_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `ask_id` (`ask_id`),
KEY `ask_comments_id` (`ask_comments_id`),
KEY `reply_comments_id` (`reply_comments_id`),
KEY `status` (`status`),
KEY `md5_key` (`md5_key`),
KEY `comments_count` (`comments_count`),
KEY `give_thumbs_count` (`give_thumbs_count`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答评论 - 问答';
# 问答点赞 - 问答
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_give_thumbs` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`ask_comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答评论id',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `ask_id` (`ask_id`),
KEY `ask_comments_id` (`ask_comments_id`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答点赞 - 问答';
# 问答发布奖励积分日志
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_give_integral_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖励积分',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `ask_id` (`ask_id`),
KEY `user_id` (`user_id`),
KEY `integral` (`integral`),
KEY `add_time` (`add_time`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答发布奖励积分日志 - 问答';
# 问答评论奖励积分日志
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_comments_give_integral_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖励积分',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `ask_id` (`ask_id`),
KEY `comments_id` (`comments_id`),
KEY `user_id` (`user_id`),
KEY `integral` (`integral`),
KEY `add_time` (`add_time`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答评论奖励积分日志 - 问答';
# 问答点赞奖励积分日志
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_thumbs_give_integral_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖励积分',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `ask_id` (`ask_id`),
KEY `comments_id` (`comments_id`),
KEY `user_id` (`user_id`),
KEY `integral` (`integral`),
KEY `add_time` (`add_time`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答点赞奖励积分日志 - 问答';
# 表重命名
RENAME TABLE `{PREFIX}answer` TO `{PREFIX}plugins_ask`;
RENAME TABLE `{PREFIX}plugins_answers_goods` TO `{PREFIX}plugins_ask_goods`;
RENAME TABLE `{PREFIX}plugins_answers_slider` TO `{PREFIX}plugins_ask_slider`;
# 插件名称
UPDATE `{PREFIX}plugins` SET `plugins`='ask' WHERE `plugins`='answers';
UPDATE `{PREFIX}attachment` SET `path_type`='plugins_ask' WHERE `path_type`='plugins_answers';
# 问答新增评论和点赞总数
ALTER TABLE `{PREFIX}plugins_ask` add `comments_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论总数' after `access_count`;
ALTER TABLE `{PREFIX}plugins_ask` add `give_thumbs_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞总数' after `comments_count`;
# 问答新增商品id
ALTER TABLE `{PREFIX}plugins_ask` add `goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品id' after `user_id`;
2. 然后再去商店在线安装问答增强版插件
3 人点赞过