Index: openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2-2.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2-2.0d1.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2-2.0d1.sql	18 Nov 2003 17:57:56 -0000	1.1
+++ openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2-2.0d1.sql	1 Dec 2003 09:53:19 -0000	1.2
@@ -46,3 +46,14 @@
 create index workflow_case_log_action_id on workflow_case_log (action_id);
 create index workflow_case_log_case_id on workflow_case_log (case_id);
 
+
+-- Missing unique constraints on names
+-- TODO: Test these
+alter table workflow_roles add constraint wf_roles_short_name_un unique (workflow_id, short_name);
+alter table workflow_roles add constraint wf_roles_pretty_name_un unique (workflow_id, pretty_name);
+
+alter table workflow_actions add constraint wf_actions_short_name_un unique (workflow_id, short_name);
+alter table workflow_actions add constraint wf_actions_pretty_name_un unique (workflow_id, pretty_name);
+
+alter table workflow_fsm_states add constraint wf_fsm_states_short_name_un unique (workflow_id, short_name);
+alter table workflow_fsm_states add constraint wf_fsm_states_pretty_name_un unique (workflow_id, pretty_name);