• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix typos

  1. … 28 more files in changeset.
Fix typos

    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.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
    ./postgresql/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
    ./postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
  1. … 15 more files in changeset.
add text/markdown to known content types (like text/enhanced), bump version number to 5.10.0d4

    • -0
    • +4
    ./oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
    • -0
    • +39
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  1. … 1 more file in changeset.
fix typos

    • -10
    • +10
    ./oracle/upgrade/upgrade-4.7d6-5.0d1.sql
  1. … 10 more files in changeset.
Bring legacy versions of image__new() in sync with the actual definitions

    • -0
    • +207
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  1. … 2 more files in changeset.
Fix typo in variable name "new_nls_language" (must be "new__nls_language")

    • -0
    • +201
    ./postgresql/upgrade/upgrade-5.9.2d1-5.9.2d2.sql
  1. … 1 more file in changeset.
file upgrade-5.9.2d1-5.9.2d2.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.2d1-5.9.2d2.sql
Fix typo in variable name "new_nls_language" (must be "new__nls_language")

    • -0
    • +201
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  1. … 1 more file in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -16
    • +16
    ./oracle/upgrade/upgrade-4.7d6-5.0d1.sql
  1. … 7820 more files in changeset.
Allow copy of files/folders into the same folder of the original content. This is done by appending a numerical suffix to the name.

It required modifying copy stored procedures so they could accept a different name and title for the copy.

I have also removed redundant package definition in oracle code that was immediately overridden afterwards.

    • -0
    • +685
    ./oracle/upgrade/upgrade-5.9.1b4-5.9.1b5.sql
    • -0
    • +146
    ./postgresql/upgrade/upgrade-5.9.1b4-5.9.1b5.sql
  1. … 9 more files in changeset.
file upgrade-5.9.1b4-5.9.1b5.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.9.1b4-5.9.1b5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1b4-5.9.1b5.sql
Fix spelling errors

    • -16
    • +16
    ./oracle/upgrade/upgrade-4.7d6-5.0d1.sql
  1. … 35 more files in changeset.
Performance improvement in content_item__get_path stored procedure (thanks to Thomas Renner)

    • -0
    • +95
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
  1. … 1 more file in changeset.
file upgrade-5.9.1b3-5.9.1b4.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
fix issue #3303: wrong identifier due to different database structure in oracle

- Align type of parameter "storage_type" with type definition of cr_items.storage_type

- bump version to 5.9.1d27

    • -0
    • +213
    ./postgresql/upgrade/upgrade-5.9.1d26-5.9.1d27.sql
  1. … 1 more file in changeset.
file upgrade-5.9.1d26-5.9.1d27.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d26-5.9.1d27.sql
Improve documentation

    • -3
    • +2
    ./postgresql/upgrade/upgrade-5.9.1d25-5.9.1d26.sql
file upgrade-5.9.1d25-5.9.1d26.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d25-5.9.1d26.sql
- fix bug when updateing a user portrait, which was saved as "lob"

    • -0
    • +39
    ./postgresql/upgrade/upgrade-5.9.1d25-5.9.1d26.sql
  1. … 1 more file in changeset.
- make upgrade script more robust (when run twice)

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.9.1d22-5.9.1d23.sql
- fix cr_revision_latest_tr once more to reduce the number of dead tuples generated for xo* classes

- bump version number to 5.9.1d25

    • -0
    • +28
    ./postgresql/upgrade/upgrade-5.9.1d24-5.9.1d25.sql
  1. … 1 more file in changeset.
file upgrade-5.9.1d24-5.9.1d25.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d24-5.9.1d25.sql
- avoid call of deprecated sql variant with 12 args via API (many thnaks to Guenter Ernst)

- handling of NULL values in cr_revision_latest_tr (many thanks to Guenter Ernst)

- bump version to 5.9.1d24

    • -3
    • +3
    ./postgresql/upgrade/upgrade-5.9.1d22-5.9.1d23.sql
    • -0
    • +26
    ./postgresql/upgrade/upgrade-5.9.1d23-5.9.1d24.sql
  1. … 2 more files in changeset.
file upgrade-5.9.1d23-5.9.1d24.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d23-5.9.1d24.sql