GitLab

数据库

ucs

SQL

alter table `tb_biz_company_contact` add audit_logo_status SMALLINT(1) not null default 0 after contact_status;
alter table `tb_biz_company_contact` add audit_logo_reason varchar(255) not null default '' after audit_logo_status;
alter table `tb_biz_company_contact` add logo_img_tmp varchar(512) not null default '' after logo_img

alter table `tb_biz_company_contact` add audit_site_status SMALLINT(1) not null default 0 after audit_logo_reason; 
alter table `tb_biz_company_contact` add audit_site_reason varchar(255) not null default '' after audit_site_status;
alter table `tb_biz_company_contact` add official_website_tmp varchar(256) not null default '' after official_website;

update `tb_biz_company_contact` set audit_logo_status=1 where logo_img is not null;
update `tb_biz_company_contact` set audit_site_status=1 where official_website is not null;

update `tb_biz_company_contact` set logo_img_tmp=logo_img where logo_img is not null
update `tb_biz_company_contact` set official_website_tmp=official_website where official_website is not null;