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

forums-forums-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 13
Last Commit: 23 Apr
Commits this week: 0
Total Lines of Code (LoC): 109
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 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Mar 2020
8:50 pm

antoniop

Redefine forum charter as text, therefore without length limit

Options
    • -3
    • +17
    ./forums-forums-create.sql
  2. … 2 more files in changeset.
Tuesday 18 Jun 2019
8:38 pm

hectorr

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.

Options
    • -1
    • +4
    ./forums-forums-create.sql
  2. … 4 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
    • -0
    • +3
    ./forums-forums-create.sql
  2. … 10 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
    • +3
    ./forums-forums-create.sql
  2. … 21 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -6
    • +4
    ./forums-forums-create.sql
  2. … 7834 more files in changeset.
Saturday 14 May 2016
7:33 pm

gustafn

Alter caveman style booleans (type character(1)) to real SQL boolean types.

Options
    • -6
    • +4
    ./forums-forums-create.sql
  2. … 4 more files in changeset.
Tuesday 03 Sep 2013
9:34 pm

gustafn

- fix half-baken dollar quoting

Options
    • -3
    • +6
    ./forums-forums-create.sql
  2. … 1 more file in changeset.
Sunday 25 Aug 2013
12:04 pm

gustafn

- fix half-baken dollar quoting

Options
    • -3
    • +6
    ./forums-forums-create.sql
  2. … 1 more file 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
    • -10
    • +11
    ./forums-forums-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
    • -22
    • +18
    ./forums-forums-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
    • -78
    • +84
    ./forums-forums-create.sql
  2. … 270 more files in changeset.
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
  2. … 6 more files in changeset.
Tuesday 13 Dec 2005
11:24 pm

rocaelh

perfomance improvements

Options
    • -0
    • +5
    ./forums-forums-create.sql
  2. … 3 more files 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
    • +12
    ./forums-forums-create.sql
  2. … 91 more files in changeset.
Monday 25 Jul 2005
9:42 pm

andrewg

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

Options
    • -21
    • +12
    ./forums-forums-create.sql
  2. … 8 more files in changeset.
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
    • +3
    ./forums-forums-create.sql
  2. … 2275 more files in changeset.
Thursday 23 Dec 2004
3:12 am

donb

Added tracking of threads in a forum and replies to a root post to the

forums-forums and forums-messages datamodel, and fixed the necessary code.

Also cleaned up some stuff and wrote a test case for automated testing. PG

only at this point, will add the Oracle stuff shortly.

Options
    • -0
    • +3
    ./forums-forums-create.sql
  2. … 15 more files in changeset.
Saturday 17 May 2003
12:37 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -1
    • +1
    ./forums-forums-create.sql
  2. … 64 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -1
    • +1
    ./forums-forums-create.sql
  2. … 39 more files in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -13
    • +2
    ./forums-forums-create.sql
  2. … 103 more files in changeset.
Friday 22 Nov 2002
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
    • -13
    • +2
    ./forums-forums-create.sql
  2. … 16 more files in changeset.
Wednesday 10 Jul 2002
8:30 pm

rmello

Fixed Data Change Violation error for PG 7.1.

Options
    • -23
    • +18
    ./forums-forums-create.sql
Tuesday 25 Jun 2002
12:37 am

yon

cleaning up while trying to get postgres port working

Options
    • -14
    • +14
    ./forums-forums-create.sql
  2. … 4 more files in changeset.
Wednesday 12 Jun 2002
5:24 pm

yon

now loads (and unloads) in postgres

Options
    • -79
    • +98
    ./forums-forums-create.sql
  2. … 12 more files in changeset.
Saturday 01 Jun 2002
9:02 pm

ben

added beginning of PG port

Options
    • -0
    • +99
    ./forums-forums-create.sql
  2. … 10 more files in changeset.