Index: openacs-4/packages/workflow/tcl/action-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/action-procs-postgresql.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/workflow/tcl/action-procs-postgresql.xql 11 Mar 2004 16:49:37 -0000 1.11
+++ openacs-4/packages/workflow/tcl/action-procs-postgresql.xql 23 Nov 2017 14:43:09 -0000 1.12
@@ -34,32 +34,12 @@
a.description,
a.description_mime_type,
extract (days from a.timeout) * 86400 + extract (hours from a.timeout) * 3600 +
- extract (minutes from a.timeout) * 60 + extract (seconds from a.timeout) as timeout_seconds
+ extract (minutes from a.timeout) * 60 + extract (seconds from a.timeout) as timeout_seconds
from workflow_actions a left outer join
workflow_fsm_actions fa on (a.action_id = fa.action_id)
where a.workflow_id = :workflow_id
order by a.sort_order
-
-
-
- select coalesce(max(sort_order),0) + 1
- from workflow_action_callbacks
- where action_id = :action_id
-
-
-
-
- insert into workflow_action_allowed_roles
- select :action_id,
- (select role_id
- from workflow_roles
- where workflow_id = :workflow_id
- and short_name = :allowed_role) as role_id
-
-
-
-