[Bioperl-l] Re: bioperl-db

[Mike Muratet]

On Tue, 20 Jul 2004, Hilmar Lapp wrote:

> If (and it seems you are) you're using a version of bioperl-db updated  
> some time in I believe May or so (shame on me for not tagging...) then  
> the namespace if provided will always be included in the lookup.
> 
> This is to support the inclusion of namespace in the two alternative  
> key definitions on bioentry, i.e., (accession,version,namespace) and  
> (identifier,namespace). The schema DDL definition as in CVS defines  
> identifier as unique by itself, but given earlier feedback this is  
> likely to be changed. At any rate, you may choose either definition of  
> the unique key.
> 
> So, most likely what you want is to change the unique key definition of  
> identifier to include biodatabase_id. If you don't know how to do that  
> I can send you the SQL code.
> 
> 	-hilmar
> 

Hilmar

Thanks.

I'll take a look at table definitions. Redefining the keys isn't any more
than creating a new table with the new keys and selecting from the old
table is it? I can't remember if mysql allows you to alter keys in
tables.

Mike