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

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 40
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 32,399
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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 09 Aug 2005
8:43 pm

miguelm

file upgrade-5.2.0a3-5.2.0a4.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0a3-5.2.0a4.sql
8:42 pm

miguelm

adding function content_symlink__del, this function is called from content_symlink__delete

Options
    • -3
    • +17
    ./content-symlink.sql
    • -0
    • +28
    ./upgrade/upgrade-5.2.0a3-5.2.0a4.sql
Wednesday 03 Aug 2005
5:59 pm

victorg

Moving folders was broken. Adding the correct definitios of

content_folder__move function.

Options
    • -5
    • +21
    ./content-folder.sql
3:27 am

victorg

typo, missing '_'

Options
    • -1
    • +1
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
Monday 01 Aug 2005
6:35 pm

daveb

Add image procs that support package_id to upgrade script

Options
    • -1
    • +349
    ./upgrade/upgrade-5.2.0a2-5.2.0a3.sql
Friday 15 Jul 2005
4:40 pm

daveb

Fixes bug#2530. Create content_revision delete on upgrade that unsets live and latest revisions.

Options
    • -1
    • +5
    ./upgrade/upgrade-5.2.0d9-5.2.0d10.sql
Thursday 07 Jul 2005
1:31 am

donb

Aesthetic changes, removed oracle cruft left in as comments by Dan Wickstrom's

original conservsion scripts ( while working on allowing null type table names).

Options
    • -46
    • +1
    ./content-revision.sql
    • -50
    • +28
    ./content-type.sql
    • -46
    • +0
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
Friday 01 Jul 2005
9:58 pm

daveb

Fix define function args for content_folder__is_folder to match oracle.

Options
    • -2
    • +2
    ./content-folder.sql
    • -0
    • +2
    ./upgrade/upgrade-5.2.0a2-5.2.0a3.sql
  3. … 1 more file in changeset.
Tuesday 21 Jun 2005
7:25 pm

daveb

Double quotes from code copied from Oracle!

Options
    • -2
    • +2
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
7:23 pm

daveb

Fix query for view since we need to workaround the fact that acs-messaging uses CR_REVISIONS for table name.

Options
    • -0
    • +2
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
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
    • -0
    • +156
    ./upgrade/upgrade-5.2.0a2-5.2.0a3.sql
8:20 pm

jader

file upgrade-5.2.0a2-5.2.0a3.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0a2-5.2.0a3.sql
Saturday 18 Jun 2005
5:23 pm

daveb

Recreate new version of refresh_view procedure and recreate all the

views to add package_id to the view from acs_objects.

Options
    • -2
    • +117
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Wednesday 08 Jun 2005
11:12 pm

timoh

fixing package_id of revisions; changed insert trigger to make use of object_package_id in the insert view

Options
    • -2
    • +3
    ./content-type.sql
    • -0
    • +102
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
  3. … 4 more files in changeset.
11:12 pm

timoh

file upgrade-5.2.0a1-5.2.0a2.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
  2. … 1 more file in changeset.
10:58 pm

timoh

fixing package_id of revisions; changed insert trigger to make use of object_package_id in the insert view

Options
    • -2
    • +3
    ./content-type.sql
    • -0
    • +102
    ./upgrade/upgrade-5.2.0d16-5.2.0d17.sql
  3. … 4 more files in changeset.
Sunday 05 Jun 2005
6:38 pm

daveb

Fix bug#1937 with patch#548. Use full syntax for inserts so integer

values work on content_revision__copy in PostgreSQL.

Options
    • -3
    • +4
    ./content-revision.sql
    • -0
    • +50
    ./upgrade/upgrade-5.2.0d15-5.2.0a1.sql
6:38 pm

daveb

file upgrade-5.2.0d15-5.2.0a1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0d15-5.2.0a1.sql
Saturday 04 Jun 2005
7:12 pm

michaels

define function args for content_template__get_path and __delete; add upgrade script and bump version to 5.2.0d17

Options
    • -3
    • +3
    ./content-template.sql
    • -0
    • +8
    ./upgrade/upgrade-5.2.0d16-5.2.0d17.sql
  3. … 1 more file in changeset.
7:12 pm

michaels

file upgrade-5.2.0d16-5.2.0d17.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0d16-5.2.0d17.sql
Monday 23 May 2005
4:32 am

daveb

Fix define function args call to use parent_type for parametr name to

match oracle instead of content_type.

Options
    • -2
    • +2
    ./content-type.sql
Thursday 12 May 2005
11:35 pm

jeffd

add some common mimetypes, bump version, upgrade scripts provided

Options
    • -0
    • +5
    ./upgrade/upgrade-5.2.0d15-5.2.0d16.sql
  2. … 3 more files in changeset.
Wednesday 20 Apr 2005
1:48 pm

eduardop

fix pacakge -> package typo

Options
    • -3
    • +3
    ./upgrade/upgrade-5.1.4d2-5.1.4d3.sql
  2. … 10 more files in changeset.
1:29 pm

eduardop

fix pacakge -> package typo

Options
    • -3
    • +3
    ./upgrade/upgrade-5.1.4d2-5.1.4d3.sql
  2. … 7 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
    • -0
    • +654
    ./upgrade/upgrade-5.2.0d14-5.2.0d15.sql
  3. … 1 more file 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
    • -10
    • +8
    ./content-folder.sql
    • -14
    • +28
    ./content-item.sql
    • -30
    • +25
    ./content-revision.sql
    • -0
    • +395
    ./upgrade/upgrade-5.2.0d12-5.2.0d13.sql
2:41 pm

daveb

Add content_keyword__del to match oracle pl/sql.

Add define_function_args calls for content-keyword.sql.

Add basic tests for content::keyword apis.

Options
    • -42
    • +21
    ./content-keyword.sql
    • -0
    • +49
    ./upgrade/upgrade-5.2.0d13-5.2.0d14.sql
  3. … 3 more files in changeset.
Friday 18 Mar 2005
2:50 pm

jeffd

minor fix: move_name should have been move__name

Options
    • -2
    • +2
    ./content-folder.sql
    • -1
    • +1
    ./upgrade/upgrade-5.2.0d12-5.2.0d13.sql
2:44 pm

jeffd

upgrade to fix bug in content_folder__move and add the integer,integer version used in content_item__move; bump to 5.2.0d13. thanks daveb

Options
    • -0
    • +86
    ./upgrade/upgrade-5.2.0d12-5.2.0d13.sql
  2. … 1 more file in changeset.
4:21 am

daveb

Add content_folder__move function that allows rename on move. Already existed on Oracle.

Options
    • -5
    • +21
    ./content-folder.sql