Index: openacs-4/packages/download/sql/postgresql/download-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/download-drop.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/download/sql/postgresql/download-drop.sql	23 May 2001 20:00:56 -0000	1.6
+++ openacs-4/packages/download/sql/postgresql/download-drop.sql	23 Feb 2002 05:15:35 -0000	1.7
@@ -1,4 +1,13 @@
 --
+-- packages/sdm/sql/download/download-drop.sql
+--
+-- 
+-- @author Vinod Kurup (vinod@kurup.com)
+-- 
+-- @cvs-id $Id$
+--
+
+--
 -- Drop the data model and the PL/SQL packages.
 --
 
@@ -58,30 +67,6 @@
 
 drop function inline_0 ();
 
---begin
---    for archive_rec in (select item_id from cr_items where content_type = 'cr_download_archive_desc')
---    loop
---        content_item.delete(archive_rec.item_id);
---    end loop;
---end;
---/
---
---begin
---    for archive_rec in (select item_id from cr_items where content_type = 'cr_download_archive')
---    loop
---        content_item.delete(archive_rec.item_id);
---    end loop;
---end;
---/
---
---begin
---    for archive_rec in (select item_id from cr_items where content_type = 'cr_download_rep')
---    loop
---        content_item.delete(archive_rec.item_id);
---    end loop;
---end;
---/
-
 /* acs_object_type */
 
 create function inline_1 ()
@@ -124,48 +109,3 @@
 
 drop function inline_1 ();
 
---begin
---  content_type.unregister_child_type(
---      parent_type => 'cr_download_rep',
---      child_type => 'cr_download_archive',
---      relation_tag => 'generic'
---  );
---
---  content_type.unregister_child_type(
---      parent_type => 'cr_download_rep',
---      child_type => 'cr_download_archive_desc',
---      relation_tag => 'generic'
---  );
---end;
---/
---
---begin
---    acs_object_type.drop_type(
---        object_type => 'cr_download_archive_desc',
---        cascade_p => 't'
---    );
---end;
---/
---show errors
---
---begin
---    acs_object_type.drop_type(
---        object_type => 'cr_download_rep',
---        cascade_p => 't'
---    );
---end;
---/
---show errors
---
---begin
---    acs_object_type.drop_type(
---        object_type => 'cr_download_archive',
---        cascade_p => 't'
---    );
---
---end;
---/
---show errors
---
-
---drop package download_rep;