yuanchengpasc/application/common/versionsql/Version7

CREATE TABLE if not exists `every_studies` (
  `id` varchar(50) NOT NULL,
  `institution_id` varchar(50) DEFAULT NULL COMMENT '医院id',
  `institution_name` varchar(255) DEFAULT NULL COMMENT '医院名称',
  `date` varchar(50) DEFAULT NULL COMMENT '检查时间',
  `count` int(11) DEFAULT NULL COMMENT '检查数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER  TABLE  `institution`  ADD  is_test  varchar(10) default 0;
ALTER  TABLE  `doctors`  ADD  is_use_autograph  varchar(10) default 0;
ALTER  TABLE  `doctors`  ADD  autograph  varchar(255);
ALTER  TABLE  `exams`  ADD  application_department  varchar(255) COMMENT '申请科室';
ALTER  TABLE  `exams`  ADD  application_doctor  varchar(255) COMMENT '申请医生';
ALTER  TABLE  `exams`  ADD  severe   varchar(255) COMMENT '重症标识' default 0;