• last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
We cannot create the local authority in authentication-procs, because acs_magic_objects isn't defined until acs-create.sql, and is referenced by a trigger on acs-objects.

    • -13
    • +1
    ./sql/oracle/authentication-create.sql
    • -20
    • +1
    ./sql/postgresql/authentication-create.sql
fixing broken installation: changing service contract implementation id columns in the auth_authorities table to reference acs_objects instead of acs_sc_impls table as the latter table is created later

    • -4
    • +5
    ./sql/oracle/authentication-create.sql
    • -4
    • +5
    ./sql/postgresql/authentication-create.sql
Support for external authentication: two new columns added to users table - username and authority. New object type authority with corresponding table auth_authorities. Bumping version number to 5.0d3

    • -0
    • +95
    ./sql/oracle/authentication-create.sql
    • -0
    • +28
    ./sql/oracle/authentication-drop.sql
    • -0
    • +93
    ./sql/oracle/authentication-package-create.sql
    • -0
    • +6
    ./sql/oracle/authentication-package-drop.sql
    • -5
    • +15
    ./sql/oracle/community-core-create.sql
    • -0
    • +215
    ./sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -0
    • +1
    ./sql/postgresql/acs-kernel-create.sql
    • -0
    • +97
    ./sql/postgresql/authentication-create.sql
    • -0
    • +32
    ./sql/postgresql/authentication-drop.sql
    • -0
    • +85
    ./sql/postgresql/authentication-package-create.sql
    • -0
    • +25
    ./sql/postgresql/authentication-package-drop.sql
    • -19
    • +29
    ./sql/postgresql/community-core-create.sql
    • -0
    • +204
    ./sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
adding locale and timezone to user_preferences table. Adding default_locale to apm_packages table

    • -2
    • +4
    ./sql/oracle/community-core-create.sql
    • -0
    • +11
    ./sql/oracle/upgrade/upgrade-5.0d-5.0d2.sql
    • -1
    • +3
    ./sql/postgresql/community-core-create.sql
    • -0
    • +23
    ./sql/postgresql/upgrade/upgrade-4.7.2d-5.0d.sql
    • -0
    • +11
    ./sql/postgresql/upgrade/upgrade-5.0d-5.0d2.sql
removed what looks like a copy-and-pase mistake at the end of the script

    • -2
    • +1
    ./sql/oracle/acs-permissions-create.sql
"Registered users" had a join policy of "open", which meant a user could

visit the join group registration page manually and turn user_id 0 (the

public) into a registered user. Bad ...

Decided that assuming SQL data files are CSV-formatted files is a bad idea

after running into a package that embeds comments in its data! Changed

from .csv to .dat and all that implies. Still more testing to do...

  1. … 30 more files in changeset.
Added code to allow loading of data for packages like ref-timezones with

SQL*Loader or PostgreSQL's COPY command.

  1. … 4 more files in changeset.
Fixed typo oops!

Added csv_data as a package file type ...

    • -0
    • +1
    ./sql/oracle/upgrade/upgrade-4.7.2d-5.0d.sql
    • -0
    • +1
    ./sql/postgresql/upgrade/upgrade-4.7.2d-5.0d.sql
1. removed some errant log statemets previously inserted when debugging

2. sql/common/*sql files weren't being displayed by the APM, are now

3. added index on start_date in timespan-create after user reported

very slow calendar queries in .LRN

    • -65
    • +0
    ./sql/postgresql/utilities-create.sql
  1. … 7 more files in changeset.
1. Made object_id 0 be a user instead of a person;

2. Created a rel_type 'admin_rel' and corresponding role 'admin'.

    • -1
    • +48
    ./sql/oracle/groups-body-create.sql
    • -0
    • +121
    ./sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql
    • -0
    • +67
    ./sql/postgresql/groups-body-create.sql
    • -15
    • +45
    ./sql/postgresql/groups-create.sql
    • -0
    • +114
    ./sql/postgresql/upgrade/upgrade-4.6.5-4.6.6.sql
file upgrade-4.6.5-4.6.6.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6.5-4.6.6.sql
committing all translations on the translation server at http://translate.dotlrn.collaboraid.net

    • -1
    • +1
    ./catalog/acs-kernel.ast_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.es_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.fi_FI.ISO-8859-15.xml
    • -1
    • +1
    ./catalog/acs-kernel.fr_FR.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.gl_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.ja_JP.Shift_JIS.xml
    • -0
    • +7
    ./catalog/acs-kernel.ko_KR.EUC-KR.xml
    • -0
    • +7
    ./catalog/acs-kernel.ms_my.US-ASCII.xml
    • -1
    • +1
    ./catalog/acs-kernel.nl_NL.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.no_NO.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.pl_PL.ISO-8859-2.xml
    • -1
    • +1
    ./catalog/acs-kernel.pt_BR.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.ru_RU.windows-1251.xml
  1. … 532 more files in changeset.
add user id and IP address to update_last_modified()

    • -0
    • +702
    ./sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -10
    • +16
    ./sql/postgresql/acs-objects-create.sql
    • -0
    • +47
    ./sql/postgresql/upgrade/upgrade-4.6.4-4.6.5.sql
  1. … 7 more files in changeset.
file upgrade-4.6.4-4.6.5.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6.4-4.6.5.sql
fixing lame = 0 instead of is null bug in register_parameter proc that would cause default values of new parameters to not be propagated to package instances during package upgrade

    • -1
    • +57
    ./sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
file upgrade-4.6.3-4.6.4.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-4.6.3-4.6.4.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
Added password_changed_date column to users table, so we can expire passwords after a certain number of days

    • -2
    • +3
    ./sql/oracle/community-core-create.sql
    • -1
    • +2
    ./sql/postgresql/community-core-create.sql
    • -0
    • +61
    ./sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
Removed duplicate parameters that snuck in when I merged with 4.6

Merged with 4.6 branch

    • -1
    • +11
    ./sql/oracle/acs-metadata-create.sql
    • -1
    • +11
    ./sql/oracle/acs-objects-create.sql
    • -66
    • +4
    ./sql/oracle/acs-permissions-create.sql
    • -3
    • +45
    ./sql/oracle/groups-body-create.sql
    • -2
    • +1475
    ./sql/oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -0
    • +887
    ./sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -0
    • +10
    ./sql/postgresql/acs-metadata-create.sql
  1. … 16 more files in changeset.
adding the acs-kernel parameter DefaultPersistentLoginP in response to bug 474

removing the file listings from the info files since those are no longer used by OpenACS

  1. … 28 more files in changeset.
Forgot to add my upgrade script during my last commit ...

file upgrade-4.6.2-4.6.3.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-4.6.2-4.6.3.sql
1. removed some needless LARS notices

2. removed acs_methods and friends from the permissions documentation

and got rid of the commented-out table stubs.

3. dropping of permissions was broken in PG, fixed that.

4. cc_users and registered_users views have been sped up.

5. removed an unused and incorrect proc from revision-procs

6. updated acs-kernel to 4.6.3

-------------------------------------------------------------------------------------

    • -66
    • +4
    ./sql/oracle/acs-permissions-create.sql
    • -1
    • +49
    ./sql/postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
  1. … 6 more files in changeset.
file upgrade-4.6.2-4.6.3.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
Changed a minor bug regarding the definition of user_tab_comments, bumped

to 4.6.3 and added an upgrade script (we may not release a 4.6.3 but if we

do, we're ready!)

    • -131
    • +31
    ./sql/postgresql/postgresql.sql
    • -0
    • +13
    ./sql/postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
1. Added kernel param IndexRedirectUrl which allows one to specify a url

that the index template will redirect to. dotLRN in particular wants

users to land at /dotlrn.

2. Changed the index file to implement this.

3. Removed unused proc from apm-xml-procs.tcl

  1. … 2 more files in changeset.
Fixed a problem with the party_approved_member_map uncovered by Dave Bauer.

    • -3
    • +45
    ./sql/oracle/groups-body-create.sql
    • -0
    • +211
    ./sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -4
    • +38
    ./sql/postgresql/groups-body-create.sql
    • -1
    • +1
    ./sql/postgresql/rel-segments-create.sql
    • -0
    • +217
    ./sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql