NYCPHP Meetup

[Chris Snyder]

On Tue, Aug 31, 2010 at 12:43 PM, David Mintz <david at davidmintz.org> wrote:

> What would you do?
> Gratefully yours....

One way to handle the duplicate key problem is to append a flag to the
key when you mark the record inactive. So chsnyder at gmail.com becomes
chsnyder at gmail.com_20100831. That way your tables are ready for the
next chsnyder at gmail.com to come along.

If you want to mark a user inactive AND prevent them from
reregistering, don't add change the key.