[Erp5-report] r6330 - /erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogMethodTemplateIt...

[nobody at svn.erp5.org]

Author: jerome
Date: Tue Mar 28 12:40:48 2006
New Revision: 6330

URL: http://svn.erp5.org?rev=6330&view=rev
Log:
remove indexes on meta type. add indexes on reference & title

Modified:
    erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql/z_create_catalog.xml

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql/z_create_catalog.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql/z_create_catalog.xml?rev=6330&r1=6329&r2=6330&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql/z_create_catalog.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql/z_create_catalog.xml Tue Mar 28 12:40:48 2006
@@ -130,10 +130,10 @@
   KEY `security_uid` (`security_uid`),\n
   KEY `Parent` (`parent_uid`),\n
   KEY `Path` (`path`),\n
+  KEY `Title` (`title`),\n
+  KEY `Reference` (`reference`),\n
   KEY `relative_url` (`relative_url`),\n
-  KEY `Type` (`meta_type`,`portal_type`),\n
-  KEY `Type1` (`portal_type`),\n
-  KEY `Type2` (`meta_type`),\n
+  KEY `Portal Type` (`portal_type`),\n
   KEY `opportunity_state` (`opportunity_state`),\n
   KEY `validation_state` (`validation_state`),\n
   KEY `simulation_state` (`simulation_state`),\n
@@ -215,10 +215,10 @@
   KEY `security_uid` (`security_uid`),\n
   KEY `Parent` (`parent_uid`),\n
   KEY `Path` (`path`),\n
+  KEY `Title` (`title`),\n
+  KEY `Reference` (`reference`),\n
   KEY `relative_url` (`relative_url`),\n
-  KEY `Type` (`meta_type`,`portal_type`),\n
-  KEY `Type1` (`portal_type`),\n
-  KEY `Type2` (`meta_type`),\n
+  KEY `Portal Type` (`portal_type`),\n
   KEY `opportunity_state` (`opportunity_state`),\n
   KEY `validation_state` (`validation_state`),\n
   KEY `simulation_state` (`simulation_state`),\n