-- increase max chars to 4000
ALTER TABLE  `supervisoridea` CHANGE  `requirements`  `requirements` VARCHAR( 4000 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

ALTER TABLE `projectIdea` ADD `showSupervisor` bit(1) DEFAULT 0;

-- this below has already been run on the prod db, not as part of a deploy but in order to fix a bug quickly
-- ALTER TABLE `supervisoridea` CHANGE `requirements` `requirements` VARCHAR( 1024 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;