Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -r1.17 -r1.17.2.1
--- openacs-4/packages/acs-content-repository/acs-content-repository.info 23 Sep 2002 23:32:00 -0000 1.17
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info 29 Oct 2002 01:51:36 -0000 1.17.2.1
@@ -7,18 +7,18 @@
t
t
-
+
oracle
postgresql
- Dan Wickstrom
Karl Goldstein
+ Dan Wickstrom
A canonical repository for all OpenACS content.
- 2002-05-15
+ 2002-10-27
OpenACS
-
+
@@ -57,6 +57,7 @@
+
@@ -85,9 +86,11 @@
+
+
Fisheye: Tag 1.1.2.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/upgrade-4.5-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-4.5-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql,v
diff -u -r1.10 -r1.10.4.1
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql 9 Dec 2001 04:21:58 -0000 1.10
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql 29 Oct 2002 01:51:38 -0000 1.10.4.1
@@ -128,13 +128,12 @@
returns integer as '
declare
delete__keyword_id alias for $1;
- v_item_id integer;
v_rec record;
begin
for v_rec in select item_id from cr_item_keyword_map
where keyword_id = delete__keyword_id LOOP
- PERFORM content_keyword__item_unassign(v_item_id, delete__keyword_id);
+ PERFORM content_keyword__item_unassign(v_rec.item_id, delete__keyword_id);
end LOOP;
PERFORM acs_object__delete(delete__keyword_id);
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-4.5-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-events/acs-events.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/acs-events.info,v
diff -u -r1.4.2.1 -r1.4.2.2
--- openacs-4/packages/acs-events/acs-events.info 30 Sep 2002 16:03:07 -0000 1.4.2.1
+++ openacs-4/packages/acs-events/acs-events.info 29 Oct 2002 01:51:40 -0000 1.4.2.2
@@ -1,5 +1,5 @@
-
+
ACS Events
@@ -31,9 +31,9 @@
+
-
@@ -48,6 +48,7 @@
+
Index: openacs-4/packages/acs-events/sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/oracle/upgrade/upgrade-0.1d-0.2d.sql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/acs-events/sql/oracle/upgrade/upgrade-0.1d-0.2d.sql 6 Oct 2002 23:43:38 -0000 1.1
+++ openacs-4/packages/acs-events/sql/oracle/upgrade/upgrade-0.1d-0.2d.sql 29 Oct 2002 01:51:41 -0000 1.1.2.1
@@ -1,4 +1,6 @@
--- RBM: All this to replace one function - 2002-10-06
+-- @author Vinod Kurup (vinod@kurup.com)
+-- @creation-date 2002-10-27
+-- from a bug fix by Deds Castillo
create or replace package acs_event
as
@@ -401,21 +403,13 @@
begin
-- get the initial offsets
select start_date, end_date into v_one_start_date, v_one_end_date
- from time_intervals, timespans, acs_events
- where time_intervals.interval_id = timespans.interval_id
- and timespans.timespan_id = acs_events.timespan_id
- and event_id= recurrence_timespan_edit.event_id;
+ from time_intervals, timespans, acs_events
+ where time_intervals.interval_id = timespans.interval_id and
+ timespans.timespan_id = acs_events.timespan_id and
+ event_id= recurrence_timespan_edit.event_id;
- -- RBM: Converted inneficient query to INNER JOINs (2002-10-06)
- -- (select * from time_intervals where interval_id in (select interval_id from timespans where timespan_id in (select timespan_id from acs_events where recurrence_id = (select recurrence_id from acs_events where event_id = recurrence_timespan_edit.event_id))))
-
- FOR v_timespan in
- SELECT ti.*
- FROM time_intervals ti, timespans t, acs_events ae
- WHERE ti.interval_id = t.interval_id
- AND t.timespan_id = ae.timespan_id
- AND ae.event_id = recurrence_timespan_edit.event_id
-
+ for v_timespan in
+ (select * from time_intervals where interval_id in (select interval_id from timespans where timespan_id in (select timespan_id from acs_events where recurrence_id = (select recurrence_id from acs_events where event_id = recurrence_timespan_edit.event_id))))
LOOP
time_interval.edit(v_timespan.interval_id, v_timespan.start_date + (start_date - v_one_start_date), v_timespan.end_date + (end_date - v_one_end_date));
END LOOP;
Index: openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql 19 Aug 2002 19:55:40 -0000 1.1
+++ openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql 29 Oct 2002 01:51:42 -0000 1.1.2.1
@@ -1,9 +1,7 @@
-- created by arjun@openforce.net
-- from a bug fix by Deds Castillo
-drop function acs_event__recurrence_timespan_edit;
-
-create function acs_event__recurrence_timespan_edit (
+create or replace function acs_event__recurrence_timespan_edit (
integer,
timestamp,
timestamp
@@ -45,3 +43,34 @@
return p_event_id;
END;
' language 'plpgsql';
+
+
+-- to_interval() now returns 'timespan' not 'interval'
+
+create or replace function to_interval (
+ --
+ -- Convert an integer to the specified interval
+ --
+ -- Utility function so we do not have to remember how to escape
+ -- double quotes when we typecast an integer to an interval
+ --
+ -- @author jowell@jsabino.com
+ --
+ -- @param interval_number Integer to convert to interval
+ -- @param interval_units Interval units
+ --
+ -- @return interval equivalent of interval_number, in interval_units units
+ --
+ integer,
+ varchar
+)
+returns timespan as '
+declare
+ interval__number alias for $1;
+ interval__units alias for $2;
+begin
+
+ -- We should probably do unit checking at some point
+ return ('''''''' || interval__number || '' '' || interval__units || '''''''')::timespan;
+
+end;' language 'plpgsql';
Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -r1.17.2.1 -r1.17.2.2
--- openacs-4/packages/acs-kernel/acs-kernel.info 30 Sep 2002 19:01:02 -0000 1.17.2.1
+++ openacs-4/packages/acs-kernel/acs-kernel.info 29 Oct 2002 01:51:43 -0000 1.17.2.2
@@ -7,17 +7,17 @@
t
t
-
+
oracle
postgresql
Don Baccus
Routines and data models providing the foundation for OpenACS-based Web services.
- 2002-08-17
+ 2002-10-27
OpenACS
-
+
@@ -82,6 +82,7 @@
+
@@ -137,6 +138,7 @@
+
@@ -149,45 +151,45 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql 17 Aug 2002 17:42:45 -0000 1.1
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql 29 Oct 2002 01:51:44 -0000 1.1.2.1
@@ -715,6 +715,448 @@
show errors
+-- new function apm_package.parent_id
+
+create or replace package apm_package
+as
+
+function new (
+ package_id in apm_packages.package_id%TYPE
+ default null,
+ instance_name in apm_packages.instance_name%TYPE
+ default null,
+ package_key in apm_packages.package_key%TYPE,
+ object_type in acs_objects.object_type%TYPE
+ default 'apm_package',
+ creation_date in acs_objects.creation_date%TYPE
+ default sysdate,
+ creation_user in acs_objects.creation_user%TYPE
+ default null,
+ creation_ip in acs_objects.creation_ip%TYPE
+ default null,
+ context_id in acs_objects.context_id%TYPE
+ default null
+ ) return apm_packages.package_id%TYPE;
+
+ procedure delete (
+ package_id in apm_packages.package_id%TYPE
+ );
+
+ function initial_install_p (
+ package_key in apm_packages.package_key%TYPE
+ ) return integer;
+
+ function singleton_p (
+ package_key in apm_packages.package_key%TYPE
+ ) return integer;
+
+ function num_instances (
+ package_key in apm_package_types.package_key%TYPE
+ ) return integer;
+
+ function name (
+ package_id in apm_packages.package_id%TYPE
+ ) return varchar2;
+
+ -- Enable a package to be utilized by a subsite.
+ procedure enable (
+ package_id in apm_packages.package_id%TYPE
+ );
+
+ procedure disable (
+ package_id in apm_packages.package_id%TYPE
+ );
+
+ function highest_version (
+ package_key in apm_package_types.package_key%TYPE
+ ) return apm_package_versions.version_id%TYPE;
+
+ function parent_id (
+ package_id in apm_packages.package_id%TYPE
+ ) return apm_packages.package_id%TYPE;
+
+end apm_package;
+/
+show errors
+
+create or replace package body apm_package
+as
+ procedure initialize_parameters (
+ package_id in apm_packages.package_id%TYPE,
+ package_key in apm_package_types.package_key%TYPE
+ )
+ is
+ v_value_id apm_parameter_values.value_id%TYPE;
+ cursor cur is
+ select parameter_id, default_value
+ from apm_parameters
+ where package_key = initialize_parameters.package_key;
+ begin
+ -- need to initialize all params for this type
+ for cur_val in cur
+ loop
+ v_value_id := apm_parameter_value.new(
+ package_id => initialize_parameters.package_id,
+ parameter_id => cur_val.parameter_id,
+ attr_value => cur_val.default_value
+ );
+ end loop;
+ end initialize_parameters;
+
+ function new (
+ package_id in apm_packages.package_id%TYPE
+ default null,
+ instance_name in apm_packages.instance_name%TYPE
+ default null,
+ package_key in apm_packages.package_key%TYPE,
+ object_type in acs_objects.object_type%TYPE
+ default 'apm_package',
+ creation_date in acs_objects.creation_date%TYPE
+ default sysdate,
+ creation_user in acs_objects.creation_user%TYPE
+ default null,
+ creation_ip in acs_objects.creation_ip%TYPE
+ default null,
+ context_id in acs_objects.context_id%TYPE
+ default null
+ ) return apm_packages.package_id%TYPE
+ is
+ v_singleton_p integer;
+ v_package_type apm_package_types.package_type%TYPE;
+ v_num_instances integer;
+ v_package_id apm_packages.package_id%TYPE;
+ v_instance_name apm_packages.instance_name%TYPE;
+ begin
+ v_singleton_p := apm_package.singleton_p(
+ package_key => apm_package.new.package_key
+ );
+ v_num_instances := apm_package.num_instances(
+ package_key => apm_package.new.package_key
+ );
+
+ if v_singleton_p = 1 and v_num_instances >= 1 then
+ select package_id into v_package_id
+ from apm_packages
+ where package_key = apm_package.new.package_key;
+ return v_package_id;
+ else
+ v_package_id := acs_object.new(
+ object_id => package_id,
+ object_type => object_type,
+ creation_date => creation_date,
+ creation_user => creation_user,
+ creation_ip => creation_ip,
+ context_id => context_id
+ );
+ if instance_name is null then
+ v_instance_name := package_key || ' ' || v_package_id;
+ else
+ v_instance_name := instance_name;
+ end if;
+
+ select package_type into v_package_type
+ from apm_package_types
+ where package_key = apm_package.new.package_key;
+
+ insert into apm_packages
+ (package_id, package_key, instance_name)
+ values
+ (v_package_id, package_key, v_instance_name);
+
+ if v_package_type = 'apm_application' then
+ insert into apm_applications
+ (application_id)
+ values
+ (v_package_id);
+ else
+ insert into apm_services
+ (service_id)
+ values
+ (v_package_id);
+ end if;
+
+ initialize_parameters(
+ package_id => v_package_id,
+ package_key => apm_package.new.package_key
+ );
+ return v_package_id;
+
+ end if;
+end new;
+
+ procedure delete (
+ package_id in apm_packages.package_id%TYPE
+ )
+ is
+ cursor all_values is
+ select value_id from apm_parameter_values
+ where package_id = apm_package.delete.package_id;
+ cursor all_site_nodes is
+ select node_id from site_nodes
+ where object_id = apm_package.delete.package_id;
+ begin
+ -- Delete all parameters.
+ for cur_val in all_values loop
+ apm_parameter_value.delete(value_id => cur_val.value_id);
+ end loop;
+ delete from apm_applications where application_id = apm_package.delete.package_id;
+ delete from apm_services where service_id = apm_package.delete.package_id;
+ delete from apm_packages where package_id = apm_package.delete.package_id;
+ -- Delete the site nodes for the objects.
+ for cur_val in all_site_nodes loop
+ site_node.delete(cur_val.node_id);
+ end loop;
+ -- Delete the object.
+ acs_object.delete (
+ object_id => package_id
+ );
+ end delete;
+
+ function initial_install_p (
+ package_key in apm_packages.package_key%TYPE
+ ) return integer
+ is
+ v_initial_install_p integer;
+ begin
+ select 1 into v_initial_install_p
+ from apm_package_types
+ where package_key = initial_install_p.package_key
+ and initial_install_p = 't';
+ return v_initial_install_p;
+
+ exception
+ when NO_DATA_FOUND
+ then
+ return 0;
+ end initial_install_p;
+
+ function singleton_p (
+ package_key in apm_packages.package_key%TYPE
+ ) return integer
+ is
+ v_singleton_p integer;
+ begin
+ select 1 into v_singleton_p
+ from apm_package_types
+ where package_key = singleton_p.package_key
+ and singleton_p = 't';
+ return v_singleton_p;
+
+ exception
+ when NO_DATA_FOUND
+ then
+ return 0;
+ end singleton_p;
+
+ function num_instances (
+ package_key in apm_package_types.package_key%TYPE
+ ) return integer
+ is
+ v_num_instances integer;
+ begin
+ select count(*) into v_num_instances
+ from apm_packages
+ where package_key = num_instances.package_key;
+ return v_num_instances;
+
+ exception
+ when NO_DATA_FOUND
+ then
+ return 0;
+ end num_instances;
+
+ function name (
+ package_id in apm_packages.package_id%TYPE
+ ) return varchar2
+ is
+ v_result apm_packages.instance_name%TYPE;
+ begin
+ select instance_name into v_result
+ from apm_packages
+ where package_id = name.package_id;
+
+ return v_result;
+ end name;
+
+ procedure enable (
+ package_id in apm_packages.package_id%TYPE
+ )
+ is
+ begin
+ update apm_packages
+ set enabled_p = 't'
+ where package_id = enable.package_id;
+ end enable;
+
+ procedure disable (
+ package_id in apm_packages.package_id%TYPE
+ )
+ is
+ begin
+ update apm_packages
+ set enabled_p = 'f'
+ where package_id = disable.package_id;
+ end disable;
+
+ function highest_version (
+ package_key in apm_package_types.package_key%TYPE
+ ) return apm_package_versions.version_id%TYPE
+ is
+ v_version_id apm_package_versions.version_id%TYPE;
+ begin
+ select version_id into v_version_id
+ from apm_package_version_info i
+ where apm_package_version.sortable_version_name(version_name) =
+ (select max(apm_package_version.sortable_version_name(v.version_name))
+ from apm_package_version_info v where v.package_key = highest_version.package_key)
+ and package_key = highest_version.package_key;
+ return v_version_id;
+ exception
+ when NO_DATA_FOUND
+ then
+ return 0;
+ end highest_version;
+
+ function parent_id (
+ package_id in apm_packages.package_id%TYPE
+ ) return apm_packages.package_id%TYPE
+ is
+ v_package_id apm_packages.package_id%TYPE;
+ begin
+ select sn1.object_id
+ into v_package_id
+ from site_nodes sn1
+ where sn1.node_id = (select sn2.parent_id
+ from site_nodes sn2
+ where sn2.object_id = apm_package.parent_id.package_id);
+
+ return v_package_id;
+
+ exception when NO_DATA_FOUND then
+ return -1;
+ end parent_id;
+
+end apm_package;
+/
+show errors
+
+
-- acs-permissions-create.sql
+create or replace package body acs_permission
+as
+ procedure grant_permission (
+ object_id acs_permissions.object_id%TYPE,
+ grantee_id acs_permissions.grantee_id%TYPE,
+ privilege acs_permissions.privilege%TYPE
+ )
+ as
+ begin
+ insert into acs_permissions
+ (object_id, grantee_id, privilege)
+ values
+ (object_id, grantee_id, privilege);
+ exception
+ when dup_val_on_index then
+ return;
+ end grant_permission;
+ --
+ procedure revoke_permission (
+ object_id acs_permissions.object_id%TYPE,
+ grantee_id acs_permissions.grantee_id%TYPE,
+ privilege acs_permissions.privilege%TYPE
+ )
+ as
+ begin
+ delete from acs_permissions
+ where object_id = revoke_permission.object_id
+ and grantee_id = revoke_permission.grantee_id
+ and privilege = revoke_permission.privilege;
+ end revoke_permission;
+ function permission_p (
+ object_id acs_objects.object_id%TYPE,
+ party_id parties.party_id%TYPE,
+ privilege acs_privileges.privilege%TYPE
+ ) return char
+ as
+ exists_p char(1);
+ begin
+ --
+ -- direct permissions
+ select decode(count(*),0,'f','t') into exists_p
+ from dual where exists (
+ select 'x'
+ from acs_object_grantee_priv_map
+ where object_id = permission_p.object_id
+ and grantee_id = permission_p.party_id
+ and privilege = permission_p.privilege);
+ if exists_p = 't' then
+ return 't';
+ end if;
+ --
+ -- public-like permissions
+ select decode(count(*),0,'f','t') into exists_p
+ from dual where exists (
+ select 'x'
+ from acs_object_grantee_priv_map
+ where object_id = permission_p.object_id
+ and 0 = permission_p.party_id
+ and privilege = permission_p.privilege
+ and grantee_id = -1);
+ if exists_p = 't' then
+ return 't';
+ end if;
+ --
+ -- public permissions
+ select decode(count(*),0,'f','t') into exists_p
+ from dual where exists (
+ select 'x'
+ from acs_object_grantee_priv_map m, users u
+ where object_id = permission_p.object_id
+ and u.user_id = permission_p.party_id
+ and privilege = permission_p.privilege
+ and m.grantee_id = -1);
+ if exists_p = 't' then
+ return 't';
+ end if;
+ --
+ -- group permmissions
+ select decode(count(*),0,'f','t') into exists_p
+ from dual where exists (
+ select 'x'
+ from acs_object_grantee_priv_map ogpm,
+ group_approved_member_map gmm
+ where object_id = permission_p.object_id
+ and gmm.member_id = permission_p.party_id
+ and privilege = permission_p.privilege
+ and ogpm.grantee_id = gmm.group_id);
+ if exists_p = 't' then
+ return 't';
+ end if;
+ --
+ -- relational segment approved group
+ select decode(count(*),0,'f','t') into exists_p
+ from dual where exists (
+ select 'x'
+ from acs_object_grantee_priv_map ogpm,
+ rel_seg_approved_member_map rsmm
+ where object_id = permission_p.object_id
+ and rsmm.member_id = permission_p.party_id
+ and privilege = permission_p.privilege
+ and ogpm.grantee_id = rsmm.segment_id);
+ if exists_p = 't' then
+ return 't';
+ end if;
+ return exists_p;
+ end;
+ --
+end acs_permission;
+/
+show errors
+
+-- add indices (yon)
+
+create index users_email_verified_idx on users (email_verified_p);
+create index member_rels_member_state_idx on membership_rels (member_state);
+create index site_nodes_parent_id_idx on site_nodes(parent_id,object_id,node_id);
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5.1-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v
diff -u -r1.29 -r1.29.2.1
--- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 23 Sep 2002 11:05:17 -0000 1.29
+++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 29 Oct 2002 01:51:45 -0000 1.29.2.1
@@ -1881,7 +1881,7 @@
v_version_id apm_package_versions.version_id%TYPE;
begin
if apm_pkg_ver__version_id = '''' or apm_pkg_ver__version_id is null then
- select acs_object_id_seq.nextval
+ select nextval(''t_acs_object_id_seq'')
into v_version_id
from dual;
else
@@ -1993,12 +1993,12 @@
where version_id = copy__version_id;
insert into apm_package_dependencies(dependency_id, version_id, dependency_type, service_uri, service_version)
- select acs_object_id_seq.nextval, v_version_id, dependency_type, service_uri, service_version
+ select nextval(''t_acs_object_id_seq''), v_version_id, dependency_type, service_uri, service_version
from apm_package_dependencies
where version_id = copy__version_id;
insert into apm_package_files(file_id, version_id, path, file_type, db_type)
- select acs_object_id_seq.nextval, v_version_id, path, file_type, db_type
+ select nextval(''t_acs_object_id_seq''), v_version_id, path, file_type, db_type
from apm_package_files
where version_id = copy__version_id;
@@ -2086,7 +2086,7 @@
if NOT FOUND
then
if add_file__file_id is null then
- select acs_object_id_seq.nextval into v_file_id from dual;
+ select nextval(''t_acs_object_id_seq'') into v_file_id from dual;
else
v_file_id := add_file__file_id;
end if;
@@ -2128,7 +2128,7 @@
v_dep_id apm_package_dependencies.dependency_id%TYPE;
begin
if add_interface__interface_id is null then
- select acs_object_id_seq.nextval into v_dep_id from dual;
+ select nextval(''t_acs_object_id_seq'') into v_dep_id from dual;
else
v_dep_id := add_interface__interface_id;
end if;
@@ -2186,7 +2186,7 @@
v_dep_id apm_package_dependencies.dependency_id%TYPE;
begin
if add_dependency__dependency_id is null then
- select acs_object_id_seq.nextval into v_dep_id from dual;
+ select nextval(''t_acs_object_id_seq'') into v_dep_id from dual;
else
v_dep_id := add_dependency__dependency_id;
end if;
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.5.1-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-mail/acs-mail.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/acs-mail.info,v
diff -u -r1.8 -r1.8.2.1
--- openacs-4/packages/acs-mail/acs-mail.info 3 Aug 2002 17:52:16 -0000 1.8
+++ openacs-4/packages/acs-mail/acs-mail.info 29 Oct 2002 01:51:47 -0000 1.8.2.1
@@ -7,19 +7,19 @@
t
t
-
+
oracle
postgresql
- John Prevost
Vinod Kurup
+ John Prevost
General messaging system, mark II
- 2002-05-15
+ 2002-10-27
OpenACS
Provides generic message services, with email sending.
-
+
@@ -33,12 +33,14 @@
+
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.5-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.5-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-service-contract/acs-service-contract.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/acs-service-contract.info,v
diff -u -r1.8 -r1.8.2.1
--- openacs-4/packages/acs-service-contract/acs-service-contract.info 17 Aug 2002 17:42:45 -0000 1.8
+++ openacs-4/packages/acs-service-contract/acs-service-contract.info 29 Oct 2002 01:51:51 -0000 1.8.2.1
@@ -7,18 +7,18 @@
t
t
-
+
oracle
postgresql
- Kapil Thangavelu
Neophytos Demetriou
+ Kapil Thangavelu
Allows different packages to communicate via defined contracts
- 2002-08-17
+ 2002-10-27
OpenACS
-
+
@@ -37,6 +37,7 @@
+
@@ -51,6 +52,7 @@
+
@@ -61,6 +63,8 @@
+
+
Index: openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql 20 Aug 2002 21:05:04 -0000 1.2
+++ openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql 29 Oct 2002 01:51:52 -0000 1.2.2.1
@@ -221,7 +221,7 @@
show errors
-- UPGRADE ISSUE 2
--- acs_sc_binding.exists_p was broken on Oracle if you installed
+-- acs_sc_binding.exists_p was broken on Oracle if you
-- tested a binding for which the implementation was installed, but the
-- contract wasn't.
@@ -336,3 +336,4 @@
end acs_sc_binding;
/
show errors
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5.1-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-service-contract/sql/postgresql/upgrade/upgrade-4.5.1-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/bookmarks/bookmarks.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/bookmarks.info,v
diff -u -r1.21 -r1.21.4.1
--- openacs-4/packages/bookmarks/bookmarks.info 13 Sep 2001 20:27:19 -0000 1.21
+++ openacs-4/packages/bookmarks/bookmarks.info 29 Oct 2002 01:51:55 -0000 1.21.4.1
@@ -1,43 +1,43 @@
-
+
Bookmarks
Bookmarks Modules
f
f
-
+
oracle
postgresql
Peter Marklund
This module lets you manage your bookmarks on the web and enables sharing of bookmarks between people in a community (one ACS installation).
- 2001-02-23
+ 2002-10-27
ArsDigita Corporation
- This version contains a number of bugfixes and minor improvements over the 4.X alpha versions and has been rigorously tested.
-
-New features in the ACS4 (not in the ACS4 version) include:
-
-- Adding bookmarks when browsing with the help of a Bookmarklet (a Bookmark in the browser that contains Javascript instead of a url).
-
-- Sorting by name and access date
-
-- Enhanced access permissions. The alpha version will only include toggling between private and public. Future versions could use the ACS permission API to grant read, write, delete and admin rights to any party on a bookmark level. It is not yet clear how big the need for this granular access permissions is.
-
-- Display of keywords and descriptions of urls (fetched with ns_httpget)
-
-Important features from the ACS3 version are:
-
-- Bookmarks are viewed in a tree structure with open/collapse functionality of folders. Alternatively the bookmarks can be viewed in a Javascript version.
-
-- Importing/exporting bookmarks from/to Netscape and IE browsers
-
-- Checking if URLs are alive
-
-- Display of the most popular hosts and urls in the community
-
+ This version contains a number of bugfixes and minor improvements over the 4.X alpha versions and has been rigorously tested.
+
+New features in the ACS4 (not in the ACS4 version) include:
+
+- Adding bookmarks when browsing with the help of a Bookmarklet (a Bookmark in the browser that contains Javascript instead of a url).
+
+- Sorting by name and access date
+
+- Enhanced access permissions. The alpha version will only include toggling between private and public. Future versions could use the ACS permission API to grant read, write, delete and admin rights to any party on a bookmark level. It is not yet clear how big the need for this granular access permissions is.
+
+- Display of keywords and descriptions of urls (fetched with ns_httpget)
+
+Important features from the ACS3 version are:
+
+- Bookmarks are viewed in a tree structure with open/collapse functionality of folders. Alternatively the bookmarks can be viewed in a Javascript version.
+
+- Importing/exporting bookmarks from/to Netscape and IE browsers
+
+- Checking if URLs are alive
+
+- Display of the most popular hosts and urls in the community
+
Areas that need improvement: The query on the index page is a bit slow - closing and opening folders becomes impractible with for example 200 bookmarks. Users who have this many bookmarks can preferably use the Javascript version.
@@ -48,6 +48,7 @@
+
@@ -60,8 +61,6 @@
-
-
@@ -179,10 +178,10 @@
-
-
-
+
+
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/bookmarks/sql/postgresql/upgrade/upgrade-4.1.1b-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/faq/faq.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/faq.info,v
diff -u -r1.5 -r1.5.2.1
--- openacs-4/packages/faq/faq.info 17 Jul 2002 20:20:17 -0000 1.5
+++ openacs-4/packages/faq/faq.info 29 Oct 2002 01:51:59 -0000 1.5.2.1
@@ -7,15 +7,15 @@
f
f
-
+
oracle
postgresql
- Elizabeth Wirth
Jennie Kim Housman
+ Elizabeth Wirth
Port of FAQ module from 3.4 with a few enhancements.
- 2001-03-15
+ 2002-10-27
Ybos Corporation
@@ -25,6 +25,7 @@
+
@@ -40,7 +41,6 @@
-
@@ -57,7 +57,6 @@
-
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/faq/sql/oracle/upgrade/upgrade-4.0-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/file-storage/file-storage.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/file-storage.info,v
diff -u -r1.17 -r1.17.2.1
--- openacs-4/packages/file-storage/file-storage.info 17 Sep 2002 21:03:22 -0000 1.17
+++ openacs-4/packages/file-storage/file-storage.info 29 Oct 2002 01:52:03 -0000 1.17.2.1
@@ -7,18 +7,18 @@
f
f
-
+
oracle
postgresql
Jowell S. Sabino
This application allows users to collaboratively maintain documents on the web server
- 2000-12-29
+ 2002-10-27
OpenACS
Now allows storage of files on the filesystem or database.
-
+
@@ -32,6 +32,7 @@
+
@@ -41,6 +42,7 @@
+
@@ -120,8 +122,6 @@
-
-
@@ -152,11 +152,11 @@
-
-
-
-
+
+
+
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-4.2-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-4.2-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/news/news.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/news.info,v
diff -u -r1.6 -r1.6.2.1
--- openacs-4/packages/news/news.info 31 May 2002 12:50:14 -0000 1.6
+++ openacs-4/packages/news/news.info 29 Oct 2002 01:52:06 -0000 1.6.2.1
@@ -7,19 +7,19 @@
f
f
-
+
oracle
postgresql
Stefan Deusch
News application
- 2001-03-07
- ArsDigita Corporation
- News publication tool for corporate and website news in HTML and plain text format.
+ 2002-10-27
+ OpenACS
+ News publication tool for corporate and website news in HTML and plain text format.
Beta release.
-
+
@@ -32,10 +32,12 @@
+
+
@@ -55,7 +57,6 @@
-
@@ -103,19 +104,18 @@
-
-
-
-
-
-
+
+
+
+
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/news/sql/oracle/upgrade/upgrade-4.1.0b-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/news/sql/postgresql/upgrade/upgrade-4.1.0b-4.6.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/search/search.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/search.info,v
diff -u -r1.6 -r1.6.2.1
--- openacs-4/packages/search/search.info 23 Sep 2002 23:32:32 -0000 1.6
+++ openacs-4/packages/search/search.info 29 Oct 2002 01:52:10 -0000 1.6.2.1
@@ -7,16 +7,16 @@
t
f
-
+
oracle
postgresql
Neophytos Demetriou
- 2002-05-15
+ 2002-10-27
OpenACS
-
+
@@ -30,13 +30,13 @@
-
+
@@ -45,6 +45,7 @@
+
@@ -53,14 +54,13 @@
-
-
-
-
-
+
+
+
+