OpenACS / openacs-4 / packages / bulk-mail

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 16:34
Commits this week: 0
Total Lines of Code (LoC): 1,027
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 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -3
    • +4
    ./oracle/bulk-mail-create.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
    • -0
    • +19
    ./oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
    • -3
    • +4
    ./postgresql/bulk-mail-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
    • -0
    • +22
    ./postgresql/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  7. … 8094 more files in changeset.
Saturday 12 Feb 2022
9:11 pm

gustafn

improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  2. … 8 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
    ./oracle/bulk-mail-create.sql
    • -0
    • +19
    ./oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
    • -1
    • +2
    ./postgresql/bulk-mail-create.sql
    • -0
    • +22
    ./postgresql/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  5. … 2 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
    ./oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
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
    ./oracle/bulk-mail-create.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
    • -3
    • +3
    ./postgresql/bulk-mail-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
  5. … 1 more file 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
    ./oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
Tuesday 11 Dec 2018
11:38 am

gustafn

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

Options
    • -1
    • +2
    ./oracle/bulk-mail-create.sql
    • -0
    • +4
    ./oracle/upgrade/upgrade-2.10.0d0-2.10.0d1.sql
    • -2
    • +3
    ./postgresql/bulk-mail-create.sql
    • -0
    • +24
    ./postgresql/upgrade/upgrade-2.10.0d0-2.10.0d1.sql
  5. … 1 more file 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
    ./postgresql/bulk-mail-create.sql
    • -7
    • +8
    ./postgresql/bulk-mail-drop.sql
    • -33
    • +53
    ./postgresql/bulk-mail-package-create.sql
    • -32
    • +52
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -24
    • +38
    ./postgresql/upgrade/upgrade-0.5.2d1-0.5.2d2.sql
    • -0
    • +2
    ./postgresql/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
    ./postgresql/bulk-mail-package-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.5.2d1-0.5.2d2.sql
    • -1
    • +2
    ./postgresql/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
    ./postgresql/bulk-mail-package-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.5.2d1-0.5.2d2.sql
    • -0
    • +1
    ./postgresql/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
    ./postgresql/upgrade/upgrade-2.8.1d2-2.8.1a1.sql
Friday 05 Sep 2014
6:27 pm

gustafn

- fix broken drop script

Options
    • -5
    • +5
    ./postgresql/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
    ./postgresql/bulk-mail-create.sql
    • -3
    • +4
    ./postgresql/bulk-mail-drop.sql
    • -33
    • +53
    ./postgresql/bulk-mail-package-create.sql
    • -33
    • +53
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -24
    • +38
    ./postgresql/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
    ./postgresql/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
    ./postgresql/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
    • -2
    • +2
    ./oracle/bulk-mail-create.sql
    • -1
    • +3
    ./postgresql/bulk-mail-create.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
  4. … 2476 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
    • -2
    • +2
    ./oracle/bulk-mail-create.sql
    • -1
    • +3
    ./postgresql/bulk-mail-create.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
12:08 am

donb

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

Options
    • -0
    • +0
    ./postgresql/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
    ./postgresql/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
    ./postgresql/bulk-mail-package-create.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
    • +4
    ./oracle/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
  2. … 687 more files in changeset.
Tuesday 22 Jun 2004
4:51 pm

janine

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
4:51 pm

janine

named upgrade script incorrectly on the first try

Options
    • -4
    • +0
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
    • -0
    • +4
    ./oracle/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
  3. … 1 more file in changeset.
4:13 pm

janine

file upgrade-0.5-0.5d1.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
4:13 pm

janine

forgot to commit upgrade script. this is a constraint change, so Oracle only

Options
    • -0
    • +4
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
  2. … 1 more file in changeset.
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
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +181
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
    • -38
    • +0
    ./postgresql/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
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +181
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
    • -38
    • +0
    ./postgresql/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
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
Tuesday 21 Oct 2003
11:31 pm

lars

Fixed bug #989: Page error when requesting membership - bulk_mail_messages.query column was changed from varchar to clob

Options
    • -3
    • +3
    ./oracle/bulk-mail-package-create.sql
    • -3
    • +3
    ./oracle/upgrade/upgrade-0.4-0.5.sql
Wednesday 08 Oct 2003
6:53 pm

mohanp

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

Options
    • -0
    • +110
    ./oracle/upgrade/upgrade-0.4-0.5.sql
  2. … 23 more files in changeset.