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: 07 Nov
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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
4:40 am

donb

Fixed an upgrade script ordering issue

Options
    • -0
    • +50
    ./postgresql/upgrade/upgrade-5.2.0d18-5.2.0d19.sql
Wednesday 22 Nov 2006
11:03 am

nimam

Reverted all changes from Mannheim

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.1.4d4-5.1.4d5.sql
  2. … 222 more files in changeset.
Monday 20 Nov 2006
9:00 pm

nimam

Mannheim update, fix and merge bugbash

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.1.4d4-5.1.4d5.sql
  2. … 197 more files in changeset.
10:24 am

maltes

Change to the locking of acs-objects

Options
    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.3.0d4-5.3.0d5.sql
    • -0
    • +793
    ./postgresql/upgrade/upgrade-5.3.0d6-5.3.0d7.sql
  3. … 1 more file in changeset.
Thursday 05 Oct 2006
7:04 pm

emmar

Fix #3008: remove duplicated drop_type procedure, added missing param in proc specification and correct upgrade script

Options
    • -104
    • +3
    ./oracle/content-type.sql
    • -2
    • +2
    ./oracle/packages-create.sql
    • -3
    • +1099
    ./oracle/upgrade/upgrade-5.3.0d2-5.3.0d3.sql
Tuesday 03 Oct 2006
6:37 pm

victorg

Adding script upgrade for fixing typo in function content_extlink__copy.

This has been fixed in the create script ( content-extlink.sql).

Options
    • -0
    • +81
    ./postgresql/upgrade/upgrade-5.3.0d3-5.3.0d4.sql
  2. … 1 more file in changeset.
Tuesday 26 Sep 2006
4:48 pm

byronl

Correction of name constraint

Options
    • -28
    • +30
    ./oracle/content-create.sql
    • -2
    • +2
    ./oracle/content-image.sql
    • -2
    • +3
    ./oracle/content-xml.sql
  4. … 11 more files in changeset.
Monday 25 Sep 2006
10:15 pm

byronl

Correction of name constraint

Options
    • -57
    • +66
    ./postgresql/content-create.sql
    • -2
    • +2
    ./postgresql/content-image.sql
    • -3
    • +3
    ./postgresql/content-type.sql
    • -2
    • +3
    ./postgresql/content-xml.sql
  5. … 1 more file in changeset.
Sunday 24 Sep 2006
1:37 pm

maltes

Added the option to drop the items, revisions and objects along with the dropping of a content type

Options
    • -1
    • +128
    ./oracle/content-type.sql
    • -0
    • +127
    ./oracle/upgrade/upgrade-5.3.0d2-5.3.0d3.sql
    • -1
    • +121
    ./postgresql/content-type.sql
    • -0
    • +118
    ./postgresql/upgrade/upgrade-5.3.0d2-5.3.0d3.sql
  5. … 2 more files in changeset.
Wednesday 06 Sep 2006
4:46 pm

daveb

Update search triggers to honor publish_date.

Options
    • -12
    • +17
    ./postgresql/content-search.sql
    • -0
    • +74
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
Thursday 27 Jul 2006
10:09 pm

victorg

Removing wrong acs attributes for object type apm_package.

Fixing object attribute datatypes so they are consistent

with the database datatype.

Options
    • -7
    • +7
    ./oracle/types-create.sql
    • -7
    • +7
    ./postgresql/types-create.sql
  3. … 2 more files in changeset.
Wednesday 26 Jul 2006
10:52 pm

gustafn

Fix for the duplicate revision_id and deadlock on concurrent cr updates and inserts

Options
    • -49
    • +38
    ./postgresql/content-type.sql
    • -0
    • +267
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  3. … 4 more files in changeset.
Thursday 13 Jul 2006
10:43 pm

victorg

Removing upgrade scripts not well ordered for acs-kernel and acs-content-repository.

Adding corresponding upgrade scripts with correct versions.

Now the test case files__check_upgrade_ordering (acs-tcl) does not fail.

Options
    • -50
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d15-5.2.0a1.sql
    • -0
    • +52
    ./postgresql/upgrade/upgrade-5.2.0d18-5.2.0d19.sql
  3. … 4 more files in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -0
    • +5
    ./common/mime-type-data.sql
    • -3
    • +3
    ./oracle/content-create.sql
    • -14
    • +8
    ./oracle/content-folder.sql
    • -5
    • +5
    ./oracle/content-image.sql
    • -20
    • +13
    ./oracle/content-item.sql
    • -1
    • +1
    ./oracle/content-keyword.sql
    • -1
    • +7
    ./oracle/packages-create.sql
    • -0
    • +1963
    ./oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql
    • -0
    • +3155
    ./oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
    • -0
    • +497
    ./oracle/upgrade/upgrade-5.2.0b6-5.2.0b7.sql
    • -1
    • +3
    ./oracle/upgrade/upgrade-5.2.0d16-5.2.0d17.sql
    • -0
    • +2937
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
    • -0
    • +285
    ./oracle/upgrade/upgrade-5.2.2-5.2.3d1.sql
    • -0
    • +203
    ./oracle/upgrade/upgrade-5.2.3d1-5.2.3d2.sql
    • -70
    • +61
    ./postgresql/content-create.sql
  16. … 707 more files in changeset.