Redmine

I noticed that the database design for redmine used TEXT type for multiple fields that can contain large amounts of data, particularly the "description" field in the "issues" table and the "notes" field in the "journals" table. These fields in my opinion should really be given the MEDIUMTEXT type as reporters / commenters can often paste in large amounts of data (such as logs). that will easily exceed the size limit of 64kb which TEXT imposes.

I know that the sensible thing to do here would be for the person to simply add these logs as an attachment but you can not always expect people to be sensible, especially if you work with people that are not very technical and are simply reporting some bugs to you in a way you explained them to (which, as you might have guessed, is what we do at my work).

I've personally already updated my DB to use MEDIUMTEXT but I thought I'd report it here as I think it's in the interest of redmine to have it on that by default.