คำเตือน !!!
มีการปรับโครงสร้างตาราง opdscreen อาจใช้เวลานานในการ upgrade structure
ALTER TABLE xray_report_film ADD `opi_guid` varchar(38) NULL
ALTER TABLE xray_report_film ADD `film_price` double(15,3) NULL
ALTER TABLE xray_report ADD `confirm_read_time` time NULL
ALTER TABLE xray_report ADD `confirm_read_date` date NULL
ALTER TABLE xray_report ADD `accept_time` time NULL
ALTER TABLE xray_report ADD `accept_date` date NULL
ALTER TABLE xray_report ADD `xray_items_service_type_id` int NULL
ALTER TABLE xray_rent ADD `return_staff` varchar(50) NULL
ALTER TABLE xray_rent ADD `staff` varchar(200) NULL
ALTER TABLE xray_rent ADD `due_date` date NULL
ALTER TABLE xray_rent ADD `xray_rent_reason_id` int NULL
ALTER TABLE xray_rent ADD `rent_doctor` varchar(10) NULL
ALTER TABLE xray_head ADD `service_type_name_list` varchar(200) NULL
ALTER TABLE xray_head ADD `xray_film_flag` int NULL
ALTER TABLE xray_head ADD `xray_head_flag` int NULL
ALTER TABLE visit_pttype ADD `pttype_service_charge` char(1) NULL
ALTER TABLE visit_pttype ADD `emp_id` int NULL
ALTER TABLE visit_pttype ADD `emp_privilege` char(1) NULL
ALTER TABLE s_drugitems ADD `is_medication` char(1) NULL
ALTER TABLE referout ADD `refer_in_region` char(1) NULL
ALTER TABLE referout ADD `refer_in_province` char(1) NULL
ALTER TABLE referin ADD `referin_id` int NULL
ALTER TABLE referin ADD `referout_number` varchar(100) NULL
ALTER TABLE referin ADD `referin_number` varchar(100) NULL
ALTER TABLE rcpt_print ADD `deposit_debit_amount` double(15,3) NULL
ALTER TABLE rcpt_print ADD `cash_amount` double(15,3) NULL
ALTER TABLE rcpt_debt ADD `status` varchar(10) NULL
ALTER TABLE rcpt_debt ADD `department` char(3) NULL
ALTER TABLE person_anc_other_precare ADD `anc_result` int NULL
ALTER TABLE ovstdiag ADD `dx_guid` varchar(38) NULL
ALTER TABLE ovst_seq ADD `finance_status_flag` int NULL
ALTER TABLE ovst_presc_ned ADD `opi_guid` varchar(38) NULL
ALTER TABLE opi_dispense ADD `pttype_items_price_id` int NULL
ALTER TABLE opi_dispense ADD `opi_dispense_his_name` varchar(100) NULL
ALTER TABLE opi_dispense ADD `opi_dispense_usage_type_id` int NULL
ALTER TABLE opi_dispense ADD `opi_dispense_qty_type_id` int NULL
ALTER TABLE opi_dispense ADD `opi_dispense_item_type_id` int NULL
ALTER TABLE operation_list ADD `dx_note` text NULL
ALTER TABLE opdscreen_bp ADD `depcode` char(3) NULL
ALTER TABLE opdscreen ADD `g6pd` char(1) NULL
ALTER TABLE opdscreen ADD `pe_skin_text` varchar(100) NULL
ALTER TABLE opdscreen ADD `pe_skin` char(1) NULL
ALTER TABLE opdscreen ADD `pe_head_text` varchar(100) NULL
ALTER TABLE opdscreen ADD `pe_head` char(1) NULL
ALTER TABLE opdscreen ADD `bsa` double(15,3) NULL
ALTER TABLE oapp_xray ADD `xray_note` varchar(200) NULL
ALTER TABLE oapp ADD `perform_text` text NULL
ALTER TABLE nondrugitems ADD `extra_unitcost` double(15,3) NULL
ALTER TABLE lab_status ADD `lab_order_flag` int NULL
ALTER TABLE lab_head ADD `hospital_department_id` int NULL
ALTER TABLE lab_app_order_service ADD `opi_guid` varchar(38) NULL
ALTER TABLE lab_app_order ADD `lab_items_normal_value_ref` varchar(200) NULL
ALTER TABLE lab_app_order ADD `lab_items_name_ref` varchar(150) NULL
ALTER TABLE lab_app_order ADD `order_type` char(1) NULL
ALTER TABLE lab_app_head ADD `lab_priority_id` int NULL
ALTER TABLE lab_app_head ADD `hospital_department_id` int NULL
ALTER TABLE lab_app_head ADD `finance_lab_confirm` char(1) NULL
ALTER TABLE lab_app_head ADD `confirm_charge_money` char(1) NULL
ALTER TABLE lab_app_head ADD `lab_perform_status_id` int NULL
ALTER TABLE ipt_pttype ADD `finance_clear_ok` char(1) NULL
ALTER TABLE ipt ADD `finance_status_flag` int NULL
ALTER TABLE ipt ADD `cur_dep_code` char(3) NULL
ALTER TABLE er_regist_oper ADD `opi_guid` varchar(38) NULL
ALTER TABLE dtmain ADD `dx_guid` varchar(38) NULL
ALTER TABLE drugitems ADD `drugitems_due_type_id` int NULL
ALTER TABLE drugitems ADD `need_order_reason` char(1) NULL
ALTER TABLE drugitems ADD `capacity_qty` double(15,3) NULL
ALTER TABLE drugitems ADD `prefer_opd_usage_code` char(1) NULL
ALTER TABLE drugitems ADD `max_qty` int NULL
ALTER TABLE drugitems ADD `no_order_gender` char(1) NULL
ALTER TABLE drugitems ADD `gender_check` char(1) NULL
ALTER TABLE drugitems ADD `no_order_g6pd` char(1) NULL
ALTER TABLE drugitems ADD `active_ingredient_mg` double(15,3) NULL
ALTER TABLE drugitems ADD `name_print` varchar(100) NULL
ALTER TABLE drugitems ADD `drug_control_type_id` int NULL
ALTER TABLE drugitems ADD `extra_unitcost` double(15,3) NULL
ALTER TABLE drugitems ADD `finish_reason` varchar(100) NULL
ALTER TABLE drugitems ADD `capacity_name` varchar(100) NULL
ALTER TABLE drugitems ADD `name_eng` varchar(100) NULL
ALTER TABLE drugitems ADD `name_pr` varchar(100) NULL
ALTER TABLE drugitems ADD `finish_date` date NULL
ALTER TABLE drugitems ADD `begin_date` date NULL
ALTER TABLE drugitems ADD `sks_claim_control_type_id` int NULL
ALTER TABLE doctor_operation ADD `update_datetime` datetime NULL
ALTER TABLE doctor_operation ADD `staff` varchar(25) NULL
ALTER TABLE death ADD `staff` varchar(50) NULL
ALTER TABLE death ADD `update_datetime` datetime NULL
หัวข้อ: hosxp.net/bms/HOSxP_Upgrade_3.57.5.23.exe (อ่าน 6389 ครั้ง)