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

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 28
Last Commit: 12 Sep 13
Commits this week: 0
Total Lines of Code (LoC): 3,659
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 10 Feb 2005
10:18 pm

maltes

Fixed my previous select as it was missing the parent_id clause

Options
    • -1
    • +1
    ./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
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
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
    ./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
    • +37
    ./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
    • +3
    ./file-storage-create.sql
    • -0
    • +40
    ./file-storage-rss-create.sql
    • -0
    • +38
    ./upgrade/upgrade-5.1.0a11-5.1.0a12.sql
  4. … 29 more files in changeset.
Friday 22 Oct 2004
9:19 pm

hramado

comment line 49, function file_storage__new_root_folder (integer)

Options
    • -1
    • +1
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
Friday 15 Oct 2004
10:49 am

maltes

Change needed due to dependecies

Options
    • -6
    • +9
    ./upgrade/upgrade-4.2-4.6.sql
  2. … 1 more file in changeset.
Monday 13 Sep 2004
7:49 pm

hramado

fixing syntax error

Options
    • -1
    • +1
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
Tuesday 07 Sep 2004
4:29 pm

daveb

Patch #594, Fixes bug#2092, syntax errors in upgrade script.

Options
    • -4
    • +5
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
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
    • +2
    ./file-storage-notifications-create.sql
  2. … 1 more file in changeset.
Monday 09 Aug 2004
3:57 pm

daveb

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

re-sourceing package create.sql

Options
    • -0
    • +82
    ./upgrade/upgrade-5.1.0a6-5.1.0a7.sql
    • -27
    • +1
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  3. … 2 more files in changeset.
Monday 02 Aug 2004
7:29 pm

daveb

Fix bug#2036. Recreate file-storage view with cr_revisions.title

Options
    • -1
    • +4
    ./upgrade/upgrade-5.1.0d3-5.1.0d4.sql
Thursday 22 Jul 2004
12:37 am

jvdongen

Backported notification support for file-storage from HEAD.

Options
    • -1
    • +4
    ./file-storage-create.sql
    • -1
    • +5
    ./file-storage-drop.sql
    • -0
    • +0
    ./file-storage-notifications-create.sql
    • -0
    • +0
    ./file-storage-notifications-drop.sql
    • -0
    • +63
    ./upgrade/upgrade-5.1.0a4-5.1.0a5.sql
  6. … 19 more files in changeset.
Friday 09 Jul 2004
3:40 pm

daveb

Fix file_storage__move_file in upgrade script. Fixes bug#1974

Options
    • -0
    • +27
    ./upgrade/upgrade-5.1.0a3-5.1.0a4.sql
  2. … 1 more file 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.
Thursday 17 Jun 2004
3:04 pm

daveb

Close bug#1908. Remove call to new_root_folder.

Options
    • -2
    • +0
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.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
    • -2
    • +2
    ./upgrade/upgrade-4.2-4.6.sql
    • -0
    • +21
    ./upgrade/upgrade-5.1.0a2-5.1.0a3.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.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
    • -3
    • +3
    ./file-storage-package-create.sql
    • -2
    • +2
    ./upgrade/upgrade-4.2-4.6.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  4. … 26 more files in changeset.
Tuesday 25 May 2004
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
7:08 pm

daveb

Remove misnamed upgrade script.

Options
    • -69
    • +0
    ./upgrade/upgrade-5.1.0d3-5.1.0.d4.sql
    • -1
    • +71
    ./upgrade/upgrade-5.1.0d3-5.1.0d4.sql
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
    • +9
    ./file-storage-views-create.sql
    • -0
    • +48
    ./upgrade/upgrade-5.1.0d3-5.1.0d4.sql
  3. … 5 more files in changeset.
Thursday 13 May 2004
2:48 pm

daveb

Recreate file_storage__new_root_folder on upgrade.

Options
    • -0
    • +69
    ./upgrade/upgrade-5.1.0d3-5.1.0.d4.sql
Tuesday 11 May 2004
3:06 am

daveb

Fix missing '' in file_storage__delete_folder. Fixes bug#1808

Options
    • -2
    • +2
    ./file-storage-package-create.sql
    • -0
    • +42
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
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
    • -2
    • +22
    ./file-storage-package-create.sql
  2. … 1 more file in changeset.
Friday 07 May 2004
6:28 pm

daveb

Remove unused v_count variable in file_storage__get_root_folder

Options
    • -1
    • +0
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
6:24 pm

daveb

Remove unused v_count variable in file_storage__get_root_folder.

Options
    • -2
    • +1
    ./file-storage-package-create.sql
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
    • -641
    • +0
    ./upgrade/upgrade-5.0.0-5.1.0.sql
    • -0
    • +641
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  3. … 3 more files in changeset.