upgrade-5.0.1d6-5.0.1d7.sql

  • last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

  1. … 8 more files in changeset.
Chat data-model reform:

- introduce on delete cascade on foreign key constraints so package can be removed easily e.g. from the subsite UI

- remove remaining stored procedures (and function_args definitions) to relieve the burden on the development process and reduce divergency between oracle and postgres code

- converge oracle and postgres datamodels:

. oracle -> add missing messages_time_window column

. postgres -> remove creation_date from chat_transcripts, which was found to be still existing on old downstream installations

  1. … 9 more files in changeset.
file upgrade-5.0.1d6-5.0.1d7.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade-5.0.1d6-5.0.1d7.sql
  1. … 1 more file in changeset.