alter table `SUMMARY` add `END_TIME` time;

alter table `LESSON_INSTANCE` add `OID_MISSED_PROFESSORSHIP` bigint unsigned, add index (OID_MISSED_PROFESSORSHIP);

alter table `SHIFT_ENROLMENT` add `OID_SHIFT_CAPACITY` bigint unsigned, add index (OID_SHIFT_CAPACITY);
create table `SHIFT_CAPACITY` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `CAPACITY_TYPE` text, `CAPACITY` int(11), `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OID_SHIFT` bigint unsigned, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_SHIFT), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
