DELETE FROM `loan_outstanding` WHERE outstanding_type != 'PAYMENT'; UPDATE `loans` SET `migration_status` = 'NO', message = NULL; TRUNCATE `transactions`; TRUNCATE `daily_account_balances`; UPDATE `general_ledgers` SET `balance` = '0'; UPDATE `schedule_at_disbursement` SET status = 'COMPLETED' WHERE repayment_date <= CURDATE(); UPDATE `accounts` SET `balance` = '0';