OpenACS / openacs-4 / packages / file-storage

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 30
Last Commit: 16:06
Commits this week: 0
Total Lines of Code (LoC): 10,735
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
Friday 30 Sep 2005
8:14 pm

skaufman

partial fix bug 2369

Options
    • -14
    • +25
    ./postgresql/file-storage-package-create.sql
    • -0
    • +199
    ./postgresql/upgrade/upgrade-5.2.0d6-5.2.0d7.sql
  3. … 1 more file in changeset.
8:08 pm

skaufman

adds file_storage__copy_file

Options
    • -1
    • +106
    ./postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
8:07 pm

skaufman

fixes file_storage__copy_file

Options
    • -2
    • +6
    ./postgresql/file-storage-package-create.sql
Thursday 29 Sep 2005
8:51 pm

skaufman

partial fix of bug 2639 -- patch 736

Options
    • -13
    • +20
    ./postgresql/file-storage-package-create.sql
    • -0
    • +199
    ./postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
  3. … 4 more files in changeset.
Thursday 25 Aug 2005
8:44 pm

maltes

Upgrade scripts for the view fix for fs_objects

Options
    • -0
    • +53
    ./oracle/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
    • -0
    • +50
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  3. … 1 more file 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
    ./oracle/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
8:40 pm

maltes

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

Options
    • -2
    • +2
    ./oracle/file-storage-views-create.sql
8:33 pm

maltes

the count in fs_objects was actually counting non fs_objects as well when counting the number of elements in a folder. This has been taken care of.

Options
    • -2
    • +2
    ./postgresql/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
    ./oracle/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
    ./oracle/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
    ./oracle/file-storage-create.sql
    • -1
    • +1
    ./oracle/file-storage-drop.sql
    • -2
    • +6
    ./oracle/file-storage-package-create.sql
    • -1
    • +1
    ./oracle/file-storage-views-create.sql
    • -1
    • +1
    ./oracle/file-storage-views-drop.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.1.0d1-5.1.0d2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql
    • -1
    • +1
    ./postgresql/file-storage-create.sql
    • -1
    • +1
    ./postgresql/file-storage-drop.sql
    • -2
    • +5
    ./postgresql/file-storage-package-create.sql
    • -1
    • +1
    ./postgresql/file-storage-views-create.sql
    • -1
    • +1
    ./postgresql/file-storage-views-drop.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
  16. … 47 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
    ./oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -2
    • +12
    ./oracle/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
    • -2
    • +1
    ./oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
    • -2
    • +1
    ./postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
  5. … 318 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
    ./oracle/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
    ./oracle/upgrade/upgrade-5.0.0-5.1.0.sql
    • -641
    • +0
    ./postgresql/upgrade/upgrade-5.0.0-5.1.0.sql
12:17 pm

maltes

Upgrade scripts was buggy, took the create version

Options
    • -2
    • +12
    ./oracle/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
    ./oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
10:18 pm

maltes

Fixed my previous select as it was missing the parent_id clause

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
8:47 pm

maltes

PLEASE REVERT IF YOU THINK THIS IS NOT RIGHT, but it is the only way this f***ed upgrade script works reliably on the sites I needed to upgrade (and that had the same title twice. I changed the if statement from the complex parent_id, title check to a simple select on the cr_item table, checking if the name is already there. Obviously this is very inefficient (for each file you run yet another select) but it works reliably (with the old version I got errors on two sites)

Options
    • -2
    • +1
    ./postgresql/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
    ./oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
Thursday 03 Feb 2005
1:16 am

jeffd

bind the fts contract when creating the datamodel

Options
    • -0
    • +1
    ./postgresql/file-storage-sc-create.sql
  2. … 1 more file in changeset.
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
    ./oracle/file-storage-create.sql
    • -1
    • +12
    ./oracle/file-storage-notifications-create.sql
    • -0
    • +42
    ./oracle/file-storage-rss-create.sql
    • -4
    • +10
    ./oracle/file-storage-views-create.sql
    • -0
    • +42
    ./oracle/upgrade/upgrade-5.1.0a11-5.1.0a12.sql
    • -0
    • +8
    ./oracle/upgrade/upgrade-5.1.0a12-5.1.0a13.sql
    • -0
    • +12
    ./oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -0
    • +145
    ./oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
    • -0
    • +47
    ./oracle/upgrade/upgrade-5.1.0a8-5.1.0a9.sql
    • -23
    • +611
    ./oracle/upgrade/upgrade-5.1.0d1-5.1.0d2.sql
    • -1
    • +3
    ./postgresql/file-storage-create.sql
    • -1
    • +2
    ./postgresql/file-storage-notifications-create.sql
    • -0
    • +41
    ./postgresql/file-storage-rss-create.sql
    • -6
    • +9
    ./postgresql/upgrade/upgrade-4.2-4.6.sql
    • -0
    • +38
    ./postgresql/upgrade/upgrade-5.1.0a11-5.1.0a12.sql
  16. … 2261 more files in changeset.
Friday 07 Jan 2005
8:52 am

maltes

Two wheres = error. I changed one where to an and and hope this is intended.

Options
    • -2
    • +2
    ./postgresql/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
    ./oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -0
    • +12
    ./postgresql/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
  3. … 1 more file 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
    ./oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
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
    ./oracle/file-storage-rss-create.sql
    • -0
    • +8
    ./oracle/upgrade/upgrade-5.1.0a12-5.1.0a13.sql
    • -1
    • +2
    ./postgresql/file-storage-rss-create.sql
    • -0
    • +37
    ./postgresql/upgrade/upgrade-5.1.0a12-5.1.0a13.sql
  5. … 1 more file 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
    ./oracle/upgrade/upgrade-5.1.0a12-5.1.0a13.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.0a12-5.1.0a13.sql
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
    ./oracle/upgrade/upgrade-5.1.0a11-5.1.0a12.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.0a11-5.1.0a12.sql
5:33 pm

andrewg

Adding rss support, turned off and hidden by default.

Options
    • -1
    • +4
    ./oracle/file-storage-create.sql
    • -0
    • +41
    ./oracle/file-storage-rss-create.sql
    • -0
    • +42
    ./oracle/upgrade/upgrade-5.1.0a11-5.1.0a12.sql
    • -1
    • +3
    ./postgresql/file-storage-create.sql
    • -0
    • +40
    ./postgresql/file-storage-rss-create.sql
    • -0
    • +38
    ./postgresql/upgrade/upgrade-5.1.0a11-5.1.0a12.sql
  7. … 26 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
    ./oracle/file-storage-rss-create.sql
    • -0
    • +0
    ./postgresql/file-storage-rss-create.sql
Friday 22 Oct 2004
9:19 pm

hramado

comment line 49, function file_storage__new_root_folder (integer)

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.1.0d1-5.1.0d2.sql