[Obo-svn-commit] SF.net SVN: obo:[2978] OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema. sql

[<car...@us...>]

Revision: 2978
          http://obo.svn.sourceforge.net/obo/?rev=2978&view=rev
Author:   cartik73
Date:     2009-12-23 17:38:31 +0000 (Wed, 23 Dec 2009)

Log Message:
-----------
One last index to the phenotype_by_entity_Char table

Modified Paths:
--------------
    OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql

Modified: OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql
===================================================================
--- OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql	2009-12-23 17:18:01 UTC (rev 2977)
+++ OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql	2009-12-23 17:38:31 UTC (rev 2978)
@@ -86,6 +86,7 @@
 CREATE INDEX subject_index ON phenotype_by_entity_character(subject_nid);
 CREATE INDEX subject_uid_index ON phenotype_by_entity_character(subject_uid);
 CREATE INDEX entity_uid_index ON phenotype_by_entity_character(entity_uid);
+CREATE INDEX character_uid_index ON phenotype_by_entity_character(character_uid);
 CREATE INDEX entity_index ON phenotype_by_entity_character(entity_nid);
 CREATE INDEX phenotype_nid_index ON phenotype_by_entity_character(phenotype_nid);
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.