• last updated 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    ./sql/postgresql/site-nodes-create.sql
revert premature commit affecting all sites

    • -1
    • +0
    ./sql/oracle/community-core-create.sql
    • -1
    • +0
    ./sql/postgresql/community-core-create.sql
  1. … 2 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.

    • -1
    • +2
    ./sql/oracle/community-core-create.sql
    • -1
    • +2
    ./sql/postgresql/community-core-create.sql
  1. … 2 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

Add 'boolean' parameter datatype and increase version number

file upgrade-5.10.0d12-5.10.0d13.sql was initially added on branch oacs-5-10.

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

Bring files on oacs-5-10 in sync with HEAD

    • -1
    • +187
    ./sql/oracle/utilities-create.sql
  1. … 14 more files in changeset.
Reinstate reworked versions of some oracle database utilities left behind during solution of bug #3302

Rework is based on coding style observed in code provided by Brian Fenton, but could still not be tested. See https://openacs.org/bugtracker/openacs/bug?bug_number=3302

    • -1
    • +187
    ./sql/oracle/utilities-create.sql
    • -0
    • +353
    ./sql/oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
Drop function first, as name of parameters changed

name arguments consistently

Fix typo

schema queries: allow mixed case for column and table names (similar to function_args

bump versiom number to 5.10.0d11

    • -15
    • +15
    ./sql/postgresql/utilities-create.sql
proivde upgrades script for PG 11 and bump version number to 5.9.2d2

file upgrade-5.9.2d1-5.9.2d2.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.2d1-5.9.2d2.sql
backport from HEAD for PG 11

[PostgreSQL 11] Change 'with (iscachable)' to IMMUTABLE for PG11

document parameter consitently concerning required server restarts

improve comments and spelling

    • -2
    • +2
    ./sql/oracle/acs-relationships-create.sql
fix issue #3360; probably a problem that shows up with pg10.

make checking of pg_version number more robust (backporting changes from head).

See also issue #3359

Fix typos

Removed obsolete @arch-tag

    • -2
    • +1
    ./sql/oracle/upgrade/upgrade-5.2.0d11-5.2.0d12.sql
  1. … 29 more files in changeset.
Add @see in deprecated proc, declare acs-kernel.AdminOwner parameter deprecated (superseded by acs-kernel.HostAdministrator)

  1. … 1 more file in changeset.
Fix typo

Change database type for boolean from "bool" to "boolean" in acs_datatypes

    • -2
    • +2
    ./sql/postgresql/acs-metadata-create.sql
    • -0
    • +7
    ./sql/postgresql/upgrade/upgrade-5.10.0d7-5.10.0d8.sql
    • -1
    • +1
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
Remove reference to legacy datamodel

...chances are few this code will be ever executed anyhow, as is the dropping script for the very kernel

Remove obsolete table apm_package_db_types: this was superseded by threaded cache ::acs::known_database_types

    • -0
    • +5
    ./sql/oracle/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
    • -0
    • +5
    ./sql/postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  1. … 1 more file in changeset.
imporve spelling

    • -1
    • +1
    ./sql/oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -2
    • +2
    ./sql/postgresql/site-nodes-create.sql