20
« เมื่อ: พฤษภาคม 18, 2016, 09:30:41 AM »
ไม่ได้ตรวจสอบครับ รายการตารางที่เคลียร์มีดังนี้
delete from stock;
delete from stock_adj_item_list;
delete from stock_adjust_detail;
delete from stock_adjust_item;
delete from stock_bestow;
delete from stock_bestow_item;
delete from stock_bestow_list;
delete from stock_bestow_return;
delete from stock_bestow_return_item;
delete from stock_bestow_return_list;
delete from stock_borrow;
delete from stock_borrow_item;
delete from stock_borrow_return;
delete from stock_borrow_return_item;
delete from stock_borrow_return_list;
delete from stock_borrow_status_remark;
delete from stock_budget_detail;
delete from stock_budget_list;
delete from stock_capital_cost;
delete from stock_capital_cost_detail;
delete from stock_card;
delete from stock_cary_forward;
delete from stock_check_warehouse_detail;
delete from stock_check_warehouse_head;
delete from stock_cheque_check;
delete from stock_cheque_check_detail;
delete from stock_cheque_check_head;
delete from stock_cheque_detail;
delete from stock_cheque_head;
delete from stock_cheque_list;
delete from stock_class;
delete from stock_co_po_detail;
delete from stock_co_po_type;
delete from stock_committee;
delete from stock_committee_detail;
delete from stock_committee_group;
delete from stock_committee_position;
delete from stock_cutpay;
delete from stock_cutpay_item;
delete from stock_cutpay_list;
delete from stock_deliver;
delete from stock_deliver_detail;
delete from stock_department_item;
delete from stock_department_item_level;
delete from stock_department_route;
delete from stock_department_type;
delete from stock_draw;
delete from stock_draw_item;
delete from stock_draw_list;
delete from stock_drug_item;
delete from stock_employee;
delete from stock_employee_salary;
delete from stock_expire;
delete from stock_item_balance_history;
delete from stock_item_history;
delete from stock_item_list;
delete from stock_item_month_rate;
delete from stock_item_regist;
delete from stock_item_remain;
delete from stock_item_standard;
delete from stock_item_type_price;
delete from stock_labor_cost;
delete from stock_labor_cost_detail;
delete from stock_listdrawpay;
delete from stock_listdrawpay_detail;
delete from stock_manual_detail;
delete from stock_manual_head;
delete from stock_manual_item;
delete from stock_mastercommittee;
delete from stock_mastercommitteeposition;
delete from stock_material_cost;
delete from stock_material_cost_detail;
delete from stock_opitemrece;
delete from stock_opitemrece_err;
delete from stock_opitemrece_list;
delete from stock_ovst;
delete from stock_plan;
delete from stock_plan_list;
delete from stock_po;
delete from stock_po_committee;
delete from stock_po_detail;
delete from stock_po_special;
delete from stock_po_special_committee;
delete from stock_po_special_detail;
delete from stock_project;
delete from stock_project_plan;
delete from stock_proviso;
delete from stock_proviso_item;
delete from stock_register_inventory;
delete from stock_remain_summary;
delete from stock_request;
delete from stock_request_committee;
delete from stock_request_list;
delete from stock_request_subject;
delete from stock_request_subject_person;
delete from stock_return;
delete from stock_return_cutpay;
delete from stock_return_cutpay_list;
delete from stock_return_item;
delete from stock_return_list;
delete from stock_return_stock;
delete from stock_return_stock_item;
delete from stock_salary_type;
delete from stock_setting_abc;
delete from stock_setting_detail_point;
delete from stock_setting_document;
delete from stock_setting_document_detail;
delete from stock_setting_document_type;
delete from stock_setting_document_type_detail;
delete from stock_setting_inventory;
delete from stock_snapshot_detail;
delete from stock_snapshot_head;
delete from stock_subcard;
delete from stock_subdraw;
delete from stock_subdraw_department;
delete from stock_subdraw_department_list;
delete from stock_subdraw_list;
delete from stock_subdraw_type;
delete from stock_substock_detail;
delete from stock_summary;
delete from stock_supplier_item;
delete from stock_supplier_parent;
delete from stock_test;
delete from stock_trancation;
delete from stock_trancation_itemdata;
delete from stock_transfer_draw;
delete from stock_transfer_draw_item;
delete from stock_transfer_draw_list;
delete from stock_warehouse_adj_detail;
delete from stock_warehouse_adj_head;
delete from stock_warehouse_check;
delete from stock_warehouse_room;
delete from stock_warehouse_sub_department;
delete from stockcard;
delete from stockin;
update stock_item_unit set rate_1_month=0,rate_3_month=0,rate_12_month=0,rate_1_month_lastyear=0,empty_in_day=0,
age_1_year=0,age_2_year=0,age_3_year=0,age_4_year=0,age_5_year=0,age_morethan_5_year=0,current_qty=0,po_wait_qty=0;
update stock_item set unit_cost=0;
update stock_item_unit set last_active_date="";
update stock_item set unit_cost = " ";
ขอคำชี้แนะ และวิธีแก้ไขครับ