Index: openacs-4/packages/cms/cms.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/cms.info,v diff -u -r1.15 -r1.16 --- openacs-4/packages/cms/cms.info 9 May 2005 22:44:47 -0000 1.15 +++ openacs-4/packages/cms/cms.info 4 Oct 2005 22:06:23 -0000 1.16 @@ -7,20 +7,22 @@ f f - - Michael Steigman - Karl Goldstein + David Lutterkort + Karl Goldstein + Michael Steigman A CMS implemented on top of the Content Repository - 2001-01-26 + 2005-10-04 OpenACS - CMS is a full featured content management system implemented on top of - the content repository which supports workflow, composite objects, dynamicly created attributes, publishing to - the filesystem and categorization. The user interface needs a great deal of work and the package relies on - acs-workflow which has been deprecated. Alternatives include etp and bcms (which is a work in progress), CMS - remains the best place to look to find examples of how the content repository should be used. + CMS is a full featured content management system implemented on top of + the content repository which supports workflow, composite objects, dynamicly created attributes, publishing to + the filesystem and categorization. The user interface needs a great deal of work and the package relies on + acs-workflow which has been deprecated. Alternatives include etp and bcms (which is a work in progress), CMS + remains the best place to look to find examples of how the content repository should be used. - + 0 + + Index: openacs-4/packages/cms/sql/postgresql/cms-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/sql/postgresql/cms-create.sql,v diff -u -r1.12 -r1.13 --- openacs-4/packages/cms/sql/postgresql/cms-create.sql 27 Sep 2005 08:00:32 -0000 1.12 +++ openacs-4/packages/cms/sql/postgresql/cms-create.sql 4 Oct 2005 22:01:38 -0000 1.13 @@ -231,7 +231,8 @@ ''text/plain'', null, null, - ''file'' + ''file'', + p_package_id ); insert into cm_modules 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 --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/cms/sql/postgresql/upgrade/upgrade-5.0d-5.1d.sql 4 Oct 2005 22:05:51 -0000 1.1 @@ -0,0 +1,53 @@ +-- +-- packages/cms/sql/postgresql/upgrade/upgrade-5.0d-5.1d.sql +-- +-- @author Stan Kaufman (skaufman@epimetrics.com) +-- @creation-date 2005-10-04 +-- @cvs-id $Id: upgrade-5.0d-5.1d.sql,v 1.1 2005/10/04 22:05:51 skaufman Exp $ +-- + +-- adds package_id to call to content_item__new +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_package_id alias for $6; + p_object_id alias for $7; -- null + p_creation_date alias for $8; -- now() + p_creation_user alias for $9; -- null + p_creation_ip alias for $10; -- null + p_object_type alias for $11; -- ''content_module'' + v_module_id integer; +begin + v_module_id := content_item__new( + p_name, + p_parent_id, + p_object_id, + null, + p_creation_date, + p_creation_user, + null, + p_creation_ip, + ''content_module'', + p_object_type, + null, + null, + ''text/plain'', + null, + null, + ''file'', + p_package_id + ); + + insert into cm_modules + (module_id, key, name, root_key, sort_key, package_id) + values + (v_module_id, p_key, p_name, p_root_key, p_sort_key, p_package_id); + + return v_module_id; + +end;' language 'plpgsql';