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: 08 May
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 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Friday 15 Oct 2004
10:49 am

maltes

Change needed due to dependecies

Options
    • -6
    • +9
    ./postgresql/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
    ./postgresql/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
    ./postgresql/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
    • +12
    ./oracle/file-storage-notifications-create.sql
    • -1
    • +2
    ./postgresql/file-storage-notifications-create.sql
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
    ./oracle/file-storage-views-create.sql
    • -1
    • +1
    ./oracle/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
    ./oracle/upgrade/upgrade-5.1.0a8-5.1.0a9.sql
9:46 pm

tracya

showing date of latest file change for folders

Options
    • -2
    • +6
    ./oracle/file-storage-views-create.sql
    • -0
    • +47
    ./oracle/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
    ./oracle/file-storage-views-create.sql
    • -0
    • +67
    ./oracle/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
    ./oracle/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
    ./oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
    • -22
    • +665
    ./oracle/upgrade/upgrade-5.1.0d1-5.1.0d2.sql
    • -0
    • +82
    ./postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
    • -27
    • +1
    ./postgresql/upgrade/upgrade-5.1.0d1-5.1.0d2.sql
3:57 pm

daveb

file upgrade-5.1.0a6-5.1.0a7.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql
Monday 02 Aug 2004
7:29 pm

daveb

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

Options
    • -1
    • +4
    ./postgresql/upgrade/upgrade-5.1.0d3-5.1.0d4.sql
Saturday 24 Jul 2004
10:33 am

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040712 and jcd-merge-5-1-20040724 to HEAD

Options
    • -0
    • +46
    ./oracle/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
    • -0
    • +63
    ./postgresql/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
  3. … 137 more files in changeset.
Thursday 22 Jul 2004
12:37 am

jvdongen

Backported notification support for file-storage from HEAD.

Options
    • -1
    • +4
    ./oracle/file-storage-create.sql
    • -1
    • +3
    ./oracle/file-storage-drop.sql
    • -0
    • +0
    ./oracle/file-storage-notifications-create.sql
    • -0
    • +0
    ./oracle/file-storage-notifications-drop.sql
    • -0
    • +46
    ./oracle/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
    • -1
    • +4
    ./postgresql/file-storage-create.sql
    • -1
    • +5
    ./postgresql/file-storage-drop.sql
    • -0
    • +0
    ./postgresql/file-storage-notifications-create.sql
    • -0
    • +0
    ./postgresql/file-storage-notifications-drop.sql
    • -0
    • +63
    ./postgresql/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
  11. … 14 more files in changeset.
12:37 am

jvdongen

file upgrade-5.1.0a4-5.1.0a5.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.0a4-5.1.0a5.sql