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

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 28
Last Commit: 26 Apr
Commits this week: 0
Total Lines of Code (LoC): 44,612
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 17 Sep 2007
3:06 pm

maltes

Made sure the content package has the new procedures as well

Options
    • -36
    • +127
    ./content-package.sql
3:00 pm

maltes

Missing upgrade scripts

Options
    • -0
    • +3
    ./upgrade/upgrade-5.4.0d1-5.4.0d2.sql
    • -0
    • +134
    ./upgrade/upgrade-5.4.0d3-5.4.0d4.sql
    • -0
    • +137
    ./upgrade/upgrade-5.4.0d4-5.4.0d5.sql
    • -0
    • +670
    ./upgrade/upgrade-5.4.0d5-5.4.0d6.sql
  5. … 1 more file in changeset.
2:58 pm

maltes

Got rid of reliance on Java for Oracle. Removed unused old functions. Hopefully someone else can help with a fresh install test as well

Options
    • -59
    • +2
    ./content-revision.sql
    • -53
    • +125
    ./content-util.sql
    • -50
    • +0
    ./packages-create.sql
  4. … 3 more files in changeset.
Wednesday 29 Aug 2007
8:28 pm

maltes

Support for relative file locations which might even reside on a windows drive and therefore start with d:\

Options
    • -2
    • +3
    ./content-create.sql
    • -1
    • +3
    ./content-image.sql
  3. … 5 more files in changeset.
Friday 15 Dec 2006
1:36 pm

emmar

Add Open Documents MIME types

Options
    • -0
    • +56
    ./upgrade/upgrade-5.3.0d3-5.3.0d4.sql
  2. … 2 more files in changeset.
1:28 pm

emmar

file upgrade-5.3.0d3-5.3.0d4.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.3.0d3-5.3.0d4.sql
1:28 pm

emmar

Add Open Documents MIME types

Options
    • -0
    • +56
    ./upgrade/upgrade-5.3.0d3-5.3.0d4.sql
  2. … 2 more files in changeset.
1:00 am

donb

First round of oacs-5-3 merge to HEAD commits

Options
    • -10
    • +0
    ./upgrade/upgrade-5.1.0-5.1.1.sql
    • -0
    • +10
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
  3. … 95 more files in changeset.
Thursday 14 Dec 2006
5:22 am

donb

Fixed an upgrade ordering problem

Options
    • -10
    • +0
    ./upgrade/upgrade-5.1.0-5.1.1.sql
    • -0
    • +10
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
Thursday 05 Oct 2006
7:04 pm

emmar

Fix #3008: remove duplicated drop_type procedure, added missing param in proc specification and correct upgrade script

Options
    • -104
    • +3
    ./content-type.sql
    • -2
    • +2
    ./packages-create.sql
    • -3
    • +1099
    ./upgrade/upgrade-5.3.0d2-5.3.0d3.sql
Tuesday 26 Sep 2006
4:48 pm

byronl

Correction of name constraint

Options
    • -28
    • +30
    ./content-create.sql
    • -2
    • +2
    ./content-image.sql
    • -2
    • +3
    ./content-xml.sql
  4. … 11 more files 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
    ./content-type.sql
    • -0
    • +127
    ./upgrade/upgrade-5.3.0d2-5.3.0d3.sql
  3. … 4 more files in changeset.
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
    ./types-create.sql
  2. … 3 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
    • -3
    • +3
    ./content-create.sql
    • -14
    • +8
    ./content-folder.sql
    • -5
    • +5
    ./content-image.sql
    • -20
    • +13
    ./content-item.sql
    • -1
    • +1
    ./content-keyword.sql
    • -1
    • +7
    ./packages-create.sql
    • -0
    • +1963
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
    • -0
    • +3155
    ./upgrade/upgrade-5.2.0b5-5.2.0b6.sql
    • -0
    • +497
    ./upgrade/upgrade-5.2.0b6-5.2.0b7.sql
    • -1
    • +3
    ./upgrade/upgrade-5.2.0d16-5.2.0d17.sql
    • -0
    • +2937
    ./upgrade/upgrade-5.2.1d1-5.2.1d2.sql
    • -0
    • +285
    ./upgrade/upgrade-5.2.2-5.2.3d1.sql
    • -0
    • +203
    ./upgrade/upgrade-5.2.3d1-5.2.3d2.sql
  14. … 709 more files in changeset.
Monday 10 Apr 2006
11:59 am

emmar

replacing content_template for package_id param

Options
    • -0
    • +203
    ./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
    ./upgrade/upgrade-5.2.3d1-5.2.3d2.sql
Wednesday 29 Mar 2006
12:54 pm

emmar

fix content_item.new call in content_folder.new

Options
    • -11
    • +11
    ./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
    ./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
    ./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
    ./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
    ./content-image.sql
    • -0
    • +285
    ./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
    ./content-keyword.sql
    • -1
    • +1
    ./packages-create.sql
    • -2
    • +0
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
    • -1
    • +3
    ./upgrade/upgrade-5.2.0d16-5.2.0d17.sql
    • -9
    • +13
    ./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
    ./content-folder.sql
    • -12
    • +5
    ./content-item.sql
    • -33
    • +667
    ./upgrade/upgrade-5.2.1d1-5.2.1d2.sql
Wednesday 04 Jan 2006
2:29 am

daveb

Fix upgrade. Move 5.2.0 stuff to 5.2.1

Options
    • -486
    • +0
    ./upgrade/upgrade-5.2.0b11-5.2.0b12.sql
    • -2
    • +489
    ./upgrade/upgrade-5.2.1d1-5.2.1d2.sql
  3. … 2 more files in changeset.
1:38 am

donb

More 5.2 fixes for Oracle ...

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

daveb

Refresh views and triggers.

Recreate content keyword to support package_id parameter

Options
    • -0
    • +486
    ./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
    ./upgrade/upgrade-5.2.0b11-5.2.0b12.sql
Thursday 29 Dec 2005
2:24 am

daveb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.1d1-5.2.1d2.sql
  2. … 1 more file in changeset.
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
    • -3
    • +3
    ./content-create.sql
    • -5
    • +5
    ./content-folder.sql
    • -10
    • +10
    ./content-item.sql
    • -0
    • +1812
    ./upgrade/upgrade-5.2.1d1-5.2.1d2.sql
  5. … 4 more files in changeset.
Wednesday 30 Nov 2005
2:27 am

donb

1. Fixed a wee bit of PG-ish code that snuck into the content repository's

Oracle datamodel.

2. Tested Dave's recent changes to subsite for Oracle. It works. Bumped

the info file to reflect the new version so the upgrade scripts will run.

Options
    • -2
    • +2
    ./content-folder.sql
    • -2
    • +2
    ./upgrade/upgrade-5.2.0b5-5.2.0b6.sql
  3. … 1 more file in changeset.