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

[nobody at svn.erp5.org]

Author: vincent
Date: Wed Feb 20 16:44:11 2008
New Revision: 19441

URL: http://svn.erp5.org?rev=19441&view=rev
Log:
Add an index on serialization_tag column.

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=19441&r1=19440&r2=19441&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql Wed Feb 20 16:44:11 2008
@@ -28,6 +28,7 @@
   KEY (`method_id`),
   KEY `processing_node_processing` (`processing_node`, `processing`),
   KEY `processing_node_date` (`processing_node`, `date`),
+  KEY `processing_node_serialization_tag` (`processing_node`, `serialization_tag`),
   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=19441&r1=19440&r2=19441&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql Wed Feb 20 16:44:11 2008
@@ -25,6 +25,7 @@
   KEY (`method_id`),
   KEY `processing_node_processing` (`processing_node`, `processing`),
   KEY `processing_node_date` (`processing_node`, `date`),
+  KEY `processing_node_serialization_tag` (`processing_node`, `serialization_tag`),
   KEY (`priority`),
   KEY (`tag`)
 ) TYPE = InnoDB;