[Gmod-schema-cmts] schema/chado/modules/genetic genetic.sql, 1.24, 1.25

[David E. <em...@us...>]

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

Modified Files:
	genetic.sql 
Log Message:
Add indexes to table phenotype_comparison


Index: genetic.sql
===================================================================
RCS file: /cvsroot/gmod/schema/chado/modules/genetic/genetic.sql,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** genetic.sql	9 Nov 2006 17:20:55 -0000	1.24
--- genetic.sql	9 Nov 2006 17:24:26 -0000	1.25
***************
*** 193,196 ****
      CONSTRAINT phenotype_comparison_c1 UNIQUE (genotype1_id,environment1_id,genotype2_id,environment2_id,phenotype1_id,type_id,pub_id)
  );
! 
  COMMENT ON TABLE phenotype_comparison IS 'comparison of phenotypes eg, genotype1/environment1/phenotype1 "non-suppressible" wrt  genotype2/environment2/phenotype2';
--- 193,199 ----
      CONSTRAINT phenotype_comparison_c1 UNIQUE (genotype1_id,environment1_id,genotype2_id,environment2_id,phenotype1_id,type_id,pub_id)
  );
! CREATE INDEX phenotype_comparison_idx1 on phenotype_comparison (genotype1_id);
! CREATE INDEX phenotype_comparison_idx2 on phenotype_comparison (genotype2_id);
! CREATE INDEX phenotype_comparison_idx3 on phenotype_comparison (type_id);
! CREATE INDEX phenotype_comparison_idx4 on phenotype_comparison (pub_id);
  COMMENT ON TABLE phenotype_comparison IS 'comparison of phenotypes eg, genotype1/environment1/phenotype1 "non-suppressible" wrt  genotype2/environment2/phenotype2';