• last updated 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
the auth_auhtorities.help_contact_text_format column was missing from the upgrade scripts

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)

    • -4
    • +4
    ./sql/oracle/acs-relationships-create.sql
    • -16
    • +16
    ./sql/oracle/community-core-create.sql
    • -15
    • +19
    ./sql/oracle/groups-body-create.sql
    • -8
    • +15
    ./sql/oracle/rel-constraints-create.sql
    • -6
    • +6
    ./sql/oracle/rel-segments-body-create.sql
  1. … 261 more files in changeset.
upgrade script fix: cannot drop columns with PG 7.2. Also, shouldn't say drop table CASCADE with PG 7.2

upgrade script fix: authority__new had too many arguments. Seems we cannot alter a column to have not null constraint

upgrade script fix: only creating admin rel role if it hasn't already been created by dotlrn

    • -1
    • +18
    ./sql/postgresql/upgrade/upgrade-4.6.5-4.6.6.sql
moving the password question parameters to acs-kernel. Updating parameter::get calls in local-procs to always provide a package_id (either current subsite or acs-kernel)

  1. … 2 more files in changeset.
Implemented bug #194: Do not serve .xql files

  1. … 2 more files in changeset.
when removing file db model, forgot to replace reference to apm_package_files.path%TYPE with varchar. Doing so now and changing upgrade script

    • -0
    • +47
    ./sql/postgresql/upgrade/upgrade-5.0d7-5.0d9.sql
removing call to apm_package.enable (proc no longer exists)

removed comment on apm_packages.enabled_p since the column's gone

when removing the apm_package.enabled_p column I forgot to remove the apm_package.enable/disable functions, so removing those now

    • -289
    • +586
    ./sql/oracle/upgrade/upgrade-5.0d7-5.0d9.sql
Upgrading kernel to 5.0d9. Fixing bug 555 - Removing apm_packages.enabled_p column and taking the opportunity to remove obsolete file related datamodel

    • -0
    • +565
    ./sql/oracle/upgrade/upgrade-5.0d7-5.0d9.sql
    • -0
    • +15
    ./sql/postgresql/upgrade/upgrade-5.0d7-5.0d9.sql
re-exporting the Arabic catalog files as their keys were previously messed up (had question marks in them)

    • -2
    • +1
    ./catalog/acs-kernel.AR_EG.ISO-8859-6.xml
    • -2
    • +1
    ./catalog/acs-kernel.AR_LB.ISO-8859-6.xml
  1. … 60 more files in changeset.
Applied patch #280 for bug #820

    • -2
    • +2
    ./sql/postgresql/acs-objects-create.sql
    • -1
    • +47
    ./sql/postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
Fixed password expiration and approval expiration

  1. … 8 more files in changeset.
Default to persistent logins, now that persistent logins aren't eternal, but only for about 8 hours

Rewrote cookie handling

    • -1
    • +3
    ./sql/oracle/community-core-create.sql
    • -0
    • +12
    ./sql/oracle/upgrade/upgrade-5.0d6-5.0d7.sql
    • -0
    • +2
    ./sql/postgresql/community-core-create.sql
    • -0
    • +11
    ./sql/postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
  1. … 5 more files in changeset.
ext-auth #20: adding support for Login over HTTPS. New acs-kernel parameter RestrictLoginToSSLP. New API in security-procs.tcl for casting requests into HTTPS mode etc. Requiring secure connection in scripts passing password (registration, login, password-update)

  1. … 8 more files in changeset.
adding latest translations from the translation server

    • -0
    • +7
    ./catalog/acs-kernel.AR_EG.ISO-8859-6.xml
    • -0
    • +7
    ./catalog/acs-kernel.AR_LB.ISO-8859-6.xml
    • -1
    • +1
    ./catalog/acs-kernel.ast_ES.ISO-8859-1.xml
    • -0
    • +7
    ./catalog/acs-kernel.da_DK.ISO-8859-1.xml
    • -3
    • +3
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
    • -1
    • +0
    ./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
    • -0
    • +7
    ./catalog/acs-kernel.it_IT.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.ja_JP.Shift_JIS.xml
    • -1
    • +1
    ./catalog/acs-kernel.ms_my.US-ASCII.xml
    • -1
    • +1
    ./catalog/acs-kernel.nl_NL.ISO-8859-1.xml
  1. … 616 more files in changeset.
Removed snapshot_p flag from data model, and moved into auth_sync_retrieve service contract

    • -7
    • +1
    ./sql/oracle/authentication-create.sql
    • -5
    • +1
    ./sql/postgresql/authentication-create.sql
removing ACS and OpenACS prefixes from core package names as they weren't really conveying any useful information for system admins

  1. … 12 more files in changeset.
Added UsePasswordWidgetForUsername and UseEmailForUsername parameters

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)