for clear 1st 
TRUNCATE `acc_bills`;
TRUNCATE `acc_bill_details`;
TRUNCATE `acc_bill_payments`;
TRUNCATE `acc_cost_centers`;
TRUNCATE `acc_invoices`;
TRUNCATE `acc_invoice_details`;
TRUNCATE `acc_invoice_payments`;
TRUNCATE `customers`;
TRUNCATE `customer_billing_addresses`;
TRUNCATE `customer_contacts`;
TRUNCATE `customer_delivery_addresses`;
TRUNCATE `customer_documents`;
TRUNCATE `customer_meta_details`;
TRUNCATE `customer_notes`;
TRUNCATE `customer_payment_informations`;
TRUNCATE `customer_pickup_addresses`;
TRUNCATE `customer_shiping_addresses`;
TRUNCATE `employees`;
TRUNCATE `employee_contacts`;
TRUNCATE `employee_jobs`;
TRUNCATE `employee_job_details`;
TRUNCATE `employee_personal_details`;
TRUNCATE `employee_salary_allowance_items`;
TRUNCATE `employee_salary_salary_items`;
TRUNCATE `opportunities`;
TRUNCATE `opportunities_logs`;
TRUNCATE `products`;
TRUNCATE `product_details`;
TRUNCATE `product_meta_details`;
TRUNCATE `sales_opportunities`;
TRUNCATE `sales_opp_order_logs`;
TRUNCATE `sales_orders`;
TRUNCATE `sales_order_items`;
TRUNCATE `sales_quotations`;
TRUNCATE `sales_quotation_items`;
TRUNCATE `transactions`;
TRUNCATE `transaction_cost_centers`;
TRUNCATE `transaction_crs`;
TRUNCATE `transaction_drs`;
TRUNCATE `transaction_files`;
TRUNCATE `transaction_logs`;
TRUNCATE `transaction_product_details`;
TRUNCATE `vendors`;
TRUNCATE `vendor_contacts`;