• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
It's "sysdate", not "sysdate()", folks :)

    • -0
    • +28
    ./upgrade/upgrade-5.4.0d2-5.4.0d3.sql
  1. … 1 more file in changeset.
Adding support for oracle for the upgrade to 5.4.0d3 which allows for file attachments

    • -0
    • +56
    ./upgrade/upgrade-5.4.0d2-5.4.0d3.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.
Applying patch 587 for bug 1973: on delete cascade for

notifications/notification_requests acs_objects

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040712 and jcd-merge-5-1-20040724 to HEAD

    • -0
    • +115
    ./upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +25
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  1. … 136 more files in changeset.
Forgot upgade scripts for previous commit, which added new function delete_all_for_user

    • -0
    • +115
    ./upgrade/upgrade-5.0.0b4-5.1.0d2.sql
  1. … 1 more file in changeset.
file upgrade-5.0.0b4-5.1.0d2.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./upgrade/upgrade-5.0.0b4-5.1.0d2.sql
  1. … 1 more file in changeset.
adds on delete cascade to fk constraints for notifications and notification_requests

    • -0
    • +25
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  1. … 1 more file in changeset.
file upgrade-5.1.0d2-5.1.0d3.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  1. … 1 more file in changeset.
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.
fix from Sloan: proc to delete all notifications for a user, which will be used later when we have callbacks to call things like this when we delete a user from core

  1. … 4 more files in changeset.
merge of changes between oacs-5-0-0b4 and oacs-5-0-0-final to HEAD

    • -0
    • +404
    ./upgrade/upgrade-4.6.4-5.0d1.sql
  1. … 286 more files in changeset.
delete--> del upgrade

    • -0
    • +404
    ./upgrade/upgrade-4.6.4-5.0d1.sql
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

    • -5
    • +6
    ./notifications-replies-extra-create.sql
  1. … 595 more files in changeset.
fix inconsistency between notifications-replies-extra-create and upgrade scripts, hopefully this finally fixed 1231

    • -1
    • +1
    ./notifications-replies-extra-create.sql
  1. … 1 more file in changeset.
no need to drop table if you are just changing a constraint.

  1. … 1 more file in changeset.
use clobs for to_addr, headers, body; fix load_qmail_mail_queue.holdinsert query, fix upgrade script, make constriant names conform to standards. Fixes bug 1231

  1. … 3 more files in changeset.
text datatype should be clob for oracle

    • -5
    • +6
    ./notifications-replies-extra-create.sql
making notifications cascade when acs objects are deleted, see bug 260

  1. … 2 more files in changeset.
file upgrade-5.0.0a5-5.0.0a6.sql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  1. … 1 more file in changeset.

o notifications fixes have been completed.

o needed fixes in lt_format_time and html-email-procs.

o Oracle bits /should/ work but are untested at this time.

    • -0
    • +1
    ./notifications-replies-extra-create.sql
    • -486
    • +8
    ./upgrade/upgrade-4.6.4-5.0d1.sql
  1. … 4 more files in changeset.

o updated create/drop scripts

o removed debug statement

o correct param documentation of bounce_mail_message

  1. … 3 more files in changeset.

Added bounce messages for improperly addressed emails and for emails

from unauthorized senders.

Messages follow the qmail-send Bounce Messages Format (QDBMF)

http://cr.yp.to/proto/qsbmf.txt

Added a notification_email_hold table to hold possible bounce messages

until they are accepted by the system.

    • -0
    • +7
    ./notifications-replies-extra-create.sql
    • -0
    • +1
    ./notifications-replies-extra-drop.sql
  1. … 6 more files in changeset.
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +486
    ./upgrade/upgrade-4.6.4-5.0d1.sql
  1. … 23 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)

    • -23
    • +23
    ./notifications-package-create.sql
    • -4
    • +4
    ./notifications-replies-package-create.sql
  1. … 273 more files in changeset.
Applied patch #123: Added dropping of these objects and permissions removal. This should be rolled into acs_object.delete, but if this makes dropping work, that's better than nothing

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

  1. … 809 more files in changeset.
Forgot to remove the call to notification-type-sc-create.sql. Can't believe I didn't catch this in my fresh-install test

  1. … 1 more file in changeset.
Added support for notifications going out as the user who sent the notification. This required changing the delivery method service contract, so I moved all service contracts into tcl

  1. … 20 more files in changeset.
file upgrade-4.6.2-4.6.4.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-4.6.2-4.6.4.sql
  1. … 1 more file in changeset.