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

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 47
Last Commit: 13 Nov
Commits this week: 0
Total Lines of Code (LoC): 77,885
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 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Oct 2006
6:37 pm

victorg

Adding script upgrade for fixing typo in function content_extlink__copy.

This has been fixed in the create script ( content-extlink.sql).

Options
    • -0
    • +81
    ./postgresql/upgrade/upgrade-5.3.0d3-5.3.0d4.sql
  2. … 1 more file in changeset.
Tuesday 26 Sep 2006
4:48 pm

byronl

Correction of name constraint

Options
    • -28
    • +30
    ./oracle/content-create.sql
    • -2
    • +2
    ./oracle/content-image.sql
    • -2
    • +3
    ./oracle/content-xml.sql
  4. … 11 more files in changeset.
Monday 25 Sep 2006
10:15 pm

byronl

Correction of name constraint

Options
    • -57
    • +66
    ./postgresql/content-create.sql
    • -2
    • +2
    ./postgresql/content-image.sql
    • -3
    • +3
    ./postgresql/content-type.sql
    • -2
    • +3
    ./postgresql/content-xml.sql
  5. … 1 more file in changeset.
Sunday 24 Sep 2006
1:37 pm

maltes

Added the option to drop the items, revisions and objects along with the dropping of a content type

Options
    • -1
    • +128
    ./oracle/content-type.sql
    • -0
    • +127
    ./oracle/upgrade/upgrade-5.3.0d2-5.3.0d3.sql
    • -1
    • +121
    ./postgresql/content-type.sql
    • -0
    • +118
    ./postgresql/upgrade/upgrade-5.3.0d2-5.3.0d3.sql
  5. … 2 more files in changeset.
Wednesday 06 Sep 2006
4:46 pm

daveb

Update search triggers to honor publish_date.

Options
    • -12
    • +17
    ./postgresql/content-search.sql
    • -0
    • +74
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
Thursday 27 Jul 2006
10:09 pm

victorg

Removing wrong acs attributes for object type apm_package.

Fixing object attribute datatypes so they are consistent

with the database datatype.

Options
    • -7
    • +7
    ./oracle/types-create.sql
    • -7
    • +7
    ./postgresql/types-create.sql
  3. … 2 more files in changeset.
Wednesday 26 Jul 2006
10:52 pm

gustafn

Fix for the duplicate revision_id and deadlock on concurrent cr updates and inserts

Options
    • -49
    • +38
    ./postgresql/content-type.sql
    • -0
    • +267
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  3. … 4 more files in changeset.
Thursday 13 Jul 2006
10:43 pm

victorg

Removing upgrade scripts not well ordered for acs-kernel and acs-content-repository.

Adding corresponding upgrade scripts with correct versions.

Now the test case files__check_upgrade_ordering (acs-tcl) does not fail.

Options
    • -50
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d15-5.2.0a1.sql
    • -0
    • +52
    ./postgresql/upgrade/upgrade-5.2.0d18-5.2.0d19.sql
  3. … 4 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
    • -0
    • +5
    ./common/mime-type-data.sql
    • -3
    • +3
    ./oracle/content-create.sql
    • -14
    • +8
    ./oracle/content-folder.sql
    • -5
    • +5
    ./oracle/content-image.sql
    • -20
    • +13
    ./oracle/content-item.sql
    • -1
    • +1
    ./oracle/content-keyword.sql
    • -1
    • +7
    ./oracle/packages-create.sql
    • -0
    • +1963
    ./oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql
    • -0
    • +3155
    ./oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
    • -0
    • +497
    ./oracle/upgrade/upgrade-5.2.0b6-5.2.0b7.sql
    • -1
    • +3
    ./oracle/upgrade/upgrade-5.2.0d16-5.2.0d17.sql
    • -0
    • +2937
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
    • -0
    • +285
    ./oracle/upgrade/upgrade-5.2.2-5.2.3d1.sql
    • -0
    • +203
    ./oracle/upgrade/upgrade-5.2.3d1-5.2.3d2.sql
    • -70
    • +61
    ./postgresql/content-create.sql
  16. … 707 more files in changeset.
Wednesday 19 Apr 2006
2:10 pm

roelc

content_name should be content__name

Options
    • -2
    • +2
    ./postgresql/content-extlink.sql
Monday 10 Apr 2006
9:31 pm

donb

Applied patch supplied by Jeff Davis.

Options
    • -2
    • +2
    ./postgresql/content-type.sql
11:59 am

emmar

replacing content_template for package_id param

Options
    • -0
    • +203
    ./oracle/upgrade/upgrade-5.2.3d1-5.2.3d2.sql
11:59 am

emmar

file upgrade-5.2.3d1-5.2.3d2.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.2.3d1-5.2.3d2.sql
Friday 07 Apr 2006
3:09 am

donb

Fixed "bug" #2646. This code wasn't actually executed since the relevant

table's created explicitly in another script ...

Options
    • -2
    • +2
    ./postgresql/content-update.sql
2:48 am

donb

Fixed "bug" #2747. The code was never called and was just a stub that

hadn't been ported to PG, but I removed it so future people with

sharp eyes don't look at it and report the "bug" again.

Options
    • -60
    • +1
    ./postgresql/content-schedule.sql
Wednesday 29 Mar 2006
12:54 pm

emmar

fix content_item.new call in content_folder.new

Options
    • -11
    • +11
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
12:53 pm

emmar

fix #2870, #2868: upgrade script for image and content_extlink packages

Options
    • -0
    • +497
    ./oracle/upgrade/upgrade-5.2.0b6-5.2.0b7.sql
12:53 pm

emmar

file upgrade-5.2.0b6-5.2.0b7.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.2.0b6-5.2.0b7.sql
Wednesday 18 Jan 2006
6:04 pm

hughb

file upgrade-5.2.2-5.2.3d1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.2.2-5.2.3d1.sql
6:03 pm

hughb

fix non-nullable package id on image (package id should be nullable and it now is)

Options
    • -5
    • +5
    ./oracle/content-image.sql
    • -0
    • +285
    ./oracle/upgrade/upgrade-5.2.2-5.2.3d1.sql
  3. … 1 more file in changeset.
Monday 16 Jan 2006
1:17 am

donb

Fixed 5.1->5.2 upgrade, all content repository tests now pass.

Options
    • -1
    • +1
    ./oracle/content-keyword.sql
    • -1
    • +1
    ./oracle/packages-create.sql
    • -2
    • +0
    ./oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql
    • -1
    • +3
    ./oracle/upgrade/upgrade-5.2.0d16-5.2.0d17.sql
    • -9
    • +13
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
  6. … 2 more files in changeset.
Thursday 12 Jan 2006
7:25 pm

daveb

Remove code that guesses package_id based on parent_id

Options
    • -10
    • +3
    ./oracle/content-folder.sql
    • -12
    • +5
    ./oracle/content-item.sql
    • -33
    • +667
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
7:23 pm

daveb

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

this will return null anyway.

Options
    • -10
    • +3
    ./postgresql/content-folder.sql
    • -43
    • +15
    ./postgresql/content-item.sql
    • -206
    • +154
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
4:20 am

dedsc

fix content_type__refresh_view to do a lowercase when selecting table_name. this was in the upgrade script for 5.2.0a1 to 5.2.0a2 but didn't find it's way here

Options
    • -1
    • +3
    ./postgresql/content-type.sql
Wednesday 04 Jan 2006
4:51 pm

daveb

Refresh content_revision view also, not just child types.

Options
    • -3
    • +4
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
2:29 am

daveb

Fix upgrade. Move 5.2.0 stuff to 5.2.1

Options
    • -486
    • +0
    ./oracle/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
    • -2
    • +489
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
    • -95
    • +0
    ./postgresql/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
    • -1
    • +97
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
1:38 am

donb

More 5.2 fixes for Oracle ...

Options
    • -2
    • +2
    ./oracle/content-folder.sql
    • -8
    • +1166
    ./oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
Tuesday 03 Jan 2006
4:05 pm

daveb

Recreate content_keyword__new to support package_id.

Refresh views and triggers.

Options
    • -2
    • +95
    ./postgresql/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
4:04 pm

daveb

Refresh views and triggers.

Recreate content keyword to support package_id parameter

Options
    • -0
    • +486
    ./oracle/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
4:04 pm

daveb

file upgrade-5.2.0b11-5.2.0b12.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.2.0b11-5.2.0b12.sql