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: 03 Jun
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 9 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
    ./oracle/file-storage-package-create.sql
    • -2
    • +2
    ./oracle/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
    ./oracle/file-storage-package-create.sql
Friday 09 Aug 2019
10:19 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./postgresql/file-storage-package-create.sql
  2. … 14 more files in changeset.
Friday 15 Mar 2019
10:36 am

antoniop

Align fs_objects view definition in Oracle with the one in Postgres

Options
    • -6
    • +3
    ./oracle/file-storage-views-create.sql
    • -0
    • +49
    ./oracle/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
    ./oracle/upgrade/upgrade-5.10.d2-5.10.d3.sql
Wednesday 15 Aug 2018
6:49 pm

gustafn

Removed obsolete @arch-tag

Options
    • -3
    • +2
    ./oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -2
    • +1
    ./oracle/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
    • -3
    • +2
    ./postgresql/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
    • -2
    • +1
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  5. … 23 more files in changeset.
Friday 29 Dec 2017
12:32 pm

gustafn

fix typos

Options
    • -2
    • +2
    ./postgresql/file-storage-package-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.2.0d6-5.2.0d7.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.2.0d7-5.2.0d8.sql
  5. … 4 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
    ./oracle/file-storage-package-create.sql
    • -0
    • +478
    ./oracle/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
    • -9
    • +14
    ./postgresql/file-storage-package-create.sql
    • -7
    • +22
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
    • -0
    • +135
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
  7. … 7829 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
    ./oracle/file-storage-package-create.sql
    • -0
    • +478
    ./oracle/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
    • -8
    • +11
    ./postgresql/file-storage-package-create.sql
    • -0
    • +135
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
  5. … 9 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
    ./oracle/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
Tuesday 01 Nov 2016
6:21 pm

gustafn

- avoid call to deprecated content_revision__new/11, call content_revision__new/13 instead

- bump version number to 5.9.1d2

Options
    • -2
    • +4
    ./postgresql/file-storage-package-create.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
  3. … 1 more file in changeset.
6:21 pm

gustafn

file upgrade-5.9.1d1-5.9.1d2.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
Thursday 17 Dec 2015
9:43 pm

gustafn

- (backport from oacs-5-9): rewrite update script based on a recursive query to avoid potential conflicts due to different orders of script execution, when e.g. acs_objects.tree_sortkey was already dropped.

Options
    • -7
    • +22
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
9:41 pm

gustafn

- rewrite update script based on a recursive query to avoid potential conflicts due to different orders of script execution, when e.g. acs_objects.tree_sortkey was already dropped.

Options
    • -7
    • +22
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
Tuesday 30 Jun 2015
1:39 pm

gustafn

- add function args missed by earlier upgrades

- bump version numbers

Options
    • -0
    • +16
    ./postgresql/upgrade/upgrade-5.9.0d1-5.9.0d2.sql
  2. … 9 more files in changeset.
Monday 27 Apr 2015
5:28 pm

victorg

Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

Options
    • -106
    • +101
    ./postgresql/file-storage-package-create.sql
    • -0
    • +137
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
  3. … 519 more files in changeset.
Wednesday 03 Dec 2014
5:23 pm

gustafn

- fix for bloat in cr_folder_type_map caused by file-storage. large sites might have 10 Mio+ entries! see posting in OpenACS Development forum concerning cr_folder_type_map bloat

Options
    • -107
    • +102
    ./postgresql/file-storage-package-create.sql
    • -0
    • +137
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
  3. … 2 more files in changeset.
5:23 pm

gustafn

file upgrade-5.8.1-5.8.2.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1-5.8.2.sql
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -1
    • +2
    ./postgresql/file-storage-package-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  3. … 2546 more files in changeset.
Saturday 30 Aug 2014
6:47 pm

gustafn

file upgrade-5.8.1d3-5.8.1d4.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  2. … 1 more file in changeset.
6:43 pm

gustafn

- add missing function args

Options
    • -1
    • +2
    ./postgresql/file-storage-package-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  3. … 7 more files in changeset.
Sunday 31 Mar 2013
6:31 pm

gustafn

- fix $$ quoting in upgrade scripts

Options
    • -2
    • +1
    ./postgresql/upgrade/upgrade-5.1.0a3-5.1.0a4.sql
  2. … 2 more files in changeset.
2:01 pm

gustafn

- fix collateral damage in upgrade scripts of file-storage

Options
    • -6
    • +4
    ./postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
    • -3
    • +2
    ./postgresql/upgrade/upgrade-4.6.3-5.0.0.sql
    • -6
    • +4
    ./postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
    • -5
    • +3
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
    • -3
    • +2
    ./postgresql/upgrade/upgrade-5.1.0d3-5.1.0d4.sql
    • -4
    • +3
    ./postgresql/upgrade/upgrade-5.2.0d6-5.2.0d7.sql
Saturday 30 Mar 2013
11:50 pm

gustafn

- update postgres function to modern style plpgsql definitions using dollar quoting

Options
    • -12
    • +13
    ./postgresql/file-storage-create.sql
    • -8
    • +15
    ./postgresql/file-storage-drop.sql
    • -26
    • +33
    ./postgresql/file-storage-notifications-create.sql
    • -29
    • +37
    ./postgresql/file-storage-notifications-drop.sql
    • -292
    • +408
    ./postgresql/file-storage-package-create.sql
    • -258
    • +325
    ./postgresql/upgrade/upgrade-4.2-4.6.sql
    • -21
    • +37
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
    • -85
    • +94
    ./postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
    • -28
    • +31
    ./postgresql/upgrade/upgrade-4.6.3-5.0.0.sql
    • -8
    • +17
    ./postgresql/upgrade/upgrade-5.1.0a12-5.1.0a13.sql
    • -96
    • +100
    ./postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
    • -13
    • +16
    ./postgresql/upgrade/upgrade-5.1.0a2-5.1.0a3.sql
    • -17
    • +20
    ./postgresql/upgrade/upgrade-5.1.0a3-5.1.0a4.sql
    • -25
    • +30
    ./postgresql/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
    • -18
    • +25
    ./postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
  16. … 27 more files in changeset.
Saturday 05 Dec 2009
3:08 am

donb

1. Package uninstantiate now cleans up the instance's root folder.

2. Package drop works.

Options
    • -18
    • +11
    ./postgresql/file-storage-drop.sql
    • -1
    • +6
    ./postgresql/file-storage-notifications-drop.sql
  3. … 4 more files 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
    ./oracle/file-storage-create.sql
    • -0
    • +26
    ./oracle/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
    • -4
    • +13
    ./postgresql/file-storage-create.sql
    • -0
    • +22
    ./postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
  5. … 1 more file in changeset.
Thursday 29 Jan 2009
3:31 pm

emmar

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

Options
    • -0
    • +7
    ./oracle/upgrade/upgrade-5.5.0d1-5.5.0d2.sql
    • -0
    • +7
    ./postgresql/upgrade/upgrade-5.5.0d1-5.5.0d2.sql
  3. … 1 more file in changeset.
Tuesday 13 May 2008
1:09 pm

marka

compilation error due to bad plpgsql body

Options
    • -1
    • +3
    ./postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
    • -2
    • +4
    ./postgresql/upgrade/upgrade-5.1.0d1-5.1.0d2.sql
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
    ./oracle/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
  3. … 3 more files in changeset.
9:36 am

maltes

Fixed it so only the parameter from file storage package will be overwritten and not any other parameters with the same name

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.4.0d1-5.4.0d2.sql