[Bioperl-l] Re: bioperl-db
muratem at eng.uah.edu
Wed Jul 21 15:29:17 EDT 2004
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.
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
More information about the Bioperl-l