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 -r1.6 -r1.7
--- openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql	9 Jan 2004 15:47:53 -0000	1.6
+++ openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql	12 Jan 2004 10:57:00 -0000	1.7
@@ -209,3 +209,7 @@
     -- return id of newly created item
     return v_item_id;
 end;' language 'plpgsql';
+
+-- Adding unique constraint on workflow fsm enabled in actions
+-- This could cause upgrades to fail, if there are in fact duplicates, so let's pray that there aren't
+alter table workflow_fsm_action_en_in_st add constraint workflow_fsm_action_en_in_st_pk primary key (action_id, state_id);