-- 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;