Index: openacs-4/contrib/packages/portal/sql/postgresql/datasource-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/portal/sql/postgresql/datasource-package-create.sql,v diff -u -r1.5 -r1.6 --- openacs-4/contrib/packages/portal/sql/postgresql/datasource-package-create.sql 22 Jan 2004 02:50:11 -0000 1.5 +++ openacs-4/contrib/packages/portal/sql/postgresql/datasource-package-create.sql 12 Mar 2004 04:54:04 -0000 1.6 @@ -23,28 +23,29 @@ -- @version $Id$ -- -select define_function_args('portal_datasource__new', 'name,pretty_name,application,owner,template,shadeable_p;t,hideable_p;t,description'); +select define_function_args('portal_datasource__new', 'name,pretty_name,application,owner,template,admin_p;f,shadeable_p;t,hideable_p;t,description'); -create or replace function portal_datasource__new (varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar) +create or replace function portal_datasource__new (varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar) returns integer as ' declare p_name alias for $1; p_pretty_name alias for $2; p_application alias for $3; p_owner alias for $4; p_template alias for $5; - p_shadeable_p alias for $6; - p_hideable_p alias for $7; - p_description alias for $8; + p_admin_p alias for $6; + p_shadeable_p alias for $7; + p_hideable_p alias for $8; + p_description alias for $9; v_datasource_id portal_datasources.datasource_id%TYPE; begin v_datasource_id := nextval(''portal_seq''); insert into portal_datasources - (datasource_id, name, pretty_name, application, owner, template, shadeable_p, hideable_p, description) + (datasource_id, name, pretty_name, application, owner, template, admin_p, shadeable_p, hideable_p, description) values - (v_datasource_id, p_name, p_pretty_name, p_application, p_owner, p_template, p_shadeable_p, p_hideable_p, p_description); + (v_datasource_id, p_name, p_pretty_name, p_application, p_owner, p_template, p_admin_p, p_shadeable_p, p_hideable_p, p_description); return v_datasource_id;