System Utilities

Lynx Core

System Diagnostic & Data Seeding Dashboard

Deployment Status

SYSTEM READY

Elapsed Time
7.27s
Environment
Local/Debug

Execution Steps

Sequential Order
1

Database Check/Creation

Verified or successfully created the database 'lynxlk_asia_capital_db'.

Success
View Output Logs
Database 'lynxlk_asia_capital_db' charset=utf8mb4 collation=utf8mb4_unicode_ci validated successfully.
2

Migrate Fresh

Dropped all tables and executed fresh migrations.

Success
View Output Logs
Dropping all tables .......................................... 130.05ms DONE

   INFO  Preparing database.  

  Creating migration table ....................................... 9.70ms DONE

   INFO  Running migrations.  

  0001_01_01_000000_create_users_table .......................... 73.38ms DONE
  0001_01_01_000001_create_cache_table .......................... 48.64ms DONE
  0001_01_01_000002_create_jobs_table ........................... 64.45ms DONE
  2025_08_14_170933_add_two_factor_columns_to_users_table ....... 49.46ms DONE
  2026_06_23_000001_create_cms_tables ........................... 52.90ms DONE
  2026_06_23_082002_create_permission_tables ................... 214.47ms DONE
  2026_08_08_234051_add_user_id_to_customers_table ............... 0.28ms DONE
  2026_08_09_000001_create_holidays_table ....................... 24.99ms DONE
  2026_08_09_000002_create_customers_table ...................... 61.30ms DONE
  2026_08_09_000003_create_guarantors_table ..................... 45.11ms DONE
  2026_08_09_000004_create_documents_table ...................... 43.15ms DONE
  2026_08_09_000005_create_customer_bank_details_table .......... 45.44ms DONE
  2026_08_09_000006_create_loan_products_table .................. 25.27ms DONE
  2026_08_09_000007_create_product_rate_histories_table ......... 50.54ms DONE
  2026_08_09_000008_create_loans_table ......................... 119.63ms DONE
  2026_08_09_000009_create_loan_schedules_table ................. 66.84ms DONE
  2026_08_09_000010_create_penalty_charges_table ................ 53.52ms DONE
  2026_08_09_000011_create_loan_approvals_table ................. 53.95ms DONE
  2026_08_09_000012_create_collections_table ................... 109.80ms DONE
  2026_08_09_000013_create_expense_categories_table .............. 8.03ms DONE
  2026_08_09_000014_create_expenses_table ....................... 75.56ms DONE
  2026_08_09_000015_add_supervisor_and_otp_to_users_table ....... 64.48ms DONE
  2026_08_16_000001_create_branches_table ....................... 24.78ms DONE
  2026_08_16_000002_add_branch_id_to_related_tables ............ 160.91ms DONE
  2026_08_16_000003_create_branch_user_table .................... 73.74ms DONE
  2026_08_16_000004_create_loan_categories_table ................ 25.82ms DONE
  2026_08_16_000005_add_category_id_to_loan_products ............ 43.53ms DONE
  2026_08_18_082832_add_employment_details_to_customers_table ... 98.65ms DONE
  2026_08_24_000001_add_product_manager_id_to_loan_products ..... 39.51ms DONE
  2026_08_25_000001_add_od_rate_and_grace_period_to_loan_products_and_loans  44.93ms DONE
  2026_08_25_000002_add_collection_order_to_loans_table ......... 33.88ms DONE
  2026_08_25_000003_create_daily_handovers_and_audit_logs_tables  236.38ms DONE
  2026_08_25_000004_add_coordinates_to_customers_and_branches ... 58.05ms DONE
3

Database Seeding

Populated tables with initial security roles, permissions, and administrator accounts.

Success
View Output Logs
INFO  Seeding database.  

  Database\Seeders\RoleAndPermissionSeeder ........................... RUNNING  
  Database\Seeders\RoleAndPermissionSeeder ..................... 2,137 ms DONE  

  Database\Seeders\BranchSeeder ...................................... RUNNING  
  Database\Seeders\BranchSeeder ................................... 14 ms DONE  

  Database\Seeders\LoanCategorySeeder ................................ RUNNING  
  Database\Seeders\LoanCategorySeeder .............................. 4 ms DONE  

  Database\Seeders\LoanProductSeeder ................................. RUNNING  
  Database\Seeders\LoanProductSeeder ............................... 5 ms DONE  

  Database\Seeders\HolidaySeeder ..................................... RUNNING  
  Database\Seeders\HolidaySeeder ................................... 1 ms DONE  

  Database\Seeders\DemoDataSeeder .................................... RUNNING  
  Database\Seeders\RoleAndPermissionSeeder ........................... RUNNING  
  Database\Seeders\RoleAndPermissionSeeder ..................... 2,073 ms DONE  

  Database\Seeders\BranchSeeder ...................................... RUNNING  
  Database\Seeders\BranchSeeder .................................... 3 ms DONE  

  Database\Seeders\LoanCategorySeeder ................................ RUNNING  
  Database\Seeders\LoanCategorySeeder .............................. 1 ms DONE  

  Database\Seeders\LoanProductSeeder ................................. RUNNING  
  Database\Seeders\LoanProductSeeder ............................... 4 ms DONE  

  Database\Seeders\HolidaySeeder ..................................... RUNNING  
  Database\Seeders\HolidaySeeder ................................... 1 ms DONE  

  Database\Seeders\DemoDataSeeder .............................. 2,691 ms DONE
4

Create Storage Link

Cleaned up pre-existing 'public/storage' folder/symlink. Successfully linked backend storage to the public directory.

Success
View Output Logs
INFO  The [public/storage] link has been connected to [storage/app/public].
5

Optimize Clear

Cleared all compiled files, caches, views, and routing tables.

Success
View Output Logs
INFO  Clearing cached bootstrap files.  

  config ......................................................... 0.30ms DONE
  cache .......................................................... 0.76ms DONE
  compiled ....................................................... 0.28ms DONE
  events ......................................................... 0.29ms DONE
  routes ......................................................... 0.28ms DONE
  views .......................................................... 0.56ms DONE
6

Optimize & Cache

Skipped configuration caching in local environment to prevent test DB conflicts.

Success
View Output Logs
Local development environment: skipped optimize command.