Private types won't save if there is another person with the same private type

[cfmack]

Use case:
1 User A puts in a new food type: apple sauce
2 System inserts this new type under User A's profile
3 User B goes to add apple sauce
4 User B did not see User A's private type of apple sauce
5 User B goes to add apple sauce

The system fails to give a 'failure' notice and fails to save

[cfmack]

The bug was around the SQL unique indexes. I suspect there is still the following errors:

• unique key does not consider "IsDeleted" types, which is behind the scenes anyways
  -- Does MySQL support filtered indexes?
• If there is a failure, the user is still not notified