-- Limita las conclusiones descriptivas a 150 caracteres.

UPDATE nota_estudiante
SET conclusion_descriptiva = LEFT(TRIM(REPLACE(REPLACE(conclusion_descriptiva, CHAR(13), ' '), CHAR(10), ' ')), 150)
WHERE conclusion_descriptiva IS NOT NULL
  AND CHAR_LENGTH(conclusion_descriptiva) > 150;

UPDATE nota_transversal_docente
SET conclusion_descriptiva = LEFT(TRIM(REPLACE(REPLACE(conclusion_descriptiva, CHAR(13), ' '), CHAR(10), ' ')), 150)
WHERE conclusion_descriptiva IS NOT NULL
  AND CHAR_LENGTH(conclusion_descriptiva) > 150;

UPDATE siagie_importacion_detalle
SET conclusion_descriptiva = LEFT(TRIM(REPLACE(REPLACE(conclusion_descriptiva, CHAR(13), ' '), CHAR(10), ' ')), 150)
WHERE conclusion_descriptiva IS NOT NULL
  AND CHAR_LENGTH(conclusion_descriptiva) > 150;

ALTER TABLE nota_estudiante
  MODIFY conclusion_descriptiva VARCHAR(150) NULL;

ALTER TABLE nota_transversal_docente
  MODIFY conclusion_descriptiva VARCHAR(150) NULL;

ALTER TABLE siagie_importacion_detalle
  MODIFY conclusion_descriptiva VARCHAR(150) NULL;