• last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Added this file to upgrade to changes made for Oracle 9i support

    • -0
    • +1762
    ./oracle/upgrade/upgrade-1.0-1.0d1.sql
  1. … 4 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

    • -1
    • +2
    ./oracle/admin-profile-provider-create.sql
    • -3
    • +3
    ./oracle/admin-profile-provider-drop.sql
    • -9
    • +9
    ./oracle/communities-package-create.sql
    • -29
    • +29
    ./oracle/community-memberships-packages-create.sql
    • -1
    • +2
    ./oracle/external-profile-provider-create.sql
    • -3
    • +3
    ./oracle/external-profile-provider-drop.sql
  1. … 75 more files in changeset.
using named parameters in call to acs_sc_impl.new to avoid mismatch with new optional pretty name parameter

  1. … 26 more files in changeset.
removing the admin role as it already exists in the acs-kernel now

merging dotlrn-1-0-1 tag down onto head. Thanks to Jarkko Laine and Mohan Pakkurti for all the help. See comments at http://openacs.org/storage/download/index?version_id=104101

    • -6
    • +6
    ./postgresql/communities-package-create.sql
  1. … 117 more files in changeset.
Removed unnecessary trigger drop/recreate (PG bug fixed in 7.2)

1. The externals group was pretty-named "Externals" rather than "External".

2. Date arithmetic issue for PG 7.3, switched to PG interval type

  1. … 1 more file in changeset.
A handful of various fixes, mostly for PG 7.3. Unfortunately I copied

over the fixed directory tree from my test instance here by mistake so

everything looks changed.

    • -6
    • +6
    ./postgresql/communities-package-create.sql
  1. … 9 more files in changeset.
merging the dotlrn-1-0 branch down onto HEAD (the trunk)

    • -0
    • +62
    ./postgresql/custom-permissions.sql
    • -24
    • +33
    ./postgresql/security-create.sql
  1. … 190 more files in changeset.
change because underscore proc only takes two arguments now, localizing more texts in UI, using message keys for the role names in the database

  1. … 22 more files in changeset.
I removed the composite index that checks for uniqueness of the community_type

and supertype pair. This index broke installation if the Oracle blocksize is

less than 8KB (which is true by default on at least some platforms).

The unique constraint was unnecessary since community_type was already declared as the

table's primary key. Because of this, only one row with a given community_type name

is possible, which means the composite key (community_type, supertype) is guaranteed

to be unique.

Removing the index will also speed community creation slightly, save a bit of

disk space, etc etc.

Note that the composite index was useless for lookups on the supertype alone

anyway (since community_type was the leftmost member of the composite key), and that

any queries on the type hierarchy ought to use the denormalized table defined

by acs-objects-metadata.sql anyway.

So the index seems entirely useless to me.

doh. forgot to remove the plsql function from the vars

move child create to before trigger recreate

sloan - adds dotlrn_spam_community perm, postgresql cleanup

    • -21
    • +32
    ./postgresql/security-create.sql
sloan - faster permission check dotlrn_community_admin_p

    • -0
    • +62
    ./postgresql/custom-permissions.sql
file custom-permissions.sql was initially added on branch dotlrn-1-0.

    • -0
    • +0
    ./oracle/custom-permissions.sql
    • -0
    • +0
    ./postgresql/custom-permissions.sql
rel_id->p_rel_id in function calls to ...rel__detete()

    • -4
    • +4
    ./postgresql/community-memberships-packages-create.sql
copyright OpenForce -> MIT

    • -2
    • +2
    ./oracle/admin-profile-provider-create.sql
    • -2
    • +2
    ./oracle/admin-profile-provider-drop.sql
  1. … 532 more files in changeset.
fixed but in dotlrn_admin_rel__delete

    • -10
    • +9
    ./postgresql/community-memberships-packages-create.sql
fixed order of define_function_args for dotlrn_community__new and also added default value of false for archived_p. also placed the define_function_args calls next to their plsql procs so it is easier to see when the parameter lists don't match.

    • -15
    • +16
    ./postgresql/communities-package-create.sql
fixed another typo in a member_rel_creation..

fixed a typo in a member_rel_creation..

added an operation to the dotlrn_applet service contract. the operation's name

is ChangeEventHandler and is usually implemented by change_event_handler

method in the dotlrn_applet implementation. dotLRN can throw events based on

changes to a community via the dotlrn_community::generate_change_event method.

currently the only event being thrown and handled is the 'rename' event. this

event is thrown when the name of a community is changed. the only applets that

currently listen for this event are dotlrn_fs, dotlrn_forums, and

dotlrn_calendar.

applets do not have to handle all events, only events they are interested in

handling.

we will add events on an as needed basis.

    • -145
    • +168
    ./oracle/applet-sc-create.sql
    • -204
    • +225
    ./postgresql/applet-sc-create.sql
  1. … 48 more files in changeset.
new users can be added as dotlrn_externals now

    • -2
    • +2
    ./postgresql/externals-package-create.sql
  1. … 2 more files in changeset.
added rel_type and segment_id columns to dotlrn_user_types table and

dotlrn_users view.

increase term_year col to 9

increase term_year lenght to 9

    • -0
    • +1
    ./oracle/upgrade/upgrade-july-25-2002.sql
    • -0
    • +27
    ./postgresql/upgrade/upgrade-july-25-2002.sql
fix for pg 7.1

    • -27
    • +33
    ./postgresql/security-create.sql
dotlrn.. it keeps going, and going..

    • -4
    • +4
    ./postgresql/communities-package-create.sql
    • -2
    • +2
    ./postgresql/community-memberships-packages-create.sql
  1. … 5 more files in changeset.
update info file. fix referential constraint in dotlrn_applets table.

  1. … 1 more file in changeset.