[Erp5-report] r18659 - in /erp5/trunk/bt5/erp5_worklist_sql: SkinTemplateItem/portal_skins/...
nobody at svn.erp5.org
nobody at svn.erp5.org
Fri Jan 11 11:34:00 CET 2008
Author: aurel
Date: Fri Jan 11 11:33:59 2008
New Revision: 18659
URL: http://svn.erp5.org?rev=18659&view=rev
Log:
2008-01-11 aurel
* include most of the column of the catalog in sql table
Added:
erp5/trunk/bt5/erp5_worklist_sql/bt/template_catalog_datetime_key_list
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/change_log
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=18659&r1=18658&r2=18659&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 Jan 11 11:33:59 2008
@@ -73,6 +73,24 @@
`portal_type` VARCHAR(255) NOT NULL,\n
`validation_state` VARCHAR(255) NULL,\n
`simulation_state` VARCHAR(255) NULL,\n
+ `parent_uid` BIGINT UNSIGNED default \'0\',\n
+ `title` varchar(255) default \'\',\n
+ `opportunity_state` varchar(255) default \'\',\n
+ `causality_state` varchar(255) default \'\',\n
+ `invoice_state` varchar(255) default \'\',\n
+ `payment_state` varchar(255) default \'\',\n
+ `event_state` varchar(255) default \'\',\n
+ `immobilisation_state` varchar(255) default \'\',\n
+ `reference` varchar(255) binary default \'\',\n
+ `grouping_reference` varchar(255) default \'\',\n
+ `source_reference` varchar(255) default \'\',\n
+ `destination_reference` varchar(255) default \'\',\n
+ `string_index` varchar(255),\n
+ `int_index` INT,\n
+ `float_index` real,\n
+ `has_cell_content` bool,\n
+ `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_validation_security` (`portal_type`, `validation_state`, `security_uid`),\n
@@ -126,6 +144,24 @@
`portal_type` VARCHAR(255) NOT NULL,\n
`validation_state` VARCHAR(255) NULL,\n
`simulation_state` VARCHAR(255) NULL,\n
+ `parent_uid` BIGINT UNSIGNED default \'0\',\n
+ `title` varchar(255) default \'\',\n
+ `opportunity_state` varchar(255) default \'\',\n
+ `causality_state` varchar(255) default \'\',\n
+ `invoice_state` varchar(255) default \'\',\n
+ `payment_state` varchar(255) default \'\',\n
+ `event_state` varchar(255) default \'\',\n
+ `immobilisation_state` varchar(255) default \'\',\n
+ `reference` varchar(255) binary default \'\',\n
+ `grouping_reference` varchar(255) default \'\',\n
+ `source_reference` varchar(255) default \'\',\n
+ `destination_reference` varchar(255) default \'\',\n
+ `string_index` varchar(255),\n
+ `int_index` INT,\n
+ `float_index` real,\n
+ `has_cell_content` bool,\n
+ `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_validation_security` (`portal_type`, `validation_state`, `security_uid`),\n
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=18659&r1=18658&r2=18659&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 Jan 11 11:33:59 2008
@@ -30,24 +30,114 @@
<value>
<dictionary>
<item>
+ <key> <string>causality_state</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
<key> <string>count</string> </key>
<value>
<dictionary/>
</value>
</item>
<item>
+ <key> <string>creation_date</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>destination_reference</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>event_state</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>float_index</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>grouping_reference</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>has_cell_content</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>immobilisation_state</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>int_index</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>invoice_state</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>modification_date</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>opportunity_state</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
<key> <string>owner</string> </key>
<value>
<dictionary/>
</value>
</item>
<item>
+ <key> <string>parent_uid</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>payment_state</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
<key> <string>portal_type</string> </key>
<value>
<dictionary/>
</value>
</item>
<item>
+ <key> <string>reference</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
<key> <string>security_uid</string> </key>
<value>
<dictionary/>
@@ -55,6 +145,24 @@
</item>
<item>
<key> <string>simulation_state</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>source_reference</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>string_index</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>title</string> </key>
<value>
<dictionary/>
</value>
@@ -78,6 +186,24 @@
<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>
</list>
</value>
</item>
@@ -93,7 +219,25 @@
portal_type\r\n
simulation_state\r\n
validation_state\r\n
-owner</string> </value>
+owner\r\n
+parent_uid\r\n
+title\r\n
+opportunity_state\r\n
+causality_state\r\n
+invoice_state\r\n
+payment_state\r\n
+event_state\r\n
+immobilisation_state\r\n
+reference\r\n
+grouping_reference\r\n
+source_reference\r\n
+destination_reference\r\n
+string_index\r\n
+int_index\r\n
+float_index\r\n
+has_cell_content\r\n
+creation_date\r\n
+modification_date</string> </value>
</item>
<item>
<key> <string>connection_id</string> </key>
@@ -109,7 +253,9 @@
INSERT INTO\n
worklist_cache\n
- (`count`, `owner`, `security_uid`, `portal_type`, `validation_state`, `simulation_state`)\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
+ `source_reference`, `destination_reference`, `string_index`, `int_index`, `float_index`, `has_cell_content`, `creation_date`,\n
+ `modification_date`)\n
VALUES\n
<dtml-in prefix="loop" expr="_.range(_.len(count))">\n
(\n
@@ -118,7 +264,25 @@
<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
- <dtml-sqlvar expr="simulation_state[loop_item]" type="string" optional>\n
+ <dtml-sqlvar expr="simulation_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="parent_uid[loop_item]" type="int" optional>,\n
+ <dtml-sqlvar expr="title[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="opportunity_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="causality_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="invoice_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="payment_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="event_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="immobilisation_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="reference[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="grouping_reference[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="source_reference[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="destination_reference[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="string_index[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="int_index[loop_item]" type="int" optional>,\n
+ <dtml-sqlvar expr="float_index[loop_item]" type="float" optional>,\n
+ <dtml-sqlvar expr="has_cell_content[loop_item]" type="int" optional>,\n
+ <dtml-sqlvar expr="creation_date[loop_item]" type="datetime" optional>,\n
+ <dtml-sqlvar expr="modification_date[loop_item]" type="datetime" optional>\n
)\n
<dtml-if sequence-end><dtml-else>,</dtml-if>\n
</dtml-in>
@@ -163,7 +327,9 @@
INSERT INTO\n
worklist_cache\n
- (`count`, `owner`, `security_uid`, `portal_type`, `validation_state`, `simulation_state`)\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
+ `source_reference`, `destination_reference`, `string_index`, `int_index`, `float_index`, `has_cell_content`, `creation_date`,\n
+ `modification_date`)\n
VALUES\n
<dtml-in prefix="loop" expr="_.range(_.len(count))">\n
(\n
@@ -172,7 +338,25 @@
<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
- <dtml-sqlvar expr="simulation_state[loop_item]" type="string" optional>\n
+ <dtml-sqlvar expr="simulation_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="parent_uid[loop_item]" type="int" optional>,\n
+ <dtml-sqlvar expr="title[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="opportunity_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="causality_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="invoice_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="payment_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="event_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="immobilisation_state[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="reference[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="grouping_reference[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="source_reference[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="destination_reference[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="string_index[loop_item]" type="string" optional>,\n
+ <dtml-sqlvar expr="int_index[loop_item]" type="int" optional>,\n
+ <dtml-sqlvar expr="float_index[loop_item]" type="float" optional>,\n
+ <dtml-sqlvar expr="has_cell_content[loop_item]" type="int" optional>,\n
+ <dtml-sqlvar expr="creation_date[loop_item]" type="datetime" optional>,\n
+ <dtml-sqlvar expr="modification_date[loop_item]" type="datetime" optional>\n
)\n
<dtml-if sequence-end><dtml-else>,</dtml-if>\n
</dtml-in>
Modified: erp5/trunk/bt5/erp5_worklist_sql/bt/change_log
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_worklist_sql/bt/change_log?rev=18659&r1=18658&r2=18659&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_worklist_sql/bt/change_log (original)
+++ erp5/trunk/bt5/erp5_worklist_sql/bt/change_log Fri Jan 11 11:33:59 2008
@@ -1,0 +1,2 @@
+2008-01-11 aurel
+* include most of the column of the catalog in sql table
Modified: erp5/trunk/bt5/erp5_worklist_sql/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_worklist_sql/bt/revision?rev=18659&r1=18658&r2=18659&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_worklist_sql/bt/revision (original)
+++ erp5/trunk/bt5/erp5_worklist_sql/bt/revision Fri Jan 11 11:33:59 2008
@@ -1,1 +1,1 @@
-6
+10
Added: erp5/trunk/bt5/erp5_worklist_sql/bt/template_catalog_datetime_key_list
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_worklist_sql/bt/template_catalog_datetime_key_list?rev=18659&view=auto
==============================================================================
(empty)
More information about the Erp5-report
mailing list