[Gmod-schema-cmts] schema/chado/modules default_schema.sql, 1.49, 1.50

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

Update of /cvsroot/gmod/schema/chado/modules
In directory sc8-pr-cvs2.sourceforge.net:/tmp/cvs-serv26160/modules

Modified Files:
	default_schema.sql 
Log Message:
a left over fix for the GFF preprocessor and minor fixes to the gbrowse all names view, and a minor doc fix for the materialized view tool.


Index: default_schema.sql
===================================================================
RCS file: /cvsroot/gmod/schema/chado/modules/default_schema.sql,v
retrieving revision 1.49
retrieving revision 1.50
diff -C2 -d -r1.49 -r1.50
*** default_schema.sql	5 Dec 2007 16:00:15 -0000	1.49
--- default_schema.sql	12 Dec 2007 04:03:29 -0000	1.50
***************
*** 5922,5931 ****
    name
  ) AS
! SELECT feature_id,uniquename FROM feature
  UNION
! SELECT feature_id, name FROM feature
  UNION
  SELECT fs.feature_id,s.name FROM feature_synonym fs, synonym s
!   WHERE fs.synonym_id = s.synonym_id;
  
  --------------------------------
--- 5922,5932 ----
    name
  ) AS
! SELECT feature_id,CAST(substring(uniquename from 0 for 255) as varchar(255)) as name FROM feature
  UNION
! SELECT feature_id, name FROM feature where name is not null
  UNION
  SELECT fs.feature_id,s.name FROM feature_synonym fs, synonym s
!   WHERE fs.synonym_id = s.synonym_id ;
! 
  
  --------------------------------