OpenACS / openacs-4 / packages / notifications

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 21
Last Commit: 21 Nov
Commits this week: 0
Total Lines of Code (LoC): 3,578
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 20 Jul 2004
4:37 pm

janine

file upgrade-5.0.0b4-5.1.0d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
Thursday 15 Jul 2004
3:04 am

skaufman

adds on delete cascade to fk constraints for notifications and notification_requests

Options
    • -1
    • +3
    ./oracle/notifications-core-create.sql
    • -0
    • +25
    ./oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
    • -1
    • +3
    ./postgresql/notifications-core-create.sql
3:00 am

skaufman

adds on delete cascade to fk constraints of notifications and notification_requests

Options
    • -0
    • +53
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
3:00 am

skaufman

file upgrade-5.1.0d2-5.1.0d3.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
Tuesday 29 Jun 2004
12:17 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

Options
    • -0
    • +19
    ./oracle/notifications-package-create.sql
    • -0
    • +19
    ./postgresql/notifications-package-create.sql
  3. … 686 more files in changeset.
Thursday 17 Jun 2004
11:11 pm

janine

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

Options
    • -0
    • +19
    ./oracle/notifications-package-create.sql
    • -0
    • +19
    ./postgresql/notifications-package-create.sql
  3. … 3 more files in changeset.
Monday 08 Mar 2004
1:34 pm

maltes

Notification Replies where not dropped.

Options
    • -0
    • +1
    ./postgresql/notifications-drop.sql
    • -0
    • +16
    ./postgresql/notifications-replies-drop.sql
Thursday 26 Feb 2004
4:28 pm

jeffd

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

Options
    • -7
    • +7
    ./postgresql/upgrade/upgrade-4.6.4-5.0d1.sql
    • -2
    • +30
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  3. … 292 more files in changeset.
Wednesday 04 Feb 2004
11:57 am

lars

Implemented a safe way to delete constraints, as these constraints didn't exist. It's most likely got to do with the PG upgrade from 7.2 to 7.3 not recording constraints properly. This is a workaround, not a fix. See bug #1294.

Options
    • -2
    • +30
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
11:53 am

lars

Untabify

Options
    • -7
    • +7
    ./postgresql/upgrade/upgrade-4.6.4-5.0d1.sql
Monday 26 Jan 2004
4:39 pm

jeffd

merge of changes between oacs-5-0-0b4 and oacs-5-0-0-final to HEAD

Options
    • -0
    • +404
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
  2. … 286 more files in changeset.
Tuesday 30 Dec 2003
6:48 am

tracya

delete--> del upgrade

Options
    • -0
    • +404
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -1
    • +2
    ./oracle/notifications-core-create.sql
    • -5
    • +6
    ./oracle/notifications-replies-extra-create.sql
    • -5
    • +6
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
    • -0
    • +8
    ./oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -1
    • +2
    ./postgresql/notifications-core-create.sql
    • -2
    • +3
    ./postgresql/notifications-replies-extra-create.sql
    • -3
    • +4
    ./postgresql/upgrade/upgrade-4.6.4-5.0d1.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  9. … 591 more files in changeset.
Thursday 04 Dec 2003
8:44 am

jeffd

fix inconsistency between notifications-replies-extra-create and upgrade scripts, hopefully this finally fixed 1231

Options
    • -1
    • +1
    ./oracle/notifications-replies-extra-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
    • -3
    • +4
    ./postgresql/upgrade/upgrade-4.6.4-5.0d1.sql
Tuesday 02 Dec 2003
11:45 am

peterm

no need to drop table if you are just changing a constraint.

Options
    • -2
    • +4
    ./oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -42
    • +11
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
Friday 28 Nov 2003
3:52 pm

jeffd

the upgrade failed because notification_user_map constraint notif_user_map_notif_id_fk needed the pk on notifications_bak, now drops it and recreates it after the table is reloaded

Options
    • -0
    • +4
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
Thursday 27 Nov 2003
11:46 am

jeffd

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

Options
    • -5
    • +6
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
    • -2
    • +3
    ./postgresql/notifications-replies-extra-create.sql
  3. … 2 more files in changeset.
Wednesday 26 Nov 2003
6:11 pm

jeffd

text datatype should be clob for oracle

Options
    • -5
    • +6
    ./oracle/notifications-replies-extra-create.sql
Monday 24 Nov 2003
7:51 pm

peterm

making notifications cascade when acs objects are deleted, see bug 260

Options
    • -2
    • +3
    ./oracle/notifications-core-create.sql
    • -0
    • +6
    ./oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -2
    • +3
    ./postgresql/notifications-core-create.sql
    • -0
    • +42
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
7:51 pm

peterm

file upgrade-5.0.0a5-5.0.0a6.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
Thursday 06 Nov 2003
8:23 pm

matk

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.

Options
    • -0
    • +1
    ./oracle/notifications-replies-extra-create.sql
    • -486
    • +8
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
    • -0
    • +1
    ./postgresql/notifications-replies-extra-create.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-4.6.4-5.0d1.sql
  5. … 2 more files in changeset.
5:44 pm

matk

o updated create/drop scripts

o removed debug statement

o correct param documentation of bounce_mail_message

Options
    • -2
    • +2
    ./oracle/notifications-create.sql
    • -0
    • +1
    ./postgresql/notifications-create.sql
    • -0
    • +1
    ./postgresql/notifications-drop.sql
  4. … 1 more file in changeset.
3:28 pm

matk

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.

Options
    • -0
    • +7
    ./oracle/notifications-replies-extra-create.sql
    • -0
    • +1
    ./oracle/notifications-replies-extra-drop.sql
    • -0
    • +7
    ./postgresql/notifications-replies-extra-create.sql
    • -0
    • +1
    ./postgresql/notifications-replies-extra-drop.sql
  5. … 4 more files in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

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

Options
    • -0
    • +486
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
  2. … 23 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

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)

Options
    • -2
    • +2
    ./oracle/notifications-core-drop.sql
    • -23
    • +23
    ./oracle/notifications-package-create.sql
    • -4
    • +4
    ./oracle/notifications-replies-package-create.sql
  4. … 273 more files in changeset.
Monday 22 Sep 2003
10:56 pm

lars

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

Options
    • -1
    • +37
    ./oracle/notifications-core-drop.sql
Thursday 28 Aug 2003
11:41 am

lars

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

Options
    • -68
    • +0
    ./oracle/delivery-method-sc-create.sql
    • -61
    • +0
    ./oracle/email-sc-impl-create.sql
    • -68
    • +0
    ./oracle/notification-type-sc-create.sql
    • -2
    • +5
    ./oracle/notifications-core-create.sql
    • -8
    • +2
    ./oracle/notifications-create.sql
    • -10
    • +1
    ./oracle/notifications-init.sql
    • -2
    • +4
    ./oracle/notifications-package-create.sql
    • -0
    • +99
    ./oracle/upgrade/upgrade-4.6.2-4.6.4.sql
    • -72
    • +0
    ./postgresql/delivery-method-sc-create.sql
    • -67
    • +0
    ./postgresql/email-sc-impl-create.sql
    • -73
    • +0
    ./postgresql/notification-type-sc-create.sql
    • -73
    • +67
    ./postgresql/notifications-core-create.sql
    • -8
    • +0
    ./postgresql/notifications-create.sql
    • -53
    • +29
    ./postgresql/notifications-init.sql
    • -11
    • +12
    ./postgresql/notifications-package-create.sql
  16. … 802 more files in changeset.
Tuesday 17 Jun 2003
9:19 am

lars

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

Options
    • -2
    • +0
    ./oracle/notifications-create.sql
    • -2
    • +0
    ./postgresql/notifications-create.sql
Thursday 12 Jun 2003
3:34 pm

lars

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

Options
    • -68
    • +0
    ./oracle/delivery-method-sc-create.sql
    • -61
    • +0
    ./oracle/email-sc-impl-create.sql
    • -68
    • +0
    ./oracle/notification-type-sc-create.sql
    • -1
    • +4
    ./oracle/notifications-core-create.sql
    • -7
    • +3
    ./oracle/notifications-create.sql
    • -10
    • +1
    ./oracle/notifications-init.sql
    • -2
    • +4
    ./oracle/notifications-package-create.sql
    • -0
    • +99
    ./oracle/upgrade/upgrade-4.6.2-4.6.4.sql
    • -72
    • +0
    ./postgresql/delivery-method-sc-create.sql
    • -67
    • +0
    ./postgresql/email-sc-impl-create.sql
    • -73
    • +0
    ./postgresql/notification-type-sc-create.sql
    • -72
    • +66
    ./postgresql/notifications-core-create.sql
    • -6
    • +0
    ./postgresql/notifications-create.sql
    • -53
    • +29
    ./postgresql/notifications-init.sql
    • -11
    • +12
    ./postgresql/notifications-package-create.sql
  16. … 13 more files in changeset.
3:34 pm

lars

file upgrade-4.6.2-4.6.4.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-4.6.2-4.6.4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.6.2-4.6.4.sql