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.33.2.2 -r1.33.2.3 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 26 May 2004 19:10:12 -0000 1.33.2.2 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 21 Dec 2004 18:22:30 -0000 1.33.2.3 @@ -199,6 +199,7 @@ end;' language 'plpgsql'; -- procedure delete +select define_function_args('content_folder__delete','folder_id,cascade_p;f'); create or replace function content_folder__delete (integer, boolean) returns integer as ' @@ -280,6 +281,7 @@ -- procedure rename +select define_function_args('content_folder__edit_name','folder_id,name,label,description'); create or replace function content_folder__edit_name (integer,varchar,varchar,varchar) returns integer as ' declare @@ -322,6 +324,8 @@ -- 3) update the parent_id for the folder -- procedure move +select define_function_args('content_folder__move','folder_id,target_folder_id'); + create or replace function content_folder__move (integer,integer) returns integer as ' declare @@ -525,6 +529,7 @@ -- function is_folder +select define_function_args('content_folder__is_folder','folder_id'); create or replace function content_folder__is_folder (integer) returns boolean as ' declare @@ -538,6 +543,7 @@ -- function is_sub_folder +select define_function_args('content_folder__is_sub_folder','folder_id,target_folder_id'); create or replace function content_folder__is_sub_folder (integer,integer) returns boolean as ' declare @@ -579,10 +585,11 @@ return v_sub_folder_p; -end;' language 'plpgsql'; +end;' language 'plpgsql'; -- function is_empty +select define_function_args('content_folder__is_empty','folder_id'); create or replace function content_folder__is_empty (integer) returns boolean as ' declare @@ -603,6 +610,8 @@ -- procedure register_content_type +select define_function_args('content_folder__register_content_type','folder_id,content_type,include_subtypes;f'); + create or replace function content_folder__register_content_type (integer,varchar,boolean) returns integer as ' declare @@ -668,6 +677,7 @@ -- procedure unregister_content_type +select define_function_args('content_folder__unregister_content_type','folder_id,content_type,include_subtypes;f'); create or replace function content_folder__unregister_content_type (integer,varchar,boolean) returns integer as ' declare @@ -706,6 +716,7 @@ -- function is_registered +select define_function_args('content_folder__is_registered','folder_id,content_type,include_subtypes;f'); create or replace function content_folder__is_registered (integer,varchar,boolean) returns boolean as ' declare @@ -765,6 +776,7 @@ -- function get_label +select define_function_args('content_folder__get_label','folder_id'); create or replace function content_folder__get_label (integer) returns varchar as ' declare @@ -785,6 +797,7 @@ -- function get_index_page +select define_function_args('content_folder__get_index_page','folder_id'); create or replace function content_folder__get_index_page (integer) returns integer as ' declare @@ -827,6 +840,7 @@ -- function is_root +select define_function_args('content_folder__is_root','folder_id'); create or replace function content_folder__is_root (integer) returns boolean as ' declare