shinnosuke
2026-08-12 f40c2939c6f784fc6721554794154a336d12bc3a
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
alter table app_agreement
    modify column content_html longtext not null;
 
update app_agreement agreement
join admin_protocol_setting setting
    on setting.protocol_key = 'talent_user_agreement'
set agreement.title = '用户协议',
    agreement.content_html = setting.content_html
where agreement.agreement_type = 'user'
  and length(trim(setting.content_html)) > 0;
 
update app_agreement agreement
join admin_protocol_setting setting
    on setting.protocol_key = 'talent_privacy_policy'
set agreement.title = '隐私与权限',
    agreement.content_html = setting.content_html
where agreement.agreement_type = 'privacy'
  and length(trim(setting.content_html)) > 0;
 
update merchant_agreement agreement
join admin_protocol_setting setting
    on setting.protocol_key = 'merchant_user_agreement'
set agreement.title = '用户协议',
    agreement.content_html = setting.content_html
where agreement.agreement_type = 'user'
  and length(trim(setting.content_html)) > 0;
 
update merchant_agreement agreement
join admin_protocol_setting setting
    on setting.protocol_key = 'merchant_privacy_policy'
set agreement.title = '隐私与权限',
    agreement.content_html = setting.content_html
where agreement.agreement_type = 'privacy'
  and length(trim(setting.content_html)) > 0;