ALTER TABLE `applicationperiodexemption` CHANGE `until` `until` DATETIME NOT NULL;
ALTER TABLE `applicationperiodexemption` ADD `comment` varchar(255) DEFAULT NULL;
ALTER TABLE `applicationperiodexemption` ADD `grantedOn` datetime NOT NULL;
ALTER TABLE `applicationperiodexemption` ADD `grantedBy_id` bigint(20) NOT NULL;
ALTER TABLE `applicationperiodexemption` ADD KEY `FK34182FD8DEC4D3D8` (`grantedBy_id`);

ALTER TABLE `general_system_settings` ADD `finalSeminarCreateDaysAhead` int(11) NOT NULL;
ALTER TABLE `general_system_settings` ADD COLUMN `finalSeminarThesisDaysAhead` int(11) NOT NULL;

ALTER TABLE `project_class_settings` ADD `maxFinalSeminarActiveParticipation` int(11) NOT NULL;
ALTER TABLE `project_class_settings` ADD `maxOpponentsOnFinalSeminar` int(11) NOT NULL;  
ALTER TABLE `project_class_settings` ADD `minFinalSeminarActiveParticipation` int(11) NOT NULL;
ALTER TABLE `project_class_settings` ADD `minOpponentsOnFinalSeminar` int(11) NOT NULL;

ALTER TABLE `general_system_settings` DROP `finalSeminarMinOpponents`;
ALTER TABLE `general_system_settings` DROP `finalSeminarMinParticipants`;

UPDATE `general_system_settings` SET `finalSeminarThesisDaysAhead` = 10;