MantisBT - ATutor
View Issue Details
0004688ATutorGlobalpublic2011-01-12 11:272011-08-18 13:04
cindy 
cindy 
normalminoralways
closedfixed 
2.0.2 
2.0.3 
SVN
0004688: Table created with field set to "text not null"
In atutor_schema.sql, some tables are created with fields' option "text not null". Since default value cannot be set on text fields (refer to http://atutor.ca/atutor/mantis/view.php?id=3922 [^]), "not null" part is unnecessary. It would cause error when no value is given at the insert.
No tags attached.
Issue History
2011-01-12 11:27cindyNew Issue
2011-01-12 11:41cindyNote Added: 0004882
2011-01-12 11:41cindyStatusnew => resolved
2011-01-12 11:41cindyFixed in Version => 2.0.3
2011-01-12 11:41cindyResolutionopen => fixed
2011-01-12 11:41cindyAssigned To => cindy
2011-08-18 13:04gregNote Added: 0005176
2011-08-18 13:04gregStatusresolved => closed

Notes
(0004882)
cindy   
2011-01-12 11:41   
SVN revision: 10608

Altered table fields that are created with "text not null" to "text".

Affected:
atutor_schema.sql
atutor_upgrade_2.0.2_to_2.0.3.sql
(0005176)
greg   
2011-08-18 13:04   
first round of 2.0.3 changes closed