• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- add missing enumeration type to create script

- fix ambiguity for content_item__new in template__new

- add/update mime types for text/csv text/vcard, text/calendar

- bump version number to 5.9.1d17

  1. … 6 more files in changeset.
- Change text enumeration field "storage_type" in cr_items to native

SQL enumeration type

- bump version number to 5.9.1d15

  1. … 3 more files in changeset.
- fix install scripts

  1. … 1 more file in changeset.
Content-Repository Reform: reduce dependency on cr_child_rels and simplify content_item__del() via cascading delete operations

- remove manual deletion operations from content_item__del() via

* delete cr_child_rels via "ON DELETE CASCADE" on parent_id and child_id

* delete cr_item_rels via "ON DELETE CASCADE" on item_id

* delete acs_object_context_index entries via "ON DELETE CASCADE" on ancestor_id and object_id

* delete acs_objects entries via "ON DELETE CASCADE" on context_id

- remove manual deletion operations for symlinks amd journal entries,

since db constrains handle the deletion already

- use cr_items.parent_id instead of cr_child_rels to determine direct children

of items

- remove deletion trigger for content search content_search__dtrg

since "ON DELETE CASCADE" removes entries already

  1. … 3 more files in changeset.
Content-Repository Reform : Reduction of number of functions in

the content repository for PostgreSQL by using using argument defaults

(while providing compatibility for clients using old versions):

- reduced number of versions of content_item__new from 12 (!) to 6 by using defaults

- commented differences

- commented arguments of plpgsql functions with long argument lists

- reduced code duplication by basing one version of content_item__new/17 directly on /20

- marking on version of content_item__new/17 and content_item__new/6 as deprecated

- reduced number of versions of content_revision__new from 7 to 4 by using defaults

- commented differences

- marking on version of content_revision__new/7 as deprecated

- let automatically generated functions call directly content_revision__new/13

- remove space from automatically generated functions

- updated automatically generated functions for all types of the content repository

- reduced number of versions of image__new from 4 to 2by using defaults

- reduced number of versions of image__new_revision from 2 to 1 by using defaults

  1. … 7 more files in changeset.
- follow naming conventions proposed by regression test

- bump version number

  1. … 3 more files in changeset.
Scalability reform part 3 (content-repository):

- content_revision__del:

* Removed manual nulling of live_revision and latest_revision

by using appropriate ond delete actions on foreign keys

* Removed manual deletion of old_revision and new_revision in

cr_item_publish_audit by using "on delete cascade"

- content_item__del:

* Removed manual deletion of item_id in cr_item_publish_audit

by using "on delete cascade"

* Removed manual deletion of item_id in cr_release_periods

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_template_map

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_keyword_map

by using "on delete cascade"

* Removed manual deletion of direct permissions (was already

cascading)

- Added missing index for child_id to cr_child_rels.

This index was in the create scripts (with a non-conformant name),

but not in the upgrade scripts

- bump version number of acs-content-repository to 5.9.0d3

  1. … 4 more files in changeset.
- Scalability reform part 2:

* remove cases in the content repository where referencial

integrity was handled manually. Ancient versions of

PostgresSQL seemed to have a bug, which was adressed

via extra triggers in OpenACS

* drop some leftover form ancient versions, were some

update scripts were missing

- bump version number of acs-content-repository to 5.9.0d2

  1. … 2 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2547 more files in changeset.
- use external command "find" instead of tcllib package fileutil for speed and better filtering

- add index for much quicker reverse lookup file names in the content repository

  1. … 6 more files in changeset.
*** empty log message ***

make sure we exclude null paths from cr_files_to_delete

  1. … 1 more file in changeset.
- missing index and foreign key constraints on cr_item_publish_audit fixed

  1. … 2 more files in changeset.
Bring PostgreSQL functions closer to the current level of PL/pgSQL:

- upgrade PL/pgSQL functions to the $$ notation (recommended since pg8.0, jan 2005).

- get rid of backslash usages in function definitions

- drop aliases in favor of named function arguments (recommended since pg8.0)

- fix wrong function_args, add missing function_args, align default semantics

with the defaults in pg (providing "null" as default means the argument is

optional).

- change return types of triggers from "opaque" to "trigger" (recommended since pg8.0)

- unify names of triggers *_tr

- removed some version dependencies of pg 7.2 and 7.3

  1. … 54 more files in changeset.
Moved table building and column adding code from content repository to

kernel, so all objects can benefit. Part of the acs object management package

work.

  1. … 5 more files in changeset.
Fixed a problem with the deletion of lob.sql-based ("pseudo-lob") binary

storage.

  1. … 2 more files in changeset.
switch foo_id_seq.netval to nextval('t_foo_id_seq') calls to placate postgresql 8.

  1. … 8 more files in changeset.
Merged from 5.4.2

  1. … 283 more files in changeset.
Made naming constraints follow our standard so PG core AA tests won't bitch

  1. … 1 more file in changeset.
Remove unecessary upgrades.

Fix RI trigger now that we require PG 8 we don't need the workaround in

cr_folders.

  1. … 4 more files in changeset.
Support for relative file locations which might even reside on a windows drive and therefore start with d:\

  1. … 6 more files in changeset.
Merged the 5.3 branch with HEAD. Look for tags with the pattern

drb-*-20070513

  1. … 324 more files in changeset.
Update default template to use text instead of content tag to property grab

text from filesystem stored revisions.

  1. … 1 more file in changeset.
Correction of name constraint

  1. … 4 more files in changeset.
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?

  1. … 721 more files in changeset.
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.

  1. … 7 more files in changeset.
changes and new upgrade file for fixing performan issues in the CR when adding / editing an item

  1. … 1 more file in changeset.
Page root and template root registered as magic objects.

  1. … 1 more file in changeset.
add index on cr_revisions(publish_date), upgrade bump to 5.2.0d12

  1. … 4 more files in changeset.
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

  1. … 2275 more files in changeset.