📊 Users in Database

IMPORTANT: This script shows password hashes. Delete this file after use for security!

🔍 Checking Database Structure

Table Structure:

id - bigint(20) unsigned (NO)
employee_id - varchar(50) (NO)
email - varchar(255) (NO)
password - varchar(255) (NO)
first_name - varchar(255) (YES)
last_name - varchar(255) (YES)
role - enum('admin','hse_manager','hse_officer','trainer','supervisor','viewer') (YES)
department - varchar(100) (YES)
phone - varchar(20) (YES)
status - enum('active','inactive','suspended') (YES)
last_login - datetime (YES)
created_at - timestamp (YES)
updated_at - timestamp (YES)

📋 User List (5 users)

Id	Employee id	Email	Password	First name	Last name	Role	Department	Status	Created at	Updated at
1	HSE-001	hse.manager@ncc.ae	$2y$10$YourHashedPasswordHere...	Mohammed	Al Hashimi	hse_manager	HSE Department	active	2026-02-05 11:09:21	2026-02-05 11:09:21
2	HSE-002	hse.officer1@ncc.ae	$2y$10$YourHashedPasswordHere...	Fatima	Al Zaabi	hse_officer	HSE Department	active	2026-02-05 11:09:21	2026-02-05 11:09:21
3	TRN-001	trainer1@ncc.ae	$2y$10$YourHashedPasswordHere...	Khalid	Al Marri	trainer	Training Department	active	2026-02-05 11:09:21	2026-02-05 11:09:21
4	SUP-001	supervisor1@ncc.ae	$2y$10$YourHashedPasswordHere...	Salem	Al Shamsi	supervisor	Operations	active	2026-02-05 11:09:21	2026-02-05 11:09:21
5	EMP20260206043817853	admin@trn.mysignages.com	$2y$12$RLPl6BLuPPRsPtltBTChu.9...			viewer		active	2026-02-06 04:38:17	2026-02-06 04:38:17

🔑 Recommended Login Credentials

Try these emails with password: Admin@123

hse.manager@ncc.ae - No name
hse.officer1@ncc.ae - No name
trainer1@ncc.ae - No name
supervisor1@ncc.ae - No name
admin@trn.mysignages.com - No name

⚙️ Quick Fixes

Option 1: Create Minimal User

Option 2: Run Migrations

If you have Laravel migrations, run:

php artisan migrate

Or execute this SQL:

ALTER TABLE users ADD COLUMN IF NOT EXISTS name VARCHAR(255) AFTER id;
ALTER TABLE users ADD COLUMN IF NOT EXISTS email_verified_at TIMESTAMP NULL AFTER email;
ALTER TABLE users ADD COLUMN IF NOT EXISTS remember_token VARCHAR(100) NULL AFTER password;