


-- Inserted at 2010-04-27T18:10:05.346+01:00

alter table `COMPETENCE_COURSE_INFORMATION` add column `OID_COMPETENCE_COURSE_GROUP_UNIT` bigint(20);
alter table `COMPETENCE_COURSE_INFORMATION` add index (`OID_COMPETENCE_COURSE_GROUP_UNIT`);

update COMPETENCE_COURSE_INFORMATION as Information set OID_COMPETENCE_COURSE_GROUP_UNIT = (select Course.OID_COMPETENCE_COURSE_GROUP_UNIT from COMPETENCE_COURSE as Course where Course.OID_COMPETENCE_COURSE_GROUP_UNIT is not NULL and Course.OID = Information.OID_COMPETENCE_COURSE);

