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