From: <car...@us...> - 2009-12-23 17:38:39
|
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. |