OpenACS / openacs-4 / packages / forums / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 23
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 4,269
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 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
    • -7
    • +0
    ./forums-messages-create.sql
    • -4
    • +4
    ./forums-messages-package-create.sql
    • -0
    • +285
    ./upgrade/upgrade-1.0d4-1.0.1d2.sql
  4. … 685 more files in changeset.
Tuesday 22 Jun 2004
6:53 pm

janine

file upgrade-1.0d4-1.0.1d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-1.0d4-1.0.1d2.sql
  2. … 1 more file in changeset.
6:53 pm

janine

fix from Sloan: use richtext widget

Options
    • -7
    • +0
    ./forums-messages-create.sql
    • -4
    • +4
    ./forums-messages-package-create.sql
    • -0
    • +285
    ./upgrade/upgrade-1.0d4-1.0.1d2.sql
  4. … 13 more files in changeset.
Monday 17 May 2004
5:14 pm

jeffd

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

Options
    • -14
    • +21
    ./forums-search-create.sql
    • -10
    • +15
    ./forums-search-drop.sql
  3. … 833 more files in changeset.
Thursday 13 May 2004
12:23 pm

lars

Paraemterized the Intermedia scripts

Options
    • -14
    • +21
    ./forums-search-create.sql
    • -10
    • +15
    ./forums-search-drop.sql
Tuesday 30 Mar 2004
11:00 pm

jeffd

fix upgrade script, set package, title for forums on new and edit, propigate displayed_object_id for forum

Options
    • -1
    • +3
    ./forums-forums-package-create.sql
    • -0
    • +1
    ./upgrade/upgrade-1.1d1-1.1d2.sql
  3. … 5 more files in changeset.
Thursday 25 Mar 2004
4:59 pm

jeffd

propigate title, package_id to acs_objects, require kernel 5.2.0d2 bump version to 1.1d2, upgrade scripts tip 42

Options
    • -1
    • +5
    ./forums-messages-package-create.sql
    • -0
    • +1
    ./upgrade/upgrade-1.1d1-1.1d2.sql
  3. … 3 more files in changeset.
Monday 13 Oct 2003
9:47 am

lars

Reverting accidental change

Options
    • -11
    • +6
    ./forums-search-create.sql
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +364
    ./upgrade/upgrade-1.0d3-1.0d4.sql
  2. … 23 more files in changeset.
Friday 03 Oct 2003
9:38 pm

lars

- Fixed bug in oracle code, which caused thread last post date to not get set corectly

- Moved upgrade scripts to upgrade directory

Options
    • -3
    • +3
    ./forums-messages-package-create.sql
    • -328
    • +0
    ./upgrade-0.1d-0.2d.sql
    • -6
    • +0
    ./upgrade-0.2d-0.3d.sql
    • -3
    • +0
    ./upgrade-0.3d-0.4d.sql
    • -0
    • +328
    ./upgrade/upgrade-0.1d-0.2d.sql
    • -0
    • +6
    ./upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +3
    ./upgrade/upgrade-0.3d-0.4d.sql
    • -0
    • +260
    ./upgrade/upgrade-1.0d2-1.0d3.sql
  9. … 7 more files in changeset.
8:26 pm

lars

Fixed bug #871: Sorting forums post listing

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

frankn

Resolves bug #749 by appying patch #302.

Options
    • -2
    • +4
    ./forums-messages-create.sql
  2. … 2 more files 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
    ./forums-forums-drop.sql
    • -0
    • +3
    ./forums-messages-drop.sql
    • -5
    • +112
    ./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
    ./forums-notifications-init.sql
  2. … 26 more files in changeset.
Saturday 17 May 2003
12:37 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -0
    • +3
    ./forums-messages-create.sql
    • -0
    • +3
    ./upgrade-0.3d-0.4d.sql
  3. … 63 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
    ./forums-notifications-sanitize.sql
8:01 am

tilmanns

Added missing drop script.

Options
    • -0
    • +12
    ./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
    ./upgrade-0.3d-0.4d.sql
  2. … 1 more file in changeset.
12:02 am

jeffd

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

Options
    • -0
    • +3
    ./forums-messages-create.sql
    • -0
    • +3
    ./upgrade-0.3d-0.4d.sql
  3. … 3 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
    ./forums-messages-create.sql
    • -0
    • +6
    ./upgrade-0.2d-0.3d.sql
  3. … 55 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
    ./upgrade-0.2d-0.3d.sql
  2. … 1 more file in changeset.
11:48 am

jeffd

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

Options
    • -0
    • +4
    ./forums-messages-create.sql
    • -0
    • +6
    ./upgrade-0.2d-0.3d.sql
  3. … 4 more files in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -1
    • +2
    ./forums-forums-create.sql
    • -2
    • +0
    ./forums-forums-package-create.sql
    • -0
    • +1
    ./forums-messages-create.sql
    • -1
    • +16
    ./forums-messages-package-create.sql
    • -0
    • +328
    ./upgrade-0.1d-0.2d.sql
  6. … 99 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
    ./forums-messages-package-create.sql
    • -2
    • +9
    ./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
    ./upgrade-0.1d-0.2d.sql
  2. … 1 more file in changeset.
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
    ./forums-forums-create.sql
    • -2
    • +0
    ./forums-forums-package-create.sql
    • -0
    • +1
    ./forums-messages-create.sql
    • -1
    • +8
    ./forums-messages-package-create.sql
    • -0
    • +321
    ./upgrade-0.1d-0.2d.sql
  6. … 12 more files in changeset.
Friday 09 Aug 2002
10:51 pm

yon

copyright OpenForce -> MIT

Options
    • -2
    • +2
    ./forums-search-create.sql
    • -2
    • +2
    ./forums-search-drop.sql
  3. … 112 more files in changeset.
Monday 15 Jul 2002
5:25 pm

yon

some minor improvements

Options
    • -22
    • +23
    ./forums-search-create.sql