ลองทดสอบเพิ่ม กันนะขอรับ
http://hosxp.net/bms/HOSxP_Upgrade_3.56.4.1b.exe
---------------------------------------------------------------------------
http://cloud1.hosxp.net/$
System Message
Drop duplicate primary key unique index datadictionary.ix_fieldname_tablename_unique ["fieldname","tablename"]
Recreate unique index drugitems_register_unique.ix_unique_8337_unique [std_code]
Safe alter table start for table drugitems_register_unique command drop index `ix_unique_8337_unique`
Install Trigger on drugitems_register_unique
Clone table drugitems_register_unique -> tmp_drugitems_register_unique
Execute command drop index `ix_unique_8337_unique`
Enabling keys
Synchronize table drugitems_register_unique
Synchronize row data done.
Rename table tmp_drugitems_register_unique --> drugitems_register_unique
Safe alter table done.
Safe alter table start for table drugitems_register_unique command add unique index ix_unique_8337_unique_unique (std_code)
Install Trigger on drugitems_register_unique
Clone table drugitems_register_unique -> tmp_drugitems_register_unique
Execute command add unique index ix_unique_8337_unique_unique (std_code)
Enabling keys
Synchronize table drugitems_register_unique
Synchronize row data done.
Rename table tmp_drugitems_register_unique --> drugitems_register_unique
Safe alter table done.
Recreate unique index dw_emr_cache.ix_unique_1743 [dw_emr_key]
Drop duplicate primary key unique index health_med_operation_item_organ.ix_unique ["health_med_operation_item_organ_id","health_med_operation_item_id","health_med_operation_type_id"]
Recreate unique index provis_pname.ix_shortname [provis_pname_short_name]
Safe alter table start for table person_dmht_screen_summary command add unique index ix_person_dmht_screen_summary_unique (person_id,bdg_year)
Install Trigger on person_dmht_screen_summary
Clone table person_dmht_screen_summary -> tmp_person_dmht_screen_summary
Execute command add unique index ix_person_dmht_screen_summary_unique (person_id,bdg_year)
SQL Error: Duplicate entry '5775-2553' for key 'ix_person_dmht_screen_summary_unique'
Enabling keys
Synchronize table person_dmht_screen_summary
Synchronize row data done.
Rename table tmp_person_dmht_screen_summary --> person_dmht_screen_summary
Safe alter table done.
SQL Error: Column 'ovst_icf_type_name' cannot be null
select * from ovst_icf_level_type limit 0
SQL Error: Column 'ovst_icf_type_name' cannot be null
select * from ovst_icf_level_type limit 0
SQL Error: Column 'ovst_icf_type_name' cannot be null
select * from ovst_icf_level_type limit 0
SQL Error: Column 'ovst_icf_type_name' cannot be null
select * from ovst_icf_level_type limit 0
SQL Error: Column 'ovst_icf_type_name' cannot be null
select * from ovst_icf_level_type limit 0
SQL Error: Column 'ovst_icf_type_name' cannot be null
select * from ovst_icf_level_type limit 0
SQL Error: Column 'ovst_icf_type_name' cannot be null
select * from ovst_icf_level_type limit 0
หัวข้อ: HOSxP 3.56.4.1 (อ่าน 28083 ครั้ง)