OpenACS / openacs-4 / packages / notifications / sql / postgresql

notifications-core-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

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

gustafn

Added index on foreign key columns

Options
    • -1
    • +3
    ./notifications-core-create.sql
  2. … 4 more files 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
  2. … 4 more files in changeset.
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -40
    • +40
    ./notifications-core-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
    • -40
    • +40
    ./notifications-core-create.sql
  2. … 5 more files in changeset.
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
    ./notifications-core-create.sql
  2. … 10 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
    ./notifications-core-create.sql
  2. … 2478 more files in changeset.
Thursday 22 Sep 2005
10:15 am

maltes

I18N of notifications

Options
    • -11
    • +11
    ./notifications-core-create.sql
  2. … 4 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
    ./notifications-core-create.sql
  2. … 138 more files 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
  2. … 2 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
    ./notifications-core-create.sql
  2. … 598 more files in changeset.
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
  2. … 3 more files in changeset.
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
    • -73
    • +67
    ./notifications-core-create.sql
  2. … 816 more files in changeset.
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
    • -72
    • +66
    ./notifications-core-create.sql
  2. … 27 more files in changeset.
Saturday 17 May 2003
12:47 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -3
    • +12
    ./notifications-core-create.sql
  2. … 41 more files in changeset.
Wednesday 05 Mar 2003
4:02 pm

lars

Upgrade to 4.6.2: Notifications extensions - dynamic notifications recipients.

Options
    • -2
    • +3
    ./notifications-core-create.sql
  2. … 20 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

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

Options
    • -3
    • +3
    ./notifications-core-create.sql
  2. … 39 more files in changeset.
Tuesday 25 Feb 2003
11:05 am

lars

Added support for dynamic notifications

Options
    • -2
    • +3
    ./notifications-core-create.sql
  2. … 32 more files in changeset.
Saturday 01 Feb 2003
1:14 am

jeffd

adds indexes for foreign keys, bumps to version 0.4d, upgrade scripts added

Options
    • -1
    • +10
    ./notifications-core-create.sql
  2. … 8 more files in changeset.
Thursday 16 Jan 2003
2:48 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -3
    • +5
    ./notifications-core-create.sql
  2. … 56 more files in changeset.
Friday 06 Dec 2002
10:03 pm

donb

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.

Options
    • -3
    • +5
    ./notifications-core-create.sql
  2. … 9 more files in changeset.
Friday 20 Sep 2002
11:18 pm

jeffd

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.

Options
    • -2
    • +2
    ./notifications-core-create.sql
  2. … 15 more files in changeset.
Friday 09 Aug 2002
10:51 pm

yon

copyright OpenForce -> MIT

Options
    • -2
    • +2
    ./notifications-core-create.sql
  2. … 113 more files in changeset.
Tuesday 25 Jun 2002
8:58 pm

ben

merged

Options
    • -2
    • +8
    ./notifications-core-create.sql
  2. … 11 more files in changeset.
12:12 am

yon

fixed some defaults

Options
    • -10
    • +15
    ./notifications-core-create.sql
  2. … 1 more file in changeset.
Wednesday 12 Jun 2002
3:53 pm

yon

fixing postgres port

Options
    • -59
    • +88
    ./notifications-core-create.sql
  2. … 8 more files in changeset.
Wednesday 05 Jun 2002
12:53 am

yon

adding "on delete cascade" clauses where appropriate

Options
    • -162
    • +175
    ./notifications-core-create.sql
  2. … 4 more files in changeset.
Saturday 01 Jun 2002
9:04 pm

ben

begun PG port

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