• last updated 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    ./upgrade/upgrade-5.10.0d13-5.10.0d14.sql
  1. … 2 more files in changeset.
file upgrade-5.10.0d13-5.10.0d14.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d13-5.10.0d14.sql
  1. … 1 more file in changeset.
revert premature commit affecting all sites

    • -10
    • +0
    ./upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 5 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
    ./upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 5 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
    ./upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 3 more files in changeset.
Add 'boolean' parameter datatype and increase version number

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

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 1 more file in changeset.
Bring files on oacs-5-10 in sync with HEAD

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

    • -0
    • +353
    ./upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  1. … 1 more file in changeset.
improve comments and spelling

  1. … 4 more files in changeset.
Fix typos

  1. … 1 more file in changeset.
Removed obsolete @arch-tag

    • -2
    • +1
    ./upgrade/upgrade-5.2.0d11-5.2.0d12.sql
  1. … 30 more files 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

  1. … 1 more file in changeset.
Remove obsolete table apm_package_db_types: this was superseded by threaded cache ::acs::known_database_types

    • -0
    • +5
    ./upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  1. … 4 more files in changeset.
imporve spelling

  1. … 3 more files in changeset.
Fix typos

  1. … 23 more files in changeset.
Fix typos

  1. … 60 more files in changeset.
Fix typos

  1. … 7 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -2
    • +4
    ./test/rel-segments-test-types-create.sql
    • -0
    • +344
    ./upgrade/upgrade--5.9.1d15-5.9.1d16.sql
  1. … 7820 more files in changeset.
Fix spelling errors

    • -11
    • +11
    ./upgrade/upgrade-5.0d9-5.0d13.sql
  1. … 34 more files in changeset.
applied changes provided by Brian for oracle. For details, see issue #3302

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

Added new database utility to retrieve primary keys of a table.

Source for the postgres version: https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns

Source for the oracle version: http://stackoverflow.com/questions/4749650/function-that-would-return-the-data-retreived-from-a-select-query-oracle

    • -0
    • +245
    ./upgrade/upgrade-5.9.1d19-5.9.1d20.sql
  1. … 3 more files in changeset.
file upgrade-5.9.1d19-5.9.1d20.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade/upgrade-5.9.1d19-5.9.1d20.sql
  1. … 1 more file in changeset.
Added new database functions to check for various properties and constraints in database metadata:

- foreign key constraint

- unique constraint

- not null constraint

- get column default value

    • -0
    • +225
    ./upgrade/upgrade-5.9.1d18-5.9.1d19.sql
  1. … 3 more files in changeset.
file upgrade-5.9.1d18-5.9.1d19.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade/upgrade-5.9.1d18-5.9.1d19.sql
  1. … 1 more file in changeset.
composition-rel reform:

- apply changes developed by Michael Steigman for making rel-types

configurable whether these should be composable or not

(default is: these are composable, which was up to now the only

choice)

- improved documentation of log argument lists of SQL functions

- Background:

http://openacs.org/forums/message-view?message_id=5330734

http://openacs.org/forums/message-view?message_id=4031049

- bump version number of acs-kernel to 5.9.1d16

    • -2
    • +4
    ./test/rel-segments-test-types-create.sql
    • -0
    • +344
    ./upgrade/upgrade--5.9.1d15-5.9.1d16.sql
  1. … 30 more files in changeset.
file upgrade--5.9.1d15-5.9.1d16.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade/upgrade--5.9.1d15-5.9.1d16.sql
- replace obsolete all_object_party_privilege_map by acs_object_party_privilege_map

- bump version number to 5.9.1d10

    • -0
    • +197
    ./upgrade/upgrade-5.9.1d9-5.9.1d10.sql
  1. … 4 more files in changeset.
file upgrade-5.9.1d9-5.9.1d10.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade/upgrade-5.9.1d9-5.9.1d10.sql
  1. … 1 more file in changeset.