OpenACS / openacs-4 / packages / file-storage / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 22
Last Commit: 23 Apr
Commits this week: 0
Total Lines of Code (LoC): 5,456
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
Wednesday 16 Feb 2022
1:26 pm

gustafn

Fixes for Oracle 19c: fix broken variable references (introduced in oacs-5-9)

Options
    • -6
    • +6
    ./file-storage-package-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.9.1b3-5.9.1b4.sql
1:15 pm

gustafn

Fixes for Oracle 19c: added missing SQL package declaration

Options
    • -1
    • +147
    ./file-storage-package-create.sql
Friday 15 Mar 2019
10:36 am

antoniop

Align fs_objects view definition in Oracle with the one in Postgres

Options
    • -6
    • +3
    ./file-storage-views-create.sql
    • -0
    • +49
    ./upgrade/upgrade-5.10.d2-5.10.d3.sql
  3. … 1 more file in changeset.
10:36 am

antoniop

file upgrade-5.10.d2-5.10.d3.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.10.d2-5.10.d3.sql
Wednesday 15 Aug 2018
6:49 pm

gustafn

Removed obsolete @arch-tag

Options
    • -3
    • +2
    ./upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -2
    • +1
    ./upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  3. … 25 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -153
    • +9
    ./file-storage-package-create.sql
    • -0
    • +478
    ./upgrade/upgrade-5.9.1b3-5.9.1b4.sql
  3. … 7833 more files in changeset.
Friday 21 Apr 2017
7:14 pm

antoniop

Allow copy of files/folders into the same folder of the original content. This is done by appending a numerical suffix to the name.

It required modifying copy stored procedures so they could accept a different name and title for the copy.

I have also removed redundant package definition in oracle code that was immediately overridden afterwards.

Options
    • -153
    • +9
    ./file-storage-package-create.sql
    • -0
    • +478
    ./upgrade/upgrade-5.9.1b3-5.9.1b4.sql
  3. … 11 more files in changeset.
7:14 pm

antoniop

file upgrade-5.9.1b3-5.9.1b4.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.9.1b3-5.9.1b4.sql
  2. … 1 more file in changeset.
Tuesday 13 Oct 2009
12:46 am

daveb

Patches for NULL table name, on delete cascade to clean up file storage from Jim Lynch

Options
    • -4
    • +13
    ./file-storage-create.sql
    • -0
    • +26
    ./upgrade/upgrade-5.6.0d1-5.6.0d2.sql
  3. … 3 more files in changeset.
Thursday 29 Jan 2009
3:31 pm

emmar

Fix param values for archive command and extension (were mixed up)

Options
    • -0
    • +7
    ./upgrade/upgrade-5.5.0d1-5.5.0d2.sql
  2. … 2 more files in changeset.
Monday 10 Dec 2007
10:53 am

victorg

Checking that upgrade scripts modify parameters for the right package.

Modification to the oracle upgrade scripts for FS.

Options
    • -4
    • +4
    ./upgrade/upgrade-5.4.0d1-5.4.0d2.sql
  2. … 4 more files in changeset.
Tuesday 16 Jan 2007
9:40 am

maltes

Change the archive command from tgz to ZIP as per http://openacs.org/forums/message-view?message_id=557561

Options
    • -0
    • +4
    ./upgrade/upgrade-5.4.0d1-5.4.0d2.sql
  2. … 2 more files in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

Options
    • -7
    • +11
    ./file-storage-package-create.sql
    • -2
    • +3
    ./file-storage-views-create.sql
    • -3
    • +4
    ./upgrade/upgrade-5.1.0a2-5.1.0a3.sql
    • -17
    • +17
    ./upgrade/upgrade-5.1.0a4-5.1.0a5.sql
    • -4
    • +5
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
    • -0
    • +53
    ./upgrade/upgrade-5.2.0d5-5.2.0d6.sql
    • -0
    • +642
    ./upgrade/upgrade-5.2.0d8-5.2.2.sql
    • -0
    • +45
    ./upgrade/upgrade-5.2.3d1-5.2.3d2.sql
    • -0
    • +47
    ./upgrade/upgrade-5.2.3d2-5.2.3.sql
  10. … 2470 more files in changeset.
Wednesday 12 Jul 2006
2:58 am

donb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.3d2-5.2.3.sql
  2. … 1 more file in changeset.
2:58 am

donb

Made fs_objects count folder items the same was fs_folders does.

Options
    • -2
    • +2
    ./file-storage-views-create.sql
    • -0
    • +47
    ./upgrade/upgrade-5.2.3d2-5.2.3.sql
  3. … 3 more files in changeset.
Friday 07 Jul 2006
1:35 am

maltes

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
  2. … 1 more file in changeset.
1:35 am

maltes

Added view support for Symlinks. This works in a hardlink fashion at the moment and is not tested on Oracle, though I doubt it will fail.

Options
    • -2
    • +3
    ./file-storage-views-create.sql
    • -0
    • +45
    ./upgrade/upgrade-5.2.3d1-5.2.3d2.sql
  3. … 4 more files in changeset.
Friday 31 Mar 2006
2:55 pm

emmar

replace invalidated view fs_urls_full

Options
    • -1
    • +17
    ./upgrade/upgrade-5.2.0d8-5.2.2.sql
Wednesday 29 Mar 2006
3:26 am

donb

file upgrade-5.2.0d8-5.2.2.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0d8-5.2.2.sql
3:26 am

donb

1. Got rid of some extraneous notification comments

2. Fixed bug 2851 for Oracle (it was fixed previously for Postgres)

Options
    • -4
    • +7
    ./file-storage-package-create.sql
    • -0
    • +626
    ./upgrade/upgrade-5.2.0d8-5.2.2.sql
  3. … 4 more files in changeset.
Sunday 19 Mar 2006
11:26 pm

emmar

file_storage.get_title to return cr_revisions.title of the live revision instead of cr_items.name

Options
    • -4
    • +5
    ./file-storage-package-create.sql
    • -3
    • +4
    ./upgrade/upgrade-5.1.0a2-5.1.0a3.sql
    • -4
    • +5
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
10:10 pm

emmar

Set cr_items.name as fs_objects.name instead of cr_revisions.filename

Options
    • -2
    • +2
    ./file-storage-views-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.2.0d5-5.2.0d6.sql
Thursday 25 Aug 2005
8:44 pm

maltes

Upgrade scripts for the view fix for fs_objects

Options
    • -0
    • +53
    ./upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  2. … 2 more files in changeset.
8:44 pm

maltes

file upgrade-5.2.0d5-5.2.0d6.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  2. … 1 more file in changeset.
8:40 pm

maltes

Fixed the counting. Special treatment for oracle not using the "in" statement. PLEASE TEST IT SOMEONE!!!

Options
    • -2
    • +2
    ./file-storage-views-create.sql
Wednesday 22 Jun 2005
8:04 pm

andrewg

This script was failing on Oracle. To fix I added named args to all calls and changed acs_sc_impl.new_alias to acs_sc_impl_alias.new

Options
    • -17
    • +17
    ./upgrade/upgrade-5.1.0a4-5.1.0a5.sql
8:03 pm

andrewg

This script was failing on Oracle. To fix I added named args to all calls and changed acs_sc_impl.new_alias to acs_sc_impl_alias.new

Options
    • -17
    • +17
    ./upgrade/upgrade-5.1.0a4-5.1.0a5.sql
Thursday 26 May 2005
10:28 am

maltes

Added callbacks for integration with PM. Made sure the package_id is set correctly

Options
    • -1
    • +1
    ./file-storage-create.sql
    • -1
    • +1
    ./file-storage-drop.sql
    • -2
    • +6
    ./file-storage-package-create.sql
    • -1
    • +1
    ./file-storage-views-create.sql
    • -1
    • +1
    ./file-storage-views-drop.sql
    • -1
    • +1
    ./upgrade/upgrade-4.6.1-4.6.2.sql
    • -1
    • +1
    ./upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -1
    • +1
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
    • -1
    • +1
    ./upgrade/upgrade-5.1.0d3-5.1.0d4.sql
  10. … 53 more files in changeset.
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
    • +2
    ./upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -2
    • +12
    ./upgrade/upgrade-5.1.0a4-5.1.0a5.sql
    • -2
    • +1
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
  4. … 319 more files in changeset.
Wednesday 23 Feb 2005
8:56 pm

maltes

Changed the upgrade script to use select count(*) to circumwent Oracles dislike for if (select...)

Options
    • -2
    • +5
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql