Index: openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	24 Mar 2001 22:00:48 -0000	1.1
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	11 May 2001 04:43:39 -0000	1.2
@@ -166,9 +166,19 @@
       acs_object_types 
     where
       object_type = drop_type.content_type;
+
+    -- drop the input/output views for the type
+    -- being dropped.
+    -- FIXME: does the trigger get dropped when the 
+    -- view is dropped?  This did not exist in the 4.2 release,
+    -- and it needs to be tested.
+
        
-    execute immediate 'drop table ' || v_table_name ;
+    execute immediate 'drop view ' || v_table_name || 'x';
+    execute immediate 'drop view ' || v_table_name || 'i';
 
+    execute immediate 'drop table ' || v_table_name;
+
   end if;
 
   acs_object_type.drop_type(
