Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -r1.34 -r1.35
--- openacs-4/packages/acs-content-repository/acs-content-repository.info 27 Mar 2004 13:23:30 -0000 1.34
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info 27 Mar 2004 15:58:03 -0000 1.35
@@ -7,7 +7,7 @@
t
t
-
+
OpenACS
The canonical repository for OpenACS content.
2004-03-10
@@ -17,7 +17,7 @@
other CMS backing functionality. Utilized by Bug Tracker, File Storage, and other packages.
-
+
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql,v
diff -u -r1.35 -r1.36
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 12 Mar 2004 19:19:46 -0000 1.35
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 27 Mar 2004 15:58:03 -0000 1.36
@@ -406,7 +406,7 @@
PERFORM content_item__rename(rename__folder_id, rename__name);
end if;
- if rename__label is not null and rename_label != '''' then
+ if rename__label is not null and rename__label != '''' then
update acs_objects
set title = rename__label
where object_id = rename__folder_id;
Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql 27 Mar 2004 15:58:03 -0000 1.1
@@ -0,0 +1,39 @@
+-- this one had a rename__label as rename_label so replace it.
+create or replace function content_folder__rename (integer,varchar,varchar,varchar)
+returns integer as '
+declare
+ rename__folder_id alias for $1;
+ rename__name alias for $2; -- default null
+ rename__label alias for $3; -- default null
+ rename__description alias for $4; -- default null
+ v_name_already_exists_p integer;
+begin
+
+ if rename__name is not null and rename__name != '''' then
+ PERFORM content_item__rename(rename__folder_id, rename__name);
+ end if;
+
+ if rename__label is not null and rename__label != '''' then
+ update acs_objects
+ set title = rename__label
+ where object_id = rename__folder_id;
+ end if;
+
+ if rename__label is not null and rename__label != '''' and
+ rename__description is not null and rename__description != '''' then
+
+ update cr_folders
+ set label = rename__label,
+ description = rename__description
+ where folder_id = rename__folder_id;
+
+ else if(rename__label is not null and rename__label != '''') and
+ (rename__description is null or rename__description = '''') then
+ update cr_folders
+ set label = rename__label
+ where folder_id = rename__folder_id;
+
+ end if; end if;
+
+ return 0;
+end;' language 'plpgsql';