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 -N -r1.18 -r1.19
--- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	10 Dec 2003 16:05:09 -0000	1.18
+++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	16 Dec 2003 18:18:49 -0000	1.19
@@ -98,6 +98,8 @@
                           constraint wf_roles_pk
                           primary key,
   workflow_id             integer
+                          constraint wf_roles_workflow_id_nn
+                          not null
                           constraint wf_roles_workflow_id_fk
                           references workflows(workflow_id)
                           on delete cascade,
@@ -245,6 +247,8 @@
 -- For the initial action, which fires when a new case is started
 create table workflow_initial_action (
   workflow_id             integer
+                          constraint wf_roles_workflow_id_nn
+                          not null
                           constraint wf_initial_acn_pk
                           primary key
                           constraint wf_initial_acn_wf_fk
