gustafn
committed
on 11 Feb 16
Content-Repository Reform: reduce dependency on cr_child_rels and simplify content_item__del() via cascading delete operations
- remove manu… Show more
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

Show less