http切换成https

-- contract_project表
UPDATE contract_project SET   recruitment_chart = REPLACE(recruitment_chart,   'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where recruitment_chart   like '%http://183.162.193.78:37491%';
UPDATE contract_project SET poster_cover_picture = REPLACE(poster_cover_picture, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where poster_cover_picture like '%http://183.162.193.78:37491%';
UPDATE contract_project SET             qr_code = REPLACE(qr_code,             'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where qr_code             like '%http://183.162.193.78:37491%';
UPDATE contract_project SET       single_qr_code = REPLACE(single_qr_code,       'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where single_qr_code       like '%http://183.162.193.78:37491%';
UPDATE contract_project SET      qrcode_with_num = REPLACE(qrcode_with_num,      'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where qrcode_with_num      like '%http://183.162.193.78:37491%';

-- 候选人流转表
UPDATE candidate_circulation SET file_url = REPLACE(file_url, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where file_url like '%http://183.162.193.78:37491%';

-- 候选人个人简历表
UPDATE candidate_resume SET file_url = REPLACE(file_url, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where file_url like '%http://183.162.193.78:37491%';

-- 入职银行卡信息
UPDATE induction_bank_info SET card_img = REPLACE(card_img, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where card_img like '%http://183.162.193.78:37491%';

-- 入职身份证信息
UPDATE induction_card_info SET card_front_img = REPLACE(card_front_img, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where card_front_img like '%http://183.162.193.78:37491%';
UPDATE induction_card_info SET card_back_img  = REPLACE(card_back_img,  'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where card_back_img  like '%http://183.162.193.78:37491%';

-- 入职材料表
UPDATE induction_material SET        diploma_img  = REPLACE(diploma_img,          'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where diploma_img         like '%http://183.162.193.78:37491%';
UPDATE induction_material SET academic_degree_img = REPLACE(academic_degree_img,  'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where academic_degree_img like '%http://183.162.193.78:37491%';
UPDATE induction_material SET    leaving_cert_img = REPLACE(leaving_cert_img,     'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where leaving_cert_img    like '%http://183.162.193.78:37491%';
UPDATE induction_material SET  medical_report_img = REPLACE(medical_report_img,   'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where medical_report_img  like '%http://183.162.193.78:37491%';
UPDATE induction_material SET      other_cert_img = REPLACE(other_cert_img,       'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where other_cert_img      like '%http://183.162.193.78:37491%';

-- 入职补充信息
UPDATE induction_person_info SET employee_img = REPLACE(employee_img, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where employee_img like '%http://183.162.193.78:37491%';

-- 面试登记信息表
UPDATE interview_info SET resume_url = REPLACE(resume_url, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where resume_url like '%http://183.162.193.78:37491%';

-- 项目信息表
UPDATE item_info SET        poster_img = REPLACE(poster_img,        'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where poster_img        like '%http://183.162.193.78:37491%';
UPDATE item_info SET attendance_qrcode = REPLACE(attendance_qrcode, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where attendance_qrcode like '%http://183.162.193.78:37491%';

-- job
UPDATE job SET img_url = REPLACE(img_url, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where img_url like '%http://183.162.193.78:37491%';

-- job
UPDATE job_historical_record SET img_url = REPLACE(img_url, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where img_url like '%http://183.162.193.78:37491%';

-- offer录用银行卡信息
UPDATE offer_bank_info SET card_img = REPLACE(card_img, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where card_img like '%http://183.162.193.78:37491%';

-- offer录用身份证信息
UPDATE offer_card_info SET card_front_img = REPLACE(card_front_img, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where card_front_img like '%http://183.162.193.78:37491%';
UPDATE offer_card_info SET card_back_img  = REPLACE(card_back_img,  'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where card_back_img  like '%http://183.162.193.78:37491%';

-- offer录用入职材料表
UPDATE offer_material SET        diploma_img  = REPLACE(diploma_img,          'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where diploma_img         like '%http://183.162.193.78:37491%';
UPDATE offer_material SET academic_degree_img = REPLACE(academic_degree_img,  'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where academic_degree_img like '%http://183.162.193.78:37491%';
UPDATE offer_material SET    leaving_cert_img = REPLACE(leaving_cert_img,     'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where leaving_cert_img    like '%http://183.162.193.78:37491%';
UPDATE offer_material SET  medical_report_img = REPLACE(medical_report_img,   'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where medical_report_img  like '%http://183.162.193.78:37491%';
UPDATE offer_material SET      other_cert_img = REPLACE(other_cert_img,       'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where other_cert_img      like '%http://183.162.193.78:37491%';


-- 入职补充信息
UPDATE offer_person_info SET employee_img = REPLACE(employee_img, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where employee_img like '%http://183.162.193.78:37491%';

-- resume
UPDATE resume SET file_url = REPLACE(file_url, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where file_url like '%http://183.162.193.78:37491%';

-- resume_records
UPDATE resume_records SET resumes = REPLACE(resumes, 'http://183.162.193.78:37491', 'https://crm.sunyardbpo.com:9440') where resumes like '%http://183.162.193.78:37491%';