OpenACS / openacs-4 / packages / acs-content-repository / sql / postgresql

content-item.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 18
Last Commit: 02 May
Commits this week: 0
Total Lines of Code (LoC): 2,466
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 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 01 Nov 2018
9:43 am

gustafn

improve spelling

Options
    • -3
    • +3
    ./content-item.sql
  2. … 14 more files in changeset.
Sunday 25 Mar 2018
10:56 pm

hectorr

Fix typos

Options
    • -3
    • +3
    ./content-item.sql
  2. … 14 more files in changeset.
Wednesday 21 Feb 2018
3:00 pm

antoniop

Portrait management reform and correction

Moved logics to create a portrait in a proc in order to reuse it in other places

such as picture retrieval services (e.g. Bach picture retrieval at WU). Turns out

we were not doing our homeworks here: when the portrait is created into CR, a

cr_child_rel is created. When the portrait was erased though, this was not cleaned

up propely, leaving dangling acs_objects with no reference in cr_child_rels table.

On busy sites, this can grow in the ten thousands order of magnitude. Changes include

also fix for this behavior and tuples cleanup.

Options
    • -24
    • +23
    ./content-item.sql
  2. … 16 more files in changeset.
Monday 04 Sep 2017
8:23 am

gustafn

Fix typo in variable name "new_nls_language" (must be "new__nls_language")

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -767
    • +250
    ./content-item.sql
  2. … 7834 more files in changeset.
Sunday 03 May 2015
2:32 pm

gustafn

Scalability reform part 3 (content-repository):

- content_revision__del:

* Removed manual nulling of live_revision and latest_revision

by using appropriate ond delete actions on foreign keys

* Removed manual deletion of old_revision and new_revision in

cr_item_publish_audit by using "on delete cascade"

- content_item__del:

* Removed manual deletion of item_id in cr_item_publish_audit

by using "on delete cascade"

* Removed manual deletion of item_id in cr_release_periods

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_template_map

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_keyword_map

by using "on delete cascade"

* Removed manual deletion of direct permissions (was already

cascading)

- Added missing index for child_id to cr_child_rels.

This index was in the create scripts (with a non-conformant name),

but not in the upgrade scripts

- bump version number of acs-content-repository to 5.9.0d3

Options
    • -91
    • +52
    ./content-item.sql
  2. … 4 more files in changeset.
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
    • -279
    • +6
    ./content-item.sql
  2. … 2547 more files in changeset.
Thursday 07 Jul 2011
12:46 pm

gustafn

Bring PostgreSQL functions closer to the current level of PL/pgSQL:

- upgrade PL/pgSQL functions to the $$ notation (recommended since pg8.0, jan 2005).

- get rid of backslash usages in function definitions

- drop aliases in favor of named function arguments (recommended since pg8.0)

- fix wrong function_args, add missing function_args, align default semantics

with the defaults in pg (providing "null" as default means the argument is

optional).

- change return types of triggers from "opaque" to "trigger" (recommended since pg8.0)

- unify names of triggers *_tr

- removed some version dependencies of pg 7.2 and 7.3

Options
    • -676
    • +1097
    ./content-item.sql
  2. … 54 more files in changeset.
Wednesday 11 Jun 2008
2:08 am

donb

Removed stupid NOTICEs to the log file when deleting stuff. Slows large

deletes down a LOT and fills log file with GARBAGE.

Options
    • -14
    • +1
    ./content-item.sql
Monday 01 Oct 2007
12:15 pm

gustafn

add update script

Options
    • -21
    • +21
    ./content-item.sql
  2. … 1 more file in changeset.
Monday 17 Sep 2007
11:43 am

gustafn

Get rid of the postgres warning "adding missing FROM-clause entry " on sequences

Make "db_nextval acs_object_id_seq" more than twice as fast (from 948 microseconds to 378 microseconds)

Options
    • -8
    • +11
    ./content-item.sql
  2. … 9 more files in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -63
    • +35
    ./content-item.sql
  2. … 721 more files in changeset.
Saturday 26 Mar 2005
1:30 pm

jeffd

propigate title rather than name for content_item__new, bump to d15, upgrade

Options
    • -32
    • +30
    ./content-item.sql
  2. … 2 more files in changeset.
Sunday 20 Mar 2005
4:58 pm

jeffd

fix laundry list of bugs in content repository copy code.

duplicate version of the 11arg content_folder__new

copy_creation_ip rather than copy__creation_ip in content_revision__copy

content_folder__copy did not preserve context_id properly

content_item__copy2 had a bunch of unused varaibles -- removed them.

content_item__copy now preserves live_revision so things which copy an

item with a live revision to not have to explicitly publish the new copy

(which eg file storage did not do).

content_revision__copy did an insert into acs_objects without specifying

column names which breaks on a new install since the order is not as expected.

Options
    • -14
    • +28
    ./content-item.sql
  2. … 3 more files in changeset.
Thursday 24 Feb 2005
8:34 pm

jeffd

set live and latest to null so delete does not violate fk constraints

Options
    • -1
    • +4
    ./content-item.sql
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
    • -17
    • +8
    ./content-item.sql
  2. … 2275 more files in changeset.
Thursday 06 Jan 2005
5:52 pm

daveb

Fix __delete functions to have __del variant.

Options
    • -5
    • +13
    ./content-item.sql
  2. … 5 more files in changeset.
Wednesday 05 Jan 2005
4:39 pm

cesarh

Fixing the params in the function content_item__set_live_revision() changing the param item_id by revision_id

Options
    • -2
    • +2
    ./content-item.sql
Wednesday 01 Sep 2004
12:36 am

donb

Upgrade to track my earlier bug fix

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Monday 02 Aug 2004
3:40 pm

daveb

Make sure all versions of content_item__new behave in the same way, creating

a new revision if content or title is specified. Patch#580 from

Dave Manginelli fixes bug#2040.

Options
    • -4
    • +19
    ./content-item.sql
Tuesday 20 Jul 2004
5:19 pm

jvdongen

Fixed CR part of bug #1953

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Thursday 01 Jul 2004
6:33 pm

jeffd

add define_function_args definitions for most functions, bump to 5.2.0d5, upgrade script

Options
    • -4
    • +46
    ./content-item.sql
  2. … 9 more files in changeset.
Tuesday 29 Jun 2004
12:17 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

Options
    • -1
    • +1
    ./content-item.sql
  2. … 687 more files in changeset.
Wednesday 02 Jun 2004
12:54 am

donb

Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

Options
    • -12
    • +12
    ./content-item.sql
  2. … 25 more files in changeset.
Monday 17 May 2004
5:14 pm

jeffd

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

Options
    • -2
    • +2
    ./content-item.sql
  2. … 834 more files in changeset.
Friday 12 Mar 2004
8:19 pm

jeffd

various bug fixes for package_id, title addition to acs_objects

Options
    • -4
    • +4
    ./content-item.sql
  2. … 12 more files in changeset.
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -49
    • +295
    ./content-item.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -294
    • +48
    ./content-item.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -49
    • +295
    ./content-item.sql
  2. … 96 more files in changeset.
Monday 01 Mar 2004
12:55 pm

marka

modified content_item.get_title to return a useful label for extlinks (postgres and oracle)

Options
    • -2
    • +5
    ./content-item.sql
  2. … 1 more file in changeset.