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
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
    • -0
    • +2
    ./forums-forums-create.sql
    • -0
    • +2
    ./forums-messages-create.sql
    • -9
    • +114
    ./forums-messages-package-create.sql
    • -0
    • +402
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
  5. … 2272 more files in changeset.
Saturday 08 Jan 2005
2:20 am

donb

Testing revealed a minor error in my upgrade script

Options
    • -1
    • +1
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
Friday 07 Jan 2005
5:59 pm

donb

My changes weren't counting threaded deletes correctly ... this still needs

retesting on Oracle/PG which I'll do in the next day or so by writing new

test cases...

Options
    • -1
    • +1
    ./forums-messages-package-create.sql
    • -1
    • +1
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
  3. … 2 more files in changeset.
5:48 pm

donb

Added previous "mutating table" fix to the upgrade script, too ...

Options
    • -2
    • +4
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
5:43 pm

donb

Fixing "mutating table" problem but on my wrong machine, need to go

test this on the server with Oracle on it ...

Options
    • -2
    • +4
    ./forums-messages-package-create.sql
Tuesday 04 Jan 2005
8:31 pm

andrewg

Oracle 8 doesn't support current_timestamp, so I've changed it to sysdate

Options
    • -2
    • +2
    ./forums-messages-package-create.sql
    • -2
    • +2
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
Saturday 25 Dec 2004
10:46 pm

donb

last_child_post wasn't being initialized in the "new" function...

Options
    • -4
    • +6
    ./forums-messages-package-create.sql
    • -4
    • +6
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
2:05 am

donb

Added the thread and reply counting code previously commited for the PG

version to the Oracle version.

Options
    • -0
    • +2
    ./forums-forums-create.sql
    • -0
    • +2
    ./forums-messages-create.sql
    • -8
    • +109
    ./forums-messages-package-create.sql
    • -0
    • +398
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
2:05 am

donb

file upgrade-1.0.6-1.0.7d.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
Monday 12 Jul 2004
4:49 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040628 and jcd-merge-5-1-20040712 to HEAD

Options
    • -0
    • +2
    ./forums-messages-create.sql
  2. … 116 more files in changeset.
Wednesday 30 Jun 2004
9:47 pm

janine

fixing bug in previous submission

Options
    • -0
    • +2
    ./forums-messages-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
    • -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