Activity OpenACS/openacs-4/packages/forums/sql/oracle

5:37 pm

gustafn

More
MAIN:gustafn:20240903153723
changed 8100 files
MAIN

merge from oacs-5-10

- -4
- +1
./forums-create.sql
- History
- Source
- Diff
./forums-create.sql
- -3
- +0
./forums-drop.sql
- History
- Source
- Diff
./forums-drop.sql
- -0
- +6
./forums-forums-create.sql
- History
- Source
- Diff
./forums-forums-create.sql
- -118
- +0
./forums-notifications-init.sql
- History
- Source
- Diff
./forums-notifications-init.sql
- -128
- +0
./forums-notifications-sanitize.sql
- History
- Source
- Diff
./forums-notifications-sanitize.sql
- -1
- +1
./upgrade/upgrade-1.3-1.3d1.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3-1.3d1.sql
- -0
- +15
./upgrade/upgrade-1.3.1d12-1.3.1d13.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3.1d12-1.3.1d13.sql
- -1
- +1
./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
… 8092 more files in changeset.

12:43 pm

antoniop

Cleanup leftover references to files deleted in https://cvs.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Aantoniop%3A20200507144307

This was not preventing the installation or functionalities of the forums package, so it has been long missed. Upon closer inspection, errors were popping up in the installation UI.

- -4
- +1
./forums-create.sql
- History
- Source
- Diff
./forums-create.sql
- -3
- +0
./forums-drop.sql
- History
- Source
- Diff
./forums-drop.sql
… 3 more files in changeset.

9:11 pm

gustafn

improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

- -1
- +1
./upgrade/upgrade-1.3-1.3d1.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3-1.3d1.sql
- -1
- +1
./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
… 7 more files in changeset.

4:43 pm

antoniop

Move logics to create forum notification type to tcl to:

- reduce code duplication

- make it simpler to extend forums with new notification types

This reform was triggered by a downstream request, where users would like a new kind of notification for forum moderators that triggers also when a forum message has not been approved

- -118
- +0
./forums-notifications-init.sql
- History
- Source
- Diff
./forums-notifications-init.sql
- -128
- +0
./forums-notifications-sanitize.sql
- History
- Source
- Diff
./forums-notifications-sanitize.sql
… 3 more files in changeset.

8:38 pm

Add column 'attachments_allowed_p' to 'forums_forums', to be used to allow/disallow attachments on a per forum basis. Currently, the attachment logic is package instance wise, so if the forums instance has an attachment instance mounted below, then attachments are assumed to be enabled for all forums in that package instance. The idea with this change is to check for both the attachments instance mounted under a particular forum instance, and the 'attachments_allowed_p' column on 'forums_forums', to decide if attachments are enabled or not (both should be true). Next step would be to rewrite the logic to achieve that.

- -0
- +6
./forums-forums-create.sql
- History
- Source
- Diff
./forums-forums-create.sql
- -0
- +15
./upgrade/upgrade-1.3.1d12-1.3.1d13.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3.1d12-1.3.1d13.sql
… 3 more files in changeset.

8:38 pm

hectorr

More
MAIN:hectorr:20190618183805
deleted 2 files
MAIN

file upgrade-1.3.1d12-1.3.1d13.sql was initially added on branch oacs-5-10.

- -0
- +0
./upgrade/upgrade-1.3.1d12-1.3.1d13.sql
- History
- Source
./upgrade/upgrade-1.3.1d12-1.3.1d13.sql
… 1 more file in changeset.

6:49 pm

gustafn

More
MAIN:gustafn:20180815164920
changed 27 files
MAIN

Removed obsolete @arch-tag

- -2
- +1
./upgrade/upgrade-1.2.0d3-1.2.0d4.sql
- History
- Source
- Diff
./upgrade/upgrade-1.2.0d3-1.2.0d4.sql
… 26 more files in changeset.

4:22 pm

antoniop

More
MAIN:antoniop:20171113152226
changed 8 files
MAIN

Port downstream only usage of reading info api

Also fix such api so that root message is retrieved for every given source message

- -5
- +16
./forums-reading-info-package-create.sql
- History
- Source
- Diff
./forums-reading-info-package-create.sql
- -0
- +163
./upgrade/upgrade-1.3.1d3-1.3.1d4.sql
- History
- Source
./upgrade/upgrade-1.3.1d3-1.3.1d4.sql
… 6 more files in changeset.

1:52 pm

antoniop

More
MAIN:antoniop:20171113125259
changed 2 files
MAIN

Fix sql update to populate new forum_id column in existing data

- -3
- +9
./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
… 1 more file in changeset.

6:21 pm

antoniop

More
MAIN:antoniop:20171110172105
changed 9 files
MAIN

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

- -17
- +10
./forums-reading-info-create.sql
- History
- Source
- Diff
./forums-reading-info-create.sql
- -3
- +3
./forums-reading-info-drop.sql
- History
- Source
- Diff
./forums-reading-info-drop.sql
- -143
- +5
./forums-reading-info-package-create.sql
- History
- Source
- Diff
./forums-reading-info-package-create.sql
- -0
- +186
./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
- History
- Source
./upgrade/upgrade-1.3.1d2-1.3.1d3.sql
… 5 more files in changeset.

1:05 pm

antoniop

More
MAIN:antoniop:20171108120555
changed 11 files
MAIN

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

- -1
- +7
./forums-forums-create.sql
- History
- Source
- Diff
./forums-forums-create.sql
- -0
- +27
./upgrade/upgrade-1.3.1d1-1.3.1d2.sql
- History
- Source
./upgrade/upgrade-1.3.1d1-1.3.1d2.sql
… 9 more files in changeset.

1:07 pm

antoniop

More
MAIN:antoniop:20170927110751
changed 22 files
MAIN

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

- -0
- +6
./forums-forums-create.sql
- History
- Source
- Diff
./forums-forums-create.sql
- -0
- +18
./upgrade/upgrade-1.3-1.3d1.sql
- History
- Source
./upgrade/upgrade-1.3-1.3d1.sql
… 20 more files in changeset.

12:29 am

donb

More
MAIN:donb:20081109232922
changed 380 files
MAIN

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

2. Bump version numbers to 2.5.0d1.

- -2
- +1
./forums-reading-info-drop.sql
- History
- Source
- Diff
./forums-reading-info-drop.sql
- -57
- +140
./forums-reading-info-package-create.sql
- History
- Source
- Diff
./forums-reading-info-package-create.sql
… 378 more files in changeset.

12:10 pm

marioa

Fixed package forum-reading-info for Oracle.

- -3
- +2
./forums-reading-info-drop.sql
- History
- Source
- Diff
./forums-reading-info-drop.sql
- -57
- +140
./forums-reading-info-package-create.sql
- History
- Source
- Diff
./forums-reading-info-package-create.sql

6:04 pm

marioa

Fixed packaged body bug

- -1
- +1
./forums-reading-info-package-create.sql
- History
- Source
- Diff
./forums-reading-info-package-create.sql

12:42 pm

davidam

More
MAIN:davidam:20070615104221
changed 1 file
MAIN

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

- -1
- +2
./upgrade/upgrade-1.3d5-1.3d6.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3d5-1.3d6.sql

12:39 pm

davidam

More
MAIN:davidam:20070615103914
changed 1 file
MAIN

add reading info creation scripts

- -0
- +4
./forums-create.sql
- History
- Source
- Diff
./forums-create.sql

12:35 pm

davidam

More
MAIN:davidam:20070615103552
added 1 file
MAIN

creation

- -0
- +213
./forums-reading-info-package-create.sql
- History
- Source
./forums-reading-info-package-create.sql

2:35 pm

davidam

More
MAIN:davidam:20070604123521
added 1 file
MAIN

creation: load the reading_info script

- -0
- +1
./upgrade/upgrade-1.3d5-1.3d6.sql
- History
- Source
./upgrade/upgrade-1.3d5-1.3d6.sql

5:56 pm

davidam

More
MAIN:davidam:20070601155657
added 2 files
MAIN

creation

- -0
- +50
./forums-reading-info-create.sql
- History
- Source
./forums-reading-info-create.sql
- -0
- +18
./forums-reading-info-drop.sql
- History
- Source
./forums-reading-info-drop.sql

10:14 pm

donb

More
MAIN:donb:20070515201413
changed 1557 files
MAIN

Merged changes to HEAD ...

- -0
- +96
./upgrade/upgrade-1.3d3-1.3d4.sql
- History
- Source
- Diff
./upgrade/upgrade-1.3d3-1.3d4.sql
… 1556 more files in changeset.

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.