Checking structure phase 2
ALTER TABLE oapp_pending_log ADD `pending_datetime` datetime NULL
ALTER TABLE oapp_pending_log ADD `staff` varchar(50) NULL
ALTER TABLE oapp_pending_log ADD `pending_reason` varchar(150) NULL
ALTER TABLE oapp_pending_log ADD `new_nexttime` time NULL
ALTER TABLE oapp_pending_log ADD `new_nextdate` date NULL
ALTER TABLE oapp_pending_log ADD `old_nexttime` time NULL
ALTER TABLE oapp_pending_log ADD `old_nextdate` date NULL
ALTER TABLE oapp_pending_log ADD `oapp_id` int NOT NULL
ALTER TABLE kskdepartment ADD `depcode_active` char(1) NULL
ALTER TABLE ipt_er_list ADD `doctor` varchar(7) NULL
ALTER TABLE ipt_er_list ADD `er_pt_type` int NULL
ALTER TABLE ipt_er_list ADD `er_emergency_type` int NULL
ALTER TABLE ipt_er_list ADD `er_period` int NULL
ALTER TABLE ipt_er_list ADD `oper_list` varchar(250) NULL
ALTER TABLE ipt_er_list ADD `er_oper_status_id` int NULL
ALTER TABLE ipt_er_list ADD `receive_datetime` datetime NULL
ALTER TABLE ipt_er_list ADD `receive_staff` varchar(50) NULL
ALTER TABLE ipt_er_detail ADD `end_time` datetime NULL
ALTER TABLE ipt_er_detail ADD `begin_time` datetime NULL
ALTER TABLE ipt_er_detail ADD `doctor` varchar(7) NULL
ALTER TABLE ipt_er_detail ADD `unitprice` double(15,3) NULL
ALTER TABLE ipt_er_detail ADD `qty` int NULL
ALTER TABLE ipt_er_detail ADD `opi_guid` varchar(38) NULL
ALTER TABLE er_oper_status ADD `er_oper_status_name` varchar(150) NOT NULL
ALTER TABLE doctor_sound_record ADD `elapsed_time` int NULL
ALTER TABLE doctor_sound_record ADD `record_data` longblob NULL
ALTER TABLE doctor_sound_record ADD `record_format` varchar(10) NULL
ALTER TABLE doctor_sound_record ADD `record_datetime` datetime NULL
ALTER TABLE doctor_sound_record ADD `doctor_code` varchar(7) NULL
ALTER TABLE doctor_sound_record ADD `vn` varchar(13) NOT NULL
CREATE TABLE oapp_pending_log ( `oapp_pending_log_id` int NOT NULL )
CREATE TABLE er_oper_status ( `er_oper_status_id` int NOT NULL )
CREATE TABLE doctor_sound_record ( `doctor_sound_record_id` int NOT NULL )
Checking structure phase 1
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.51.7.24 (อ่าน 11093 ครั้ง)