ALTER TABLE physic_items ADD `price3` double(15,3) NULL
ALTER TABLE physic_items ADD `price2` double(15,3) NULL
ALTER TABLE physic_items ADD `active_status` char(1) NULL
ALTER TABLE person_wbc ADD `baby_no` int NULL
ALTER TABLE ovst_presc_ned ADD `presc_reason_5` varchar(250) NULL
ALTER TABLE ovst_presc_ned ADD `presc_reason_4` varchar(250) NULL
ALTER TABLE ovst_presc_ned ADD `presc_reason_3` varchar(250) NULL
ALTER TABLE operation_detail ADD `biopsy` char(1) NULL
ALTER TABLE operation_detail ADD `ovst_oper_type` int NULL
ALTER TABLE operation_detail ADD `oper_type` int NULL
ALTER TABLE opdrent ADD `link_vn` varchar(12) NULL
ALTER TABLE oapp_limit ADD `check_time` char(1) NULL
ALTER TABLE oapp_limit ADD `end_time` time NULL
ALTER TABLE oapp_limit ADD `start_time` time NULL
ALTER TABLE medication_reconciliation_detail ADD `usage_name` varchar(250) NULL
ALTER TABLE lab_items ADD `confirm_order_text` varchar(250) NULL
ALTER TABLE ipt_labour_vaccine ADD `doctor_code` varchar(10) NULL
ALTER TABLE ipt_labour_vaccine ADD `vaccine_lotno` varchar(50) NULL
ALTER TABLE ipt_labour_vaccine ADD `vaccine_expire_date` date NULL
ALTER TABLE ipt_labour_vaccine ADD `wbc_vaccine_id` int NOT NULL
ALTER TABLE ipt_labour_vaccine ADD `ipt_labour_id` int NOT NULL
ALTER TABLE ipt_home_stay_detail ADD `remark` varchar(200) NULL
ALTER TABLE ipt_home_stay_detail ADD `end_date` date NULL
ALTER TABLE ipt_home_stay_detail ADD `begin_date` date NULL
ALTER TABLE ipt_home_stay_detail ADD `an` varchar(9) NOT NULL
ALTER TABLE house_googlemaps_image ADD `house_googlemaps_blob` longblob NULL
ALTER TABLE house_googlemaps_image ADD `house_id` int NOT NULL
ALTER TABLE dttm ADD `dent2006_item_code` varchar(50) NULL
ALTER TABLE drugusage ADD `ipt_injection_sticker_count` int NULL
ALTER TABLE drugitems_register_unique ADD `un_spsc` varchar(35) NULL
ALTER TABLE drugitems_register_unique ADD `std_code` varchar(35) NULL
ALTER TABLE drugitems_register_unique ADD `country` varchar(100) NULL
ALTER TABLE drugitems_register_unique ADD `manufacturer` varchar(100) NULL
ALTER TABLE drugitems_register_unique ADD `strength` varchar(100) NULL
ALTER TABLE drugitems_register_unique ADD `drugname` varchar(150) NULL
ALTER TABLE drugitems_register_unique ADD `unit` varchar(50) NULL
ALTER TABLE drugitems_register_unique ADD `dgdsfnm` varchar(100) NULL
ALTER TABLE drugitems_register_unique ADD `dosage_form` varchar(100) NULL
ALTER TABLE drugitems_register_unique ADD `tradename` varchar(250) NULL
ALTER TABLE drugitems_register_unique ADD `comp` varchar(150) NULL
ALTER TABLE drugitems_register_unique ADD `gpocheck` varchar(20) NULL
ALTER TABLE drugitems_register_unique ADD `gpocode` varchar(15) NULL
ALTER TABLE drugitems_register_unique ADD `t_code` varchar(20) NOT NULL
ALTER TABLE drugitems_register_unique ADD `regno` varchar(20) NOT NULL
ALTER TABLE drugitems_property ADD `group_code` varchar(50) NULL
ALTER TABLE drugitems ADD `print_ipd_injection_sticker` char(1) NULL
ALTER TABLE dent2006_item ADD `dent2006_item_name` varchar(250) NULL
CREATE TABLE ipt_labour_vaccine ( `ipt_labour_vaccine_id` int NOT NULL )
CREATE TABLE ipt_home_stay_detail ( `ipt_home_stay_detail_id` int NOT NULL )
CREATE TABLE house_googlemaps_image ( `house_googlemaps_image_id` int NOT NULL )
CREATE TABLE drugitems_register_unique ( `drugitems_register_id` int NOT NULL )
CREATE TABLE drugallergy_no_alert ( `allergy_name` varchar(200) NULL )
CREATE TABLE dent2006_item ( `dent2006_item_code` varchar(50) 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 version 3.53.12.16 (อ่าน 20306 ครั้ง)