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