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: 20 Dec
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Thursday 30 May 2002
1:04 am

arjun

pl/sql proc to clone news items from one package to another

Options
    • -1
    • +61
    ./oracle/news-create.sql
  2. … 1 more file in changeset.
Tuesday 02 Apr 2002
4:18 pm

donb

Robert Locke's bug fixes that make news work with PG 7.2 as well as PG 7.1

Options
    • -9
    • +9
    ./postgresql/news-create.sql
  2. … 1 more file in changeset.
8:08 am

robertl

Removed interval keyword from news__status function.

Options
    • -9
    • +9
    ./postgresql/news-create.sql
Friday 26 Oct 2001
12:15 pm

robertl

Changed subtype to content item from content revision.

Options
    • -2
    • +2
    ./postgresql/news-create.sql
Thursday 25 Oct 2001
1:39 pm

robertl

Added search capability to news module.

Options
    • -3
    • +3
    ./oracle/news-create.sql
    • -1
    • +6
    ./postgresql/news-create.sql
    • -1
    • +6
    ./postgresql/news-drop.sql
    • -0
    • +30
    ./postgresql/news-sc-create.sql
    • -0
    • +13
    ./postgresql/news-sc-drop.sql
  6. … 6 more files in changeset.
1:03 pm

robertl

Changed my mind. Duh!

Options
    • -0
    • +888
    ./postgresql/news-create.sql
12:59 pm

robertl

Breaking news-create into 2 pieces.

Options
    • -887
    • +0
    ./postgresql/news-create.sql
Wednesday 24 Oct 2001
4:14 am

donb

news was subtyping content_revision with a NULL supertype. glossary-drop

broken for Oracle (probably still broken but it's better, I added stuff

I discovered as I worked on the PG version). The html doc had a missing

tag.

Options
    • -2
    • +2
    ./postgresql/news-create.sql
  2. … 2 more files in changeset.
Tuesday 16 Oct 2001
8:18 pm

donb

Fixed a few minor bugs and updated some info files...

Options
    • -9
    • +1
    ./oracle/news-create.sql
  2. … 6 more files in changeset.
9:06 am

robertl

Changed pretty_name and pretty_plural for news content type to 'News Article(s)' to avoid conflict with ETP.

Options
    • -3
    • +3
    ./postgresql/news-create.sql
Monday 15 Oct 2001
3:41 pm

robertl

First port of news. Tested on both Oracle and Postgres. Search is still missing in Postgres.

Options
    • -0
    • +887
    ./postgresql/news-create.sql
    • -0
    • +179
    ./postgresql/news-drop.sql
  3. … 48 more files in changeset.
Friday 20 Apr 2001
10:51 pm

donb

Forgot to define binary files before importing, so .gifs were messed up.

Options
    • -0
    • +0
    ./oracle/news-create.sql
    • -0
    • +0
    ./oracle/news-drop.sql
    • -0
    • +0
    ./oracle/news-sws-drop.sql
    • -0
    • +0
    ./oracle/news-sws.sql
  5. … 2476 more files in changeset.
10:51 pm

donb

Initial revision

Options
    • -0
    • +915
    ./oracle/news-create.sql
    • -0
    • +183
    ./oracle/news-drop.sql
    • -0
    • +29
    ./oracle/news-sws-drop.sql
    • -0
    • +217
    ./oracle/news-sws.sql
  5. … 2476 more files in changeset.