• last updated 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
PG 9.0 compatibility. Avoiding fetching next value of sequences using a view.

    • -0
    • +135
    ./postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
  1. … 4 more files in changeset.
Forgot to add my upgrade scripts ...

    • -0
    • +205
    ./oracle/upgrade/upgrade-5.5.1d1-5.6.0d1.sql
    • -0
    • +207
    ./postgresql/upgrade/upgrade-5.5.1d1-5.6.0d1.sql
Changed to use richtext and a bit of other clean-up. Tested news item create,

edit, upload from file, notifications, rss, view, admin view, etc for PG. Testing

for Oracle is next and if bugs are found, there will be a commit soon.

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

    • -32
    • +15
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
    • -9
    • +18
    ./postgresql/news-package-create.sql
    • -0
    • +76
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  1. … 2471 more files in changeset.
Fix for news__clone plsql, added lead var for news__new

    • -0
    • +76
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  1. … 1 more file in changeset.
file upgrade-5.2.0d5-5.2.0d6.sql was initially added on branch oacs-5-2.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
lead column created by create_attribute, no need to modify column manually

cr_news.lead column allready exists so we just change its size to varchar2 4000

Fix another missing comma!

Add missing comma

commit to OACS-5-2 merge of changes on OACS-5-1

(using tag vg-merge-dotlrn-2-1-20050922) for packages under dotlrn-all

    • -32
    • +15
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
  1. … 9 more files in changeset.
Additional fixes to news__clone - incorrect call to news__new and sql fixes

    • -8
    • +15
    ./postgresql/news-package-create.sql
fix misnamed variable

now made ambiguous by acs_objects.title

Updated the plsql which was out of date. No using the news-create.sql v1.8.4.1 code.

    • -32
    • +15
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
make getting url work for item_id when > 1 rev, make revision_set_active denormalize the title to acs_objects

    • -12
    • +16
    ./postgresql/news-package-create.sql
    • -0
    • +27
    ./postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
  1. … 1 more file in changeset.
add the upgrade script, make news__url work for item or revision

    • -0
    • +128
    ./postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
  1. … 2 more files in changeset.
make search rss support work, make nice urls work, propigate title to acs_objects

    • -30
    • +36
    ./postgresql/news-package-create.sql
  1. … 12 more files in changeset.
add lead and associated image to news story, clean up markup some, break package, views out from create.sql

    • -0
    • +578
    ./oracle/news-package-create.sql
    • -0
    • +206
    ./oracle/news-views-create.sql
    • -0
    • +8
    ./oracle/news-views-drop.sql
    • -0
    • +796
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -0
    • +505
    ./postgresql/news-package-create.sql
    • -0
    • +7
    ./postgresql/news-package-drop.sql
    • -0
    • +217
    ./postgresql/news-views-create.sql
    • -0
    • +8
    ./postgresql/news-views-drop.sql
    • -0
    • +388
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  1. … 40 more files in changeset.
file news-sc-create.sql was added on branch oacs-5-2 on 2005-09-26 09:08:49 +0000

file news-sc-drop.sql was added on branch oacs-5-2 on 2005-09-26 09:08:49 +0000

bind the news contracts with a tcl spec

  1. … 2 more files in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2274 more files in changeset.
Applied patch #614. Hope these kind of patches are immediately commited, safes some work....

drop news plpgsql with drop_package, no need to drop attributes individually, just drop the content type

various bug fixes for package_id, title addition to acs_objects

  1. … 12 more files in changeset.
Added view news_items_live_or_submitted to upgrade script.

Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +588
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
  1. … 23 more files in changeset.
fixing bug 240 - internationalization of news publish status. Making the PLSQL function news_status return only a short name status instead of human readable text. Instead generating human readable text from new Tcl proc news_pretty_status. Bumping version number to 5.0d1. Providing an automated test covering both functions.

    • -0
    • +673
    ./oracle/upgrade/upgrade-4.6-5.0d1.sql
    • -0
    • +145
    ./postgresql/upgrade/upgrade-4.6-5.0d1.sql
  1. … 7 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. … 274 more files in changeset.