HOSXP 3.52.1.30
Checking structure phase 2
ALTER TABLE xray_class_rent ADD `return_complete` char(1) NULL
ALTER TABLE xray_class_rent ADD `return_staff` varchar(25) NULL
ALTER TABLE xray_class_rent ADD `return_time` time NULL
ALTER TABLE xray_class_rent ADD `return_date` date NULL
ALTER TABLE women_service ADD `export_code` varchar(20) NULL
ALTER TABLE village_student_screen ADD `vn` varchar(13) NULL
ALTER TABLE stock_user_right ADD `stock_right_id` int NULL
ALTER TABLE stock_user_right ADD `stock_user_id` int NOT NULL
ALTER TABLE stock_user ADD `stock_user_position` varchar(150) NULL
ALTER TABLE stock_user ADD `loginname` varchar(100) NOT NULL
ALTER TABLE stock_right ADD `stock_right_name` varchar(250) NOT NULL
ALTER TABLE person_wbc_service ADD `transfer_other` char(1) NULL
ALTER TABLE person_epi_nutrition ADD `vn` varchar(13) NULL
ALTER TABLE ipt_labour_infant ADD `hr` double(15,3) NULL
ALTER TABLE ipt_labour_infant ADD `rr` double(15,3) NULL
ALTER TABLE ipt_labour_infant ADD `temperature` double(15,3) NULL
ALTER TABLE ipt_labour ADD `entry_datetime` datetime NULL
ALTER TABLE dtmain_area ADD `ext_code` varchar(150) NULL
CREATE TABLE stock_user_right ( `stock_user_right_id` int NOT NULL )
CREATE TABLE stock_user ( `stock_user_id` int NOT NULL )
CREATE TABLE stock_right ( `stock_right_id` int NOT NULL )
Checking structure phase 1
3.52.1.30B
Checking structure phase 2
ALTER TABLE village_student_screen ADD `vn` varchar(13) NULL
ALTER TABLE stock_user_right ADD `stock_right_id` int NULL
ALTER TABLE stock_user_right ADD `stock_user_id` int NOT NULL
ALTER TABLE stock_user ADD `stock_user_position` varchar(150) NULL
ALTER TABLE stock_user ADD `loginname` varchar(100) NOT NULL
ALTER TABLE stock_right ADD `stock_right_name` varchar(250) NOT NULL
ALTER TABLE stock_po ADD `pr_ref_no` varchar(100) NULL
ALTER TABLE stock_po ADD `delivery_ref_date` date NULL
ALTER TABLE stock_item ADD `item_code` varchar(25) NULL
ALTER TABLE stock_item ADD `unit_price` double(15,3) NULL
ALTER TABLE person_epi_nutrition ADD `vn` varchar(13) NULL
ALTER TABLE ipt_labour_infant ADD `hr` double(15,3) NULL
ALTER TABLE ipt_labour_infant ADD `rr` double(15,3) NULL
ALTER TABLE ipt_labour_infant ADD `temperature` double(15,3) NULL
ALTER TABLE ipt_labour ADD `entry_datetime` datetime NULL
ALTER TABLE dttm ADD `charge_area_qty` char(1) NULL
ALTER TABLE dtmain_area ADD `ext_code` varchar(150) NULL
CREATE TABLE stock_user_right ( `stock_user_right_id` int NOT NULL )
CREATE TABLE stock_user ( `stock_user_id` int NOT NULL )
CREATE TABLE stock_right ( `stock_right_id` int NOT NULL )
Checking structure phase 1
หัวข้อ: HOSXP 3.52.1.30 (อ่าน 17660 ครั้ง)