โหลดแล้ว อัพแล้ว
Checking structure phase 2
ALTER TABLE xray_items_doctor ADD `doctor` varchar(9) NOT NULL
ALTER TABLE xray_items_doctor ADD `xray_items_code` int NOT NULL
ALTER TABLE wbc_vaccine ADD `vaccine_in_use` char(1) NULL
ALTER TABLE wbc_transfer ADD `wbc_transfer_name` varchar(150) NOT NULL
ALTER TABLE village_student_vaccine_list ADD `epi_autistic_screen_type_id` int NULL
ALTER TABLE village_student_vaccine_list ADD `vaccine_expire_date` date NULL
ALTER TABLE village_student_vaccine_list ADD `vaccine_lotno` varchar(50) NULL
ALTER TABLE universal_item_value_list ADD `hos_guid` varchar(38) NULL
ALTER TABLE universal_item_value_list ADD `universal_item_value_name` varchar(200) NOT NULL
ALTER TABLE universal_item_value_list ADD `universal_item_value_code` varchar(150) NOT NULL
ALTER TABLE universal_item_value_list ADD `universal_item_id` int NOT NULL
ALTER TABLE universal_item_class ADD `hos_guid` varchar(38) NULL
ALTER TABLE universal_item ADD `hos_guid` varchar(38) NULL
ALTER TABLE universal_form_design ADD `hos_guid` varchar(38) NULL
ALTER TABLE universal_form_design ADD `parent` varchar(150) NULL
ALTER TABLE universal_form_design ADD `universal_object_name` varchar(150) NULL
ALTER TABLE universal_form_design ADD `onexit_script` longtext NULL
ALTER TABLE universal_form_design ADD `onenter_script` longtext NULL
ALTER TABLE universal_form_design ADD `onclick_script` longtext NULL
ALTER TABLE universal_form_department ADD `depcode` varchar(3) NOT NULL
ALTER TABLE universal_form_department ADD `universal_form_id` int NOT NULL
ALTER TABLE universal_form ADD `hos_guid` varchar(38) NULL
ALTER TABLE universal_form ADD `form_height` int NULL
ALTER TABLE universal_form ADD `form_width` int NULL
ALTER TABLE universal_form ADD `form_script_onsave` longtext NULL
ALTER TABLE universal_form ADD `form_script_onload` longtext NULL
ALTER TABLE universal_detail_subvalue ADD `universal_item_value_list_id` int NULL
ALTER TABLE universal_detail_subvalue ADD `universal_subitem_value` varchar(150) NOT NULL
ALTER TABLE universal_detail_subvalue ADD `universal_detail_id` int NOT NULL
ALTER TABLE universal_detail ADD `universal_item_value_memo` text NULL
ALTER TABLE physic_group_doctor ADD `doctor` varchar(9) NOT NULL
ALTER TABLE physic_group_doctor ADD `physic_group_id` int NOT NULL
ALTER TABLE person_wbc_vaccine_abnormal ADD `abnormal_text` varchar(250) NULL
ALTER TABLE person_wbc_vaccine_abnormal ADD `person_wbc_service_id` int NOT NULL
ALTER TABLE person_wbc_service_detail ADD `vaccine_expire_date` date NULL
ALTER TABLE person_wbc_service_detail ADD `vaccine_lotno` varchar(50) NULL
ALTER TABLE person_epi_vaccine_list ADD `vaccine_expire_date` date NULL
ALTER TABLE person_epi_vaccine_list ADD `vaccine_lotno` varchar(50) NULL
ALTER TABLE person_epi_vaccine ADD `wbc_development_assess_id` int NULL
ALTER TABLE person_epi_vaccine ADD `wbc_transfer_id` int NULL
ALTER TABLE person_epi ADD `person_epi_no` varchar(20) NULL
ALTER TABLE opi_usage_unit_code ADD `usage_unit_name` varchar(150) NOT NULL
ALTER TABLE opi_usage_code ADD `usage_line4` varchar(200) NULL
ALTER TABLE opi_usage_code ADD `usage_line3` varchar(200) NULL
ALTER TABLE opi_usage_code ADD `usage_line2` varchar(200) NULL
ALTER TABLE opi_usage_code ADD `usage_line1` varchar(200) NULL
ALTER TABLE opi_time_code ADD `time_name` varchar(150) NOT NULL
ALTER TABLE opi_frequency_code ADD `qty_per_day` double(15,3) NULL
ALTER TABLE opi_frequency_code ADD `frequency_name` varchar(200) NOT NULL
ALTER TABLE opi_dose_usage_unit ADD `dose_usage_unit_name` varchar(150) NOT NULL
ALTER TABLE opi_dose_usage_unit ADD `dose` double(15,3) NULL
ALTER TABLE opi_dose_usage_unit ADD `usage_unit_code` varchar(10) NULL
ALTER TABLE opi_dispense ADD `usage_shortlist` varchar(150) NULL
ALTER TABLE opi_dispense ADD `usage_line4` varchar(150) NULL
ALTER TABLE opi_dispense ADD `usage_line3` varchar(150) NULL
ALTER TABLE opi_dispense ADD `usage_line2` varchar(150) NULL
ALTER TABLE opi_dispense ADD `usage_line1` varchar(150) NULL
ALTER TABLE opi_dispense ADD `doctor` varchar(9) NULL
ALTER TABLE opi_dispense ADD `usage_unit_code` varchar(10) NULL
ALTER TABLE opi_dispense ADD `sp_use` varchar(9) NULL
ALTER TABLE opi_dispense ADD `price` double(15,3) NULL
ALTER TABLE opi_dispense ADD `print_sticker` char(1) NULL
ALTER TABLE opi_dispense ADD `modify_computer` varchar(30) NULL
ALTER TABLE opi_dispense ADD `modify_staff` varchar(25) NULL
ALTER TABLE opi_dispense ADD `modify_datetime` datetime NULL
ALTER TABLE opi_dispense ADD `drug_hint_text` varchar(150) NULL
ALTER TABLE opi_dispense ADD `time_code` varchar(10) NULL
ALTER TABLE opi_dispense ADD `frequency_code` varchar(10) NULL
ALTER TABLE opi_dispense ADD `unit_name` varchar(25) NULL
ALTER TABLE opi_dispense ADD `dose` double(15,3) NULL
ALTER TABLE opi_dispense ADD `usage_code` varchar(10) NULL
ALTER TABLE opi_dispense ADD `qty` double(15,3) NULL
ALTER TABLE opi_dispense ADD `icode` varchar(7) NOT NULL
ALTER TABLE opi_dispense ADD `hos_guid` varchar(38) NOT NULL
ALTER TABLE ipt_labour_infant ADD `birth_asphyxia` text NULL
ALTER TABLE infant_dchstts ADD `name` varchar(150) NOT NULL
ALTER TABLE epi_vaccine ADD `vaccine_in_use` char(1) NULL
ALTER TABLE drugusage ADD `drugusage_active` char(1) NULL
ALTER TABLE drugusage MODIFY COLUMN `idrlink` varchar(100)
ALTER TABLE drugusage MODIFY COLUMN `shortlist` varchar(250)
ALTER TABLE drugitems ADD `dose_per_units` double(15,3) NULL
ALTER TABLE drugitems ADD `usage_unit_code` varchar(10) NULL
ALTER TABLE drugitems ADD `dispense_dose` double(15,3) NULL
ALTER TABLE drugitems ADD `time_code` varchar(10) NULL
ALTER TABLE drugitems ADD `frequency_code` varchar(10) NULL
ALTER TABLE drugitems ADD `usage_code` varchar(10) NULL
ALTER TABLE doctor ADD `name_soundex` varchar(150) NULL
CREATE TABLE xray_items_doctor ( `xray_items_doctor_id` int NOT NULL )
CREATE TABLE wbc_transfer ( `wbc_transfer_id` int NOT NULL )
CREATE TABLE universal_item_value_list ( `universal_item_value_list_id` int NOT NULL )
CREATE TABLE universal_form_department ( `universal_form_department_id` int NOT NULL )
CREATE TABLE universal_detail_subvalue ( `universal_detail_subvalue_id` int NOT NULL )
CREATE TABLE physic_group_doctor ( `physic_group_doctor_id` int NOT NULL )
CREATE TABLE person_wbc_vaccine_abnormal ( `person_wbc_vaccine_abnormal_id` int NOT NULL )
CREATE TABLE opi_usage_unit_code ( `usage_unit_code` varchar(10) NOT NULL )
CREATE TABLE opi_usage_code ( `usage_code` varchar(10) NOT NULL )
CREATE TABLE opi_time_code ( `time_code` varchar(10) NOT NULL )
CREATE TABLE opi_frequency_code ( `frequency_code` varchar(10) NOT NULL )
CREATE TABLE opi_dose_usage_unit ( `opi_dose_usage_unit_id` int NOT NULL )
CREATE TABLE opi_dispense ( `opi_dispense_id` int NOT NULL )
CREATE TABLE infant_dchstts ( `dchstts` varchar(2) 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
Upgrade MySQL Done.
End at 10/02/2552 10:10:06
Checking Serial Number