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.3 -r1.4
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	30 Jul 2003 20:42:05 -0000	1.3
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	1 Aug 2003 20:51:04 -0000	1.4
@@ -129,3 +129,36 @@
     null, -- default value
     'numeric' -- column_spec
 );
+
+
+
+-- constraint types
+-- such as:
+-- cannot start until Task X finishes
+-- cannot start until Task X begins
+-- cannot finish until Task X finishes
+-- cannot finish until Task X begins
+
+create table pm_task_constraint_types (
+        task_constraint_type_id         integer
+                                        constraint pm_task_const_type_id_pk
+                                        primary key,
+        short_name                      varchar(100),
+        description                     varchar(1000)
+);
+
+create table pm_task_constraints (
+        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,
+        parent_task_id                  integer
+                                        constraint pm_tasks_const_parent_id_fk
+                                        references pm_tasks
+                                        on delete cascade,
+        task_type                       integer
+                                        constraint pm_tasks_const_type
+                                        references pm_task_constraint_types
+);