-- ============================================================
--  Nursing Guru — Admin Password Reset
--  Run this in phpMyAdmin → SQL tab on your 'nurseportal' DB
--  
--  Email:    admin@nursingguru.in
--  Password: Admin@123
-- ============================================================

-- Option 1: Update existing admin record
UPDATE `admins`
SET `password` = '$2y$10$O6TRoMuN7lOjYjQzAWLK3uYa1xf4kMSUaFywb/uIJN1w1pqvZxJBy',
    `status`   = 1
WHERE `email` = 'admin@nursingguru.in';

-- Option 2: If the above updates 0 rows (admin doesn't exist yet),
-- run this INSERT instead:
-- INSERT INTO `admins` (`name`, `email`, `password`, `role`, `status`) VALUES
-- ('Super Admin', 'admin@nursingguru.in', '$2y$10$O6TRoMuN7lOjYjQzAWLK3uYa1xf4kMSUaFywb/uIJN1w1pqvZxJBy', 'superadmin', 1)
-- ON DUPLICATE KEY UPDATE
--   `password` = '$2y$10$O6TRoMuN7lOjYjQzAWLK3uYa1xf4kMSUaFywb/uIJN1w1pqvZxJBy',
--   `status`   = 1;

-- Verify: this should return 1 row with your email
SELECT id, name, email, role, status FROM `admins`;