• last updated 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merge with missing files

    • -0
    • +0
    ./oracle/upgrade/upgrade-4.7d6-5.0d1.sql
  1. … 1453 more files in changeset.
merge from oacs-5-10

    • -8
    • +8
    ./oracle/upgrade/upgrade-4.7d6-5.0d1.sql
    • -0
    • +48
    ./oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  1. … 8085 more files in changeset.
Add new extension mjs, for Javascript modules, to the Javascript mime type

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

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.1b3-5.10.1b4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.1b3-5.10.1b4.sql
Redefine content_item__get_virtual_path so that get_virtual_path__root_folder_id argument is not ignored

    • -0
    • +33
    ./postgresql/upgrade/upgrade-5.10.1b1-5.10.1b2.sql
  1. … 1 more file in changeset.
file upgrade-5.10.1b1-5.10.1b2.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.1b1-5.10.1b2.sql
Add vtt mime type to CR

    • -0
    • +38
    ./postgresql/upgrade/upgrade-5.10.1d4-5.10.1d5.sql
  1. … 1 more file in changeset.
file upgrade-5.10.1d4-5.10.1d5.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.1d4-5.10.1d5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.1d4-5.10.1d5.sql
Fixes for Oracle 19c: made set_live_revision compatible with postgres version

fix broken function_args definition

    • -0
    • +1
    ./postgresql/upgrade/upgrade-5.10.1d2-5.10.1d3.sql
  1. … 4 more files in changeset.
file upgrade-5.10.1d2-5.10.1d3.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.1d2-5.10.1d3.sql
More fixes for Oracle 19c in essential packages

in essence, this fixes

- package content_item

- package content_folder

with the following errors popping at at installation:

Errors for PACKAGE BODY CONTENT_FOLDER:

LINE/COL ERROR

-------- -----------------------------------------------------------------

76/11 PLS-00323: subprogram or cursor 'COPY' is declared in a package

specification and must be defined in the package body

Errors for PACKAGE BODY CONTENT_ITEM:

LINE/COL ERROR

-------- -----------------------------------------------------------------

22/10 PLS-00323: subprogram or cursor 'NEW' is declared in a package

specification and must be defined in the package body

40/1 PL/SQL: Item ignored

67/38 PLS-00382: expression is of wrong type

275/11 PLS-00323: subprogram or cursor 'SET_LIVE_REVISION' is declared

in a package specification and must be defined in the package

body

DRG-10595: ALTER INDEX CR_REV_ATTRIBUTE_INDEX failed

DRG-11000: invalid keyword SYNC

DRG-10595: ALTER INDEX CR_REV_CONTENT_INDEX failed

DRG-11000: invalid keyword SYNC

file upgrade-5.10.0d14-5.10.0d15.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d14-5.10.0d15.sql
Use 'revision_id' as a tiebreaker in case creation_date is the same, which can happen if different revisions were created inside a single transaction.

    • -0
    • +43
    ./postgresql/upgrade/upgrade-5.10.0d14-5.10.0d15.sql
  1. … 1 more file in changeset.
added constraint cr_items_parent_id_ck to avoid certain simple loops on parent_ids

An item must not be equal to its own parent. Note that this constraint is not

guaranteed to avoid all loops; it is still possible to create indirect recursive

loops but excludes some real-world problems.

    • -0
    • +12
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d12-5.10.0d13.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
Fix typo

    • -0
    • +48
    ./oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
    • -0
    • +41
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d11-5.10.0d12.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
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

    • -262
    • +241
    ./postgresql/content-folder.sql
    • -0
    • +61
    ./postgresql/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
    ./postgresql/upgrade/upgrade-5.10.0d10-5.10.0d11.sql
improve performance of content_folder__is_sub_folder

    • -0
    • +34
    ./postgresql/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
    ./postgresql/upgrade/upgrade-5.10.0d9-5.10.0d10.sql
Add oracle upgrade logic for previous attribute datatype discrepancy package upgrades, and fix typo in postgres upgrade script

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

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

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