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 -r1.4 -r1.5
--- openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	17 May 2003 09:42:02 -0000	1.4
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	1 Feb 2005 17:09:24 -0000	1.5
@@ -617,7 +617,19 @@
   -- create the input view (includes content columns)
 
   execute immediate 'create or replace view ' || v_table_name ||
-    'i as select acs_objects.*, cr.revision_id, cr.title, cr.item_id,
+    'i as select acs_objects.object_id,
+ acs_objects.object_type,
+ acs_objects.title as object_title,
+ acs_objects.package_id as object_package_id,
+ acs_objects.context_id,
+ acs_objects.security_inherit_p,
+ acs_objects.creation_user,
+ acs_objects.creation_date,
+ acs_objects.creation_ip,
+ acs_objects.last_modified,
+ acs_objects.modifying_user,
+ acs_objects.modifying_ip,
+ cr.revision_id, cr.title, cr.item_id,
     cr.content as data, cr_text.text,
     cr.description, cr.publish_date, cr.mime_type, cr.nls_language' || 
     cols || 
@@ -627,7 +639,19 @@
   -- create the output view (excludes content columns to enable SELECT *)
 
   execute immediate 'create or replace view ' || v_table_name ||
-    'x as select acs_objects.*, cr.revision_id, cr.title, cr.item_id,
+    'x as select acs_objects.object_id,
+ acs_objects.object_type,
+ acs_objects.title as object_title,
+ acs_objects.package_id as object_package_id,
+ acs_objects.context_id,
+ acs_objects.security_inherit_p,
+ acs_objects.creation_user,
+ acs_objects.creation_date,
+ acs_objects.creation_ip,
+ acs_objects.last_modified,
+ acs_objects.modifying_user,
+ acs_objects.modifying_ip,
+ cr.revision_id, cr.title, cr.item_id,
     cr.description, cr.publish_date, cr.mime_type, cr.nls_language,
     i.name, i.parent_id' || 
     cols ||