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.10 -r1.10.2.1
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-drop.sql	15 Sep 2003 23:09:56 -0000	1.10
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-drop.sql	4 Dec 2003 21:00:13 -0000	1.10.2.1
@@ -1,151 +1,159 @@
--- packages/project-manager/sql/project-manager-drop.sql
--- drop script
---
--- @author jade@bread.com
--- @creation-date 2003-05-15
--- @cvs-id $Id$
---
-
---------
--- TASKS
---------
-
--- task dependency types
-drop table pm_task_dependency_types cascade;
-drop table pm_task_dependency cascade;
-drop sequence pm_task_dependency_seq;
-drop sequence pm_tasks_number_seq;
-
--------------
--- WORKGROUPS
--------------
-
-drop sequence pm_workgroup_seq;
-drop table pm_workgroup_parties;
-drop table pm_workgroup;
-
-------------
--- PROCESSES
-------------
-
-drop sequence pm_process_seq;
-drop sequence pm_process_task_seq;
-drop sequence pm_process_task_dependency_seq;
-
-drop table pm_process_task_assignment;
-drop table pm_process_task_dependency;
-drop table pm_process_task;
-drop table pm_process;
-
----------
--- OTHERS
----------
-drop table pm_default_roles;
-drop table pm_project_assignment;
-drop table pm_task_assignment;
-drop table pm_roles;
-drop sequence pm_role_seq;
-
-
-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.item_id);
-        end loop;
-
-    return 0;
-end;
-' language 'plpgsql';
-
-select inline_0();
-drop function inline_0();
-
-select drop_package('pm_task');
-
-
------------
--- PROJECTS
------------
-
---drop permissions
-delete from acs_permissions where object_id in (select project_id from pm_projects);
-
--- unregister content_types from folder
-create function inline_0 ()
-returns integer as '
-declare
-    v_folder_id	  cr_folders.folder_id%TYPE;
-    v_item_id     cr_items.item_id%TYPE;
-    v_item_cursor RECORD;
-begin
-
-    -- delete all contents of projects folder
-    FOR v_item_cursor IN
-        select
-        item_id
-        from
-        cr_items
-        where
-        content_type = ''pm_project''
-    LOOP
-       	PERFORM pm_project__delete_project_item(v_item_cursor.item_id);
-    END LOOP;
-
-    select content_item__get_id(''projects'', null, ''f'') into v_folder_id from dual;
-
-    -- unregister_content_types
-    PERFORM content_folder__unregister_content_type (
-        v_folder_id,		-- folder_id
-        ''pm_project'',		-- content_type
-        ''t''			-- include_subtypes
-    );
-
-    -- this table must not hold reference to ''pm_project'' type
-    delete from cr_folder_type_map where content_type = ''pm_project'';
-
-    -- delete projects folder
-    PERFORM content_folder__delete(v_folder_id);
-
-    -- delete the content folders
-    FOR v_item_cursor IN
-        select f.folder_id 
-        from   cr_folders f, 
-               cr_items   i
-        where  f.folder_id = i.item_id and 
-               description = ''Project Repository''
-    LOOP
-       	PERFORM content_item__delete(v_item_cursor.folder_id);
-    END LOOP;
-
-    return 0;
-end;
-' language 'plpgsql';
-
-select inline_0();
-drop function inline_0();
-
--- drop package, which drops all functions created with define_function_args
-select drop_package('pm_project');
-
---drop table
-drop table pm_projects cascade;
-
-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
-
+-- packages/project-manager/sql/project-manager-drop.sql
+-- drop script
+--
+-- @author jade@bread.com
+-- @creation-date 2003-05-15
+-- @cvs-id $Id$
+--
+
+--------
+-- TASKS
+--------
+
+-- task dependency types
+drop table pm_task_dependency_types cascade;
+drop table pm_task_dependency cascade;
+drop sequence pm_task_dependency_seq;
+drop sequence pm_tasks_number_seq;
+
+-------------
+-- WORKGROUPS
+-------------
+
+drop sequence pm_workgroup_seq;
+drop table pm_workgroup_parties;
+drop table pm_workgroup;
+
+------------
+-- PROCESSES
+------------
+
+drop sequence pm_process_seq;
+drop sequence pm_process_task_seq;
+drop sequence pm_process_task_dependency_seq;
+
+drop table pm_process_task_assignment;
+drop table pm_process_task_dependency;
+drop table pm_process_task;
+drop table pm_process;
+
+---------
+-- OTHERS
+---------
+drop table pm_default_roles;
+drop table pm_project_assignment;
+drop table pm_task_assignment;
+drop table pm_roles;
+drop sequence pm_role_seq;
+
+
+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.item_id);
+        end loop;
+
+    return 0;
+end;
+' language 'plpgsql';
+
+select inline_0();
+drop function inline_0();
+
+select drop_package('pm_task');
+
+
+-----------
+-- PROJECTS
+-----------
+
+--drop permissions
+delete from acs_permissions where object_id in (select project_id from pm_projects);
+
+-- unregister content_types from folder
+create function inline_0 ()
+returns integer as '
+declare
+    v_folder_id	  cr_folders.folder_id%TYPE;
+    v_item_id     cr_items.item_id%TYPE;
+    v_item_cursor RECORD;
+begin
+
+    -- delete all contents of projects folder
+    FOR v_item_cursor IN
+        select
+        item_id
+        from
+        cr_items
+        where
+        content_type = ''pm_project''
+    LOOP
+       	PERFORM pm_project__delete_project_item(v_item_cursor.item_id);
+    END LOOP;
+
+    select content_item__get_id(''projects'', null, ''f'') into v_folder_id from dual;
+
+    -- unregister_content_types
+    PERFORM content_folder__unregister_content_type (
+        v_folder_id,		-- folder_id
+        ''pm_project'',		-- content_type
+        ''t''			-- include_subtypes
+    );
+
+    -- this table must not hold reference to ''pm_project'' type
+    delete from cr_folder_type_map where content_type = ''pm_project'';
+
+    -- delete projects folder
+    PERFORM content_folder__delete(v_folder_id);
+
+    -- delete the content folders
+    FOR v_item_cursor IN
+        select f.folder_id 
+        from   cr_folders f, 
+               cr_items   i
+        where  f.folder_id = i.item_id and 
+               description = ''Project Repository''
+    LOOP
+       	PERFORM content_item__delete(v_item_cursor.folder_id);
+    END LOOP;
+
+    return 0;
+end;
+' language 'plpgsql';
+
+select inline_0();
+drop function inline_0();
+
+-- drop package, which drops all functions created with define_function_args
+select drop_package('pm_project');
+
+--drop table
+drop table pm_projects cascade;
+
+drop sequence pm_project_status_seq;
+drop table pm_project_status;
+
+drop table pm_project_category_map;
+
+drop sequence pm_project_category_seq;
+drop table pm_project_category;
+
+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
+