Index: openacs-4/packages/dotlrn-lorsm/sql/postgresql/dotlrn-lorsm-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-lorsm/sql/postgresql/Attic/dotlrn-lorsm-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lors/sql/postgresql/lors-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/lors-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lors/sql/postgresql/lors-imscp-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/lors-imscp-drop.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/lors/sql/postgresql/lors-imscp-drop.sql	18 May 2005 17:13:08 -0000	1.6
+++ openacs-4/packages/lors/sql/postgresql/lors-imscp-drop.sql	20 Jun 2005 13:04:06 -0000	1.7
@@ -1,23 +1,79 @@
--- IMS Content Packaging data model
+-- IMS Content Packaging Data Model
 --
--- @author Ernie Ghiglione (ErnieG@ee.usyd.edu.au)
+-- @author Nima Mazloumi (mazloumi@uni-mannheim.de)
 -- @creation-date 6 Jan 2004
--- @cvs-id $Id$
 
--- Based on IMS Content Packaging Specifications Version 1.1.2 
--- http://www.imsglobal.org/content/packaging/cpv1p1p2/imscp_infov1p1p2.html
+--
+--  Copyright (C) 2004 Nima Mazloumi
+--
+--  This package is free software; you can redistribute it and/or modify it under the
+--  terms of the GNU General Public License as published by the Free Software
+--  Foundation; either version 2 of the License, or (at your option) any later
+--  version.
+--
+--  It is distributed in the hope that it will be useful, but WITHOUT ANY
+--  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+--  FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
+--  details.
+--
 
 -- And
 
 -- SCORM 1.2 Specs
 
+
+-----
+--   Drop all object types
+-----
+
+
+    select acs_object_type__drop_type (
+                'ims_manifest',          -- object_type
+                'f'
+        );
+        
+       
+    select acs_object_type__drop_type (
+                'ims_organization',          -- object_type
+                'f'
+        );
+ 
+     select acs_object_type__drop_type (
+                 'ims_item',          -- object_type
+                 'f'
+        );
+        
+     select acs_object_type__drop_type (
+                 'ims_resource',          -- object_type
+                 'f'
+        );        
+
+-----
+--   Drop tables
+----
+
+-- Manifest files
+DROP TABLE ims_cp_manifest_class;
+
 -- Manifests
-drop table ims_cp_dependencies;
-drop sequence ims_cp_dependencies_seq;
-drop table ims_cp_files;
-drop table ims_cp_resources;
-drop table ims_cp_items;
-drop table ims_cp_organizations;
-drop table ims_cp_manifests;
-drop table lors_available_presentation_formats;
+DROP TABLE ims_cp_manifests CASCADE;
 
+-- Organizations
+DROP TABLE ims_cp_organizations CASCADE;
+
+-- Items
+DROP TABLE ims_cp_items CASCADE;
+
+-- Resources
+DROP TABLE ims_cp_resources CASCADE;  
+
+-- Item resources mapping
+DROP TABLE ims_cp_items_to_resources;
+
+-- Resource dependencies
+DROP SEQUENCE ims_cp_dependencies_seq;
+DROP TABLE ims_cp_dependencies;
+
+-- Resource files
+DROP TABLE ims_cp_files;
+
Index: openacs-4/packages/lors/sql/postgresql/lors-imscp-package-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/lors-imscp-package-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lors/sql/postgresql/lors-imsmd-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/lors-imsmd-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lors/sql/postgresql/lors-imsmd-packages-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/lors-imsmd-packages-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lors/sql/postgresql/lors-imsmd-sc-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/lors-imsmd-sc-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lorsm/sql/postgresql/lorsm-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/sql/postgresql/lorsm-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lorsm/sql/postgresql/lorsm-drop.sql	26 May 2005 18:14:59 -0000	1.1
+++ openacs-4/packages/lorsm/sql/postgresql/lorsm-drop.sql	20 Jun 2005 13:04:02 -0000	1.2
@@ -35,3 +35,4 @@
        'public'
 );
 
+\i lorsm-packages-drop.sql
Index: openacs-4/packages/lorsm/sql/postgresql/lorsm-packages-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/sql/postgresql/lorsm-packages-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lorsm/sql/postgresql/lorsm-template-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/sql/postgresql/lorsm-template-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lorsm-portlet/sql/postgresql/lorsm-admin-portlet-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm-portlet/sql/postgresql/lorsm-admin-portlet-drop.sql,v
diff -u
Binary files differ
Index: openacs-4/packages/lorsm-portlet/sql/postgresql/lorsm-portlet-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm-portlet/sql/postgresql/lorsm-portlet-drop.sql,v
diff -u
Binary files differ