OpenACS / openacs-4 / packages / news

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 23
Last Commit: 17:24
Commits this week: 0
Total Lines of Code (LoC): 7,060
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./postgresql/news-create.sql
    • -0
    • +0
    ./postgresql/news-drop.sql
    • -0
    • +0
    ./postgresql/news-package-create.sql
  4. … 1462 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -3
    • +3
    ./postgresql/news-create.sql
    • -4
    • +19
    ./postgresql/news-drop.sql
    • -4
    • +5
    ./postgresql/news-package-create.sql
    • -0
    • +106
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  5. … 8096 more files in changeset.
Wednesday 17 Mar 2021
2:51 pm

gernst

file upgrade-5.10.0d3-5.10.0d4.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
Wednesday 15 Aug 2018
6:49 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  2. … 26 more files in changeset.
Thursday 05 Apr 2018
12:05 am

hectorr

Fix typos

Options
    • -1
    • +1
    ./oracle/news-package-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.1.0b-4.6.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.6-5.0d1.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -2
    • +2
    ./postgresql/news-package-create.sql
  7. … 4 more files in changeset.
Wednesday 04 Apr 2018
8:51 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./oracle/news-package-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.1.0b-4.6.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.6-5.0d1.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -2
    • +2
    ./postgresql/news-package-create.sql
  7. … 29 more files in changeset.
Saturday 24 Mar 2018
12:53 am

hectorr

Fix more typos

Options
    • -2
    • +2
    ./oracle/news-drop.sql
  2. … 84 more files in changeset.
Wednesday 31 Jan 2018
9:27 pm

gustafn

fix typos

Options
    • -2
    • +2
    ./postgresql/news-drop.sql
  2. … 7 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -96
    • +55
    ./postgresql/news-package-create.sql
    • -0
    • +16
    ./postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql
    • -0
    • +127
    ./postgresql/upgrade/upgrade-5.9.0d1-5.9.0d2.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql
    • -0
    • +74
    ./postgresql/upgrade/upgrade-5.9.1b1-5.9.1b2.sql
  6. … 7830 more files in changeset.
Thursday 16 Feb 2017
1:42 pm

gustafn

file upgrade-5.9.1b1-5.9.1b2.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1b1-5.9.1b2.sql
Thursday 11 Aug 2016
2:56 pm

gustafn

file upgrade-5.9.0-5.9.1d1.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql
2:56 pm

gustafn

file upgrade-5.9.0d2-5.9.0d3.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql
Friday 25 Sep 2015
10:25 am

gustafn

file upgrade-5.9.0d1-5.9.0d2.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.0d1-5.9.0d2.sql
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -25
    • +39
    ./postgresql/news-create.sql
    • -42
    • +56
    ./postgresql/news-drop.sql
    • -170
    • +258
    ./postgresql/news-package-create.sql
    • -8
    • +18
    ./postgresql/upgrade/upgrade-4.1.0b-4.6.sql
    • -14
    • +23
    ./postgresql/upgrade/upgrade-4.6-5.0d1.sql
    • -69
    • +86
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -51
    • +66
    ./postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
    • -9
    • +19
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
    • -42
    • +51
    ./postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
  10. … 2539 more files in changeset.
Monday 08 Nov 2010
8:23 am

victorg

PG 9.0 compatibility. Avoiding fetching next value of sequences using a view.

Options
    • -2
    • +2
    ./postgresql/news-package-create.sql
    • -0
    • +135
    ./postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
  3. … 4 more files in changeset.
Wednesday 23 Dec 2009
9:53 pm

donb

Forgot to add my upgrade scripts ...

Options
    • -0
    • +205
    ./oracle/upgrade/upgrade-5.5.1d1-5.6.0d1.sql
    • -0
    • +207
    ./postgresql/upgrade/upgrade-5.5.1d1-5.6.0d1.sql
Tuesday 22 Dec 2009
11:24 pm

donb

Changed to use richtext and a bit of other clean-up. Tested news item create,

edit, upload from file, notifications, rss, view, admin view, etc for PG. Testing

for Oracle is next and if bugs are found, there will be a commit soon.

Options
    • -9
    • +8
    ./oracle/news-views-create.sql
    • -4
    • +4
    ./postgresql/news-views-create.sql
  3. … 21 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
    • -32
    • +15
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
    • -1
    • +2
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -9
    • +18
    ./postgresql/news-package-create.sql
    • -0
    • +30
    ./postgresql/news-sc-create.sql
    • -0
    • +13
    ./postgresql/news-sc-drop.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
    • -0
    • +76
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  9. … 2471 more files in changeset.
Wednesday 19 Apr 2006
1:44 pm

roelc

file upgrade-5.2.0d5-5.2.0d6.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
Saturday 26 Mar 2005
10:45 pm

jeffd

make getting url work for item_id when > 1 rev, make revision_set_active denormalize the title to acs_objects

Options
    • -12
    • +16
    ./postgresql/news-package-create.sql
    • -0
    • +27
    ./postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
  3. … 1 more file in changeset.
9:54 pm

jeffd

add the upgrade script, make news__url work for item or revision

Options
    • -0
    • +128
    ./postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
  2. … 2 more files in changeset.
2:49 pm

jeffd

make search rss support work, make nice urls work, propigate title to acs_objects

Options
    • -30
    • +36
    ./postgresql/news-package-create.sql
  2. … 12 more files in changeset.
Thursday 24 Feb 2005
7:03 pm

jeffd

add lead and associated image to news story, clean up markup some, break package, views out from create.sql

Options
    • -771
    • +14
    ./oracle/news-create.sql
    • -14
    • +3
    ./oracle/news-drop.sql
    • -0
    • +578
    ./oracle/news-package-create.sql
    • -0
    • +206
    ./oracle/news-views-create.sql
    • -0
    • +8
    ./oracle/news-views-drop.sql
    • -0
    • +796
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -719
    • +19
    ./postgresql/news-create.sql
    • -15
    • +4
    ./postgresql/news-drop.sql
    • -0
    • +505
    ./postgresql/news-package-create.sql
    • -0
    • +7
    ./postgresql/news-package-drop.sql
    • -0
    • +217
    ./postgresql/news-views-create.sql
    • -0
    • +8
    ./postgresql/news-views-drop.sql
    • -0
    • +388
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  14. … 40 more files in changeset.
Thursday 03 Feb 2005
1:15 am

jeffd

bind the news contracts with a tcl spec

Options
    • -2
    • +3
    ./postgresql/news-create.sql
    • -2
    • +5
    ./postgresql/news-drop.sql
    • -30
    • +0
    ./postgresql/news-sc-create.sql
    • -13
    • +0
    ./postgresql/news-sc-drop.sql
  5. … 2 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
    • -2
    • +2
    ./oracle/news-create.sql
    • -1
    • +2
    ./postgresql/news-drop.sql
  3. … 2274 more files in changeset.
Monday 05 Jul 2004
5:05 pm

jeffd

drop news plpgsql with drop_package, no need to drop attributes individually, just drop the content type

Options
    • -50
    • +2
    ./postgresql/news-drop.sql
Friday 12 Mar 2004
8:19 pm

jeffd

various bug fixes for package_id, title addition to acs_objects

Options
    • -2
    • +2
    ./postgresql/news-create.sql
  2. … 12 more files in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +588
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
  2. … 23 more files in changeset.
Monday 06 Oct 2003
2:11 pm

peterm

fixing bug 240 - internationalization of news publish status. Making the PLSQL function news_status return only a short name status instead of human readable text. Instead generating human readable text from new Tcl proc news_pretty_status. Bumping version number to 5.0d1. Providing an automated test covering both functions.

Options
    • -34
    • +23
    ./oracle/news-create.sql
    • -0
    • +673
    ./oracle/upgrade/upgrade-4.6-5.0d1.sql
    • -50
    • +27
    ./postgresql/news-create.sql
    • -0
    • +145
    ./postgresql/upgrade/upgrade-4.6-5.0d1.sql
  5. … 7 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -8
    • +8
    ./oracle/news-create.sql
    • -3
    • +3
    ./oracle/news-drop.sql
  3. … 274 more files in changeset.