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;
|