-- Fix Admin Password
-- This SQL script updates the admin password to a bcrypt hash of "admin123"
-- After running this, you can log in with:
-- Email: admin@gmail.com
-- Password: admin123

UPDATE admin 
SET password = '$2b$10$8qTvL/BrFCeGgVL8i4Zx/e/DK8dN6zF3bK9xM2pQ5rS7tU1w4s2sG' 
WHERE email = 'admin@gmail.com';

-- Verify the update
SELECT id, email, password FROM admin WHERE email = 'admin@gmail.com';
