TRUNCATE TABLE `accountancy_items`;
TRUNCATE TABLE `bills`;
TRUNCATE TABLE `bill_revisions`;
TRUNCATE TABLE `bill_accountancy_details`;
TRUNCATE TABLE `bill_details`;
TRUNCATE TABLE `bill_detail_revisions`;
TRUNCATE TABLE `bill_states`;
TRUNCATE TABLE `catalogs`;
TRUNCATE TABLE `ccatalogs`;
TRUNCATE TABLE `checks`;
TRUNCATE TABLE `check_details`;
TRUNCATE TABLE `customers`;
TRUNCATE TABLE `customers_ccatalogs`;
TRUNCATE TABLE `imports`;
TRUNCATE TABLE `import_details`;
TRUNCATE TABLE `logs`;
TRUNCATE TABLE `notes`;
TRUNCATE TABLE `payment_bills`;
TRUNCATE TABLE `payment_types`;
TRUNCATE TABLE `products`;
TRUNCATE TABLE `products_catalogs`;
TRUNCATE TABLE `promotions`;
TRUNCATE TABLE `receipts`;
TRUNCATE TABLE `receipt_types`;
TRUNCATE TABLE `redeems`;
TRUNCATE TABLE `reserves`;
TRUNCATE TABLE `reserve_histories`;
TRUNCATE TABLE `return_products`;
TRUNCATE TABLE `return_product_details`;
TRUNCATE TABLE `return_imports`;
TRUNCATE TABLE `return_import_details`;
TRUNCATE TABLE `scatalogs`;
TRUNCATE TABLE `suppliers`;
TRUNCATE TABLE `suppliers_scatalogs`;
TRUNCATE TABLE `tickets`;
TRUNCATE TABLE `transfers`;
TRUNCATE TABLE `transfer_details`;
TRUNCATE TABLE `units`;
TRUNCATE TABLE `unit_names`;


INSERT INTO `customers`(`code`,`branch_id`,`user_id`,`name`,`left`,`trash`) VALUES('',0,0,'Khách vãng lai',0,0);

INSERT INTO `suppliers`(`code`,`user_id`,`name`,`left`,`trash`) VALUES('',0,'Không khai báo',0,0);

INSERT INTO `units`(`id`,`name`,`product_id`,`ccatalog_id`,`price`) VALUES(0,'Giá mặc định',0,0,0);

