[Erp5-report] r19582 - in /erp5/trunk/bt5/erp5_worklist_sql: SkinTemplateItem/portal_skins/...
nobody at svn.erp5.org
nobody at svn.erp5.org
Fri Feb 29 13:28:12 CET 2008
Author: romain
Date: Fri Feb 29 13:28:10 2008
New Revision: 19582
URL: http://svn.erp5.org?rev=19582&view=rev
Log:
Update worklist_cache table to follow recent modifications of the catalog table.
Modified:
erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml
erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml
erp5/trunk/bt5/erp5_worklist_sql/bt/revision
Modified: erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml?rev=19582&r1=19581&r2=19582&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml (original)
+++ erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zCreateWorklistTable.xml Fri Feb 29 13:28:10 2008
@@ -68,7 +68,8 @@
<dtml-var sql_delimiter>\n
CREATE TABLE `worklist_cache` (\n
`count` INT UNSIGNED NOT NULL,\n
- `owner` VARCHAR(32) NOT NULL DEFAULT \'\',\n
+ `owner` VARCHAR(32) DEFAULT \'\',\n
+ `viewable_owner` VARCHAR(32) NOT NULL DEFAULT \'\',\n
`security_uid` INT UNSIGNED NOT NULL,\n
`portal_type` VARCHAR(255) NOT NULL,\n
`validation_state` VARCHAR(255) NULL,\n
@@ -92,9 +93,9 @@
`creation_date` datetime,\n
`modification_date` datetime,\n
KEY `portal_simulation_security` (`portal_type`, `simulation_state`, `security_uid`),\n
- KEY `portal_simulation_owner` (`portal_type`, `simulation_state`, `owner`),\n
+ KEY `portal_simulation_owner` (`portal_type`, `simulation_state`, `viewable_owner`),\n
KEY `portal_validation_security` (`portal_type`, `validation_state`, `security_uid`),\n
- KEY `portal_validation_owner` (`portal_type`, `validation_state`, `owner`)\n
+ KEY `portal_validation_owner` (`portal_type`, `validation_state`, `viewable_owner`)\n
) TYPE=InnoDB;
]]></string> </value>
@@ -139,7 +140,8 @@
<dtml-var sql_delimiter>\n
CREATE TABLE `worklist_cache` (\n
`count` INT UNSIGNED NOT NULL,\n
- `owner` VARCHAR(32) NOT NULL DEFAULT \'\',\n
+ `owner` VARCHAR(32) DEFAULT \'\',\n
+ `viewable_owner` VARCHAR(32) NOT NULL DEFAULT \'\',\n
`security_uid` INT UNSIGNED NOT NULL,\n
`portal_type` VARCHAR(255) NOT NULL,\n
`validation_state` VARCHAR(255) NULL,\n
@@ -163,9 +165,9 @@
`creation_date` datetime,\n
`modification_date` datetime,\n
KEY `portal_simulation_security` (`portal_type`, `simulation_state`, `security_uid`),\n
- KEY `portal_simulation_owner` (`portal_type`, `simulation_state`, `owner`),\n
+ KEY `portal_simulation_owner` (`portal_type`, `simulation_state`, `viewable_owner`),\n
KEY `portal_validation_security` (`portal_type`, `validation_state`, `security_uid`),\n
- KEY `portal_validation_owner` (`portal_type`, `validation_state`, `owner`)\n
+ KEY `portal_validation_owner` (`portal_type`, `validation_state`, `viewable_owner`)\n
) TYPE=InnoDB;
]]></string> </value>
Modified: erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml?rev=19582&r1=19581&r2=19582&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml (original)
+++ erp5/trunk/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql/Base_zInsertIntoWorklistTable.xml Fri Feb 29 13:28:10 2008
@@ -173,6 +173,12 @@
<dictionary/>
</value>
</item>
+ <item>
+ <key> <string>viewable_owner</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
</dictionary>
</value>
</item>
@@ -180,30 +186,31 @@
<key> <string>_keys</string> </key>
<value>
<list>
- <string>count</string>
- <string>security_uid</string>
- <string>portal_type</string>
- <string>simulation_state</string>
- <string>validation_state</string>
- <string>owner</string>
- <string>parent_uid</string>
- <string>title</string>
- <string>opportunity_state</string>
- <string>causality_state</string>
- <string>invoice_state</string>
- <string>payment_state</string>
- <string>event_state</string>
- <string>immobilisation_state</string>
- <string>reference</string>
- <string>grouping_reference</string>
- <string>source_reference</string>
- <string>destination_reference</string>
- <string>string_index</string>
- <string>int_index</string>
- <string>float_index</string>
- <string>has_cell_content</string>
- <string>creation_date</string>
- <string>modification_date</string>
+<string>count</string>
+<string>security_uid</string>
+<string>portal_type</string>
+<string>simulation_state</string>
+<string>validation_state</string>
+<string>owner</string>
+<string>viewable_owner</string>
+<string>parent_uid</string>
+<string>title</string>
+<string>opportunity_state</string>
+<string>causality_state</string>
+<string>invoice_state</string>
+<string>payment_state</string>
+<string>event_state</string>
+<string>immobilisation_state</string>
+<string>reference</string>
+<string>grouping_reference</string>
+<string>source_reference</string>
+<string>destination_reference</string>
+<string>string_index</string>
+<string>int_index</string>
+<string>float_index</string>
+<string>has_cell_content</string>
+<string>creation_date</string>
+<string>modification_date</string>
</list>
</value>
</item>
@@ -220,6 +227,7 @@
simulation_state\r\n
validation_state\r\n
owner\r\n
+viewable_owner\r\n
parent_uid\r\n
title\r\n
opportunity_state\r\n
@@ -253,7 +261,7 @@
INSERT INTO\n
worklist_cache\n
- (`count`, `owner`, `security_uid`, `portal_type`, `validation_state`, `simulation_state`, `parent_uid`, `title`,`opportunity_state`, `causality_state`, `invoice_state`, `payment_state`, `event_state`, `immobilisation_state`, `reference`, `grouping_reference`,\n
+ (`count`, `owner`, `viewable_owner`, `security_uid`, `portal_type`, `validation_state`, `simulation_state`, `parent_uid`, `title`,`opportunity_state`, `causality_state`, `invoice_state`, `payment_state`, `event_state`, `immobilisation_state`, `reference`, `grouping_reference`,\n
`source_reference`, `destination_reference`, `string_index`, `int_index`, `float_index`, `has_cell_content`, `creation_date`,\n
`modification_date`)\n
VALUES\n
@@ -261,6 +269,7 @@
(\n
<dtml-sqlvar expr="count[loop_item]" type="int">,\n
<dtml-sqlvar expr="owner[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="viewable_owner[loop_item]" type="string" optional>,\n
<dtml-sqlvar expr="security_uid[loop_item]" type="int">,\n
<dtml-sqlvar expr="portal_type[loop_item]" type="string">,\n
<dtml-sqlvar expr="validation_state[loop_item]" type="string" optional>,\n
@@ -327,7 +336,7 @@
INSERT INTO\n
worklist_cache\n
- (`count`, `owner`, `security_uid`, `portal_type`, `validation_state`, `simulation_state`, `parent_uid`, `title`,`opportunity_state`, `causality_state`, `invoice_state`, `payment_state`, `event_state`, `immobilisation_state`, `reference`, `grouping_reference`,\n
+ (`count`, `owner`, `viewable_owner`, `security_uid`, `portal_type`, `validation_state`, `simulation_state`, `parent_uid`, `title`,`opportunity_state`, `causality_state`, `invoice_state`, `payment_state`, `event_state`, `immobilisation_state`, `reference`, `grouping_reference`,\n
`source_reference`, `destination_reference`, `string_index`, `int_index`, `float_index`, `has_cell_content`, `creation_date`,\n
`modification_date`)\n
VALUES\n
@@ -335,6 +344,7 @@
(\n
<dtml-sqlvar expr="count[loop_item]" type="int">,\n
<dtml-sqlvar expr="owner[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="viewable_owner[loop_item]" type="string" optional>,\n
<dtml-sqlvar expr="security_uid[loop_item]" type="int">,\n
<dtml-sqlvar expr="portal_type[loop_item]" type="string">,\n
<dtml-sqlvar expr="validation_state[loop_item]" type="string" optional>,\n
Modified: erp5/trunk/bt5/erp5_worklist_sql/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_worklist_sql/bt/revision?rev=19582&r1=19581&r2=19582&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_worklist_sql/bt/revision (original)
+++ erp5/trunk/bt5/erp5_worklist_sql/bt/revision Fri Feb 29 13:28:10 2008
@@ -1,1 +1,1 @@
-11
+17
More information about the Erp5-report
mailing list