Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-main-portlet-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-main-portlet-create.sql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/dotlrn/sql/oracle/dotlrn-main-portlet-create.sql 16 Nov 2001 23:56:07 -0000 1.5 +++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-main-portlet-create.sql 17 Nov 2001 16:34:56 -0000 1.6 @@ -19,8 +19,7 @@ begin ds_id := portal_datasource.new( name => 'dotlrn_main_portlet', - description => 'Displays the list of communities a user belongs to', - configurable_p => 't' + description => 'Displays the list of communities a user belongs to' ); end; Index: openacs-4/packages/new-portal/sql/oracle/api-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/api-create.sql,v diff -u -r1.19 -r1.20 --- openacs-4/packages/new-portal/sql/oracle/api-create.sql 16 Nov 2001 18:52:51 -0000 1.19 +++ openacs-4/packages/new-portal/sql/oracle/api-create.sql 17 Nov 2001 16:36:34 -0000 1.20 @@ -255,7 +255,6 @@ datasource_id in portal_datasources.datasource_id%TYPE default null, name in portal_datasources.name%TYPE default null, description in portal_datasources.description%TYPE default null, - configurable_p in portal_datasources.configurable_p%TYPE default null, object_type in acs_object_types.object_type%TYPE default 'portal_datasource', creation_date in acs_objects.creation_date%TYPE default sysdate, @@ -288,7 +287,6 @@ datasource_id in portal_datasources.datasource_id%TYPE default null, name in portal_datasources.name%TYPE default null, description in portal_datasources.description%TYPE default null, - configurable_p in portal_datasources.configurable_p%TYPE default null, object_type in acs_object_types.object_type%TYPE default 'portal_datasource', creation_date in acs_objects.creation_date%TYPE default sysdate, creation_user in acs_objects.creation_user%TYPE default null, @@ -310,9 +308,9 @@ insert into portal_datasources - (datasource_id, name, description, configurable_p) + (datasource_id, name, description) values - (v_datasource_id, name, description, configurable_p); + (v_datasource_id, name, description); return v_datasource_id; end new; 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.22 -r1.23 --- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql 15 Nov 2001 21:19:00 -0000 1.22 +++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql 17 Nov 2001 16:34:04 -0000 1.23 @@ -22,18 +22,12 @@ -- **** DATASOURCES **** --- Some datasources need to be restricted and some do not. The way we --- will handle this is a check at PE creation (DS binding) time, and --- of course, checks on the portal_id sent in. create table portal_datasources ( datasource_id constraint p_datasources_datasource_id_fk references acs_objects(object_id) constraint p_datasources_datasource_id_pk primary key, description varchar(4000), - configurable_p char(1) default 'f' - constraint p_elements_configurable_p_ck - check(configurable_p in ('t', 'f')), name varchar(200) not null );