Index: openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql,v diff -u -r1.14 -r1.15 --- openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql 25 Mar 2004 15:59:29 -0000 1.14 +++ openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql 29 Jun 2004 10:18:29 -0000 1.15 @@ -12,7 +12,7 @@ -- chunks lifted from Gilbert. Thanks Orchard Labs! -- -select define_function_args ('forums_message__new', 'message_id,object_type;forums_message,forum_id,subject,content,html_p,user_id,posting_date,state,parent_id,creation_date,creation_user,creation_ip,context_id'); +select define_function_args ('forums_message__new', 'message_id,object_type;forums_message,forum_id,subject,content,format,user_id,posting_date,state,parent_id,creation_date,creation_user,creation_ip,context_id'); create or replace function forums_message__new (integer,varchar,integer,varchar,text,char,integer,timestamptz,varchar,integer,timestamptz,integer,varchar,integer) returns integer as ' @@ -22,7 +22,7 @@ p_forum_id alias for $3; p_subject alias for $4; p_content alias for $5; - p_html_p alias for $6; + p_format alias for $6; p_user_id alias for $7; p_posting_date alias for $8; p_state alias for $9; @@ -77,9 +77,9 @@ end if; insert into forums_messages - (message_id, forum_id, subject, content, html_p, user_id, posting_date, parent_id, state) + (message_id, forum_id, subject, content, format, user_id, posting_date, parent_id, state) values - (v_message_id, p_forum_id, p_subject, p_content, p_html_p, p_user_id, v_posting_date, p_parent_id, v_state); + (v_message_id, p_forum_id, p_subject, p_content, p_format, p_user_id, v_posting_date, p_parent_id, v_state); update forums_forums set last_post = v_posting_date