• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
file upgrade-2.10.0d2-2.10.0d3.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
Redefine foreign keys as on delete cascade to avoid having callbacks around to delete bulk mail messages on package deletion

    • -0
    • +9
    ./postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
  1. … 1 more file in changeset.
file upgrade-2.10.0d1-2.10.0d2.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
add index for bulk mail sweeper. was already #10 on sequential reads on learn

    • -0
    • +4
    ./oracle/upgrade/upgrade-2.10.0d0-2.10.0d1.sql
    • -0
    • +24
    ./postgresql/upgrade/upgrade-2.10.0d0-2.10.0d1.sql
  1. … 1 more file in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -14
    • +14
    ./postgresql/bulk-mail-create.sql
    • -33
    • +53
    ./postgresql/bulk-mail-package-create.sql
    • -32
    • +52
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -24
    • +38
    ./postgresql/upgrade/upgrade-0.5.2d1-0.5.2d2.sql
  1. … 2542 more files in changeset.
Removing function's name prefix from parameter's names.

    • -3
    • +3
    ./postgresql/bulk-mail-package-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
Fixing defaults for parameters of bulk_mail__new plpgsql function.

    • -2
    • +2
    ./postgresql/bulk-mail-package-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
file upgrade-2.8.1d2-2.8.1a1.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.8.1d2-2.8.1a1.sql
- fix broken drop script

  1. … 1 more file in changeset.
- modernize SQL (dollar quoting, named arguments, fix and complete function_args)

    • -14
    • +14
    ./postgresql/bulk-mail-create.sql
    • -33
    • +53
    ./postgresql/bulk-mail-package-create.sql
    • -33
    • +53
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -24
    • +38
    ./postgresql/upgrade/upgrade-0.5.2d1-0.5.2d2.sql
Provide upgrade script for bug 3103

    • -0
    • +69
    ./postgresql/upgrade/upgrade-0.5.2d1-0.5.2d2.sql
  1. … 1 more file in changeset.
bug #3103 change to_date to to_timestamp in bulk_mail__new function

    • -2
    • +2
    ./postgresql/bulk-mail-package-create.sql
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2476 more files in changeset.
1. Oracle bulk-mail-create.sql did not agree with the 5.1d2 upgrade script (made it so)

2. PG didn't have the contraint, added it to bulk-mail-create.sql and made and

tested an upgrade script.

Thanks to Richard Hamilton for uncovering this discrepancy.

file upgrade-0.5.1d1-0.5.1d2.sql was initially added on branch oacs-5-2.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
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
    • +3
    ./postgresql/bulk-mail-package-create.sql
  1. … 2275 more files in changeset.
Added forgotten return to bulk_mail__delete plsql postgres function

    • -1
    • +3
    ./postgresql/bulk-mail-package-create.sql
merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

  1. … 687 more files in changeset.
file upgrade-0.5.1d1-0.5.1d2.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./oracle/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
named upgrade script incorrectly on the first try

    • -4
    • +0
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
  1. … 1 more file in changeset.
file upgrade-0.5-0.5d1.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
forgot to commit upgrade script. this is a constraint change, so Oracle only

    • -0
    • +4
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
  1. … 1 more file in changeset.
merge of all changes on oacs-5-0 branch between tag openacs-5-0-0-final and jcd-merge-pre503 (except those in lars-blogger).

    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +181
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
    • -38
    • +0
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
  1. … 290 more files in changeset.
Replaced 3 defunct upgrade scripts with one new upgrade script that works

    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +181
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
    • -38
    • +0
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
file upgrade-0.1a-0.4.sql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
Fixed bug #989: Page error when requesting membership - bulk_mail_messages.query column was changed from varchar to clob

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

    • -0
    • +110
    ./oracle/upgrade/upgrade-0.4-0.5.sql
  1. … 23 more files in changeset.
making upgrade scripts of bulk-mail work with PG 7.2

    • -9
    • +68
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -9
    • +69
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
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.
Added define_function_args: bug #55

    • -0
    • +3
    ./postgresql/upgrade/upgrade-0.2-0.3.sql