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;