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: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 5,648
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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Tuesday 22 Feb 2005
9:22 pm

jeffd

upgrade-5.0.0-5.1.0.sql was not well ordered and was renamed to 5.1.0d1-5.1.0d2

Options
    • -37
    • +0
    ./upgrade/upgrade-5.0.0-5.1.0.sql
  2. … 1 more file in changeset.
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
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
    • +4
    ./file-storage-create.sql
    • -1
    • +12
    ./file-storage-notifications-create.sql
    • -0
    • +42
    ./file-storage-rss-create.sql
    • -4
    • +10
    ./file-storage-views-create.sql
    • -0
    • +42
    ./upgrade/upgrade-5.1.0a11-5.1.0a12.sql
    • -0
    • +8
    ./upgrade/upgrade-5.1.0a12-5.1.0a13.sql
    • -0
    • +12
    ./upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -0
    • +145
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
    • -0
    • +47
    ./upgrade/upgrade-5.1.0a8-5.1.0a9.sql
    • -23
    • +611
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  11. … 2266 more files in changeset.
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.
6:37 pm

daveb

file upgrade-5.1.0a13-5.1.0a14.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.0a13-5.1.0a14.sql
  2. … 1 more file 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.
10:27 pm

andrewg

file upgrade-5.1.0a12-5.1.0a13.sql was initially added on branch oacs-5-1.

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

andrewg

file upgrade-5.1.0a11-5.1.0a12.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.0a11-5.1.0a12.sql
  2. … 1 more file in changeset.
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.
5:33 pm

andrewg

file file-storage-rss-create.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./file-storage-rss-create.sql
  2. … 1 more file 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

file upgrade-5.1.0a8-5.1.0a9.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.0a8-5.1.0a9.sql
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