-- تحديث كلمات المرور للحسابات التجريبية
-- Update test accounts passwords

-- admin@nursery.local / admin123
UPDATE staff_users 
SET password_hash = '$2y$10$qlxwx6GAqTQ5EkF5RuGZFuCqmE9Zk7odrZEp7YG/j0UKgF88WeiiO' 
WHERE email = 'admin@nursery.local';

-- manager@nursery.local / manager123
UPDATE staff_users 
SET password_hash = '$2y$10$gc1Tv6FTX8lt5765s//lL.DR7ILyaJAvX0B/H8SXbuXnp92ATlHRy' 
WHERE email = 'manager@nursery.local';

-- accountant@nursery.local / accountant123
UPDATE staff_users 
SET password_hash = '$2y$10$Z53dRhcF3yPy7Y5KpelFs.sxWKmbMwhY3ZDa1dcMnD9PEnnfuwfrK' 
WHERE email = 'accountant@nursery.local';

-- staff@nursery.local / staff123 (إذا كان موجوداً)
UPDATE staff_users 
SET password_hash = '$2y$10$xrCDC8hRtnMt4DxgES1rLOLds9OPFgPHrqt9Ftx.VVdiMEG7kof4u' 
WHERE email = 'staff@nursery.local';

-- staff1@nursery.local / staff123
UPDATE staff_users 
SET password_hash = '$2y$10$xrCDC8hRtnMt4DxgES1rLOLds9OPFgPHrqt9Ftx.VVdiMEG7kof4u' 
WHERE email = 'staff1@nursery.local';

-- staff2@nursery.local / staff123
UPDATE staff_users 
SET password_hash = '$2y$10$xrCDC8hRtnMt4DxgES1rLOLds9OPFgPHrqt9Ftx.VVdiMEG7kof4u' 
WHERE email = 'staff2@nursery.local';

-- admin@admin.com / admin123
UPDATE staff_users 
SET password_hash = '$2y$10$qlxwx6GAqTQ5EkF5RuGZFuCqmE9Zk7odrZEp7YG/j0UKgF88WeiiO' 
WHERE email = 'admin@admin.com';

-- transport@nursery.local / staff123
UPDATE staff_users 
SET password_hash = '$2y$10$xrCDC8hRtnMt4DxgES1rLOLds9OPFgPHrqt9Ftx.VVdiMEG7kof4u' 
WHERE email = 'transport@nursery.local';

-- إعادة تعيين محاولات تسجيل الدخول للجميع
UPDATE staff_users 
SET login_attempts = 0, locked_until = NULL;