Index: openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/sql/postgresql/Attic/project-manager-table-create.sql,v
diff -u -r1.15.2.3 -r1.15.2.4
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	13 Dec 2003 01:19:54 -0000	1.15.2.3
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	10 Jan 2004 01:04:02 -0000	1.15.2.4
@@ -343,10 +343,10 @@
         description                     varchar(1000)
 );
 
-insert into pm_task_dependency_types (short_name, description) values ('start_before_start','Start before this starts');
-insert into pm_task_dependency_types (short_name, description) values ('start_before_finish','Start before this finishes');
-insert into pm_task_dependency_types (short_name, description) values ('finish_before_start','Finish before this starts');
-insert into pm_task_dependency_types (short_name, description) values ('finish_before_finish','Finish before this finishes');
+insert into pm_task_dependency_types (short_name, description) values ('start_before_start','Starts before this starts');
+insert into pm_task_dependency_types (short_name, description) values ('start_before_finish','Starts before this finishes');
+insert into pm_task_dependency_types (short_name, description) values ('finish_before_start','Finishes before this starts');
+insert into pm_task_dependency_types (short_name, description) values ('finish_before_finish','Finishes before this finishes');
 
 
 create sequence pm_task_dependency_seq;
@@ -356,15 +356,21 @@
                                         constraint pm_task_const_id_pk
                                         primary key,
         task_id                         integer
+                                        constraint pm_task_const_task_id_nn
+                                        not null
                                         constraint pm_task_const_task_id_fk
                                         references pm_tasks
                                         on delete cascade,
         parent_task_id                  integer
+                                        constraint pm_tasks_const_parent_id_nn
+                                        not null
                                         constraint pm_tasks_const_parent_id_fk
                                         references pm_tasks
                                         on delete cascade,
         dependency_type                 varchar
-                                        constraint pm_tasks_const_type
+                                        constraint pm_tasks_const_type_nn
+                                        not null
+                                        constraint pm_tasks_const_type_fk
                                         references pm_task_dependency_types,
         constraint pm_task_dependency_uq
         unique (task_id, parent_task_id)
