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: 13:02
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
Wednesday 04 Jan 2006
4:51 pm

daveb

Refresh content_revision view also, not just child types.

Options
    • -3
    • +4
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
2:29 am

daveb

Fix upgrade. Move 5.2.0 stuff to 5.2.1

Options
    • -486
    • +0
    ./oracle/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
    • -2
    • +489
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
    • -95
    • +0
    ./postgresql/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
    • -1
    • +97
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
1:38 am

donb

More 5.2 fixes for Oracle ...

Options
    • -2
    • +2
    ./oracle/content-folder.sql
    • -8
    • +1166
    ./oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
Tuesday 03 Jan 2006
4:05 pm

daveb

Recreate content_keyword__new to support package_id.

Refresh views and triggers.

Options
    • -2
    • +95
    ./postgresql/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
4:04 pm

daveb

Refresh views and triggers.

Recreate content keyword to support package_id parameter

Options
    • -0
    • +486
    ./oracle/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
4:04 pm

daveb

file upgrade-5.2.0b11-5.2.0b12.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
2:45 pm

daveb

Refresh insert views on upgrade since the definition has changed.

Options
    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
2:45 pm

daveb

file upgrade-5.2.0b11-5.2.0b12.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0b11-5.2.0b12.sql
Thursday 29 Dec 2005
2:24 am

daveb

file upgrade-5.2.1d1-5.2.1d2.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
2:24 am

daveb

Changes to make the root of parentless items = -4 (security context root) instead of 0 (unregistered visitor)

Sites upgradeed from 4.6-4.6.1 have been operating with -4 as the parent_id for years (for example openacs.org) while new installs had

parent_id = 0. This caused problems with the new package_id code that calls content_item__get_root_folder which was assuming the root =

0. It looks like the new install code did not accomodate parent_id=-4 and that is now fixed.

Needs testing on Oracle.

Options
    • -3
    • +3
    ./oracle/content-create.sql
    • -5
    • +5
    ./oracle/content-folder.sql
    • -10
    • +10
    ./oracle/content-item.sql
    • -0
    • +1812
    ./oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
    • -3
    • +3
    ./postgresql/content-create.sql
    • -6
    • +6
    ./postgresql/content-folder.sql
    • -20
    • +20
    ./postgresql/content-item.sql
    • -0
    • +957
    ./postgresql/upgrade/upgrade-5.2.1d1-5.2.1d2.sql
Tuesday 13 Dec 2005
2:07 pm

maltes

Added missing content-folders on upgrade

Options
    • -0
    • +1
    ./postgresql/upgrade/upgrade-5.2.0b9-5.2.0b10.sql
Monday 12 Dec 2005
2:09 pm

maltes

A couple of content_item__new functions were missing so I recreated them all

Options
    • -0
    • +954
    ./postgresql/upgrade/upgrade-5.2.0b9-5.2.0b10.sql
  2. … 1 more file in changeset.
2:09 pm

maltes

file upgrade-5.2.0b9-5.2.0b10.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0b9-5.2.0b10.sql
Saturday 03 Dec 2005
9:57 pm

daveb

Fix define_function_args for content_type__register_child_type

Options
    • -5
    • +5
    ./postgresql/content-type.sql
Wednesday 30 Nov 2005
2:27 am

donb

1. Fixed a wee bit of PG-ish code that snuck into the content repository's

Oracle datamodel.

2. Tested Dave's recent changes to subsite for Oracle. It works. Bumped

the info file to reflect the new version so the upgrade scripts will run.

Options
    • -2
    • +2
    ./oracle/content-folder.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
  3. … 1 more file in changeset.
Tuesday 29 Nov 2005
12:39 pm

maltes

file upgrade-5.2.0b6-5.2.0b7.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0b6-5.2.0b7.sql
12:39 pm

maltes

Somehow the extlink functions where missing on our installs, so I assume it is saver to get them again in an upgrade script

Options
    • -0
    • +237
    ./postgresql/upgrade/upgrade-5.2.0b6-5.2.0b7.sql
  2. … 1 more file in changeset.
Saturday 26 Nov 2005
10:25 pm

daveb

Allow content_folders to have non-cr_items as parents

Options
    • -2
    • +3
    ./oracle/content-folder.sql
    • -1
    • +673
    ./oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
10:24 pm

daveb

Upgrade to allow cr_folders to have non-cr_items as parents

Options
    • -1
    • +99
    ./postgresql/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
10:22 pm

daveb

Allow folders to have non-cr_items are parents

Options
    • -2
    • +3
    ./postgresql/content-folder.sql
Friday 28 Oct 2005
8:03 pm

daveb

Don't try to get the package id of folder_id 0 (which isn't a folder anyway!)

Options
    • -0
    • +1325
    ./oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
    • -2
    • +2
    ./postgresql/content-item.sql
    • -2
    • +210
    ./postgresql/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
8:03 pm

daveb

file upgrade-5.2.0b5-5.2.0b6.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
1:26 am

donb

Fixed Daveb's translation of his PG change to this script (he didn't have

oracle to test his changes on)

Options
    • -5
    • +2
    ./oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Thursday 27 Oct 2005
9:30 pm

daveb

Fix bug#2668

Options
    • -4
    • +10
    ./oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql
7:16 pm

daveb

Fix bug#2668, don't try to recrete views for edit-this-page content types without content tables.

Options
    • -4
    • +7
    ./postgresql/upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Tuesday 25 Oct 2005
5:40 pm

daveb

Fix upgrade since we support proper upgrade from beta to release.

Options
    • -0
    • +10
    ./postgresql/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
5:40 pm

daveb

file upgrade-5.2.0b5-5.2.0b6.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0b5-5.2.0b6.sql
5:27 pm

daveb

Fix define function args for set_live_revision

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
Wednesday 12 Oct 2005
1:53 am

donb

Fixed this bug many moons ago but failed to commit ...

Options
    • -0
    • +1
    ./oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql
Monday 03 Oct 2005
8:17 pm

rocaelh

file upgrade-5.2.0b2-5.2.0b3.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0b2-5.2.0b3.sql