• last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- provide support for old installations, with other constaint names

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

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

    • -0
    • +0
    ./postgresql/upgrade/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).

    • -18
    • +19
    ./postgresql/faq-package-create.sql
    • -9
    • +17
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
  1. … 2544 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
    ./postgresql/upgrade/upgrade-5.8.1d2-5.8.1d3.sql
- add missing function args

- bump version number

  1. … 1 more file in changeset.
- use dollar quoting

- modernize SQL

    • -9
    • +17
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
  1. … 2 more files in changeset.
- fix partial SQL edit

    • -18
    • +17
    ./postgresql/faq-package-create.sql
missing ';'.

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

    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  1. … 1 more file in changeset.
- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

    • -45
    • +92
    ./postgresql/faq-package-create.sql
  1. … 21 more files in changeset.
Merged oacs-5-3 branch to HEAD

    • -0
    • +10
    ./postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
  1. … 184 more files in changeset.
file faq-sc-create.sql was initially added on branch oacs-5-3.

    • -0
    • +0
    ./postgresql/faq-sc-create.sql
file upgrade-5.2.0d4-5.2.0d5.sql was initially added on branch oacs-5-3.

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

    • -0
    • +10
    ./postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
  1. … 1 more file 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.

Renamed a mis-named variable.

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

    • -0
    • +217
    ./oracle/faq-package-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -0
    • +171
    ./postgresql/faq-package-create.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  1. … 3 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -0
    • +45
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
  1. … 33 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

    • -0
    • +45
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
file upgrade-4.0-4.6.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

  1. … 38 more files in changeset.
merge from oacs-4-6

    • -0
    • +212
    ./oracle/upgrade/upgrade-4.0-4.6.sql
  1. … 101 more files in changeset.
file upgrade-4.0-4.6.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./oracle/upgrade/upgrade-4.0-4.6.sql
- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

    • -0
    • +212
    ./oracle/upgrade/upgrade-4.0-4.6.sql
  1. … 30 more files in changeset.
adds disabled_p to table faqs (used by dotlrn)