Index: openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql	23 Jan 2004 11:02:27 -0000	1.8
+++ openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql	26 Jan 2004 12:33:21 -0000	1.9
@@ -258,3 +258,16 @@
            workflow_user_deputy_map wudm
     where  pamm.party_id = wcrpm.party_id
     and    wudm.on_behalf_of_user_id = pamm.member_id;
+
+-- pretty-name unique per parent, not per workflow
+alter table workflow_actions 
+  drop constraint wf_actions_pretty_name_un;
+alter table workflow_actions 
+  add constraint wf_actions_pretty_name_un
+  unique (workflow_id, parent_action_id, pretty_name);
+
+alter table workflow_fsm_states
+  drop constraint wf_fsm_states_pretty_name_un;
+alter table workflow_fsm_states
+  add constraint wf_fsm_states_pretty_name_un
+  unique (workflow_id, parent_action_id, pretty_name);