scipro/resources/db_update_scripts/db_update_2013-05-10.sql
2013-05-10 16:05:57 +09:00

16 lines
820 B
SQL
Executable File

DELETE FROM `message_board` WHERE `message_board`.`id` = 88;
DELETE FROM `message_board` WHERE `message_board`.`id` = 370;
DELETE FROM `message_board` WHERE `message_board`.`id` = 479;
DELETE FROM `message_board` WHERE `message_board`.`id` = 493;
CREATE TABLE IF NOT EXISTS `general_system_settings_fs_thesis_comment_punish_recipients` (
`GeneralSystemSettings_id` bigint(20) NOT NULL,
`mail` varchar(255) DEFAULT NULL,
KEY `FKBB22CEE02AC37675` (`GeneralSystemSettings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `general_system_settings_fs_thesis_comment_punish_recipients` (`GeneralSystemSettings_id`, `mail`) VALUES
(1, 'matchsupport@dsv.su.se');
ALTER TABLE final_seminar ADD `punishChecked` tinyint(1) NOT NULL;
ALTER TABLE `general_system_settings` ADD `punishMailDate` datetime DEFAULT NULL;