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: 26 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 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 14 May 2016
7:33 pm

gustafn

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

Options
    • -6
    • +4
    ./postgresql/forums-forums-create.sql
    • -5
    • +3
    ./postgresql/forums-messages-create.sql
    • -5
    • +5
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-1.3d12-1.3d13.sql
  5. … 1 more file in changeset.
7:33 pm

gustafn

file upgrade-1.3d12-1.3d13.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.3d12-1.3d13.sql
Sunday 11 Oct 2015
8:10 pm

gustafn

- add function args for completeness

Options
    • -0
    • +1
    ./postgresql/forums-reading-info-create.sql
Tuesday 30 Jun 2015
1:39 pm

gustafn

- add function args missed by earlier upgrades

- bump version numbers

Options
    • -0
    • +21
    ./postgresql/upgrade/upgrade-1.3d10-1.3d11.sql
  2. … 9 more files in changeset.
Tuesday 03 Sep 2013
9:34 pm

gustafn

- fix half-baken dollar quoting

Options
    • -3
    • +6
    ./postgresql/forums-forums-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-1.1.2d4-1.1.2d5.sql
Sunday 25 Aug 2013
12:04 pm

gustafn

- fix half-baken dollar quoting

Options
    • -3
    • +6
    ./postgresql/forums-forums-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-1.1.2d4-1.1.2d5.sql
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
    ./postgresql/forums-forums-create.sql
    • -16
    • +16
    ./postgresql/forums-forums-drop.sql
    • -32
    • +51
    ./postgresql/forums-forums-package-create.sql
    • -13
    • +13
    ./postgresql/forums-messages-create.sql
    • -5
    • +5
    ./postgresql/forums-messages-drop.sql
    • -82
    • +132
    ./postgresql/forums-messages-package-create.sql
    • -45
    • +53
    ./postgresql/forums-notifications-init.sql
    • -37
    • +52
    ./postgresql/forums-notifications-sanitize.sql
    • -55
    • +116
    ./postgresql/forums-reading-info-create.sql
    • -33
    • +40
    ./postgresql/forums-sc-create.sql
    • -7
    • +14
    ./postgresql/forums-tree-create.sql
    • -44
    • +70
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
    • -7
    • +16
    ./postgresql/upgrade/upgrade-0.2d-0.3d.sql
    • -47
    • +76
    ./postgresql/upgrade/upgrade-1.0.6-1.0.7d.sql
    • -23
    • +30
    ./postgresql/upgrade/upgrade-1.0d4-1.0.1d2.sql
  16. … 9 more files in changeset.
Monday 10 Nov 2008
12:29 am

donb

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

2. Bump version numbers to 2.5.0d1.

Options
    • -2
    • +1
    ./oracle/forums-reading-info-drop.sql
    • -57
    • +140
    ./oracle/forums-reading-info-package-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-1.3d5-1.3d6.sql
  4. … 377 more files in changeset.
Saturday 24 May 2008
12:10 pm

marioa

Fixed package forum-reading-info for Oracle.

Options
    • -3
    • +2
    ./oracle/forums-reading-info-drop.sql
    • -57
    • +140
    ./oracle/forums-reading-info-package-create.sql
Thursday 01 May 2008
3:28 am

emmar

Fix path of the upgrade script to source

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-1.3d5-1.3d6.sql
Wednesday 23 Apr 2008
6:04 pm

marioa

Fixed packaged body bug

Options
    • -1
    • +1
    ./oracle/forums-reading-info-package-create.sql
Friday 15 Jun 2007
12:42 pm

davidam

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

Options
    • -1
    • +2
    ./oracle/upgrade/upgrade-1.3d5-1.3d6.sql
12:39 pm

davidam

add reading info creation scripts

Options
    • -0
    • +4
    ./oracle/forums-create.sql
12:35 pm

davidam

creation

Options
    • -0
    • +213
    ./oracle/forums-reading-info-package-create.sql
Monday 04 Jun 2007
2:50 pm

davidam

creation

Options
    • -0
    • +22
    ./postgresql/forums-reading-info-drop.sql
2:43 pm

davidam

fixed some problems with constraints

Options
    • -3
    • +4
    ./postgresql/forums-reading-info-create.sql
2:35 pm

davidam

creation: load the reading_info script

Options
    • -0
    • +1
    ./oracle/upgrade/upgrade-1.3d5-1.3d6.sql
Friday 01 Jun 2007
5:56 pm

davidam

creation

Options
    • -0
    • +50
    ./oracle/forums-reading-info-create.sql
    • -0
    • +18
    ./oracle/forums-reading-info-drop.sql
Thursday 31 May 2007
10:33 am

davidam

Insert forums-reading-info-drop to drop

Options
    • -0
    • +3
    ./postgresql/forums-drop.sql
Tuesday 22 May 2007
11:42 am

michaelt

store and display reading info

Options
    • -0
    • +4
    ./postgresql/forums-create.sql
    • -0
    • +225
    ./postgresql/forums-reading-info-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-1.3d5-1.3d6.sql
  4. … 17 more files in changeset.
Tuesday 15 May 2007
10:14 pm

donb

Merged changes to HEAD ...

Options
    • -0
    • +96
    ./oracle/upgrade/upgrade-1.3d3-1.3d4.sql
    • -0
    • +42
    ./postgresql/upgrade/upgrade-1.3d3-1.3d4.sql
  3. … 1555 more files in changeset.
Sunday 21 Jan 2007
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.

Options
    • -1
    • +95
    ./oracle/upgrade/upgrade-1.3d3-1.3d4.sql
    • -1
    • +41
    ./postgresql/upgrade/upgrade-1.3d3-1.3d4.sql
8:03 am

maltes

Made sure that old forum instances have the package_id set correctly. For newer ones acs_object__new should take care of it.

Options
    • -0
    • +2
    ./oracle/upgrade/upgrade-1.3d3-1.3d4.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-1.3d3-1.3d4.sql
  3. … 1 more file in changeset.
8:03 am

maltes

file upgrade-1.3d3-1.3d4.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-1.3d3-1.3d4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.3d3-1.3d4.sql
Tuesday 08 Aug 2006
11:26 pm

donb

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

Options
    • -22
    • +14
    ./oracle/forums-forums-create.sql
    • -14
    • +5
    ./oracle/forums-forums-drop.sql
    • -8
    • +20
    ./oracle/forums-messages-package-create.sql
    • -0
    • +90
    ./oracle/upgrade/upgrade-1.0.6-1.0.7d.sql
    • -3
    • +27
    ./oracle/upgrade/upgrade-1.1.1-1.1.2d1.sql
    • -0
    • +48
    ./oracle/upgrade/upgrade-1.1.2d4-1.1.2d5.sql
    • -0
    • +12
    ./oracle/upgrade/upgrade-1.2.0d3-1.2.0d4.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-1.2.0d4-1.3d1.sql
    • -34
    • +28
    ./oracle/upgrade/upgrade-1.2d1-1.2d2.sql
    • -3
    • +3
    ./postgresql/forums-drop.sql
    • -22
    • +18
    ./postgresql/forums-forums-create.sql
    • -14
    • +8
    ./postgresql/forums-forums-drop.sql
    • -1
    • +1
    ./postgresql/forums-messages-package-drop.sql
    • -6
    • +6
    ./postgresql/forums-sc-create.sql
    • -2
    • +10
    ./postgresql/forums-sc-drop.sql
  16. … 2464 more files in changeset.
Wednesday 28 Jun 2006
10:30 pm

veronicac

Initial import of forums version 1.2.0d4

Options
    • -0
    • +0
    ./oracle/forums-drop.sql
    • -5
    • +114
    ./oracle/forums-notifications-sanitize.sql
    • -34
    • +46
    ./oracle/forums-search-create.sql
    • -11
    • +16
    ./oracle/forums-search-drop.sql
    • -0
    • +0
    ./oracle/forums-tree-drop.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
    • -0
    • +402
    ./oracle/upgrade/upgrade-1.0.6-1.0.7d.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-1.0d2-1.0d3.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-1.0d3-1.0d4.sql
    • -0
    • +285
    ./oracle/upgrade/upgrade-1.0d4-1.0.1d2.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-1.1.1-1.1.2d1.sql
    • -0
    • +48
    ./oracle/upgrade/upgrade-1.1.2d4-1.1.2d5.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-1.1d1-1.1d2.sql
  16. … 256 more files in changeset.
10:30 pm

veronicac

Initial import of forums version 1.2.0d4

Options
    • -1
    • +0
    ./oracle/forums-create.sql
    • -61
    • +68
    ./oracle/forums-forums-create.sql
    • -3
    • +20
    ./oracle/forums-forums-drop.sql
    • -69
    • +77
    ./oracle/forums-forums-package-create.sql
    • -59
    • +72
    ./oracle/forums-messages-create.sql
    • -0
    • +3
    ./oracle/forums-messages-drop.sql
    • -178
    • +342
    ./oracle/forums-messages-package-create.sql
    • -0
    • +61
    ./oracle/forums-notifications-init.sql
    • -30
    • +29
    ./oracle/forums-tree-create.sql
  10. … 35 more files in changeset.
Thursday 11 May 2006
1:56 pm

emmar

Update package_id for projects

Options
    • -0
    • +11
    ./oracle/upgrade/upgrade-1.2.0d4-1.3d1.sql
1:56 pm

emmar

file upgrade-1.2.0d4-1.3d1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-1.2.0d4-1.3d1.sql
Wednesday 10 May 2006
8:50 pm

maltes

file upgrade-1.2.0d4-1.3d1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.2.0d4-1.3d1.sql