notifications-core-create.sql

  • last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Added index on foreign key columns

  1. … 4 more files in changeset.
Address issue #3358: avoid duplicate entries in notification_requests via data model, in case the check in notification::request::new for existing requests with the same type_id, object_id and user_id is somehow bypassed

  1. … 4 more files in changeset.
Merged from 5.4.2

  1. … 283 more files in changeset.
Fixed public procs without documentation blocks which caused automated tests

to fail. I even tried to write meaningful documentation in some cases.

Fixed constraint names that also caused automated test failures FOR PG ONLY.

Someone who used Oracle can fix the Oracle ones if they want.

  1. … 5 more files in changeset.
Adding support for file attachments via file_ids in the notifications table, includes sql upgrade scripts and bumps the version to 5.4.0d3

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

  1. … 2478 more files in changeset.
I18N of notifications

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

  1. … 138 more files in changeset.
adds on delete cascade to fk constraints for notifications and notification_requests

  1. … 2 more files in changeset.
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

  1. … 598 more files in changeset.
making notifications cascade when acs objects are deleted, see bug 260

  1. … 3 more files in changeset.
Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

  1. … 816 more files 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. … 27 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 41 more files in changeset.
Upgrade to 4.6.2: Notifications extensions - dynamic notifications recipients.

  1. … 20 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. … 39 more files in changeset.
Added support for dynamic notifications

  1. … 32 more files in changeset.
adds indexes for foreign keys, bumps to version 0.4d, upgrade scripts added

  1. … 8 more files in changeset.
Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

  1. … 56 more files in changeset.
1. Changed cleanup sweep interval to 15 minutes

2. Fixed broken PostgreSQL and Oracle queries that were supposed to select

notifications for deletion but rather returned all notifications if any

were ripe for deletion, causing seemingly random failure to deliver

notifications. Sloan had hacked this with a kludge to only delete

notifications older than two days but this didn't work on openacs.org,

which supports weekly summaries of notifications.

3. Changed notification::new to not insert notifications that have no

pending requests. This avoids having to waste time deleting them

afterwards.

4. Added notification_request::request_exists which returns true if

there's at least one notification request for a given object and

notification type.

5. Added a couple of indexes to speed queries that ran slow on openacs.org.

  1. … 9 more files in changeset.
Fixes from sloan

* Increase field sizes for subject

* adds a manage page

* adds a object_id redirect (object-goto.tcl)

* linking to manage page in outgoing message.

  1. … 15 more files in changeset.
copyright OpenForce -> MIT

  1. … 113 more files in changeset.
merged

  1. … 11 more files in changeset.
fixed some defaults

  1. … 1 more file in changeset.
fixing postgres port

  1. … 8 more files in changeset.
adding "on delete cascade" clauses where appropriate

    • -162
    • +175
    ./notifications-core-create.sql
  1. … 4 more files in changeset.
begun PG port

    • -0
    • +211
    ./notifications-core-create.sql
  1. … 5 more files in changeset.