[BioSQL-l] Some modifications

Hilmar Lapp hlapp@gnf.org
Wed, 4 Sep 2002 11:34:57 -0700


Added Binomial to table taxa. Made Binomial, Common_name, and 
NCBI_Taxa_Id unique keys. Common_Name is now nullable.

Added Authority to table Biodatabase. Made Name a unique key.

Made Term_Name in table Ontology_Term NOT NULL and a unique key.

All these changes should be neutral to current adaptor 
implementations unless you are using SELECT * (which you shouldn't 
do anyway). Unique keys on nullable columns is only supported since 
recent versions of MySQL, so you may need to upgrade your MySQL in 
order to use this latest revision of BioSQL.

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