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

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 25 Dec
Commits this week: 0
Total Lines of Code (LoC): 428
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
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
    • +11
    ./upgrade/upgrade-2.10.0d1-2.10.0d2.sql
    • -0
    • +19
    ./upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  4. … 8097 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
    ./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
    ./bulk-mail-create.sql
    • -0
    • +19
    ./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
    • +11
    ./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
    • -1
    • +2
    ./bulk-mail-create.sql
    • -0
    • +4
    ./upgrade/upgrade-2.10.0d0-2.10.0d1.sql
  3. … 3 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
    • -2
    • +2
    ./bulk-mail-create.sql
  2. … 2478 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
    ./bulk-mail-create.sql
  2. … 2 more files 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
    • +4
    ./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
    ./upgrade/upgrade-0.5.1d1-0.5.1d2.sql
4:51 pm

janine

named upgrade script incorrectly on the first try

Options
    • -4
    • +0
    ./upgrade/upgrade-0.5-0.5d1.sql
    • -0
    • +4
    ./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
    ./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
    ./upgrade/upgrade-0.5-0.5d1.sql
  2. … 1 more file in changeset.
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
    ./bulk-mail-package-create.sql
    • -3
    • +3
    ./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
    ./upgrade/upgrade-0.4-0.5.sql
  2. … 23 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -2
    • +2
    ./bulk-mail-drop.sql
    • -6
    • +6
    ./bulk-mail-package-create.sql
  3. … 274 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
    • -7
    • +7
    ./bulk-mail-create.sql
    • -4
    • +4
    ./bulk-mail-package-create.sql
    • -2
    • +3
    ./bulk-mail-views-create.sql
    • -0
    • +7
    ./upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +42
    ./upgrade/upgrade-0.3-0.4.sql
  6. … 812 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
    • -7
    • +7
    ./bulk-mail-create.sql
    • -5
    • +5
    ./bulk-mail-package-create.sql
    • -3
    • +4
    ./bulk-mail-views-create.sql
    • -0
    • +42
    ./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.
Wednesday 11 Jun 2003
12:37 pm

yon

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

Options
    • -0
    • +0
    ./upgrade/upgrade-0.1a-0.2.sql
  2. … 1 more file in changeset.
12:35 pm

yon

modified query column to be of type clob for oracle and type text for

postgresql.

Options
    • -2
    • +2
    ./bulk-mail-create.sql
    • -0
    • +7
    ./upgrade/upgrade-0.1a-0.2.sql
  3. … 3 more files in changeset.
Thursday 16 May 2002
12:07 am

yon

initial version of a simple bulk mail service that supports variable interpolation

Options
    • -0
    • +0
    ./bulk-mail-create.sql
    • -0
    • +0
    ./bulk-mail-drop.sql
    • -0
    • +0
    ./bulk-mail-package-create.sql
    • -0
    • +0
    ./bulk-mail-package-drop.sql
    • -0
    • +0
    ./bulk-mail-views-create.sql
    • -0
    • +0
    ./bulk-mail-views-drop.sql
  7. … 18 more files in changeset.
12:07 am

yon

Initial revision

Options
    • -0
    • +58
    ./bulk-mail-create.sql
    • -0
    • +25
    ./bulk-mail-drop.sql
    • -0
    • +110
    ./bulk-mail-package-create.sql
    • -0
    • +8
    ./bulk-mail-package-drop.sql
    • -0
    • +18
    ./bulk-mail-views-create.sql
    • -0
    • +9
    ./bulk-mail-views-drop.sql
  7. … 27 more files in changeset.