CREATE TABLE  if not exists `oss_callbacks`(
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `md5` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `region` varchar(255) NOT NULL,
  `bucket` varchar(255) NOT NULL,
  `size` int(11) NOT NULL,
  `hospital_id` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `remark` varchar(255) DEFAULT NULL,
  `x_real_ip` varchar(255) DEFAULT NULL,
  `x_forwarded_for_ip` varchar(255) DEFAULT NULL,
  `request_date` varchar(255) DEFAULT NULL,
  `x_oss_request_id` varchar(255) DEFAULT NULL,
  `x_oss_requester` varchar(255) DEFAULT NULL,
  `x_oss_pub_key_url` varchar(255) DEFAULT NULL,
  `authorization` varchar(255) DEFAULT NULL,
  `content_md5` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `md5_index` (`md5`),
  UNIQUE KEY `url_index` (`url`),
  KEY `oss_callbacks_hospital_id` (`hospital_id`),
  KEY `oss_callbacks_bucket` (`bucket`),
  KEY `oss_callbacks_status` (`status`),
  KEY `oss_callbacks_x_real_ip` (`x_real_ip`),
  KEY `oss_callbacks_region` (`region`),
  KEY `oss_callbacks_x_forwarded_for_ip` (`x_forwarded_for_ip`),
  KEY `oss_callbacks_x_oss_request_id` (`x_oss_request_id`),
  KEY `oss_callbacks_x_oss_requester` (`x_oss_requester`),
  KEY `oss_callbacks_authorization` (`authorization`),
  KEY `oss_callbacks_x_oss_pub_key_url` (`x_oss_pub_key_url`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
ALTER  TABLE  `constant`  ADD  INDEX constant_value (  `constant_value`  );
ALTER  TABLE  `doctors`  ADD  INDEX doc_username (  `username`  );
ALTER  TABLE  `dr_cla_permission`  ADD  INDEX dr_pass (  `pass`  );
ALTER  TABLE  `dr_cla_permission`  ADD  INDEX dr_type (  `type`  );
ALTER  TABLE  `exams`  ADD  INDEX exam_report (  `exam_report`  );
ALTER  TABLE  `exams`  ADD  INDEX exam_project (  `exam_project`  );
ALTER  TABLE  `exams`  ADD  INDEX exam_device (  `device`  );
ALTER  TABLE  `exams`  ADD  INDEX exam_body (  `body_part`  );
ALTER  TABLE  `exams`  ADD  INDEX exams_exam_datetime (  `exam_datetime`  );
ALTER  TABLE  `exams`  ADD  INDEX exams_exam_class (  `exam_class`  );
ALTER  TABLE  `exams`  ADD  INDEX exams_exam_status (  `exam_status`  );
ALTER  TABLE  `exams`  ADD  INDEX exams_patient_num (  `patient_num`  );
ALTER  TABLE  `exams`  ADD  INDEX exams_patient_id (  `patient_id`  );
ALTER  TABLE  `images`  ADD  size varchar(255);
ALTER  TABLE  `images`  ADD  institution_id varchar(100);
ALTER  TABLE  `images`  ADD  INDEX series_id_index (  `series_id`  );
ALTER  TABLE  `images`  ADD  INDEX images_owner (  `owner`  );
ALTER  TABLE  `images`  ADD  INDEX images_institution_id (  `institution_id`  );
ALTER  TABLE  `images`  ADD  INDEX images_url (  `url`  );
ALTER  TABLE  `images`  ADD  INDEX images_series_id (  `series_id`  );
ALTER  TABLE  `operating`  ADD  INDEX month (  `month`  );
ALTER  TABLE  `patient_infos`  ADD  INDEX card_num (  `card_num`  );
ALTER  TABLE  `patient_infos`  ADD  INDEX patient_infos_institution_id (  `institution_id`  );
ALTER  TABLE  `series`  ADD  INDEX series_modality (  `modality`  );
ALTER  TABLE  `series`  ADD  INDEX series_study_id (  `study_id`  );
ALTER  TABLE  `studies`  ADD  INDEX studies_institution_name (  `institution_name`  );
ALTER  TABLE  `studies`  ADD  INDEX studies_patient_id (  `patient_id`  );
ALTER  TABLE  `studies`  ADD  INDEX studies_studydate (  `studydate`  );
ALTER  TABLE  `studies`  ADD  INDEX studies_modality (  `modality`  );
ALTER  TABLE  `studies`  ADD  INDEX studies_status (  `status`  );
ALTER  TABLE  `studies`  ADD  INDEX studies_studyid (  `studyid`  );
ALTER  TABLE  `studies`  ADD  INDEX studies_accession_num (  `accession_num`  );
delete from patient_infos where id not in (select patient_id from exams);