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 );