• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Just an indentation fix

    • -15
    • +17
    ./sql/postgresql/authentication-create.sql
added authority key

    • -19
    • +21
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
added common strings

    • -0
    • +21
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
changing datatype to varchar for the key column of the parameters table in upgrade scripts

making key column in parameters table varchar instead of clob (text)

    • -2
    • +2
    ./sql/oracle/authentication-create.sql
    • -2
    • +2
    ./sql/postgresql/authentication-create.sql
bugfix: cannot reference acs_sc_impl table from acs-kernel

    • -2
    • +3
    ./sql/oracle/authentication-create.sql
    • -2
    • +3
    ./sql/postgresql/authentication-create.sql
Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

    • -1
    • +2
    ./sql/oracle/community-core-create.sql
    • -1
    • +48
    ./sql/oracle/groups-body-create.sql
    • -0
    • +702
    ./sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -0
    • +118
    ./sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql
    • -10
    • +16
    ./sql/postgresql/acs-objects-create.sql
    • -0
    • +1
    ./sql/postgresql/community-core-create.sql
    • -0
    • +67
    ./sql/postgresql/groups-body-create.sql
    • -15
    • +45
    ./sql/postgresql/groups-create.sql
    • -0
    • +117
    ./sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
  1. … 802 more files in changeset.
adding datamodel for authority parameters and bumping version to 5.0d4

    • -1
    • +17
    ./sql/oracle/authentication-create.sql
    • -0
    • +25
    ./sql/oracle/upgrade/upgrade-5.0d3-5.0d4.sql
    • -1
    • +17
    ./sql/postgresql/authentication-create.sql
    • -0
    • +25
    ./sql/postgresql/upgrade/upgrade-5.0d3-5.0d4.sql
Corrected PG version of Barry Brooks speed up to the object update trigger,

added the new Oracle trigger to the proper upgrade script.

    • -2
    • +2
    ./sql/postgresql/acs-objects-create.sql
Modified Barry Brooks's context_id update trigger speedup for PostgreSQL,

did some testing ...

    • -7
    • +11
    ./sql/postgresql/acs-objects-create.sql
    • -1
    • +78
    ./sql/postgresql/upgrade/upgrade-5.0d-5.0d2.sql
Added Barry Brook's speed-up to the object context update trigger (untested as

yet, will get Janine to test at Sloan)

Changed acs_user.new and acs.add_user to take authority_id and username. Removed password_question/answer to make room.

    • -9
    • +18
    ./sql/oracle/community-core-create.sql
    • -44
    • +76
    ./sql/postgresql/community-core-create.sql
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