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

7 lines
494 B
SQL
Executable File

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