Index: openacs-4/packages/new-portal/sql/postgresql/api-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/postgresql/api-create.sql,v diff -u -r1.14.2.1 -r1.14.2.2 --- openacs-4/packages/new-portal/sql/postgresql/api-create.sql 12 Mar 2007 03:00:13 -0000 1.14.2.1 +++ openacs-4/packages/new-portal/sql/postgresql/api-create.sql 29 Mar 2007 00:43:38 -0000 1.14.2.2 @@ -23,21 +23,22 @@ -- @version $Id$ -- -select define_function_args('portal_page__new','page_id,pretty_name,portal_id,layout_id,hidden_p,object_type;portal_page,creation_date,creation_user,creation_ip,context_id'); +select define_function_args('portal_page__new','page_id,pretty_name,accesskey,portal_id,layout_id,hidden_p,object_type;portal_page,creation_date,creation_user,creation_ip,context_id'); -create function portal_page__new (integer,varchar,integer,integer,char,varchar,timestamptz,integer,varchar,integer) +create function portal_page__new (integer,char,varchar,integer,integer,char,varchar,timestamptz,integer,varchar,integer) returns integer as ' declare p_page_id alias for $1; p_pretty_name alias for $2; - p_portal_id alias for $3; - p_layout_id alias for $4; - p_hidden_p alias for $5; - p_object_type alias for $6; - p_creation_date alias for $7; - p_creation_user alias for $8; - p_creation_ip alias for $9; - p_context_id alias for $10; + p_accesskey alias for $3; + p_portal_id alias for $4; + p_layout_id alias for $5; + p_hidden_p alias for $6; + p_object_type alias for $7; + p_creation_date alias for $8; + p_creation_user alias for $9; + p_creation_ip alias for $10; + p_context_id alias for $11; v_page_id portal_pages.page_id%TYPE; v_layout_id portal_pages.layout_id%TYPE; v_sort_key portal_pages.sort_key%TYPE; @@ -67,9 +68,9 @@ where portal_id = p_portal_id; insert into portal_pages - (page_id, pretty_name, portal_id, layout_id, sort_key, hidden_p) + (page_id, pretty_name, accesskey, portal_id, layout_id, sort_key, hidden_p) values - (v_page_id, p_pretty_name, p_portal_id, v_layout_id, v_sort_key, p_hidden_p); + (v_page_id, p_pretty_name, p_accesskey, p_portal_id, v_layout_id, v_sort_key, p_hidden_p); return v_page_id;