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.2 -r1.19.2.3
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	2 Jul 2004 23:13:48 -0000	1.19.2.2
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql	16 Jul 2004 20:59:39 -0000	1.19.2.3
@@ -191,10 +191,17 @@
         task_number                     integer,
         status                          integer
                                         constraint pm_tasks_task_status_fk
-                                        references pm_task_status
+                                        references pm_task_status,
+        deleted_p                       char(1) default 'f'
+                                        constraint pm_tasks_deleted_p_ck
+                                        check (deleted_p in ('t','f'))
 );
 
+CREATE OR REPLACE view 
+pm_tasks_active as 
+  SELECT task_id, task_number, status FROM pm_tasks where deleted_p = 'f';
 
+
 create table pm_tasks_revisions (
         task_revision_id                integer
                                         constraint pm_task_revs_id_fk
