• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes for Oracle 19c: fix broken variable references (introduced in oacs-5-9)

    • -6
    • +6
    ./oracle/file-storage-package-create.sql
Fixes for Oracle 19c: added missing SQL package declaration

    • -1
    • +147
    ./oracle/file-storage-package-create.sql
improve spelling

    • -2
    • +2
    ./postgresql/file-storage-package-create.sql
  1. … 14 more files in changeset.
Align fs_objects view definition in Oracle with the one in Postgres

    • -6
    • +3
    ./oracle/file-storage-views-create.sql
  1. … 1 more file in changeset.
file upgrade-5.10.d2-5.10.d3.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.d2-5.10.d3.sql
Removed obsolete @arch-tag

    • -3
    • +2
    ./postgresql/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
  1. … 23 more files in changeset.
fix typos

    • -2
    • +2
    ./postgresql/file-storage-package-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
  1. … 4 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -153
    • +9
    ./oracle/file-storage-package-create.sql
    • -0
    • +478
    ./oracle/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
    • -9
    • +14
    ./postgresql/file-storage-package-create.sql
    • -0
    • +135
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
  1. … 7829 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.

    • -153
    • +9
    ./oracle/file-storage-package-create.sql
    • -0
    • +478
    ./oracle/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
    • -8
    • +11
    ./postgresql/file-storage-package-create.sql
    • -0
    • +135
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
  1. … 9 more files in changeset.
file upgrade-5.9.1b3-5.9.1b4.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
- avoid call to deprecated content_revision__new/11, call content_revision__new/13 instead

- bump version number to 5.9.1d2

    • -2
    • +4
    ./postgresql/file-storage-package-create.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
  1. … 1 more file in changeset.
file upgrade-5.9.1d1-5.9.1d2.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
- (backport from oacs-5-9): rewrite update script based on a recursive query to avoid potential conflicts due to different orders of script execution, when e.g. acs_objects.tree_sortkey was already dropped.

- rewrite update script based on a recursive query to avoid potential conflicts due to different orders of script execution, when e.g. acs_objects.tree_sortkey was already dropped.

- add function args missed by earlier upgrades

- bump version numbers

    • -0
    • +16
    ./postgresql/upgrade/upgrade-5.9.0d1-5.9.0d2.sql
  1. … 9 more files in changeset.
Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

    • -106
    • +101
    ./postgresql/file-storage-package-create.sql
    • -0
    • +137
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
  1. … 519 more files in changeset.
- fix for bloat in cr_folder_type_map caused by file-storage. large sites might have 10 Mio+ entries! see posting in OpenACS Development forum concerning cr_folder_type_map bloat

    • -107
    • +102
    ./postgresql/file-storage-package-create.sql
    • -0
    • +137
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
  1. … 2 more files in changeset.
file upgrade-5.8.1-5.8.2.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -1
    • +2
    ./postgresql/file-storage-package-create.sql
  1. … 2546 more files in changeset.
file upgrade-5.8.1d3-5.8.1d4.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  1. … 1 more file in changeset.
- add missing function args

    • -1
    • +2
    ./postgresql/file-storage-package-create.sql
  1. … 7 more files in changeset.
- fix $$ quoting in upgrade scripts

  1. … 2 more files in changeset.
- fix collateral damage in upgrade scripts of file-storage

    • -6
    • +4
    ./postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
- update postgres function to modern style plpgsql definitions using dollar quoting

    • -12
    • +13
    ./postgresql/file-storage-create.sql
    • -26
    • +33
    ./postgresql/file-storage-notifications-create.sql
    • -29
    • +37
    ./postgresql/file-storage-notifications-drop.sql
    • -292
    • +408
    ./postgresql/file-storage-package-create.sql
    • -258
    • +325
    ./postgresql/upgrade/upgrade-4.2-4.6.sql
    • -21
    • +37
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
    • -85
    • +94
    ./postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
    • -28
    • +31
    ./postgresql/upgrade/upgrade-4.6.3-5.0.0.sql
    • -8
    • +17
    ./postgresql/upgrade/upgrade-5.1.0a12-5.1.0a13.sql
    • -96
    • +100
    ./postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
    • -13
    • +16
    ./postgresql/upgrade/upgrade-5.1.0a2-5.1.0a3.sql
    • -17
    • +20
    ./postgresql/upgrade/upgrade-5.1.0a3-5.1.0a4.sql
    • -25
    • +30
    ./postgresql/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
    • -18
    • +25
    ./postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
  1. … 27 more files in changeset.
1. Package uninstantiate now cleans up the instance's root folder.

2. Package drop works.

    • -18
    • +11
    ./postgresql/file-storage-drop.sql
    • -1
    • +6
    ./postgresql/file-storage-notifications-drop.sql
  1. … 4 more files in changeset.
Patches for NULL table name, on delete cascade to clean up file storage from Jim Lynch

    • -0
    • +26
    ./oracle/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
    • -4
    • +13
    ./postgresql/file-storage-create.sql
    • -0
    • +22
    ./postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
  1. … 1 more file in changeset.
Fix param values for archive command and extension (were mixed up)

    • -0
    • +7
    ./oracle/upgrade/upgrade-5.5.0d1-5.5.0d2.sql
    • -0
    • +7
    ./postgresql/upgrade/upgrade-5.5.0d1-5.5.0d2.sql
  1. … 1 more file in changeset.
compilation error due to bad plpgsql body

Checking that upgrade scripts modify parameters for the right package.

Modification to the oracle upgrade scripts for FS.

  1. … 3 more files in changeset.
Fixed it so only the parameter from file storage package will be overwritten and not any other parameters with the same name