BMS-HOSxP Community
		HOSxP => แจ้งปัญหา / ขอความช่วยเหลือ => ข้อความที่เริ่มโดย: u10908 ที่ กรกฎาคม 25, 2013, 17:39:20 PM
		
			
			- 
				จะปล่อยโหลด เมื่อไหร่น้อ  หรือว่าโดนบล็อก หรือว่าเจอ บั๊ก 
			
- 
				อีกสักพักครับ อ.ชัยพร ปรับตาม request ของ tester อยู่ครับ
			
- 
				 ;D ;D ;D
 ใจเย็น ๆ ครับเจ๊
 ;D ;D ;D
- 
				ดูจาก Change Log แล้วมันน่าสนใจ  จ๊ะ  และถามเผื่อหลายๆท่านที่สงสัย คือกัลล  จ้า 
			
- 
				ดูจาก Change Log แล้วมันน่าสนใจ  จ๊ะ  และถามเผื่อหลายๆท่านที่สงสัย คือกัลล  จ้า 
 
 
 ประมาณ
 
 ALTER TABLE xray_pacs_transaction ADD `hos_guid` char(38) NULL
 ALTER TABLE ward_admit_snapshot ADD `hos_guid` char(38) NULL
 ALTER TABLE vn_opd_complete ADD `hos_guid` char(38) NULL
 ALTER TABLE vn_insert ADD `hos_guid` char(38) NULL
 ALTER TABLE vital_sign_data ADD `hos_guid` char(38) NULL
 ALTER TABLE visit_pttype_change ADD `hos_guid` char(38) NULL
 ALTER TABLE visit_name ADD `hos_guid` char(38) NULL
 ALTER TABLE thaiaddress ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE sks_drug_code ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE sks_drug_code ADD `hos_guid` char(38) NULL
 ALTER TABLE serial ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE screen_doctor ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE screen_doctor ADD `hos_guid` char(38) NULL
 ALTER TABLE rx_audit ADD `hos_guid` char(38) NULL
 ALTER TABLE risk_screen_sso_company ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE risk_screen_sso_company ADD `hos_guid` char(38) NULL
 ALTER TABLE reporttemplate_history ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE reporttemplate ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE rcpt_print_opi ADD `hos_guid` char(38) NULL
 ALTER TABLE rcpt_disease ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE rcpt_debt_opi ADD `hos_guid` char(38) NULL
 ALTER TABLE rcpt_abort ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE rcpt_abort ADD `hos_guid` char(38) NULL
 ALTER TABLE pttypehistory ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE pttypehistory ADD `hos_guid` char(38) NULL
 ALTER TABLE ptdepart ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ptdepart ADD `hos_guid` char(38) NULL
 ALTER TABLE provis_chronic_icd10 ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE provis_chronic_icd10 ADD `hos_guid` char(38) NULL
 ALTER TABLE profile_print ADD `hos_guid` char(38) NULL
 ALTER TABLE pq_screen ADD `hos_guid` char(38) NULL
 ALTER TABLE pq_ipdorder ADD `hos_guid` char(38) NULL
 ALTER TABLE person_bc_target ADD `hos_guid` char(38) NULL
 ALTER TABLE person_anc_classifying ADD `hos_guid` char(38) NULL
 ALTER TABLE pe_image ADD `hos_guid` char(38) NULL
 ALTER TABLE pe_code ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_search ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_search ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_rx_note ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_rx_note ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_regiment ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_regiment ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_qr_code ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_qr_code ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_pttype_lock ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_pttype_lock ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_pid ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_pid ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_nc ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_nc ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_history ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_history ADD `hos_guid` char(38) NULL
 ALTER TABLE patient_employer ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE patient_employer ADD `hos_guid` char(38) NULL
 ALTER TABLE ovst_rx_room ADD `hos_guid` char(38) NULL
 ALTER TABLE ovst_presc_ned ADD `hos_guid` char(38) NULL
 ALTER TABLE ovst_nhso_send ADD `hos_guid` char(38) NULL
 ALTER TABLE ovst_finance ADD `hos_guid` char(38) NULL
 ALTER TABLE ovst_control_doctor ADD `hos_guid` char(38) NULL
 ALTER TABLE opitemrece_summary ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE opitemrece_sticker_stat ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE opitemrece_pay ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE opitemrece_medplan ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE opitemrece_ipd ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE opitemrece_finance_delete ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE opitemrece_charge ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE operation_icd_10 ADD `hos_guid` char(38) NULL
 ALTER TABLE opduser_right ADD `hos_guid` char(38) NULL
 ALTER TABLE opdcard_location ADD `hos_guid` char(38) NULL
 ALTER TABLE opd_regist_sendlist ADD `hos_guid` char(38) NULL
 ALTER TABLE opd_observe ADD `hos_guid` char(38) NULL
 ALTER TABLE opd_ill_history ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE opd_ill_history ADD `hos_guid` char(38) NULL
 ALTER TABLE opd_hn_change ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE nhso_offline_check ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE nhso_offline_check ADD `hos_guid` char(38) NULL
 ALTER TABLE medreturn_ipd ADD `hos_guid` char(38) NULL
 ALTER TABLE medpay_ipd_head ADD `hos_guid` char(38) NULL
 ALTER TABLE loinc_code ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE loinc_code ADD `hos_guid` char(38) NULL
 ALTER TABLE lab_order_print ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE lab_lis_track ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_queue ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ipt_queue ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_income_auto_check ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ipt_income_auto_check ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_income_auto_charge ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ipt_income_auto_charge ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_income_auto ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ipt_income_auto ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_food_order_sp ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_finance_status ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ipt_finance_status ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_chart_location ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ipt_chart_location ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_against_advice ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ipt_against_advice ADD `hos_guid` char(38) NULL
 ALTER TABLE ipt_admit_queue ADD `hos_guid` char(38) NULL
 ALTER TABLE ipd_profile_print ADD `hos_guid` char(38) NULL
 ALTER TABLE ipd_mar ADD `hos_guid` char(38) NULL
 ALTER TABLE ipd_data_synchronize ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ipd_data_synchronize ADD `hos_guid` char(38) NULL
 ALTER TABLE incoth_summary_head ADD `hos_guid` char(38) NULL
 ALTER TABLE incoth ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE incith_adjust ADD `hos_guid` char(38) NULL
 ALTER TABLE incith ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE incith ADD `hos_guid` char(38) NULL
 ALTER TABLE inc_opd_stat ADD `hos_guid` char(38) NULL
 ALTER TABLE inc_ipd_stat ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE inc_ipd_stat ADD `hos_guid` char(38) NULL
 ALTER TABLE icd_codemap ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE icd_codemap ADD `hos_guid` char(38) NULL
 ALTER TABLE icd9cm1 ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE icd9cm1 ADD `hos_guid` char(38) NULL
 ALTER TABLE icd10tm_operation ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE icd10tm_operation ADD `hos_guid` char(38) NULL
 ALTER TABLE icd101 ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE icd101 ADD `hos_guid` char(38) NULL
 ALTER TABLE hosxp_ddl_index ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE hosxp_ddl_index ADD `hos_guid` char(38) NULL
 ALTER TABLE hosxp_ddl_field ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE hosxp_ddl_field ADD `hos_guid` char(38) NULL
 ALTER TABLE hospcode ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE hninsert ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE hninsert ADD `hos_guid` char(38) NULL
 ALTER TABLE hipdata ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE height_chart ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE fbshistory ADD `hos_guid` char(38) NULL
 ALTER TABLE eriscode ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE eriscode ADD `hos_guid` char(38) NULL
 ALTER TABLE er_image ADD `hos_guid` char(38) NULL
 ALTER TABLE dw_emr_cache ADD `hos_guid` char(38) NULL
 ALTER TABLE dt_list ADD `hos_guid` char(38) NULL
 ALTER TABLE drugusage_line2 ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE drugusage_line2 ADD `hos_guid` char(38) NULL
 ALTER TABLE drugusage_line1 ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE drugusage_line1 ADD `hos_guid` char(38) NULL
 ALTER TABLE drugstdgeneric ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE drugstdgeneric ADD `hos_guid` char(38) NULL
 ALTER TABLE drugitems_usage ADD `hos_guid` char(38) NULL
 ALTER TABLE drugitems_register_unique ADD `hos_guid` char(38) NULL
 ALTER TABLE drugitems_register ADD `hos_guid` char(38) NULL
 ALTER TABLE drug_interaction_incident ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE drug_interaction_incident ADD `hos_guid` char(38) NULL
 ALTER TABLE doctor_cert ADD `hos_guid` char(38) NULL
 ALTER TABLE dental_icd ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE dental_icd ADD `hos_guid` char(38) NULL
 ALTER TABLE dbicd10chronic ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE dbicd10chronic ADD `hos_guid` char(38) NULL
 ALTER TABLE dbhospital ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE dbhospital ADD `hos_guid` char(38) NULL
 ALTER TABLE dbaddress ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE dbaddress ADD `hos_guid` char(38) NULL
 ALTER TABLE data_synchronize ADD `hos_guid` char(38) NULL
 ALTER TABLE ct2proc ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ct2proc ADD `hos_guid` char(38) NULL
 ALTER TABLE ct2mdcpr ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ct2mdcpr ADD `hos_guid` char(38) NULL
 ALTER TABLE ct2icd10 ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ct2icd10 ADD `hos_guid` char(38) NULL
 ALTER TABLE ct2ccexc ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ct2ccexc ADD `hos_guid` char(38) NULL
 ALTER TABLE ct2ax ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE ct2ax ADD `hos_guid` char(38) NULL
 ALTER TABLE bw_chart ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE bmi_chart ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE bird_flu_screen ADD `hos_guid` char(38) NULL
 ALTER TABLE baby_development_status ADD `hos_guid_ext` varchar(64) NULL
 ALTER TABLE aninsert ADD `hos_guid_ext` varchar(64) NULL
- 
				จะปล่อยโหลด เมื่อไหร่น้อ  หรือว่าโดนบล็อก หรือว่าเจอ บั๊ก 
 
 
 แนะนำว่าถ้าเจอ เวอร์ชั่นใหม่ ทำใจว่า หลาย รพ.ต้องปิดระบบ ก่อนอัพเวอร์ชั่น เพราะน่าจะนานมาก
 เพิ่มเยอะนะครับ
- 
				load ได้แล้วน่ะครับ ตอนนี้ สด ๆ ร้อน ๆๆ ;D ;D
			
- 
				แต่ยังไม่ผ่าน QC ตรวจสอบเลยนะครับ
			
- 
				up โลด  ทดสอบๆ ;D :D