I have a table with 4 columns - id(auto incremented), tournament\_id, userid, cash.

userid & tournament\_id may have duplicate entries but combination of tournament\_id and userid is always unique.

So according to my requirement i need to have 2 set of indexes.

1. userid
2. tournament\_id, cash

but i am not able to create index with non unique entries as it keeps giving me following error: 

```
  "Failed to create index : SQL create unique index `test_index` on `table_name` 
  (`tournament_id`) failed : Duplicate entry"

```