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