alter table COORDINATOR add column KEY_PERSON int(11) default null;
update COORDINATOR, TEACHER, PARTY set COORDINATOR.KEY_PERSON = PARTY.ID_INTERNAL where COORDINATOR.KEY_TEACHER = TEACHER.ID_INTERNAL and TEACHER.KEY_PERSON = PARTY.ID_INTERNAL;
alter table COORDINATOR change column KEY_PERSON KEY_PERSON int(11) not null;
alter table COORDINATOR drop key U1;
