OpenACS / openacs-4 / packages / bulk-mail / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 599
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
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./bulk-mail-create.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -3
    • +4
    ./bulk-mail-create.sql
    • -0
    • +9
    ./upgrade/upgrade-2.10.0d1-2.10.0d2.sql
    • -0
    • +22
    ./upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  4. … 8097 more files in changeset.
Wednesday 10 Feb 2021
2:36 pm

antoniop

Introduce a new 'to_display_name' column enabling to specify a display name with which qualify recipients of a bulk mail as e.g. "Members of Group 1"

This is useful to inform the user about who else should be expected to have received the same communication

Options
    • -1
    • +2
    ./bulk-mail-create.sql
    • -0
    • +22
    ./upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  3. … 4 more files in changeset.
2:36 pm

antoniop

file upgrade-2.10.0d2-2.10.0d3.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  2. … 1 more file in changeset.
Thursday 30 Jul 2020
6:36 pm

antoniop

Redefine foreign keys as on delete cascade to avoid having callbacks around to delete bulk mail messages on package deletion

Options
    • -3
    • +3
    ./bulk-mail-create.sql
    • -0
    • +9
    ./upgrade/upgrade-2.10.0d1-2.10.0d2.sql
  3. … 3 more files in changeset.
6:36 pm

antoniop

file upgrade-2.10.0d1-2.10.0d2.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.10.0d1-2.10.0d2.sql
  2. … 1 more file in changeset.
Tuesday 11 Dec 2018
11:38 am

gustafn

add index for bulk mail sweeper. was already #10 on sequential reads on learn

Options
    • -2
    • +3
    ./bulk-mail-create.sql
    • -0
    • +24
    ./upgrade/upgrade-2.10.0d0-2.10.0d1.sql
  3. … 3 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
    • -14
    • +14
    ./bulk-mail-create.sql
    • -7
    • +8
    ./bulk-mail-drop.sql
    • -33
    • +53
    ./bulk-mail-package-create.sql
    • -32
    • +52
    ./upgrade/upgrade-0.1a-0.4.sql
    • -24
    • +38
    ./upgrade/upgrade-0.5.2d1-0.5.2d2.sql
    • -0
    • +2
    ./upgrade/upgrade-2.8.1d2-2.8.1a1.sql
  7. … 2542 more files in changeset.
Thursday 11 Sep 2014
4:00 pm

victorg

Removing function's name prefix from parameter's names.

Options
    • -3
    • +3
    ./bulk-mail-package-create.sql
    • -3
    • +3
    ./upgrade/upgrade-0.1a-0.4.sql
    • -2
    • +2
    ./upgrade/upgrade-0.5.2d1-0.5.2d2.sql
    • -1
    • +2
    ./upgrade/upgrade-2.8.1d2-2.8.1a1.sql
2:42 pm

victorg

Fixing defaults for parameters of bulk_mail__new plpgsql function.

Options
    • -2
    • +2
    ./bulk-mail-package-create.sql
    • -2
    • +2
    ./upgrade/upgrade-0.1a-0.4.sql
    • -2
    • +2
    ./upgrade/upgrade-0.5.2d1-0.5.2d2.sql
    • -0
    • +1
    ./upgrade/upgrade-2.8.1d2-2.8.1a1.sql
2:42 pm

victorg

file upgrade-2.8.1d2-2.8.1a1.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.8.1d2-2.8.1a1.sql
Friday 05 Sep 2014
6:27 pm

gustafn

- fix broken drop script

Options
    • -5
    • +5
    ./bulk-mail-drop.sql
  2. … 1 more file in changeset.
Monday 18 Aug 2014
10:54 pm

gustafn

- modernize SQL (dollar quoting, named arguments, fix and complete function_args)

Options
    • -14
    • +14
    ./bulk-mail-create.sql
    • -3
    • +4
    ./bulk-mail-drop.sql
    • -33
    • +53
    ./bulk-mail-package-create.sql
    • -33
    • +53
    ./upgrade/upgrade-0.1a-0.4.sql
    • -24
    • +38
    ./upgrade/upgrade-0.5.2d1-0.5.2d2.sql
Wednesday 01 Apr 2009
5:00 pm

emmar

Provide upgrade script for bug 3103

Options
    • -0
    • +69
    ./upgrade/upgrade-0.5.2d1-0.5.2d2.sql
  2. … 1 more file in changeset.
Friday 27 Mar 2009
11:55 pm

ryang

bug #3103 change to_date to to_timestamp in bulk_mail__new function

Options
    • -2
    • +2
    ./bulk-mail-package-create.sql
Tuesday 08 Aug 2006
11:26 pm

donb

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

Options
    • -1
    • +3
    ./bulk-mail-create.sql
    • -0
    • +4
    ./upgrade/upgrade-0.5.1d1-0.5.1d2.sql
  3. … 2477 more files in changeset.
Thursday 30 Jun 2005
12:08 am

donb

1. Oracle bulk-mail-create.sql did not agree with the 5.1d2 upgrade script (made it so)

2. PG didn't have the contraint, added it to bulk-mail-create.sql and made and

tested an upgrade script.

Thanks to Richard Hamilton for uncovering this discrepancy.

Options
    • -1
    • +3
    ./bulk-mail-create.sql
    • -0
    • +4
    ./upgrade/upgrade-0.5.1d1-0.5.1d2.sql
  3. … 1 more file in changeset.
12:08 am

donb

file upgrade-0.5.1d1-0.5.1d2.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.5.1d1-0.5.1d2.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
    • -1
    • +3
    ./bulk-mail-package-create.sql
  2. … 2275 more files in changeset.
Tuesday 21 Dec 2004
10:58 am

darior

Added forgotten return to bulk_mail__delete plsql postgres function

Options
    • -1
    • +3
    ./bulk-mail-package-create.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
    • -72
    • +0
    ./upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +181
    ./upgrade/upgrade-0.1a-0.4.sql
    • -72
    • +0
    ./upgrade/upgrade-0.2-0.3.sql
    • -38
    • +0
    ./upgrade/upgrade-0.3-0.4.sql
  5. … 290 more files in changeset.
Tuesday 03 Feb 2004
6:51 pm

lars

Replaced 3 defunct upgrade scripts with one new upgrade script that works

Options
    • -72
    • +0
    ./upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +181
    ./upgrade/upgrade-0.1a-0.4.sql
    • -72
    • +0
    ./upgrade/upgrade-0.2-0.3.sql
    • -38
    • +0
    ./upgrade/upgrade-0.3-0.4.sql
6:51 pm

lars

file upgrade-0.1a-0.4.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.1a-0.4.sql
Tuesday 30 Sep 2003
2:10 pm

peterm

making upgrade scripts of bulk-mail work with PG 7.2

Options
    • -9
    • +68
    ./upgrade/upgrade-0.1a-0.2.sql
    • -9
    • +69
    ./upgrade/upgrade-0.2-0.3.sql
Wednesday 24 Sep 2003
1:30 am

lars

Added define_function_args: bug #55

Options
    • -0
    • +3
    ./upgrade/upgrade-0.2-0.3.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
    • -3
    • +8
    ./bulk-mail-create.sql
    • -9
    • +9
    ./bulk-mail-package-create.sql
    • -2
    • +2
    ./bulk-mail-views-create.sql
    • -0
    • +13
    ./upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +9
    ./upgrade/upgrade-0.2-0.3.sql
    • -0
    • +38
    ./upgrade/upgrade-0.3-0.4.sql
  7. … 811 more files in changeset.
Monday 23 Jun 2003
9:44 pm

janines

changes to support outgoing HTML e-mail from bulk mail, incoming HTML email to forums, and prevent MIT's vacation messages from making it into forums

Options
    • -1
    • +6
    ./bulk-mail-create.sql
    • -9
    • +9
    ./bulk-mail-package-create.sql
    • -3
    • +3
    ./bulk-mail-views-create.sql
    • -0
    • +38
    ./upgrade/upgrade-0.3-0.4.sql
  5. … 13 more files in changeset.
9:44 pm

janines

file upgrade-0.3-0.4.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.3-0.4.sql
  2. … 1 more file in changeset.
Thursday 12 Jun 2003
5:37 pm

yon

send_date needs to be timestamptz

Options
    • -2
    • +2
    ./bulk-mail-create.sql
    • -0
    • +9
    ./upgrade/upgrade-0.2-0.3.sql
  3. … 1 more file in changeset.
5:37 pm

yon

file upgrade-0.2-0.3.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.2-0.3.sql