-- ============================================
-- Fix Admin Password Hash (for phpMyAdmin)
-- ============================================
-- 
-- INSTRUCTIONS:
-- 1. Generate a NEW bcrypt hash at: https://bcrypt-generator.com/
--    - Enter your desired password
--    - Set rounds to 10
--    - Copy the complete hash (60 characters)
--
-- 2. Replace values below:
--    - 'PASTE_NEW_HASH_HERE' → Your new bcrypt hash
--    - 'admin@yourdomain.com' → Your admin email
--
-- 3. Execute in phpMyAdmin SQL tab
--
-- ============================================

UPDATE `users` 
SET 
  `password` = 'PASTE_NEW_HASH_HERE',  -- ⬅️ PASTE YOUR NEW BCRYPT HASH
  `passwordSet` = TRUE,
  `isActive` = TRUE,
  `updatedAt` = NOW()
WHERE `email` = 'admin@yourdomain.com';  -- ⬅️ CHANGE TO YOUR ADMIN EMAIL

-- ============================================
-- EXAMPLE: Reset to 'admin123' password
-- ============================================
-- Uncomment and use this if you want to reset to default:
--
-- UPDATE `users` 
-- SET 
--   `password` = '$2a$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LJZdL17lhWy',
--   `passwordSet` = TRUE,
--   `isActive` = TRUE,
--   `updatedAt` = NOW()
-- WHERE `email` = 'admin@yourdomain.com';  -- ⬅️ CHANGE EMAIL
--
-- ⚠️ WARNING: Change password immediately after login!
-- ============================================