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

8 lines
459 B
SQL
Executable File

CREATE TABLE `projectIdea_Employee` (
`projectIdea_id` bigint(20) NOT NULL,
`supervisorInterest_id` bigint(20) NOT NULL,
KEY `FK485C987D4E31D7A1` (`projectIdea_id`),
KEY `FK485C987DBB2259FB` (`supervisorInterest_id`),
CONSTRAINT `FK485C987DBB2259FB` FOREIGN KEY (`supervisorInterest_id`) REFERENCES `role` (`id`),
CONSTRAINT `FK485C987D4E31D7A1` FOREIGN KEY (`projectIdea_id`) REFERENCES `projectIdea` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1