OpenACS / openacs-4 / packages / acs-messaging

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 17
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 6,109
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 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 22 Apr 2003
2:25 am

donb

1. Fixed a type mismatch problem in acs-messaging for PostgreSQL that was

ignored by versions before 7.3 and therefore had been missed.

2. Fixed a problem in static pages regarding misunderstanding of how

nsv_array set works by someone who worked on it at some point.

3. Fixed a typo in static pages for PostgreSQL (misspelled function

name)

4. Fixed a typo in a query in survey.

Options
    • -2
    • +2
    ./postgresql/acs-messaging-packages.sql
    • -0
    • +102
    ./postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
  3. … 3 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
    • -3
    • +3
    ./postgresql/acs-messaging-create.sql
    • -10
    • +10
    ./postgresql/acs-messaging-drop.sql
    • -13
    • +13
    ./postgresql/acs-messaging-packages.sql
  4. … 51 more files in changeset.
Friday 24 Jan 2003
11:08 pm

jeffd

removing duped upgrade scripts closes bug 179

Options
    • -242
    • +0
    ./oracle/upgrade-4.0-4.0.1a.sql
    • -12
    • +0
    ./oracle/upgrade-4.0.1-4.1.sql
    • -49
    • +0
    ./oracle/upgrade-4.0.1a-4.0.1.sql
11:06 pm

jeffd

removing duped upgrade scripts closes bug 179

Options
    • -242
    • +0
    ./oracle/upgrade-4.0-4.0.1a.sql
    • -12
    • +0
    ./oracle/upgrade-4.0.1-4.1.sql
    • -49
    • +0
    ./oracle/upgrade-4.0.1a-4.0.1.sql
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -3
    • +3
    ./postgresql/acs-messaging-create.sql
    • -5
    • +5
    ./postgresql/acs-messaging-packages.sql
  3. … 53 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -3
    • +3
    ./postgresql/acs-messaging-create.sql
    • -5
    • +5
    ./postgresql/acs-messaging-packages.sql
  3. … 53 more files in changeset.
Sunday 12 May 2002
10:57 pm

donb

Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

Options
    • -7
    • +7
    ./oracle/acs-messaging-packages.sql
  2. … 58 more files in changeset.
Sunday 31 Mar 2002
11:08 pm

donb

Applied Michael Steigman's patches 199-201, which fixes package spec/body

mismatches allowed by Oracle 8i but not by 9i.

Options
    • -7
    • +7
    ./oracle/acs-messaging-packages.sql
  2. … 4 more files in changeset.
Sunday 09 Dec 2001
10:08 pm

donb

Fixed some errors in my earlier hacking on hierarchical queries...

Options
    • -1
    • +2
    ./postgresql/acs-messaging-create.sql
  2. … 3 more files in changeset.
5:21 am

donb

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

Options
    • -1
    • +8
    ./postgresql/acs-messaging-create.sql
    • -2
    • +2
    ./postgresql/acs-messaging-packages.sql
  3. … 17 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -26
    • +20
    ./postgresql/acs-messaging-create.sql
    • -6
    • +4
    ./postgresql/acs-messaging-packages.sql
  3. … 61 more files in changeset.
Thursday 01 Nov 2001
8:01 pm

donb

Bug fixes in the postgres ports of these packages ...

Options
    • -24
    • +30
    ./postgresql/acs-messaging-packages.sql
  2. … 2 more files in changeset.
Wednesday 31 Oct 2001
9:42 pm

donb

1. Added a new Tcl procedure to the content repository's library, named

cr_write_content, which properly writes content to the connection

regardless of RDBMS and storage type. This simplified a bunch of stuff

(which explains the removed files).

2. Fixed a lot of general comments issues regarding HTML vs. Plain/Text,

attachments, etc.

3. Partially ported glossary.

Options
    • -7
    • +13
    ./oracle/acs-messaging-packages.sql
  2. … 81 more files in changeset.
Wednesday 19 Sep 2001
2:54 am

donb

Fixed all sorts of cruft uncovered when I decided to fix the bug preventing

file upload in bboard.

Options
    • -4
    • +7
    ./postgresql/acs-messaging-packages.sql
  2. … 5 more files in changeset.
Wednesday 29 Aug 2001
8:46 pm

arjun

Fixing typo.

Options
    • -2
    • +2
    ./postgresql/acs-messaging-packages.sql
Tuesday 24 Jul 2001
3:50 pm

jong

added missing declare

Options
    • -3
    • +4
    ./postgresql/acs-messaging-packages.sql
Thursday 05 Jul 2001
11:11 pm

lukep

add tree_sortkey to acs_messages to enable hierarchical queries on the reply_to field

Options
    • -2
    • +93
    ./postgresql/acs-messaging-create.sql
    • -3
    • +8
    ./postgresql/acs-messaging-drop.sql
    • -9
    • +14
    ./postgresql/acs-messaging-packages.sql
    • -3
    • +3
    ./postgresql/acs-messaging-views.sql
Thursday 14 Jun 2001
7:03 am

jong

Applied patch from Vinod.

Thanks!

Fixed many little ommisions and drop scripts, etc.

Options
    • -4
    • +3
    ./postgresql/acs-messaging-create.sql
    • -4
    • +47
    ./postgresql/acs-messaging-drop.sql
    • -134
    • +181
    ./postgresql/acs-messaging-packages.sql
Wednesday 06 Jun 2001
5:37 pm

jong

fixed included files syntax

Options
    • -3
    • +3
    ./postgresql/acs-messaging-create.sql
Friday 01 Jun 2001
3:02 pm

donb

Changed parameters to use the new "p_" convention, for the most part.

Options
    • -3
    • +3
    ./postgresql/acs-messaging-create.sql
    • -215
    • +212
    ./postgresql/acs-messaging-packages.sql
  3. … 3 more files in changeset.
Wednesday 23 May 2001
6:39 pm

jong

changed dir structure

Options
    • -0
    • +242
    ./postgresql/upgrade/upgrade-4.0-4.0.1a.sql
    • -0
    • +12
    ./postgresql/upgrade/upgrade-4.0.1-4.1.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-4.0.1a-4.0.1.sql
    • -0
    • +658
    ./postgresql/upgrade/upgrade-4.1-4.1.1.sql
  5. … 6 more files in changeset.
6:38 pm

jong

Initial checkin after changing directory name.

Options
    • -0
    • +139
    ./postgresql/acs-messaging-create.sql
    • -0
    • +20
    ./postgresql/acs-messaging-drop.sql
    • -0
    • +493
    ./postgresql/acs-messaging-packages.sql
    • -0
    • +24
    ./postgresql/acs-messaging-views.sql
6:37 pm

jong

Renamed directory to postgresql

Options
    • -139
    • +0
    ./postgres/acs-messaging-create.sql
    • -20
    • +0
    ./postgres/acs-messaging-drop.sql
    • -493
    • +0
    ./postgres/acs-messaging-packages.sql
    • -24
    • +0
    ./postgres/acs-messaging-views.sql
    • -242
    • +0
    ./postgres/upgrade/upgrade-4.0-4.0.1a.sql
    • -12
    • +0
    ./postgres/upgrade/upgrade-4.0.1-4.1.sql
    • -49
    • +0
    ./postgres/upgrade/upgrade-4.0.1a-4.0.1.sql
    • -658
    • +0
    ./postgres/upgrade/upgrade-4.1-4.1.1.sql
8:06 am

jong

Accidently added.

Options
    • -317
    • +0
    ./postgres/acs-create.sql
7:57 am

jong

cleanup

Options
    • -4
    • +1
    ./postgres/acs-messaging-packages.sql
7:56 am

jong

deleted unneeded files

Options
    • -26
    • +26
    ./postgres/acs-messaging-create.sql
    • -8
    • +6
    ./postgres/acs-messaging-drop.sql
    • -459
    • +403
    ./postgres/acs-messaging-packages.sql
    • -4
    • +7
    ./postgres/acs-messaging-views.sql
    • -242
    • +0
    ./postgres/upgrade-4.0-4.0.1a.sql
    • -12
    • +0
    ./postgres/upgrade-4.0.1-4.1.sql
    • -49
    • +0
    ./postgres/upgrade-4.0.1a-4.0.1.sql
Tuesday 22 May 2001
6:05 am

jong

initial revision

Options
    • -0
    • +317
    ./postgres/acs-create.sql
    • -0
    • +139
    ./postgres/acs-messaging-create.sql
    • -0
    • +22
    ./postgres/acs-messaging-drop.sql
    • -0
    • +552
    ./postgres/acs-messaging-packages.sql
    • -0
    • +21
    ./postgres/acs-messaging-views.sql
    • -0
    • +242
    ./postgres/upgrade-4.0-4.0.1a.sql
    • -0
    • +12
    ./postgres/upgrade-4.0.1-4.1.sql
    • -0
    • +49
    ./postgres/upgrade-4.0.1a-4.0.1.sql
    • -0
    • +242
    ./postgres/upgrade/upgrade-4.0-4.0.1a.sql
    • -0
    • +12
    ./postgres/upgrade/upgrade-4.0.1-4.1.sql
    • -0
    • +49
    ./postgres/upgrade/upgrade-4.0.1a-4.0.1.sql
    • -0
    • +658
    ./postgres/upgrade/upgrade-4.1-4.1.1.sql
Friday 13 Apr 2001
8:42 pm

donb

More file shuffling...

Options
    • -242
    • +0
    ./upgrade-4.0-4.0.1a.sql
    • -12
    • +0
    ./upgrade-4.0.1-4.1.sql
    • -49
    • +0
    ./upgrade-4.0.1a-4.0.1.sql
    • -0
    • +242
    ./oracle/upgrade/upgrade-4.0-4.0.1a.sql
    • -0
    • +12
    ./oracle/upgrade/upgrade-4.0.1-4.1.sql
    • -0
    • +49
    ./oracle/upgrade/upgrade-4.0.1a-4.0.1.sql
8:37 pm

donb

Just reorganizing more datamodel files into the new scheme, also made the

one-line change necessary to port the "page" module.

Options
    • -658
    • +0
    ./upgrade/upgrade-4.1-4.1.1.sql
  2. … 4 more files in changeset.
Thursday 05 Apr 2001
8:23 pm

donb

Big 'ole update to implement multi-db aware packages. Don't try this yet,

I can't *possibly* have gotten all the right files added and removed in

one fell swoop!

Options
    • -138
    • +0
    ./acs-messaging-create.sql
    • -22
    • +0
    ./acs-messaging-drop.sql
    • -637
    • +0
    ./acs-messaging-packages.sql
    • -21
    • +0
    ./acs-messaging-views.sql
    • -0
    • +138
    ./oracle/acs-messaging-create.sql
    • -0
    • +22
    ./oracle/acs-messaging-drop.sql
    • -0
    • +637
    ./oracle/acs-messaging-packages.sql
    • -0
    • +21
    ./oracle/acs-messaging-views.sql
    • -0
    • +242
    ./oracle/upgrade-4.0-4.0.1a.sql
    • -0
    • +12
    ./oracle/upgrade-4.0.1-4.1.sql
    • -0
    • +49
    ./oracle/upgrade-4.0.1a-4.0.1.sql
    • -0
    • +658
    ./oracle/upgrade/upgrade-4.1-4.1.1.sql
  13. … 107 more files in changeset.