• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
adding format column for the help_contact_text richtext column

    • -1
    • +2
    ./sql/oracle/authentication-create.sql
    • -1
    • +2
    ./sql/postgresql/authentication-create.sql
committed the authority__new function with more than 16 arguments which doesn't work in PG. Reverting back to 16 args

    • -12
    • +2
    ./sql/oracle/authentication-package-create.sql
    • -16
    • +6
    ./sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
making sort order default to the current highest sort order plus one for authorities

    • -1
    • +11
    ./sql/oracle/authentication-package-create.sql
    • -3
    • +11
    ./sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
adding batch sync related columns to the auth_authorities table

    • -2
    • +18
    ./sql/oracle/authentication-create.sql
    • -2
    • +12
    ./sql/oracle/authentication-package-create.sql
    • -3
    • +14
    ./sql/postgresql/authentication-create.sql
    • -12
    • +37
    ./sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
seems create or replace view doesn't work with PG 7.2 so changing to create view

Added all_users view to get basic user info without all the baggae of cc_users.

I messed up with that Main Site -> Home change. Turns out there's code all over the place which depends on that name

Renamed Main Site to Home (uh-oh, hope I won't get kicked and yelled at)

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