OpenACS / openacs-4 / packages / forums

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 30
Last Commit: 14:19
Commits this week: 0
Total Lines of Code (LoC): 7,294
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 a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 03 Oct 2003
1:37 pm

lars

Fixed bug #873 for Oracle by also using 'like' search for Oracle. Intermedia doesn't install by default, and I'm not sure how we're going to make it.

Options
    • -2
    • +2
    ./oracle/forums-search-create.sql
  2. … 5 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
    • -1
    • +1
    ./oracle/forums-forums-drop.sql
    • -4
    • +4
    ./oracle/forums-forums-package-create.sql
    • -6
    • +6
    ./oracle/forums-messages-package-create.sql
    • -0
    • +2
    ./oracle/forums-notifications-init.sql
    • -6
    • +6
    ./oracle/forums-notifications-sanitize.sql
  6. … 271 more files in changeset.
7:19 am

frankn

Resolves bug #749 by appying patch #302.

Options
    • -2
    • +4
    ./oracle/forums-messages-create.sql
    • -3
    • +3
    ./postgresql/forums-messages-create.sql
  3. … 1 more file in changeset.
Monday 22 Sep 2003
11:37 pm

lars

Applied patch #16 for dropping forums. Not convinced it works now, and haven't tested, but I can tell for sure it didn't work before.

Options
    • -3
    • +20
    ./oracle/forums-forums-drop.sql
    • -0
    • +3
    ./oracle/forums-messages-drop.sql
    • -5
    • +112
    ./oracle/forums-notifications-sanitize.sql
Wednesday 17 Sep 2003
3:58 pm

peterm

using named parameters in call to acs_sc_impl.new to avoid mismatch with new optional pretty name parameter

Options
    • -6
    • +6
    ./oracle/forums-notifications-init.sql
  2. … 26 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
    • -0
    • +3
    ./postgresql/forums-create.sql
    • -0
    • +3
    ./postgresql/forums-drop.sql
    • -0
    • +76
    ./postgresql/forums-sc-create.sql
    • -0
    • +23
    ./postgresql/forums-sc-drop.sql
  5. … 813 more files in changeset.
Wednesday 18 Jun 2003
11:40 am

peterm

adding OpenFTS site-wide search integration of forums from openacs.org. We tested it on a .LRN server and it worked fine

Options
    • -0
    • +3
    ./postgresql/forums-create.sql
    • -0
    • +3
    ./postgresql/forums-drop.sql
    • -0
    • +76
    ./postgresql/forums-sc-create.sql
    • -0
    • +23
    ./postgresql/forums-sc-drop.sql
11:40 am

peterm

file forums-sc-create.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./postgresql/forums-sc-create.sql
11:40 am

peterm

file forums-sc-drop.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./postgresql/forums-sc-drop.sql
Saturday 17 May 2003
12:37 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -0
    • +3
    ./oracle/forums-messages-create.sql
    • -0
    • +3
    ./oracle/upgrade-0.3d-0.4d.sql
    • -1
    • +1
    ./postgresql/forums-forums-create.sql
    • -1
    • +1
    ./postgresql/forums-forums-package-create.sql
    • -1
    • +1
    ./postgresql/forums-forums-package-drop.sql
    • -3
    • +7
    ./postgresql/forums-messages-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-drop.sql
    • -5
    • +5
    ./postgresql/upgrade-0.1d-0.2d.sql
    • -0
    • +3
    ./postgresql/upgrade-0.3d-0.4d.sql
  11. … 55 more files in changeset.
Sunday 02 Mar 2003
11:42 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
    • -1
    • +1
    ./postgresql/forums-forums-create.sql
    • -1
    • +1
    ./postgresql/forums-forums-package-create.sql
    • -1
    • +1
    ./postgresql/forums-forums-package-drop.sql
    • -3
    • +3
    ./postgresql/forums-messages-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-drop.sql
    • -5
    • +5
    ./postgresql/upgrade-0.1d-0.2d.sql
  8. … 33 more files in changeset.
Sunday 23 Feb 2003
7:19 pm

danw

forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

Options
    • -9
    • +0
    ./postgresql/forums-forums-drop.sql
  2. … 7 more files in changeset.
Thursday 13 Feb 2003
8:25 am

tilmanns

Removed some postgresql-isms. SC drop is Still missing, and it will still fail because of child record problems in notifications.

Options
    • -1
    • +3
    ./oracle/forums-notifications-sanitize.sql
8:01 am

tilmanns

Added missing drop script.

Options
    • -0
    • +12
    ./oracle/forums-tree-drop.sql
Saturday 01 Feb 2003
12:03 am

jeffd

file upgrade-0.3d-0.4d.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade-0.3d-0.4d.sql
    • -0
    • +0
    ./postgresql/upgrade-0.3d-0.4d.sql
12:02 am

jeffd

adds user_id and parent_id indexes in forums_messages, bump version to 0.4d, upgrade scripts

Options
    • -0
    • +3
    ./oracle/forums-messages-create.sql
    • -0
    • +3
    ./oracle/upgrade-0.3d-0.4d.sql
    • -0
    • +4
    ./postgresql/forums-messages-create.sql
    • -0
    • +3
    ./postgresql/upgrade-0.3d-0.4d.sql
  5. … 1 more file in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -1
    • +1
    ./postgresql/forums-forums-package-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
  3. … 53 more files in changeset.
Thursday 16 Jan 2003
2:48 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
    • -0
    • +4
    ./oracle/forums-messages-create.sql
    • -0
    • +6
    ./oracle/upgrade-0.2d-0.3d.sql
    • -0
    • +4
    ./postgresql/forums-messages-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +28
    ./postgresql/upgrade-0.2d-0.3d.sql
  6. … 52 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -1
    • +1
    ./postgresql/forums-forums-package-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
  3. … 53 more files in changeset.
Tuesday 17 Dec 2002
11:48 am

jeffd

file upgrade-0.2d-0.3d.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade-0.2d-0.3d.sql
    • -0
    • +0
    ./postgresql/upgrade-0.2d-0.3d.sql
11:48 am

jeffd

create necessary index, make forums_message__root_message_id isstrict, icachable, upgrade script

Options
    • -0
    • +4
    ./oracle/forums-messages-create.sql
    • -0
    • +6
    ./oracle/upgrade-0.2d-0.3d.sql
    • -0
    • +4
    ./postgresql/forums-messages-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +28
    ./postgresql/upgrade-0.2d-0.3d.sql
  6. … 1 more file in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -1
    • +2
    ./oracle/forums-forums-create.sql
    • -2
    • +0
    ./oracle/forums-forums-package-create.sql
    • -0
    • +1
    ./oracle/forums-messages-create.sql
    • -1
    • +16
    ./oracle/forums-messages-package-create.sql
    • -0
    • +328
    ./oracle/upgrade-0.1d-0.2d.sql
    • -13
    • +2
    ./postgresql/forums-forums-create.sql
    • -2
    • +0
    ./postgresql/forums-forums-package-create.sql
    • -0
    • +1
    ./postgresql/forums-messages-create.sql
    • -1
    • +8
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +173
    ./postgresql/upgrade-0.1d-0.2d.sql
  11. … 94 more files in changeset.
Tuesday 26 Nov 2002
3:38 am

donb

Fixed the last post problems cleaned up templates a little bit ..

Options
    • -1
    • +9
    ./oracle/forums-messages-package-create.sql
    • -2
    • +9
    ./oracle/upgrade-0.1d-0.2d.sql
  3. … 2 more files in changeset.
Friday 22 Nov 2002
7:38 pm

donb

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

Options
    • -0
    • +0
    ./oracle/upgrade-0.1d-0.2d.sql
    • -0
    • +0
    ./postgresql/upgrade-0.1d-0.2d.sql
7:38 pm

donb

Added "last_post" column to the forums table and "last_child_post" column

to the forums messages table to track these values. Previously the code

was abusing the related object's last_modified field and it didn't bother

tracking the date of the last reply to a thread.

Options
    • -1
    • +2
    ./oracle/forums-forums-create.sql
    • -2
    • +0
    ./oracle/forums-forums-package-create.sql
    • -0
    • +1
    ./oracle/forums-messages-create.sql
    • -1
    • +8
    ./oracle/forums-messages-package-create.sql
    • -0
    • +321
    ./oracle/upgrade-0.1d-0.2d.sql
    • -13
    • +2
    ./postgresql/forums-forums-create.sql
    • -2
    • +0
    ./postgresql/forums-forums-package-create.sql
    • -0
    • +1
    ./postgresql/forums-messages-create.sql
    • -1
    • +8
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +173
    ./postgresql/upgrade-0.1d-0.2d.sql
  11. … 7 more files in changeset.
Tuesday 20 Aug 2002
11:39 pm

arjun

message deletion fixes

Options
    • -7
    • +7
    ./postgresql/forums-messages-package-create.sql
  2. … 4 more files in changeset.
Friday 09 Aug 2002
10:51 pm

yon

copyright OpenForce -> MIT

Options
    • -2
    • +2
    ./oracle/forums-search-create.sql
    • -2
    • +2
    ./oracle/forums-search-drop.sql
  3. … 112 more files in changeset.
Monday 05 Aug 2002
10:00 pm

arjun

added coalesces (where there's nvl's in the oracle version) to fix the perm bug where reg'd users can't see forums or posts

Options
    • -2
    • +2
    ./postgresql/forums-forums-package-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
Monday 15 Jul 2002
5:25 pm

yon

some minor improvements

Options
    • -22
    • +23
    ./oracle/forums-search-create.sql
Friday 12 Jul 2002
5:20 pm

yon

grant execute on ctx_dll to user so that the dbms_job to sync the forums

context index can be scheduled by the user and not by the ctxsys user.

Options
    • -5
    • +3
    ./oracle/forums-search-create.sql
    • -7
    • +1
    ./oracle/forums-search-drop.sql