ALTER  TABLE  `report`  ADD  type varchar(10);
ALTER  TABLE  `report`  ADD  remote_application_id  varchar(50);
ALTER  TABLE  `remote_application`  ADD  report_status  varchar(10);
CREATE TABLE  if not exists `bbs` (
      `id` varchar(50) NOT NULL,
      `initiator` varchar(50) DEFAULT NULL COMMENT '发起人',
      `reply` varchar(50) DEFAULT NULL COMMENT '回复人',
      `remote_application_id` varchar(50) DEFAULT NULL COMMENT '申请单id',
      `content` varchar(3000) DEFAULT NULL COMMENT '内容',
      `attachment` varchar(255) DEFAULT NULL COMMENT '附件',
      `createdAt` datetime DEFAULT NULL COMMENT '创建时间',
      PRIMARY KEY (`id`),
      KEY `bbs_initiator` (`initiator`),
      KEY `bbs_reply` (`reply`),
      KEY `bbs_applicaition` (`remote_application_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER  TABLE  `institution`  ADD  msg_phone  varchar(50);
ALTER  TABLE  `institution`  ADD  urgent_time  varchar(50);
ALTER  TABLE  `institution`  ADD  not_urgent_time  varchar(50);
ALTER  TABLE  `doctors`  ADD  send_sms  int(10) default 0;
ALTER  TABLE  `exams`  ADD  id_card  varchar(50);
ALTER  TABLE  `exams`  ADD  INDEX exams_idcard (  `id_card`  );
ALTER  TABLE  `patient_infos`  ADD  INDEX patient_infos_phone (  `phone`  );