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: 17 May
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 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
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.
Tuesday 18 Jan 2005
5:44 pm

andrewg

Inserting a couple of missing commas.

Options
    • -3
    • +3
    ./content-revision.sql
5:35 pm

andrewg

Added missing comma in content_revision package definition.

Options
    • -1
    • +1
    ./packages-create.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
    • -1
    • +2
    ./content-create.sql
    • -5
    • +6
    ./content-folder.sql
    • -1
    • +3
    ./content-revision.sql
    • -0
    • +1
    ./packages-create.sql
    • -0
    • +653
    ./upgrade/upgrade-5.1.2d5-5.1.2d6.sql
    • -0
    • +10
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
    • -0
    • +752
    ./upgrade/upgrade-5.1.2d8-5.1.2d9.sql
  8. … 2269 more files in changeset.
Monday 06 Sep 2004
6:43 pm

rocaelh

adding cr_items(name) index on the creation of the pkg

Options
    • -1
    • +2
    ./content-create.sql
  2. … 1 more file in changeset.
Friday 03 Sep 2004
6:05 pm

tracya

file upgrade-5.1.2d8-5.1.2d9.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.2d8-5.1.2d9.sql
5:58 pm

tracya

filestorage was displying the ugly filename instead of the pretty title for the main entry; also wasn't updating the filename to the newest upload (still need to ask DaveB about getting the links to work with the latest upload filename

Options
    • -3
    • +5
    ./content-revision.sql
    • -1
    • +2
    ./packages-create.sql
    • -0
    • +752
    ./upgrade/upgrade-5.1.2d8-5.1.2d9.sql
  4. … 5 more files in changeset.
Thursday 02 Sep 2004
10:18 pm

rocaelh

file upgrade-5.1.2d6-5.1.2d7.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
  2. … 1 more file in changeset.
10:18 pm

rocaelh

new index for perf improvements

Options
    • -0
    • +10
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
  2. … 2 more files in changeset.
Wednesday 25 Aug 2004
1:28 am

tracya

file upgrade-5.1.2d5-5.1.2d6.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.2d5-5.1.2d6.sql
1:28 am

tracya

is_sub_folder always returned t

Options
    • -5
    • +6
    ./content-folder.sql
    • -0
    • +653
    ./upgrade/upgrade-5.1.2d5-5.1.2d6.sql
  3. … 1 more file in changeset.
Saturday 24 Jul 2004
10:33 am

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040712 and jcd-merge-5-1-20040724 to HEAD

Options
    • -1
    • +5
    ./content-item.sql
    • -0
    • +4
    ./upgrade/upgrade-5.1.2d3-5.1.2d4.sql
  3. … 137 more files in changeset.
Tuesday 20 Jul 2004
5:03 pm

janine

file upgrade-5.1.2d3-5.1.2d4.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.2d3-5.1.2d4.sql
5:03 pm

janine

add view content_item_globals, which already exists for PG but was missing for Oracle

Options
    • -1
    • +5
    ./content-item.sql
    • -0
    • +4
    ./upgrade/upgrade-5.1.2d3-5.1.2d4.sql
  3. … 1 more file in changeset.
Monday 12 Jul 2004
4:49 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040628 and jcd-merge-5-1-20040712 to HEAD

Options
    • -3084
    • +0
    ./upgrade/upgrade-5.1.1-5.1.2.sql
    • -0
    • +3084
    ./upgrade/upgrade-5.1.1d2-5.1.1d3.sql
  3. … 115 more files in changeset.
Monday 05 Jul 2004
9:31 am

joela

moved the 5.1.1-5.1.2 upgrade script back to 5.1.1d2-5.1.1d3 and changed info file from 5.1.2 to 5.1.1d3, to maintain consistency with core release conventions.

Options
    • -3084
    • +0
    ./upgrade/upgrade-5.1.1-5.1.2.sql
    • -0
    • +3084
    ./upgrade/upgrade-5.1.1d2-5.1.1d3.sql
  3. … 3 more files in changeset.
9:31 am

joela

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.1d2-5.1.1d3.sql
  2. … 1 more file in changeset.
Tuesday 29 Jun 2004
12:17 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

Options
    • -2
    • +2
    ./content-folder.sql
    • -1
    • +1
    ./content-item.sql
    • -1
    • +1
    ./upgrade/upgrade-4.6.2-4.6.3.sql
    • -0
    • +3084
    ./upgrade/upgrade-5.1.1-5.1.2.sql
  5. … 684 more files in changeset.
Friday 11 Jun 2004
10:43 pm

janine

list columns to insert into (fix from Sloan)

Options
    • -1
    • +1
    ./upgrade/upgrade-4.6.2-4.6.3.sql
10:42 pm

janine

merge fix from head

Options
    • -9
    • +18
    ./upgrade/upgrade-4.6.1-4.6.2.sql