[BioSQL-l] Updates to biosql Oracle schema

[mark.schreiber at group.novartis.com]

Actually this was my mistake. The thing I changed (in Lens Schema) was:

ALTER TABLE "BIOJAVA_LEN"."BIOENTRY_QUALIFIER_VALUE"
   MODIFY ("VALUE" VARCHAR2(300))

Some of those viruses have bloody long descriptions!

- Mark

Mark Schreiber
Principal Scientist (Bioinformatics)

Novartis Institute for Tropical Diseases (NITD)
10 Biopolis Road
#05-01 Chromos
Singapore 138670
www.nitd.novartis.com

phone +65 6722 2973
fax  +65 6722 2910





Hilmar Lapp <hlapp at gnf.org>
11/16/2004 09:24 AM

 
        To:     "Richard HOLLAND" <hollandr at gis.a-star.edu.sg>
        cc:     Mark Schreiber/GP/Novartis at PH, <biosql-l at open-bio.org>
        Subject:        Re: [BioSQL-l] Updates to biosql Oracle schema



On Nov 15, 2004, at 5:08 PM, Richard HOLLAND wrote:

> The column failing was bioentry_qualifer_value.value, which when 
> expanded to 300 characters in
> length was able to store it. Not sure if this should be changed in 
> BioSQL or not?

I assume you mean 3000, not 300? In the DDL script the width is 
actually expanded to 4000, the full size. Also, if it's a translation 
then it will have been in the feature table, and the respective table 
would then be seqfeature_qualifier_value.

Apparently both column width expansions are in the DDL, but not in the 
migration script. I added them both to the migration script too 
(sql/biosql-ora/migrate/1.0/migrate-all.sql).

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