OpenACS / openacs-4 / packages / forums

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 30
Last Commit: 28 Dec
Commits this week: 0
Total Lines of Code (LoC): 7,294
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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    ./oracle/upgrade-0.1d-0.2d.sql
    • -0
    • +0
    ./postgresql/upgrade-0.1d-0.2d.sql
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
    • -1
    • +2
    ./oracle/forums-forums-create.sql
    • -2
    • +0
    ./oracle/forums-forums-package-create.sql
    • -0
    • +1
    ./oracle/forums-messages-create.sql
    • -1
    • +8
    ./oracle/forums-messages-package-create.sql
    • -0
    • +321
    ./oracle/upgrade-0.1d-0.2d.sql
    • -13
    • +2
    ./postgresql/forums-forums-create.sql
    • -2
    • +0
    ./postgresql/forums-forums-package-create.sql
    • -0
    • +1
    ./postgresql/forums-messages-create.sql
    • -1
    • +8
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +173
    ./postgresql/upgrade-0.1d-0.2d.sql
  11. … 7 more files in changeset.
Tuesday 20 Aug 2002
11:39 pm

arjun

message deletion fixes

Options
    • -7
    • +7
    ./postgresql/forums-messages-package-create.sql
  2. … 4 more files in changeset.
Friday 09 Aug 2002
10:51 pm

yon

copyright OpenForce -> MIT

Options
    • -2
    • +2
    ./oracle/forums-search-create.sql
    • -2
    • +2
    ./oracle/forums-search-drop.sql
  3. … 112 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
    ./postgresql/forums-forums-package-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
Monday 15 Jul 2002
5:25 pm

yon

some minor improvements

Options
    • -22
    • +23
    ./oracle/forums-search-create.sql
Friday 12 Jul 2002
5:20 pm

yon

grant execute on ctx_dll to user so that the dbms_job to sync the forums

context index can be scheduled by the user and not by the ctxsys user.

Options
    • -5
    • +3
    ./oracle/forums-search-create.sql
    • -7
    • +1
    ./oracle/forums-search-drop.sql
Thursday 11 Jul 2002
4:28 pm

yon

dbms_job for syncing index has to run as ctxsys (that sucks)

Options
    • -2
    • +8
    ./oracle/forums-search-create.sql
    • -2
    • +8
    ./oracle/forums-search-drop.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
    ./postgresql/forums-notifications-sanitize.sql
8:30 pm

rmello

Fixed Data Change Violation error for PG 7.1.

Options
    • -23
    • +18
    ./postgresql/forums-forums-create.sql
Tuesday 02 Jul 2002
4:00 am

yon

added search to forums. oracle version using intermedia, postgres version

simply using like statements for now. forums-search-create.sql and

forums-search-drop.sql aren't sourced automatically since they require manual

loading (must switch schema user at certain points) please follow the

instructions in the file. need to figure out a good way to do this.

Options
    • -0
    • +261
    ./oracle/forums-search-create.sql
    • -0
    • +61
    ./oracle/forums-search-drop.sql
  3. … 12 more files in changeset.
Monday 01 Jul 2002
6:08 am

ben

fixed forums for new notifications (PG version)

Options
    • -56
    • +110
    ./postgresql/forums-notifications-init.sql
5:46 am

ben

removed bogus file

Options
    • -25
    • +0
    ./oracle/forums-alerts-create.sql
Saturday 29 Jun 2002
2:21 am

ben

fixed notifications and forums for replies

Options
    • -0
    • +59
    ./oracle/forums-notifications-init.sql
  2. … 11 more files in changeset.
Friday 28 Jun 2002
2:14 am

yon

optimized tree trigger a little bit

Options
    • -32
    • +29
    ./oracle/forums-tree-create.sql
    • -23
    • +16
    ./postgresql/forums-tree-create.sql
  3. … 1 more file in changeset.
Tuesday 25 Jun 2002
9:32 pm

yon

adding some oracle data model scripts

Options
    • -0
    • +24
    ./oracle/forums-drop.sql
    • -0
    • +19
    ./oracle/forums-notifications-sanitize.sql
  3. … 1 more file in changeset.
8:09 pm

yon

postgres tree_sortkey trigger finally working

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

yon

cleaning up while trying to get postgres port working

Options
    • -62
    • +65
    ./oracle/forums-forums-create.sql
    • -61
    • +59
    ./oracle/forums-messages-create.sql
    • -14
    • +14
    ./postgresql/forums-forums-create.sql
    • -12
    • +4
    ./postgresql/forums-messages-create.sql
    • -1
    • +0
    ./postgresql/forums-tree-create.sql
Monday 24 Jun 2002
11:40 pm

yon

some more porting to postgres

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

yon

tree.increment_key() now does the lpadding for us

Options
    • -5
    • +7
    ./oracle/forums-tree-create.sql
  2. … 2 more files in changeset.
Wednesday 19 Jun 2002
5:11 pm

yon

fixing calls to tree functions in postgres queries

Options
    • -5
    • +5
    ./postgresql/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
    ./postgresql/forums-drop.sql
    • -79
    • +98
    ./postgresql/forums-forums-create.sql
    • -41
    • +46
    ./postgresql/forums-forums-drop.sql
    • -2
    • +1
    ./postgresql/forums-forums-package-create.sql
    • -2
    • +0
    ./postgresql/forums-forums-package-drop.sql
    • -56
    • +70
    ./postgresql/forums-messages-create.sql
    • -17
    • +13
    ./postgresql/forums-messages-drop.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-drop.sql
    • -42
    • +58
    ./postgresql/forums-notifications-init.sql
    • -0
    • +27
    ./postgresql/forums-notifications-sanitize.sql
    • -30
    • +37
    ./postgresql/forums-tree-create.sql
    • -0
    • +17
    ./postgresql/forums-tree-drop.sql
Tuesday 04 Jun 2002
1:58 am

yon

adding forums_message.name

Options
    • -71
    • +77
    ./oracle/forums-forums-package-create.sql
    • -1
    • +2
    ./oracle/forums-messages-create.sql
    • -183
    • +219
    ./oracle/forums-messages-package-create.sql
    • -1
    • +1
    ./postgresql/forums-forums-package-create.sql
    • -1
    • +1
    ./postgresql/forums-messages-create.sql
    • -36
    • +45
    ./postgresql/forums-messages-package-create.sql
  7. … 1 more file 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
    ./oracle/forums-forums-package-create.sql
    • -0
    • +2
    ./oracle/forums-messages-package-create.sql
    • -0
    • +2
    ./postgresql/forums-forums-package-create.sql
    • -0
    • +2
    ./postgresql/forums-messages-package-create.sql
Saturday 01 Jun 2002
9:02 pm

ben

added beginning of PG port

Options
    • -0
    • +24
    ./postgresql/forums-create.sql
    • -0
    • +99
    ./postgresql/forums-forums-create.sql
    • -0
    • +59
    ./postgresql/forums-forums-drop.sql
    • -0
    • +74
    ./postgresql/forums-forums-package-create.sql
    • -0
    • +20
    ./postgresql/forums-forums-package-drop.sql
    • -0
    • +82
    ./postgresql/forums-messages-create.sql
    • -0
    • +30
    ./postgresql/forums-messages-drop.sql
    • -0
    • +190
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +26
    ./postgresql/forums-messages-package-drop.sql
    • -0
    • +56
    ./postgresql/forums-notifications-init.sql
    • -0
    • +60
    ./postgresql/forums-tree-create.sql
Thursday 30 May 2002
8:08 pm

yon

moving ben's tree sortkey utilities for oracle from forums to acs-kernel

Options
    • -1
    • +0
    ./oracle/forums-create.sql
    • -201
    • +0
    ./oracle/tree-create.sql
  3. … 6 more files in changeset.
8:25 am

ben

added a few details like posting confirmation, links to correct community member page, default to forum name

Options
    • -1
    • +2
    ./oracle/forums-forums-create.sql
  2. … 9 more files in changeset.
Wednesday 29 May 2002
11:40 pm

ben

start of forums package

Options
    • -0
    • +0
    ./oracle/forums-alerts-create.sql
    • -0
    • +0
    ./oracle/forums-create.sql
    • -0
    • +0
    ./oracle/forums-forums-create.sql
    • -0
    • +0
    ./oracle/forums-forums-drop.sql
    • -0
    • +0
    ./oracle/forums-forums-package-create.sql
    • -0
    • +0
    ./oracle/forums-forums-package-drop.sql
    • -0
    • +0
    ./oracle/forums-messages-create.sql
    • -0
    • +0
    ./oracle/forums-messages-drop.sql
    • -0
    • +0
    ./oracle/forums-messages-package-create.sql
    • -0
    • +0
    ./oracle/forums-messages-package-drop.sql
    • -0
    • +0
    ./oracle/forums-notifications-init.sql
    • -0
    • +0
    ./oracle/forums-tree-create.sql
    • -0
    • +0
    ./oracle/tree-create.sql
  14. … 47 more files in changeset.
11:40 pm

ben

Initial revision

Options
    • -0
    • +25
    ./oracle/forums-alerts-create.sql
    • -0
    • +25
    ./oracle/forums-create.sql
    • -0
    • +90
    ./oracle/forums-forums-create.sql
    • -0
    • +54
    ./oracle/forums-forums-drop.sql
    • -0
    • +97
    ./oracle/forums-forums-package-create.sql
    • -0
    • +15
    ./oracle/forums-forums-package-drop.sql
    • -0
    • +82
    ./oracle/forums-messages-create.sql
    • -0
    • +33
    ./oracle/forums-messages-drop.sql
    • -0
    • +208
    ./oracle/forums-messages-package-create.sql
    • -0
    • +14
    ./oracle/forums-messages-package-drop.sql
    • -0
    • +57
    ./oracle/forums-notifications-init.sql
    • -0
    • +60
    ./oracle/forums-tree-create.sql
    • -0
    • +201
    ./oracle/tree-create.sql
  14. … 47 more files in changeset.