[Erp5-report] r32277 aurel - in /erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catal...
nobody at svn.erp5.org
nobody at svn.erp5.org
Fri Feb 5 09:19:07 CET 2010
Author: aurel
Date: Fri Feb 5 09:19:06 2010
New Revision: 32277
URL: http://svn.erp5.org?rev=32277&view=rev
Log:
2010-02-05 aurel
* add more columns into versioning table in order to use frequency_index
Modified:
erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_versioning_list.xml
erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_versioning.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_catalog_versioning_list.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_versioning_list.xml?rev=32277&r1=32276&r2=32277&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_versioning_list.xml [utf8] (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_versioning_list.xml [utf8] Fri Feb 5 09:19:06 2010
@@ -24,6 +24,12 @@
<value>
<dictionary>
<item>
+ <key> <string>getCreationDateIndex</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
<key> <string>getEffectiveDate</string> </key>
<value>
<dictionary/>
@@ -31,6 +37,12 @@
</item>
<item>
<key> <string>getExpirationDate</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>getFrequencyIndex</string> </key>
<value>
<dictionary/>
</value>
@@ -72,6 +84,8 @@
<string>getRevision</string>
<string>getEffectiveDate</string>
<string>getExpirationDate</string>
+ <string>getCreationDateIndex</string>
+ <string>getFrequencyIndex</string>
</list>
</value>
</item>
@@ -99,7 +113,9 @@
getVersion\r\n
getRevision\r\n
getEffectiveDate\r\n
-getExpirationDate</string> </value>
+getExpirationDate\r\n
+getCreationDateIndex\r\n
+getFrequencyIndex</string> </value>
</item>
<item>
<key> <string>cache_time_</string> </key>
@@ -149,7 +165,9 @@
<dtml-sqlvar expr="getLanguage[loop_item]" type="string" optional>,\n
<dtml-sqlvar expr="getRevision[loop_item]" type="string" optional>,\n
<dtml-sqlvar expr="getEffectiveDate[loop_item]" type="datetime" optional>,\n
- <dtml-sqlvar expr="getExpirationDate[loop_item]" type="datetime" optional>\n
+ <dtml-sqlvar expr="getExpirationDate[loop_item]" type="datetime" optional>,\n
+ <dtml-sqlvar expr="getCreationDateIndex[loop_item]" type="int" optional>,\n
+ <dtml-sqlvar expr="getFrequencyIndex[loop_item]" type="int" optional>\n
)\n
<dtml-if sequence-end>\n
<dtml-else>\n
@@ -206,7 +224,9 @@
<dtml-sqlvar expr="getLanguage[loop_item]" type="string" optional>,\n
<dtml-sqlvar expr="getRevision[loop_item]" type="string" optional>,\n
<dtml-sqlvar expr="getEffectiveDate[loop_item]" type="datetime" optional>,\n
- <dtml-sqlvar expr="getExpirationDate[loop_item]" type="datetime" optional>\n
+ <dtml-sqlvar expr="getExpirationDate[loop_item]" type="datetime" optional>,\n
+ <dtml-sqlvar expr="getCreationDateIndex[loop_item]" type="int" optional>,\n
+ <dtml-sqlvar expr="getFrequencyIndex[loop_item]" type="int" optional>\n
)\n
<dtml-if sequence-end>\n
<dtml-else>\n
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_versioning.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_versioning.xml?rev=32277&r1=32276&r2=32277&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_versioning.xml [utf8] (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_versioning.xml [utf8] Fri Feb 5 09:19:06 2010
@@ -63,11 +63,14 @@
`revision` varchar(10) default \'\',\n
`effective_date` datetime default NULL,\n
`expiration_date` datetime default NULL,\n
+ `creation_date_index` INT, \n
+ `frequency_index` INT, \n
PRIMARY KEY (`uid`),\n
KEY `version` (`version`),\n
KEY `language` (`language`),\n
KEY `effective_date` (`effective_date`),\n
- KEY `expiration_date` (`effective_date`)\n
+ KEY `expiration_date` (`effective_date`),\n
+ KEY `frequency_index` (`creation_date_index`, `frequency_index`)\n
) TYPE=InnoDB;\n
</string> </value>
</item>
@@ -112,11 +115,14 @@
`revision` varchar(10) default \'\',\n
`effective_date` datetime default NULL,\n
`expiration_date` datetime default NULL,\n
+ `creation_date_index` INT, \n
+ `frequency_index` INT, \n
PRIMARY KEY (`uid`),\n
KEY `version` (`version`),\n
KEY `language` (`language`),\n
KEY `effective_date` (`effective_date`),\n
- KEY `expiration_date` (`effective_date`)\n
+ KEY `expiration_date` (`effective_date`),\n
+ KEY `frequency_index` (`creation_date_index`, `frequency_index`)\n
) TYPE=InnoDB;\n
</string> </value>
</item>
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=32277&r1=32276&r2=32277&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/change_log [utf8] (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/change_log [utf8] Fri Feb 5 09:19:06 2010
@@ -1,3 +1,6 @@
+2010-02-05 aurel
+* add more columns into versioning table in order to use frequency_index
+
2010-01-07 Kazuhiko
* increase the size of the language column in the versioning table from 2 to 5.
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=32277&r1=32276&r2=32277&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision [utf8] (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision [utf8] Fri Feb 5 09:19:06 2010
@@ -1,1 +1,1 @@
-170
+172
More information about the Erp5-report
mailing list