-- Increase limit on Watson fields
ALTER TABLE  `projectIdea` CHANGE  `practicalHow`  `practicalHow` VARCHAR( 4000 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
ALTER TABLE  `projectIdea` CHANGE  `theoryHow`  `theoryHow` VARCHAR( 4000 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
ALTER TABLE  `projectIdea` CHANGE  `what`  `what` VARCHAR( 4000 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
ALTER TABLE  `projectIdea` CHANGE  `why`  `why` VARCHAR( 4000 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

CREATE TABLE IF NOT EXISTS `weights` (
  `id` bigint(20) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `lastModified` datetime NOT NULL,
  `version` int(11) NOT NULL,
  `keywordPoints` int(11) NOT NULL,
  `preferredSupervisorPoints` int(11) NOT NULL,
  `researchAreaPoints` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;