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 -r1.2 -r1.3
--- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	14 Jan 2003 15:09:07 -0000	1.2
+++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	16 Jan 2003 15:07:36 -0000	1.3
@@ -307,12 +307,15 @@
 
 create table workflow_fsm_actions (
   action_id               integer
+                          constraint workflow_fsm_actions_aid_fk
+                          references workflow_actions(action_id)
+                          on delete cascade
                           constraint workflow_fsm_actions_pk
                           primary key,
   new_state               integer
                           constraint workflow_fsm_actions_new_state_fk
                           references workflow_fsm_states(state_id)
-                          on delete set null
+                          on delete cascade
   -- can be null
 );
 
