-- ═══════════════════════════════════════════════════════════════
-- reset_admin_password.sql
-- Database: skjrjcrd_nfp-portal
--
-- RECOMMENDED: Use setpw.php instead of this file
--   1. Upload files to membership.nfp.or.ke
--   2. Visit https://membership.nfp.or.ke/setpw.php
--   3. Enter secret: NFP2026setup
--   4. Type your desired password and submit
--   5. DELETE setpw.php from the server immediately after
--
-- ALTERNATIVE: Run the SQL below in phpMyAdmin
--   This sets the admin password to: 4dm1n
--   The hash below is verified bcrypt compatible with PHP password_verify()
-- ═══════════════════════════════════════════════════════════════

UPDATE `admin_users`
SET `password_hash` = '$2y$10$YKFbMHbIoRqCiVksWAjvauMBv9pOFN.W2vKpXFDvg0xWrXiMl9RuS'
WHERE `username` = 'admin';

-- Password is: 4dm1n
-- If this hash does not work, use setpw.php (strongly recommended)
