• last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Redefine foreign keys as on delete cascade to avoid having callbacks around to delete bulk mail messages on package deletion

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

    • -0
    • +0
    ./upgrade/upgrade-2.10.0d1-2.10.0d2.sql
  1. … 1 more file in changeset.
add index for bulk mail sweeper. was already #10 on sequential reads on learn

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

    • -24
    • +38
    ./upgrade/upgrade-0.5.2d1-0.5.2d2.sql
  1. … 2542 more files in changeset.
Removing function's name prefix from parameter's names.

Fixing defaults for parameters of bulk_mail__new plpgsql function.

file upgrade-2.8.1d2-2.8.1a1.sql was initially added on branch oacs-5-8.

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

    • -24
    • +38
    ./upgrade/upgrade-0.5.2d1-0.5.2d2.sql
Provide upgrade script for bug 3103

    • -0
    • +69
    ./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

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2477 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.

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

    • -0
    • +0
    ./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. … 2275 more files in changeset.
Added forgotten return to bulk_mail__delete plsql postgres function

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).

  1. … 290 more files in changeset.
Replaced 3 defunct upgrade scripts with one new upgrade script that works

file upgrade-0.1a-0.4.sql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./upgrade/upgrade-0.1a-0.4.sql
making upgrade scripts of bulk-mail work with PG 7.2

Added define_function_args: bug #55

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

  1. … 811 more files in changeset.
changes to support outgoing HTML e-mail from bulk mail, incoming HTML email to forums, and prevent MIT's vacation messages from making it into forums

  1. … 13 more files in changeset.
file upgrade-0.3-0.4.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-0.3-0.4.sql
  1. … 1 more file in changeset.
send_date needs to be timestamptz

  1. … 1 more file in changeset.
file upgrade-0.2-0.3.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-0.2-0.3.sql
file upgrade-0.1a-0.2.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-0.1a-0.2.sql
  1. … 1 more file in changeset.
modified query column to be of type clob for oracle and type text for

postgresql.

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

  1. … 75 more files in changeset.
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. … 52 more files in changeset.