Index: openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql,v diff -u -N -r1.12 -r1.13 --- openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql 29 Jan 2004 12:47:25 -0000 1.12 +++ openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql 30 Jan 2004 09:46:05 -0000 1.13 @@ -1,5 +1,5 @@ -- --- Adds timed actions +-- Adding hierarchy, parallelism and timed actions -- -- @cvs-id $Id$ -- @@ -202,9 +202,9 @@ -- Answers the question: Which parties are currently assigned to which actions? -- Does not take deputies into account. --- Pimarily needed for building the workflow_case_assigned_user_actions view. +-- Pimarily needed for building the wf_case_assigned_user_actions view. -- TODO: See if we can find a way to improve this without the union? -create or replace view workflow_case_assigned_party_actions as +create or replace view wf_case_assigned_party_actions as select wcaa.enabled_action_id, wcaa.action_id, wcaa.case_id, @@ -231,13 +231,13 @@ -- Answers the question: which actions is this user assigned to? -- Does take deputies into account -create or replace view workflow_case_assigned_user_actions as +create or replace view wf_case_assigned_user_actions as select wcapa.enabled_action_id, wcapa.action_id, wcapa.case_id, wudm.user_id, wudm.on_behalf_of_user_id - from workflow_case_assigned_party_actions wcapa, + from wf_case_assigned_party_actions wcapa, party_approved_member_map pamm, workflow_user_deputy_map wudm where pamm.party_id = wcapa.party_id