6 lines
430 B
SQL
6 lines
430 B
SQL
-- Update test user passwords with correctly hashed password123
|
|
UPDATE "Users" SET password = '$2b$10$dPXxS9Byg7AbB.fngFtNWel1llS1nHJlQrTO4zQToy7vVitS9mr96' WHERE username IN ('john_doe', 'jane_premium', 'teacher_bob', 'admin_user', 'new_user');
|
|
|
|
-- Verify the update
|
|
SELECT username, LEFT(password, 20) AS password_hash, state FROM "Users" WHERE username IN ('john_doe', 'jane_premium', 'teacher_bob', 'admin_user', 'new_user');
|