MantisBT - ATutor
View Issue Details
0003252ATutorUpgradingpublic2007-12-17 06:592008-08-21 08:58
harris 
harris 
normalminoralways
closedfixed 
1.6 
1.6 
SVN
0003252: Database upgrade increases the database size.
The field sizes can be reduced to TEXT instead of MEDIUMTEXT.

http://www.atutor.ca/view/3/12062/1.html [^]
VARCHAR is 2^8 (for mysql <= 5)
TEXT is 2^16
MEDIUMTEXT is 2^32

Multiplying 2^8 by 4 is still 2^10, it should be TEXT instead.

Moreover, some fields like real_name, title can even be in VARCHAR(255), because ASCII characters are mostly in 1-byte, and there is really no need for a title to be in TEXT.
No tags attached.
Issue History
2007-12-17 06:59harrisNew Issue
2007-12-17 06:59harrisAffects version => SVN
2007-12-17 07:01harrisNote Added: 0002658
2007-12-17 07:22harrisStatusnew => assigned
2007-12-17 07:22harrisAssigned To => harris
2007-12-17 07:23harrisStatusassigned => resolved
2007-12-17 07:23harrisFixed in Version => 1.6
2007-12-17 07:23harrisResolutionopen => fixed
2007-12-17 07:23harrisNote Added: 0002659
2008-08-21 08:58gregStatusresolved => closed

Notes
(0002658)
harris   
2007-12-17 07:01   
probably name-related, and title-related should remain the same size.

comments/description has to be in text.
(0002659)
harris   
2007-12-17 07:23   
7168