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: 30 Apr
Commits this week: 0
Total Lines of Code (LoC): 6,938
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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 07 Aug 2005
3:51 am

marka

now made ambiguous by acs_objects.title

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
Tuesday 05 Jul 2005
4:46 pm

andrewg

Updated the plsql which was out of date. No using the news-create.sql v1.8.4.1 code.

Options
    • -32
    • +15
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.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

victorg

file news-sc-create.sql was added on branch oacs-5-2 on 2005-09-26 09:08:49 +0000

Options
    • -0
    • +0
    ./postgresql/news-sc-create.sql
1:15 am

victorg

file news-sc-drop.sql was added on branch oacs-5-2 on 2005-09-26 09:08:49 +0000

Options
    • -0
    • +0
    ./postgresql/news-sc-drop.sql
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.
Thursday 23 Dec 2004
8:41 am

maltes

Applied patch #614. Hope these kind of patches are immediately commited, safes some work....

Options
    • -2
    • +2
    ./oracle/news-create.sql
    • -2
    • +2
    ./postgresql/news-create.sql
    • -2
    • +2
    ./postgresql/news-drop.sql
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.
Friday 17 Oct 2003
4:50 pm

daveb

Added view news_items_live_or_submitted to upgrade script.

Options
    • -0
    • +96
    ./postgresql/upgrade/upgrade-4.1.0b-4.6.sql
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.
Monday 08 Sep 2003
9:04 pm

daveb

Merge in fix for postgresql 7.3 from HEAD.

Options
    • -32
    • +23
    ./postgresql/news-create.sql
Thursday 28 Aug 2003
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -2
    • +3
    ./oracle/news-create.sql
    • -2
    • +2
    ./postgresql/news-create.sql
  3. … 815 more files in changeset.
Saturday 23 Aug 2003
10:23 pm

tilmanns

Moved drop of depending function to the end, changed acs_objects__drop_type to content_type__drop_type.

Options
    • -16
    • +22
    ./postgresql/news-drop.sql
9:20 pm

tilmanns

Fixes Bug #678: Error in news__status, pg date math problem, patch by Gabriel Burca

Options
    • -10
    • +10
    ./postgresql/news-create.sql
Tuesday 17 Jun 2003
4:55 pm

peterm

making news items have their package instance as context_id. This is a convention that all packages should follow for permissions to work as expected

Options
    • -2
    • +3
    ./oracle/news-create.sql
    • -2
    • +2
    ./postgresql/news-create.sql
Saturday 17 May 2003
12:47 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -12
    • +12
    ./postgresql/news-create.sql
    • -8
    • +8
    ./postgresql/news-drop.sql
  3. … 40 more files in changeset.
Wednesday 12 Mar 2003
4:43 pm

donb

Views were returning dates rather than timestamps and screwing things up.

Options
    • -5
    • +5
    ./oracle/news-create.sql
    • -8
    • +8
    ./postgresql/news-create.sql
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
    • -12
    • +12
    ./postgresql/news-create.sql
    • -8
    • +8
    ./postgresql/news-drop.sql
  3. … 38 more files in changeset.
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
    • -13
    • +1
    ./postgresql/news-create.sql
  2. … 7 more files in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -0
    • +581
    ./oracle/upgrade/upgrade-4.1.0b-4.6.sql
    • -0
    • +64
    ./postgresql/upgrade/upgrade-4.1.0b-4.6.sql
  3. … 102 more files in changeset.
Tuesday 29 Oct 2002
2:52 am

vinodk

file upgrade-4.1.0b-4.6.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-4.1.0b-4.6.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.1.0b-4.6.sql
2:51 am

vinodk

- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

Options
    • -0
    • +581
    ./oracle/upgrade/upgrade-4.1.0b-4.6.sql
    • -0
    • +64
    ./postgresql/upgrade/upgrade-4.1.0b-4.6.sql
  3. … 29 more files in changeset.
Wednesday 17 Jul 2002
10:20 pm

chak

added news and faq dotlrn applets

Options
    • -1
    • +67
    ./postgresql/news-create.sql
    • -1
    • +2
    ./postgresql/news-drop.sql
  3. … 15 more files in changeset.