Skip to content

GitLab

Closed
Created by 互联网应用开发@wangqsMaintainer

删除tb_user字段

ALTER TABLE `tb_user`
  DROP `user_gender`,
  DROP `city`,
  DROP `user_desc`,
  DROP `org_code`,
  DROP `org_name`,
  DROP `has_bill`,
  DROP `user_domain`,
  DROP `expire_time`,
  DROP `rand_password`,
  DROP `user_qq`,
  DROP `user_cs_id`,
  DROP `user_cs_qq`,
  DROP `user_cs_name`,
  DROP `brand_report_num`,
  DROP `report_num`,
  DROP `owner_id`,
  DROP `applicant_name`,
  DROP `applicant_idcard`,
  DROP `applicant_mobile`,
  DROP `applicant_idcard_img`,
  DROP `applicant_authorization`,
  DROP `audit_status`,
  DROP `audit_time`,
  DROP `audit_info`,
  DROP `audit_reply`;
ALTER TABLE `ucs`.`tb_user` ADD INDEX (`phone`);
ALTER TABLE `ucs`.`tb_user` ADD UNIQUE (`user_weixin_id`);