[Gmod-schema-cmts] schema/chado/modules/sequence/views implicit-feature-views.sql, 1.2, 1.3

[Scott C. <sco...@us...>]

Update of /cvsroot/gmod/schema/chado/modules/sequence/views
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv10554

Modified Files:
	implicit-feature-views.sql 
Log Message:
fixing the protein coding gene view to use the mrna view that is in the so schema


Index: implicit-feature-views.sql
===================================================================
RCS file: /cvsroot/gmod/schema/chado/modules/sequence/views/implicit-feature-views.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** implicit-feature-views.sql	22 May 2008 21:52:00 -0000	1.2
--- implicit-feature-views.sql	16 Oct 2008 22:06:33 -0000	1.3
***************
*** 4,8 ****
  -- The standard Chado pattern for protein coding genes
  -- is a feature of type 'gene' with 'mRNA' features as parts
! -- REQUIRES: 'mrna' view from sofa-bridge.sql
  CREATE OR REPLACE VIEW protein_coding_gene AS
   SELECT
--- 4,8 ----
  -- The standard Chado pattern for protein coding genes
  -- is a feature of type 'gene' with 'mRNA' features as parts
! -- REQUIRES: 'mrna' view from so-bridge.sql
  CREATE OR REPLACE VIEW protein_coding_gene AS
   SELECT
***************
*** 11,15 ****
    feature AS gene
    INNER JOIN feature_relationship AS fr ON (gene.feature_id=fr.object_id)
!   INNER JOIN mrna ON (mrna.feature_id=fr.subject_id);
  
  
--- 11,15 ----
    feature AS gene
    INNER JOIN feature_relationship AS fr ON (gene.feature_id=fr.object_id)
!   INNER JOIN so.mrna ON (mrna.feature_id=fr.subject_id);