[Erp5-report] r18105 - in /erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog: Ca...

[nobody at svn.erp5.org]

Author: vincent
Date: Fri Dec  7 10:03:34 2007
New Revision: 18105

URL: http://svn.erp5.org?rev=18105&view=rev
Log:
Add a key on aggregate_uid, simulation_state and date. This is used in LEFT JOINs done by Resource_zGetTrackingList.

Modified:
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml?rev=18105&r1=18104&r2=18105&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml Fri Dec  7 10:03:34 2007
@@ -3,11 +3,8 @@
   <record id="1" aka="AAAAAAAAAAE=">
     <pickle>
       <tuple>
-        <tuple>
-          <string>Products.ZSQLMethods.SQL</string>
-          <string>SQL</string>
-        </tuple>
-        <none/>
+        <global name="SQL" module="Products.ZSQLMethods.SQL"/>
+        <tuple/>
       </tuple>
     </pickle>
     <pickle>
@@ -108,9 +105,9 @@
   KEY `node_uid` (`node_uid`),\n
   KEY `section_uid` (`section_uid`),\n
   KEY `resource_uid` (`resource_uid`),\n
-  KEY `variation_text` (`variation_text`)\n
+  KEY `variation_text` (`variation_text`),\n
+  KEY `aggregate_simulation_state_date` (`aggregate_uid`,`simulation_state`,`date`)\n
 ) TYPE=InnoDB;\n
-\n
 </string> </value>
         </item>
         <item>
@@ -118,9 +115,11 @@
             <value>
               <object>
                 <klass>
+                  <global name="__newobj__" module="copy_reg"/>
+                </klass>
+                <tuple>
                   <global name="SQL" module="Shared.DC.ZRDB.DA"/>
-                </klass>
-                <none/>
+                </tuple>
                 <state>
                   <dictionary>
                     <item>
@@ -162,9 +161,9 @@
   KEY `node_uid` (`node_uid`),\n
   KEY `section_uid` (`section_uid`),\n
   KEY `resource_uid` (`resource_uid`),\n
-  KEY `variation_text` (`variation_text`)\n
+  KEY `variation_text` (`variation_text`),\n
+  KEY `aggregate_simulation_state_date` (`aggregate_uid`,`simulation_state`,`date`)\n
 ) TYPE=InnoDB;\n
-\n
 </string> </value>
                     </item>
                   </dictionary>

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision?rev=18105&r1=18104&r2=18105&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision Fri Dec  7 10:03:34 2007
@@ -1,1 +1,1 @@
-85
+86