Authentication Test
✅ Database connected
✅ Users table exists
Users Table Columns:
- id - char(36)
- name - varchar(100)
- full_name - varchar(120)
- email - varchar(255)
- password - varchar(255)
- password_hash - varchar(255)
- role - enum('admin','employer','driver','individual')
- createdAt - timestamp
- email_verified - tinyint(1)
- email_verification_token_hash - varchar(255)
- email_verification_expires_at - datetime
- email_verification_attempts - int
- status - enum('active','passive','pending_verification','suspended','banned','deleted')
- suspend_until - datetime
- banned_at - datetime
- risk_score - tinyint unsigned
- email_verified_at - datetime
- phone_verified_at - datetime
- identity_verified_at - datetime
- document_status - enum('pending','approved','rejected')
- document_reject_reason - varchar(500)
- failed_login_count - int
- deleted_at - datetime
- deleted_by - char(36)
- created_by - char(36)
- updated_by - char(36)
- phone - varchar(40)
- company_name - varchar(190)
- city - varchar(120)
- photo_url - varchar(255)
- username - varchar(120)
- service_cities - text
- tursab_no - varchar(120)
- tursab_doc - varchar(255)
- company_docs - text
- uetds_username - varchar(100)
- uetds_password_enc - varchar(500)
- uetds_personnel_id - varchar(100)
- iban_number - varchar(34)
- iban_account_holder - varchar(150)
- tursab_api_no - varchar(50)
- tursab_api_status - enum('none','pending','approved','rejected')
- tursab_firm_name - varchar(200)
- tursab_verified_at - datetime
- active - tinyint(1)
- banned - tinyint(1)
- driver_type - enum('free','paid')
- driver_status - enum('idle','busy')
- vehicle_type - varchar(100)
- region - varchar(100)
- status_v2 - varchar(20)
- district - varchar(100)
- address - text
- tax_office - varchar(120)
- tax_no - varchar(32)
Total users: 32
❌ Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'field list'
Session Info:
Array
(
[csrf_token] => 7835f335cfb78894d8616f6e02f857b99163c34fd557364464e7418d35915f59
)