Index: openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql,v diff -u -r1.46.2.2 -r1.46.2.3 --- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql 29 Mar 2007 00:43:38 -0000 1.46.2.2 +++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql 29 Mar 2007 01:14:07 -0000 1.46.2.3 @@ -169,7 +169,7 @@ default 'Untitled Page' constraint portal_pages_pretty_name_nn not null, - accesskey char(1) + accesskey varchar(200) default null, portal_id constraint portal_pages_portal_id_fk references portals (portal_id) Index: openacs-4/packages/new-portal/sql/oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/new-portal/sql/oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql 29 Mar 2007 00:43:38 -0000 1.1.2.1 +++ openacs-4/packages/new-portal/sql/oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql 29 Mar 2007 01:14:07 -0000 1.1.2.2 @@ -1,4 +1,4 @@ -alter table add accesskey char(1) default null; +alter table add accesskey varchar(200) default null; create or replace package portal_page as 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.2 -r1.14.2.3 --- openacs-4/packages/new-portal/sql/postgresql/api-create.sql 29 Mar 2007 00:43:38 -0000 1.14.2.2 +++ openacs-4/packages/new-portal/sql/postgresql/api-create.sql 29 Mar 2007 01:14:07 -0000 1.14.2.3 @@ -25,7 +25,7 @@ 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,char,varchar,integer,integer,char,varchar,timestamptz,integer,varchar,integer) +create function portal_page__new (integer,varchar,varchar,integer,integer,char,varchar,timestamptz,integer,varchar,integer) returns integer as ' declare p_page_id alias for $1; Index: openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql,v diff -u -r1.5.2.2 -r1.5.2.3 --- openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql 29 Mar 2007 00:43:38 -0000 1.5.2.2 +++ openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql 29 Mar 2007 01:14:07 -0000 1.5.2.3 @@ -173,7 +173,7 @@ default 'Untitled Page' constraint portal_pages_pretty_name_nn not null, - accesskey char(1) + accesskey varchar(200) default null, portal_id integer constraint portal_pages_portal_id_fk Index: openacs-4/packages/new-portal/sql/postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/new-portal/sql/postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql 29 Mar 2007 00:43:38 -0000 1.1.2.1 +++ openacs-4/packages/new-portal/sql/postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql 29 Mar 2007 01:14:07 -0000 1.1.2.2 @@ -1,8 +1,8 @@ -alter table portal_pages add accesskey char(1) default null; +alter table portal_pages add accesskey varchar(200) default null; 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'); -drop function portal_page__new (integer,varchar,integer,integer,char,varchar,timestamptz,integer,varchar,integer); +--drop function portal_page__new (integer,varchar,integer,integer,char,varchar,timestamptz,integer,varchar,integer); create or replace function portal_page__new (integer,char,varchar,integer,integer,char,varchar,timestamptz,integer,varchar,integer) returns integer as '