First, I have a question for clarification:
(1) A user can use "Demo" button to upload and delete data (both simple and complete mapsets)
(2) A user can log in and upload both simple and complete mapsets for sample species
From database perspective, (1) and (2) are not related because data are stored into different tables. Am I correct?
A bug to be solved: For the (2), I have uploaded all three simple and complete mapsets as "review" user. However, I can display all of them, but only one of them is available for me to delete. When I logged in as "admin" user, I can see all of them for deletion.
The reason this may be is because all of them but one were uploaded without you logged in. When data is uploaded with no user logged in, the data is considered public and only the admin can delete it. I have this functionality so only the admin can delete public data.