OpenACS / openacs-4 / packages / acs-content-repository

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 47
Last Commit: 24 Sep
Commits this week: 0
Total Lines of Code (LoC): 77,885
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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 20 Jan 2008
6:15 pm

donb

Part of the malte rollback

Options
    • -670
    • +0
    ./oracle/upgrade/upgrade-5.4.0d5-5.4.0d6.sql
5:19 pm

donb

Rolled back abortive attempt to substitute dbms_log stuff for java

Options
    • -2
    • +2
    ./oracle/content-image.sql
    • -0
    • +50
    ./oracle/packages-create.sql
    • -134
    • +0
    ./oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql
    • -137
    • +0
    ./oracle/upgrade/upgrade-5.4.0d4-5.4.0d5.sql
  5. … 1 more file in changeset.
Monday 01 Oct 2007
12:44 pm

gustafn

new update script in case, someone managed to get the .info file without the update script

Options
    • -0
    • +146
    ./postgresql/upgrade/upgrade-5.4.0d7-5.4.0d8.sql
    • -0
    • +360
    ./postgresql/upgrade/upgrade-5.4.0d8-5.4.0d9.sql
  3. … 1 more file in changeset.
12:15 pm

gustafn

add update script

Options
    • -21
    • +21
    ./postgresql/content-item.sql
  2. … 1 more file in changeset.
2:10 am

gustafn

fix more function_args, fix comment for default values in stored procedures

Options
    • -5
    • +5
    ./postgresql/content-folder.sql
    • -4
    • +4
    ./postgresql/content-type.sql
  3. … 1 more file in changeset.
Tuesday 25 Sep 2007
5:22 pm

donb

Merged 5.3 to HEAD

Options
    • -26
    • +1
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
  2. … 60 more files in changeset.
Monday 17 Sep 2007
3:06 pm

maltes

Made sure the content package has the new procedures as well

Options
    • -36
    • +127
    ./oracle/content-package.sql
3:00 pm

maltes

Missing upgrade scripts

Options
    • -0
    • +3
    ./oracle/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
    • -0
    • +134
    ./oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql
    • -0
    • +137
    ./oracle/upgrade/upgrade-5.4.0d4-5.4.0d5.sql
    • -0
    • +670
    ./oracle/upgrade/upgrade-5.4.0d5-5.4.0d6.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-5.4.0d6-5.4.0d7.sql
2:58 pm

maltes

Got rid of reliance on Java for Oracle. Removed unused old functions. Hopefully someone else can help with a fresh install test as well

Options
    • -59
    • +2
    ./oracle/content-revision.sql
    • -53
    • +125
    ./oracle/content-util.sql
    • -50
    • +0
    ./oracle/packages-create.sql
    • -71
    • +1
    ./postgresql/content-util.sql
  5. … 2 more files in changeset.
11:43 am

gustafn

Get rid of the postgres warning "adding missing FROM-clause entry " on sequences

Make "db_nextval acs_object_id_seq" more than twice as fast (from 948 microseconds to 378 microseconds)

Options
    • -8
    • +11
    ./postgresql/content-item.sql
    • -2
    • +5
    ./postgresql/content-template.sql
    • -0
    • +839
    ./postgresql/upgrade/upgrade-5.4.0d4-5.4.0d5.sql
  4. … 7 more files in changeset.
Saturday 15 Sep 2007
8:15 pm

gustafn

adding upgrade script

Options
    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.4.0d3-5.4.0d4.sql
8:13 pm

gustafn

Fix incorrect function args

Options
    • -3
    • +3
    ./postgresql/content-type.sql
  2. … 1 more file in changeset.
Wednesday 29 Aug 2007
8:28 pm

maltes

Support for relative file locations which might even reside on a windows drive and therefore start with d:\

Options
    • -2
    • +3
    ./oracle/content-create.sql
    • -1
    • +3
    ./oracle/content-image.sql
    • -1
    • +2
    ./postgresql/content-create.sql
  4. … 4 more files in changeset.
Saturday 19 May 2007
9:55 pm

maltes

This old version of the view update is superseeded by upgrade-5.3.0d1, apart from the fact that on none of my sites moving from pre 5.2 it has been working on an upgrade (usually fails due to image content type)

Options
    • -26
    • +1
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
Thursday 17 May 2007
12:09 pm

emmar

Remove duplicated inserts of Open Documents mime types

Options
    • -16
    • +0
    ./common/mime-type-data.sql
Monday 14 May 2007
10:30 pm

donb

Merged the 5.3 branch with HEAD. Look for tags with the pattern

drb-*-20070513

Options
    • -0
    • +16
    ./common/mime-type-data.sql
    • -2
    • +2
    ./postgresql/content-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql
    • -0
    • +288
    ./postgresql/upgrade/upgrade-5.3.0b2-5.3.0b3.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  6. … 320 more files in changeset.
Thursday 29 Mar 2007
9:51 am

gustafn

add mime types for .xpi and .mp4

Options
    • -0
    • +4
    ./common/mime-type-data.sql
    • -0
    • +19
    ./common/upgrade/upgrade-5.3.0b1-5.3.0b2.sql
  3. … 1 more file in changeset.
Wednesday 10 Jan 2007
6:32 pm

daveb

Move content_revision__new functions to a seperate upgrade script that

will run after beta2.

Options
    • -281
    • +1
    ./postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql
    • -0
    • +288
    ./postgresql/upgrade/upgrade-5.3.0b2-5.3.0b3.sql
6:32 pm

daveb

file upgrade-5.3.0b2-5.3.0b3.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.3.0b2-5.3.0b3.sql
6:23 pm

daveb

Recreate all content_revision__new functions.

Options
    • -2
    • +282
    ./postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql
Tuesday 09 Jan 2007
7:48 pm

daveb

Recreating the trigger without recreating the view can cause a problem

in a very specific case. It doesn't hurt to recreate the view (which

calls refresh_trigger)

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
Wednesday 03 Jan 2007
10:06 pm

daveb

Fix upgrade script to update the correct revision_id for the template

since template_id is a cr_items.item_id.

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql
10:00 pm

daveb

file upgrade-5.3.0b1-5.3.0b2.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql
10:00 pm

daveb

Update default template to use text instead of content tag to property grab

text from filesystem stored revisions.

Options
    • -2
    • +2
    ./postgresql/content-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql
Friday 15 Dec 2006
1:36 pm

emmar

Add Open Documents MIME types

Options
    • -0
    • +31
    ./common/mime-type-data.sql
    • -0
    • +56
    ./oracle/upgrade/upgrade-5.3.0d3-5.3.0d4.sql
    • -0
    • +54
    ./postgresql/upgrade/upgrade-5.3.0d7-5.3.0d8.sql
1:28 pm

emmar

file upgrade-5.3.0d3-5.3.0d4.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.3.0d3-5.3.0d4.sql
1:28 pm

emmar

file upgrade-5.3.0d7-5.3.0d8.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.3.0d7-5.3.0d8.sql
1:28 pm

emmar

Add Open Documents MIME types

Options
    • -0
    • +31
    ./common/mime-type-data.sql
    • -0
    • +56
    ./oracle/upgrade/upgrade-5.3.0d3-5.3.0d4.sql
    • -0
    • +54
    ./postgresql/upgrade/upgrade-5.3.0d7-5.3.0d8.sql
1:00 am

donb

First round of oacs-5-3 merge to HEAD commits

Options
    • -10
    • +0
    ./oracle/upgrade/upgrade-5.1.0-5.1.1.sql
    • -0
    • +10
    ./oracle/upgrade/upgrade-5.1.5d2-5.1.5d3.sql
    • -0
    • +50
    ./postgresql/upgrade/upgrade-5.2.0d18-5.2.0d19.sql
  4. … 94 more files in changeset.
Thursday 14 Dec 2006
5:22 am

donb

Fixed an upgrade ordering problem

Options
    • -10
    • +0
    ./oracle/upgrade/upgrade-5.1.0-5.1.1.sql
    • -0
    • +10
    ./oracle/upgrade/upgrade-5.1.5d2-5.1.5d3.sql