OpenACS / openacs-4 / packages / forums / sql / postgresql

forums-sc-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 30 Apr
Commits this week: 0
Total Lines of Code (LoC): 102
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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 29 Apr 2021
4:03 pm

antoniop

Handle correctly the indexing of moderated messages in fulltext search:

so far the fulltext search would also include unapproved messages and threads. With this reform we address this by:

- making sure unapproved threads are deleted from the index

- making sure new threads are added to the index only when the are approved

- making sure we unindex or reindex a thread whenever the approval state changes

- not fetching unapproved messages in the datasource callback, hence excluding them from the index

Note that Oracle has not been targeted by the reform. However, the situation improves for Oracle as well, because we won't render unmoderated messages in the datasource callback anymore.

Options
    • -6
    • +59
    ./forums-sc-create.sql
  2. … 3 more files in changeset.
Monday 12 Aug 2013
11:34 am

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -33
    • +40
    ./forums-sc-create.sql
  2. … 23 more files in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

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

Options
    • -6
    • +6
    ./forums-sc-create.sql
  2. … 2478 more files in changeset.
Wednesday 28 Jun 2006
10:30 pm

veronicac

Initial import of forums version 1.2.0d4

Options
    • -0
    • +95
    ./forums-sc-create.sql
  2. … 270 more files in changeset.
Saturday 08 Oct 2005
3:37 am

donb

Fixed drop script for the empty-package case at least.

Options
    • -6
    • +6
    ./forums-sc-create.sql
  2. … 3 more files in changeset.
Friday 30 Apr 2004
8:57 am

jeffd

fix typo not forums_forumss

Options
    • -1
    • +1
    ./forums-sc-create.sql
Tuesday 27 Apr 2004
2:11 pm

jeffd

add triggers to index forums themselves, small bug in the datasource func

Options
    • -0
    • +38
    ./forums-sc-create.sql
  2. … 1 more file in changeset.
Thursday 01 Apr 2004
10:03 pm

jeffd

add a forum_forum FtsContentProvider impl, move contract create to callbacks, should move notifications too, bump to 1.1d4, need forums_forums triggers still

Options
    • -21
    • +2
    ./forums-sc-create.sql
  2. … 7 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
    • +76
    ./forums-sc-create.sql
  2. … 816 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
    • +76
    ./forums-sc-create.sql
  2. … 3 more files in changeset.
11:40 am

peterm

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

Options
    • -0
    • +0
    ./forums-sc-create.sql