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: 23 Dec
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 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./oracle/notifications-core-create.sql
    • -0
    • +0
    ./postgresql/notifications-core-create.sql
  3. … 1463 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -2
    • +3
    ./oracle/notifications-core-create.sql
    • -0
    • +5
    ./oracle/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
    • -1
    • +3
    ./postgresql/notifications-core-create.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  6. … 8095 more files in changeset.
Friday 06 Nov 2020
4:51 pm

antoniop

file upgrade-5.10.0d6-5.10.0d7.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
Sunday 12 Apr 2020
10:57 am

gustafn

file upgrade-5.10.0d4-5.10.0d5.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
Friday 02 Nov 2018
10:37 am

gustafn

Delete from duplicated notification request entries before trying to add the unique constraint to deal with broken data

Options
    • -0
    • +21
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
Wednesday 03 Oct 2018
11:11 am

gustafn

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

Options
    • -8
    • +10
    ./oracle/notifications-core-create.sql
    • -0
    • +4
    ./oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
    • -8
    • +10
    ./postgresql/notifications-core-create.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  5. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -2
    • +2
    ./oracle/notifications-core-create.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  4. … 7832 more files in changeset.
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -25
    • +28
    ./postgresql/notifications-package-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  3. … 2546 more files in changeset.
Saturday 30 Aug 2014
6:47 pm

gustafn

file upgrade-5.8.1d3-5.8.1d4.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  2. … 1 more file in changeset.
Sunday 31 Mar 2013
6:31 pm

gustafn

- fix $$ quoting in upgrade scripts

Options
    • -28
    • +15
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
    • -30
    • +15
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
  3. … 1 more file in changeset.
Saturday 30 Mar 2013
11:01 pm

gustafn

- update postgres function to modern style plpgsql definitions using dollar quoting

Options
    • -53
    • +29
    ./postgresql/notifications-package-create.sql
    • -18
    • +17
    ./postgresql/notifications-replies-package-create.sql
7:50 pm

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -9
    • +9
    ./postgresql/notifications-core-drop.sql
    • -96
    • +153
    ./postgresql/notifications-package-create.sql
    • -5
    • +5
    ./postgresql/notifications-replies-drop.sql
    • -3
    • +5
    ./postgresql/notifications-replies-package-create.sql
    • -7
    • +16
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
    • -1
    • +2
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
    • -7
    • +16
    ./postgresql/upgrade/upgrade-0.4d-4.6.1.sql
    • -1
    • +2
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
    • -20
    • +26
    ./postgresql/upgrade/upgrade-4.6.2-4.6.4.sql
    • -8
    • +17
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -7
    • +13
    ./postgresql/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -9
    • +18
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
    • -21
    • +27
    ./postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
  14. … 7 more files in changeset.
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -1
    • +1
    ./oracle/notifications-replies-extra-create.sql
    • -40
    • +40
    ./postgresql/notifications-core-create.sql
    • -1
    • +1
    ./postgresql/notifications-replies-extra-create.sql
  4. … 281 more files in changeset.
Tuesday 15 Jan 2008
7:29 pm

donb

It's "sysdate", not "sysdate()", folks :)

Options
    • -0
    • +1
    ./oracle/notifications-package-create.sql
    • -0
    • +28
    ./oracle/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
  3. … 1 more file in changeset.
Thursday 28 Jun 2007
7:23 pm

matthewg

Adding support for oracle for the upgrade to 5.4.0d3 which allows for file attachments

Options
    • -2
    • +3
    ./oracle/notifications-core-create.sql
    • -2
    • +3
    ./oracle/notifications-package-create.sql
    • -0
    • +56
    ./oracle/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
Wednesday 27 Jun 2007
8:54 pm

matthewg

Adding support for file attachments via file_ids in the notifications table, includes sql upgrade scripts and bumps the version to 5.4.0d3

Options
    • -2
    • +3
    ./postgresql/notifications-core-create.sql
    • -8
    • +10
    ./postgresql/notifications-package-create.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
  4. … 8 more files in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

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

Options
    • -11
    • +11
    ./postgresql/notifications-core-create.sql
    • -2
    • +2
    ./postgresql/notifications-replies-create.sql
  3. … 2477 more files in changeset.
Thursday 13 Jan 2005
2:54 pm

jeffd

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

Options
    • -3
    • +3
    ./oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  2. … 2275 more files in changeset.
Saturday 24 Jul 2004
10:33 am

jeffd

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

Options
    • -0
    • +2
    ./oracle/notifications-core-create.sql
    • -0
    • +115
    ./oracle/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +25
    ./oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
    • -0
    • +2
    ./postgresql/notifications-core-create.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +53
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  7. … 133 more files in changeset.
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: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.
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.
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.
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.
Monday 24 Nov 2003
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.