From http://www.phpbb.com/community/viewtopic.php?f=64&t=993475

Scenario:

I have one existing system with a “user” table. The key elements of this table:

UserID > Auto increment primary key
Email > varchar with unique constraint; this also acts as the login for the “website”
Password > varchar
IsActive > integer for storing user’s “active” status [...]