OpenACS / openacs-4 / packages / notifications / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 08 May
Commits this week: 0
Total Lines of Code (LoC): 2,114
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 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 12 Apr 2020
10:57 am

gustafn

Added index on foreign key columns

Options
    • -2
    • +3
    ./notifications-core-create.sql
    • -0
    • +5
    ./upgrade/upgrade-5.10.0d4-5.10.0d5.sql
  3. … 3 more files in changeset.
10:57 am

gustafn

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.10.0d4-5.10.0d5.sql
  2. … 1 more file in changeset.
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
    ./notifications-core-create.sql
    • -0
    • +4
    ./upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  3. … 3 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -2
    • +2
    ./notifications-core-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  3. … 7833 more files in changeset.
Saturday 22 Apr 2017
1:58 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./notifications-core-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  3. … 7 more files in changeset.
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -1
    • +1
    ./notifications-replies-extra-create.sql
  2. … 283 more files in changeset.
Thursday 24 Jan 2008
6:39 pm

donb

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.

Options
    • -1
    • +1
    ./notifications-replies-extra-create.sql
  2. … 5 more files in changeset.
Tuesday 15 Jan 2008
7:29 pm

donb

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

Options
    • -0
    • +1
    ./notifications-package-create.sql
    • -0
    • +28
    ./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
    ./notifications-core-create.sql
    • -2
    • +3
    ./notifications-package-create.sql
    • -0
    • +56
    ./upgrade/upgrade-5.4.0d2-5.4.0d3.sql
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
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  2. … 2275 more files in changeset.
Friday 10 Sep 2004
1:22 am

jader

Applying patch 587 for bug 1973: on delete cascade for

notifications/notification_requests acs_objects

Options
    • -3
    • +3
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
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
    ./notifications-core-create.sql
    • -0
    • +115
    ./upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +25
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  4. … 136 more files in changeset.
Tuesday 20 Jul 2004
4:37 pm

janine

Forgot upgade scripts for previous commit, which added new function delete_all_for_user

Options
    • -0
    • +115
    ./upgrade/upgrade-5.0.0b4-5.1.0d2.sql
  2. … 1 more file in changeset.
4:37 pm

janine

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0b4-5.1.0d2.sql
  2. … 1 more file in changeset.
Thursday 15 Jul 2004
3:04 am

skaufman

adds on delete cascade to fk constraints for notifications and notification_requests

Options
    • -1
    • +3
    ./notifications-core-create.sql
    • -0
    • +25
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  3. … 1 more file in changeset.
3:00 am

skaufman

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  2. … 1 more file in changeset.
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
    ./notifications-package-create.sql
  2. … 687 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
    ./notifications-package-create.sql
  2. … 4 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
    ./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
    ./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
    ./notifications-core-create.sql
    • -5
    • +6
    ./notifications-replies-extra-create.sql
    • -5
    • +6
    ./upgrade/upgrade-4.6.4-5.0d1.sql
    • -0
    • +8
    ./upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  5. … 595 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
    ./notifications-replies-extra-create.sql
    • -1
    • +1
    ./upgrade/upgrade-4.6.4-5.0d1.sql
  3. … 1 more file in changeset.
Tuesday 02 Dec 2003
11:45 am

peterm

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

Options
    • -2
    • +4
    ./upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  2. … 1 more file in changeset.
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
    ./upgrade/upgrade-4.6.4-5.0d1.sql
  2. … 3 more files in changeset.
Wednesday 26 Nov 2003
6:11 pm

jeffd

text datatype should be clob for oracle

Options
    • -5
    • +6
    ./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
    ./notifications-core-create.sql
    • -0
    • +6
    ./upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  3. … 2 more files in changeset.
7:51 pm

peterm

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  2. … 1 more file in changeset.
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
    ./notifications-replies-extra-create.sql
    • -486
    • +8
    ./upgrade/upgrade-4.6.4-5.0d1.sql
  3. … 4 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
    ./notifications-create.sql
  2. … 3 more files 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
    ./notifications-replies-extra-create.sql
    • -0
    • +1
    ./notifications-replies-extra-drop.sql
  3. … 6 more files in changeset.