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: 31 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 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Wednesday 02 Jun 2004
1:24 am

donb

I'd accidently changed some old upgrade files to use edit_name rather than

rename (for Oracle 9.2) and had not added the needed upgrade files for 5.1.

Options
    • -8
    • +8
    ./upgrade/upgrade-4.7d6-5.0d1.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.0-5.1.1.sql
    • -0
    • +3084
    ./upgrade/upgrade-5.1.1-5.1.2.sql
  4. … 9 more files in changeset.
1:24 am

donb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.1-5.1.2.sql
  2. … 1 more file in changeset.
12:54 am

donb

Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

Options
    • -12
    • +12
    ./content-folder.sql
    • -9
    • +9
    ./content-item.sql
    • -3
    • +3
    ./content-test.sql
    • -2
    • +2
    ./packages-create.sql
  5. … 22 more files in changeset.
Wednesday 26 May 2004
8:50 pm

donb

Further fixing of bug #1858

Options
    • -8
    • +8
    ./content-folder.sql
    • -7
    • +7
    ./content-item.sql
    • -2
    • +2
    ./packages-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.0-5.1.1.sql
8:12 pm

donb

Fixed Bug #1858: qualifying "rename" works in 8i bug chokes in 9i causing

the reported error on installation. Fixed by changing the name to "edit_name"

and implemented it for PG as well (to keep names similar)

Options
    • -2
    • +2
    ./content-folder.sql
    • -3
    • +3
    ./content-test.sql
    • -8
    • +8
    ./upgrade/upgrade-4.7d6-5.0d1.sql
  4. … 26 more files in changeset.
Monday 17 May 2004
5:14 pm

jeffd

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

Options
    • -6
    • +6
    ./content-folder.sql
    • -6
    • +6
    ./content-item.sql
    • -0
    • +10
    ./upgrade/upgrade-5.1.0-5.1.1.sql
  4. … 832 more files in changeset.
Sunday 02 May 2004
9:13 pm

daveb

Fix content_folder.rename.

Options
    • -0
    • +10
    ./upgrade/upgrade-5.1.0-5.1.1.sql