SET FOREIGN_KEY_CHECKS = 0;

DELETE FROM `tbl_admin_journal_entry_lines`;
DELETE FROM `tbl_admin_journal_entries`;

DELETE FROM `tbl_admin_payment_accounting_postings`;
DELETE FROM `tbl_admin_po_payments`;
DELETE FROM `tbl_admin_po_payment_counters`;

DELETE FROM `tbl_admin_grn_accounting_postings`;
DELETE FROM `tbl_admin_grn_line_serials`;
DELETE FROM `tbl_admin_grn_lines`;
DELETE FROM `tbl_admin_grn`;
DELETE FROM `tbl_admin_grn_counters`;

DELETE FROM `tbl_admin_purchase_order_lines`;
DELETE FROM `tbl_admin_purchase_orders`;

DELETE FROM `tbl_admin_gs_stationery_stock_reservations`;
DELETE FROM `tbl_admin_gs_stock_movements`;
DELETE FROM `tbl_admin_gs_stock_lots`;
DELETE FROM `tbl_admin_gs_stationery_batches`;

DELETE FROM `tbl_admin_gs_issue_request_lines`;
DELETE FROM `tbl_admin_gs_issue_requests`;

DELETE FROM `tbl_admin_gs_stationery_request_lines`;
DELETE FROM `tbl_admin_gs_stationery_requests`;

DELETE FROM `tbl_admin_requisition_lines`;
DELETE FROM `tbl_admin_requisitions`;
DELETE FROM `tbl_admin_req_counters`;

DELETE FROM `tbl_admin_asset_depreciation_runs`;
DELETE FROM `tbl_admin_asset_units`;
DELETE FROM `tbl_admin_asset_variants`;
DELETE FROM `tbl_admin_assets`;

DELETE FROM `tbl_admin_ap_invoices`;

DELETE FROM `tbl_admin_gs_asset_serial_sequences`;
DELETE FROM `tbl_admin_serial_number`;
DELETE FROM `tbl_admin_variant_planning`;
DELETE FROM `tbl_admin_variant_code_sequences`;
DELETE FROM `tbl_admin_approval_chain_steps`;


ALTER TABLE `tbl_admin_ap_invoices` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_asset_depreciation_runs` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_asset_units` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_asset_variants` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_assets` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_grn` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_grn_accounting_postings` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_grn_counters` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_grn_line_serials` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_grn_lines` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_asset_serial_sequences` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_issue_request_lines` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_issue_requests` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_stationery_batches` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_stationery_request_lines` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_stationery_requests` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_stationery_stock_reservations` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_stock_lots` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_gs_stock_movements` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_journal_entries` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_journal_entry_lines` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_payment_accounting_postings` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_po_payment_counters` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_po_payments` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_purchase_order_lines` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_purchase_orders` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_req_counters` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_requisition_lines` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_requisitions` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_serial_number` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_variant_code_sequences` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_variant_planning` AUTO_INCREMENT = 1;
ALTER TABLE `tbl_admin_approval_chain_steps` AUTO_INCREMENT = 1;
SET FOREIGN_KEY_CHECKS = 1;