• last updated 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
    • -0
    • +41
    ./upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  1. … 3 more files in changeset.
file upgrade-5.10.0d11-5.10.0d12.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  1. … 1 more file in changeset.
use SQL functions (instead of plpgsql) defined as stabe and strict for

* content_folder__is_folder

* content_folder__is_sub_folder, and

* content_folder__is_empty

... having as well more sane constructs returning boolean values

    • -0
    • +61
    ./upgrade/upgrade-5.10.0d10-5.10.0d11.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d10-5.10.0d11.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d10-5.10.0d11.sql
improve performance of content_folder__is_sub_folder

    • -0
    • +34
    ./upgrade/upgrade-5.10.0d9-5.10.0d10.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d9-5.10.0d10.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d9-5.10.0d10.sql
file upgrade-5.10.0d8-5.10.0d9.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d8-5.10.0d9.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

    • -0
    • +21
    ./upgrade/upgrade-5.10.0d8-5.10.0d9.sql
  1. … 3 more files in changeset.
Whitespace cleanup

Move CR search callbacks to new namespace in compliance with OpenACS naming convention, create deprecated wrappers, update service contract tables

    • -0
    • +31
    ./upgrade/upgrade-5.10.0d7-5.10.0d8.sql
  1. … 2 more files in changeset.
file upgrade-5.10.0d7-5.10.0d8.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d7-5.10.0d8.sql
Whitespace cleanup

fix typo

improve spelling

  1. … 32 more files in changeset.
improve spelling

  1. … 31 more files in changeset.
drop leftover functions from 2003, 2004 and 2005 in existing instances

    • -0
    • +34
    ./upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d6-5.10.0d7.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d6-5.10.0d7.sql
revert prevous change

    • -97
    • +2
    ./upgrade/upgrade-5.10.0d5-5.10.0d6.sql
Add "FOR UPDATE" to select operation of *_f() function inserting tuples.

the required "content_type__refresh_trigger" calls will follow later.

    • -0
    • +98
    ./upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  1. … 1 more file in changeset.
improve spelling

    • -1
    • +1
    ./upgrade/upgrade-5.2.0d12-5.2.0d13.sql
    • -1
    • +1
    ./upgrade/upgrade-5.9.1d14-5.9.1d15.sql
    • -1
    • +1
    ./upgrade/upgrade-5.9.1d9-5.9.1d10.sql
  1. … 5 more files in changeset.
Removed obsolete @arch-tag

    • -3
    • +1
    ./upgrade/upgrade-5.2.0d18-5.2.0d19.sql
  1. … 26 more files in changeset.
Removed obsolete @arch-tag

    • -3
    • +2
    ./upgrade/upgrade-5.2.0d10-5.2.0d11.sql
    • -2
    • +1
    ./upgrade/upgrade-5.2.0d13-5.2.0d14.sql
    • -3
    • +2
    ./upgrade/upgrade-5.2.0d18-5.2.0d19.sql
  1. … 16 more files in changeset.
Fix typos

    • -1
    • +1
    ./upgrade/upgrade-5.2.0d14-5.2.0d15.sql
  1. … 62 more files in changeset.
Fix typos

  1. … 28 more files in changeset.
Fix typos

    • -2
    • +2
    ./upgrade/upgrade-5.10.0d4-5.10.0d5.sql
    • -2
    • +2
    ./upgrade/upgrade-5.2.0d9-5.2.0d10.sql
  1. … 7 more files in changeset.
Fix more typos

  1. … 83 more files in changeset.
Fix typos

  1. … 52 more files in changeset.
Upgrade fix

Execute cleanup only if explicitly uncommented, as might have performance implications.

Also, correct unaligned constraint names in old instances upgraded incrementally over the years.

    • -5
    • +9
    ./upgrade/upgrade-5.10.0d4-5.10.0d5.sql
  1. … 1 more file in changeset.
Add missing change in the data model from previous commit

Portrait management reform and correction

Moved logics to create a portrait in a proc in order to reuse it in other places

such as picture retrieval services (e.g. Bach picture retrieval at WU). Turns out

we were not doing our homeworks here: when the portrait is created into CR, a

cr_child_rel is created. When the portrait was erased though, this was not cleaned

up propely, leaving dangling acs_objects with no reference in cr_child_rels table.

On busy sites, this can grow in the ten thousands order of magnitude. Changes include

also fix for this behavior and tuples cleanup.

    • -0
    • +77
    ./upgrade/upgrade-5.10.0d4-5.10.0d5.sql
  1. … 15 more files in changeset.