MantisBT - ATutor
View Issue Details
0003946ATutorInstallationpublic2009-09-29 10:132009-11-05 11:11
greg 
cindy 
normalminoralways
closedfixed 
 
1.6.4 
SVN
0003946: member table address bug
The creation of the member table inserts an address filed with NOT NULL. Address is optional so NULL values should be accepted.
No tags attached.
Issue History
2009-09-29 10:13gregNew Issue
2009-09-29 10:13gregAffects version => SVN
2009-10-26 09:54harrisNote Added: 0003805
2009-11-04 11:29gregStatusnew => assigned
2009-11-04 11:29gregAssigned To => cindy
2009-11-05 08:09cindyStatusassigned => resolved
2009-11-05 08:09cindyFixed in Version => 1.6.4
2009-11-05 08:09cindyResolutionopen => fixed
2009-11-05 08:09cindyNote Added: 0003824
2009-11-05 09:21cindyStatusresolved => feedback
2009-11-05 09:21cindyResolutionfixed => reopened
2009-11-05 09:22cindyStatusfeedback => resolved
2009-11-05 09:22cindyResolutionreopened => fixed
2009-11-05 09:22cindyNote Added: 0003826
2009-11-05 11:11gregStatusresolved => closed

Notes
(0003805)
harris   
2009-10-26 09:54   
We can save data as '', an empty string.

Is there another reason why we should allow null?
(0003824)
cindy   
2009-11-05 08:09   
svn revision: 8872

solution: replace all field definition of "text not null" with "text"

affected script: install/db/atutor_schema.sql
(0003826)
cindy   
2009-11-05 09:22   
svn revision: 8875

modify upgrade sql file

affected script: install/db/atutor_upgrade_1.6.3_1.6.4.sql