The index <str> cannot be unique and have a duplicates clause

  Explanation:  An index cannot be defined as UNIQUE and specify
  that DUPLICATES ARE SORTED or DUPLICATES ARE COMPRESSED.

  User Action:  Remove either the UNIQUE syntax or the DUPLICATES
  ARE SORTED or DUPLICATES ARE COMPRESSED syntax.