svn commit: r1002793 - /subversion/trunk/subversion/libsvn_wc/wc-metadata.sql

[philip]

Author: philip
Date: Wed Sep 29 18:07:38 2010
New Revision: 1002793

URL: http://svn.apache.org/viewvc?rev=1002793&view=rev
Log:
* subversion/libsvn_wc/wc-metadata.sql
  (I_NODES_PARENT): Add op_depth to index.
  (I_NODES_PATH): Remove index as unneeded given the PRIMARY KEY.

Modified:
    subversion/trunk/subversion/libsvn_wc/wc-metadata.sql

Modified: subversion/trunk/subversion/libsvn_wc/wc-metadata.sql
URL: 
http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_wc/wc-metadata.sql?rev=1002793&r1=1002792&r2=1002793&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-metadata.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-metadata.sql Wed Sep 29 18:07:38 
2010
@@ -861,8 +861,7 @@ CREATE TABLE NODES (
 
   );
 
-CREATE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath);
-CREATE INDEX I_NODES_PATH ON NODES (wc_id, local_relpath);
+CREATE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath, op_depth);