ALTER TABLE `blade_region` ADD INDEX `parent_code`(`parent_code` ASC) USING BTREE;

ALTER TABLE `h_basic_info` DROP INDEX `info_no_index`;

ALTER TABLE `h_basic_info` DROP INDEX `info_cert_num_id`;

ALTER TABLE `h_basic_info` ADD INDEX `info_num`(`info_num` ASC) USING BTREE;

ALTER TABLE `h_basic_info` ADD INDEX `cert_num_id`(`cert_num_id` ASC) USING BTREE;

ALTER TABLE `h_basic_info` ADD INDEX `resident_name`(`resident_name` ASC) USING BTREE;

ALTER TABLE `h_basic_info_history` ADD INDEX `cert_num_id`(`cert_num_id` ASC) USING BTREE;

ALTER TABLE `h_device_bioch_bld_equit` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_device_bioch_bld_equit` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_device_biochemical_data` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_device_biochemical_data` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_device_biochemical_data` ADD INDEX `bioch_id`(`bioch_id` ASC) USING BTREE;

ALTER TABLE `h_device_bmode_data` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_device_bmode_data` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_device_bmode_img` ADD INDEX `bmode_id`(`bmode_id` ASC) USING BTREE;

ALTER TABLE `h_device_cbc_data` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_device_cbc_data` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_device_cbc_data` ADD INDEX `info_id`(`info_id` ASC) USING BTREE;

ALTER TABLE `h_device_cbc_info` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_device_cbc_info` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_device_ecg_data` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_device_ecg_data` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_device_urin_items` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_device_urin_items` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_device_urin_items` ADD INDEX `bioch_id`(`bioch_id` ASC) USING BTREE;

ALTER TABLE `h_device_urin_record` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_device_urin_record` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_check_lifestyle` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst` DROP INDEX `h_info_num_index`;

ALTER TABLE `h_health_checklst` DROP INDEX `info_cert_num_id`;

ALTER TABLE `h_health_checklst` ADD INDEX `info_num`(`info_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst` ADD INDEX `cert_num_id`(`cert_num_id` ASC) USING BTREE;

ALTER TABLE `h_health_checklst` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst_exceptval` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst_guid` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst_hosp` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst_immunhis` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst_maindruguse` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst_majissues` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_checklst_rskctrlfac` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_chinese_medicine` DROP INDEX `h_health_chinese_medicine_cert_num_id_index`;

ALTER TABLE `h_health_chinese_medicine` ADD INDEX `cert_num_id`(`cert_num_id` ASC) USING BTREE;

ALTER TABLE `h_health_chinese_medicine` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_health_chinese_medicine` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_oldman_firs_vis` ADD INDEX `cert_num_id`(`cert_num_id` ASC) USING BTREE;

ALTER TABLE `h_oldman_firs_vis_asses_self` ADD INDEX `exam_num`(`exam_num` ASC) USING BTREE;

ALTER TABLE `h_oldman_firs_vis_asses_self` ADD INDEX `barcode_num`(`barcode_num` ASC) USING BTREE;

ALTER TABLE `h_towns_villages` ADD INDEX `town_code`(`town_code` ASC) USING BTREE;