• last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
add editor hints, whitespace changes

    • -177
    • +184
    ./sql/postgresql/groups-body-create.sql
    • -63
    • +69
    ./sql/postgresql/site-nodes-create.sql
whitespace changes

    • -148
    • +148
    ./sql/postgresql/groups-body-create.sql
    • -86
    • +85
    ./sql/postgresql/site-nodes-create.sql
- Convert frequenty used functions from plpgsql

to strict and stable SQL functions, which allow

the PostgreSQL more optimizations

* acs_group__member_p/3

* site_node__url/1

- bump version number to 5.10.0d27

    • -17
    • +20
    ./sql/postgresql/groups-body-create.sql
    • -8
    • +7
    ./sql/postgresql/site-nodes-create.sql
file upgrade-5.10.0d26-5.10.0d27.sql was initially added on branch oacs-5-10.

Attribute discrepancy fix for object_types in OpenACS.

Some attributes are not created for new instances since 2006, but an upgrade

script deleting the already existing ones was never done.

Original datatype change:

https://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Avictorg%3A20060727200933

https://github.com/openacs/openacs-core/commit/7e30fa270483dcbc866ffbf6f5cf4f30447987cb

file upgrade-5.10.0d25-5.10.0d26.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.10.0d25-5.10.0d26.sql
Add oracle upgrade logic for previous attribute datatype discrepancy package upgrades, and fix typo in postgres upgrade script

  1. … 1 more file in changeset.
file upgrade-5.10.0d24-5.10.0d25.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.10.0d24-5.10.0d25.sql
Fix attribute datatype discrepancy, introduced in 2006 but never fixed for already existing instances.

Original datatype change:

https://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Avictorg%3A20060727200933

https://github.com/openacs/openacs-core/commit/7e30fa270483dcbc866ffbf6f5cf4f30447987cb

  1. … 2 more files in changeset.
file upgrade-5.10.0d24-5.10.0d25.sql was initially added on branch oacs-5-10.

Index acs_object's creation and modification date

    • -1
    • +3
    ./sql/postgresql/acs-objects-create.sql
file upgrade-5.10.0d23-5.10.0d24.sql was initially added on branch oacs-5-10.

Fix typo in message key

    • -1
    • +1
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
Export message keys to normalize sorting anx xml quoting (will prevent huge diffs with new message keys)

    • -87
    • +86
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
    • -88
    • +89
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
make return arguments explicit

Whitespace cleanup

    • -68
    • +66
    ./sql/postgresql/groups-body-create.sql
Redefine acs_group__member_p so that direct membership is checked in a way that is uniform with that of cascading membership: without any permission check (fixes acs_subsite_check_composite_group automated test)

    • -5
    • +2
    ./sql/postgresql/groups-body-create.sql
file upgrade-5.10.0d22-5.10.0d23.sql was initially added on branch oacs-5-10.

Define an acs_object schema and use it to redefine acs_object__name using dot notation

Goal is to further reduce code divergency between Oracle and Postgres

    • -7
    • +27
    ./sql/postgresql/acs-objects-create.sql
file upgrade-5.10.0d21-5.10.0d22.sql was initially added on branch oacs-5-10.

Fix acs-kernel url

improve spelling

  1. … 6 more files in changeset.
improve spelling

  1. … 11 more files in changeset.
improve spelling

    • -3
    • +3
    ./sql/oracle/rel-constraints-create.sql
    • -2
    • +2
    ./sql/oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -1
    • +1
    ./sql/oracle/upgrade/upgrade-4.5-4.5.1.sql
  1. … 19 more files in changeset.
Bump 'acs-kernel' version number

Add upgrade script to cleanup 'acs_object_context_index' and friends

file upgrade-5.10.0d20-5.10.0d21.sql was initially added on branch oacs-5-10.

Modernize logic for protecting against cached passwords from forms,

when users log out and other users use the back button (for Nora).

- switch to more modern caching prevention

- add CSRF protection to login form against forgery requests

- none of the cache-preventing mechanisms helps when the user

stores the password in the browser (no change to the past).

- For admins of existing sites: alter kernel parameter

"LoginPageExpirationTime" to 0 make use of this feature

  1. … 2 more files in changeset.
implementing feature request #3408: support for passing in null values to acs_object__set_attribute

    • -9
    • +8
    ./sql/postgresql/acs-objects-create.sql
file upgrade-5.10.0d19-5.10.0d20.sql was initially added on branch oacs-5-10.