TRUNCATE `admin_login`;
TRUNCATE `admin_usermenulist`;
TRUNCATE `employee_advance`;
TRUNCATE `employee_advance_collection`;
TRUNCATE `employee_attendance_dtl`;
TRUNCATE `employee_attendance_hdr`;
TRUNCATE `expense_entry`;
TRUNCATE `explosive_return_dtl`;
TRUNCATE `explosive_return_hdr`;
TRUNCATE `explosive_stock`;
TRUNCATE `explosive_utiliz`;
TRUNCATE `explosive_utiliz_dtl`;
TRUNCATE `explosive_utiliz_hdr`;
TRUNCATE `externalfill_diesel`;
TRUNCATE `externalpro_diesel`;
TRUNCATE `fill_diesel`;
TRUNCATE `internalpro_diesel`;
TRUNCATE `internalpro_explosive_dtl`;
TRUNCATE `internalpro_explosive_hdr`;
TRUNCATE `internalpro_spare_dtl`;
TRUNCATE `internalpro_spare_hdr`;
TRUNCATE `internalunfillpro_diesel`;

TRUNCATE `purchasedetails`;
TRUNCATE `purchasedetailswo`;
TRUNCATE `purchaseheader`;
TRUNCATE `purchaseheaderwo`;
TRUNCATE `purchase_dieselinvoice`;
TRUNCATE `purchase_explosiveinvoice_dtl`;
TRUNCATE `purchase_explosiveinvoice_hdr`;
TRUNCATE `purchase_spareinvoice_dtl`;
TRUNCATE `purchase_spareinvoice_hdr`;
TRUNCATE `supplier_payment`;
TRUNCATE `supplier_payment_header`;
TRUNCATE `supplier_payment_headerwo`;
TRUNCATE `supplier_payment_spare`;
TRUNCATE `total_litres`;
TRUNCATE `trip_equipment_dtl`;
TRUNCATE `trip_equipment_hdr`;
TRUNCATE `trip_transportation_dtl`;
TRUNCATE `trip_transportation_hdr`;