20 lines
1.2 KiB
SQL
Executable File
20 lines
1.2 KiB
SQL
Executable File
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;
|
|
|