-- BI UBE v3.1 - Ajuste de vigencia del personal
-- Ejecutar UNA SOLA VEZ. No elimina registros ni historial.

SET @c1=(SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='usuarios' AND COLUMN_NAME='motivo_inactivacion');
SET @s1=IF(@c1=0,'ALTER TABLE usuarios ADD COLUMN motivo_inactivacion VARCHAR(150) NULL AFTER estado','SELECT 1');
PREPARE st FROM @s1; EXECUTE st; DEALLOCATE PREPARE st;

SET @c2=(SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='usuarios' AND COLUMN_NAME='fecha_inactivacion');
SET @s2=IF(@c2=0,'ALTER TABLE usuarios ADD COLUMN fecha_inactivacion DATETIME NULL AFTER motivo_inactivacion','SELECT 1');
PREPARE st FROM @s2; EXECUTE st; DEALLOCATE PREPARE st;

SET @c3=(SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='docentes' AND COLUMN_NAME='motivo_inactivacion');
SET @s3=IF(@c3=0,'ALTER TABLE docentes ADD COLUMN motivo_inactivacion VARCHAR(150) NULL AFTER estado','SELECT 1');
PREPARE st FROM @s3; EXECUTE st; DEALLOCATE PREPARE st;

SET @c4=(SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='docentes' AND COLUMN_NAME='fecha_inactivacion');
SET @s4=IF(@c4=0,'ALTER TABLE docentes ADD COLUMN fecha_inactivacion DATETIME NULL AFTER motivo_inactivacion','SELECT 1');
PREPARE st FROM @s4; EXECUTE st; DEALLOCATE PREPARE st;