Add missing foreign key declarations

[asmecher]

Several foreign key constraints were missed in the introduction of #6093. Add them:

• filters.context_id
• plugin_settings.context_id
• navigation_menus.context_id
• navigation_menu_items.context_id
• user_groups.context_id
• email_log.sender_id

[bozana]

I am not sure if it belongs here, but: submission_file_settings contain chapterId setting_name (in OMP). This chapter IDs could apparently be orphaned, not exist any more in the table submission_chapters. S. the case here #9186.

[bozana]

Here an update to the situation described above, when submission files exist with not existing chapter IDs (s. #9186 (comment)): in this case the submission files do exist and are listed and approved under Publication > Publication Formats. Removing the entries with not existing chapter IDs from the table submission_file_settings would lead to publicly listing of those files on the book view page (from previously not being listed), which could be an undesired effect. Thus, maybe the solution here is to just check and report such cases during the upgrade preflight check, so that users can resolve them manually.

[asmecher]

PRs to add fk/index to email_log.sender_id:

• pkp/pkp-lib#8826 Add missing FK and index on email_log.sender_id #9947
• pkp/pkp-lib#8826 Add missing FK and index on email_log.sender_id ojs#4272

[jonasraoni]

I'm closing this as a duplicate of #8333, which has a couple of initial PRs.