Index: openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql,v
diff -u -r1.24 -r1.25
--- openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql	12 Mar 2005 19:45:05 -0000	1.24
+++ openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql	4 Jun 2006 00:45:22 -0000	1.25
@@ -285,7 +285,13 @@
   use_context     in cr_type_template_map.use_context%TYPE
 );
 
+-- Create or replace a trigger on insert for simplifying addition of
+-- revisions for any content type
 
+procedure refresh_trigger (
+  content_type  in acs_object_types.object_type%TYPE
+);
+
 end content_type;
 /
 show errors;
@@ -1499,7 +1505,7 @@
 			   default null,
   creation_ip	in acs_objects.creation_ip%TYPE default null,
   object_type   in acs_object_types.object_type%TYPE default 'content_keyword',
-  package_id    in acs_objects.package_id%TYPE
+  package_id    in acs_objects.package_id%TYPE default null
 ) return cr_keywords.keyword_id%TYPE;
 
 procedure del (