Index: openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql	18 Nov 2003 17:57:56 -0000	1.8
+++ openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql	1 Dec 2003 09:53:19 -0000	1.9
@@ -104,7 +104,11 @@
                           constraint wf_roles_pretty_name_nn
                           not null,
   sort_order              integer constraint wf_roles_so_nn
-                          not null
+                          not null,
+  constraint wf_roles_short_name_un
+  unique (workflow_id, short_name),
+  constraint wf_roles_pretty_name_un
+  unique (workflow_id, pretty_name)
 );
 
 create sequence workflow_roles_seq;
@@ -162,7 +166,11 @@
  -- When the action to automatically fire.
  -- A value of 0 means immediately, null means never.
  -- Other values mean x amount of time after having become enabled
- timeout_seconds          integer
+ timeout_seconds          integer,
+  constraint wf_actions_short_name_un
+  unique (workflow_id, short_name),
+  constraint wf_actions_pretty_name_un
+  unique (workflow_id, pretty_name)
 );
 
 create sequence workflow_actions_seq;
@@ -257,7 +265,12 @@
   pretty_name             varchar(200)
                           constraint wf_fsm_states_pretty_name_nn
                           not null,
-  hide_fields             varchar(4000)
+  hide_fields             varchar(4000),
+  constraint wf_fsm_states_short_name_un
+  unique (workflow_id, short_name),
+  constraint wf_fsm_states_pretty_name_un
+  unique (workflow_id, pretty_name)
+
 );
 
 create sequence workflow_fsm_states_seq;