1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| insert into admin_protocol_setting(protocol_key, title, content_html)
| values
| ('talent_user_agreement', '用户协议-人才', coalesce((select old_protocol.content_html from (select content_html from admin_protocol_setting where protocol_key = 'visitor_user_agreement') old_protocol), '')),
| ('merchant_user_agreement', '用户协议-商户', coalesce((select old_protocol.content_html from (select content_html from admin_protocol_setting where protocol_key = 'guide_user_agreement') old_protocol), '')),
| ('talent_privacy_policy', '隐私与权限-人才', coalesce((select old_protocol.content_html from (select content_html from admin_protocol_setting where protocol_key = 'visitor_privacy_policy') old_protocol), '')),
| ('merchant_privacy_policy', '隐私与权限-商户', '')
| on duplicate key update title = values(title);
|
| delete from admin_protocol_setting
| where protocol_key in (
| 'visitor_user_agreement',
| 'guide_user_agreement',
| 'visitor_privacy_policy',
| 'pure_service_notice',
| 'guide_service_agreement',
| 'guide_reward_policy'
| );
|
|
