หายไปนานเลย
ตารางที่สร้าง
ALTER TABLE stockconfig ADD `stock_hospitalname` varchar(100) NULL
ALTER TABLE stock_warehouse ADD `warehouse_issue_position` varchar(250) NULL
ALTER TABLE stock_warehouse ADD `warehouse_issue_name` varchar(250) NULL
ALTER TABLE stock_transfer_draw ADD `stock_subdraw_department_id` int NULL
ALTER TABLE stock_supplier_parent ADD `stock_supplieta_parent_tel` varchar(100) NULL
ALTER TABLE stock_supplier_parent ADD `stock_supplier_parent_address` varchar(200) NULL
ALTER TABLE stock_supplier_parent ADD `stock_supplier_parent_name` varchar(100) NULL
ALTER TABLE stock_supplier_item ADD `item_barcode` varchar(30) NULL
ALTER TABLE stock_supplier_item ADD `item_refno` varchar(50) NULL
ALTER TABLE stock_supplier ADD `stock_supplier_parent_id` int NULL
ALTER TABLE stock_summary ADD `summary_no` varchar(20) NULL
ALTER TABLE stock_subdraw_department_list ADD `remain_subdraw_qty` int NULL
ALTER TABLE stock_subdraw_department_list ADD `department_qty` int NULL
ALTER TABLE stock_subdraw_department_list ADD `item_price` double(11,8) NULL
ALTER TABLE stock_subdraw_department_list ADD `item_qty` int NULL
ALTER TABLE stock_subdraw_department_list ADD `remain_qty` int NULL
ALTER TABLE stock_subdraw_department_list ADD `stock_package_qty` int NULL
ALTER TABLE stock_subdraw_department_list ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_subdraw_department_list ADD `item_id` int NULL
ALTER TABLE stock_subdraw_department_list ADD `stock_subdraw_department_id` int NULL
ALTER TABLE stock_subdraw_department ADD `stock_subdraw_status` char(1) NULL
ALTER TABLE stock_subdraw_department ADD `subdraw_note` varchar(300) NULL
ALTER TABLE stock_subdraw_department ADD `total_price` double(15,8) NULL
ALTER TABLE stock_subdraw_department ADD `item_count` int NULL
ALTER TABLE stock_subdraw_department ADD `stock_user_officer_name` varchar(100) NULL
ALTER TABLE stock_subdraw_department ADD `stock_user_id` int NULL
ALTER TABLE stock_subdraw_department ADD `department_id_issue` int NULL
ALTER TABLE stock_subdraw_department ADD `department_id_receive` int NULL
ALTER TABLE stock_subdraw_department ADD `stock_subdraw_department_no` varchar(20) NULL
ALTER TABLE stock_subdraw_department ADD `stock_subdraw_department_date` date NULL
ALTER TABLE stock_subdraw ADD `stock_user_id` int NULL
ALTER TABLE stock_return_list ADD `total_price` double(15,8) NULL
ALTER TABLE stock_return ADD `stock_user_id` int NULL
ALTER TABLE stock_request ADD `budget_id` int NULL
ALTER TABLE stock_request ADD `transport_day` int NULL
ALTER TABLE stock_request ADD `note` varchar(200) NULL
ALTER TABLE stock_register_inventory ADD `reg_datedemo` date NULL
ALTER TABLE stock_register_inventory ADD `note` varchar(200) NULL
ALTER TABLE stock_register_inventory ADD `number` int NULL
ALTER TABLE stock_register_inventory ADD `reg_hoscode` varchar(10) NULL
ALTER TABLE stock_register_inventory ADD `reg_startdate` date NULL
ALTER TABLE stock_register_inventory ADD `reg_type` varchar(10) NULL
ALTER TABLE stock_register_inventory ADD `reg_happay` varchar(20) NULL
ALTER TABLE stock_register_inventory ADD `reg_hos` varchar(100) NULL
ALTER TABLE stock_register_inventory ADD `reg_bed` int NULL
ALTER TABLE stock_register_inventory ADD `reg_tel` varchar(100) NULL
ALTER TABLE stock_register_inventory ADD `reg_email` varchar(100) NULL
ALTER TABLE stock_register_inventory ADD `req_address` varchar(200) NULL
ALTER TABLE stock_register_inventory ADD `reg_name` varchar(150) NULL
ALTER TABLE stock_po_detail ADD `remain_qty` int NULL
ALTER TABLE stock_po_committee ADD `mastercommitteeposition_id` int NULL
ALTER TABLE stock_po ADD `stock_budget_price` double(15,8) NULL
ALTER TABLE stock_po ADD `stock_budget_remain` double(15,8) NULL
ALTER TABLE stock_po ADD `stock_budget_use` double(15,8) NULL
ALTER TABLE stock_po ADD `stock_user_id` int NULL
ALTER TABLE stock_po ADD `department_id` int NULL
ALTER TABLE stock_po ADD `transport_day` int NULL
ALTER TABLE stock_po ADD `stock_po_type` int NULL
ALTER TABLE stock_mastercommittee ADD `stock_committee_status` int NULL
ALTER TABLE stock_mastercommittee ADD `stock_committee__name` varchar(100) NULL
ALTER TABLE stock_manual_item ADD `difference_qty` int NULL
ALTER TABLE stock_item ADD `item_status_control` char(1) NULL
ALTER TABLE stock_draw_list ADD `draw_cancel` char(1) NULL
ALTER TABLE stock_draw_item ADD `warehouse_total_qty` int NULL
ALTER TABLE stock_draw ADD `stock_po_id` int NULL
ALTER TABLE stock_draw ADD `stock_user_id` int NULL
ALTER TABLE stock_draw ADD `draw_cancel` char(1) NULL
ALTER TABLE stock_department ADD `department_board_position2` varchar(150) NULL
ALTER TABLE stock_department ADD `department_board_position1` varchar(150) NULL
ALTER TABLE stock_department ADD `department_board_name2` varchar(150) NULL
ALTER TABLE stock_department ADD `department_board_name1` varchar(150) NULL
ALTER TABLE stock_department ADD `stock_department_type_id` int NULL
ALTER TABLE stock_deliver_detail ADD `reg_no` varchar(20) NULL
ALTER TABLE stock_deliver_detail ADD `item_unitprice` double(11,8) NULL
ALTER TABLE stock_deliver ADD `stock_user_id` int NULL
ALTER TABLE stock_deliver ADD `stock_ref_no` varchar(50) NULL
ALTER TABLE stock_cutpay_list ADD `transaction_datetime` datetime NULL
ALTER TABLE stock_committee_group ADD `stock_mastercommitteeposition_id` int NULL
ALTER TABLE stock_committee_detail ADD `stock_position_id` int NULL
ALTER TABLE stock_committee_detail ADD `stock_mastercommitteeposition_id` int NULL
ALTER TABLE stock_cary_forward ADD `cary_date` date NULL
ALTER TABLE stock_cary_forward ADD `cary_price` double(15,8) NULL
ALTER TABLE stock_cary_forward ADD `cary_qty` double(15,8) NULL
ALTER TABLE stock_cary_forward ADD `item_id` int NULL
ALTER TABLE stock_cary_forward ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_cary_forward ADD `warehouse_id` int NULL
ALTER TABLE stock_card ADD `string_unitname` varchar(30) NULL
ALTER TABLE stock_card ADD `unit_qty` int NULL
ALTER TABLE stock_card ADD `unit_total` int NULL
ALTER TABLE stock_card ADD `unit_out_qty` int NULL
ALTER TABLE stock_card ADD `unit_in_qty` int NULL
ALTER TABLE stock_borrow ADD `stock_user_id` int NULL
CREATE TABLE stock_supplier_parent ( `stock_supplier_parent_id` int NOT NULL )
CREATE TABLE stock_subdraw_department_list ( `stock_subdraw_department_list_id` int NOT NULL )
CREATE TABLE stock_subdraw_department ( `stock_subdraw_department_id` int NOT NULL )
CREATE TABLE stock_register_inventory ( `register_id` varchar(30) NOT NULL )
CREATE TABLE stock_mastercommittee ( `stock_mastercommittee_id` int NOT NULL )