กำลัง Update structure อยู่เลยครับ ใช้ไอ้ตั๊กให้เยอะ ๆ หน่อยครับเดี๋ยวฟุ้งซ่าน...5555
ALTER TABLE xray_pack ADD `pack_accession_no` int NOT NULL
ALTER TABLE person_anc ADD `dental_tx_date` date NULL
ALTER TABLE labour_sac_type ADD `labour_sac_type_name` varchar(250) NOT NULL
ALTER TABLE labour_deliver_abnormal_type ADD `labour_deliver_abnormal_name` varchar(150) NOT NULL
ALTER TABLE labour_amniotic_type ADD `labour_amniotic_type_name` varchar(250) NOT NULL
ALTER TABLE labor ADD `labour_cervical_date` date NULL
ALTER TABLE labor ADD `labour_cervical_time` time NULL
ALTER TABLE labor ADD `labour_cervical_3cm_date` date NULL
ALTER TABLE labor ADD `labour_cervical_3cm_time` time NULL
ALTER TABLE labor ADD `entry_staff` varchar(25) NULL
ALTER TABLE labor ADD `sulture_doctor` varchar(9) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `labour_sac_type_id` int NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `labour_amniotic_type_id` int NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `station` varchar(10) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `eff` double(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `cervical_open_size` double(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `fetal_heart_sound` varchar(200) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `pe_abdomen` varchar(200) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `pe_heart` varchar(200) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `pe_lung` varchar(200) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `hr` int NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `rr` int NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `bpd` double(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `bps` double(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `height` double(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `temperature` double(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `bw` double(15,3) NULL
ALTER TABLE ipt_labour_infant ADD `entry_staff` varchar(50) NULL
ALTER TABLE ipt_labour_infant ADD `labour_doctor` varchar(9) NULL
ALTER TABLE ipt_labour ADD `entry_staff` varchar(50) NULL
CREATE TABLE xray_pack ( `xn` int NOT NULL )
CREATE TABLE labour_sac_type ( `labour_sac_type_id` int NOT NULL )
CREATE TABLE labour_deliver_abnormal_type ( `labour_deliver_abnormal_type` int NOT NULL )
CREATE TABLE labour_amniotic_type ( `labour_amniotic_type_id` int NOT NULL )
CREATE TABLE ipt_pregnancy_vital_sign ( `an` varchar(9) NOT NULL )
CREATE TABLE icd10_nhso ( `code` varchar(9) 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