• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Use quotes consistently around group/community names

    • -6
    • +6
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
    • -6
    • +6
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
  1. … 2 more files in changeset.
extend message keys

    • -75
    • +94
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
Support internationalization via [group::get_member_state_pretty] and

other related messages concerning state changes.

    • -78
    • +99
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
  1. … 4 more files in changeset.
Fix spelling errors

    • -2
    • +2
    ./sql/oracle/test/rel-constraints-test.sql
    • -2
    • +2
    ./sql/oracle/test/rel-segments-test.sql
    • -6
    • +6
    ./sql/oracle/upgrade/upgrade-4.5-4.5.1.sql
    • -11
    • +11
    ./sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql
  1. … 34 more files in changeset.
Fix wrong version number

Fix upgrade logics, because old instances named constraint differently. Also, skip execution when not needed, as can be demanding (acts on acs_objects).

Added missing data model upgrade from version 5.2, affecting long lived installations.

file upgrade-5.9.1b3-5.9.1b4.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
applied changes provided by Brian for oracle. For details, see issue #3302

    • -143
    • +61
    ./sql/oracle/utilities-create.sql
    • -123
    • +60
    ./sql/oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -142
    • +59
    ./sql/oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
Fix issue #3300 and #3301: index name breaks Oracle name length limit of 30 chars

- bump version number of OpenACS to 5.9.1b3 and DotLRN to 2.9.1b3

  1. … 79 more files in changeset.
Updating of German translation for many packages (many thanks to Markus Moser)

    • -0
    • +21
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
  1. … 25 more files in changeset.
Updated es_ES translation

    • -0
    • +5
    ./catalog/acs-kernel.es_ES.ISO-8859-1.xml
  1. … 20 more files in changeset.
Bump version numbers for OpenACS 5.9.1b1

  1. … 81 more files in changeset.
Italian localization of message keys for many packages

    • -6
    • +29
    ./catalog/acs-kernel.it_IT.ISO-8859-1.xml
  1. … 25 more files in changeset.
Added new database utility to retrieve primary keys of a table.

Source for the postgres version: https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns

Source for the oracle version: http://stackoverflow.com/questions/4749650/function-that-would-return-the-data-retreived-from-a-select-query-oracle

    • -0
    • +245
    ./sql/oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
    • -1
    • +18
    ./sql/postgresql/utilities-create.sql
file upgrade-5.9.1d19-5.9.1d20.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
Added new database functions to check for various properties and constraints in database metadata:

- foreign key constraint

- unique constraint

- not null constraint

- get column default value

    • -1
    • +117
    ./sql/oracle/utilities-create.sql
    • -0
    • +225
    ./sql/oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -9
    • +155
    ./sql/postgresql/utilities-create.sql
file upgrade-5.9.1d18-5.9.1d19.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
- add nonces to script tags

- add body handlers

  1. … 7 more files in changeset.
- Improved compatiblity with PostgreSQL before 9.2:

don't use SQL-language function names to reference parameters to

obtain compatibility for earlier PostgreSQL versions

(see https://www.postgresql.org/docs/9.2/static/release-9-2.html

item E.19.3.9.3)

- fix upgrade script for PostgreSQL before 9.2: the old version checked

already the version number, but actually the SQL compilation failed

due to the unknown "IF EXISTS" for sequences.

- Added support for W3C Content Security Policy(CSP)

* For details about CSP, see https://www.w3.org/TR/CSP/

* New calls:

security::csp::nonce:

Generate a CSP nonce token token

security::csp::require /directive/ /value/:

Add a requirements of a page to the CSP in order to generate

later a tailored policy with the minimal permissions for

this page. For example, the following requirement is

currently added per default to the oacs-master template to

permit style tags and style attribites in the markup.

security::csp::require style-src 'unsafe-inline'

security::csp::render:

Generate a policy from the requirements

* Added Kernel Parameter CSPEnabledP to activate/desctivate CSP

(default on)

- Bump version numbers

acs-tcl to 5.9.1d11

acs-bootstrap-installer to 5.9.1d4

acs-kernel to 5.9.1d17

  1. … 7 more files in changeset.
- add kernel parameter to make ad_session_id cookies secure (useful on sites, where all sessions are via https, improves security rating on e.g. mozillas observatory tool)

  1. … 1 more file in changeset.
- don't change names of arguments unless necessary, since such cases require a DROP FUNCTION

composition-rel reform:

- apply changes developed by Michael Steigman for making rel-types

configurable whether these should be composable or not

(default is: these are composable, which was up to now the only

choice)

- improved documentation of log argument lists of SQL functions

- Background:

http://openacs.org/forums/message-view?message_id=5330734

http://openacs.org/forums/message-view?message_id=4031049

- bump version number of acs-kernel to 5.9.1d16

    • -1
    • +2
    ./sql/oracle/acs-relationships-create.sql
    • -23
    • +32
    ./sql/oracle/groups-body-create.sql
    • -25
    • +36
    ./sql/postgresql/groups-body-create.sql
    • -8
    • +5
    ./sql/postgresql/rel-segments-create.sql
    • -4
    • +6
    ./sql/test/rel-segments-test-types-create.sql
  1. … 20 more files in changeset.
file upgrade--5.9.1d15-5.9.1d16.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
file upgrade-5.9.1d15-5.9.1d16.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d15-5.9.1d16.sql
- use dollar quoting for SQL comments

    • -9
    • +9
    ./sql/postgresql/acs-objects-create.sql
- add verbosity setting

- make it easy to log SQL statements as these are executed

    • -4
    • +4
    ./sql/postgresql/acs-kernel-create.sql