Index: openacs-4/packages/workflow/workflow.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/workflow.info,v diff -u -r1.10 -r1.10.2.1 --- openacs-4/packages/workflow/workflow.info 10 Nov 2003 16:36:32 -0000 1.10 +++ openacs-4/packages/workflow/workflow.info 18 Nov 2003 17:54:56 -0000 1.10.2.1 @@ -8,7 +8,7 @@ t workflow - + Peter Marklund Lars Pind A Tcl API for creating workflows that support the Bug Tracker, CMS publication, simple approval, and much more. @@ -18,7 +18,7 @@ <p> For more information, see: <a href="http://www.collaboraid.biz/developer/workflow-spec">the workflow specification</a>. - + Index: openacs-4/packages/workflow/sql/oracle/workflow-procedural-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/workflow-procedural-create.sql,v diff -u -r1.5 -r1.5.2.1 --- openacs-4/packages/workflow/sql/oracle/workflow-procedural-create.sql 3 Oct 2003 13:26:27 -0000 1.5 +++ openacs-4/packages/workflow/sql/oracle/workflow-procedural-create.sql 18 Nov 2003 17:54:57 -0000 1.5.2.1 @@ -58,18 +58,10 @@ ) return integer is begin - for rec in (select cr.item_id - from cr_items cr, workflow_case_log wcl - where cr.item_id = wcl.entry_id - and wcl.case_id = delete_case_id) - loop - delete from workflow_case_log where entry_id = rec.item_id; - content_item.del(rec.item_id); - end loop; - -- All workflow data cascades from the case id - delete from workflow_cases - where object_id = delete_case_id; + delete + from workflow_cases + where object_id = workflow_case_pkg.del.delete_case_id; return 0; end del; Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2d1-1.2b2.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/workflow/sql/postgresql/workflow-procedural-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/workflow-procedural-create.sql,v diff -u -r1.8 -r1.8.2.1 --- openacs-4/packages/workflow/sql/postgresql/workflow-procedural-create.sql 3 Oct 2003 13:26:27 -0000 1.8 +++ openacs-4/packages/workflow/sql/postgresql/workflow-procedural-create.sql 18 Nov 2003 17:54:57 -0000 1.8.2.1 @@ -36,16 +36,6 @@ delete_case_id alias for $1; rec record; begin - - for rec in select cr.item_id - from cr_items cr, workflow_case_log wcl - where cr.item_id = wcl.entry_id - and wcl.case_id = delete_case_id loop - - delete from workflow_case_log where entry_id = rec.item_id; - perform content_item__delete(rec.item_id); - end loop; - -- All workflow data cascades from the case id delete from workflow_cases where case_id = delete_case_id; Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2d1-1.2b2.sql'. Fisheye: No comparison available. Pass `N' to diff?