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.19.2.6 -r1.19.2.7
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	26 Oct 2004 01:22:27 -0000	1.19.2.6
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	14 Nov 2004 14:50:15 -0000	1.19.2.7
@@ -177,7 +177,7 @@
         creation_date                   timestamptz,
         deleted_p                       char(1) default 'f'
                                         constraint pm_process_deleted_p_ck
-                                        check (deleted_p in ('t','f')),
+                                        check (deleted_p in ('t','f'))
 );
 
 comment on table pm_process is '
@@ -231,7 +231,7 @@
                                         constraint pm_process_task_mime_type_fk
                                         references cr_mime_types(mime_type)
                                         on update no action on delete no action
-                                        default 'text/plain'
+                                        default 'text/plain',
         -- dates are optional, because it may be computed in reference
         -- to all other items, or simply not have a deadline
         -- percent complete is always 0
@@ -247,6 +247,27 @@
   A template for the tasks that will be created by the process
 ';
 
+-- DEPENDENCIES
+
+-- dependency 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_dependency_types (
+        short_name                      varchar(100)
+                                        constraint pm_task_const_sn_pk
+                                        primary key,
+        description                     varchar(1000)
+);
+
+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_process_task_dependency_seq;
 
 create table pm_process_task_dependency (
@@ -264,8 +285,8 @@
         dependency_type                 varchar
                                         constraint pm_process_task_dep_type
                                         references pm_task_dependency_types,
-        constraint pm_proc_task_depend_uq
-        unique (process_task_id, parent_task_id)
+				        constraint pm_proc_task_depend_uq
+				        unique (process_task_id, parent_task_id)
 );
 
 comment on table pm_process_task_dependency is '
@@ -341,7 +362,7 @@
         process_instance                integer
                                         constraint pm_tasks_process_instance_fk
                                         references 
-                                        pm_process_instance;
+                                        pm_process_instance
 );
 
 CREATE OR REPLACE view 
@@ -525,28 +546,8 @@
 );
 
 
--- DEPENDENCIES
 
--- dependency 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_dependency_types (
-        short_name                      varchar(100)
-                                        constraint pm_task_const_sn_pk
-                                        primary key,
-        description                     varchar(1000)
-);
-
-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;
 
 create table pm_task_dependency (
