Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql,v diff -u -r1.36 -r1.37 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql 2 Jun 2004 20:54:15 -0000 1.36 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql 1 Jul 2004 16:33:38 -0000 1.37 @@ -206,9 +206,10 @@ return 0; end;' language 'plpgsql'; -select define_function_args('content_type__create_attribute','content_type,attribute_name,datatype,pretty_name,pretty_plural,sort_order,default_value,column_spec;text'); -- function create_attribute + +select define_function_args('content_type__create_attribute','content_type,attribute_name,datatype,pretty_name,pretty_plural,sort_order,default_value,column_spec;text'); create or replace function content_type__create_attribute (varchar,varchar,varchar,varchar,varchar,integer,varchar,varchar) returns integer as ' declare @@ -323,6 +324,7 @@ -- procedure register_template +select define_function_args('content_type__register_template','content_type,template_id,use_context,is_default;f'); create or replace function content_type__register_template (varchar,integer,varchar,boolean) returns integer as ' declare @@ -375,6 +377,7 @@ -- procedure set_default_template +select define_function_args('content_type__set_default_template','content_type,template_id,use_context'); create or replace function content_type__set_default_template (varchar,integer,varchar) returns integer as ' declare @@ -404,6 +407,7 @@ -- function get_template +select define_function_args('content_type__get_template','content_type,use_context'); create or replace function content_type__get_template (varchar,varchar) returns integer as ' declare @@ -430,6 +434,7 @@ -- procedure unregister_template +select define_function_args('content_type__unregister_template','content_type,template_id,use_context'); create or replace function content_type__unregister_template (varchar,integer,varchar) returns integer as ' declare @@ -470,6 +475,7 @@ -- function trigger_insert_statement +select define_function_args('content_type__trigger_insert_statement','content_type'); create or replace function content_type__trigger_insert_statement (varchar) returns varchar as ' declare @@ -552,6 +558,7 @@ -- revisions for any content type -- procedure refresh_trigger +select define_function_args('content_type__refresh_trigger','content_type'); create or replace function content_type__refresh_trigger (varchar) returns integer as ' declare @@ -633,6 +640,7 @@ -- procedure refresh_view +select define_function_args('content_type__refresh_view','content_type'); create or replace function content_type__refresh_view (varchar) returns integer as ' declare @@ -749,6 +757,7 @@ -- procedure register_child_type +select define_function_args('content_type__register_child_type','content_type,child_type,relation_tag;generic,min_n;0,max_n'); create or replace function content_type__register_child_type (varchar,varchar,varchar,integer,integer) returns integer as ' declare @@ -796,6 +805,7 @@ -- procedure unregister_child_type +select define_function_args('content_type__unregister_child_type','content_type,child_type,relation_tag'); create or replace function content_type__unregister_child_type (varchar,varchar,varchar) returns integer as ' declare @@ -818,6 +828,8 @@ -- procedure register_relation_type +select define_function_args('content_type__register_relation_type','content_type,target_type,relation_tag;generic,min_n;0,max_n'); + create or replace function content_type__register_relation_type (varchar,varchar,varchar,integer,integer) returns integer as ' declare @@ -870,6 +882,8 @@ -- procedure unregister_relation_type +select define_function_args('content_type__unregister_relation_type','content_type,target_type,relation_tag;generic'); + create or replace function content_type__unregister_relation_type (varchar,varchar,varchar) returns integer as ' declare @@ -893,6 +907,7 @@ -- procedure register_mime_type +select define_function_args('content_type__register_mime_type','content_type,mime_type'); create or replace function content_type__register_mime_type (varchar,varchar) returns integer as ' declare @@ -930,6 +945,7 @@ -- procedure unregister_mime_type +select define_function_args('content_type__unregister_mime_type','content_type,mime_type'); create or replace function content_type__unregister_mime_type (varchar,varchar) returns integer as ' declare @@ -946,6 +962,8 @@ -- function is_content_type +select define_function_args('content_type__is_content_type','content_type'); + create or replace function content_type__is_content_type (varchar) returns boolean as ' declare @@ -970,6 +988,8 @@ -- procedure rotate_template +select define_function_args('content_type__rotate_template','template_id,content_type,use_context'); + create or replace function content_type__rotate_template (integer,varchar,varchar) returns integer as ' declare