Checking users table structure...

✅ users table exists

Current columns:
- id (int)
- username (varchar(50))
- email (varchar(100))
- password_hash (varchar(255))
- first_name (varchar(50))
- last_name (varchar(50))
- phone (varchar(20))
- department (varchar(50))
- role_id (int)
- is_active (tinyint(1))
- last_login (timestamp)
- created_at (timestamp)
- updated_at (timestamp)
- password (varchar(255))
- role (enum('admin','md','procurement','finance','hod'))
- name (varchar(255))
- status (enum('active','inactive','suspended'))
- phone_number (varchar(20))
- full_name (varchar(100))
- department_id (int)