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.13 -r1.14
--- openacs-4/packages/new-portal/sql/postgresql/api-create.sql	24 Jul 2004 15:24:34 -0000	1.13
+++ openacs-4/packages/new-portal/sql/postgresql/api-create.sql	8 Aug 2006 21:26:59 -0000	1.14
@@ -23,20 +23,21 @@
 -- @version $Id$
 --
 
-select define_function_args('portal_page__new','page_id,pretty_name,portal_id,layout_id,object_type;portal_page,creation_date,creation_user,creation_ip,context_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');
 
-create function portal_page__new (integer,varchar,integer,integer,varchar,timestamptz,integer,varchar,integer)
+create function portal_page__new (integer,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_object_type                   alias for $5;
-    p_creation_date                 alias for $6;
-    p_creation_user                 alias for $7;
-    p_creation_ip                   alias for $8;
-    p_context_id                    alias for $9;
+    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;
     v_page_id                       portal_pages.page_id%TYPE;
     v_layout_id                     portal_pages.layout_id%TYPE;
     v_sort_key                      portal_pages.sort_key%TYPE;
@@ -66,9 +67,9 @@
     where portal_id = p_portal_id;
 
     insert into portal_pages
-    (page_id, pretty_name, portal_id, layout_id, sort_key)
+    (page_id, pretty_name, portal_id, layout_id, sort_key, hidden_p)
     values
-    (v_page_id, p_pretty_name, p_portal_id, v_layout_id, v_sort_key);
+    (v_page_id, p_pretty_name, p_portal_id, v_layout_id, v_sort_key, p_hidden_p);
 
     return v_page_id;
 
@@ -195,6 +196,7 @@
             p_default_page_name,
             v_portal_id,
             v_layout_id,
+            ''f'',
             ''portal_page'',
             p_creation_date,
             p_creation_user,
@@ -228,6 +230,7 @@
             v_page.pretty_name,
             v_portal_id,
             v_page.layout_id,
+            ''f'',
             ''portal_page'',
             p_creation_date,
             p_creation_user,