Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-admins-package-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-admins-package-drop.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-admins-package-drop.sql 2 Jul 2002 18:40:08 -0000 1.3 +++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-admins-package-drop.sql 5 Jul 2002 15:26:25 -0000 1.4 @@ -21,5 +21,4 @@ -- @version $Id$ -- -select drop_package('dotlrn_full_admin_profile_rel'); select drop_package('dotlrn_admin_profile_rel'); Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-admins-sanitize.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-admins-sanitize.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-admins-sanitize.sql 2 Jul 2002 18:40:08 -0000 1.3 +++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-admins-sanitize.sql 5 Jul 2002 15:26:25 -0000 1.4 @@ -78,7 +78,7 @@ foo ); - acs_rel_type__drop_type( + perform acs_rel_type__drop_type( ''dotlrn_admin_profile_rel'', ''t'' ); Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-class-membership-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-class-membership-drop.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-class-membership-drop.sql 3 Jul 2002 19:58:07 -0000 1.2 +++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-class-membership-drop.sql 5 Jul 2002 15:26:25 -0000 1.3 @@ -28,27 +28,27 @@ returns integer as ' begin - select acs_rel_type__drop_type ( + perform acs_rel_type__drop_type ( ''dotlrn_student_rel'', ''t'' ); - select acs_rel_type__drop_type ( + perform acs_rel_type__drop_type ( ''dotlrn_ta_rel'', ''t'' ); - select acs_rel_type__drop_type ( + perform acs_rel_type__drop_type ( ''dotlrn_ca_rel'', ''t'' ); - select acs_rel_type__drop_type ( + perform acs_rel_type__drop_type ( ''dotlrn_cadmin_rel'', ''t'' ); - select acs_rel_type__drop_type ( + perform acs_rel_type__drop_type ( ''dotlrn_instructor_rel'', ''t'' ); @@ -57,7 +57,7 @@ end;' language 'plpgsql'; -select function inline_0(); +select inline_0(); drop function inline_0(); drop view dotlrn_instructor_rels_full; Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-communities-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-communities-package-create.sql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-communities-package-create.sql 3 Jul 2002 19:58:07 -0000 1.4 +++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-communities-package-create.sql 5 Jul 2002 15:26:25 -0000 1.5 @@ -132,7 +132,7 @@ from dotlrn_community_types where community_type = p_community_type; - PERFORM acs_object_type__drop_type(p_community_type); + PERFORM acs_object_type__drop_type(p_community_type, ''f''); return 0; END; ' language 'plpgsql'; Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-professors-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-professors-drop.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-professors-drop.sql 2 Jul 2002 18:40:08 -0000 1.3 +++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-professors-drop.sql 5 Jul 2002 15:26:25 -0000 1.4 @@ -26,5 +26,5 @@ \i dotlrn-professors-sanitize.sql \i dotlrn-professor-profile-provider-drop.sql -drop table dotlrn_full_prof_profile_rels; +drop table dotlrn_full_professor_profile_rels; drop table dotlrn_professor_profile_rels; Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-security-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-security-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-security-drop.sql 5 Jul 2002 15:26:25 -0000 1.1 @@ -0,0 +1,68 @@ +-- +-- Copyright (C) 2001, 2002 OpenForce, Inc. +-- +-- This file is part of dotLRN. +-- +-- dotLRN is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. See the GNU General Public License for more +-- details. +-- + +-- +-- drop dotLRN permissions +-- +-- @author Ben Adida (ben@openforce.net) +-- @author dan chak (chak@openforce.net) +-- @creation-date 2001-11-28 +-- ported 2002-07-01 +-- @version $Id: dotlrn-security-drop.sql,v 1.1 2002/07/05 15:26:25 chak Exp $ +-- + +create function inline0() +returns integer as ' +begin + + perform acs_privilege__remove_child(''admin'', ''dotlrn_admin_community''); + perform acs_privilege__remove_child(''admin'', ''dotlrn_admin_community_type''); + perform acs_privilege__remove_child(''admin'', ''dotlrn_browse''); + perform acs_privilege__remove_child(''create'', ''dotlrn_create_community''); + perform acs_privilege__remove_child(''create'', ''dotlrn_create_community_type''); + perform acs_privilege__remove_child(''read'', ''dotlrn_view_community''); + perform acs_privilege__remove_child(''read'', ''dotlrn_view_community_type''); + perform acs_privilege__remove_child(''write'', ''dotlrn_edit_community''); + + perform acs_privilege__remove_child(''dotlrn_edit_community'', ''dotlrn_view_community''); + perform acs_privilege__remove_child(''dotlrn_admin_community'', ''dotlrn_edit_community''); + + delete + from acs_permissions + where privilege in (''dotlrn_admin_community'', + ''dotlrn_admin_community_type'', + ''dotlrn_browse'', + ''dotlrn_create_community'', + ''dotlrn_create_community_type'', + ''dotlrn_edit_community'', + ''dotlrn_view_community'', + ''dotlrn_view_community_type''); + + perform acs_privilege__drop_privilege(''dotlrn_admin_community''); + perform acs_privilege__drop_privilege(''dotlrn_admin_community_type''); + perform acs_privilege__drop_privilege(''dotlrn_browse''); + perform acs_privilege__drop_privilege(''dotlrn_create_community''); + perform acs_privilege__drop_privilege(''dotlrn_create_community_type''); + perform acs_privilege__drop_privilege(''dotlrn_edit_community''); + perform acs_privilege__drop_privilege(''dotlrn_view_community''); + perform acs_privilege__drop_privilege(''dotlrn_view_community_type''); + + return 0; + +end;' language 'plpgsql'; + +select inline0(); +drop function inline0(); Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/sql/postgresql/dotlrn-security.drop.sql'. Fisheye: No comparison available. Pass `N' to diff?