• last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Whitespace cleanup

    • -68
    • +66
    ./postgresql/groups-body-create.sql
Redefine acs_group__member_p so that direct membership is checked in a way that is uniform with that of cascading membership: without any permission check (fixes acs_subsite_check_composite_group automated test)

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

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d22-5.10.0d23.sql
Define an acs_object schema and use it to redefine acs_object__name using dot notation

Goal is to further reduce code divergency between Oracle and Postgres

    • -7
    • +27
    ./postgresql/acs-objects-create.sql
    • -0
    • +76
    ./postgresql/upgrade/upgrade-5.10.0d21-5.10.0d22.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d21-5.10.0d22.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d21-5.10.0d22.sql
improve spelling

  1. … 6 more files in changeset.
improve spelling

    • -1
    • +1
    ./oracle/upgrade/upgrade-4.2.1-4.2.2.sql
  1. … 11 more files in changeset.
improve spelling

    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.5-4.5.1.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.6-4.6.1d1.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.0d7-5.0d9.sql
    • -9
    • +9
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.1.4-5.1.4d1.sql
  1. … 19 more files in changeset.
Add upgrade script to cleanup 'acs_object_context_index' and friends

    • -0
    • +54
    ./postgresql/upgrade/upgrade-5.10.0d20-5.10.0d21.sql
file upgrade-5.10.0d20-5.10.0d21.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d20-5.10.0d21.sql
implementing feature request #3408: support for passing in null values to acs_object__set_attribute

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

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d19-5.10.0d20.sql
Move away portraits created as children of the -100 object that might be still around after acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql

    • -0
    • +20
    ./oracle/upgrade/upgrade-5.10.0d17-5.10.0d18.sql
    • -0
    • +20
    ./postgresql/upgrade/upgrade-5.10.0d17-5.10.0d18.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d17-5.10.0d18.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d17-5.10.0d18.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d17-5.10.0d18.sql
Data model upgrade for those instances that might have missed the renaming of the person object type

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

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d16-5.10.0d17.sql
file upgrade-5.10.0d15-5.10.0d16.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d15-5.10.0d16.sql
Modernize SQL existence test: make it more readable and faster

    • -0
    • +17
    ./postgresql/upgrade/upgrade-5.10.0d15-5.10.0d16.sql
  1. … 1 more file in changeset.
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
Modernize SQL existence test: make these more readable and faster

    • -12
    • +11
    ./postgresql/community-core-create.sql
    • -0
    • +92
    ./postgresql/upgrade/upgrade-5.10.0d14-5.10.0d15.sql
  1. … 1 more file in changeset.
backport from oacs-5-10 to allow installation of old version on pg11

Reparent portraits coming from the old good days, which were saved with -100 as parent_id (since at least 6 years portraits are saved as children of the user object)

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

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
site nodes reform part 2: change from tree_sortkeys to recursive queries

-- This upgrade script completes the commits "change queries on

-- site-node tree from tree_sortkey to recursive queries" from Oct 21,

-- 2018, 4 months ago. This upgrade has the purpose to drop the now

-- obsolete triggers and indices.

--

-- Delaying the 2nd part had the purpose to make upgrades more smooth,

-- at least for upgrades via .apm files. Without site nodes working,

-- users cannot navigate on their server unless it is restarted.

--

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181021173623

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181021175135

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022074137

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022085126

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022081230

--

    • -175
    • +3
    ./postgresql/site-nodes-create.sql
    • -0
    • +31
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 1 more file in changeset.
revert premature commit affecting all sites

    • -10
    • +0
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -1
    • +0
    ./postgresql/community-core-create.sql
    • -10
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 3 more files in changeset.
Add new column 'public_avatar_p' to the 'user_preferences' table, in order to allow the user to decide wheter to make the avatar (profile picture) public to other users or not, with a conservative default, false. Add also a simple API to get/set that value and bump acs-kernel version number.

    • -0
    • +10
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -1
    • +2
    ./postgresql/community-core-create.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 3 more files in changeset.
Rollback of 'boolean' parameter datatype, as oracle does not see necessary to have 'boolean' datatypes, and they do not even provide with a proper alternative on what to use instead. Great. See: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6263249199595#876972400346931526

    • -23
    • +0
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -22
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 1 more file in changeset.
Add 'boolean' parameter datatype and increase version number

    • -0
    • +23
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -0
    • +22
    ./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
Bring files on oacs-5-10 in sync with HEAD

  1. … 15 more files in changeset.