-- ZT Mobile - Reset Transactions (keep master data like device_catalog, device_variants, products optional)
SET FOREIGN_KEY_CHECKS=0;

TRUNCATE TABLE sales_items;
DELETE FROM sales;
ALTER TABLE sales AUTO_INCREMENT=1;

TRUNCATE TABLE used_mobiles;
DELETE FROM used_purchases;
ALTER TABLE used_purchases AUTO_INCREMENT=1;

TRUNCATE TABLE repairs;
TRUNCATE TABLE expenses;

TRUNCATE TABLE payments;
TRUNCATE TABLE party_ledger;
TRUNCATE TABLE cashbook;
TRUNCATE TABLE audit_log;

SET FOREIGN_KEY_CHECKS=1;
