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
Monday 13 Nov 2017
1:52 pm

antoniop

Fix sql update to populate new forum_id column in existing data

Options
    • -3
    • +9
    ./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
  2. … 1 more file in changeset.
Friday 10 Nov 2017
6:21 pm

antoniop

Maintenance of forum reading count feature

- removal of forums_reading_info_user (1Mio rows on Learn@WU).

This materialized view had to be constantly synced with

forums_reading_info table. Reimplemented as view.

- simplify logics in stored procedure due to new datamodel

- fix inconsistencies between oracle and postgres function definition

- re-enabled parameter to decide whether use these stats or not in

administration

TODO: consider further reform of this feature as stats grow very

large on busy sites for probably little value added

Options
    • -17
    • +10
    ./forums-reading-info-create.sql
    • -3
    • +3
    ./forums-reading-info-drop.sql
    • -143
    • +5
    ./forums-reading-info-package-create.sql
    • -0
    • +186
    ./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
  5. … 5 more files in changeset.
Wednesday 08 Nov 2017
1:05 pm

antoniop

Implement post anonymously through explicit forum attribute in table

Now moderators can explicitly decide whether a forum will enable posting anonymously or not.

Forum must be in a policy different from closed and the anonymous flag must be set accordingly for this to happen.

Also:

- normalize api in a way it can accomodate all current attributes. In particular,

now edit api will now leave every unspecified attribute unchanged, instead of

setting it to some default.

- fix some usability issues when managing forum parameters (e.g. values not

retrieved in form when editing existing forum)

- introduce missing Oracle upgrade script for the whole forum reform

- fix oracle creation script

Options
    • -1
    • +7
    ./forums-forums-create.sql
    • -0
    • +27
    ./upgrade/upgrade-1.3.1d1-1.3.1d2.sql
  3. … 9 more files in changeset.
Wednesday 27 Sep 2017
1:07 pm

antoniop

Forum reform

- remove hardcoded dependency with registered_users group. Target is to improve suitability in convoluted multi groups/multi subsites context

- in place of previous permission-based machinery, use plain table columns to detect whether user can or cannot post replies/new threads

- remove permission check at the message level in favor of that on forum level

Options
    • -0
    • +6
    ./forums-forums-create.sql
    • -0
    • +18
    ./upgrade/upgrade-1.3-1.3d1.sql
  3. … 20 more files in changeset.
Monday 10 Nov 2008
12:29 am

donb

1. Merge 2.4.1 to HEAD other than assessment, imsld, lorsm, and views.

2. Bump version numbers to 2.5.0d1.

Options
    • -2
    • +1
    ./forums-reading-info-drop.sql
    • -57
    • +140
    ./forums-reading-info-package-create.sql
  3. … 378 more files in changeset.
Saturday 24 May 2008
12:10 pm

marioa

Fixed package forum-reading-info for Oracle.

Options
    • -3
    • +2
    ./forums-reading-info-drop.sql
    • -57
    • +140
    ./forums-reading-info-package-create.sql
Wednesday 23 Apr 2008
6:04 pm

marioa

Fixed packaged body bug

Options
    • -1
    • +1
    ./forums-reading-info-package-create.sql
Friday 15 Jun 2007
12:42 pm

davidam

add @forums-reading-info-package-create.sql script

Options
    • -1
    • +2
    ./upgrade/upgrade-1.3d5-1.3d6.sql
12:39 pm

davidam

add reading info creation scripts

Options
    • -0
    • +4
    ./forums-create.sql
12:35 pm

davidam

creation

Options
    • -0
    • +213
    ./forums-reading-info-package-create.sql
Monday 04 Jun 2007
2:35 pm

davidam

creation: load the reading_info script

Options
    • -0
    • +1
    ./upgrade/upgrade-1.3d5-1.3d6.sql
Friday 01 Jun 2007
5:56 pm

davidam

creation

Options
    • -0
    • +50
    ./forums-reading-info-create.sql
    • -0
    • +18
    ./forums-reading-info-drop.sql
Tuesday 15 May 2007
10:14 pm

donb

Merged changes to HEAD ...

Options
    • -0
    • +96
    ./upgrade/upgrade-1.3d3-1.3d4.sql
  2. … 1556 more files in changeset.
Sunday 21 Jan 2007
8:23 am

maltes

Forgot the function that needed upgrades as well. Good to have sites that acutally upgraded from 4.6 around :-). ORACLE: NOT TESTED. NOT SURE IF IT IS THE PROPER THING. PLEASE TEST.

Options
    • -1
    • +95
    ./upgrade/upgrade-1.3d3-1.3d4.sql
  2. … 1 more file in changeset.
8:03 am

maltes

Made sure that old forum instances have the package_id set correctly. For newer ones acs_object__new should take care of it.

Options
    • -0
    • +2
    ./upgrade/upgrade-1.3d3-1.3d4.sql
  2. … 2 more files in changeset.
8:03 am

maltes

file upgrade-1.3d3-1.3d4.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./upgrade/upgrade-1.3d3-1.3d4.sql
  2. … 1 more file in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

Options
    • -22
    • +14
    ./forums-forums-create.sql
    • -14
    • +5
    ./forums-forums-drop.sql
    • -8
    • +20
    ./forums-messages-package-create.sql
    • -0
    • +90
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
    • -3
    • +27
    ./upgrade/upgrade-1.1.1-1.1.2d1.sql
    • -0
    • +48
    ./upgrade/upgrade-1.1.2d4-1.1.2d5.sql
    • -0
    • +12
    ./upgrade/upgrade-1.2.0d3-1.2.0d4.sql
    • -0
    • +11
    ./upgrade/upgrade-1.2.0d4-1.3d1.sql
    • -34
    • +28
    ./upgrade/upgrade-1.2d1-1.2d2.sql
  10. … 2470 more files in changeset.
Wednesday 28 Jun 2006
10:30 pm

veronicac

Initial import of forums version 1.2.0d4

Options
    • -0
    • +0
    ./forums-drop.sql
    • -5
    • +114
    ./forums-notifications-sanitize.sql
    • -34
    • +46
    ./forums-search-create.sql
    • -11
    • +16
    ./forums-search-drop.sql
    • -0
    • +0
    ./forums-tree-drop.sql
    • -0
    • +0
    ./upgrade/upgrade-0.1d-0.2d.sql
    • -0
    • +0
    ./upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +0
    ./upgrade/upgrade-0.3d-0.4d.sql
    • -0
    • +402
    ./upgrade/upgrade-1.0.6-1.0.7d.sql
    • -0
    • +0
    ./upgrade/upgrade-1.0d2-1.0d3.sql
    • -0
    • +0
    ./upgrade/upgrade-1.0d3-1.0d4.sql
    • -0
    • +285
    ./upgrade/upgrade-1.0d4-1.0.1d2.sql
    • -0
    • +11
    ./upgrade/upgrade-1.1.1-1.1.2d1.sql
    • -0
    • +48
    ./upgrade/upgrade-1.1.2d4-1.1.2d5.sql
    • -0
    • +1
    ./upgrade/upgrade-1.1d1-1.1d2.sql
  16. … 256 more files in changeset.
10:30 pm

veronicac

Initial import of forums version 1.2.0d4

Options
    • -1
    • +0
    ./forums-create.sql
    • -61
    • +68
    ./forums-forums-create.sql
    • -3
    • +20
    ./forums-forums-drop.sql
    • -69
    • +77
    ./forums-forums-package-create.sql
    • -59
    • +72
    ./forums-messages-create.sql
    • -0
    • +3
    ./forums-messages-drop.sql
    • -178
    • +342
    ./forums-messages-package-create.sql
    • -0
    • +61
    ./forums-notifications-init.sql
    • -30
    • +29
    ./forums-tree-create.sql
  10. … 35 more files in changeset.
Thursday 11 May 2006
1:56 pm

emmar

Update package_id for projects

Options
    • -0
    • +11
    ./upgrade/upgrade-1.2.0d4-1.3d1.sql
1:56 pm

emmar

file upgrade-1.2.0d4-1.3d1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-1.2.0d4-1.3d1.sql
Wednesday 10 May 2006
10:30 am

dedsc

increase forums_forums.charter to 4000 chars, add length checking in the forums form, bump version info

Options
    • -1
    • +1
    ./forums-forums-create.sql
    • -0
    • +12
    ./upgrade/upgrade-1.2.0d3-1.2.0d4.sql
  3. … 5 more files in changeset.
10:30 am

dedsc

file upgrade-1.2.0d3-1.2.0d4.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-1.2.0d3-1.2.0d4.sql
  2. … 1 more file in changeset.
Sunday 19 Mar 2006
7:53 pm

emmar

Last poster was updated with the user_id value of the root message instead of with the user_id received by forums_message.new

Options
    • -2
    • +2
    ./forums-messages-package-create.sql
    • -2
    • +2
    ./upgrade/upgrade-1.2d1-1.2d2.sql
Thursday 16 Mar 2006
1:23 pm

emmar

Fix oracle syntax and query for updating forums_messages.last_poster

Options
    • -26
    • +8
    ./upgrade/upgrade-1.2d1-1.2d2.sql
Monday 02 Jan 2006
1:24 am

donb

Applied patch to fix bug #2761.

Options
    • -6
    • +18
    ./forums-messages-package-create.sql
    • -6
    • +18
    ./upgrade/upgrade-1.2d1-1.2d2.sql
Tuesday 08 Nov 2005
8:10 pm

daveb

Fix permissions change so it works if explciti read, write, or create exist on

forums objects.

Options
    • -3
    • +27
    ./upgrade/upgrade-1.1.1-1.1.2d1.sql
  2. … 1 more file in changeset.
Monday 26 Sep 2005
10:57 am

victorg

commit to OACS-5-2 merge of changes on OACS-5-1

(using tag vg-merge-dotlrn-2-1-20050922) for packages under dotlrn-all

Options
    • -21
    • +13
    ./forums-forums-create.sql
    • -14
    • +5
    ./forums-forums-drop.sql
    • -0
    • +48
    ./upgrade/upgrade-1.1.2d4-1.1.2d5.sql
  4. … 89 more files in changeset.
Monday 25 Jul 2005
9:42 pm

victorg

file upgrade-1.1.2d4-1.1.2d5.sql was added on branch oacs-5-2 on 2005-09-26 09:03:13 +0000

Options
    • -0
    • +0
    ./upgrade/upgrade-1.1.2d4-1.1.2d5.sql
9:42 pm

andrewg

Resolving outstanding permissions bugs in forums. Please let me know if you have any trouble with it.

Options
    • -21
    • +13
    ./forums-forums-create.sql
    • -14
    • +5
    ./forums-forums-drop.sql
    • -0
    • +48
    ./upgrade/upgrade-1.1.2d4-1.1.2d5.sql
  4. … 6 more files in changeset.