เพิ่มเติมเยอะเมหือนกันครับ
System Message
Safe alter table start for table labor command ADD `placenta_bps` double(15,3) NULL
Install Trigger on labor
Clone table labor -> tmp_labor
Execute command ADD `placenta_bps` double(15,3) NULL
Enabling keys
Synchronize table labor
Synchronize row data done.
Rename table tmp_labor --> labor
Safe alter table done.
Safe alter table start for table labor command ADD `placenta_bpd` double(15,3) NULL
Install Trigger on labor
Clone table labor -> tmp_labor
Execute command ADD `placenta_bpd` double(15,3) NULL
Enabling keys
Synchronize table labor
Synchronize row data done.
Rename table tmp_labor --> labor
Safe alter table done.
Safe alter table start for table labor command ADD `labour_placenta_desc_id` int NULL
Install Trigger on labor
Clone table labor -> tmp_labor
Execute command ADD `labour_placenta_desc_id` int NULL
Enabling keys
Synchronize table labor
Synchronize row data done.
Rename table tmp_labor --> labor
Safe alter table done.
Safe alter table start for table medpay_ipd command ADD `med_real_pay_qty` int NULL
Install Trigger on medpay_ipd
Clone table medpay_ipd -> tmp_medpay_ipd
Execute command ADD `med_real_pay_qty` int NULL
Enabling keys
Synchronize table medpay_ipd
Synchronize row data done.
Rename table tmp_medpay_ipd --> medpay_ipd
Safe alter table done.
Safe alter table start for table medpay_ipd command ADD `hos_guid` varchar(38) NULL
Install Trigger on medpay_ipd
Clone table medpay_ipd -> tmp_medpay_ipd
Execute command ADD `hos_guid` varchar(38) NULL
Enabling keys
Synchronize table medpay_ipd
Synchronize row data done.
Rename table tmp_medpay_ipd --> medpay_ipd
Safe alter table done.
Safe alter table start for table person_epi command ADD `person_epi_no` varchar(20) NULL
Install Trigger on person_epi
Clone table person_epi -> tmp_person_epi
Execute command ADD `person_epi_no` varchar(20) NULL
Enabling keys
Synchronize table person_epi
Synchronize row data done.
Rename table tmp_person_epi --> person_epi
Safe alter table done.
Safe alter table start for table person_epi_vaccine command ADD `wbc_transfer_id` int NULL
Install Trigger on person_epi_vaccine
Clone table person_epi_vaccine -> tmp_person_epi_vaccine
Execute command ADD `wbc_transfer_id` int NULL
Enabling keys
Synchronize table person_epi_vaccine
Synchronize row data done.
Rename table tmp_person_epi_vaccine --> person_epi_vaccine
Safe alter table done.
Safe alter table start for table person_epi_vaccine command ADD `wbc_development_assess_id` int NULL
Install Trigger on person_epi_vaccine
Clone table person_epi_vaccine -> tmp_person_epi_vaccine
Execute command ADD `wbc_development_assess_id` int NULL
Enabling keys
Synchronize table person_epi_vaccine
Synchronize row data done.
Rename table tmp_person_epi_vaccine --> person_epi_vaccine
Safe alter table done.
Safe alter table start for table person_epi_vaccine_list command ADD `vaccine_lotno` varchar(50) NULL
Install Trigger on person_epi_vaccine_list
Clone table person_epi_vaccine_list -> tmp_person_epi_vaccine_list
Execute command ADD `vaccine_lotno` varchar(50) NULL
Enabling keys
Synchronize table person_epi_vaccine_list
Synchronize row data done.
Rename table tmp_person_epi_vaccine_list --> person_epi_vaccine_list
Safe alter table done.
Safe alter table start for table person_epi_vaccine_list command ADD `vaccine_expire_date` date NULL
Install Trigger on person_epi_vaccine_list
Clone table person_epi_vaccine_list -> tmp_person_epi_vaccine_list
Execute command ADD `vaccine_expire_date` date NULL
Enabling keys
Synchronize table person_epi_vaccine_list
Synchronize row data done.
Rename table tmp_person_epi_vaccine_list --> person_epi_vaccine_list
Safe alter table done.
Table al2dc Has No primary key !!!
Table al2mdc Has No primary key !!!
Table allergy_list Has No primary key !!!
Modify Column allergy_list_name varchar(150) on allergy_list to Primary Key
Table anc_birthcontrol Has No primary key !!!
Table anc_birthcontrol_history Has No primary key !!!
Table anc_delivery Has No primary key !!!
Table anc_family_history Has No primary key !!!
Table anc_ill_history Has No primary key !!!
Table anc_midwife Has No primary key !!!
Table anc_preg_history Has No primary key !!!
Table appserver Has No primary key !!!
Table baby_development_status Has No primary key !!!
Table baby_growth Has No primary key !!!
Table backuplist Has No primary key !!!
Table backupx Has No primary key !!!
Table backupx1 Has No primary key !!!
Table billrece Has No primary key !!!
Table clinic_auto_lab Has No primary key !!!
Table clinic_cormobidity Has No primary key !!!
Table clinic_cormobidity_diabete Has No primary key !!!
Table clinic_cormobidity_list Has No primary key !!!
Table clinic_dm_member Has No primary key !!!
Table clinic_dm_refer_type Has No primary key !!!
Table clinic_persist_icd Has No primary key !!!
Table clinic_profile Has No primary key !!!
Table code506 Has No primary key !!!
Table comdep Has No primary key !!!
Table ct2ax Has No primary key !!!
Table ct2bimdc Has No primary key !!!
Table ct2ccexc Has No primary key !!!
Table ct2icd10 Has No primary key !!!
Table ct2mdcpr Has No primary key !!!
Table ct2mscc Has No primary key !!!
Table ct2pcom Has No primary key !!!
Table ct2proc Has No primary key !!!
Table ct2rw Has No primary key !!!
Table ct2sh Has No primary key !!!
Table cupsmoney Has No primary key !!!
Table cupsname Has No primary key !!!
Table data_system Has No primary key !!!
Table debtor Has No primary key !!!
Table debtor_dt Has No primary key !!!
Table dentop Has No primary key !!!
Table detail_account Has No primary key !!!
Table devnote Has No primary key !!!
Table doctor_keyword Has No primary key !!!
Table doctor_position_std Has No primary key !!!
Modify Column doctor_position_std_id int on doctor_position_std to Primary Key
Table doctorptotlist Has No primary key !!!
Table doctorscreen Has No primary key !!!
Table drgcc Has No primary key !!!
Table drgdxmain Has No primary key !!!
Table drgicd10 Has No primary key !!!
Table drgmdc Has No primary key !!!
Table drgnoncc Has No primary key !!!
Table drgopadd Has No primary key !!!
Table drgopmain Has No primary key !!!
Table drgoutput Has No primary key !!!
Table drgprocedure Has No primary key !!!
Table drgrw Has No primary key !!!
Table drug_group_check Has No primary key !!!
Table drug_user_check Has No primary key !!!
Table drugalias Has No primary key !!!
Table drugbarcode Has No primary key !!!
Table drugbdgtype Has No primary key !!!
Table drugcom Has No primary key !!!
Table drugdepartment Has No primary key !!!
Table drugessential Has No primary key !!!
Table druggpo Has No primary key !!!
Table drugitems_inc Has No primary key !!!
Table drugitems_picture Has No primary key !!!
Table drugjoin Has No primary key !!!
Table drugminp Has No primary key !!!
Table drugminpdt Has No primary key !!!
Table drugminptype Has No primary key !!!
Table drugorderplan Has No primary key !!!
Table drugpaylist Has No primary key !!!
Table drugpayref Has No primary key !!!
Table drugphmtype Has No primary key !!!
Table drugpotype Has No primary key !!!
Table drugptype Has No primary key !!!
Table drugrecipient Has No primary key !!!
Table drugrequestdetail Has No primary key !!!
Table drugrequestsummary Has No primary key !!!
Table drugstickeridr Has No primary key !!!
Table drugstock Has No primary key !!!
Table drugstockperson Has No primary key !!!
Table drugstockpersontype Has No primary key !!!
Table drugstockpropose Has No primary key !!!
Table drugstockproposedetail Has No primary key !!!
Table drugstockproposeorder Has No primary key !!!
Table drugstockproposeperson Has No primary key !!!
Table drugstore_detail Has No primary key !!!
Table drugstore_head Has No primary key !!!
Table drugstrength Has No primary key !!!
Table drugsupport Has No primary key !!!
Table drugtempreorder Has No primary key !!!
Table drugusage_default Has No primary key !!!
Table dtacthistory Has No primary key !!!
Table dtapp Has No primary key !!!
Table dtdn Has No primary key !!!
Table dtmain_ipd Has No primary key !!!
Table dtmain_save Has No primary key !!!
Table dttmrpt Has No primary key !!!
Table dxa_advice Has No primary key !!!
Table dxa_disease Has No primary key !!!
Table dxa_disease_cc Has No primary key !!!
Table dxa_disease_habit Has No primary key !!!
Table dxa_disease_physical_exam Has No primary key !!!
Table dxa_person_habit Has No primary key !!!
Table dxa_person_properties Has No primary key !!!
Table dxa_physical_exam Has No primary key !!!
Table dxa_treatment Has No primary key !!!
Table dxa_vital_sign Has No primary key !!!
Table education Has No primary key !!!
Table er_command Has No primary key !!!
Table erais Has No primary key !!!
Table eris Has No primary key !!!
Table eriscode Has No primary key !!!
Table eroprt Has No primary key !!!
Table factordm Has No primary key !!!
Table family_person Has No primary key !!!
Table ffdeath Has No primary key !!!
Table ffhealthcare Has No primary key !!!
Table ffmember Has No primary key !!!
Table finance_check Has No primary key !!!
Table fpapp Has No primary key !!!
Table fpmain Has No primary key !!!
Table fpspclty Has No primary key !!!
Table gpsccode Has No primary key !!!
Table hinso1 Has No primary key !!!
Table hipdatachw Has No primary key !!!
Table hismember Has No primary key !!!
Table icd10help Has No primary key !!!
Table inc_opd_print Has No primary key !!!
Table infant_dchstts Has No primary key !!!
Modify Column dchstts varchar(2) on infant_dchstts to Primary Key
Table inj_demo Has No primary key !!!
Table inj_er Has No primary key !!!
Table inj_injury Has No primary key !!!
Table inj_refer Has No primary key !!!
Table injury Has No primary key !!!
Table intraweb Has No primary key !!!
Table ipt_income_auto_charge Has No primary key !!!
Table ipt_income_auto_check Has No primary key !!!
Table ipt_income_auto_template Has No primary key !!!
Table ipt_nutrition Has No primary key !!!
Table ipt_nutrition_order Has No primary key !!!
Table ipt_pregnancy_deliver_type Has No primary key !!!
Table iptbedmove Has No primary key !!!
Table iptdrugorder Has No primary key !!!
Table iptoprt Has No primary key !!!
Table karaoke Has No primary key !!!
Table kkpopdb Has No primary key !!!
Table kskbackuprule Has No primary key !!!
Table kskdocument Has No primary key !!!
Table lab_routine_result Has No primary key !!!
Table labour_placenta_desc Has No primary key !!!
Modify Column labour_placenta_desc_id int on labour_placenta_desc to Primary Key
Table medplan Has No primary key !!!
Table moo_home_image Has No primary key !!!
Table moo_home_water Has No primary key !!!
Table name506_form_image Has No primary key !!!
Table naranjo_algorithm Has No primary key !!!
Modify Column naranjo_algorithm_id int on naranjo_algorithm to Primary Key
Table naranjo_check Has No primary key !!!
Modify Column naranjo_check_id int on naranjo_check to Primary Key
Table naranjo_result Has No primary key !!!
Modify Column naranjo_result_id int on naranjo_result to Primary Key
Table ncr_doctor Has No primary key !!!
Table ncr_patient Has No primary key !!!
Table ncr_patient2 Has No primary key !!!
Table ncr_patnew Has No primary key !!!
Table ncr_pnhn Has No primary key !!!
Table ncr_stock1 Has No primary key !!!
Table ncr_table2 Has No primary key !!!
Table ndrugdurable Has No primary key !!!
Table ndruggroup Has No primary key !!!
Table ndrugitems Has No primary key !!!
Table ndrugminp Has No primary key !!!
Table ndrugminpdt Has No primary key !!!
Table ndrugpaylist Has No primary key !!!
Table ndrugpayref Has No primary key !!!
Table ndrugstock Has No primary key !!!
Table ndrugtempreorder Has No primary key !!!
Table oldpttypeno Has No primary key !!!
Table opd_allergy_naranjo Has No primary key !!!
Modify Column opd_allergy_naranjo_id int on opd_allergy_naranjo to Primary Key
Table opd_ill_history Has No primary key !!!
Table opdnurse Has No primary key !!!
Table opdoprt Has No primary key !!!
Table opdquickccscreen Has No primary key !!!
Table opdscreen_bp Has No primary key !!!
Table operation_image Has No primary key !!!
Modify Column operation_image_id int on operation_image to Primary Key
Table operation_recovery_room_problem Has No primary key !!!
Modify Column operation_recovery_room_problem_id int on operation_recovery_room_problem to Primary Key
Table opi_dispense Has No primary key !!!
Modify Column opi_dispense_id int on opi_dispense to Primary Key
Table opi_dose_usage_unit Has No primary key !!!
Modify Column opi_dose_usage_unit_id int on opi_dose_usage_unit to Primary Key
Table opi_frequency_code Has No primary key !!!
Modify Column frequency_code varchar(10) on opi_frequency_code to Primary Key
Table opi_time_code Has No primary key !!!
Modify Column time_code varchar(10) on opi_time_code to Primary Key
Table opi_usage_code Has No primary key !!!
Modify Column usage_code varchar(10) on opi_usage_code to Primary Key
Table opi_usage_unit_code Has No primary key !!!
Modify Column usage_unit_code varchar(10) on opi_usage_unit_code to Primary Key
Table opitemreceh Has No primary key !!!
Table ovaccident Has No primary key !!!
Table patient_ipd_scan Has No primary key !!!
Table patient_nc Has No primary key !!!
Table patient_search Has No primary key !!!
Table patient_special_prop Has No primary key !!!
Modify Column patient_special_prop_id int on patient_special_prop to Primary Key
Table pcu_child Has No primary key !!!
Table pcu_node Has No primary key !!!
Table pcu_replicate_cfg Has No primary key !!!
Table pcu_replicate_log Has No primary key !!!
Table person_wbc_vaccine_abnormal Has No primary key !!!
Modify Column person_wbc_vaccine_abnormal_id int on person_wbc_vaccine_abnormal to Primary Key
Table personcardtime Has No primary key !!!
Table personid Has No primary key !!!
Table personsalary Has No primary key !!!
Table physic_group_doctor Has No primary key !!!
Modify Column physic_group_doctor_id int on physic_group_doctor to Primary Key
Table presetdosageregimen Has No primary key !!!
Table ptdepart Has No primary key !!!
Table pteroprt Has No primary key !!!
Table qno Has No primary key !!!
Table replicate_cfg Has No primary key !!!
Table replicate_err Has No primary key !!!
Table replicate_lock Has No primary key !!!
Table replicate_slave Has No primary key !!!
Table replicate_trigger_service Has No primary key !!!
Table rfrcs0 Has No primary key !!!
Table rpt_accident_code Has No primary key !!!
Table rpt_accident_name Has No primary key !!!
Table rtfreport Has No primary key !!!
Table sccredit Has No primary key !!!
Table scguarantorcut Has No primary key !!!
Table sclendmoney Has No primary key !!!
Table scloan Has No primary key !!!
Table scloandt Has No primary key !!!
Table scmember Has No primary key !!!
Table scpay Has No primary key !!!
Table screen_doctor Has No primary key !!!
Table scshare Has No primary key !!!
Table scsystem Has No primary key !!!
Table sigtoidr Has No primary key !!!
Table special_prop_type Has No primary key !!!
Modify Column special_prop_type_id int on special_prop_type to Primary Key
Table stat_clinic Has No primary key !!!
Table stockconfig Has No primary key !!!
Table table1 Has No primary key !!!
Table temp412a061 Has No primary key !!!
Table temp412a071 Has No primary key !!!
Table temp412a091 Has No primary key !!!
Table temp412b031 Has No primary key !!!
Table temp412b051 Has No primary key !!!
Table temp412b091 Has No primary key !!!
Table temp421d071 Has No primary key !!!
Table tempball1 Has No primary key !!!
Table tempblue_command1 Has No primary key !!!
Table tempcom41 Has No primary key !!!
Table tempdental1 Has No primary key !!!
Table tempmanoi_xp1 Has No primary key !!!
Table tempmanoi_xp2 Has No primary key !!!
Table tempreport Has No primary key !!!
Table tempthabo_151 Has No primary key !!!
Table test Has No primary key !!!
Table universal_detail_subvalue Has No primary key !!!
Modify Column universal_detail_subvalue_id int on universal_detail_subvalue to Primary Key
Table universal_form_department Has No primary key !!!
Modify Column universal_form_department_id int on universal_form_department to Primary Key
Table universal_item_value_list Has No primary key !!!
Modify Column universal_item_value_list_id int on universal_item_value_list to Primary Key
Table validitaken Has No primary key !!!
Table wbc_transfer Has No primary key !!!
Modify Column wbc_transfer_id int on wbc_transfer to Primary Key
Table web_board Has No primary key !!!
Table web_conf Has No primary key !!!
Table web_session Has No primary key !!!
Table web_var Has No primary key !!!
Table xray_items_doctor Has No primary key !!!
Modify Column xray_items_doctor_id int on xray_items_doctor to Primary Key
Table xray_report_film Has No primary key !!!
Table xrayexam Has No primary key !!!
Drop duplicate primary key unique index datadictionary.ix_fieldname_tablename_unique ["fieldname","tablename"]
Field constraint error replicate_slave.database IS NULL <should not null>
Set column not null varchar(20)
Table : replicate_slave = Should be host,database
Create table primary key constraint [host,database]
Wrong unique index universal_item.ix_universal_item_name [universal_item_name]
Recreate unique index village_student.ix_person_id_unique_unique_unique_unique_unique_unique_unique [person_id]
Safe alter table start for table medpay_ipd command add index ix_hos_guid (hos_guid)
Install Trigger on medpay_ipd
Clone table medpay_ipd -> tmp_medpay_ipd
Execute command add index ix_hos_guid (hos_guid)
Enabling keys
Synchronize table medpay_ipd
Synchronize row data done.
Rename table tmp_medpay_ipd --> medpay_ipd
Safe alter table done.
หัวข้อ: HOSxP 3.52.2.19b (อ่าน 11619 ครั้ง)