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

13 lines
476 B
SQL
Executable File

ALTER TABLE `supervisoridea`
DROP `hidden`;
CREATE TABLE `projectidea_first_meeting` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`description` longtext NOT NULL,
`firstMeetingDate` datetime NOT NULL,
`projectIdea_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKD6A43F3D4E31D7A1` (`projectIdea_id`),
CONSTRAINT `FKD6A43F3D4E31D7A1` FOREIGN KEY (`projectIdea_id`) REFERENCES `projectIdea` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;