BMS-HOSxP Community
HOSxP => ยินดีต้อนรับ => ข้อความที่เริ่มโดย: udomchok ที่ มกราคม 18, 2009, 22:46:09 PM
-
http://jaist.dl.sourceforge.net/sourceforge/hosxp/HOSxP_Upgrade_3.52.1.8.exe
-
คุณพี่ อ.udomchok ครับ ที่ อ. ลิงค์ไปมันเป็น v 3.52.1.8 ไม่ใช่ v3.52.1.18 ครับ พักผ่อนบางนะครับ คุณพี่อ.udomchok รักษาสุขภาพด้วย
-
ทำเอาชาวบ้านตื้นเต้นจนขนพองสยองเกล้าเลยนะ
-
ลุกขึ้นมาเจอตอนตี 1 นี่ถ้าเป็น 3.52.1.18 จริงๆผมคงไม่ได้นอนแน่ๆคืนนี้ พี่ udomchok แกคงรอ 3.52.1.18 มาทั้งวันและอาจทั้งคืนนี้ด้วย :D :D :D
-
แป่ว...แป่ว...แป่ว... หน้าแตกเลยเรา...เฮ้อ สงสัยต้องไปนอนจริง ๆ ละ
-
มาแล้วครับ ของจริงเพิ่งเจอเมื่อเช้านี้เอง ;D ;D ;D ฝากพี่ udomchok ทดสอบด้วยนะครับ
-
Error หน้าจอบันทึกส่งตรวจนะครับ
-
Error หน้าจอบันทึกส่งตรวจนะครับ
หลังจากอัพเกรด เวอร์ชั่น แล้ว อัพเกรด stucture หรือยังครับ ถึงขึ้น error
ถ้าอัพเกรด stucture ไม่น่ามีนะครับ จะลองทดสอบให้ ;) ;) :D :D
แป่ว...แป่ว...แป่ว... หน้าแตกเลยเรา...เฮ้อ สงสัยต้องไปนอนจริง ๆ ละ
555 พี่โก้นะ พี่โก้......... ;) :D ;D :D
-
หลังจากอัพเกรด เวอร์ชั่น แล้ว อัพเกรด stucture หรือยังครับ ถึงขึ้น error
ถ้าอัพเกรด stucture ไม่น่ามีนะครับ จะลองทดสอบให้
;D ;D ;D ปัญหาอยู่ตรงนี้แหละครับ หรือไปใช้กับฐานข้อมูลที่เวอร์ชั่นต่ำกว่าก็จะขึ้น Error นี้ครับ เพราะ MySQL มันไม่พบตารางนี้ในเวอร์ชั่นที่ต่ำกว่าครับ ;D ;D ;D
-
ฝาก อ.โก้ ให้ทดสอบด้วยคน
-
Upgrade MySQL Done.
End at 19/01/2552 09:30:55
Checking Serial Number
Import data to women_birth_control
Import data to rpt_504_code
Import data to pcu_drugitems
Import data to paidst
Import data to operation_status
Import data to income_report2
Import data to income_group
Import data to hosxp_error_message
Import data to entity_code
Refresh base data
Update s_drugitems
Checking full_name in thaiaddress
Check income.drg_group
Check System Report
Check ICD9CM1
Check patient prename
Check Invalid Data
alter ignore table labour_sulture_type add unique index ix_sulture_type_name (sulture_type_name)
alter ignore table labour_placenta_type add unique index ix_placenta_type_name (placenta_type_name)
alter ignore table labour_perineum_type add unique index ix_perineum_type_name (perineum_type_name)
alter ignore table datadictionary add unique index ix_fieldname_tablename_unique (fieldname,tablename)
Index not found : labour_sulture_type.sulture_type_name (sulture_type_name)
Index not found : labour_placenta_type.placenta_type_name (placenta_type_name)
Index not found : labour_perineum_type.perineum_type_name (perineum_type_name)
Index not found : datadictionary.ix_fieldname_tablename_unique (fieldname,tablename)
xrayxn.xn ("xn") unique = N
xrayxn.regdate ("regdate") unique = N
xrayxn.hn ("hn") unique = N
xray_type_film.xray_type ("xray_type") unique = N
xray_type.ix_xray_items_code ("xray_items_code") unique = N
xray_type.ix_name ("name") unique = N
xray_time_type.ix_xray_time_type_name ("xray_time_type_name") unique = Y
xray_template.template_name ("template_name") unique = Y
xray_status.ix_xray_status_name ("xray_status_name") unique = Y
xray_side.ix_name ("name") unique = N
xray_service_charge.ix_opi_guid ("opi_guid") unique = Y
xray_room.ix_name ("name") unique = N
xray_report_type.xn ("xn") unique = N
xray_report_film.xn ("xn") unique = N
xray_report.ix_opiguid ("opitemrece_guid") unique = N
xray_report.ix_ix_vn ("vn") unique = N
xray_report.ix_ix_request_date ("request_date") unique = N
xray_report.ix_ix_report_date ("report_date") unique = N
xray_report.ix_ix_hn ("hn") unique = N
xray_report.ix_ix_an ("an") unique = N
xray_rent_type.ix_xray_rent_type_name ("xray_rent_type_name") unique = Y
xray_rent_status.ix_xray_rent_status_name ("xray_rent_status_name") unique = Y
xray_rent_department.ix_xray_rent_department_name ("xray_rent_department_name") unique = Y
xray_rent.ix_xn ("xn") unique = N
xray_rent.ix_rent_date ("rent_date") unique = N
xray_rent.ix_hn ("hn") unique = N
xray_rent.ix_checkin ("checkin") unique = N
xray_pt_status.ix_name ("name") unique = N
xray_priority.ix_name ("priority_name") unique = N
xray_pack.ix_xn ("xray_report_xn") unique = N
xray_order.xray_order_number ("xray_order_number") unique = N
xray_keeper.ix_xray_keeper_name ("xray_keeper_name") unique = Y
xray_items.xray_items_name ("xray_items_name") unique = N
xray_head.ix_order_date ("order_date") unique = N
xray_head.ix_confirm_report ("confirm_report") unique = N
xray_head.ix_order_date_time ("order_date_time") unique = N
xray_head.vn ("vn") unique = N
xray_head.hn ("hn") unique = N
xray_head.ix_xray_order_number_unique ("xray_order_number") unique = Y
xray_film_staff.ix_xn ("xn") unique = N
xray_film.ix_filmname ("film_name") unique = N
xray_contrast_media_use.ix_xn ("xn") unique = N
xray_contrast_media.ix_xray_contrast_media_name ("xray_contrast_media_name") unique = Y
women_vaccine.ix_women_vaccine_name ("women_vaccine_name") unique = Y
women_vaccine.ix_vaccine_code ("vaccine_code") unique = Y
women_service.ix_women_service_name ("women_service_name") unique = Y
women_birth_control.ix_women_birth_control_name ("women_birth_control_name") unique = Y
web_var.name_unique ("name") unique = Y
web_session.sbrand_unique ("sbrand") unique = Y
web_board.user ("user") unique = N
web_board.subject ("subject") unique = N
web_board.master_pn ("master_pn") unique = N
web_board.pn_unique ("pn") unique = Y
wbc_vaccine.ix_export_vaccine_code ("export_vaccine_code") unique = N
wbc_vaccine.ix_age_min ("age_min") unique = N
wbc_vaccine.ix_wbc_vaccine_name ("wbc_vaccine_name") unique = Y
wbc_service.ix_wbc_service_name ("wbc_service_name") unique = Y
wbc_location_type.ix_wbc_location_type_name ("wbc_location_type_name") unique = Y
ward.name ("name") unique = N
vn_stat.ym ("ym") unique = N
vn_stat.vstdate ("vstdate") unique = N
vn_stat.pttype ("pttype") unique = N
vn_stat.pcode ("pcode") unique = N
vn_stat.cid ("cid") unique = N
vn_stat.hospsub ("hospsub") unique = N
vn_stat.hospmain ("hospmain") unique = N
vn_stat.hn ("hn") unique = N
vn_lock.lock_date_time ("lock_date_time") unique = N
vn_lock.lock_computer ("lock_computer") unique = N
vital_sign_data.ix_vn ("vn") unique = N
vital_sign_data.ix_hn ("hn") unique = N
vital_sign_data.ix_an ("an") unique = N
visit_type.ix_visit_type_name ("visit_type_name") unique = Y
visit_pttype_change.ix_vn ("vn") unique = N
visit_pttype.vn ("vn") unique = N
visit_pttype.pttype ("pttype") unique = N
visit_plan.vn ("vn") unique = N
visit_pay_plan.ix_hn_item_expire ("hn","item_expire") unique = N
visit_pay_plan.ix_hn ("hn") unique = N
visit_note_department.vn ("vn") unique = N
visit_note.ix_doctor ("doctor") unique = N
visit_note.ix_dep_name ("dep_name") unique = N
village_temple_type.ix_village_temple_type_name ("village_temple_type_name") unique = Y
village_temple.ix_village_id ("village_id") unique = N
village_survey_item.ix_item_group ("item_group") unique = N
village_survey_item.ix_unique ("village_survey_item_name") unique = Y
village_survey_detail.ix_village_si ("village_survey_item_id") unique = N
village_survey_detail.ix_village_id ("village_id") unique = N
village_student_vaccine_list.ix_village_student_vaccine_id ("village_student_vaccine_id") unique = N
village_student_vaccine.ix_village_student_id ("village_student_id") unique = N
village_student_screen.ix_village_student_id ("village_student_id") unique = N
village_student.ix_village_school_id ("village_school_id") unique = N
village_student.ix_person_id_unique_unique_unique_unique_unique_unique ("person_id") unique = Y
village_store_type.ix_village_store_type_name ("village_store_type_name") unique = Y
village_store_picture.ix_village_store_id ("village_store_id") unique = N
village_store.ix_village_id ("village_id") unique = N
village_school_class.ix_village_school_class_name ("village_school_class_name") unique = Y
village_school.ix_village_id ("village_id") unique = N
village_priest.ix_village_temple_id ("village_temple_id") unique = N
village_priest.ix_unique ("person_id") unique = Y
village_organization_type.ix_village_organization_type_name ("village_organization_type_name") unique = Y
village_organization_member_service.ix_mid ("village_organization_mid") unique = N
village_organization_member.ix_idx ("village_organization_id") unique = N
village_organization_member.ix_id ("person_id") unique = N
village_organization.ix_village_id ("village_id") unique = N
village_club_member.ix_village_club_id ("village_club_id") unique = N
village_club_member.ix_person_id ("person_id") unique = N
village_club.ix_village_id ("village_id") unique = N
village.ix_village_code ("village_code") unique = N
village.ix_hos_guid ("hos_guid") unique = N
vagina_test_place.ix_vagina_test_place_name ("vagina_test_place_name") unique = Y
vagina_cancer_test.ix_vagina_cancer_test_name ("vagina_cancer_test_name") unique = Y
vagina_cancer_result.ix_vagina_cancer_result_name ("vagina_cancer_result_name") unique = Y
vaccine_lookup.ix_unique ("vaccine_code","lookup_value") unique = Y
vaccine_combination.ix_vaccine_code ("vaccine_code") unique = N
vaccine_combination.ix_unique ("vaccine_code","vaccine_combine_code") unique = Y
universal_item_class.ix_universal_item_class_name ("universal_item_class_name") unique = Y
universal_item.ix_universal_item_name ("universal_item_name") unique = Y
universal_form_design.ix_universal_form_id ("universal_form_id") unique = N
universal_form.ix_universal_form_name ("universal_form_name") unique = Y
universal_detail.ix_universal_head_id ("universal_head_id") unique = N
tip_trick.tip_type ("tip_type") unique = N
tip_trick.tip_id ("tip_id") unique = N
thalassaemia_result.ix_thalassaemia_result_name ("thalassaemia_result_name") unique = Y
thaiaddress_region.region_code ("region_code") unique = N
thaiaddress.tmbpart ("tmbpart") unique = N
thaiaddress.name ("name") unique = N
thaiaddress.codetype ("codetype") unique = N
thaiaddress.chwpart ("chwpart") unique = N
thaiaddress.amppart ("amppart") unique = N
tempreport.reportname ("reportname") unique = N
tempreport.name ("name") unique = N
tempreport.id ("id") unique = N
tempreport.date1 ("date1") unique = N
tempmanoi_xp2.hn_unique ("hn") unique = Y
tempmanoi_xp1.pttypeno ("pttypeno") unique = N
tempmanoi_xp1.cid ("cid") unique = N
tempmanoi_xp1.ix_pttypeno_pttype_unique ("pttypeno","pttype","hn") unique = Y
tempmanoi_xp1.hn_pttypeno_pttype_unique ("hn","pttypeno","pttype") unique = Y
tempjb_2471.ix_tempjb_2471_unique ("vn","code") unique = Y
tempjb1861.ix_tempjb1861_unique ("vn","code") unique = Y
tempinfor1.ix_tempinfor1_unique ("vn","code") unique = Y
tempdental1.ix_an_code_unique ("an","code") unique = Y
tempcom41.vn_code_unique ("vn","code") unique = Y
tempball1.vn_code_unique ("vn","code") unique = Y
temp421d071.vn_code_unique ("vn","code") unique = Y
temp412b091.vn_code_unique ("vn","code") unique = Y
temp412b051.an_code_unique ("an","code") unique = Y
temp412b031.vn_code_unique ("vn","code") unique = Y
temp412a091.vn_code_unique ("vn","code") unique = Y
temp412a071.vn_code_unique ("vn","code") unique = Y
temp412a061.vn_code_unique ("vn","code") unique = Y
sys_app_script.script_name ("script_name") unique = N
surveil_member_log.ix_sv_guid ("sv_guid") unique = Y
surveil_member.ix_sv_guid ("sv_guid") unique = N
surveil_member.vn ("vn") unique = N
surveil_member.pdx ("pdx") unique = N
student_vaccine_place.ix_student_vaccine_place_name ("student_vaccine_place_name") unique = Y
student_vaccine.ix_export_vaccine_code ("export_vaccine_code") unique = N
student_vaccine.ix_vaccine_code ("vaccine_code") unique = Y
student_vaccine.ix_student_vaccine_name ("student_vaccine_name") unique = Y
student_thalassemia_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_thalassemia_check.ix_student_thalassemia_check_name ("student_thalassemia_check_name") unique = Y
student_self_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_self_check.ix_student_self_check_name ("student_self_check_name") unique = Y
student_lice_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_lice_check.ix_student_lice_check_name ("student_lice_check_name") unique = Y
student_eye_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_eye_check.ix_student_eye_check_name ("student_eye_check_name") unique = Y
student_ear_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_ear_check.ix_student_ear_check_name ("student_ear_check_name") unique = Y
student_dental_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_dental_check.ix_student_dental_check_name ("student_dental_check_name") unique = Y
student_anemia_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_anemia_check.ix_student_anemia_check_name ("student_anemia_check_name") unique = Y
stock_warehouse_adj_detail.ix_stock_warehouse_adj_detail ("stock_warehouse_adj_head_id") unique = N
stock_supplier_item.supplier_id ("supplier_id") unique = N
stock_supplier_item.item_id ("item_id") unique = N
stock_supplier_agent.supplier_id ("supplier_id") unique = N
stock_supplier.ix_supplier_name ("supplier_name") unique = N
stock_supplier.ix_company_type ("company_type") unique = N
stock_supplier.ix_company_code ("company_code") unique = N
stock_subdraw_type.ix_stock_subdraw_type_name ("stock_subdraw_type_name") unique = Y
stock_subdraw_list.ix_item_id ("item_id") unique = N
stock_return_list.ix_stock_return_item_id ("stock_return_item_id") unique = N
stock_return_list.ix_stock_draw_list_id ("stock_draw_list_id") unique = N
stock_return_list.ix_item_list_id ("item_list_id") unique = N
stock_return_item.ix_stock_return_id ("stock_return_id") unique = N
stock_return_cutpay_list.ix_stock_draw_list_id ("stock_cutpay_list_id") unique = N
stock_return_cutpay_list.ix_item_list_id ("item_list_id") unique = N
stock_po_item_type.ix_stock_po_item_type_name ("stock_po_item_type_name") unique = Y
stock_po_detail.ix_stock_po_id ("stock_po_id") unique = N
stock_po_detail.ix_reference_id ("reference_id") unique = N
stock_po.ix_stock_po_date ("stock_po_date") unique = N
stock_po.ix_reference_id ("reference_id") unique = N
stock_ovst.staff ("staff") unique = N
stock_ovst.department_id ("department_id") unique = N
stock_ovst.department ("department") unique = N
stock_opitemrece_list.ix_vn ("vn") unique = N
stock_opitemrece_list.ix_hos_guid ("hos_guid") unique = N
stock_opitemrece_err.hos_guid ("hos_guid") unique = N
stock_opitemrece.ix_vn ("vn") unique = N
stock_opitemrece.ix_ix_stock_draw_list_id ("stock_draw_list_id") unique = N
stock_opitemrece.hos_guid ("hos_guid") unique = N
stock_manual_item.ix_stock_manual_id ("stock_manual_id") unique = N
stock_manual_detail.ix_reference_id ("reference_id") unique = N
stock_manual_detail.ix_stock_manual_id ("stock_manual_id") unique = N
stock_manual_detail.ix_stock_draw_list_id ("stock_draw_list_id") unique = N
stock_item_warehouse.warehouse_id ("warehouse_id") unique = N
stock_item_warehouse.item_id ("item_id") unique = N
stock_item_unit.ix_unique ("item_id","item_unit_name") unique = Y
stock_item_standard.ix_name ("name") unique = N
stock_item_regist.ix_trade_name ("trade_name") unique = N
stock_item_regist.ix_standard_code ("standard_code") unique = N
stock_item_regist.ix_company_code ("company_code") unique = N
stock_item_list.ix_stock_po_id ("stock_po_id") unique = N
stock_item_list.ix_ix_item_id ("item_id") unique = N
stock_item_list.ix_ix_deliver_detail_id ("stock_deliver_detail_id") unique = N
stock_item_history.ix_snapshot_period ("snapshot_period") unique = N
stock_item_history.ix_item_id ("item_id") unique = N
stock_item_drugitems.item_id ("item_id") unique = N
stock_item_drugitems.icode ("icode") unique = N
stock_item_cost_type.ix_stock_item_cost_type_name ("stock_item_cost_type_name") unique = Y
stock_item.ix_stock_class ("stock_class_id") unique = N
stock_item.ix_costtype ("stock_item_cost_type_id") unique = N
stock_item.ix_barcode_number ("barcode_number") unique = N
stock_item.ix_regno ("standard_code") unique = N
stock_item.ix_item_name ("item_name") unique = N
stock_group_standard.ix_name ("name") unique = N
stock_draw_list.ix_stock_draw_left_qty ("stock_draw_left_qty") unique = N
stock_draw_list.ix_stock_draw_item_id ("stock_draw_item_id") unique = N
stock_draw_list.ix_stock_draw_id ("stock_draw_id") unique = N
stock_draw_list.ix_confirm_empty ("confirm_empty") unique = N
stock_draw_list.ix_ix_item_list_id ("item_list_id") unique = N
stock_draw_item.ix_stock_draw_id ("stock_draw_id") unique = N
stock_draw.ix_stock_sub_draw_id ("stock_subdraw_id") unique = N
stock_draw.ix_stock_draw_date ("stock_draw_date") unique = N
stock_department_route.ix_route_to_id ("route_to_department_id") unique = N
stock_department_route.ix_icode ("icode") unique = N
stock_department_route.ix_department_id ("department_id") unique = N
stock_department_route.ix_unique ("department_id","icode") unique = Y
stock_department_item_level.ix_item_id ("item_id") unique = N
stock_department_item_level.ix_department_id ("item_id") unique = N
stock_department_item_level.ix_unique ("department_id","item_id") unique = Y
stock_department_item.ix_department_id ("department_id") unique = N
stock_department.ix_department_name ("department_name") unique = N
stock_deliver_detail.ix_stock_po_detail_id ("stock_po_detail_id") unique = N
stock_deliver_detail.ix_stock_deliver_id ("stock_deliver_id") unique = N
stock_deliver.ix_stock_po_id ("stock_po_id") unique = N
stock_cutpay_list.ix_stock_cutpay_item_id ("stock_cutpay_item_id") unique = N
stock_cutpay_item.ix_stock_cutpay_id ("stock_cutpay_id") unique = N
stock_cutpay.ix_stock_cutpay_date ("stock_cutpay_date") unique = N
stock_cutpay.ix_reference_id ("reference_id") unique = N
stock_cutpay.ix_cutpaytypeid ("cutpay_type_id") unique = N
stock_class.ix_stock_class_name ("stock_class_name") unique = Y
stock_card.transaction_date ("transaction_date") unique = N
stock_card.warehouse_id ("warehouse_id") unique = N
stock_card.item_id ("item_id") unique = N
stock_card.inv_no ("inv_no") unique = N
stock_card.inv_name ("inv_name") unique = N
stock_card.expire_date ("expire_date") unique = N
stock_adjust_item.ix_stock_adj_head_id ("stock_adj_head_id") unique = N
stock_adjust_head.ix_adjust_date ("adjust_date") unique = N
stock_adjust_detail.ix_stock_adjust_item_id ("stock_adjust_item_id") unique = N
stock_adjust_detail.ix_stock_draw_list_id ("stock_draw_list_id") unique = N
stat_queue.queue_type ("queue_type") unique = N
stat_queue.queue_date_time ("queue_date_time") unique = N
stat_queue.id ("id") unique = N
stat_clinic.old_clinic_unique ("old_clinic") unique = Y
sss_chronic_detail.ix_min_icd ("min_icd") unique = N
sss_chronic_detail.ix_max_icd ("max_icd") unique = N
spclty.ix_ix_spname ("spname") unique = N
spclty.name ("name") unique = N
sp_use.oldcode ("oldcode") unique = N
sp_use.user ("user") unique = N
sp_use.sp_name ("sp_name") unique = N
sp_use.name1_name3_name2 ("name1","name3","name2") unique = N
social_aid.ix_vn_unique ("vn") unique = Y
sigtoidr.sig_unique ("sig") unique = Y
service_time.vstdate ("vstdate") unique = N
service_time.rx_time_type ("rx_time_type") unique = N
service_time.hn ("hn") unique = N
service_right.pttype ("pttype") unique = N
service_right.icode ("icode") unique = N
service_pay.pttype ("pttype") unique = N
service_pay.icode ("icode") unique = N
scshare.code_unique ("code") unique = Y
screen_doctor.vn ("vn") unique = N
screen_doctor.staff ("staff") unique = N
screen_doctor.vn_staff_unique ("vn","staff") unique = Y
scpay.lnnum ("lnnum") unique = N
scmember.code_unique ("code") unique = Y
scloan.lnmonth ("lnmonth") unique = N
scloan.code ("code") unique = N
scloan.cleared ("cleared") unique = N
scloan.lnnum_unique ("lnnum") unique = Y
school_trimester.ix_school_trimester_name ("school_trimester_name") unique = Y
school_officer_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
school_officer_check.ix_school_officer_check_name ("school_officer_check_name") unique = Y
schedule_task.task_user ("task_user") unique = N
schedule_task.task_name ("task_name") unique = N
schedule_task.task_due_date ("task_due_date") unique = N
schedule_task.task_date_time ("task_date_time") unique = N
schedule_task.task_complete ("task_complete") unique = N
schedule.doctor_code ("doctor_code") unique = N
sccredit.credittype_unique ("credittype") unique = Y
sc_pg_presenation.ix_sc_pg_presentation_name ("sc_pg_presentation_name") unique = Y
sc_pg_membrane.ix_sc_pg_membrane_name ("sc_pg_membrane_name") unique = Y
sc_pg_af.ix_sc_pg_af_name ("sc_pg_af_name") unique = Y
s_drugitems.icode_unique ("icode") unique = N
s_drugitems.icode ("icode") unique = N
s_drugitems.istatus ("istatus") unique = N
s_drugitems.name_strength_units ("name","strength","units") unique = N
s_drugitems.name ("name") unique = N
s_drugitems.access_level ("access_level") unique = N
s_drugitems.ix_nsu ("name","strength","units") unique = N
s_drugitems.ix_status ("istatus") unique = N
s_drugitems.ix_access ("access_level") unique = N
s_drugitems.ix_name ("name") unique = N
s_drugitems.ix_unique ("icode") unique = N
rx_summary.ix_rx_date ("rx_date") unique = N
rx_summary.ix_icode ("icode") unique = N
rx_operator.ix_vn ("vn") unique = N
rx_operator.ix_order_date ("order_date") unique = N
rx_operator.ix_vn_login_unique ("vn","login") unique = Y
rx_doctor.ix_rxdate ("rx_date") unique = N
rx_doctor.ix_prepare_datetime ("prepare_datetime") unique = N
rx_doctor.ix_depcode ("depcode") unique = N
rx_doctor.ix_rcpt_depcode ("rcpt_depcode") unique = N
rx_doctor.ix_prepare_rx ("prepare_rx") unique = N
rx_doctor.ix_financecheckin ("finance_checkin") unique = N
rx_doctor.vn ("vn") unique = N
rx_doctor.doctor ("doctor") unique = N
roomno.an ("an") unique = N
room_status_type.ix_room_status_type_name ("room_status_type_name") unique = Y
room_reserve_type.ix_room_reserve_type_name ("room_reserve_type_name") unique = Y
room_reserve_status.ix_room_reserve_status_name ("room_reserve_status_name") unique = Y
room_reserve.room_reserve_queue ("room_reserve_queue") unique = N
room_reserve.in_date ("in_date") unique = N
room_reserve.hn ("hn") unique = N
room_reserve.call_date ("call_date") unique = N
room_reserve.an ("an") unique = N
room_reserve.an_hn_unique ("an","hn") unique = Y
room_reserve.unique ("hn","an") unique = Y
risk_report.subject ("subject") unique = N
risk_report.report_date_time ("report_date_time") unique = N
risk_report.department_id ("department_id") unique = N
rfrcs0.rfrcs_unique ("rfrcs") unique = Y
reporttemplate.db ("db") unique = N
report_sks.ix_vn ("vn") unique = N
report_sks.ix_finance_number ("finance_number") unique = N
report_access_rule.ix_username ("user_name") unique = N
report_access_rule.ix_report_name ("report_name") unique = N
report_access_log.loginname ("loginname") unique = N
report_access_log.report_name ("report_name") unique = N
report_access_log.department ("department") unique = N
report_access_log.access_date_time ("access_date_time") unique = N
replicate_trigger.ix_replicate_trigger_tablename ("table_name","pkname1","pkvalue1","sync_state") unique = N
replicate_trigger.ix_sync_state ("sync_state") unique = N
replicate_trigger.ix_order ("sync_priority","replicate_trigger_id") unique = N
replicate_log.event_id_unique ("event_id") unique = Y
replicate_err.event_id_unique ("event_id") unique = Y
replicate_cfg.server_unique ("server") unique = Y
referout_status.ix_referout_status_name ("referout_status_name") unique = Y
referout.ix_refer_date ("refer_date") unique = N
referout.ix_hospcode ("hospcode") unique = N
referin.refer_date ("refer_date") unique = N
referin.hospcode ("hospcode") unique = N
referin.hn ("hn") unique = N
refer_type.ix_refer_type_name ("refer_type_name") unique = Y
rcpt_refund.ix_an ("an") unique = N
rcpt_print_detail.ix_ix_fn_income ("finance_number","income") unique = N
rcpt_print_detail.ix_finance_number ("finance_number") unique = N
rcpt_print_detail.vn ("vn") unique = N
rcpt_print_detail.rcpno ("rcpno") unique = N
rcpt_print_detail.income ("income") unique = N
rcpt_print_detail.finance_number ("finance_number") unique = N
rcpt_print.pttype ("pttype") unique = N
rcpt_print.book_number ("book_number") unique = N
rcpt_print.bill_number ("bill_number") unique = N
rcpt_print.bill_date_time ("bill_date_time") unique = N
rcpt_print.ix_bill_date_time ("bill_date_time") unique = N
rcpt_print.ix_pttype ("pttype") unique = N
rcpt_print.ix_billnumber ("bill_number") unique = N
rcpt_print.ix_booknumber ("book_number") unique = N
rcpt_print.vn ("vn") unique = N
rcpt_print.hn ("hn") unique = N
rcpt_print.rcpno_unique ("rcpno") unique = Y
rcpt_debt_detail.ix_income ("income") unique = N
rcpt_debt_detail.ix_debt_id ("debt_id") unique = N
rcpt_debt_cancel.ix_cancel_staff ("cancel_staff") unique = N
rcpt_debt.ix_debt_date_time ("debt_date_time") unique = N
rcpt_debt.ix_ix_vn ("vn") unique = N
rcpt_debt.finance_number ("finance_number") unique = N
rcpt_debt.debt_id ("debt_id") unique = N
rcpt_current_detail.ix_rcpt_current_id ("rcpt_current_id") unique = N
rcpt_current.ix_vn ("vn") unique = N
rcpt_credit_detail.ix_credit_id ("credit_id") unique = N
rcpt_credit.ix_vn ("vn") unique = N
rcpt_credit.ix_finance_number ("finance_number") unique = N
rcpt_bill_type_detail.ix_rcpt_bill_type_id ("rcpt_bill_type_id") unique = N
rcpt_arrear_detail.ix_arrear_id ("arrear_id") unique = N
rcpt_arrear.ix_ix_vn ("vn") unique = N
rcpt_arrear.ix_ix_arrear_date ("arrear_date") unique = N
rcpt_abort.vn ("vn") unique = N
rcpt_abort.user ("user") unique = N
rcpt_abort.hn ("hn") unique = N
rcpt_abort.approve_by ("approve_by") unique = N
pttypeno.hn ("hn") unique = N
pttypehistory.hn ("hn") unique = N
pttype_package_detail.ix_package_id ("pttype_package_id") unique = N
pttype_package.ix_package_name ("package_name") unique = Y
pttype_log.staff ("staff") unique = N
pttype_log.hn ("hn") unique = N
pttype.ix_pcode ("pcode") unique = N
pttype.ix_ix_hipdata_code ("hipdata_code") unique = N
pttype.name ("name") unique = N
pteroprt.vn ("vn") unique = N
pteroprt.hn_vsttime_ercode_unique ("hn","vsttime","ercode","vstdate","eroprtime") unique = Y
ptdepart.vn ("vn") unique = N
ptdepart.status ("status") unique = N
ptdepart.hn ("hn") unique = N
ptdepart.depcode ("depcode") unique = N
ptcardno.ix_cardno ("cardno") unique = N
ptcardno.hn ("hn") unique = N
ptcardno.cardtype ("cardtype") unique = N
pt_subtype.ix_name ("name") unique = N
pt_medication_history.ix_medication_name ("medication_name") unique = N
pt_medication_history.ix_hn ("hn") unique = N
pt_consult.staff ("staff") unique = N
pt_consult.hn ("hn") unique = N
pt_consult.consult_date ("consult_date") unique = N
psychia_visit_type.ix_vn ("vn") unique = N
psychia_member_type.ix_hn ("hn") unique = N
psychia_member_type.ix_unique ("hn","psychia_type_id") unique = Y
promotion_package.ix_promotion_package_name ("promotion_package_name") unique = Y
printserver_document.ix_printok ("print_ok") unique = N
presetdosageregimen.iname ("iname") unique = N
pregnancy_abort_type.ix_pregnancy_abort_type_name ("pregnancy_abort_type_name") unique = Y
pq_screen.staff ("staff") unique = N
pq_screen.next_dep ("next_dep") unique = N
pq_rxorder.request_time ("request_time") unique = N
pq_rxorder.request_date ("request_date") unique = N
pq_rxorder.print ("print") unique = N
pq_rxorder.hn ("hn") unique = N
pq_opdcard_tag.request_time ("request_time") unique = N
pq_opdcard_tag.request_date ("request_date") unique = N
pq_opdcard_tag.print ("print") unique = N
pq_opdcard.request_time ("request_time") unique = N
pq_opdcard.request_date ("request_date") unique = N
pq_opdcard.print ("print") unique = N
pq_ipdorder.order_no_unique ("order_no") unique = N
pq_ipdorder.order_no ("order_no") unique = N
pq_ipdorder.an ("an") unique = N
pq_ipd_rxorder.request_time ("request_time") unique = N
pq_ipd_rxorder.request_date ("request_date") unique = N
pq_ipd_rxorder.print ("print") unique = N
pq_ipd_rxorder.hn ("hn") unique = N
pq_ipd_rxorder.an ("an") unique = N
pq_doctor.vn_unique ("vn") unique = N
pq_doctor.vn ("vn") unique = N
pq_doctor.staff ("staff") unique = N
pq_doctor.doctor ("doctor") unique = N
post_care_screen.ix_post_care_screen_name ("post_care_screen_name") unique = Y
physic_type.ix_physic_type_name ("physic_type_name") unique = Y
physic_main_ipd.ix_vstdate ("vstdate") unique = N
physic_main_ipd.ix_hn ("hn") unique = N
physic_main_ipd.ix_an ("an") unique = N
physic_main.ix_vstdate ("vstdate") unique = N
physic_list_ipd.ix_physic_items_id ("physic_items_id") unique = N
physic_list_ipd.ix_physic_main_ipd_id ("physic_main_ipd_id") unique = N
physic_list.vn ("vn") unique = N
physic_list.physic_items_id ("physic_items_id") unique = N
physic_items.name ("name") unique = N
physic_group.ix_physic_group_name ("physic_group_name") unique = Y
personid.personid_unique ("personid") unique = Y
personcardtime.cardid_readtime_unique ("cardid","readtime") unique = Y
person_women_service.ix_person_women_id ("person_women_id") unique = N
person_women.ix_out_region ("out_region") unique = N
person_women.ix_discharge ("discharge") unique = N
person_women.ix_person_id ("person_id") unique = Y
person_wbc_vaccine_detail.ix_person_wbc_service_id ("person_wbc_service_id") unique = N
person_wbc_service_detail.ix_person_wbc_service_id ("person_wbc_service_id") unique = N
person_wbc_service.ix_person_wbc_id ("person_wbc_id") unique = N
person_wbc_service.ix_old_visitno ("old_visitno") unique = N
person_wbc_post_care_screen.ix_person_wbc_post_care_id ("person_wbc_post_care_id") unique = N
person_wbc.ix_out_region ("out_region") unique = N
person_wbc.ix_discharge ("discharge") unique = N
person_visit.ix_person_id ("person_id") unique = N
person_village_duty.ix_person_id ("person_id") unique = N
person_vaccine_list.ix_person_vaccine_id ("person_vaccine_id") unique = N
person_vaccine_list.ix_person_id ("person_id") unique = N
person_vaccine_list.ix_unique ("person_id","person_vaccine_id") unique = Y
person_vaccine.ix_export_vaccine_code ("export_vaccine_code") unique = N
person_vaccine.ix_vaccine_name ("vaccine_name") unique = Y
person_thyroid_result.ix_name ("name") unique = Y
person_screen_type_view.ix_person_screen_id ("person_screen_id") unique = N
person_screen_type.ix_person_screen_type_name ("person_screen_type_name") unique = Y
person_screen_normal_value2.ix_person_screen_id ("person_screen_id") unique = N
person_screen_normal_value1.ix_person_screen_id ("person_screen_id") unique = N
person_screen_location.ix_person_screen_location_name ("person_screen_location_name") unique = Y
person_screen_form_detail.ix_person_screen_form_id ("person_screen_form_id") unique = N
person_screen_form.ix_person_screen_form_name ("person_screen_form_name") unique = Y
person_screen.ix_person_screen_name ("person_screen_name") unique = Y
person_labour_type.ix_person_labour_type_name ("person_labour_type_name") unique = Y
person_labour_place.ix_person_labour_place_name ("person_labour_place_name") unique = Y
person_labour_doctor_type.ix_person_labour_doctor_type_name ("person_labour_doctor_type_name") unique = Y
person_labor_type.ix_person_labor_type_name ("person_labor_type_name") unique = Y
person_house_position.ix_person_house_position_name ("person_house_position_name") unique = Y
person_house_history.ix_person_id ("person_id") unique = N
person_finger_template.ix_person_id ("person_id") unique = N
person_epi_vaccine.ix_vn ("vn") unique = N
person_epi_vaccine.ix_person_epi_id ("person_epi_id") unique = N
person_epi_vaccine.ix_old_visitno ("old_visitno") unique = N
person_epi_place.ix_person_epi_place_name ("person_epi_place_name") unique = Y
person_epi_nutrition.ix_person_epi_id ("person_epi_id") unique = N
person_epi.ix_person_epi_regdate ("person_epi_regdate") unique = N
person_epi.ix_out_region ("out_region") unique = N
person_epi.ix_discharge ("discharge") unique = N
person_epi.ix_person_id ("person_id") unique = Y
person_duty.ix_hcis_code ("hcis_code") unique = N
person_duty.ix_person_duty_name ("person_duty_name") unique = Y
person_discharge.ix_person_discharge_name ("person_discharge_name") unique = Y
person_development_list.ix_person_id ("person_id") unique = N
person_deformed_type.ix_person_deformed_type_name ("person_deformed_type_name") unique = Y
person_deformed_detail.ix_ixperson_deform_id ("person_deformed_id") unique = N
person_deformed.ix_person_id ("person_id") unique = N
person_death.ix_deathdate ("death_date") unique = N
person_chronic_visit.ix_person_id ("person_id") unique = N
person_behavior_list.ix_person_id ("person_id") unique = N
person_behavior.ix_person_behavior_name ("person_behavior_name") unique = Y
person_anc_service.ix_pa_week ("pa_week") unique = N
person_anc_service.ix_person_anc_id ("person_anc_id") unique = N
person_anc_service.ix_old_visitno ("old_visitno") unique = N
person_anc.ix_person_id ("person_id") unique = N
person_anc.ix_out_region ("out_region") unique = N
person_anc.ix_discharge ("discharge") unique = N
person_anc.ix_anc_finish ("anc_finish") unique = N
person.ix_mother_person_id ("mother_person_id") unique = N
person.ix_hn ("patient_hn") unique = N
person.ix_father_person_id ("father_person_id") unique = N
person.ix_death ("death") unique = N
person.ix_couple_person_id ("couple_person_id") unique = N
person.ix_house_id ("house_id") unique = N
person.ix_hos_guid ("hos_guid") unique = N
person.ix_cid ("cid") unique = N
pe_template.ix_pe_name ("pe_name") unique = N
pe_template.ix_doctor ("doctor") unique = N
pe_list.ix_pe_section ("pe_section") unique = N
pe_code.ix_name ("name") unique = N
pe_code.ix_doctor ("doctor") unique = N
pcu_replicate_log.event_id_unique ("event_id") unique = Y
pcu_replicate_cfg.node_id_unique ("node_id") unique = Y
pcu_node.node_id_unique ("node_id") unique = Y
pcu_dw_track.ix_table_name ("table_name") unique = N
pcu_drugitems.ix_icode ("icode") unique = N
pcu_drugitems.ix_drug_name ("drug_name") unique = Y
pcu_child.hcode_unique ("hcode") unique = Y
pcu_age_alert.ix_min_age ("min_age") unique = N
patient_vaccine.ix_hn ("hn") unique = N
patient_vaccine.ix_unique ("hn","baby_code") unique = Y
patient_relation_type.ix_patient_relation_type_name ("patient_relation_type_name") unique = Y
patient_relation_address.ix_hn ("hn") unique = N
patient_realname.ix_staff ("staff") unique = N
patient_promotion.ix_hn ("hn") unique = N
patient_pid.ix_pid ("pid") unique = Y
patient_opd_scan.vstdate ("vstdate") unique = N
patient_opd_scan.vn ("vn") unique = N
patient_opd_scan.staff ("staff") unique = N
patient_opd_scan.scan_date_time ("scan_date_time") unique = N
patient_opd_scan.hn ("hn") unique = N
patient_opd_scan.vstdate_vsttime_unique ("vstdate","vsttime","hn") unique = Y
patient_nc.staff ("staff") unique = N
patient_nc.hn ("hn") unique = N
patient_log.ix_hn ("hn") unique = N
patient_ipd_scan.vstdate ("vstdate") unique = N
patient_ipd_scan.staff ("staff") unique = N
patient_ipd_scan.scan_date_time ("scan_date_time") unique = N
patient_ipd_scan.hn ("hn") unique = N
patient_ipd_scan.an ("an") unique = N
patient_ipd_scan.an_page_no_unique ("an","page_no") unique = Y
patient_image.image_name ("image_name") unique = N
patient_image.hn ("hn") unique = N
patient_hospital_refer.ix_hospcode ("hospcode") unique = N
patient_hospital_refer.ix_hn ("hn") unique = N
patient_file.ix_hn ("hn") unique = N
patient_employer.employer_name ("employer_name") unique = N
patient_adr.ix_report_date ("report_date") unique = N
patient.ix_oldcode ("oldcode") unique = N
patient.ix_lname_soundex ("lname_soundex") unique = N
patient.ix_lastvisit ("last_visit") unique = N
patient.ix_fname_soundex ("fname_soundex") unique = N
patient.ix_ix_deathday ("deathday") unique = N
patient.ix_cid ("cid") unique = N
patient.ix_hcode ("hcode") unique = N
patient.ix_pttype ("pttype") unique = N
patient.ix_clinic ("clinic") unique = N
patient.ix_address ("chwpart","amppart","tmbpart") unique = N
patient.ix_chwpart ("chwpart") unique = N
patient.ix_fname_lname ("fname","lname") unique = N
patient.ix_lname ("lname") unique = N
patient.ix_fname ("fname") unique = N
patient.ix_pname ("pname") unique = N
patient.ix_hn_unique ("hn") unique = Y
patient.hn_unique ("hn") unique = Y
parent_type.ix_parent_type_name ("parent_type_name") unique = Y
papregist.ix_cid ("cid") unique = N
ovstoprt.ix_vn ("vn") unique = N
ovstoprt.ix_ovstdiagid ("ovst_diag_id") unique = N
ovstoprt.ix_icd9cm ("icd9cm") unique = N
ovstist.ovstist_unique ("ovstist") unique = Y
ovstdiag.vstdate ("vstdate") unique = N
ovstdiag.vn ("vn") unique = N
ovstdiag.icd10 ("icd10") unique = N
ovstdiag.hn ("hn") unique = N
ovstdiag.doctor ("doctor") unique = N
ovstdiag.ix_vn_icd_unique ("vn","icd10") unique = Y
ovst_sticker.ix_vstdate ("vstdate") unique = N
ovst_sticker.ix_depcode ("depcode") unique = N
ovst_seq.ix_seq_id ("seq_id") unique = Y
ovst_rx_room.ix_depcode ("depcode") unique = N
ovst_rx_room.ix_vn ("vn") unique = Y
ovst_oper_type.ix_name ("name") unique = Y
ovst_department.vn ("vn") unique = N
ovst_department.doctor ("doctor") unique = N
ovst_department.depcode ("depcode") unique = N
ovst.ix_ix_hn_vstdate ("hn","vstdate") unique = N
ovst.ix_staff ("staff") unique = N
ovst.ix_o_refer_number ("o_refer_number") unique = N
ovst.ix_hcode ("hcode") unique = N
ovst.ix_spclty ("spclty") unique = N
ovst.ix_pttype ("pttype") unique = N
ovst.ix_doctor ("doctor") unique = N
ovst.ix_vstdate ("vstdate") unique = N
ovst.ix_an ("an") unique = N
ovst.ix_hn ("hn") unique = N
ovst.ix_vn_unique ("vn") unique = Y
ovaccident.vn ("vn") unique = N
ovaccident.otime ("otime") unique = N
ovaccident.odate ("odate") unique = N
ovaccident.icd10 ("icd10") unique = N
ovaccident.hn ("hn") unique = N
ovaccident.flag ("flag") unique = N
opitemreceh.ix_hn ("hn") unique = N
opitemreceh.ix_an ("an") unique = N
opitemrece_summary.ix_rxdate ("rxdate") unique = N
opitemrece_summary.ix_ix_vn ("vn") unique = N
opitemrece_medplan.ix_med_plan_number ("med_plan_number") unique = N
opitemrece_medplan.ix_an_order_no ("an","order_no") unique = N
opitemrece_medplan.ix_an ("an") unique = N
opitemrece_log.vn ("vn") unique = N
opitemrece_finance_log.ix_vn ("vn") unique = N
opitemrece_finance_delete.vstdate ("vstdate") unique = N
opitemrece_finance_delete.vn ("vn") unique = N
opitemrece_finance_delete.sub_type ("sub_type") unique = N
opitemrece_finance_delete.staff ("staff") unique = N
opitemrece_finance_delete.pttype ("pttype") unique = N
opitemrece_finance_delete.item_type ("item_type") unique = N
opitemrece_finance_delete.icode ("icode") unique = N
opitemrece_finance_delete.hn ("hn") unique = N
opitemrece_finance_delete.hcode ("hcode") unique = N
opitemrece_finance_delete.finance_number ("finance_number") unique = N
opitemrece_finance_delete.drugusage ("drugusage") unique = N
opitemrece_finance_delete.doctor ("doctor") unique = N
opitemrece_finance_delete.an ("an") unique = N
opitemrece_delta.ix_vstdate ("vstdate") unique = N
opitemrece_delta.ix_vn ("vn") unique = N
opitemrece_delta.ix_sub_type ("sub_type") unique = N
opitemrece_delta.ix_rxdate ("rxdate") unique = N
opitemrece_delta.ix_pttype ("pttype") unique = N
opitemrece_delta.ix_item_type ("item_type") unique = N
opitemrece_delta.ix_icode ("icode") unique = N
opitemrece_delta.ix_hn ("hn") unique = N
opitemrece_delta.ix_hcode ("hcode") unique = N
opitemrece_delta.ix_finance_number ("finance_number") unique = N
opitemrece_delta.ix_drugusage ("drugusage") unique = N
opitemrece_delta.ix_doctor ("doctor") unique = N
opitemrece_delta.ix_an_rxdate_icode ("an","rxdate","icode") unique = N
opitemrece_delta.ix_an ("an") unique = N
opitemrece_charge.vn ("vn") unique = N
opitemrece_charge.charge_guid ("charge_guid") unique = N
opitemrece_bak.ix_vstdate ("vstdate") unique = N
opitemrece_bak.ix_vn ("vn") unique = N
opitemrece_bak.ix_sub_type ("sub_type") unique = N
opitemrece_bak.ix_rxdate ("rxdate") unique = N
opitemrece_bak.ix_pttype ("pttype") unique = N
opitemrece_bak.ix_an_rxdate_icode ("an","rxdate","icode") unique = N
opitemrece_bak.ix_item_type ("item_type") unique = N
opitemrece_bak.ix_icode ("icode") unique = N
opitemrece_bak.ix_hn ("hn") unique = N
opitemrece_bak.ix_hcode ("hcode") unique = N
opitemrece_bak.ix_finance_number ("finance_number") unique = N
opitemrece_bak.ix_drugusage ("drugusage") unique = N
opitemrece_bak.ix_doctor ("doctor") unique = N
opitemrece_bak.ix_an ("an") unique = N
opitemrece_arc.ix_vstdate ("vstdate") unique = N
opitemrece_arc.ix_vn ("vn") unique = N
opitemrece_arc.ix_sub_type ("sub_type") unique = N
opitemrece_arc.ix_rxdate ("rxdate") unique = N
opitemrece_arc.ix_pttype ("pttype") unique = N
opitemrece_arc.ix_an_rxdate_icode ("an","rxdate","icode") unique = N
opitemrece_arc.ix_item_type ("item_type") unique = N
opitemrece_arc.ix_icode ("icode") unique = N
opitemrece_arc.ix_hn ("hn") unique = N
opitemrece_arc.ix_hcode ("hcode") unique = N
opitemrece_arc.ix_finance_number ("finance_number") unique = N
opitemrece_arc.ix_drugusage ("drugusage") unique = N
opitemrece_arc.ix_doctor ("doctor") unique = N
opitemrece_arc.ix_an ("an") unique = N
opitemrece.order_no ("order_no") unique = N
opitemrece.ix_ix_rxdate ("rxdate") unique = N
opitemrece.ix_ix_an_rxdate_icode ("an","rxdate","icode") unique = N
opitemrece.ix_staff ("staff") unique = N
opitemrece.ix_item_type ("item_type") unique = N
opitemrece.ix_pttype ("pttype") unique = N
opitemrece.ix_sub_type ("sub_type") unique = N
opitemrece.ix_finance_number ("finance_number") unique = N
opitemrece.ix_hcode ("hcode") unique = N
opitemrece.ix_doctor ("doctor") unique = N
opitemrece.ix_vstdate ("vstdate") unique = N
opitemrece.ix_drugusage ("drugusage") unique = N
opitemrece.ix_icode ("icode") unique = N
opitemrece.ix_an ("an") unique = N
opitemrece.ix_hn ("hn") unique = N
opitemrece.ix_vn ("vn") unique = N
operation_team.operation_id ("operation_id") unique = N
operation_team.doctor ("doctor") unique = N
operation_status.status_name ("status_name") unique = N
operation_specimen_type.ix_operation_specimen_type_name ("operation_specimen_type_name") unique = Y
operation_screen_in.in_date_time ("in_date_time") unique = N
operation_schedule.ix_doctor_code ("doctor_code") unique = N
operation_scan.scan_title ("scan_title") unique = N
operation_scan.operation_id ("operation_id") unique = N
operation_room.room_name ("room_name") unique = N
operation_recovery_status.ix_recovery_status_name ("recovery_status_name") unique = Y
operation_preop_problem.ix_operation_preop_name ("operation_preop_name") unique = Y
operation_premed.operation_id ("operation_id") unique = N
operation_position.position_name ("position_name") unique = N
operation_list.status_id ("status_id") unique = N
operation_list.request_time ("request_time") unique = N
operation_list.request_doctor ("request_doctor") unique = N
operation_list.request_date ("request_date") unique = N
operation_item.name ("name") unique = N
operation_item.icode ("icode") unique = N
operation_invent.operation_id ("operation_id") unique = N
operation_invent.icode ("icode") unique = N
operation_intra_complication.operation_id ("operation_id") unique = N
operation_group.ix_operation_group_name ("operation_group_name") unique = Y
operation_emergency.emergency_name ("emergency_name") unique = N
operation_disease_list.operation_id ("operation_id") unique = N
operation_detail_position.ix_operation_position_name ("operation_position_name") unique = Y
operation_detail.operation_item_id ("operation_item_id") unique = N
operation_detail.operation_id ("operation_id") unique = N
operation_detail.doctor ("doctor") unique = N
operation_cancel_type.ix_operation_cancel_type_name ("operation_cancel_type_name") unique = Y
operation_blood.operation_id ("operation_id") unique = N
operation_anes_type.anes_name ("anes_name") unique = N
operation_anes_problem.ix_operation_id ("operation_id") unique = N
operation_anes_physical_status.ix_operation_anes_physical_status_name ("operation_anes_physical_status_name") unique = Y
operation_anes_oper_list.ix_operation_id ("operation_id") unique = N
operation_anes_oper.ix_operation_anes_oper_name ("operation_anes_oper_name") unique = Y
operation_anes_monitor.ix_anes_monitor_name ("anes_monitor_name") unique = Y
operation_anes_invent.operation_id ("operation_id") unique = N
operation_anes_invent.icode ("icode") unique = N
operation_anes.operation_id ("operation_id") unique = N
operation_anes.doctor ("doctor") unique = N
operation_airway_solution.ix_airway_solution_name ("airway_solution_name") unique = Y
operation_airway_problem.ix_airway_problem_name ("airway_problem_name") unique = Y
operation_agent.ix_ix_opi_guid ("opi_guid") unique = N
operation_agent.operation_id ("operation_id") unique = N
oper_formula.formula_name ("formula_name") unique = N
oper_formula.doctor ("doctor") unique = N
opduser_right.ix_loginname ("loginname") unique = N
opduser.password ("password") unique = N
opduser.name ("name") unique = N
opduser.groupname ("groupname") unique = N
opduser.department ("department") unique = N
opdscreening.vn_unique ("vn") unique = N
opdscreening.vsttime ("vsttime") unique = N
opdscreening.vstdate_hn_vsttime ("vstdate","hn","vsttime") unique = N
opdscreening.vstdate ("vstdate") unique = N
opdscreening.vn ("vn") unique = N
opdscreening.hn ("hn") unique = N
opdscreen_bp.vn ("vn") unique = N
opdscreen_bp.screen_date ("screen_date") unique = N
opdscreen.ix_vstdate ("vstdate") unique = N
opdscreen.ix_hn ("hn") unique = N
opdscreen.ix_vn_unique ("vn") unique = Y
opdscan_vn.ix_vn ("vn") unique = N
opdscan.scan_date_time ("scan_date_time") unique = N
opdscan.hn ("hn") unique = N
opdrent.return_date ("return_date") unique = N
opdrent.rent_date ("rent_date") unique = N
opdrent.hn ("hn") unique = N
opdrent.checkin ("checkin") unique = N
opdquickccscreen.quickname_unique ("quickname") unique = Y
opdnurse.vn ("vn") unique = N
opdcard_print_log.ix_staff ("staff") unique = N
opdcard_print_log.ix_print_date ("print_date") unique = N
opdcard_print_log.ix_hn ("hn") unique = N
opdcard_not_found.ix_hn ("hn") unique = Y
opdcard_location.ix_hn ("hn") unique = N
opd_screen_value.ix_vn ("vn") unique = N
opd_screen_value.ix_screen_name ("screen_name") unique = N
opd_queue.ix_vn ("vn") unique = N
opd_queue.ix_opd_department_id ("opd_department_id") unique = N
opd_queue.ix_unique ("queue_date","opd_department_id","queue_no") unique = Y
opd_order_no.ix_vstdate ("vstdate") unique = N
opd_order_no.ix_vn ("vn") unique = N
opd_observe.vn ("vn") unique = N
opd_observe.send_doctor ("send_doctor") unique = N
opd_observe.send_date_time ("send_date_time") unique = N
opd_observe.observe_status ("observe_status") unique = N
opd_monitor.vn ("vn") unique = N
opd_monitor.monitor_criteria_id ("monitor_criteria_id") unique = N
opd_monitor.consult_ok ("consult_ok") unique = N
opd_monitor.consult_doctor ("consult_doctor") unique = N
opd_monitor.consult_date_time ("consult_date_time") unique = N
opd_ipd_transfer.ix_ix_vn ("vn") unique = N
opd_ipd_transfer.ix_ix_an ("an") unique = N
opd_ill_history.hn_unique ("hn") unique = Y
opd_hn_change.ix_ix_id ("opd_hn_change_id") unique = N
opd_hn_change.ix_ix_hos_guid ("hos_guid") unique = N
opd_department.ix_opd_department_name ("opd_department_name") unique = Y
opd_card_request.request_date_time ("request_date_time") unique = N
opd_card_request.hn ("hn") unique = N
opd_allergy.report_date ("report_date") unique = N
opd_allergy.hn ("hn") unique = N
opd_allergy.agent ("agent") unique = N
opd_allergy.unique ("hn","agent") unique = Y
onlineuser.ksklogintime ("ksklogintime") unique = N
onlineuser.computername ("computername") unique = N
onlineuser.onlineid ("onlineid") unique = N
online_printserver.computer ("computer") unique = N
offline_track.ix_table_name ("table_name") unique = N
offline_track.ix_sync_ok ("sync_ok") unique = N
occupation.ix_name ("name") unique = Y
oapp_xray.ix_oapp_id ("oapp_id") unique = N
oapp_template.ix_oapp_template_name ("oapp_template_name") unique = Y
oapp_temp.ix_ix_vstdate ("vstdate") unique = N
oapp_temp.ix_ix_vn ("vn") unique = N
oapp_temp.ix_ix_vh ("vstdate","hn") unique = N
oapp_temp.ix_ix_nextdate ("nextdate") unique = N
oapp_temp.ix_ix_hn ("hn") unique = N
oapp_temp.ix_ix_doctor ("doctor") unique = N
oapp_limit.ix_oapp_limit_clinic ("oapp_date","oapp_clinic") unique = N
oapp_limit.ix_oapp_date ("oapp_date"
-
Error หน้าจอบันทึกส่งตรวจนะครับ
ทดสอบแล้วครับ ขึ้น error ตามที่คุณvniwat ว่าจริงๆ ครับ
ลองทดสอบดูครับ :D ;D :D :D
-
Error หน้าจอบันทึกส่งตรวจนะครับ
ทดสอบแล้วครับ ขึ้น error ตามที่คุณvniwat ว่าจริงๆ ครับ
ลองทดสอบดูครับ :D ;D :D :D
อีก 1 เสียง ครับ
-
ตกใจหมดเลยครับ นึกว่าฐานข้อมูลผมมีปัญหาคนเดียว
up เครื่องสำรองก่อนทุกครั้ง
ขอบคุณท่านกิจ ครับที่บอกให้ทราบ
-
ตกใจหมดเลยครับ นึกว่าฐานข้อมูลผมมีปัญหาคนเดียว
up เครื่องสำรองก่อนทุกครั้ง
ขอบคุณท่านกิจ ครับที่บอกให้ทราบ
ถ้าจะขอบคุณกด thank เลยครับ ;D ;D ;D ;D ;D
-
เอ้ เอ้ ช้าก่อน
ของผมทดสอบใน Server slave Upversion 3.52.1.18 +Mysql 5.1.30 +innodb เรียบร้อย
ใช้ Client Mysql5.1.28 + 3.52.1.18 ส่งตรวจ
ผลเป็นปกติ ไม่ติด Error ครับ
ถอยVersion
3.51.12.4 ส่งตรวจ ---> ปกติครับ
-
;D ;D ;D ของผมที่ตัวทดสอบก็ Error ครับ ;D ;D ;D
-
;D ;D ;D ของผมที่ตัวทดสอบก็ Error ครับ ;D ;D ;D
... ของผม admin Error ครับป๋า เลยยังไม่ได้ทดสอบ ... ;D ;D ;D ....
... เดี๋ยวต้องพักไปเดินสายแลนขยายจุดให้งานประกันฯ ก่อน คืนนี้ค่อยโหลดมาทดลอง .... :D ....
-
เวอร์ชั่นนี้ ส่งออก 12+PP ในส่วนของแฟ้ม IOP ยังส่งออกไม่ถูกต้องครับ ของผมลองส่งเดือน 12-51 ออก 2Record เอง.... ???
-
ถ้าจะขอบคุณกด thank เลยครับ ;D ;D ;D ;D ;D
ตั๊กฝากมาว่า...จะเอาแต้ม thank หรือครับ ...
ตอนนี้กำลัง upgrade structure ถ้าเป็นเหมือนหลาย ๆ ท่านจะเข้ามารายงานนะครับ ...พี่น้อง
-
Error หน้าจอบันทึกส่งตรวจนะครับ
ทดสอบแล้วครับ ขึ้น error ตามที่คุณvniwat ว่าจริงๆ ครับ
ลองทดสอบดูครับ :D ;D :D :D
พบ error เช่นเดียวกัน
-
Error หน้าจอบันทึกส่งตรวจนะครับ
ยืนยันอีกคน error เหมือนกันครับ
-
ทำการแก้ไขให้แล้วครับใน 3.52.1.19
-
ทำการแก้ไขให้แล้วครับใน 3.52.1.19
เย้้้้้้้้้้้้้้้้้้้้้้!!!!!
ถ้าจะขอบคุณกด thank เลยครับ ;D ;D ;D ;D ;D
ตั๊กฝากมาว่า...จะเอาแต้ม thank หรือครับ ...
ตอนนี้กำลัง upgrade structure ถ้าเป็นเหมือนหลาย ๆ ท่านจะเข้ามารายงานนะครับ ...พี่น้อง
แน่นอนครับ ผมรณรงค์ให้คนใช้ ระบบ thank ครับ
-
ทำการแก้ไขให้แล้วครับใน 3.52.1.19
;D ;D ;D wait...wait...wait...and wait again ;D ;D ;D
-
ทำการแก้ไขให้แล้วครับใน 3.52.1.19
;D ;D ;D wait...wait...wait...and wait again ;D ;D ;D
มาไม่ทัน หลังจากนั่งรอ upgrade structure ประมาณ 3 ชม. (ผิดปกติ...ไม่รู้ว่าเป็นที่เครื่องตั๊ก หรือ Network) :(
แล้วก็ error เหมือนทุกท่านครับ
-
3.52.01.19
- แก้ไข Bug การส่งข้อมูลในตาราง IOP จากระบบส่งออก 12+8 แฟ้มใช้วันที่เดียวกันในการกำหนดเงื่อนไข
- แก้ไข Bug ส่งตรวจ Error (ระบบแสดงข้อมูลคลินิกพิเศษ)
- ปรับปรุงระบบ Lock สิทธิประจำตัวผู้ป่วยที่ระบบเวชระเบียน (opdcard)
- ปรับปรุงระบบบันทึกข้อมูล Against advice text ที่ระบบจำหน่ายผู้ป่วยใน
- ปรับปรุงระบบบันทึกสั่งยาทั้งตึกให้ Lock ใบสั่งยาอัตโนมัติ
- เพิ่มปุ่ม off ทุกรายการในระบบ IPD Medication profile
- ปรับปรุงระบบแก้ไขข้อมูลรายการ Medication profile item ใหม่
-
ช่วยตรวจงานส่งเสริมสุขภาพ ในโปรแกรมห้องทำงานแพทย์ ที่ err..v.3.52.1.15...3.52.1.16
ลงทะเบียน vaccine 1-6 ปี เด็กวัยเรียน และทะบียนวางแผนครอบครัว...
EurekaLog 6.0.18
Application:
-------------------------------------------------------
1.1 Start Date : Mon, 19 Jan 2009 10:28:01 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 3.52.1.15
1.4 Parameters :
1.5 Compilation Date: Thu, 15 Jan 2009 22:40:21 +0700
1.6 Up Time : 2 minutes, 33 seconds
Exception:
-----------------------------------------------------------------------------------------------------------
2.1 Date : Mon, 19 Jan 2009 10:30:35 +0700
2.2 Address : 015486D2
2.3 Module Name : HOSMy.exe
2.4 Module Version: 3.52.1.15
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 015486D2 in module 'HOSMy.exe'. Read of address 0000005C.
2.7 ID : 5B62
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : 1
3.2 Name : sKzXP
3.3 Email :
3.4 Company : sKz Community
3.5 Privileges: SeChangeNotifyPrivilege - ON
SeSecurityPrivilege - OFF
SeBackupPrivilege - OFF
SeRestorePrivilege - OFF
SeSystemtimePrivilege - OFF
SeShutdownPrivilege - OFF
SeRemoteShutdownPrivilege - OFF
SeTakeOwnershipPrivilege - OFF
SeDebugPrivilege - OFF
SeSystemEnvironmentPrivilege - OFF
SeSystemProfilePrivilege - OFF
SeProfileSingleProcessPrivilege - OFF
SeIncreaseBasePriorityPrivilege - OFF
SeLoadDriverPrivilege - ON
SeCreatePagefilePrivilege - OFF
SeIncreaseQuotaPrivilege - OFF
SeUndockPrivilege - ON
SeManageVolumePrivilege - OFF
SeImpersonatePrivilege - ON
SeCreateGlobalPrivilege - ON
Active Controls:
--------------------------------
4.1 Form Class : TMainForm
4.2 Form Text : :: HOSxP ::
4.3 Control Class: TwwDBGrid
4.4 Control Text :
Computer:
----------------------------------------------------------------------------------
5.1 Name : LAB1
5.2 Total Memory : 1015 Mb
5.3 Free Memory : 298 Mb
5.4 Total Disk : 48.83 Gb
5.5 Free Disk : 18.21 Gb
5.6 System Up Time: 2 hours, 42 minutes, 32 seconds
5.7 Processor : Intel(R) Pentium(R) 4 CPU 3.20GHz
5.8 Display Mode : 1152 x 864, 32 bit
5.9 Display DPI : 96
5.10 Video Card : Intel(R) 82945G Express Chipset Family (driver 6.14.10.4543)
5.11 Printer : Samsung ML-2010 Series (driver 0,5,0,0)
Operating System:
------------------------------------
6.1 Type : Microsoft Windows XP
6.2 Build # : 2600
6.3 Update : Service Pack 3
6.4 Language: Thai
6.5 Charset : 222
Network:
---------------------------------
7.1 IP Address: 192.168.001.200
7.2 Submask : 255.255.255.000
7.3 Gateway : 192.168.001.001
7.4 DNS 1 : 203.113.024.199
7.5 DNS 2 : 203.113.127.199
7.6 DHCP : OFF
Custom Information:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.1 Hospital Code : 10874 [รพช. บ้านเหลื่อม]
8.2 Database Type : MySQL
8.3 Database Protocol : mysql-4.1 [5.1.20-beta-community-nt-debug
Database hos @ 127.0.0.1]
8.4 :
8.5 No 1 : select p.* ,pc.name as pttype_name,x.name as sex_name ,n.name as nationality_name, e.name as education_name ,o.name as occupation_name,r.name as religion_name , y.name as marrystatus_name ,t.house_regist_type_name ,h.address,v.village_moo,v.village_name,ta.full_name as address_name from person p left outer join pcode pc on pc.code = p.pcode left outer join sex x on x.code = p.sex left outer join nationality n on n.nationality = p.nationality left outer join education e on e.education = p.education left outer join occupation o on o.occupation = p.occupation left outer join religion r on r.religion = p.religion left outer join marrystatus y on y.code = p.marrystatus left outer join house_regist_type t on t.house_regist_type_id = p.house_regist_type_id left outer join house h on h.house_id = p.house_id left outer join village v on v.village_id = p.village_id left outer join thaiaddress ta on ta.addressid = v.address_id where p.person_id = 5815
8.6 No 2 : insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'LAB1','UPDATE person SET age_d=9 WHERE person_id=5815')
8.7 No 3 : UPDATE person SET age_d=9 WHERE person_id=5815
8.8 DBMS Variables :
8.9 :
8.10 auto_increment_increment: 1
auto_increment_offset = 1
autocommit = ON
automatic_sp_privileges = ON
back_log = 50
basedir = C:\Program Files\HOSxP\MySQL\
big_tables = ON
binlog_cache_size = 32768
binlog_format = MIXED
bulk_insert_buffer_size = 8388608
character_set_client = tis620
character_set_connection = tis620
character_set_database = tis620
character_set_filesystem = binary
character_set_results = tis620
character_set_server = tis620
character_set_system = utf8
character_sets_dir = C:\Program Files\HOSxP\MySQL\share\charsets\
collation_connection = tis620_thai_ci
collation_database = tis620_thai_ci
collation_server = tis620_thai_ci
completion_type = 0
concurrent_insert = 1
connect_timeout = 5
datadir = C:\Program Files\HOSxP\MySQL\data\
date_format = %Y-%m-%d
datetime_format = %Y-%m-%d %H:%i:%s
debug =
default_week_format = 0
delay_key_write = ON
delayed_insert_limit = 100
delayed_insert_timeout = 300
delayed_queue_size = 1000
div_precision_increment = 4
engine_condition_pushdown = ON
error_count = 0
event_scheduler = DISABLED
expire_logs_days = 0
flush = OFF
flush_time = 1800
foreign_key_checks = ON
ft_boolean_syntax = + -><()~*:""&|
ft_max_word_len = 84
ft_min_word_len = 4
ft_query_expansion_limit = 20
ft_stopword_file = (built-in)
general_log = OFF
general_log_file = C:\Program Files\HOSxP\MySQL\data\lab1.log
group_concat_max_len = 1024
have_compress = YES
have_crypt = NO
have_csv = YES
have_dynamic_loading = YES
have_geometry = YES
have_innodb = YES
have_ndbcluster = NO
have_openssl = DISABLED
have_partitioning = YES
have_query_cache = YES
have_rtree_keys = YES
have_ssl = DISABLED
have_symlink = YES
hostname = lab1
identity = 1165
init_connect = SET NAMES tis620
init_file =
init_slave =
innodb_additional_mem_pool_size = 106954752
innodb_autoextend_increment = 8
innodb_buffer_pool_size = 425721856
innodb_checksums = ON
innodb_commit_concurrency = 0
innodb_concurrency_tickets = 500
innodb_data_file_path = ibdata1:100M:autoextend
innodb_data_home_dir =
innodb_doublewrite = ON
innodb_fast_shutdown = 1
innodb_file_io_threads = 4
innodb_file_per_table = ON
innodb_flush_log_at_trx_commit = 1
innodb_flush_method =
innodb_force_recovery = 0
innodb_lock_wait_timeout = 50
innodb_locks_unsafe_for_binlog = OFF
innodb_log_arch_dir =
innodb_log_buffer_size = 4194304
innodb_log_file_size = 16777216
innodb_log_files_in_group = 2
innodb_log_group_home_dir = .\
innodb_max_dirty_pages_pct = 90
innodb_max_purge_lag = 0
innodb_mirrored_log_groups = 1
innodb_open_files = 300
innodb_rollback_on_timeout = OFF
innodb_support_xa = ON
innodb_sync_spin_loops = 20
innodb_table_locks = ON
innodb_thread_concurrency = 8
innodb_thread_sleep_delay = 10000
insert_id = 0
interactive_timeout = 28800
join_buffer_size = 131072
key_buffer_size = 425721856
key_cache_age_threshold = 300
key_cache_block_size = 1024
key_cache_division_limit = 100
language = C:\Program Files\HOSxP\MySQL\share\english\
large_files_support = ON
large_page_size = 0
large_pages = OFF
last_insert_id = 1165
lc_time_names = en_US
license = GPL
local_infile = ON
log = OFF
log_bin = OFF
log_bin_trust_function_creators = OFF
log_bin_trust_routine_creators = OFF
log_error = C:\Program Files\HOSxP\MySQL\data\lab1.err
log_output = TABLE
log_queries_not_using_indexes = OFF
log_slave_updates = OFF
log_slow_queries = OFF
log_warnings = 1
long_query_time = 10
low_priority_updates = OFF
lower_case_file_system = ON
lower_case_table_names = 1
max_allowed_packet = 16776192
max_binlog_cache_size = 4294967295
max_binlog_size = 1073741824
max_connect_errors = 10
max_connections = 1000
max_delayed_threads = 20
max_error_count = 64
max_heap_table_size = 106954752
max_insert_delayed_threads = 20
max_join_size = 4294967295
max_length_for_sort_data = 1024
max_prepared_stmt_count = 16382
max_relay_log_size = 0
max_seeks_for_key = 4294967295
max_sort_length = 1024
max_sp_recursion_depth = 0
max_tmp_tables = 32
max_user_connections = 0
max_write_lock_count = 4294967295
multi_range_count = 256
myisam_data_pointer_size = 6
myisam_max_sort_file_size = 2147483647
myisam_recover_options = OFF
myisam_repair_threads = 1
myisam_sort_buffer_size = 266338304
myisam_stats_method = nulls_unequal
myisam_use_mmap = OFF
named_pipe = OFF
net_buffer_length = 16384
net_read_timeout = 30
net_retry_count = 10
net_write_timeout = 60
new = OFF
old = OFF
old_alter_table = OFF
old_passwords = OFF
open_files_limit = 2048
optimizer_prune_level = 1
optimizer_search_depth = 62
pid_file = C:\Program Files\HOSxP\MySQL\data\lab1.pid
plugin_dir = C:\Program Files\HOSxP\MySQL\lib/
port = 3306
preload_buffer_size = 32768
protocol_version = 10
pseudo_thread_id = 1436
query_alloc_block_size = 8192
query_cache_limit = 1048576
query_cache_min_res_unit = 4096
query_cache_size = 0
query_cache_type = ON
query_cache_wlock_invalidate = OFF
query_prealloc_size = 8192
rand_seed1 =
rand_seed2 =
range_alloc_block_size = 2048
read_buffer_size = 2093056
read_only = OFF
read_rnd_buffer_size = 2093056
relay_log_purge = ON
relay_log_space_limit = 0
rpl_recovery_rank = 0
secure_auth = OFF
secure_file_priv =
server_id = 0
shared_memory = OFF
shared_memory_base_name = MYSQL
skip_external_locking = ON
skip_networking = OFF
skip_show_database = OFF
slave_compressed_protocol = OFF
slave_load_tmpdir = C:\WINDOWS\TEMP
slave_net_timeout = 3600
slave_skip_errors = OFF
slave_transaction_retries = 10
slow_launch_time = 2
slow_query_log = OFF
slow_query_log_file = C:\Program Files\HOSxP\MySQL\data\lab1-slow.log
sort_buffer_size = 266338296
sql_auto_is_null = ON
sql_big_selects = ON
sql_big_tables = ON
sql_buffer_result = OFF
sql_log_bin = ON
sql_log_off = OFF
sql_log_update = ON
sql_low_priority_updates = OFF
sql_max_join_size = 4294967295
sql_mode =
sql_notes = ON
sql_quote_show_create = ON
sql_safe_updates = OFF
sql_select_limit = 4294967295
sql_slave_skip_counter =
sql_warnings = OFF
ssl_ca =
ssl_capath =
ssl_cert =
ssl_cipher =
ssl_key =
storage_engine = MyISAM
sync_binlog = 0
sync_frm = ON
system_time_zone = SE Asia Standard Time
table_definition_cache = 128
table_lock_wait_timeout = 50
table_open_cache = 519
table_type = MyISAM
thread_cache_size = 0
thread_handling = one-thread-per-connection
thread_stack = 196608
time_format = %H:%i:%s
time_zone = SYSTEM
timed_mutexes = OFF
timestamp = 1232335711
tmp_table_size = 16777216
tmpdir = C:\WINDOWS\TEMP
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
tx_isolation = REPEATABLE-READ
unique_checks = ON
updatable_views_with_limit = YES
version = 5.1.20-beta-community-nt-debug
version_comment = MySQL Community Server (GPL)
version_compile_machine = ia32
version_compile_os = Win32
wait_timeout = 28800
warning_count = 0