sql
```sql
USE meridian_portable_public;
ALTER TABLE tb_doctor ADD `insert_time` BIGINT(20) COMMENT '医生插入U盘的最后时间';
ALTER TABLE tb_doctor ADD `is_sign_in` INT COMMENT '本月医生是否签到';
ALTER TABLE tb_doctor_audit ADD `visit_customer_id` BIGINT(20) COMMENT '是否通过拜访客户注册而来，有id是';
ALTER TABLE tb_factor_count_month ADD `month_num` int(11) COMMENT '当做标识，用来统计当前服务商第几月';
USE meridian_portable_logic;
ALTER TABLE tb_goods_group ADD rankINT COMMENT '商品排名';
ALTER TABLE tb_factor ADD `sign_in_num` INT COMMENT '本月医生签到第几次';
```
USE meridian_portable_public;
ALTER TABLE tb_doctor ADD `data_update_num` INT COMMENT '更新手提箱资料的最后时间';
ALTER TABLE tb_doctor ADD `data_last_time` BIGINT COMMENT '资料更新的次数';
ALTER TABLE tb_doctor_audit ADD `visit_customer_id` BIGINT(20) COMMENT '拜访客户id，是否通过拜访客户注册而来，有id是';
ALTER TABLE tb_factor ADD `rank` INT COMMENT '商品排名';
USE meridian_portable_logic;