alter table CATEGORY add column WEIGHT tinyint(1) NOT NULL default '0';

update CATEGORY set WEIGHT = 1 where CATEGORY.LONG_NAME = "PROFESSOR CATEDRATICO";
update CATEGORY set WEIGHT = 2 where CATEGORY.LONG_NAME = "PROFESSOR CATEDRATICO CONVIDADO";
update CATEGORY set WEIGHT = 3 where CATEGORY.LONG_NAME = "PROFESSOR CATEDRATICO VISITANTE";
update CATEGORY set WEIGHT = 4 where CATEGORY.LONG_NAME = "EQUIPARADO A PROFESSOR CATEDRATICO";
update CATEGORY set WEIGHT = 5 where CATEGORY.LONG_NAME = "PROFESSOR ASSOCIADO";
update CATEGORY set WEIGHT = 6 where CATEGORY.LONG_NAME = "PROFESSOR ASSOCIADO CONVIDADO";
update CATEGORY set WEIGHT = 7 where CATEGORY.LONG_NAME = "PROFESSOR ASSOCIADO VISITANTE";
update CATEGORY set WEIGHT = 8 where CATEGORY.LONG_NAME = "PROFESSOR AGREGADO";
update CATEGORY set WEIGHT = 9 where CATEGORY.LONG_NAME = "PROFESSOR AUXILIAR";
update CATEGORY set WEIGHT = 10 where CATEGORY.LONG_NAME = "PROFESSOR AUXILIAR CONVIDADO";
update CATEGORY set WEIGHT = 11 where CATEGORY.LONG_NAME = "PROFESSOR AUXILIAR VISITANTE";
update CATEGORY set WEIGHT = 12 where CATEGORY.LONG_NAME = "EQUIPARADO A PROFESSOR AUXILIAR";
update CATEGORY set WEIGHT = 13 where CATEGORY.LONG_NAME = "PROFESSOR EXTRAORDINARIO";
update CATEGORY set WEIGHT = 14 where CATEGORY.LONG_NAME = "EQUIPARADO A PROFESSOR EXTRAORDINARIO";
update CATEGORY set WEIGHT = 15 where CATEGORY.LONG_NAME = "ASSISTENTE";
update CATEGORY set WEIGHT = 16 where CATEGORY.LONG_NAME = "ASSISTENTE CONVIDADO";
update CATEGORY set WEIGHT = 17 where CATEGORY.LONG_NAME = "ASSISTENTE ESTAGIARIO";
update CATEGORY set WEIGHT = 18 where CATEGORY.LONG_NAME = "EQUIPARADO A ASSISTENTE";
update CATEGORY set WEIGHT = 19 where CATEGORY.LONG_NAME = "ASSISTENTE EVENTUAL";
update CATEGORY set WEIGHT = 20 where CATEGORY.LONG_NAME = "EQUIPARADO A ASSISTENTE EVENTUAL";
update CATEGORY set WEIGHT = 21 where CATEGORY.LONG_NAME = "PRIMEIRO ASSISTENTE";
update CATEGORY set WEIGHT = 22 where CATEGORY.LONG_NAME = "SEGUNDO ASSISTENTE";
update CATEGORY set WEIGHT = 23 where CATEGORY.LONG_NAME = "ESPECIALISTA";
update CATEGORY set WEIGHT = 24 where CATEGORY.LONG_NAME = "LEITOR";
update CATEGORY set WEIGHT = 25 where CATEGORY.LONG_NAME = "MONITOR-E.C.D. COM LICENCIATURA";
update CATEGORY set WEIGHT = 26 where CATEGORY.LONG_NAME = "MONITOR-E.C.D. SEM LICENCIATURA";
update CATEGORY set WEIGHT = 27 where CATEGORY.LONG_NAME = "PROFESSOR DE EDUCACAO FISICA";
