scipro/resources/db_update_scripts/db_update_2012-08-10.sql
Jona Ekenberg 2fcd079183 hej
2013-01-18 19:55:18 +01:00

13 lines
607 B
SQL
Executable File

alter table `general_system_settings` drop column matchAlgorithmMatchesAreForceAccepted;
alter table `general_system_settings` drop column supervisorsCanAcceptDeclinePIs;
CREATE TABLE `first_meeting` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`firstMeetingDate` datetime NOT NULL,
`description` varchar(1024) NOT NULL,
`supervisoridea_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK2E9F13AC8DE85053` (`supervisoridea_id`),
CONSTRAINT `FK2E9F13AC8DE85053` FOREIGN KEY (`supervisoridea_id`) REFERENCES `supervisoridea` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;