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.16 -r1.17
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	11 Dec 2003 21:39:44 -0000	1.16
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	26 Jan 2004 15:39:40 -0000	1.17
@@ -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)
@@ -532,3 +538,5 @@
   Maps who is assigned to process tasks. These will be the default people
   assigned to the new tasks
 ';
+
+\i project-manager-custom-create.sql