OpenACS / openacs-4 / packages / forums / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 26
Last Commit: 19:01
Commits this week: 0
Total Lines of Code (LoC): 3,082
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 a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 23 Feb 2003
7:19 pm

danw

forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

Options
    • -9
    • +0
    ./forums-forums-drop.sql
  2. … 7 more files in changeset.
Saturday 01 Feb 2003
12:03 am

jeffd

file upgrade-0.3d-0.4d.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade-0.3d-0.4d.sql
  2. … 1 more file in changeset.
12:02 am

jeffd

adds user_id and parent_id indexes in forums_messages, bump version to 0.4d, upgrade scripts

Options
    • -0
    • +4
    ./forums-messages-create.sql
    • -0
    • +3
    ./upgrade-0.3d-0.4d.sql
  3. … 3 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -1
    • +1
    ./forums-forums-package-create.sql
    • -1
    • +1
    ./forums-messages-package-create.sql
  3. … 53 more files in changeset.
Thursday 16 Jan 2003
2:48 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -0
    • +4
    ./forums-messages-create.sql
    • -1
    • +1
    ./forums-messages-package-create.sql
    • -0
    • +28
    ./upgrade-0.2d-0.3d.sql
  4. … 54 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -1
    • +1
    ./forums-forums-package-create.sql
    • -1
    • +1
    ./forums-messages-package-create.sql
  3. … 53 more files in changeset.
Tuesday 17 Dec 2002
11:48 am

jeffd

file upgrade-0.2d-0.3d.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade-0.2d-0.3d.sql
  2. … 1 more file in changeset.
11:48 am

jeffd

create necessary index, make forums_message__root_message_id isstrict, icachable, upgrade script

Options
    • -0
    • +4
    ./forums-messages-create.sql
    • -1
    • +1
    ./forums-messages-package-create.sql
    • -0
    • +28
    ./upgrade-0.2d-0.3d.sql
  4. … 3 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
    • +0
    ./forums-forums-package-create.sql
    • -0
    • +1
    ./forums-messages-create.sql
    • -1
    • +8
    ./forums-messages-package-create.sql
    • -0
    • +173
    ./upgrade-0.1d-0.2d.sql
  6. … 99 more files in changeset.
Friday 22 Nov 2002
7:38 pm

donb

file upgrade-0.1d-0.2d.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade-0.1d-0.2d.sql
  2. … 1 more file in changeset.
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
    • +0
    ./forums-forums-package-create.sql
    • -0
    • +1
    ./forums-messages-create.sql
    • -1
    • +8
    ./forums-messages-package-create.sql
    • -0
    • +173
    ./upgrade-0.1d-0.2d.sql
  6. … 12 more files in changeset.
Tuesday 20 Aug 2002
11:39 pm

arjun

message deletion fixes

Options
    • -7
    • +7
    ./forums-messages-package-create.sql
  2. … 4 more files in changeset.
Monday 05 Aug 2002
10:00 pm

arjun

added coalesces (where there's nvl's in the oracle version) to fix the perm bug where reg'd users can't see forums or posts

Options
    • -2
    • +2
    ./forums-forums-package-create.sql
    • -1
    • +1
    ./forums-messages-package-create.sql
Wednesday 10 Jul 2002
8:31 pm

rmello

Drop ACS Service Contract stuff and also rows inserted into a couple notifications tables.

Options
    • -0
    • +109
    ./forums-notifications-sanitize.sql
8:30 pm

rmello

Fixed Data Change Violation error for PG 7.1.

Options
    • -23
    • +18
    ./forums-forums-create.sql
Monday 01 Jul 2002
6:08 am

ben

fixed forums for new notifications (PG version)

Options
    • -56
    • +110
    ./forums-notifications-init.sql
Friday 28 Jun 2002
2:14 am

yon

optimized tree trigger a little bit

Options
    • -23
    • +16
    ./forums-tree-create.sql
  2. … 2 more files in changeset.
Tuesday 25 Jun 2002
8:09 pm

yon

postgres tree_sortkey trigger finally working

Options
    • -0
    • +3
    ./forums-tree-create.sql
12:37 am

yon

cleaning up while trying to get postgres port working

Options
    • -14
    • +14
    ./forums-forums-create.sql
    • -12
    • +4
    ./forums-messages-create.sql
    • -1
    • +0
    ./forums-tree-create.sql
  4. … 2 more files in changeset.
Monday 24 Jun 2002
11:40 pm

yon

some more porting to postgres

Options
    • -45
    • +43
    ./forums-forums-package-create.sql
    • -1
    • +2
    ./forums-messages-create.sql
    • -142
    • +159
    ./forums-messages-package-create.sql
    • -4
    • +4
    ./forums-tree-create.sql
  5. … 6 more files in changeset.
Wednesday 19 Jun 2002
5:11 pm

yon

fixing calls to tree functions in postgres queries

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

yon

now loads (and unloads) in postgres

Options
    • -0
    • +23
    ./forums-drop.sql
    • -79
    • +98
    ./forums-forums-create.sql
    • -41
    • +46
    ./forums-forums-drop.sql
    • -2
    • +1
    ./forums-forums-package-create.sql
    • -2
    • +0
    ./forums-forums-package-drop.sql
    • -56
    • +70
    ./forums-messages-create.sql
    • -17
    • +13
    ./forums-messages-drop.sql
    • -1
    • +1
    ./forums-messages-package-create.sql
    • -1
    • +1
    ./forums-messages-package-drop.sql
    • -42
    • +58
    ./forums-notifications-init.sql
    • -0
    • +27
    ./forums-notifications-sanitize.sql
    • -30
    • +37
    ./forums-tree-create.sql
    • -0
    • +17
    ./forums-tree-drop.sql
Tuesday 04 Jun 2002
1:58 am

yon

adding forums_message.name

Options
    • -1
    • +1
    ./forums-forums-package-create.sql
    • -1
    • +1
    ./forums-messages-create.sql
    • -36
    • +45
    ./forums-messages-package-create.sql
  4. … 4 more files in changeset.
Sunday 02 Jun 2002
6:50 am

yon

updating last modified times so we can easily keep track of newness

Options
    • -0
    • +2
    ./forums-forums-package-create.sql
    • -0
    • +2
    ./forums-messages-package-create.sql
  3. … 2 more files in changeset.
Saturday 01 Jun 2002
9:02 pm

ben

added beginning of PG port

Options
    • -0
    • +24
    ./forums-create.sql
    • -0
    • +99
    ./forums-forums-create.sql
    • -0
    • +59
    ./forums-forums-drop.sql
    • -0
    • +74
    ./forums-forums-package-create.sql
    • -0
    • +20
    ./forums-forums-package-drop.sql
    • -0
    • +82
    ./forums-messages-create.sql
    • -0
    • +30
    ./forums-messages-drop.sql
    • -0
    • +190
    ./forums-messages-package-create.sql
    • -0
    • +26
    ./forums-messages-package-drop.sql
    • -0
    • +56
    ./forums-notifications-init.sql
    • -0
    • +60
    ./forums-tree-create.sql