• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Change database type for boolean from "bool" to "boolean" in acs_datatypes

    • -0
    • +7
    ./postgresql/upgrade/upgrade-5.10.0d7-5.10.0d8.sql
  1. … 1 more file in changeset.
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
    ./oracle/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  1. … 2 more files in changeset.
imporve spelling

    • -1
    • +1
    ./oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.0d7-5.0d9.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
  1. … 1 more file in changeset.
fix typo

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
Replace obsolete function bitfromint4() by cast

    • -0
    • +38
    ./postgresql/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  1. … 1 more file in changeset.
Replace obsolete funktion bittoint4() by cast

    • -0
    • +78
    ./postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
  1. … 1 more file in changeset.
fix singular/plural typos

  1. … 6 more files in changeset.
Fix typos

  1. … 31 more files in changeset.
Fix typos

    • -1
    • +1
    ./oracle/upgrade/upgrade-4.5-4.5.1.sql
  1. … 23 more files in changeset.
improve spelliing

  1. … 2 more files in changeset.
Fix typos

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  1. … 6 more files in changeset.
Fix typos

    • -1
    • +1
    ./oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
    • -2
    • +2
    ./postgresql/rel-constraints-create.sql
  1. … 57 more files in changeset.
Fix typos

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

    • -6
    • +7
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  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.

    • -2
    • +11
    ./postgresql/acs-objects-create.sql
    • -0
    • +80
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  1. … 15 more files in changeset.
Fix typos

    • -1
    • +1
    ./oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.2.1-4.2.2.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
    • -2
    • +2
    ./postgresql/acs-permissions-create.sql
    • -2
    • +2
    ./postgresql/rel-constraints-create.sql
  1. … 1 more file in changeset.
Backfix upgrade to be PostgreSQL 9.0 compliant

    • -4
    • +2
    ./postgresql/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
Backport fix to https://openacs.org/bugtracker/openacs/bug?format=table&bug_number=3331: fix original problematic update

    • -4
    • +2
    ./postgresql/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
  1. … 1 more file in changeset.
file upgrade-5.9.1-5.9.2d1.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1-5.9.2d1.sql
Fix typo

Use PostgreSQL 9.0 compatible idioms in 'sql' stored procedure

    • -0
    • +20
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  1. … 1 more file in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -2
    • +2
    ./oracle/site-node-object-map-create.sql
    • -2
    • +2
    ./oracle/test/rel-constraints-test.sql
    • -2
    • +4
    ./oracle/test/rel-segments-test-types-create.sql
    • -0
    • +344
    ./oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
  1. … 7820 more files in changeset.
Fix spelling errors

    • -2
    • +2
    ./oracle/test/rel-constraints-test.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-4.5-4.5.1.sql
    • -5
    • +5
    ./oracle/upgrade/upgrade-4.6-4.6.1d1.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -11
    • +11
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-5.1.4-5.1.4d1.sql
  1. … 34 more files in changeset.
Fix upgrade logics, because old instances named constraint differently. Also, skip execution when not needed, as can be demanding (acts on acs_objects).

    • -4
    • +17
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
Added missing data model upgrade from version 5.2, affecting long lived installations.

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

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
applied changes provided by Brian for oracle. For details, see issue #3302

    • -143
    • +61
    ./oracle/utilities-create.sql
    • -123
    • +60
    ./oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -142
    • +59
    ./oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
Fix issue #3300 and #3301: index name breaks Oracle name length limit of 30 chars

    • -2
    • +2
    ./oracle/site-node-object-map-create.sql