script untuk bersihkan database

SET FOREIGN_KEY_CHECKS=0;

truncate table	agronumt_kitchenware_dev.adjustment;
truncate table	agronumt_kitchenware_dev.adjustments_v2s;
truncate table	agronumt_kitchenware_dev.assemblies;
truncate table	agronumt_kitchenware_dev.assembly_updates;
truncate table	agronumt_kitchenware_dev.account_debts;
truncate table	agronumt_kitchenware_dev.alocations;
truncate table	agronumt_kitchenware_dev.admin_warehouse_commission;
truncate table	agronumt_kitchenware_dev.area_insentive;
truncate table	agronumt_kitchenware_dev.assignment_collectors;
truncate table	agronumt_kitchenware_dev.assignment_sms;
truncate table	agronumt_kitchenware_dev.attendances;
truncate table	agronumt_kitchenware_dev.balances_v2s;
truncate table	agronumt_kitchenware_dev.bonus_credit_sales;
truncate table	agronumt_kitchenware_dev.bundles;
truncate table	agronumt_kitchenware_dev.city_list;
truncate table	agronumt_kitchenware_dev.city_travel;
truncate table	agronumt_kitchenware_dev.claim_histories;
truncate table	agronumt_kitchenware_dev.claims;
truncate table	agronumt_kitchenware_dev.inventories;
truncate table	agronumt_kitchenware_dev.inventory_branches;
truncate table	agronumt_kitchenware_dev.inventory_histories;
truncate table	agronumt_kitchenware_dev.insentive;
truncate table	agronumt_kitchenware_dev.item_details;
truncate table	agronumt_kitchenware_dev.journal;
truncate table	agronumt_kitchenware_dev.journal_history;
truncate table	agronumt_kitchenware_dev.kasbon_histories;
truncate table	agronumt_kitchenware_dev.klaim_histories;
truncate table	agronumt_kitchenware_dev.office_spendings;
truncate table	agronumt_kitchenware_dev.order_plans;
truncate table	agronumt_kitchenware_dev.other_cost;
truncate table	agronumt_kitchenware_dev.other_cost_calculation;
truncate table	agronumt_kitchenware_dev.other_cost_calculation_details;
truncate table	agronumt_kitchenware_dev.other_cost_detail_calculations;
truncate table	agronumt_kitchenware_dev.other_cost_details;
truncate table	agronumt_kitchenware_dev.procurements;
truncate table	agronumt_kitchenware_dev.petty_cashes;
truncate table	agronumt_kitchenware_dev.petty_cash_histories;
truncate table	agronumt_kitchenware_dev.purchases;
truncate table	agronumt_kitchenware_dev.payroll_histories;
truncate table	agronumt_kitchenware_dev.payrolls;
truncate table	agronumt_kitchenware_dev.salary_component_main;
truncate table	agronumt_kitchenware_dev.salary_component_sub;
truncate table	agronumt_kitchenware_dev.sales;
truncate table	agronumt_kitchenware_dev.sales_trackers;
truncate table	agronumt_kitchenware_dev.salary_components;
truncate table	agronumt_kitchenware_dev.stock_in_v2s;
truncate table	agronumt_kitchenware_dev.stock_in_v3s;
truncate table	agronumt_kitchenware_dev.stock_opnames;
truncate table	agronumt_kitchenware_dev.stock_out_v2s;
truncate table	agronumt_kitchenware_dev.stock_out_v3s;
truncate table	agronumt_kitchenware_dev.stock_requests;
truncate table	agronumt_kitchenware_dev.schedules;
truncate table	agronumt_kitchenware_dev.suppliers;
truncate table	agronumt_kitchenware_dev.tax_adjustment;
truncate table	agronumt_kitchenware_dev.tax_journal;
truncate table	agronumt_kitchenware_dev.transaction_goods;
truncate table	agronumt_kitchenware_dev.transaction_v2s;
truncate table	agronumt_kitchenware_dev.transaction_v3s;
truncate table	agronumt_kitchenware_dev.transfer_items;
truncate table	agronumt_kitchenware_dev.trial_balances_v2s;
truncate table	agronumt_kitchenware_dev.warning_letters;

SET FOREIGN_KEY_CHECKS=1;