[Erp5-report] r17163 - in /erp5/trunk/bt5/erp5_banking_core: CatalogMethodTemplateItem/port...

[nobody at svn.erp5.org]

Author: aurel
Date: Wed Oct 24 13:47:27 2007
New Revision: 17163

URL: http://svn.erp5.org?rev=17163&view=rev
Log:
add index in stock table

Modified:
    erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml
    erp5/trunk/bt5/erp5_banking_core/bt/revision

Modified: erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml?rev=17163&r1=17162&r2=17163&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml Wed Oct 24 13:47:27 2007
@@ -128,7 +128,9 @@
   KEY `simulation_state` (`simulation_state`),\n
   KEY `resource_node_uid` (`resource_uid`, `node_uid`),\n
   KEY `resource_section_node_uid` (`resource_uid`, `section_uid`, `node_uid`, `simulation_state`),\n
-  KEY `resource_payment_state` (`resource_uid`, `payment_uid`, `simulation_state`)\n
+  KEY `resource_payment_state` (`resource_uid`, `payment_uid`, `simulation_state`),\n
+  KEY `resource_payment` (`resource_uid`, `payment_uid`),\n
+  KEY `resource_payment_state_date` (`resource_uid`, `payment_uid`, `simulation_state`, `date`)\n
 ) TYPE = InnoDB;\n
 </string> </value>
         </item>
@@ -200,7 +202,9 @@
   KEY `simulation_state` (`simulation_state`),\n
   KEY `resource_node_uid` (`resource_uid`, `node_uid`),\n
   KEY `resource_section_node_uid` (`resource_uid`, `section_uid`, `node_uid`, `simulation_state`),\n
-  KEY `resource_payment_state` (`resource_uid`, `payment_uid`, `simulation_state`)\n
+  KEY `resource_payment_state` (`resource_uid`, `payment_uid`, `simulation_state`),\n
+  KEY `resource_payment` (`resource_uid`, `payment_uid`),\n
+  KEY `resource_payment_state_date` (`resource_uid`, `payment_uid`, `simulation_state`, `date`)\n
 ) TYPE = InnoDB;\n
 </string> </value>
                     </item>

Modified: erp5/trunk/bt5/erp5_banking_core/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/bt/revision?rev=17163&r1=17162&r2=17163&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/bt/revision (original)
+++ erp5/trunk/bt5/erp5_banking_core/bt/revision Wed Oct 24 13:47:27 2007
@@ -1,1 +1,1 @@
-369
+371