[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
-------------------------------------------------------------