ALTER TABLE `attendance` CHANGE `type_ace` `type_ace` ENUM( 'UNEXCUSED_ABSENCE', 'EXCUSED_ABSENCE', 'DELAY', 'ESCAPE' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL 