สังเกตตอน upgrade มี SQL ERROR
Import table : village_market_type
SQL Error: Multiple primary key defined
ALTER IGNORE TABLE stock_item_warehouse add primary key (stock_item_warehouse_id)
ALTER IGNORE TABLE stock_item_warehouse MODIFY stock_item_warehouse_id int NOT NULL
SQL Error: Multiple primary key defined
ALTER IGNORE TABLE risk_screen_head add primary key (risk_screen_head_id)
ALTER IGNORE TABLE risk_screen_head MODIFY risk_screen_head_id int NOT NULL
SQL Error: Multiple primary key defined
ALTER IGNORE TABLE clinicmember add primary key (clinicmember_id)
ALTER IGNORE TABLE clinicmember MODIFY clinicmember_id int NOT NULL
SQL Error: Multiple primary key defined
ALTER IGNORE TABLE clinic_subtype add primary key (clinic_subtype_id)
ALTER IGNORE TABLE clinic_subtype MODIFY clinic_subtype_id int NOT NULL
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL' at line 1
ALTER ignore TABLE risk_screen_lab ADD `risk_screen_lab_result` double(22,) NULL
delete from hosxp_ddl_index
delete from hosxp_ddl_field
หัวข้อ: HOSxP PCU 3.53.9.21 บันทึกส่งตรวจไม่ได้ (อ่าน 9150 ครั้ง)