Index: openacs-4/packages/cms/sql/postgresql/upgrade/upgrade-5.0d-5.1d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/sql/postgresql/upgrade/upgrade-5.0d-5.1d.sql,v
diff -u -r1.1.2.3 -r1.1.2.4
--- openacs-4/packages/cms/sql/postgresql/upgrade/upgrade-5.0d-5.1d.sql	31 Aug 2006 19:59:04 -0000	1.1.2.3
+++ openacs-4/packages/cms/sql/postgresql/upgrade/upgrade-5.0d-5.1d.sql	19 Feb 2007 22:17:42 -0000	1.1.2.4
@@ -6,15 +6,21 @@
 -- @cvs-id $Id$
 --
 
+update apm_package_types set singleton_p = 'f' where package_key = 'cms';
+
+insert into acs_rel_roles (role,pretty_name,pretty_plural) values ('author','Author','Authors');
+insert into acs_rel_roles (role,pretty_name,pretty_plural) values ('editor','Editor','Editors');
+insert into acs_rel_roles (role,pretty_name,pretty_plural) values ('publisher','Publisher','Publishers');
 -- adds package_id to call to content_item__new
+select define_function_args('content_module__new','name,key,root_key,sort_key,parent_id,package_id,object_id,creation_date,creation_user,creation_ip,object_type');
 create or replace function content_module__new (varchar,varchar,varchar,integer,integer,integer,integer,timestamptz,integer,varchar,varchar)
 returns integer as '
 declare
   p_name                        alias for $1;  
   p_key                         alias for $2;  
   p_root_key                    alias for $3;  
   p_sort_key                    alias for $4;  
-  p_parent_id                   alias for $5;  -- null  
+  p_parent_id                   alias for $5;  
   p_package_id                  alias for $6;
   p_object_id                   alias for $7;  -- null
   p_creation_date               alias for $8;  -- now()
@@ -58,4 +64,4 @@
 select define_function_args('content_method__add_all_methods','content_type');
 select define_function_args('content_method__add_method','content_type,content_method,is_default');
 select define_function_args('content_method__is_mapped','content_type,content_method');
-select define_function_args('content_method__get_method','content_type');
\ No newline at end of file
+select define_function_args('content_method__get_method','content_type');