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: 12 Sep 13
Commits this week: 0
Total Lines of Code (LoC): 4,283
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 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 22 Jun 2005
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
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
Tuesday 22 Feb 2005
12:17 pm

maltes

Upgrade scripts was buggy, took the create version

Options
    • -2
    • +12
    ./upgrade/upgrade-5.1.0a4-5.1.0a5.sql
Thursday 10 Feb 2005
10:23 pm

maltes

Change the ifstatement to the select query as in postgres

Options
    • -2
    • +1
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
Tuesday 08 Feb 2005
4:14 pm

andrewg

Bugfix: converted extra 'where' to an 'and'.

Options
    • -2
    • +2
    ./upgrade/upgrade-5.1.0a13-5.1.0a14.sql
Wednesday 05 Jan 2005
6:37 pm

daveb

Add existing file-storage to dav_site_node_map

Options
    • -0
    • +12
    ./upgrade/upgrade-5.1.0a13-5.1.0a14.sql
  2. … 2 more files in changeset.
Friday 17 Dec 2004
10:27 pm

andrewg

Fixing the fk constraint on fs_rss_subscrs(subscr_id). It now has on delete cascade so that rss feeds can be deleted from the rss-support admin page.

Options
    • -1
    • +2
    ./file-storage-rss-create.sql
    • -0
    • +8
    ./upgrade/upgrade-5.1.0a12-5.1.0a13.sql
  3. … 3 more files in changeset.
Monday 13 Dec 2004
5:33 pm

andrewg

Adding rss support, turned off and hidden by default.

Options
    • -1
    • +4
    ./file-storage-create.sql
    • -0
    • +41
    ./file-storage-rss-create.sql
    • -0
    • +42
    ./upgrade/upgrade-5.1.0a11-5.1.0a12.sql
  4. … 29 more files in changeset.
Monday 06 Sep 2004
5:11 pm

maltes

The call to acs_sc was missing a parameter. Fixed, but maybe someone could take a look and explain why noone stumbled across this earlier :).

Options
    • -1
    • +12
    ./file-storage-notifications-create.sql
  2. … 1 more file in changeset.
Friday 03 Sep 2004
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
    • -2
    • +2
    ./file-storage-views-create.sql
    • -1
    • +1
    ./upgrade/upgrade-5.1.0a8-5.1.0a9.sql
  3. … 6 more files in changeset.
Wednesday 01 Sep 2004
9:46 pm

tracya

showing date of latest file change for folders

Options
    • -2
    • +6
    ./file-storage-views-create.sql
    • -0
    • +47
    ./upgrade/upgrade-5.1.0a8-5.1.0a9.sql
  3. … 1 more file in changeset.
Monday 23 Aug 2004
7:30 pm

tracya

listing of files listed first revision date instead of last revision date - also fixed upgrade script

Options
    • -3
    • +5
    ./file-storage-views-create.sql
    • -0
    • +67
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
Monday 09 Aug 2004
3:58 pm

daveb

Clean unnecessary triggers from uprade script. They don't need to be

updated.

Options
    • -56
    • +1
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
3:57 pm

daveb

Fix name/title upgrade. Load the entire oracle pl/sql package instead of

re-sourceing package create.sql

Options
    • -0
    • +78
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
    • -22
    • +665
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  3. … 2 more files in changeset.
Thursday 22 Jul 2004
12:37 am

jvdongen

Backported notification support for file-storage from HEAD.

Options
    • -1
    • +4
    ./file-storage-create.sql
    • -1
    • +3
    ./file-storage-drop.sql
    • -0
    • +0
    ./file-storage-notifications-create.sql
    • -0
    • +0
    ./file-storage-notifications-drop.sql
    • -0
    • +46
    ./upgrade/upgrade-5.1.0a4-5.1.0a5.sql
  6. … 19 more files in changeset.
Wednesday 23 Jun 2004
2:56 am

daveb

Patch#538. Use filename instead of title for link text.

Options
    • -2
    • +3
    ./file-storage-views-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.0d3-5.1.0d4.sql
  3. … 6 more files in changeset.
Tuesday 15 Jun 2004
8:37 pm

andrewg

Added cr_mime_types to the join list. It was missing

Options
    • -2
    • +2
    ./upgrade/upgrade-5.1.0d3-5.1.0d4.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
    • -4
    • +4
    ./upgrade/upgrade-4.6.1-4.6.2.sql
    • -3
    • +3
    ./upgrade/upgrade-4.6.2-4.6.3.sql
    • -0
    • +668
    ./upgrade/upgrade-5.1.0a2-5.1.0a3.sql
  4. … 9 more files in changeset.
Wednesday 26 May 2004
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
    • -4
    • +4
    ./file-storage-package-create.sql
    • -4
    • +4
    ./upgrade/upgrade-4.6.1-4.6.2.sql
    • -3
    • +3
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  4. … 26 more files in changeset.
Tuesday 25 May 2004
8:54 pm

tracya

fixing broken view, file storage broken

Options
    • -2
    • +2
    ./file-storage-views-create.sql
7:39 pm

donb

Fixed bug 1853: missing comma in fs_objects view declaration committed to

HEAD got merged to 5.1 ...

Options
    • -2
    • +2
    ./file-storage-views-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.0d3-5.1.0d4.sql
  3. … 2 more files in changeset.
Sunday 16 May 2004
6:53 pm

daveb

Show title on folder listing. If filename is different than title, show that as well. Show cr_mime_types.label mime type description instead of techincal mime type "code".

Options
    • -4
    • +6
    ./file-storage-views-create.sql
    • -0
    • +48
    ./upgrade/upgrade-5.1.0d3-5.1.0d4.sql
  3. … 5 more files in changeset.
Monday 10 May 2004
2:19 am

daveb

Adding optional cascade_p parameter to file_storage__delete_folder to support

deleting of folder contents.

Options
    • -5
    • +11
    ./file-storage-package-create.sql
  2. … 1 more file in changeset.
Tuesday 23 Mar 2004
1:18 pm

jeffd

bump to 5.1.0a1, rename upgrade-5.0.0-5.1.0.sql to upgrade-5.1.0d1-5.1.0d2 since if the from version was 5.0.1 it would not be run, also 5.1.0 was higher than the existing version in the .info file so it would not get run in any case. bug 1673

Options
    • -37
    • +0
    ./upgrade/upgrade-5.0.0-5.1.0.sql
    • -0
    • +37
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  3. … 3 more files in changeset.