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
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