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: 19 Jan
Commits this week: 0
Total Lines of Code (LoC): 44,813
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 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Jan 2006
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.
Saturday 26 Nov 2005
10:25 pm

daveb

Allow content_folders to have non-cr_items as parents

Options
    • -2
    • +3
    ./content-folder.sql
    • -1
    • +673
    ./upgrade/upgrade-5.2.0b5-5.2.0b6.sql
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
    • -0
    • +1325
    ./upgrade/upgrade-5.2.0b5-5.2.0b6.sql
  2. … 2 more files in changeset.
8:03 pm

daveb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0b5-5.2.0b6.sql
1:26 am

donb

Fixed Daveb's translation of his PG change to this script (he didn't have

oracle to test his changes on)

Options
    • -5
    • +2
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Thursday 27 Oct 2005
9:30 pm

daveb

Fix bug#2668

Options
    • -4
    • +10
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Wednesday 12 Oct 2005
1:53 am

donb

Fixed this bug many moons ago but failed to commit ...

Options
    • -0
    • +1
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Monday 18 Jul 2005
7:36 pm

andrewg

Recompiling content_item didn't work. We needed to bounce the db pools, which we're doing now from apm.

Options
    • -3
    • +0
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Wednesday 06 Jul 2005
10:33 pm

andrewg

We needed to re-source content_revision, and recompile content_item. Not sure if we're out of the woods yet, we'll see...

Options
    • -0
    • +757
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Tuesday 05 Jul 2005
11:51 pm

donb

Still working on 8i upgrades (9 seems to work) ... refreshing the view for

each content type ...

Options
    • -0
    • +1
    ./upgrade/upgrade-5.2.0a1-5.2.0a2.sql
6:33 pm

donb

Further fixing of Timo's use of refresh_trigger

Options
    • -0
    • +6
    ./packages-create.sql
    • -0
    • +292
    ./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
    • -3
    • +5
    ./content-type.sql
    • -0
    • +914
    ./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
    • -3
    • +5
    ./content-type.sql
    • -0
    • +914
    ./upgrade/upgrade-5.2.0d16-5.2.0d17.sql
  3. … 4 more files in changeset.
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.
Tuesday 29 Mar 2005
3:50 pm

timoh

provided default template in oracle

Options
    • -1
    • +53
    ./content-create.sql
    • -0
    • +50
    ./upgrade/upgrade-5.1.5-5.1.6d1.sql
  3. … 4 more files in changeset.
3:50 pm

timoh

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.5-5.1.6d1.sql
Saturday 12 Mar 2005
10:28 pm

andrewg

This is just a comment on the previous commit. Oracle was refusing to compile the package because the specification and body were not declaring the type in an identical way. The specification says that the package_id column is of type acs_objects.package_id%TYPE but the body previously was declaring it cr_folders.package_id%TYPE. That wasn't good enough for Oracle. Now the two are declaring the type the same way.

Options
    • -2
    • +1
    ./content-folder.sql
8:45 pm

andrewg

Bugfix.

Options
    • -2
    • +2
    ./content-template.sql
    • -1
    • +1
    ./packages-create.sql
8:22 pm

andrewg

Bugfix

Options
    • -2
    • +2
    ./content-folder.sql
    • -2
    • +2
    ./content-item.sql
Thursday 24 Feb 2005
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
    • -2
    • +4
    ./content-folder.sql
    • -3
    • +4
    ./content-item.sql
    • -0
    • +2
    ./packages-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
    • -0
    • +3096
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
  6. … 317 more files in changeset.
Wednesday 23 Feb 2005
12:52 pm

leed

Page root and template root registered as magic objects.

Options
    • -1
    • +13
    ./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.
Monday 14 Feb 2005
6:23 pm

donb

Missed one file modified by daveb in my last commit

Options
    • -2
    • +5
    ./content-type.sql
Tuesday 01 Feb 2005
6:09 pm

daveb

Fix insert and select views for revisions and subtypes so title is not duplicated.

Options
    • -3
    • +27
    ./content-type.sql
Monday 31 Jan 2005
8:29 am

timoh

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
8:29 am

timoh

fixed some upgrade scripts for oracle

Options
    • -5
    • +8
    ./content-folder.sql
    • -3
    • +5
    ./content-item.sql
    • -2
    • +5
    ./packages-create.sql
    • -0
    • +3096
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
  5. … 4 more files in changeset.