sql
```sql
USE meridian_portable_logic;
ALTER TABLE tb_patient ADD `count_pres` INT COMMENT '开方数' AFTER count;
ALTER TABLE tb_patient ADD `count_see` INT COMMENT '就诊数' AFTER count_pres;
ALTER TABLE tb_patient ADD `is_see` INT DEFAULT 0 COMMENT '当天是否就诊过' AFTER count_see;
ALTER TABLE tb_result ADD `extend` VARCHAR(300) DEFAULT NULL COMMENT '扩展信息，目前存储患者在公众号预诊时发的语音素材id或文字';
ALTER TABLE tb_result ADD `is_patient` TINYINT(4) DEFAULT NULL COMMENT '是否是患者预诊的报告';
# 刷新统计： http://jmb-server.yunmaster.cn/meridian-portable-logic
/patient/update/flush/test
```
```sql
USE meridian_portable_public;
ALTER TABLE tb_doctor DROP red_end_time;
ALTER TABLE tb_account_money DROP red_packet;
ALTER TABLE tb_account_money DROP red_packet_total;
ALTER TABLE tb_account_money DROP red_packet_max_list;
ALTER TABLE tb_account_money DROP is_have;
ALTER TABLE tb_red_packet DROP is_use;
DROP TABLE IF EXISTS `tb_ignore_device_phone`;
CREATE TABLE `tb_ignore_device_phone` (
`phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '忽视设备的手机号,可以登录任何设备，不会提示设备已绑定'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
```
select * from tb_prescription_count_day
ALTER TABLE tb_prescription_count_day MODIFY COLUMN `medicine_pharmacy_id` varchar(40) COMMENT '第三方药房的药材id';
ALTER TABLE tb_prescription_count_day DROP PRIMARY KEY, ADD PRIMARY KEY(time, pharmacy_id, medicine_pharmacy_id, kind_id);