ALTER TABLE CATEGORY ADD COLUMN IS_CAREER_CATEGORY TINYINT(1) DEFAULT 0;
ALTER TABLE CATEGORY ADD COLUMN IS_MONITOR_CATEGORY TINYINT(1) DEFAULT 0;

UPDATE CATEGORY SET IS_CAREER_CATEGORY = 1 WHERE LONG_NAME = 'ASSISTENTE' AND CODE = 'AST';
UPDATE CATEGORY SET IS_CAREER_CATEGORY = 1 WHERE LONG_NAME = 'PROFESSOR CATEDRATICO' AND CODE = 'PCA';
UPDATE CATEGORY SET IS_CAREER_CATEGORY = 1 WHERE LONG_NAME = 'PROFESSOR AUXILIAR' AND CODE = 'PAX';
UPDATE CATEGORY SET IS_CAREER_CATEGORY = 1 WHERE LONG_NAME = 'PROFESSOR ASSOCIADO' AND CODE = 'PAS';
UPDATE CATEGORY SET IS_CAREER_CATEGORY = 1 WHERE LONG_NAME = 'ASSISTENTE ESTAGIARIO' AND (CODE = 'ASE' OR CODE = 'ASG');

UPDATE CATEGORY SET IS_MONITOR_CATEGORY = 1 WHERE CODE = 'MNL' OR CODE = 'MNT';