ผู้เขียน หัวข้อ: upgrade structure แล้วError  (อ่าน 3132 ครั้ง)

0 สมาชิก และ 1 บุคคลทั่วไป กำลังดูหัวข้อนี้

ออฟไลน์ somchai

  • Newbie
  • *
  • กระทู้: 7
  • Respect: 0
    • ดูรายละเอียด
upgrade structure แล้วError
« เมื่อ: ตุลาคม 26, 2008, 13:05:52 PM »
0
ผมใช้เครื่องทดสอบโดยลง full setup v.3.51.8.6แล้ว upเป็น 3.51.10.10 พอupgrage structure แล้วเกิด Error
แบบนี้ครับ
SQL Error:Incorrect in information in file:\hos\kslklog.frm:
และSQL Error:Incorrect in information in file:\hos\replicate_slave_frm:
รบกวนอาจารย์ทุกท่านช่วยแก้ไขให้ด้วยครับ ผมมือใหม่ ขอบคุณล่วงหน้าครับ
server IBM x 3400 HD 160GB
RAM 2G
Linux centos 6.4 MySQL 5.6.13-56
HOSxP v.3.56.11.19
client 30
โรงพยบาลเกาะพะงัน อ.เกาะพะงัน จ.สุราษฎร์ธานี
ขึ้นระบบโดยทีม นครศรีธรรมราช เมื่อ ม.ค.51

ออฟไลน์ sungvien

  • Sr. Member
  • ****
  • กระทู้: 267
  • Respect: +1
    • ดูรายละเอียด
    • www.konsarnhospital.com
Re: upgrade structure แล้วError
« ตอบกลับ #1 เมื่อ: ตุลาคม 26, 2008, 16:45:08 PM »
0
"คอนสาร ดินแดนแห่งน้ำผุดไหลหลาก ป่าหมากอุดม  รื่นรมย์เขื่อนจุฬาฯ เพลินป่าทุ่งกะมัง  มนต์ขลังทุ่งลุยลาย"

โรงพยาบาลคอนสาร  จังหวัดชัยภูมิ
sungvien@gmail.com
Server IBM X3650  HDD SATA 180x3  RAM 8 GB
 OS : CentOS 5.2   MySQL 5.1.30  HOSxP 3.54.8.19
Datatcenter IBM 3500 HDD SATA 180x3  RAM 4 GB
ขึ้นระบบ 28 สิงหาคม 2550 : Updateล่าสุด  19/08/2011

 5 ปีกับชีวิตอันอบอุ่นและมีความสุข ในครอบครัว ชุมชน HOSxP
------------------------------------------------------------------
ขอเป็นพลังสนับสนุนและให้กำลังใจ อ.ชัยพร และทีมงาน BMS ขอรับครับผม

ออฟไลน์ somchai

  • Newbie
  • *
  • กระทู้: 7
  • Respect: 0
    • ดูรายละเอียด
Re: upgrade structure แล้วError
« ตอบกลับ #2 เมื่อ: ตุลาคม 27, 2008, 16:50:01 PM »
0
ขอบคุณมากครับ
server IBM x 3400 HD 160GB
RAM 2G
Linux centos 6.4 MySQL 5.6.13-56
HOSxP v.3.56.11.19
client 30
โรงพยบาลเกาะพะงัน อ.เกาะพะงัน จ.สุราษฎร์ธานี
ขึ้นระบบโดยทีม นครศรีธรรมราช เมื่อ ม.ค.51

doramon

  • บุคคลทั่วไป
Re: upgrade structure แล้วError
« ตอบกลับ #3 เมื่อ: ตุลาคม 27, 2008, 17:11:30 PM »
0
full setup v.3.51.10.22

doramon

  • บุคคลทั่วไป
Re: upgrade structure แล้วError
« ตอบกลับ #4 เมื่อ: ตุลาคม 27, 2008, 17:15:41 PM »
0
@echo off

echo Alter table to innodb engine
echo altering table access_menu
mysql.exe -u root -e "alter table hos.access_menu engine = innodb"
echo altering table accessoperation
mysql.exe -u root -e "alter table hos.accessoperation engine = innodb"
echo altering table active_medication
mysql.exe -u root -e "alter table hos.active_medication engine = innodb"
echo altering table adr_cause
mysql.exe -u root -e "alter table hos.adr_cause engine = innodb"
echo altering table adr_continue_rechallenge
mysql.exe -u root -e "alter table hos.adr_continue_rechallenge engine = innodb"
echo altering table adr_death
mysql.exe -u root -e "alter table hos.adr_death engine = innodb"
echo altering table adr_dechallenge_type
mysql.exe -u root -e "alter table hos.adr_dechallenge_type engine = innodb"
echo altering table adr_medication_source
mysql.exe -u root -e "alter table hos.adr_medication_source engine = innodb"
echo altering table adr_medication_type
mysql.exe -u root -e "alter table hos.adr_medication_type engine = innodb"
echo altering table adr_outcome
mysql.exe -u root -e "alter table hos.adr_outcome engine = innodb"
echo altering table adr_possibility
mysql.exe -u root -e "alter table hos.adr_possibility engine = innodb"
echo altering table adr_product_type
mysql.exe -u root -e "alter table hos.adr_product_type engine = innodb"
echo altering table adr_rechallenge_type
mysql.exe -u root -e "alter table hos.adr_rechallenge_type engine = innodb"
echo altering table adr_report_type
mysql.exe -u root -e "alter table hos.adr_report_type engine = innodb"
echo altering table adr_seriousness
mysql.exe -u root -e "alter table hos.adr_seriousness engine = innodb"
echo altering table advice_list
mysql.exe -u root -e "alter table hos.advice_list engine = innodb"
echo altering table age_id
mysql.exe -u root -e "alter table hos.age_id engine = innodb"
echo altering table al2dc
mysql.exe -u root -e "alter table hos.al2dc engine = innodb"
echo altering table al2mdc
mysql.exe -u root -e "alter table hos.al2mdc engine = innodb"
echo altering table allergy_confirm
mysql.exe -u root -e "alter table hos.allergy_confirm engine = innodb"
echo altering table allergy_group
mysql.exe -u root -e "alter table hos.allergy_group engine = innodb"
echo altering table allergy_relation
mysql.exe -u root -e "alter table hos.allergy_relation engine = innodb"
echo altering table allergy_result
mysql.exe -u root -e "alter table hos.allergy_result engine = innodb"
echo altering table allergy_seriousness
mysql.exe -u root -e "alter table hos.allergy_seriousness engine = innodb"
echo altering table an_stat
mysql.exe -u root -e "alter table hos.an_stat engine = innodb"
echo altering table anc_baby_lead
mysql.exe -u root -e "alter table hos.anc_baby_lead engine = innodb"
echo altering table anc_baby_position
mysql.exe -u root -e "alter table hos.anc_baby_position engine = innodb"
echo altering table anc_birthcontrol
mysql.exe -u root -e "alter table hos.anc_birthcontrol engine = innodb"
echo altering table anc_birthcontrol_history
mysql.exe -u root -e "alter table hos.anc_birthcontrol_history engine = innodb"
echo altering table anc_delivery
mysql.exe -u root -e "alter table hos.anc_delivery engine = innodb"
echo altering table anc_detail
mysql.exe -u root -e "alter table hos.anc_detail engine = innodb"
echo altering table anc_disease
mysql.exe -u root -e "alter table hos.anc_disease engine = innodb"
echo altering table anc_family_history
mysql.exe -u root -e "alter table hos.anc_family_history engine = innodb"
echo altering table anc_head
mysql.exe -u root -e "alter table hos.anc_head engine = innodb"
echo altering table anc_ill_history
mysql.exe -u root -e "alter table hos.anc_ill_history engine = innodb"
echo altering table anc_items
mysql.exe -u root -e "alter table hos.anc_items engine = innodb"
echo altering table anc_lab
mysql.exe -u root -e "alter table hos.anc_lab engine = innodb"
echo altering table anc_location_type
mysql.exe -u root -e "alter table hos.anc_location_type engine = innodb"
echo altering table anc_member
mysql.exe -u root -e "alter table hos.anc_member engine = innodb"
echo altering table anc_midwife
mysql.exe -u root -e "alter table hos.anc_midwife engine = innodb"
echo altering table anc_preg_care_location
mysql.exe -u root -e "alter table hos.anc_preg_care_location engine = innodb"
echo altering table anc_preg_history
mysql.exe -u root -e "alter table hos.anc_preg_history engine = innodb"
echo altering table anc_risk
mysql.exe -u root -e "alter table hos.anc_risk engine = innodb"
echo altering table anc_screen
mysql.exe -u root -e "alter table hos.anc_screen engine = innodb"
echo altering table anc_service
mysql.exe -u root -e "alter table hos.anc_service engine = innodb"
echo altering table anc_service_type
mysql.exe -u root -e "alter table hos.anc_service_type engine = innodb"
echo altering table anc_uterus_level
mysql.exe -u root -e "alter table hos.anc_uterus_level engine = innodb"
echo altering table anc_vc_result
mysql.exe -u root -e "alter table hos.anc_vc_result engine = innodb"
echo altering table anc_visit
mysql.exe -u root -e "alter table hos.anc_visit engine = innodb"
echo altering table aninsert
mysql.exe -u root -e "alter table hos.aninsert engine = innodb"
echo altering table app_storage
mysql.exe -u root -e "alter table hos.app_storage engine = innodb"
echo altering table approve_doctor
mysql.exe -u root -e "alter table hos.approve_doctor engine = innodb"
echo altering table appserver
mysql.exe -u root -e "alter table hos.appserver engine = innodb"
echo altering table ar_adjust
mysql.exe -u root -e "alter table hos.ar_adjust engine = innodb"
echo altering table ar_adjust_head
mysql.exe -u root -e "alter table hos.ar_adjust_head engine = innodb"
echo altering table ar_detail
mysql.exe -u root -e "alter table hos.ar_detail engine = innodb"
echo altering table ar_flag
mysql.exe -u root -e "alter table hos.ar_flag engine = innodb"
echo altering table ar_head
mysql.exe -u root -e "alter table hos.ar_head engine = innodb"
echo altering table ar_original_detail
mysql.exe -u root -e "alter table hos.ar_original_detail engine = innodb"
echo altering table ar_receive_detail
mysql.exe -u root -e "alter table hos.ar_receive_detail engine = innodb"
echo altering table ar_receive_head
mysql.exe -u root -e "alter table hos.ar_receive_head engine = innodb"
echo altering table ar_receive_type
mysql.exe -u root -e "alter table hos.ar_receive_type engine = innodb"
echo altering table ba_status
mysql.exe -u root -e "alter table hos.ba_status engine = innodb"
echo altering table baby_bmi
mysql.exe -u root -e "alter table hos.baby_bmi engine = innodb"
echo altering table baby_bmi_visit
mysql.exe -u root -e "alter table hos.baby_bmi_visit engine = innodb"
echo altering table baby_development_list
mysql.exe -u root -e "alter table hos.baby_development_list engine = innodb"
echo altering table baby_development_status
mysql.exe -u root -e "alter table hos.baby_development_status engine = innodb"
echo altering table baby_growth
mysql.exe -u root -e "alter table hos.baby_growth engine = innodb"
echo altering table baby_items
mysql.exe -u root -e "alter table hos.baby_items engine = innodb"
echo altering table baby_member
mysql.exe -u root -e "alter table hos.baby_member engine = innodb"
echo altering table baby_nutrition
mysql.exe -u root -e "alter table hos.baby_nutrition engine = innodb"
echo altering table baby_status
mysql.exe -u root -e "alter table hos.baby_status engine = innodb"
echo altering table baby_visit
mysql.exe -u root -e "alter table hos.baby_visit engine = innodb"
echo altering table backuplist
mysql.exe -u root -e "alter table hos.backuplist engine = innodb"
echo altering table backupx
mysql.exe -u root -e "alter table hos.backupx engine = innodb"
echo altering table backupx1
mysql.exe -u root -e "alter table hos.backupx1 engine = innodb"
echo altering table bb9_blood
mysql.exe -u root -e "alter table hos.bb9_blood engine = innodb"
echo altering table bb9_bloodcheck
mysql.exe -u root -e "alter table hos.bb9_bloodcheck engine = innodb"
echo altering table bb9_bloodgroup
mysql.exe -u root -e "alter table hos.bb9_bloodgroup engine = innodb"
echo altering table bb9_bloodhow
mysql.exe -u root -e "alter table hos.bb9_bloodhow engine = innodb"
echo altering table bb9_bloodtype
mysql.exe -u root -e "alter table hos.bb9_bloodtype engine = innodb"
echo altering table bb9_issuedetail
mysql.exe -u root -e "alter table hos.bb9_issuedetail engine = innodb"
echo altering table bb9_request
mysql.exe -u root -e "alter table hos.bb9_request engine = innodb"
echo altering table bb9_requestdetail
mysql.exe -u root -e "alter table hos.bb9_requestdetail engine = innodb"
echo altering table bb9_sender
mysql.exe -u root -e "alter table hos.bb9_sender engine = innodb"
echo altering table bb_blood
mysql.exe -u root -e "alter table hos.bb_blood engine = innodb"
echo altering table bb_bloodgroup
mysql.exe -u root -e "alter table hos.bb_bloodgroup engine = innodb"
echo altering table bb_issue
mysql.exe -u root -e "alter table hos.bb_issue engine = innodb"
echo altering table bb_issuedetail
mysql.exe -u root -e "alter table hos.bb_issuedetail engine = innodb"
echo altering table bb_issuetype
mysql.exe -u root -e "alter table hos.bb_issuetype engine = innodb"
echo altering table bb_place
mysql.exe -u root -e "alter table hos.bb_place engine = innodb"
echo altering table bb_receive
mysql.exe -u root -e "alter table hos.bb_receive engine = innodb"
echo altering table bb_receivedetail
mysql.exe -u root -e "alter table hos.bb_receivedetail engine = innodb"
echo altering table bb_receivetype
mysql.exe -u root -e "alter table hos.bb_receivetype engine = innodb"
echo altering table bb_sender
mysql.exe -u root -e "alter table hos.bb_sender engine = innodb"
echo altering table bb_sendertype
mysql.exe -u root -e "alter table hos.bb_sendertype engine = innodb"
echo altering table bb_status
mysql.exe -u root -e "alter table hos.bb_status engine = innodb"
echo altering table bb_subgroup
mysql.exe -u root -e "alter table hos.bb_subgroup engine = innodb"
echo altering table bb_unit
mysql.exe -u root -e "alter table hos.bb_unit engine = innodb"
echo altering table bed_charge_pttype
mysql.exe -u root -e "alter table hos.bed_charge_pttype engine = innodb"
echo altering table bed_status_type
mysql.exe -u root -e "alter table hos.bed_status_type engine = innodb"
echo altering table bedno
mysql.exe -u root -e "alter table hos.bedno engine = innodb"
echo altering table bedtype
mysql.exe -u root -e "alter table hos.bedtype engine = innodb"
echo altering table billbookreg
mysql.exe -u root -e "alter table hos.billbookreg engine = innodb"
echo altering table billrece
mysql.exe -u root -e "alter table hos.billrece engine = innodb"
echo altering table bird_flu_screen
mysql.exe -u root -e "alter table hos.bird_flu_screen engine = innodb"
echo altering table blood_detail_type
mysql.exe -u root -e "alter table hos.blood_detail_type engine = innodb"
echo altering table blood_group
mysql.exe -u root -e "alter table hos.blood_group engine = innodb"
echo altering table blood_pay_detail
mysql.exe -u root -e "alter table hos.blood_pay_detail engine = innodb"
echo altering table blood_pay_service
mysql.exe -u root -e "alter table hos.blood_pay_service engine = innodb"
echo altering table blood_request
mysql.exe -u root -e "alter table hos.blood_request engine = innodb"
echo altering table blood_request_detail
mysql.exe -u root -e "alter table hos.blood_request_detail engine = innodb"
echo altering table blood_request_item
mysql.exe -u root -e "alter table hos.blood_request_item engine = innodb"
echo altering table blood_rh
mysql.exe -u root -e "alter table hos.blood_rh engine = innodb"
echo altering table blood_status
mysql.exe -u root -e "alter table hos.blood_status engine = innodb"
echo altering table blood_type
mysql.exe -u root -e "alter table hos.blood_type engine = innodb"
echo altering table bmi_level
mysql.exe -u root -e "alter table hos.bmi_level engine = innodb"
echo altering table breast_cancer_result
mysql.exe -u root -e "alter table hos.breast_cancer_result engine = innodb"
echo altering table breast_feed_status
mysql.exe -u root -e "alter table hos.breast_feed_status engine = innodb"
echo altering table breast_test_type
mysql.exe -u root -e "alter table hos.breast_test_type engine = innodb"
echo altering table canaccess
mysql.exe -u root -e "alter table hos.canaccess engine = innodb"
echo altering table cardtype
mysql.exe -u root -e "alter table hos.cardtype engine = innodb"
echo altering table cause_id
mysql.exe -u root -e "alter table hos.cause_id engine = innodb"
echo altering table clinic
mysql.exe -u root -e "alter table hos.clinic engine = innodb"
echo altering table clinic_app_limit
mysql.exe -u root -e "alter table hos.clinic_app_limit engine = innodb"
echo altering table clinic_auto_lab
mysql.exe -u root -e "alter table hos.clinic_auto_lab engine = innodb"
echo altering table clinic_cormobidity
mysql.exe -u root -e "alter table hos.clinic_cormobidity engine = innodb"
echo altering table clinic_cormobidity_diabete
mysql.exe -u root -e "alter table hos.clinic_cormobidity_diabete engine = innodb"
echo altering table clinic_cormobidity_list
mysql.exe -u root -e "alter table hos.clinic_cormobidity_list engine = innodb"
echo altering table clinic_dm_member
mysql.exe -u root -e "alter table hos.clinic_dm_member engine = innodb"
echo altering table clinic_dm_refer_type
mysql.exe -u root -e "alter table hos.clinic_dm_refer_type engine = innodb"
echo altering table clinic_dys
mysql.exe -u root -e "alter table hos.clinic_dys engine = innodb"
echo altering table clinic_member_status
mysql.exe -u root -e "alter table hos.clinic_member_status engine = innodb"
echo altering table clinic_miss_dose
mysql.exe -u root -e "alter table hos.clinic_miss_dose engine = innodb"
echo altering table clinic_persist_icd
mysql.exe -u root -e "alter table hos.clinic_persist_icd engine = innodb"
echo altering table clinic_profile
mysql.exe -u root -e "alter table hos.clinic_profile engine = innodb"
echo altering table clinic_subtype
mysql.exe -u root -e "alter table hos.clinic_subtype engine = innodb"
echo altering table clinic_transfer
mysql.exe -u root -e "alter table hos.clinic_transfer engine = innodb"
echo altering table clinic_visit
mysql.exe -u root -e "alter table hos.clinic_visit engine = innodb"
echo altering table clinicmember
mysql.exe -u root -e "alter table hos.clinicmember engine = innodb"
echo altering table club_std
mysql.exe -u root -e "alter table hos.club_std engine = innodb"
echo altering table cluster_server
mysql.exe -u root -e "alter table hos.cluster_server engine = innodb"
echo altering table cluster_table_status
mysql.exe -u root -e "alter table hos.cluster_table_status engine = innodb"
echo altering table cluster_trigger
mysql.exe -u root -e "alter table hos.cluster_trigger engine = innodb"
echo altering table code504
mysql.exe -u root -e "alter table hos.code504 engine = innodb"
echo altering table code506
mysql.exe -u root -e "alter table hos.code506 engine = innodb"
echo altering table comdep
mysql.exe -u root -e "alter table hos.comdep engine = innodb"
echo altering table community
mysql.exe -u root -e "alter table hos.community engine = innodb"
echo altering table community_house
mysql.exe -u root -e "alter table hos.community_house engine = innodb"
echo altering table company_business
mysql.exe -u root -e "alter table hos.company_business engine = innodb"
echo altering table company_contact
mysql.exe -u root -e "alter table hos.company_contact engine = innodb"
echo altering table company_contact_discount
mysql.exe -u root -e "alter table hos.company_contact_discount engine = innodb"
echo altering table contract_partner
mysql.exe -u root -e "alter table hos.contract_partner engine = innodb"
echo altering table counseling_pttype
mysql.exe -u root -e "alter table hos.counseling_pttype engine = innodb"
echo altering table credit_card_type
mysql.exe -u root -e "alter table hos.credit_card_type engine = innodb"
echo altering table ct2ax
mysql.exe -u root -e "alter table hos.ct2ax engine = innodb"
echo altering table ct2bimdc
mysql.exe -u root -e "alter table hos.ct2bimdc engine = innodb"
echo altering table ct2ccexc
mysql.exe -u root -e "alter table hos.ct2ccexc engine = innodb"
echo altering table ct2icd10
mysql.exe -u root -e "alter table hos.ct2icd10 engine = innodb"
echo altering table ct2mdcpr
mysql.exe -u root -e "alter table hos.ct2mdcpr engine = innodb"
echo altering table ct2mscc
mysql.exe -u root -e "alter table hos.ct2mscc engine = innodb"
echo altering table ct2pcom
mysql.exe -u root -e "alter table hos.ct2pcom engine = innodb"
echo altering table ct2proc
mysql.exe -u root -e "alter table hos.ct2proc engine = innodb"
echo altering table ct2rw
mysql.exe -u root -e "alter table hos.ct2rw engine = innodb"
echo altering table ct2sh
mysql.exe -u root -e "alter table hos.ct2sh engine = innodb"
echo altering table cupsmoney
mysql.exe -u root -e "alter table hos.cupsmoney engine = innodb"
echo altering table cupsname
mysql.exe -u root -e "alter table hos.cupsname engine = innodb"
echo altering table data_synchronize
mysql.exe -u root -e "alter table hos.data_synchronize engine = innodb"
echo altering table data_system
mysql.exe -u root -e "alter table hos.data_system engine = innodb"
echo altering table datadictionary
mysql.exe -u root -e "alter table hos.datadictionary engine = innodb"
echo altering table dchstts
mysql.exe -u root -e "alter table hos.dchstts engine = innodb"
echo altering table dchtype
mysql.exe -u root -e "alter table hos.dchtype engine = innodb"
echo altering table death
mysql.exe -u root -e "alter table hos.death engine = innodb"
echo altering table debtor
mysql.exe -u root -e "alter table hos.debtor engine = innodb"
echo altering table debtor_dt
mysql.exe -u root -e "alter table hos.debtor_dt engine = innodb"
echo altering table deformed
mysql.exe -u root -e "alter table hos.deformed engine = innodb"
echo altering table dental_icd
mysql.exe -u root -e "alter table hos.dental_icd engine = innodb"
echo altering table dentop
mysql.exe -u root -e "alter table hos.dentop engine = innodb"
echo altering table department_substock_list
mysql.exe -u root -e "alter table hos.department_substock_list engine = innodb"
echo altering table detail_account
mysql.exe -u root -e "alter table hos.detail_account engine = innodb"
echo altering table devnote
mysql.exe -u root -e "alter table hos.devnote engine = innodb"
echo altering table df_type
mysql.exe -u root -e "alter table hos.df_type engine = innodb"
echo altering table diagtype
mysql.exe -u root -e "alter table hos.diagtype engine = innodb"
echo altering table dis_answer_type
mysql.exe -u root -e "alter table hos.dis_answer_type engine = innodb"
echo altering table dis_evaluate
mysql.exe -u root -e "alter table hos.dis_evaluate engine = innodb"
echo altering table dis_objective
mysql.exe -u root -e "alter table hos.dis_objective engine = innodb"
echo altering table dis_person_type
mysql.exe -u root -e "alter table hos.dis_person_type engine = innodb"
echo altering table dis_question_class
mysql.exe -u root -e "alter table hos.dis_question_class engine = innodb"
echo altering table dis_question_type
mysql.exe -u root -e "alter table hos.dis_question_type engine = innodb"
echo altering table dis_reference
mysql.exe -u root -e "alter table hos.dis_reference engine = innodb"
echo altering table dis_satisfied
mysql.exe -u root -e "alter table hos.dis_satisfied engine = innodb"
echo altering table dis_satisfied_result
mysql.exe -u root -e "alter table hos.dis_satisfied_result engine = innodb"
echo altering table dis_satisfied_topic
mysql.exe -u root -e "alter table hos.dis_satisfied_topic engine = innodb"
echo altering table dis_search
mysql.exe -u root -e "alter table hos.dis_search engine = innodb"
echo altering table dis_search_notfound
mysql.exe -u root -e "alter table hos.dis_search_notfound engine = innodb"
echo altering table dis_source
mysql.exe -u root -e "alter table hos.dis_source engine = innodb"
echo altering table dis_urgent_type
mysql.exe -u root -e "alter table hos.dis_urgent_type engine = innodb"
echo altering table doctor
mysql.exe -u root -e "alter table hos.doctor engine = innodb"
echo altering table doctor_cert
mysql.exe -u root -e "alter table hos.doctor_cert engine = innodb"
echo altering table doctor_cert_help1
mysql.exe -u root -e "alter table hos.doctor_cert_help1 engine = innodb"
echo altering table doctor_cert_help2
mysql.exe -u root -e "alter table hos.doctor_cert_help2 engine = innodb"
echo altering table doctor_consult
mysql.exe -u root -e "alter table hos.doctor_consult engine = innodb"
echo altering table doctor_consult_list
mysql.exe -u root -e "alter table hos.doctor_consult_list engine = innodb"
echo altering table doctor_dep_dlg_list
mysql.exe -u root -e "alter table hos.doctor_dep_dlg_list engine = innodb"
echo altering table doctor_department
mysql.exe -u root -e "alter table hos.doctor_department engine = innodb"
echo altering table doctor_df_oper_list
mysql.exe -u root -e "alter table hos.doctor_df_oper_list engine = innodb"
echo altering table doctor_df_rate
mysql.exe -u root -e "alter table hos.doctor_df_rate engine = innodb"
echo altering table doctor_fee_list
mysql.exe -u root -e "alter table hos.doctor_fee_list engine = innodb"
echo altering table doctor_fee_type
mysql.exe -u root -e "alter table hos.doctor_fee_type engine = innodb"
echo altering table doctor_form_list
mysql.exe -u root -e "alter table hos.doctor_form_list engine = innodb"
echo altering table doctor_formula
mysql.exe -u root -e "alter table hos.doctor_formula engine = innodb"
echo altering table doctor_formula_ipd
mysql.exe -u root -e "alter table hos.doctor_formula_ipd engine = innodb"
echo altering table doctor_icd10
mysql.exe -u root -e "alter table hos.doctor_icd10 engine = innodb"
echo altering table doctor_keyword
mysql.exe -u root -e "alter table hos.doctor_keyword engine = innodb"
echo altering table doctor_no_appointment
mysql.exe -u root -e "alter table hos.doctor_no_appointment engine = innodb"
echo altering table doctor_operation
mysql.exe -u root -e "alter table hos.doctor_operation engine = innodb"
echo altering table doctor_order_print_head
mysql.exe -u root -e "alter table hos.doctor_order_print_head engine = innodb"
echo altering table doctor_order_print_lock
mysql.exe -u root -e "alter table hos.doctor_order_print_lock engine = innodb"
echo altering table doctor_position
mysql.exe -u root -e "alter table hos.doctor_position engine = innodb"
echo altering table doctor_position_list
mysql.exe -u root -e "alter table hos.doctor_position_list engine = innodb"
echo altering table doctor_print_job
mysql.exe -u root -e "alter table hos.doctor_print_job engine = innodb"
echo altering table doctor_rate_type
mysql.exe -u root -e "alter table hos.doctor_rate_type engine = innodb"
echo altering table doctor_schedule
mysql.exe -u root -e "alter table hos.doctor_schedule engine = innodb"
echo altering table doctor_schedule_type
mysql.exe -u root -e "alter table hos.doctor_schedule_type engine = innodb"
echo altering table doctor_sound_record
mysql.exe -u root -e "alter table hos.doctor_sound_record engine = innodb"
echo altering table doctor_time
mysql.exe -u root -e "alter table hos.doctor_time engine = innodb"
echo altering table doctor_time_type
mysql.exe -u root -e "alter table hos.doctor_time_type engine = innodb"
echo altering table doctorptotlist
mysql.exe -u root -e "alter table hos.doctorptotlist engine = innodb"
echo altering table doctorscreen
mysql.exe -u root -e "alter table hos.doctorscreen engine = innodb"
echo altering table doraemon
mysql.exe -u root -e "alter table hos.doraemon engine = innodb"
echo altering table dosageform
mysql.exe -u root -e "alter table hos.dosageform engine = innodb"
echo altering table drg_group
mysql.exe -u root -e "alter table hos.drg_group engine = innodb"
echo altering table drgcc
mysql.exe -u root -e "alter table hos.drgcc engine = innodb"
echo altering table drgdxmain
mysql.exe -u root -e "alter table hos.drgdxmain engine = innodb"
echo altering table drgicd10
mysql.exe -u root -e "alter table hos.drgicd10 engine = innodb"
echo altering table drgmdc
mysql.exe -u root -e "alter table hos.drgmdc engine = innodb"
echo altering table drgnoncc
mysql.exe -u root -e "alter table hos.drgnoncc engine = innodb"
echo altering table drgopadd
mysql.exe -u root -e "alter table hos.drgopadd engine = innodb"
echo altering table drgopmain
mysql.exe -u root -e "alter table hos.drgopmain engine = innodb"
echo altering table drgoutput
mysql.exe -u root -e "alter table hos.drgoutput engine = innodb"
echo altering table drgprocedure
mysql.exe -u root -e "alter table hos.drgprocedure engine = innodb"
echo altering table drgrw
mysql.exe -u root -e "alter table hos.drgrw engine = innodb"
echo altering table drug_counseling_group
mysql.exe -u root -e "alter table hos.drug_counseling_group engine = innodb"
echo altering table drug_counseling_group_check
mysql.exe -u root -e "alter table hos.drug_counseling_group_check engine = innodb"
echo altering table drug_counseling_list
mysql.exe -u root -e "alter table hos.drug_counseling_list engine = innodb"
echo altering table drug_counseling_problem
mysql.exe -u root -e "alter table hos.drug_counseling_problem engine = innodb"
echo altering table drug_counseling_pttype
mysql.exe -u root -e "alter table hos.drug_counseling_pttype engine = innodb"
echo altering table drug_due
mysql.exe -u root -e "alter table hos.drug_due engine = innodb"
echo altering table drug_due_list
mysql.exe -u root -e "alter table hos.drug_due_list engine = innodb"
echo altering table drug_group_check
mysql.exe -u root -e "alter table hos.drug_group_check engine = innodb"
echo altering table drug_information_service
mysql.exe -u root -e "alter table hos.drug_information_service engine = innodb"
echo altering table drug_interaction
mysql.exe -u root -e "alter table hos.drug_interaction engine = innodb"
echo altering table drug_interaction_incident
mysql.exe -u root -e "alter table hos.drug_interaction_incident engine = innodb"
echo altering table drug_interaction_type
mysql.exe -u root -e "alter table hos.drug_interaction_type engine = innodb"
echo altering table drug_monograph
mysql.exe -u root -e "alter table hos.drug_monograph engine = innodb"
echo altering table drug_user_check
mysql.exe -u root -e "alter table hos.drug_user_check engine = innodb"
echo altering table drugalias
mysql.exe -u root -e "alter table hos.drugalias engine = innodb"
echo altering table drugbarcode
mysql.exe -u root -e "alter table hos.drugbarcode engine = innodb"
echo altering table drugbdgtype
mysql.exe -u root -e "alter table hos.drugbdgtype engine = innodb"
echo altering table drugcom
mysql.exe -u root -e "alter table hos.drugcom engine = innodb"
echo altering table drugdepartment
mysql.exe -u root -e "alter table hos.drugdepartment engine = innodb"
echo altering table drugessential
mysql.exe -u root -e "alter table hos.drugessential engine = innodb"
echo altering table drugeval
mysql.exe -u root -e "alter table hos.drugeval engine = innodb"
echo altering table druggpo
mysql.exe -u root -e "alter table hos.druggpo engine = innodb"
echo altering table drughint
mysql.exe -u root -e "alter table hos.drughint engine = innodb"
echo altering table drugitems
mysql.exe -u root -e "alter table hos.drugitems engine = innodb"
echo altering table drugitems_clinic
mysql.exe -u root -e "alter table hos.drugitems_clinic engine = innodb"
echo altering table drugitems_factor
mysql.exe -u root -e "alter table hos.drugitems_factor engine = innodb"
echo altering table drugitems_inc
mysql.exe -u root -e "alter table hos.drugitems_inc engine = innodb"
echo altering table drugitems_ingredient
mysql.exe -u root -e "alter table hos.drugitems_ingredient engine = innodb"
echo altering table drugitems_picture
mysql.exe -u root -e "alter table hos.drugitems_picture engine = innodb"
echo altering table drugitems_usage
mysql.exe -u root -e "alter table hos.drugitems_usage engine = innodb"
echo altering table drugitemstype
mysql.exe -u root -e "alter table hos.drugitemstype engine = innodb"
echo altering table drugjoin
mysql.exe -u root -e "alter table hos.drugjoin engine = innodb"
echo altering table drugminp
mysql.exe -u root -e "alter table hos.drugminp engine = innodb"
echo altering table drugminpdt
mysql.exe -u root -e "alter table hos.drugminpdt engine = innodb"
echo altering table drugminptype
mysql.exe -u root -e "alter table hos.drugminptype engine = innodb"
echo altering table drugorderplan
mysql.exe -u root -e "alter table hos.drugorderplan engine = innodb"
echo altering table drugpaylist
mysql.exe -u root -e "alter table hos.drugpaylist engine = innodb"
echo altering table drugpayref
mysql.exe -u root -e "alter table hos.drugpayref engine = innodb"
echo altering table drugphmtype
mysql.exe -u root -e "alter table hos.drugphmtype engine = innodb"
echo altering table drugpotype
mysql.exe -u root -e "alter table hos.drugpotype engine = innodb"
echo altering table drugptype
mysql.exe -u root -e "alter table hos.drugptype engine = innodb"
echo altering table drugrecipient
mysql.exe -u root -e "alter table hos.drugrecipient engine = innodb"
echo altering table drugrequestdetail
mysql.exe -u root -e "alter table hos.drugrequestdetail engine = innodb"
echo altering table drugrequestsummary
mysql.exe -u root -e "alter table hos.drugrequestsummary engine = innodb"
echo altering table drugrtype
mysql.exe -u root -e "alter table hos.drugrtype engine = innodb"
echo altering table drugsa
mysql.exe -u root -e "alter table hos.drugsa engine = innodb"
echo altering table drugstdgeneric
mysql.exe -u root -e "alter table hos.drugstdgeneric engine = innodb"
echo altering table drugstickeridr
mysql.exe -u root -e "alter table hos.drugstickeridr engine = innodb"
echo altering table drugstock
mysql.exe -u root -e "alter table hos.drugstock engine = innodb"
echo altering table drugstockperson
mysql.exe -u root -e "alter table hos.drugstockperson engine = innodb"
echo altering table drugstockpersontype
mysql.exe -u root -e "alter table hos.drugstockpersontype engine = innodb"
echo altering table drugstockpropose
mysql.exe -u root -e "alter table hos.drugstockpropose engine = innodb"
echo altering table drugstockproposedetail
mysql.exe -u root -e "alter table hos.drugstockproposedetail engine = innodb"
echo altering table drugstockproposeorder
mysql.exe -u root -e "alter table hos.drugstockproposeorder engine = innodb"
echo altering table drugstockproposeperson
mysql.exe -u root -e "alter table hos.drugstockproposeperson engine = innodb"
echo altering table drugstore_detail
mysql.exe -u root -e "alter table hos.drugstore_detail engine = innodb"
echo altering table drugstore_head
mysql.exe -u root -e "alter table hos.drugstore_head engine = innodb"
echo altering table drugstrength
mysql.exe -u root -e "alter table hos.drugstrength engine = innodb"
echo altering table drugsupport
mysql.exe -u root -e "alter table hos.drugsupport engine = innodb"
echo altering table drugunits
mysql.exe -u root -e "alter table hos.drugunits engine = innodb"
echo altering table drugusage
mysql.exe -u root -e "alter table hos.drugusage engine = innodb"
echo altering table drugusage_default
mysql.exe -u root -e "alter table hos.drugusage_default engine = innodb"
echo altering table drugusage_line1
mysql.exe -u root -e "alter table hos.drugusage_line1 engine = innodb"
echo altering table drugusage_line2
mysql.exe -u root -e "alter table hos.drugusage_line2 engine = innodb"
echo altering table drugusage_line3
mysql.exe -u root -e "alter table hos.drugusage_line3 engine = innodb"
echo altering table dt_ipd_list
mysql.exe -u root -e "alter table hos.dt_ipd_list engine = innodb"
echo altering table dt_ipd_list_detail
mysql.exe -u root -e "alter table hos.dt_ipd_list_detail engine = innodb"
echo altering table dt_list
mysql.exe -u root -e "alter table hos.dt_list engine = innodb"
echo altering table dt_position
mysql.exe -u root -e "alter table hos.dt_position engine = innodb"
echo altering table dt_xray_result
mysql.exe -u root -e "alter table hos.dt_xray_result engine = innodb"
echo altering table dtacthistory
mysql.exe -u root -e "alter table hos.dtacthistory engine = innodb"
echo altering table dtapp
mysql.exe -u root -e "alter table hos.dtapp engine = innodb"
echo altering table dtdetail
mysql.exe -u root -e "alter table hos.dtdetail engine = innodb"
echo altering table dtdetail2
mysql.exe -u root -e "alter table hos.dtdetail2 engine = innodb"
echo altering table dtdetail_name
mysql.exe -u root -e "alter table hos.dtdetail_name engine = innodb"
echo altering table dtdetail_name2
mysql.exe -u root -e "alter table hos.dtdetail_name2 engine = innodb"
echo altering table dtdetailmain
mysql.exe -u root -e "alter table hos.dtdetailmain engine = innodb"
echo altering table dtdn
mysql.exe -u root -e "alter table hos.dtdn engine = innodb"
echo altering table dtmain
mysql.exe -u root -e "alter table hos.dtmain engine = innodb"
echo altering table dtmain_ipd
mysql.exe -u root -e "alter table hos.dtmain_ipd engine = innodb"
echo altering table dtmain_save
mysql.exe -u root -e "alter table hos.dtmain_save engine = innodb"
echo altering table dttm
mysql.exe -u root -e "alter table hos.dttm engine = innodb"
echo altering table dttm_group
mysql.exe -u root -e "alter table hos.dttm_group engine = innodb"
echo altering table dttm_inc
mysql.exe -u root -e "alter table hos.dttm_inc engine = innodb"
echo altering table dttm_master
mysql.exe -u root -e "alter table hos.dttm_master engine = innodb"
echo altering table dttmrpt
mysql.exe -u root -e "alter table hos.dttmrpt engine = innodb"
echo altering table dxa_advice
mysql.exe -u root -e "alter table hos.dxa_advice engine = innodb"
echo altering table dxa_bodyregion
mysql.exe -u root -e "alter table hos.dxa_bodyregion engine = innodb"
echo altering table dxa_cc
mysql.exe -u root -e "alter table hos.dxa_cc engine = innodb"
echo altering table dxa_cc_pdf
mysql.exe -u root -e "alter table hos.dxa_cc_pdf engine = innodb"
echo altering table dxa_disease
mysql.exe -u root -e "alter table hos.dxa_disease engine = innodb"
echo altering table dxa_disease_cc
mysql.exe -u root -e "alter table hos.dxa_disease_cc engine = innodb"
echo altering table dxa_disease_habit
mysql.exe -u root -e "alter table hos.dxa_disease_habit engine = innodb"
echo altering table dxa_disease_physical_exam
mysql.exe -u root -e "alter table hos.dxa_disease_physical_exam engine = innodb"
echo altering table dxa_person_habit
mysql.exe -u root -e "alter table hos.dxa_person_habit engine = innodb"
echo altering table dxa_person_properties
mysql.exe -u root -e "alter table hos.dxa_person_properties engine = innodb"
echo altering table dxa_physical_exam
mysql.exe -u root -e "alter table hos.dxa_physical_exam engine = innodb"
echo altering table dxa_treatment
mysql.exe -u root -e "alter table hos.dxa_treatment engine = innodb"
echo altering table dxa_vital_sign
mysql.exe -u root -e "alter table hos.dxa_vital_sign engine = innodb"
echo altering table edoc_activity_list
mysql.exe -u root -e "alter table hos.edoc_activity_list engine = innodb"
echo altering table edoc_attachment
mysql.exe -u root -e "alter table hos.edoc_attachment engine = innodb"
echo altering table edoc_command
mysql.exe -u root -e "alter table hos.edoc_command engine = innodb"
echo altering table edoc_department_list
mysql.exe -u root -e "alter table hos.edoc_department_list engine = innodb"
echo altering table edoc_list
mysql.exe -u root -e "alter table hos.edoc_list engine = innodb"
echo altering table edoc_objective
mysql.exe -u root -e "alter table hos.edoc_objective engine = innodb"
echo altering table edoc_priority
mysql.exe -u root -e "alter table hos.edoc_priority engine = innodb"
echo altering table edoc_security
mysql.exe -u root -e "alter table hos.edoc_security engine = innodb"
echo altering table edoc_send
mysql.exe -u root -e "alter table hos.edoc_send engine = innodb"
echo altering table edoc_status
mysql.exe -u root -e "alter table hos.edoc_status engine = innodb"
echo altering table edoc_status_list
mysql.exe -u root -e "alter table hos.edoc_status_list engine = innodb"
echo altering table edoc_transport
mysql.exe -u root -e "alter table hos.edoc_transport engine = innodb"
echo altering table edoc_type
mysql.exe -u root -e "alter table hos.edoc_type engine = innodb"
echo altering table education
mysql.exe -u root -e "alter table hos.education engine = innodb"
echo altering table ee_check_side
mysql.exe -u root -e "alter table hos.ee_check_side engine = innodb"
echo altering table entity_code
mysql.exe -u root -e "alter table hos.entity_code engine = innodb"
echo altering table epi_vaccine
mysql.exe -u root -e "alter table hos.epi_vaccine engine = innodb"
echo altering table er_accident_type
mysql.exe -u root -e "alter table hos.er_accident_type engine = innodb"
echo altering table er_activity
mysql.exe -u root -e "alter table hos.er_activity engine = innodb"
echo altering table er_command
mysql.exe -u root -e "alter table hos.er_command engine = innodb"
echo altering table er_dch_type
mysql.exe -u root -e "alter table hos.er_dch_type engine = innodb"
echo altering table er_doctor
mysql.exe -u root -e "alter table hos.er_doctor engine = innodb"
echo altering table er_doctor_position
mysql.exe -u root -e "alter table hos.er_doctor_position engine = innodb"
echo altering table er_emergency_type
mysql.exe -u root -e "alter table hos.er_emergency_type engine = innodb"
echo altering table er_iv_list
mysql.exe -u root -e "alter table hos.er_iv_list engine = innodb"
echo altering table er_nursing_activity
mysql.exe -u root -e "alter table hos.er_nursing_activity engine = innodb"
echo altering table er_nursing_detail
mysql.exe -u root -e "alter table hos.er_nursing_detail engine = innodb"
echo altering table er_nursing_record
mysql.exe -u root -e "alter table hos.er_nursing_record engine = innodb"
echo altering table er_nursing_visit_type
mysql.exe -u root -e "alter table hos.er_nursing_visit_type engine = innodb"
echo altering table er_oper_code
mysql.exe -u root -e "alter table hos.er_oper_code engine = innodb"
echo altering table er_oper_status
mysql.exe -u root -e "alter table hos.er_oper_status engine = innodb"
echo altering table er_period
mysql.exe -u root -e "alter table hos.er_period engine = innodb"
echo altering table er_pt_type
mysql.exe -u root -e "alter table hos.er_pt_type engine = innodb"
echo altering table er_refer_hosptype
mysql.exe -u root -e "alter table hos.er_refer_hosptype engine = innodb"
echo altering table er_refer_sender
mysql.exe -u root -e "alter table hos.er_refer_sender engine = innodb"
echo altering table er_regist
mysql.exe -u root -e "alter table hos.er_regist engine = innodb"
echo altering table er_regist_oper
mysql.exe -u root -e "alter table hos.er_regist_oper engine = innodb"
echo altering table erais
mysql.exe -u root -e "alter table hos.erais engine = innodb"
echo altering table eris
mysql.exe -u root -e "alter table hos.eris engine = innodb"
echo altering table eriscode
mysql.exe -u root -e "alter table hos.eriscode engine = innodb"
echo altering table eroprt
mysql.exe -u root -e "alter table hos.eroprt engine = innodb"
echo altering table eye_examination
mysql.exe -u root -e "alter table hos.eye_examination engine = innodb"
echo altering table eye_report_code
mysql.exe -u root -e "alter table hos.eye_report_code engine = innodb"
echo altering table eye_screen
mysql.exe -u root -e "alter table hos.eye_screen engine = innodb"
echo altering table eye_screen_code
mysql.exe -u root -e "alter table hos.eye_screen_code engine = innodb"
echo altering table factordm
mysql.exe -u root -e "alter table hos.factordm engine = innodb"
echo altering table family
mysql.exe -u root -e "alter table hos.family engine = innodb"
echo altering table family_chart
mysql.exe -u root -e "alter table hos.family_chart engine = innodb"
echo altering table family_person
mysql.exe -u root -e "alter table hos.family_person engine = innodb"
echo altering table fbshistory
mysql.exe -u root -e "alter table hos.fbshistory engine = innodb"
echo altering table feature_request
mysql.exe -u root -e "alter table hos.feature_request engine = innodb"
echo altering table ff_biography
mysql.exe -u root -e "alter table hos.ff_biography engine = innodb"
echo altering table ff_service
mysql.exe -u root -e "alter table hos.ff_service engine = innodb"
echo altering table ff_service_list
mysql.exe -u root -e "alter table hos.ff_service_list engine = innodb"
echo altering table ffdeath
mysql.exe -u root -e "alter table hos.ffdeath engine = innodb"
echo altering table ffhealth
mysql.exe -u root -e "alter table hos.ffhealth engine = innodb"
echo altering table ffhealthcare
mysql.exe -u root -e "alter table hos.ffhealthcare engine = innodb"
echo altering table ffmember
mysql.exe -u root -e "alter table hos.ffmember engine = innodb"
echo altering table file_category
mysql.exe -u root -e "alter table hos.file_category engine = innodb"
echo altering table file_source
mysql.exe -u root -e "alter table hos.file_source engine = innodb"
echo altering table finance_check
mysql.exe -u root -e "alter table hos.finance_check engine = innodb"
echo altering table finance_deposit
mysql.exe -u root -e "alter table hos.finance_deposit engine = innodb"
echo altering table finance_pay_type
mysql.exe -u root -e "alter table hos.finance_pay_type engine = innodb"
echo altering table finance_status
mysql.exe -u root -e "alter table hos.finance_status engine = innodb"
echo altering table finance_ticket
mysql.exe -u root -e "alter table hos.finance_ticket engine = innodb"
echo altering table finance_ticket_visit
mysql.exe -u root -e "alter table hos.finance_ticket_visit engine = innodb"
echo altering table finger_scan
mysql.exe -u root -e "alter table hos.finger_scan engine = innodb"
echo altering table food_allergy
mysql.exe -u root -e "alter table hos.food_allergy engine = innodb"
echo altering table food_date
mysql.exe -u root -e "alter table hos.food_date engine = innodb"
echo altering table food_menu_detail
mysql.exe -u root -e "alter table hos.food_menu_detail engine = innodb"
echo altering table food_menu_head
mysql.exe -u root -e "alter table hos.food_menu_head engine = innodb"
echo altering table fp_code
mysql.exe -u root -e "alter table hos.fp_code engine = innodb"
echo altering table fp_member
mysql.exe -u root -e "alter table hos.fp_member engine = innodb"
echo altering table fp_visit
mysql.exe -u root -e "alter table hos.fp_visit engine = innodb"
echo altering table fp_women
mysql.exe -u root -e "alter table hos.fp_women engine = innodb"
echo altering table fpapp
mysql.exe -u root -e "alter table hos.fpapp engine = innodb"
echo altering table fpmain
mysql.exe -u root -e "alter table hos.fpmain engine = innodb"
echo altering table fpspclty
mysql.exe -u root -e "alter table hos.fpspclty engine = innodb"
echo altering table gpsccode
mysql.exe -u root -e "alter table hos.gpsccode engine = innodb"
echo altering table health_med_items
mysql.exe -u root -e "alter table hos.health_med_items engine = innodb"
echo altering table health_med_list
mysql.exe -u root -e "alter table hos.health_med_list engine = innodb"
echo altering table health_screen
mysql.exe -u root -e "alter table hos.health_screen engine = innodb"
echo altering table height_level
mysql.exe -u root -e "alter table hos.height_level engine = innodb"
echo altering table hinso1
mysql.exe -u root -e "alter table hos.hinso1 engine = innodb"
echo altering table hipdata
mysql.exe -u root -e "alter table hos.hipdata engine = innodb"
echo altering table hipdatachw
mysql.exe -u root -e "alter table hos.hipdatachw engine = innodb"
echo altering table hismember
mysql.exe -u root -e "alter table hos.hismember engine = innodb"
echo altering table hninsert
mysql.exe -u root -e "alter table hos.hninsert engine = innodb"
echo altering table holiday
mysql.exe -u root -e "alter table hos.holiday engine = innodb"
echo altering table hosis
mysql.exe -u root -e "alter table hos.hosis engine = innodb"
echo altering table hospcode
mysql.exe -u root -e "alter table hos.hospcode engine = innodb"
echo altering table hospcode_cup_detail
mysql.exe -u root -e "alter table hos.hospcode_cup_detail engine = innodb"
echo altering table hospcode_cup_list
mysql.exe -u root -e "alter table hos.hospcode_cup_list engine = innodb"
echo altering table hospcode_sss_main
mysql.exe -u root -e "alter table hos.hospcode_sss_main engine = innodb"
echo altering table hospital
mysql.exe -u root -e "alter table hos.hospital engine = innodb"
echo altering table hospital_department
mysql.exe -u root -e "alter table hos.hospital_department engine = innodb"
echo altering table hosxp_ddl_field
mysql.exe -u root -e "alter table hos.hosxp_ddl_field engine = innodb"
echo altering table hosxp_ddl_index
mysql.exe -u root -e "alter table hos.hosxp_ddl_index engine = innodb"
echo altering table hosxp_error_message
mysql.exe -u root -e "alter table hos.hosxp_error_message engine = innodb"
echo altering table house
mysql.exe -u root -e "alter table hos.house engine = innodb"
echo altering table house_mosquitoes_advice
mysql.exe -u root -e "alter table hos.house_mosquitoes_advice engine = innodb"
echo altering table house_mosquitoes_prevent
mysql.exe -u root -e "alter table hos.house_mosquitoes_prevent engine = innodb"
echo altering table house_mosquitoes_survey
mysql.exe -u root -e "alter table hos.house_mosquitoes_survey engine = innodb"
echo altering table house_regist_type
mysql.exe -u root -e "alter table hos.house_regist_type engine = innodb"
echo altering table house_survey
mysql.exe -u root -e "alter table hos.house_survey engine = innodb"
echo altering table house_survey_detail
mysql.exe -u root -e "alter table hos.house_survey_detail engine = innodb"
echo altering table house_survey_garbage
mysql.exe -u root -e "alter table hos.house_survey_garbage engine = innodb"
echo altering table house_survey_health
mysql.exe -u root -e "alter table hos.house_survey_health engine = innodb"
echo altering table house_survey_item
mysql.exe -u root -e "alter table hos.house_survey_item engine = innodb"
echo altering table house_survey_summary
mysql.exe -u root -e "alter table hos.house_survey_summary engine = innodb"
echo altering table house_survey_toilet
mysql.exe -u root -e "alter table hos.house_survey_toilet engine = innodb"
echo altering table house_survey_water
mysql.exe -u root -e "alter table hos.house_survey_water engine = innodb"
echo altering table house_survey_yesno
mysql.exe -u root -e "alter table hos.house_survey_yesno engine = innodb"
echo altering table house_type
mysql.exe -u root -e "alter table hos.house_type engine = innodb"
echo altering table icd101
mysql.exe -u root -e "alter table hos.icd101 engine = innodb"
echo altering table icd102
mysql.exe -u root -e "alter table hos.icd102 engine = innodb"
echo altering table icd103
mysql.exe -u root -e "alter table hos.icd103 engine = innodb"
echo altering table icd10_sss
mysql.exe -u root -e "alter table hos.icd10_sss engine = innodb"
echo altering table icd10_sss_check
mysql.exe -u root -e "alter table hos.icd10_sss_check engine = innodb"
echo altering table icd10doctor
mysql.exe -u root -e "alter table hos.icd10doctor engine = innodb"
echo altering table icd10help
mysql.exe -u root -e "alter table hos.icd10help engine = innodb"
echo altering table icd9_sss
mysql.exe -u root -e "alter table hos.icd9_sss engine = innodb"
echo altering table icd9cm1
mysql.exe -u root -e "alter table hos.icd9cm1 engine = innodb"
echo altering table icd9cm2
mysql.exe -u root -e "alter table hos.icd9cm2 engine = innodb"
echo altering table icd9cm3
mysql.exe -u root -e "alter table hos.icd9cm3 engine = innodb"
echo altering table icd_codemap
mysql.exe -u root -e "alter table hos.icd_codemap engine = innodb"
echo altering table idr_description
mysql.exe -u root -e "alter table hos.idr_description engine = innodb"
echo altering table inc_ipd_stat
mysql.exe -u root -e "alter table hos.inc_ipd_stat engine = innodb"
echo altering table inc_opd_print
mysql.exe -u root -e "alter table hos.inc_opd_print engine = innodb"
echo altering table inc_opd_stat
mysql.exe -u root -e "alter table hos.inc_opd_stat engine = innodb"
echo altering table inc_std_ipd_stat
mysql.exe -u root -e "alter table hos.inc_std_ipd_stat engine = innodb"
echo altering table inc_std_opd_stat
mysql.exe -u root -e "alter table hos.inc_std_opd_stat engine = innodb"
echo altering table incith
mysql.exe -u root -e "alter table hos.incith engine = innodb"
echo altering table incith_adjust
mysql.exe -u root -e "alter table hos.incith_adjust engine = innodb"
echo altering table incith_cashier
mysql.exe -u root -e "alter table hos.incith_cashier engine = innodb"
echo altering table incith_current
mysql.exe -u root -e "alter table hos.incith_current engine = innodb"
echo altering table incith_summary
mysql.exe -u root -e "alter table hos.incith_summary engine = innodb"
echo altering table income
mysql.exe -u root -e "alter table hos.income engine = innodb"
echo altering table income_check
mysql.exe -u root -e "alter table hos.income_check engine = innodb"
echo altering table income_discount
mysql.exe -u root -e "alter table hos.income_discount engine = innodb"
echo altering table income_group
mysql.exe -u root -e "alter table hos.income_group engine = innodb"
echo altering table income_header
mysql.exe -u root -e "alter table hos.income_header engine = innodb"
echo altering table income_nk2
mysql.exe -u root -e "alter table hos.income_nk2 engine = innodb"
echo altering table income_report1
mysql.exe -u root -e "alter table hos.income_report1 engine = innodb"
echo altering table income_report2
mysql.exe -u root -e "alter table hos.income_report2 engine = innodb"
echo altering table income_report3
mysql.exe -u root -e "alter table hos.income_report3 engine = innodb"
echo altering table income_report4
mysql.exe -u root -e "alter table hos.income_report4 engine = innodb"
echo altering table income_report_sss
mysql.exe -u root -e "alter table hos.income_report_sss engine = innodb"
echo altering table income_std_group
mysql.exe -u root -e "alter table hos.income_std_group engine = innodb"
echo altering table incoth
mysql.exe -u root -e "alter table hos.incoth engine = innodb"
echo altering table incoth_summary
mysql.exe -u root -e "alter table hos.incoth_summary engine = innodb"
echo altering table incoth_summary_head
mysql.exe -u root -e "alter table hos.incoth_summary_head engine = innodb"
echo altering table inj_demo
mysql.exe -u root -e "alter table hos.inj_demo engine = innodb"
echo altering table inj_er
mysql.exe -u root -e "alter table hos.inj_er engine = innodb"
echo altering table inj_injury
mysql.exe -u root -e "alter table hos.inj_injury engine = innodb"
echo altering table inj_refer
mysql.exe -u root -e "alter table hos.inj_refer engine = innodb"
echo altering table injury
mysql.exe -u root -e "alter table hos.injury engine = innodb"
echo altering table intraweb
mysql.exe -u root -e "alter table hos.intraweb engine = innodb"
echo altering table inv_substock_list
mysql.exe -u root -e "alter table hos.inv_substock_list engine = innodb"
echo altering table ipd_data_synchronize
mysql.exe -u root -e "alter table hos.ipd_data_synchronize engine = innodb"
echo altering table ipd_df
mysql.exe -u root -e "alter table hos.ipd_df engine = innodb"
echo altering table ipd_dosage_plan
mysql.exe -u root -e "alter table hos.ipd_dosage_plan engine = innodb"
echo altering table ipd_finance_head
mysql.exe -u root -e "alter table hos.ipd_finance_head engine = innodb"
echo altering table ipd_mar
mysql.exe -u root -e "alter table hos.ipd_mar engine = innodb"
echo altering table ipd_nurse_note
mysql.exe -u root -e "alter table hos.ipd_nurse_note engine = innodb"
echo altering table ipd_order_status
mysql.exe -u root -e "alter table hos.ipd_order_status engine = innodb"
echo altering table ipd_profile_print
mysql.exe -u root -e "alter table hos.ipd_profile_print engine = innodb"
echo altering table ipd_refer
mysql.exe -u root -e "alter table hos.ipd_refer engine = innodb"
echo altering table ipdrent
mysql.exe -u root -e "alter table hos.ipdrent engine = innodb"
echo altering table ipt
mysql.exe -u root -e "alter table hos.ipt engine = innodb"
echo altering table ipt_accident
mysql.exe -u root -e "alter table hos.ipt_accident engine = innodb"
echo altering table ipt_act_money
mysql.exe -u root -e "alter table hos.ipt_act_money engine = innodb"
echo altering table ipt_admit_queue
mysql.exe -u root -e "alter table hos.ipt_admit_queue engine = innodb"
echo altering table ipt_admit_stat
mysql.exe -u root -e "alter table hos.ipt_admit_stat engine = innodb"
echo altering table ipt_chart_location
mysql.exe -u root -e "alter table hos.ipt_chart_location engine = innodb"
echo altering table ipt_chart_state
mysql.exe -u root -e "alter table hos.ipt_chart_state engine = innodb"
echo altering table ipt_discharge_note
mysql.exe -u root -e "alter table hos.ipt_discharge_note engine = innodb"
echo altering table ipt_doctor_list
mysql.exe -u root -e "alter table hos.ipt_doctor_list engine = innodb"
echo altering table ipt_document_url
mysql.exe -u root -e "alter table hos.ipt_document_url engine = innodb"
echo altering table ipt_er_detail
mysql.exe -u root -e "alter table hos.ipt_er_detail engine = innodb"
echo altering table ipt_er_list
mysql.exe -u root -e "alter table hos.ipt_er_list engine = innodb"
echo altering table ipt_finance_status
mysql.exe -u root -e "alter table hos.ipt_finance_status engine = innodb"
echo altering table ipt_food_menu
mysql.exe -u root -e "alter table hos.ipt_food_menu engine = innodb"
echo altering table ipt_food_order_sp
mysql.exe -u root -e "alter table hos.ipt_food_order_sp engine = innodb"
echo altering table ipt_food_print
mysql.exe -u root -e "alter table hos.ipt_food_print engine = innodb"
echo altering table ipt_home_stay
mysql.exe -u root -e "alter table hos.ipt_home_stay engine = innodb"
echo altering table ipt_income_auto
mysql.exe -u root -e "alter table hos.ipt_income_auto engine = innodb"
echo altering table ipt_income_auto_charge
mysql.exe -u root -e "alter table hos.ipt_income_auto_charge engine = innodb"
echo altering table ipt_income_auto_check
mysql.exe -u root -e "alter table hos.ipt_income_auto_check engine = innodb"
echo altering table ipt_labour
mysql.exe -u root -e "alter table hos.ipt_labour engine = innodb"
echo altering table ipt_labour_child
mysql.exe -u root -e "alter table hos.ipt_labour_child engine = innodb"
echo altering table ipt_labour_child_med
mysql.exe -u root -e "alter table hos.ipt_labour_child_med engine = innodb"
echo altering table ipt_labour_lab
mysql.exe -u root -e