- Implement ระบบ PAC Link license check
กำลังจะลง PAC ครับ
วันที่ 5 ตค.54 ทดสอบแล้วครับ
Checking structure phase 2
ALTER TABLE provis_typedis MODIFY COLUMN `code` varchar(2)
ALTER TABLE person_dmht_risk_screen_head ADD `in_hospital` char(1) NULL
ALTER TABLE oapp ADD `operation_anes_type` varchar(15) NULL
ALTER TABLE oapp ADD `operation_doctor_code` varchar(25) NULL
ALTER TABLE oapp ADD `operation_note` varchar(200) NULL
ALTER TABLE oapp ADD `operation_patient_type` char(3) NULL
ALTER TABLE oapp ADD `operation_appointment` char(1) NULL
ALTER TABLE ipt_cancel_log ADD `cancel_reason_text` text NULL
ALTER TABLE ipt_cancel_log ADD `cancel_staff` varchar(50) NULL
ALTER TABLE ipt_cancel_log ADD `cancel_datetime` datetime NULL
ALTER TABLE ipt_cancel_log ADD `an` varchar(9) NOT NULL
ALTER TABLE immigration_checkup ADD `immigration_checkup_pttype_expirationdate` date NULL
ALTER TABLE immigration_checkup ADD `immigration_checkup_pttype_issueddate` date NULL
ALTER TABLE immigration_checkup ADD `immigration_checkup_pttype_no` varchar(15) NULL
ALTER TABLE bb_blood_request ADD `bb_request_labnote` varchar(200) NULL
ALTER TABLE bb_blood_request ADD `bb_request_approvelab` datetime NULL
ALTER TABLE bb_blood_bag ADD `lab_otfnote` varchar(200) NULL
ALTER TABLE bb_blood_bag ADD `lab_note` varchar(200) NULL
ALTER TABLE bb_blood_bag ADD `lab_otbresult` varchar(15) NULL
ALTER TABLE bb_blood_bag ADD `bb_blood_symptom` varchar(30) NULL
ALTER TABLE bb_blood_bag ADD `bb_blood_bps` double(5,2) NULL
ALTER TABLE bb_blood_bag ADD `bb_blood_bpd` double(5,2) NULL
CREATE TABLE ipt_cancel_log ( `ipt_cancel_log_id` int NOT NULL )
Checking structure phase 1
Update primary key on table xray_report_film Done.
alter table tmp_pk rename to `xray_report_film`
drop table `xray_report_film`
Made permanent change on table xray_report_film
Create temp primary key table from xray_report_film
Update primary key on table opdscreen_bp Done.
alter table tmp_pk rename to `opdscreen_bp`
drop table `opdscreen_bp`
Made permanent change on table opdscreen_bp
Create temp primary key table from opdscreen_bp
Update primary key on table iptbedmove Done.
alter table tmp_pk rename to `iptbedmove`
drop table `iptbedmove`
Made permanent change on table iptbedmove
Create temp primary key table from iptbedmove
Table opdscreen has hos_guid
Table patient has hos_guid
Table ovst has hos_guid
Table opitemrece has hos_guid
Update hosxp_dll_field data ...
Upgrade MySQL Start
หัวข้อ: HOSxP 3.54.9.22 มาแล้วครับ (อ่าน 12977 ครั้ง)