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 -N -r1.4 -r1.5
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	1 Aug 2003 20:51:04 -0000	1.4
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	7 Aug 2003 23:08:45 -0000	1.5
@@ -140,25 +140,33 @@
 -- cannot finish until Task X begins
 
 create table pm_task_constraint_types (
-        task_constraint_type_id         integer
-                                        constraint pm_task_const_type_id_pk
+        short_name                      varchar(100)
+                                        constraint pm_task_const_sn_pk
                                         primary key,
-        short_name                      varchar(100),
         description                     varchar(1000)
 );
 
+insert into pm_task_constraint_types (short_name, description) values ('start_before_start','Must start before this task can start');
+insert into pm_task_constraint_types (short_name, description) values ('start_before_finish','Must start before this task can finish');
+insert into pm_task_constraint_types (short_name, description) values ('finish_before_start','Must finish before this task can start');
+insert into pm_task_constraint_types (short_name, description) values ('finish_before_finish','Must finish before this task can finish');
+
+
+create sequence pm_task_constraint_seq;
+
 create table pm_task_constraints (
+        constraint_id                   integer
+                                        constraint pm_task_const_id_pk
+                                        primary key,
         task_id                         integer
                                         constraint pm_tasks_const_task_id_fk
                                         references pm_tasks
-                                        on delete cascade
-                                        constraint pm_task_const_task_id_pk
-                                        primary key,
+                                        on delete cascade,
         parent_task_id                  integer
                                         constraint pm_tasks_const_parent_id_fk
                                         references pm_tasks
                                         on delete cascade,
-        task_type                       integer
+        const_type                       varchar
                                         constraint pm_tasks_const_type
                                         references pm_task_constraint_types
 );