Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v diff -u -r1.23 -r1.24 --- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql 23 Jan 2005 23:16:19 -0000 1.23 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql 23 Feb 2005 11:52:20 -0000 1.24 @@ -857,6 +857,12 @@ include_subtypes => 't' ); + -- add the root content folder to acs_magic_objects + insert into acs_magic_objects (name, object_id) + select 'cr_item_root', + content_item.get_root_folder + from dual; + v_id := content_folder.new ( name => 'templates', label => 'Templates', @@ -883,6 +889,12 @@ include_subtypes => 't' ); + -- add to acs_magic_objects + insert into acs_magic_objects (name, object_id) + select 'cr_template_root', + content_template.get_root_folder + from dual; + end; / show errors Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v diff -u -r1.48 -r1.49 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 23 Jan 2005 23:16:20 -0000 1.48 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 23 Feb 2005 11:52:20 -0000 1.49 @@ -1278,6 +1278,11 @@ ''t'' ); + -- add the root content folder to acs_magic_objects + insert into acs_magic_objects (name, object_id) + select ''cr_item_root'', + content_item__get_root_folder(null); + v_id := content_folder__new ( ''templates'', ''Templates'', @@ -1308,6 +1313,11 @@ ''t'' ); + -- add to acs_magic_objects + insert into acs_magic_objects (name, object_id) + select ''cr_template_root'', + content_template__get_root_folder(); + return 0; end;' language 'plpgsql';