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: 26 Apr
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 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Thursday 12 Jan 2006
7:23 pm

daveb

Remove code that guesses package_id based on parent_id. In almost all cases

this will return null anyway.

Options
    • -43
    • +15
    ./content-item.sql
  2. … 2 more files in changeset.
Thursday 29 Dec 2005
2:24 am

daveb

Changes to make the root of parentless items = -4 (security context root) instead of 0 (unregistered visitor)

Sites upgradeed from 4.6-4.6.1 have been operating with -4 as the parent_id for years (for example openacs.org) while new installs had

parent_id = 0. This caused problems with the new package_id code that calls content_item__get_root_folder which was assuming the root =

0. It looks like the new install code did not accomodate parent_id=-4 and that is now fixed.

Needs testing on Oracle.

Options
    • -20
    • +20
    ./content-item.sql
  2. … 7 more files in changeset.
Friday 28 Oct 2005
8:03 pm

daveb

Don't try to get the package id of folder_id 0 (which isn't a folder anyway!)

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Friday 23 Sep 2005
9:25 am

maltes

Fixed move function

Options
    • -2
    • +2
    ./content-item.sql
Tuesday 13 Sep 2005
4:08 pm

timoh

bugfix: moving content item

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Monday 20 Jun 2005
8:20 pm

jader

Fix bug #2497, error in content_item__copy, added upgrade script

Options
    • -2
    • +2
    ./content-item.sql
  2. … 1 more file 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.
Friday 07 Jan 2005
4:03 am

daveb

Fix define function args for content_item__set_live revision

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 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.
5:31 pm

daveb

Add __del function to match oracle so package_exec_plsql will work

Options
    • -3
    • +13
    ./content-item.sql
  2. … 2 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
Tuesday 21 Dec 2004
7:22 pm

daveb

Add CR Tcl API from HEAD.

Options
    • -14
    • +36
    ./content-item.sql
  2. … 17 more files in changeset.
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.
Wednesday 11 Aug 2004
1:56 am

donb

Fixed a typo in one of the cr_item__new procs

Options
    • -2
    • +2
    ./content-item.sql
  2. … 1 more file 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.
4:26 pm

jvdongen

Fixed the CR part of bug 1953.

Options
    • -3
    • +3
    ./content-item.sql
  2. … 2 more files in changeset.
Sunday 18 Jul 2004
7:28 pm

daveb

Fix syntax error in drop column statement in content_type__drop__attribute.

Fixes bug#2014. Added upgrade script and increased version in info file.

Options
    • -2
    • +2
    ./content-item.sql
  2. … 3 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.
Wednesday 26 May 2004
9:10 pm

donb

Minor cosmetic change vs. 1858

Options
    • -9
    • +9
    ./content-item.sql
  2. … 1 more file in changeset.
8:12 pm

donb

Fixed Bug #1858: qualifying "rename" works in 8i bug chokes in 9i causing

the reported error on installation. Fixed by changing the name to "edit_name"

and implemented it for PG as well (to keep names similar)

Options
    • -2
    • +2
    ./content-item.sql
  2. … 28 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.
Thursday 06 May 2004
2:35 am

daveb

Fix typo in parameter name, reference to non-existant parameter.

Fixes bug#1793

Options
    • -3
    • +3
    ./content-item.sql
  2. … 1 more file 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.