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

[nobody at svn.erp5.org]

Author: aurel
Date: Thu Apr  5 11:13:41 2007
New Revision: 13964

URL: http://svn.erp5.org?rev=13964&view=rev
Log:
2007-04-05 Aurel
* fix index for category table

Modified:
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_category.xml
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/change_log
    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_category.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_category.xml?rev=13964&r1=13963&r2=13964&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_category.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_category.xml Thu Apr  5 11:13:41 2007
@@ -101,10 +101,9 @@
   `base_category_uid` BIGINT UNSIGNED default \'0\',\n
   `category_strict_membership` tinyint(1) default \'0\',\n
   KEY `uid` (`uid`),\n
-  KEY `category_strict_membership` (`category_strict_membership`),\n
   KEY `Membership` (`category_uid`,`base_category_uid`),\n
-  KEY `FuzzyMembership` (`category_uid`)\n
 ) TYPE = InnoDB; \n
+\n
 </string> </value>
         </item>
         <item>
@@ -149,10 +148,9 @@
   `base_category_uid` BIGINT UNSIGNED default \'0\',\n
   `category_strict_membership` tinyint(1) default \'0\',\n
   KEY `uid` (`uid`),\n
-  KEY `category_strict_membership` (`category_strict_membership`),\n
   KEY `Membership` (`category_uid`,`base_category_uid`),\n
-  KEY `FuzzyMembership` (`category_uid`)\n
 ) TYPE = InnoDB; \n
+\n
 </string> </value>
                     </item>
                   </dictionary>

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/change_log
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/change_log?rev=13964&r1=13963&r2=13964&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/change_log (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/change_log Thu Apr  5 11:13:41 2007
@@ -1,3 +1,6 @@
+2007-04-05 Aurel
+* fix index for category table
+
 2007-02-01 Romain
 * Add mirror_date column to the stock table.
 

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=13964&r1=13963&r2=13964&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 Thu Apr  5 11:13:41 2007
@@ -1,1 +1,1 @@
-40
+41