OpenAtlas

Case 1: Since it can happen during imports that various links to types that must not be multiple like system types for places etc. are still multiple, an sql script for removing these duplicates should be designed.

Prerequisites:
1. Check in web.hierarchy for "multiple FALSE" types where value type is FALSE
2. Get all sub types of these
3. Check for duplicate links from one and the same domain_id to more than one of these types (within the type tree of the top category)
4. Design SQL query to show all duplicate links with entity_name and id plus some basic info and info on the multiple link
5. Design admin interface to select which link to delete plus some auto delete function

Case 2: Check for links with identical fields (except for id, created and modified) to get duplicate links
1. Design display and delete function for these duplicates