• last updated 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Redefine faq questions and answers as text, the same as downstream, then redefine all database function api so that argument types are taken from table definition

  1. … 3 more files in changeset.
file upgrade-5.10.0d7-5.10.0d8.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade-5.10.0d7-5.10.0d8.sql
Don't rely on the delete trigger being named consistently on different installations

Add again double quotes in the add constraint as well

Add double quotes in case constraints were defined using e.g. $ in the old days

Faq vs Search trigger reform: turns out after delete trigger on faq_q_and_as is quite pointless and makes it more complicated for faq package instances to properly uninstantiated. More details in the comments.

    • -0
    • +24
    ./upgrade-5.10.0d6-5.10.0d7.sql
  1. … 4 more files in changeset.
Introduce ON DELETE CASCADE on faq main datamodel tables, so generic acs_object db api can be used to e.g. delete a faq (fixes downstream errors when deleting FAQ package)

    • -0
    • +62
    ./upgrade-5.10.0d5-5.10.0d6.sql
  1. … 4 more files in changeset.
Removed obsolete @arch-tag

  1. … 26 more files in changeset.
Align case of acs_object_type with that of the actual table (fixes automated tests)

This change intentionally ignores Oracle, as its behavior with respect to case is not clear to me.

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

  1. … 7834 more files in changeset.
Add another constraint name variant as it existed in our production system

- provide support for old installations, with other constaint names

Alter caveman style booleans (type character(1)) to real SQL boolean types.

  1. … 5 more files in changeset.
file upgrade-5.9.0-5.9.1d1.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.9.0-5.9.1d1.sql
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2546 more files in changeset.
- add upgrade files

  1. … 1 more file in changeset.
file upgrade-5.8.1d2-5.8.1d3.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./upgrade-5.8.1d2-5.8.1d3.sql
- modernize SQL

  1. … 2 more files in changeset.
missing ';'.

Fixing null package_id's for faq and faq_q_and_as objects. Patch orignally provided by Gustaf Neumann.

    • -0
    • +11
    ./upgrade-5.2.0d5-5.2.0d6.sql
  1. … 1 more file in changeset.
Merged oacs-5-3 branch to HEAD

  1. … 187 more files in changeset.
file upgrade-5.2.0d4-5.2.0d5.sql was initially added on branch oacs-5-3.

    • -0
    • +0
    ./upgrade-5.2.0d4-5.2.0d5.sql
Added triggers to index faq contents for search (thanks to Jorge Couchet)

  1. … 4 more files in changeset.
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2478 more files in changeset.
Update acs_object_types table, not acs_objects.

split package from datamodel create, add fts contract, update for tip 42,43 fix name_method on pg

    • -0
    • +5
    ./upgrade-5.2.0d1-5.2.0d2.sql
  1. … 8 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 35 more files in changeset.
I added an upgrade script for 4.0-4.6, need to do something for people who upgraded before it was there, bump version and have a script that only gets sourced if the column does not exist? bug 215

file upgrade-4.0-4.6.sql was initially added on branch oacs-4-6.