[Erp5-report] r13060 - /erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/Catalo...
nobody at svn.erp5.org
nobody at svn.erp5.org
Mon Feb 26 23:06:21 CET 2007
Author: jp
Date: Mon Feb 26 23:06:20 2007
New Revision: 13060
URL: http://svn.erp5.org?rev=13060&view=rev
Log:
Added owner column to support owner local role search and security in optimised way
Modified:
erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_object_list.xml
erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_catalog.xml
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_object_list.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_object_list.xml?rev=13060&r1=13059&r2=13060&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_object_list.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_object_list.xml Mon Feb 26 23:06:20 2007
@@ -159,6 +159,12 @@
</value>
</item>
<item>
+ <key> <string>getViewPermissionOwner</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
<key> <string>hasCellContent</string> </key>
<value>
<dictionary/>
@@ -219,36 +225,37 @@
<key> <string>_keys</string> </key>
<value>
<list>
- <string>uid</string>
- <string>security_uid</string>
- <string>getPath</string>
- <string>getRelativeUrl</string>
- <string>getParentUid</string>
- <string>id</string>
- <string>getDescription</string>
- <string>getTitle</string>
- <string>meta_type</string>
- <string>getPortalType</string>
- <string>opportunity_state</string>
- <string>getCorporateRegistrationCode</string>
- <string>getEan13Code</string>
- <string>getSimulationState</string>
- <string>causality_state</string>
- <string>invoice_state</string>
- <string>validation_state</string>
- <string>payment_state</string>
- <string>event_state</string>
- <string>getImmobilisationState</string>
- <string>getReference</string>
- <string>getGroupingReference</string>
- <string>getSourceReference</string>
- <string>getDestinationReference</string>
- <string>getStringIndex</string>
- <string>getIntIndex</string>
- <string>getFloatIndex</string>
- <string>hasCellContent</string>
- <string>getCreationDate</string>
- <string>getModificationDate</string>
+<string>uid</string>
+<string>security_uid</string>
+<string>getViewPermissionOwner</string>
+<string>getPath</string>
+<string>getRelativeUrl</string>
+<string>getParentUid</string>
+<string>id</string>
+<string>getDescription</string>
+<string>getTitle</string>
+<string>meta_type</string>
+<string>getPortalType</string>
+<string>opportunity_state</string>
+<string>getCorporateRegistrationCode</string>
+<string>getEan13Code</string>
+<string>getSimulationState</string>
+<string>causality_state</string>
+<string>invoice_state</string>
+<string>validation_state</string>
+<string>payment_state</string>
+<string>event_state</string>
+<string>getImmobilisationState</string>
+<string>getReference</string>
+<string>getGroupingReference</string>
+<string>getSourceReference</string>
+<string>getDestinationReference</string>
+<string>getStringIndex</string>
+<string>getIntIndex</string>
+<string>getFloatIndex</string>
+<string>hasCellContent</string>
+<string>getCreationDate</string>
+<string>getModificationDate</string>
</list>
</value>
</item>
@@ -267,6 +274,7 @@
<key> <string>arguments_src</string> </key>
<value> <string>uid\r\n
security_uid\r\n
+getViewPermissionOwner\r\n
getPath\r\n
getRelativeUrl\r\n
getParentUid\r\n
@@ -292,8 +300,8 @@
getStringIndex\r\n
getIntIndex\r\n
getFloatIndex\r\n
-hasCellContent\n
-getCreationDate\n
+hasCellContent\r\n
+getCreationDate\r\n
getModificationDate</string> </value>
</item>
<item>
@@ -341,6 +349,7 @@
(\n
<dtml-sqlvar expr="uid[loop_item]" type="int">, \n
<dtml-sqlvar expr="security_uid[loop_item]" type="int">,\n
+ <dtml-sqlvar expr="getViewPermissionOwner[loop_item]" type="string" optional>,\n
<dtml-sqlvar expr="getPath[loop_item]" type="string">,\n
<dtml-sqlvar expr="getRelativeUrl[loop_item]" type="string">,\n
<dtml-sqlvar expr="getParentUid[loop_item]" type="int">,\n
@@ -417,6 +426,7 @@
(\n
<dtml-sqlvar expr="uid[loop_item]" type="int">, \n
<dtml-sqlvar expr="security_uid[loop_item]" type="int">,\n
+ <dtml-sqlvar expr="getViewPermissionOwner[loop_item]" type="string" optional>,\n
<dtml-sqlvar expr="getPath[loop_item]" type="string">,\n
<dtml-sqlvar expr="getRelativeUrl[loop_item]" type="string">,\n
<dtml-sqlvar expr="getParentUid[loop_item]" type="int">,\n
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_catalog.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_catalog.xml?rev=13060&r1=13059&r2=13060&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_catalog.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_catalog.xml Mon Feb 26 23:06:20 2007
@@ -98,6 +98,7 @@
CREATE TABLE `catalog` (\n
`uid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n
`security_uid` INT UNSIGNED,\n
+ `owner` varchar(32) default \'\',\n
`path` varchar(255) NOT NULL default \'\',\n
`relative_url` varchar(255) NOT NULL default \'\',\n
`parent_uid` BIGINT UNSIGNED default \'0\',\n
@@ -128,6 +129,7 @@
`modification_date` datetime,\n
PRIMARY KEY (`uid`),\n
KEY `security_uid` (`security_uid`),\n
+ KEY `owner` (`owner`),\n
KEY `Parent` (`parent_uid`),\n
KEY `Path` (`path`),\n
KEY `Title` (`title`),\n
@@ -183,6 +185,7 @@
CREATE TABLE `catalog` (\n
`uid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n
`security_uid` INT UNSIGNED,\n
+ `owner` varchar(32) default \'\',\n
`path` varchar(255) NOT NULL default \'\',\n
`relative_url` varchar(255) NOT NULL default \'\',\n
`parent_uid` BIGINT UNSIGNED default \'0\',\n
@@ -213,6 +216,7 @@
`modification_date` datetime,\n
PRIMARY KEY (`uid`),\n
KEY `security_uid` (`security_uid`),\n
+ KEY `owner` (`owner`),\n
KEY `Parent` (`parent_uid`),\n
KEY `Path` (`path`),\n
KEY `Title` (`title`),\n
More information about the Erp5-report
mailing list