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: 25 Dec
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 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Tuesday 30 Sep 2003
2:10 pm

peterm

making upgrade scripts of bulk-mail work with PG 7.2

Options
    • -9
    • +68
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -9
    • +69
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
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
    ./oracle/bulk-mail-drop.sql
    • -6
    • +6
    ./oracle/bulk-mail-package-create.sql
  3. … 274 more files in changeset.
Wednesday 24 Sep 2003
1:30 am

lars

Added define_function_args: bug #55

Options
    • -0
    • +3
    ./postgresql/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
    • -7
    • +7
    ./oracle/bulk-mail-create.sql
    • -4
    • +4
    ./oracle/bulk-mail-package-create.sql
    • -2
    • +3
    ./oracle/bulk-mail-views-create.sql
    • -0
    • +7
    ./oracle/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +42
    ./oracle/upgrade/upgrade-0.3-0.4.sql
    • -3
    • +8
    ./postgresql/bulk-mail-create.sql
    • -9
    • +9
    ./postgresql/bulk-mail-package-create.sql
    • -2
    • +2
    ./postgresql/bulk-mail-views-create.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
    • -0
    • +38
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
  12. … 806 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
    ./oracle/bulk-mail-create.sql
    • -5
    • +5
    ./oracle/bulk-mail-package-create.sql
    • -3
    • +4
    ./oracle/bulk-mail-views-create.sql
    • -0
    • +42
    ./oracle/upgrade/upgrade-0.3-0.4.sql
    • -1
    • +6
    ./postgresql/bulk-mail-create.sql
    • -9
    • +9
    ./postgresql/bulk-mail-package-create.sql
    • -3
    • +3
    ./postgresql/bulk-mail-views-create.sql
    • -0
    • +38
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
  9. … 9 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
    ./oracle/upgrade/upgrade-0.3-0.4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
Thursday 12 Jun 2003
5:37 pm

yon

send_date needs to be timestamptz

Options
    • -2
    • +2
    ./postgresql/bulk-mail-create.sql
    • -0
    • +9
    ./postgresql/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
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
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
    ./oracle/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
12:35 pm

yon

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

postgresql.

Options
    • -2
    • +2
    ./oracle/bulk-mail-create.sql
    • -0
    • +7
    ./oracle/upgrade/upgrade-0.1a-0.2.sql
    • -2
    • +2
    ./postgresql/bulk-mail-create.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
  5. … 1 more file in changeset.
Saturday 17 May 2003
12:16 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +2
    ./postgresql/bulk-mail-package-create.sql
    • -2
    • +2
    ./postgresql/bulk-mail-package-drop.sql
  3. … 75 more files in changeset.
Sunday 02 Mar 2003
11:32 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
    • -2
    • +2
    ./postgresql/bulk-mail-package-create.sql
    • -2
    • +2
    ./postgresql/bulk-mail-package-drop.sql
  3. … 52 more files in changeset.
Thursday 16 Jan 2003
2:38 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
    • -6
    • +12
    ./postgresql/bulk-mail-package-create.sql
  2. … 76 more files in changeset.
Friday 06 Dec 2002
1:42 pm

jeffd

acs_function_args should have been define_function_args

Options
    • -2
    • +2
    ./postgresql/bulk-mail-package-create.sql
11:19 am

jeffd

define arguments for package_instantiate_object, and fix a couple other minor issues bug 1788/patch 504 Ken Kennedy

Options
    • -6
    • +12
    ./postgresql/bulk-mail-package-create.sql
Wednesday 12 Jun 2002
3:53 pm

yon

fixing postgres port

Options
    • -16
    • +26
    ./postgresql/bulk-mail-create.sql
    • -11
    • +17
    ./postgresql/bulk-mail-drop.sql
    • -4
    • +2
    ./postgresql/bulk-mail-package-create.sql
    • -3
    • +3
    ./postgresql/bulk-mail-package-drop.sql
  5. … 5 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
    ./oracle/bulk-mail-create.sql
    • -0
    • +0
    ./oracle/bulk-mail-drop.sql
    • -0
    • +0
    ./oracle/bulk-mail-package-create.sql
    • -0
    • +0
    ./oracle/bulk-mail-package-drop.sql
    • -0
    • +0
    ./oracle/bulk-mail-views-create.sql
    • -0
    • +0
    ./oracle/bulk-mail-views-drop.sql
    • -0
    • +0
    ./postgresql/bulk-mail-create.sql
    • -0
    • +0
    ./postgresql/bulk-mail-drop.sql
    • -0
    • +0
    ./postgresql/bulk-mail-package-create.sql
    • -0
    • +0
    ./postgresql/bulk-mail-package-drop.sql
    • -0
    • +0
    ./postgresql/bulk-mail-views-create.sql
    • -0
    • +0
    ./postgresql/bulk-mail-views-drop.sql
  13. … 12 more files in changeset.
12:07 am

yon

Initial revision

Options
    • -0
    • +58
    ./oracle/bulk-mail-create.sql
    • -0
    • +25
    ./oracle/bulk-mail-drop.sql
    • -0
    • +110
    ./oracle/bulk-mail-package-create.sql
    • -0
    • +8
    ./oracle/bulk-mail-package-drop.sql
    • -0
    • +18
    ./oracle/bulk-mail-views-create.sql
    • -0
    • +9
    ./oracle/bulk-mail-views-drop.sql
    • -0
    • +56
    ./postgresql/bulk-mail-create.sql
    • -0
    • +25
    ./postgresql/bulk-mail-drop.sql
    • -0
    • +85
    ./postgresql/bulk-mail-package-create.sql
    • -0
    • +9
    ./postgresql/bulk-mail-package-drop.sql
    • -0
    • +18
    ./postgresql/bulk-mail-views-create.sql
    • -0
    • +9
    ./postgresql/bulk-mail-views-drop.sql
  13. … 21 more files in changeset.