Index: openacs-4/packages/new-portal/new-portal.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/new-portal.info,v
diff -u -r1.40.2.4 -r1.40.2.5
--- openacs-4/packages/new-portal/new-portal.info 1 Dec 2015 13:38:55 -0000 1.40.2.4
+++ openacs-4/packages/new-portal/new-portal.info 14 May 2016 17:08:09 -0000 1.40.2.5
@@ -8,15 +8,15 @@
t
portal
-
+
OpenACS
Portals.
2015-10-04
DotLRN Consortium
2
New Portal Package aka NPP. Portals are used to aggregate content from different sources within a single page. Props to Ian Baker for "Portal".
-
+
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.18 -r1.18.4.1
--- openacs-4/packages/new-portal/sql/postgresql/api-create.sql 1 Nov 2013 21:45:33 -0000 1.18
+++ openacs-4/packages/new-portal/sql/postgresql/api-create.sql 14 May 2016 17:08:09 -0000 1.18.4.1
@@ -36,7 +36,7 @@
p_accesskey varchar,
p_portal_id integer,
p_layout_id integer,
- p_hidden_p char,
+ p_hidden_p boolean,
p_object_type varchar, -- default 'portal_page'
p_creation_date timestamptz,
p_creation_user integer,
@@ -543,7 +543,7 @@
CREATE OR REPLACE FUNCTION portal_layout__add_region(
p_layout_id integer,
p_region varchar,
- p_immutable_p char -- default 'f'
+ p_immutable_p boolean default false
) RETURNS integer AS $$
DECLARE
@@ -560,36 +560,8 @@
---
--- procedure portal_layout__add_region/2
---
-CREATE OR REPLACE FUNCTION portal_layout__add_region(
- p_layout_id integer,
- p_region varchar
-) RETURNS integer AS $$
---
--- portal_layout__add_region/2 maybe obsolete, when we define proper defaults for /3
---
-DECLARE
-BEGIN
- insert
- into portal_supported_regions
- (layout_id, region, immutable_p)
- values
- (p_layout_id, p_region, 'f');
-
- return 0;
-END;
-$$ LANGUAGE plpgsql;
-
-
--- old define_function_args('portal_datasource__new','datasource_id,name,description,css_dir,object_type;portal_datasource,creation_date,creation_user,creation_ip,context_id')
--- new
select define_function_args('portal_datasource__new','datasource_id;null,name;null,description;null,css_dir,object_type;portal_datasource,creation_date;now(),creation_user;null,creation_ip;null,context_id;null');
-
-
-
--
-- procedure portal_datasource__new/9
--
@@ -759,8 +731,8 @@
--
CREATE OR REPLACE FUNCTION portal_datasource__set_def_param(
p_datasource_id integer,
- p_config_required_p varchar,
- p_configured_p varchar,
+ p_config_required_p boolean,
+ p_configured_p boolean,
p_key varchar,
p_value varchar
) RETURNS integer AS $$
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.6.8.1 -r1.6.8.2
--- openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql 2 Oct 2015 12:53:45 -0000 1.6.8.1
+++ openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql 14 May 2016 17:08:09 -0000 1.6.8.2
@@ -66,18 +66,14 @@
on delete cascade
constraint p_ds_def_prms_element_id_nn
not null,
- config_required_p char(1)
- default 'f'
+ config_required_p boolean
+ default false
constraint p_ds_def_prms_cfg_req_p_nn
- not null
- constraint p_ds_def_prms_cfg_req_p_ck
- check (config_required_p in ('t', 'f')),
- configured_p char(1)
- default 'f'
+ not null,
+ configured_p boolean
+ default false
constraint p_ds_def_prms_configured_p_nn
- not null
- constraint p_ds_def_prms_configured_p_ck
- check (configured_p in ('t', 'f')),
+ not null,
key varchar(200)
not null,
value varchar(200)
@@ -111,11 +107,9 @@
region varchar(20)
constraint p_spprtd_rgns_immtble_p_nn
not null,
- immutable_p char(1)
+ immutable_p boolean
constraint p_spprtd_rgns_immtble_p_nn
- not null
- constraint p_spprtd_rgns_immtble_p_ck
- check (immutable_p in ('t', 'f')),
+ not null,
constraint portal_supported_regions_pk
primary key (layout_id, region)
);
@@ -189,11 +183,10 @@
sort_key integer
constraint portal_pages_sort_key_nn
not null,
- hidden_p char(1)
- default 'f'
+ hidden_p boolean
+ default false
constraint portal_pages_hidden_p_nn
- not null
- check (hidden_p in ('t','f')),
+ not null,
constraint portal_pages_srt_key_un
unique (portal_id, sort_key)
);
@@ -257,18 +250,14 @@
on delete cascade
constraint p_element_prms_element_id_nn
not null,
- config_required_p char(1)
- default 'f'
+ config_required_p boolean
+ default false
constraint p_element_prms_cfg_req_p_nn
- not null
- constraint p_element_prms_cfg_req_p_ck
- check (config_required_p in ('t', 'f')),
- configured_p char(1)
- default 'f'
+ not null,
+ configured_p boolean
+ default false
constraint p_element_prms_configured_p_nn
- not null
- constraint p_element_prms_configured_p_ck
- check (configured_p in ('t', 'f')),
+ not null,
key varchar(50)
constraint p_element_prms_key_nn
not null,
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/new-portal/sql/postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql'.
Fisheye: No comparison available. Pass `N' to diff?