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.25 -r1.26
--- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	23 Jan 2004 11:02:27 -0000	1.25
+++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	26 Jan 2004 12:33:21 -0000	1.26
@@ -189,7 +189,7 @@
   constraint wf_actions_short_name_un
   unique (workflow_id, short_name),
   constraint wf_actions_pretty_name_un
-  unique (workflow_id, pretty_name)
+  unique (workflow_id, parent_action_id, pretty_name)
 );
 
 create sequence workflow_actions_seq;
@@ -286,7 +286,7 @@
   constraint wf_fsm_states_short_name_un
   unique (workflow_id, short_name),
   constraint wf_fsm_states_pretty_name_un
-  unique (workflow_id, pretty_name)
+  unique (workflow_id, parent_action_id, pretty_name)
 );
 
 create index wf_fsm_states_workflow_idx on workflow_fsm_states(workflow_id);
