Re: [GUSDEV] Please Review: Proposed Schema changes for GUS 3.6 Release

[Jian Lu <jl...@vb...>]

Hi Frank,

I am working on PATRIC project at VBI. We have the following 
tables/views that have been modified to meet the data needs.

DoTS/DoTSVer

TABLES:
alter table Dots.SECONDARYACCS modify (SECONDARY_ACCS VARCHAR2(20));
alter table DotsVer.SECONDARYACCSVer modify (SECONDARY_ACCS VARCHAR2(20));

VIEWS:
Source/SourceVer:
   add a new column: STRING43 AS MOL_TYPE

ProteinFeature/ProteinFeatureVer:
  add new columns: STRING15 AS PROTEIN_ID, CLOB1 AS TRANSLATION

Repeats/RepeatsVer:
  add new columns: STRING13 AS TRANSPOSON, STRING14 AS INSERTION_SEQ

RNAType/RNATypeVer:
  add new columns: CLOB1 AS TRANSLATION, NUMBER3 AS ANTICODON_CENTER, 
FLOAT1 AS SCORE


SRes/SResVer

alter table SRes.GOSYNONYM modify (TEXT VARCHAR2(1000));
alter table SResVer.GOSYNONYMVer modify (TEXT VARCHAR2(1000));

alter table SRes.ExternalDatabaseEntry modify(DESCRIPTION VARCHAR2(4000));
alter table SResVer.ExternalDatabaseEntryVer modify(DESCRIPTION 
VARCHAR2(4000));

alter table SRes.SequenceOntology modify(DEFINITION VARCHAR2(2000));
alter table SResVer.SequenceOntologyVer modify(DEFINITION VARCHAR2(2000));


Frank Innamorato wrote:
> *Proposed Schema changes for GUS 3.6 Release*
>
> CBIL will be releasing GUS v3.6 in the first quarter of this year.  
> Before the schema is finalized, we are asking for review from the GUS 
> community.
>
> We have compiled a series of changes based upon the GUS bug tracker, 
> as well as from informal modifications that have occurred in other GUS 
> installations.
>
> Please review the current proposed changes for GUS 3.6 within the next 
> two weeks.
> The changes can be found on the wiki page Proposed Schema Changes 
> <http://www.gusdb.org/wiki/index.php/Proposed%20Schema%20Changes>
>
> *IMPORTANT - Do not modify these pages!*
> Please submit suggestions on the GUS-3.6 Schema Change Request 
> <http://www.gusdb.org/wiki/index.php/GUS-3.6%20Schema%20Change%20Request> 
> wiki page, or send an email to fr...@pc...
>
> The GUS 3.6 schema wiki pages are incomplete and are still being 
> updated. Changes will be occurring regularly as contributer 
> submissions are being addressed.  Please note: the GUS 3.6 release 
> will NOT include a schema upgrade script, and will not focus on index 
> changes.  Index changes are tracked and will occur in a future 
> release.  Indexes will be added for new tables, and some minor index 
> changes may be included in the release.
>
> Thanks,
> -Frank
>
> Frank Innamorato
> Database Administrator
> Computational Biology and Informatics Laboratory
> Penn Center for Bioinformatics
> 1410 Blockley Hall
> 423 Guardian Drive
> University of Pennsylvania
> Philadelphia, PA 19104
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> ------------------------------------------------------------------------
>
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>