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
Wednesday 08 Jun 2005
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
Thursday 03 Mar 2005
7:11 pm

daveb

*** empty log message ***

Options
    • -2
    • +2
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
6:56 pm

daveb

Add content_revision__del

Options
    • -2
    • +2
    ./content-revision.sql
Sunday 27 Feb 2005
6:41 pm

daveb

Fix bug#2298. Create content_revision__del

Options
    • -1
    • +1
    ./upgrade/upgrade-5.1.5d3-5.1.5d4.sql
  2. … 1 more file in changeset.
6:38 pm

daveb

Move file to correct name for upgrade.

Options
    • -70
    • +0
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
    • -0
    • +70
    ./upgrade/upgrade-5.1.5d3-5.1.5d4.sql
6:32 pm

daveb

Fix bug#2298 correctly create content_revision__del

Options
    • -0
    • +70
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
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
2:32 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20050111 and jcd-merge-5-1-20050224

Options
    • -8
    • +20
    ./content-folder.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
    • -1
    • +38
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
    • -0
    • +53
    ./upgrade/upgrade-5.1.5d1-5.1.5d2.sql
  5. … 318 more files in changeset.
Wednesday 23 Feb 2005
12:52 pm

leed

Page root and template root registered as magic objects.

Options
    • -1
    • +11
    ./content-create.sql
  2. … 1 more file in changeset.
Wednesday 16 Feb 2005
1:14 am

victorg

Commented the creation of the index cr_items_name, already existed

Options
    • -2
    • +2
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
  2. … 1 more file in changeset.
Thursday 03 Feb 2005
1:16 am

jeffd

bind the fts contract when creating the datamodel

Options
    • -1
    • +5
    ./content-search.sql
  2. … 1 more file in changeset.
Monday 24 Jan 2005
12:16 am

jeffd

add index on cr_revisions(publish_date), upgrade bump to 5.2.0d12

Options
    • -1
    • +4
    ./content-create.sql
    • -0
    • +1
    ./upgrade/upgrade-5.2.0d11-5.2.0d12.sql
  3. … 3 more files in changeset.
Friday 14 Jan 2005
4:14 am

daveb

Fix content_folder__is_subfolder pl/sql. Also fix tcl proc which was

passing in the wrong list format to package_exec_plsql. Add upgrade

script and tests.

Options
    • -6
    • +19
    ./content-folder.sql
    • -1
    • +38
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
    • -0
    • +53
    ./upgrade/upgrade-5.1.5d1-5.1.5d2.sql
  4. … 3 more files in changeset.
4:14 am

daveb

file upgrade-5.1.5d1-5.1.5d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.5d1-5.1.5d2.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
    • -3
    • +4
    ./content-create.sql
    • -2
    • +1
    ./content-extlink.sql
    • -2
    • +40
    ./content-folder.sql
    • -17
    • +8
    ./content-item.sql
    • -2
    • +1
    ./content-revision.sql
    • -5
    • +5
    ./content-template.sql
    • -6
    • +2
    ./content-type.sql
    • -0
    • +16
    ./upgrade/upgrade-4.5-4.6.sql
    • -0
    • +195
    ./upgrade/upgrade-5.1.2d4-5.1.2d5.sql
    • -0
    • +125
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
    • -0
    • +97
    ./upgrade/upgrade-5.1.4d1-5.1.4d2.sql
    • -0
    • +129
    ./upgrade/upgrade-5.1.4d2-5.1.4d3.sql
    • -0
    • +130
    ./upgrade/upgrade-5.1.4d3-5.1.4d4.sql
    • -0
    • +310
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
    • -0
    • +11
    ./upgrade/upgrade-5.1.4d5-5.1.4d6.sql
  16. … 2261 more files in changeset.
Wednesday 12 Jan 2005
2:22 pm

dedsc

fix to return folder id present in upgrade. just putting it here as well

Options
    • -3
    • +2
    ./content-folder.sql