ylrz_saas_pharmacy/java/sql/lobster_wechat_im_compliance_seed.sql

-- =====================================================
-- 微信/企微 IM 全行业合规词库（与 LobsterWechatImComplianceCatalog 对齐）
-- 主库 ylrz_saas：company_lobster_replace_word + company_lobster_sensitive_word (company_id=0)
-- 租户库 lobster_compliance_rule 由 Java LobsterWechatImComplianceSeedService 自动灌入
-- 执行: mysql -u用户 -p ylrz_saas < lobster_wechat_im_compliance_seed.sql
-- =====================================================

-- 违禁词替换（全局 tenant_id=0, word_type=forbidden）
INSERT IGNORE INTO company_lobster_replace_word (tenant_id, word_type, content, replace_text, enabled, sort, create_by) VALUES
(0, 'forbidden', '现货', '可参考了解', 1, 100, 'wechat-im-seed'),
(0, 'forbidden', '秒发', '稍后回复', 1, 99, 'wechat-im-seed'),
(0, 'forbidden', '秒回', '稍后回复', 1, 98, 'wechat-im-seed'),
(0, 'forbidden', '一手货源', '交流心得', 1, 97, 'wechat-im-seed'),
(0, 'forbidden', '量大价优', '日常分享', 1, 96, 'wechat-im-seed'),
(0, 'forbidden', '内部价', '参考了解', 1, 95, 'wechat-im-seed'),
(0, 'forbidden', '独家货源', '日常分享', 1, 94, 'wechat-im-seed'),
(0, 'forbidden', '稳赚', '有较好表现', 1, 93, 'wechat-im-seed'),
(0, 'forbidden', '必赚', '有较好表现', 1, 92, 'wechat-im-seed'),
(0, 'forbidden', '无风险', '相对稳健', 1, 91, 'wechat-im-seed'),
(0, 'forbidden', '零风险', '相对稳健', 1, 90, 'wechat-im-seed'),
(0, 'forbidden', '速成', '逐步了解', 1, 89, 'wechat-im-seed'),
(0, 'forbidden', '根治', '有助于改善', 1, 88, 'wechat-im-seed'),
(0, 'forbidden', '百分百有效', '因人而异', 1, 87, 'wechat-im-seed'),
(0, 'forbidden', '百分百', '较高比例', 1, 86, 'wechat-im-seed'),
(0, 'forbidden', '永不反弹', '因人而异', 1, 85, 'wechat-im-seed'),
(0, 'forbidden', '内部名额', '常规安排', 1, 84, 'wechat-im-seed'),
(0, 'forbidden', '内部资源', '常规信息', 1, 83, 'wechat-im-seed'),
(0, 'forbidden', '神器', '产品', 1, 82, 'wechat-im-seed'),
(0, 'forbidden', '批发', '了解', 1, 81, 'wechat-im-seed'),
(0, 'forbidden', '囤货', '了解', 1, 80, 'wechat-im-seed'),
(0, 'forbidden', '下单', '了解', 1, 79, 'wechat-im-seed'),
(0, 'forbidden', '拿货', '了解', 1, 78, 'wechat-im-seed');

-- 敏感词拦截（全局 company_id=0, action=block）
INSERT IGNORE INTO company_lobster_sensitive_word (company_id, word, category, action, enabled, create_time, create_by) VALUES
(0, '电子烟', 'custom', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '雾化杆', 'custom', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '烟弹', 'custom', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '处方药', '医疗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '壮阳药', '医疗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '美白针', '医疗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '资金盘', '诈骗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '杀猪盘', '诈骗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '跑分', '诈骗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '套现', '诈骗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '私下交易', '诈骗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '绕过平台', '诈骗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '避开风控', '诈骗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '翻墙', '诈骗', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '高仿', 'custom', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '水货', 'custom', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '管制刀具', 'custom', 'block', 1, NOW(), 'wechat-im-seed'),
(0, '仿真枪', 'custom', 'block', 1, NOW(), 'wechat-im-seed');

-- 完整词表以 Java LobsterWechatImComplianceCatalog 为准，服务启动时自动补齐（INSERT 幂等）