• last updated 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
drop leftover functions from 2003, 2004 and 2005 in existing instances

  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-5.10.0d6-5.10.0d7.sql
revert prevous change

  1. … 1 more file in changeset.
Add "FOR UPDATE" to select operation of *_f() function inserting tuples.

the required "content_type__refresh_trigger" calls will follow later.

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

  1. … 8 more files in changeset.
Removed obsolete @arch-tag

  1. … 26 more files in changeset.
Removed obsolete @arch-tag

  1. … 16 more files in changeset.
Fix typos

  1. … 62 more files in changeset.
Fix typos

  1. … 28 more files in changeset.
Fix typos

  1. … 9 more files in changeset.
Fix more typos

  1. … 84 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.

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

    • -0
    • +39
    ./upgrade-5.10.0d3-5.10.0d4.sql
  1. … 3 more files in changeset.
Bring legacy versions of image__new() in sync with the actual definitions

    • -0
    • +207
    ./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")

  1. … 2 more files in changeset.
file upgrade-5.9.2d1-5.9.2d2.sql was initially added on branch oacs-5-9.

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

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

  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.

  1. … 12 more files in changeset.
file upgrade-5.9.1b4-5.9.1b5.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.9.1b4-5.9.1b5.sql
  1. … 1 more file in changeset.
Fix spelling errors

  1. … 41 more files in changeset.
Performance improvement in content_item__get_path stored procedure (thanks to Thomas Renner)

  1. … 2 more files in changeset.
file upgrade-5.9.1b3-5.9.1b4.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.9.1b3-5.9.1b4.sql
- Align type of parameter "storage_type" with type definition of cr_items.storage_type

- bump version to 5.9.1d27

  1. … 3 more files in changeset.
file upgrade-5.9.1d26-5.9.1d27.sql was initially added on branch oacs-5-9.

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

file upgrade-5.9.1d25-5.9.1d26.sql was initially added on branch oacs-5-9.

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

  1. … 2 more files in changeset.
- make upgrade script more robust (when run twice)