OpenACS / openacs-4 / packages / news / sql / postgresql

upgrade

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 12:40
Commits this week: 0
Total Lines of Code (LoC): 1,467
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 49 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 17 Mar 2021
2:51 pm

gernst

Use "latest_revision" as revision_id for the newly created news-item when it is created with "is_live_p" set to false

Options
    • -0
    • +106
    ./upgrade-5.10.0d3-5.10.0d4.sql
  2. … 2 more files in changeset.
2:51 pm

gernst

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

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

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./upgrade-5.2.0d5-5.2.0d6.sql
  2. … 26 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -0
    • +16
    ./upgrade-5.9.0-5.9.1d1.sql
    • -0
    • +127
    ./upgrade-5.9.0d1-5.9.0d2.sql
    • -0
    • +11
    ./upgrade-5.9.0d2-5.9.0d3.sql
    • -0
    • +74
    ./upgrade-5.9.1b1-5.9.1b2.sql
  5. … 7831 more files in changeset.
Saturday 18 Feb 2017
6:38 pm

gustafn

Remove leftover from old installations (perform cleanup which was missing since Feb 2005)

Options
    • -0
    • +5
    ./upgrade-5.9.1b1-5.9.1b2.sql
Thursday 16 Feb 2017
1:42 pm

gustafn

Don't call deprecated version of content_revision__new

Options
    • -0
    • +69
    ./upgrade-5.9.1b1-5.9.1b2.sql
  2. … 2 more files in changeset.
1:42 pm

gustafn

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

Options
    • -0
    • +0
    ./upgrade-5.9.1b1-5.9.1b2.sql
Thursday 11 Aug 2016
3:03 pm

gustafn

- clean dirty editor buffer

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

gustafn

- Cleanup cr_revisions belonging to the news package, for which there

are no news_id in cr_news. These entries were created since ever in

the news package. The bug adding spurious revisions was fixed with

the OpenACS 5.9.0 release, this upgrade scripts removes leftovers

of the earlier bug.

Options
    • -0
    • +15
    ./upgrade-5.9.0-5.9.1d1.sql
    • -0
    • +11
    ./upgrade-5.9.0d2-5.9.0d3.sql
  3. … 1 more file in changeset.
2:56 pm

gustafn

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

Options
    • -0
    • +0
    ./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
    ./upgrade-5.9.0d2-5.9.0d3.sql
Friday 25 Sep 2015
10:25 am

gustafn

- fix bug: don't create two revisions for every news entry

- remove redundant operations from news__new()

- use default instead of two functions in news__archive()

- fix bug: don't overwrite title with lead text in search contract

- update comments

- bump version number to 5.9.0d2

Options
    • -0
    • +127
    ./upgrade-5.9.0d1-5.9.0d2.sql
  2. … 4 more files in changeset.
10:25 am

gustafn

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

Options
    • -0
    • +0
    ./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
    • -8
    • +18
    ./upgrade-4.1.0b-4.6.sql
    • -14
    • +23
    ./upgrade-4.6-5.0d1.sql
    • -69
    • +86
    ./upgrade-5.2.0d1-5.2.0d2.sql
    • -51
    • +66
    ./upgrade-5.2.0d2-5.2.0d3.sql
    • -9
    • +19
    ./upgrade-5.2.0d5-5.2.0d6.sql
    • -42
    • +51
    ./upgrade-5.6.0d1-5.6.0d2.sql
  7. … 2542 more files in changeset.
Saturday 02 Nov 2013
5:08 pm

gustafn

- use $$ quoting in postgres SQL

- use named parameters for SQL functions

- fix/complete define_function_args

Options
    • -8
    • +18
    ./upgrade-4.1.0b-4.6.sql
    • -14
    • +23
    ./upgrade-4.6-5.0d1.sql
    • -69
    • +86
    ./upgrade-5.2.0d1-5.2.0d2.sql
    • -51
    • +66
    ./upgrade-5.2.0d2-5.2.0d3.sql
    • -9
    • +19
    ./upgrade-5.2.0d5-5.2.0d6.sql
    • -43
    • +52
    ./upgrade-5.6.0d1-5.6.0d2.sql
  7. … 3 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
    • -0
    • +135
    ./upgrade-5.6.0d1-5.6.0d2.sql
  2. … 5 more files in changeset.
Wednesday 23 Dec 2009
9:53 pm

donb

Forgot to add my upgrade scripts ...

Options
    • -0
    • +207
    ./upgrade-5.5.1d1-5.6.0d1.sql
  2. … 1 more file in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

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

Options
    • -2
    • +2
    ./upgrade-5.2.0d1-5.2.0d2.sql
    • -2
    • +2
    ./upgrade-5.2.0d2-5.2.0d3.sql
    • -0
    • +76
    ./upgrade-5.2.0d5-5.2.0d6.sql
  4. … 2476 more files in changeset.
Wednesday 19 Apr 2006
1:44 pm

roelc

Fix for news__clone plsql, added lead var for news__new

Options
    • -0
    • +76
    ./upgrade-5.2.0d5-5.2.0d6.sql
  2. … 2 more files in changeset.
1:44 pm

roelc

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

Options
    • -0
    • +0
    ./upgrade-5.2.0d5-5.2.0d6.sql
Wednesday 04 Jan 2006
9:21 pm

daveb

Fix another missing comma!

Options
    • -1
    • +1
    ./upgrade-5.2.0d2-5.2.0d3.sql
9:17 pm

daveb

Add missing comma

Options
    • -1
    • +1
    ./upgrade-5.2.0d2-5.2.0d3.sql
Sunday 07 Aug 2005
3:51 am

marka

now made ambiguous by acs_objects.title

Options
    • -2
    • +2
    ./upgrade-5.2.0d1-5.2.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
    • -0
    • +27
    ./upgrade-5.2.0d2-5.2.0d3.sql
  2. … 2 more files in changeset.
9:54 pm

jeffd

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

Options
    • -0
    • +128
    ./upgrade-5.2.0d2-5.2.0d3.sql
  2. … 2 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
    • -0
    • +388
    ./upgrade-5.2.0d1-5.2.0d2.sql
  2. … 52 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
    ./upgrade-4.1.0b-4.6.sql
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
    • -0
    • +145
    ./upgrade-4.6-5.0d1.sql
  2. … 10 more files in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -0
    • +64
    ./upgrade-4.1.0b-4.6.sql
  2. … 103 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
    ./upgrade-4.1.0b-4.6.sql
  2. … 1 more file in changeset.