[Treebase-guts] SF.net SVN: treebase:[333] trunk/treebase-core/src/main/resources/ TBASE2_POSTGRES_CREATION.sql

[<rv...@us...>]

Revision: 333
          http://treebase.svn.sourceforge.net/treebase/?rev=333&view=rev
Author:   rvos
Date:     2009-12-09 14:34:19 +0000 (Wed, 09 Dec 2009)

Log Message:
-----------
Updated SQL creation script

Modified Paths:
--------------
    trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql

Modified: trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql
===================================================================
--- trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql	2009-12-05 14:17:31 UTC (rev 332)
+++ trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql	2009-12-09 14:34:19 UTC (rev 333)
@@ -2513,4 +2513,22 @@
 	FOREIGN KEY(COLUMNRANGE_ID)
 	REFERENCES COLUMNRANGE(COLUMNRANGE_ID)
 	ON DELETE NO ACTION 
-	ON UPDATE NO ACTION;
\ No newline at end of file
+	ON UPDATE NO ACTION;
+
+-- INDICES
+CREATE INDEX matrixcolumn_phylochar_id_idx ON matrixcolumn(phylochar_id);
+CREATE INDEX matrixrow_taxonlabel_id_idx ON matrixrow(taxonlabel_id);
+CREATE INDEX matrixrow_matrix_id_idx on matrixrow(matrix_id);
+CREATE INDEX matrixdatatype_phylochar_id_idx ON matrixdatatype(phylochar_id);
+CREATE INDEX rowsegment_matrixrow_id_idx ON rowsegment(matrixrow_id);
+
+CREATE INDEX matrixelement_matrixcolumn_id_idx ON matrixelement(matrixcolumn_id);
+CREATE INDEX matrixelement_matrixrow_id_idx ON matrixelement(matrixrow_id);
+CREATE INDEX matrixelement_discretecharstate_id_idx ON matrixelement(discretecharstate_id);
+
+CREATE INDEX matrixelement_discretecharstate_id_idx ON matrixelement(discretecharstate_id);
+CREATE INDEX discretecharstate_phylochar_id_idx ON discretecharstate(phylochar_id);
+
+CREATE INDEX analysis_study_id_idx ON analysis(study_id);
+CREATE INDEX submission_study_id_idx ON submission(study_id);
+CREATE INDEX study_citation_id_idx ON study(citation_id);
\ No newline at end of file


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