Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/common/country-data.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/common/currency-data.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/common/language-data.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/common/s-and-p-data.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/common/us-counties-data.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/common/us-states.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/common/us-zipcodes-data.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-reference/sql/oracle/acs-reference-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/oracle/acs-reference-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-reference/sql/oracle/acs-reference-create.sql	22 Apr 2001 00:52:26 -0000	1.1
+++ openacs-4/packages/acs-reference/sql/oracle/acs-reference-create.sql	27 Aug 2001 02:45:45 -0000	1.2
@@ -215,4 +215,4 @@
 
 -- now load the reference data packages
 
-@@acs-reference-data
+--acs-reference-data
Index: openacs-4/packages/acs-reference/sql/oracle/acs-reference-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/oracle/acs-reference-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-reference/sql/oracle/acs-reference-drop.sql	22 Apr 2001 00:52:26 -0000	1.1
+++ openacs-4/packages/acs-reference/sql/oracle/acs-reference-drop.sql	27 Aug 2001 02:45:45 -0000	1.2
@@ -1,36 +1,56 @@
 -- Drop the ACS Reference packages
 --
--- @author ron@arsdigita.com
+-- @author jon@jongriffin.com
 -- @cvs-id $Id$
 
 set serveroutput on
 
 -- drop all associated tables and packages
+-- ordered by repository_id for dependencies.
 
 declare
     cursor refsrc_cur is
 	 select   table_name,
-                  package_name
+                  package_name,
+                  repository_id
 	 from     acs_reference_repositories
-         order by creation_date desc;
+         order by repository_id desc;
 begin
     for rec in refsrc_cur loop
 	 dbms_output.put_line('Dropping ' || rec.table_name);
 	 execute immediate 'drop table ' || rec.table_name;
 	 if rec.package_name is not null then
 	     execute immediate 'drop package ' || rec.package_name;
          end if;
+         acs_reference.delete(rec.repository_id);
     end loop;
 end;
 /
 show errors
 
+-- drop privileges
 begin
+    acs_privilege.remove_child('create','acs_reference_create');
+    acs_privilege.remove_child('write', 'acs_reference_write');
+    acs_privilege.remove_child('read',  'acs_reference_read');
+    acs_privilege.remove_child('delete','acs_reference_delete');
+
+    acs_privilege.drop_privilege('acs_reference_create');
+    acs_privilege.drop_privilege('acs_reference_write');
+    acs_privilege.drop_privilege('acs_reference_read');
+    acs_privilege.drop_privilege('acs_reference_delete');
+end;
+/
+show errors
+
+-- drop the object
+
+begin
     acs_object_type.drop_type('acs_reference_repository','t');
 end;
 /
 show errors
   
-drop package acs_reference_repository;
+drop package acs_reference;
 drop table   acs_reference_repositories;
 
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/country.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/currency.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/language.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/s-and-p.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/us-counties.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/us-states.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/us-zipcodes.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/postgresql/country.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/postgresql/currency.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/postgresql/language.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/postgresql/s-and-p.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/postgresql/us-counties.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/postgresql/us-states.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/postgresql/us-zipcodes.sql'.
Fisheye: No comparison available.  Pass `N' to diff?