[BioSQL-l] common_name (not) nullable

[Hilmar Lapp]

Minor (hopefully) issue: column common_name in Taxa is not nullable, 
although many times the value is not known when you store an object. 
The way the adaptor code worked in the past is substituting an empty 
string for undef (which would have translated to NULL). MySQL does 
allow you to cheat this way; other RDBMSs don't (e.g., Oracle).

I propose to make common_name nullable. This will have no effect on 
adaptor code. Any objections?

	-hilmar
--
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------