insert into TEACHER_SERVICE_ITEM (KEY_TEACHER_SERVICE, MASTER_DEGREE_TEACHING_NOTES, OTHERS_NOTES, SERVICE_EXEMPTION_NOTES, MANAGEMENT_FUNCTION_NOTES, KEY_ROOT_DOMAIN_OBJECT)								  
    select ID_INTERNAL, MASTER_DEGREE_TEACHING_NOTES, OTHERS_NOTES, SERVICE_EXEMPTION_NOTES, MANAGEMENT_FUNCTION_NOTES, KEY_ROOT_DOMAIN_OBJECT       
       from TEACHER_SERVICE where TEACHER_SERVICE.OTHERS_NOTES <> '' or 
       							  TEACHER_SERVICE.SERVICE_EXEMPTION_NOTES <> '' or 
       							  TEACHER_SERVICE.MANAGEMENT_FUNCTION_NOTES <> '' or 
       							  TEACHER_SERVICE.MASTER_DEGREE_TEACHING_NOTES <> ''; 

update TEACHER_SERVICE_ITEM set OJB_CONCRETE_CLASS = 'net.sourceforge.fenixedu.domain.teacher.TeacherServiceNotes' where OJB_CONCRETE_CLASS like '';       							         							  

alter table TEACHER_SERVICE drop column OTHERS_NOTES;
alter table TEACHER_SERVICE drop column SERVICE_EXEMPTION_NOTES;
alter table TEACHER_SERVICE drop column MANAGEMENT_FUNCTION_NOTES;
alter table TEACHER_SERVICE drop column MASTER_DEGREE_TEACHING_NOTES;

           							