Index: openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql,v diff -u -N -r1.26 -r1.27 --- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql 26 Jan 2004 12:33:21 -0000 1.26 +++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql 30 Jan 2004 09:46:05 -0000 1.27 @@ -612,9 +612,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, @@ -641,13 +641,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