[Erp5-report] r18424 - /erp5/trunk/products/CMFActivity/skins/activity/

[nobody at svn.erp5.org]

Author: vincent
Date: Wed Dec 19 16:31:37 2007
New Revision: 18424

URL: http://svn.erp5.org?rev=18424&view=rev
Log:
Add an index used when reserving message for a given node.

Modified:
    erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql
    erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql

Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql?rev=18424&r1=18423&r2=18424&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql Wed Dec 19 16:31:37 2007
@@ -26,6 +26,7 @@
   KEY (`path`),
   KEY (`method_id`),
   KEY `processing_node_processing` (`processing_node`, `processing`),
+  KEY `processing_node_date` (`processing_node`, `date`),
   KEY (`priority`),
   KEY (`tag`),
   KEY (`order_validation_text`)

Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql?rev=18424&r1=18423&r2=18424&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql Wed Dec 19 16:31:37 2007
@@ -23,6 +23,7 @@
   KEY (`path`),
   KEY (`method_id`),
   KEY `processing_node_processing` (`processing_node`, `processing`),
+  KEY `processing_node_date` (`processing_node`, `date`),
   KEY (`priority`),
   KEY (`tag`)
 ) TYPE = InnoDB;