12 lines
459 B
SQL
Executable File
12 lines
459 B
SQL
Executable File
-- ALTER TABLE projectIdea_role CHANGE `authors_id` `authors_id` bigint(20) DEFAULT NULL;
|
|
-- ALTER TABLE projectIdea_role ADD `interestedSupervisors_id` bigint(20) DEFAULT NULL;
|
|
|
|
CREATE TABLE IF NOT EXISTS `projectIdea_employee` (
|
|
`pi_id` bigint(20) NOT NULL,
|
|
`empl_id` bigint(20) NOT NULL,
|
|
KEY `empl_id` (`empl_id`),
|
|
KEY `pi_id` (`pi_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
ALTER TABLE weights
|
|
ADD `supervisorInterestPoints` int(11) NOT NULL; |