Foreign key constraint blocks (final) tab deletion

[MaiklT]

When trying to delete a page from the trash bin I run into an error that tells me to check my internet connection... As that can't be the reason I investigated a bit and found out that there is a foreign key constraint in the table Community_Visits (FK_Community_Visits_Tabs) blocking the deletion.

When deleting all records in this table with tab_id = (TabId of this page from the Tabs table) and restarting the app pool, the page can be deleted from the trash bin.

It is in fact done from the wrong side (should be from the master = Tabs table to the Community Visits table with the ON DELETE CASCADE option - but this is a change to the core system, and therefore not a good practice for modules).

The constraint should be removed, and to keep that table "clean" a task could check from time to time if all values of the tab_id column exist in the Tabs table and delete these records if not.