====================================================
   DATABASE CLEANUP SCRIPT - FRESH DEPLOYMENT      
====================================================

Active Database: xeebnvsf_zampay

[1/4] Creating database backup...
  -> Backup saved successfully to: /home/xeebnvsf/app.zampay.com.ng/database/backups/backup_before_cleanup_2026_08_20_075126.sql

[2/4] Truncating client transactions, logs, messages, and history...
  - Cleaned table `airtime` (cleared 0 rows)
  - Cleaned table `cash` (cleared 0 rows)
  - Cleaned table `data` (cleared 0 rows)
  - Cleaned table `data_card` (cleared 0 rows)
  - Cleaned table `data_payment` (cleared 0 rows)
  - Cleaned table `dump_data_card_pin` (cleared 0 rows)
  - Cleaned table `dump_recharge_card_pin` (cleared 0 rows)
  - Cleaned table `store_data_card` (cleared 0 rows)
  - Cleaned table `store_recharge_card` (cleared 0 rows)
  - Cleaned table `stock_result_pin` (cleared 0 rows)
  - Cleaned table `bill` (cleared 0 rows)
  - Cleaned table `bill_payment` (cleared 0 rows)
  - Cleaned table `cable` (cleared 0 rows)
  - Cleaned table `cable_payment` (cleared 0 rows)
  - Cleaned table `bulksms` (cleared 0 rows)
  - Cleaned table `exam` (cleared 0 rows)
  - Cleaned table `recharge_card` (cleared 0 rows)
  - Cleaned table `deposit` (cleared 0 rows)
  - Cleaned table `transfers` (cleared 0 rows)
  - Cleaned table `bank_transfer` (cleared 0 rows)
  - Cleaned table `wallet_funding` (cleared 0 rows)
  - Cleaned table `card_transactions` (cleared 0 rows)
  - Cleaned table `virtual_cards` (cleared 0 rows)
  - Cleaned table `scheduled_transactions` (cleared 0 rows)
  - Cleaned table `donations` (cleared 0 rows)
  - Cleaned table `campaigns` (cleared 0 rows)
  - Cleaned table `charities` (cleared 0 rows)
  - Cleaned table `pointwave_transactions` (cleared 0 rows)
  - Cleaned table `pointwave_webhooks` (cleared 0 rows)
  - Cleaned table `pointwave_customers` (cleared 0 rows)
  - Cleaned table `pointwave_virtual_accounts` (cleared 0 rows)
  - Cleaned table `pointwave_kyc` (cleared 0 rows)
  - Cleaned table `vouchers` (cleared 0 rows)
  - Cleaned table `request` (cleared 0 rows)
  - Cleaned table `webhook_events` (cleared 0 rows)
  - Cleaned table `jobs` (cleared 0 rows)
  - Cleaned table `message` (cleared 0 rows)
  - Cleaned table `notif` (cleared 0 rows)
  - Cleaned table `notification_broadcasts` (cleared 0 rows)
  - Cleaned table `support_tickets` (cleared 0 rows)
  - Cleaned table `support_messages` (cleared 0 rows)
  - Cleaned table `service_beneficiaries` (cleared 0 rows)
  - Cleaned table `beneficiaries` (cleared 0 rows)
  - Cleaned table `user_checkins` (cleared 0 rows)
  - Cleaned table `user_spins` (cleared 0 rows)
  - Cleaned table `user_gamification_stats` (cleared 0 rows)
  - Cleaned table `personal_access_tokens` (cleared 0 rows)
  - Cleaned table `user_kyc` (cleared 0 rows)
  - Cleaned table `user_bank` (cleared 0 rows)

[3/4] Purging non-admin clients and resetting admin balances...
  - Deleted 0 non-admin client accounts.
  - Preserved 2 Admin accounts:
      * ID: 3 | Username: Habukhan | Email: abokisub@gmail.com | Status: Active | Balance: 0
      * ID: 20 | Username: Mrrobot | Email: ajamilubashir@gmail.com | Status: Active | Balance: 0
  - Cleaned orphan user_settings.

[4/4] Preserved intact configurations:
  ✓ API Configurations (adex_api, habukhan_api, msorg_api, other_api, web_api, virus_api)
  ✓ API Keys (habukhan_key, adex_key, paystack_key)
  ✓ System Settings (settings, general, feature, block, card_settings, faqs, ai_learning_keywords)
  ✓ Plans & Pricing (data_plan, airtime_discount, cable_plan, bill_plan, recharge_card_plan, talkmore_plan, sel)
  ✓ Networks & Providers (network, unified_banks, transfer_providers)
  ✓ Database Migrations (100% intact, no migration loss)

====================================================
   DATABASE CLEANUP COMPLETED SUCCESSFULLY!        
====================================================