-- Evaluation auto reply settings
CREATE TABLE IF NOT EXISTS `t_evaluation_auto_reply` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `keyword` varchar(100) NOT NULL COMMENT '关键字',
  `mark` int NOT NULL COMMENT '评价类型：1=好评，2=中评，3=差评',
  `reply_content` varchar(500) NOT NULL COMMENT '回复内容',
  `sort_order` int NOT NULL DEFAULT 0 COMMENT '排序号',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态：0=启用，1=停用',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` bit(1) NOT NULL DEFAULT b'0' COMMENT '删除标志：0=正常，1=删除',
  PRIMARY KEY (`id`),
  KEY `idx_mark_status` (`mark`, `status`),
  KEY `idx_sort_order` (`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评价智能回复规则';

-- Menu permissions for management backend.
-- If your content setting parent menu id is not found by name, replace @contentSettingMenuId manually.
SET @contentSettingMenuId := (
  SELECT menu_id FROM sys_menu
  WHERE menu_name = '内容设置'
  ORDER BY menu_id ASC
  LIMIT 1
);

DELETE FROM sys_menu WHERE perms IN ('/smartReply', '/smartReply/add', '/smartReply/update', '/smartReply/del');

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark)
SELECT '智能回复设置', @contentSettingMenuId, 99, 'smartReply', 'contentSetting/smartReply', 1, 0, 'C', '0', '0', '/smartReply', '#', 'admin', NOW(), '评价智能回复设置'
WHERE @contentSettingMenuId IS NOT NULL;

SET @smartReplyMenuId := LAST_INSERT_ID();

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark)
SELECT '智能回复新增', @smartReplyMenuId, 1, '#', '', 1, 0, 'F', '0', '0', '/smartReply/add', '#', 'admin', NOW(), ''
WHERE @smartReplyMenuId > 0;

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark)
SELECT '智能回复修改', @smartReplyMenuId, 2, '#', '', 1, 0, 'F', '0', '0', '/smartReply/update', '#', 'admin', NOW(), ''
WHERE @smartReplyMenuId > 0;

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark)
SELECT '智能回复删除', @smartReplyMenuId, 3, '#', '', 1, 0, 'F', '0', '0', '/smartReply/del', '#', 'admin', NOW(), ''
WHERE @smartReplyMenuId > 0;