-- ============================================================================
-- Agregar campo de contraseña a usuarios
-- ============================================================================
USE institutoAyudantias;

-- Agregar columna password
ALTER TABLE usuarios 
ADD COLUMN password VARCHAR(255) NOT NULL AFTER correo;

-- Actualizar usuarios con contraseñas (hash de '123456' para pruebas)
UPDATE usuarios SET password = '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE idUsuario = 1; -- admin: 123456
UPDATE usuarios SET password = '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE idUsuario = 2; -- docente: 123456
UPDATE usuarios SET password = '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE idUsuario = 3;
UPDATE usuarios SET password = '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE idUsuario = 4;
UPDATE usuarios SET password = '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE idUsuario = 5;
UPDATE usuarios SET password = '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE idUsuario = 6;
UPDATE usuarios SET password = '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE idUsuario = 7;

-- Verificar cambios
SELECT idUsuario, rut, nombre, correo, perfil, 
       CASE WHEN password IS NOT NULL THEN 'Sí' ELSE 'No' END as tiene_password
FROM usuarios;