Index: openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/sql/postgresql/Attic/project-manager-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-drop.sql	30 Jul 2003 20:42:05 -0000	1.3
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-drop.sql	1 Aug 2003 20:51:04 -0000	1.4
@@ -6,6 +6,42 @@
 -- @cvs-id $Id$
 --
 
+--------
+-- TASKS
+--------
+
+-- task constraint types
+drop table pm_task_constraint_types cascade;
+drop table pm_task_constraints cascade;
+
+
+create function inline_0 ()
+returns integer as '
+declare
+    v_item RECORD;
+        
+begin
+        for v_item in select 
+                item_id
+                from 
+                cr_items
+                where 
+                content_type = ''pm_task''
+        LOOP
+                
+                PERFORM pm_task__delete_task_item(v_item);
+        end loop;
+
+    return 0;
+end;
+' language 'plpgsql';
+
+-- select inline_0();
+drop function inline_0();
+
+select drop_package('pm_task');
+
+
 --drop permissions
 delete from acs_permissions where object_id in (select project_id from pm_projects);
 
@@ -50,7 +86,7 @@
 drop function inline_0();
 
 -----------
--- PACKAGES
+-- PROJECTS
 -----------
 
 -- delete content_type 'pm_project'
@@ -83,42 +119,13 @@
 --drop table
 drop table pm_projects cascade;
 
-select content_type__drop_type('pm_project', 't', 'f');
 
---------
--- TASKS
---------
-
-
-create function inline_0 ()
-returns integer as '
-declare
-    v_item RECORD;
-        
-begin
-        for v_item in select 
-                item_id
-                from 
-                cr_items
-                where 
-                content_type = ''pm_task''
-        LOOP
-                
-                PERFORM pm_task__delete_task_item(v_item);
-        end loop;
-
-    return 0;
-end;
-' language 'plpgsql';
-
--- select inline_0();
-drop function inline_0();
-
-select drop_package('pm_task');
-
 select content_type__drop_type('pm_task', 't', 'f');
 
 drop table pm_tasks cascade;
 drop table pm_tasks_revisions cascade;
 
+select content_type__drop_type('pm_project', 't', 'f');
+
 -- note that the Project Repository folder is not deleted
+
