SiT! Bugs - SiT!
View Issue Details
0001403SiT!otherpublic2010-09-26 18:542012-01-24 12:44
paulh 
 
normalmajoralways
confirmedopen 
 
 
0001403: We should store NULL rather than a empty string when as don't have the information
In several places we insert an empty string rather than NULL when we don't have the details

contacts.telephone is an example

We should consistent this way we can write more efficient ocde and more easily use IF in SQL
No tags attached.
related to 0000887resolved paulh db definition of sites and contacts 
related to 0000958resolved paulh contact's and site's phones 
related to 0001635resolved paulh Can't create site without department field 
related to 0001755resolved paulh Inconsistencies in "setup-schema.php" can cause an upgrade to fail 
related to 0001743confirmed  Inconsistencies in DB model 
Issue History
2010-09-26 18:54paulhNew Issue
2010-09-26 18:54paulhRelationship addedrelated to 0000887
2010-09-26 18:58paulhRelationship addedrelated to 0000958
2010-09-26 18:58paulhNote Added: 0003422
2010-10-12 18:30ivanNote Added: 0003431
2011-07-02 20:09TomseRelationship addedrelated to 0001635
2012-01-07 12:36TomseRelationship addedchild of 0001755
2012-01-07 12:37TomseRelationship deletedchild of 0001755
2012-01-07 12:37TomseRelationship addedrelated to 0001755
2012-01-07 12:38TomseRelationship addedrelated to 0001743
2012-01-24 12:44ivanStatusnew => confirmed

Notes
(0003422)
paulh   
2010-09-26 18:58   
git b9e96ff comes across this problem
(0003431)
ivan   
2010-10-12 18:30   
We should, but we don't currently. So any change to this would mean we need a process to alter existing data.