![](https://secure.gravatar.com/avatar/908c9abc72ab86111a153b11cb584f26.jpg?s=120&d=mm&r=g)
28 Dec
2017
28 Dec
'17
5:36 p.m.
On Thu, Dec 28, 2017 at 9:34 AM, Sergei Golubchik
In MariaDB (and in SQL standard) the way to achieve that would be to use a nullable column for active, and mark inactive users with NULL. Then you can create a unique index on (phone,active).
That is a neat trick, thanks James and Sergei! -- Jared Beck • (607) 216-5373 • jared@jaredbeck.com