And here is the activation column image: http://i.imgur.com/o78NGVs.png
If the person gets the activation email in his email account and he clicks it, the activation column should change the value from 0 to 1, if he doesn't clicks it. There should be like a timer. If he doesn't clicks within 24 hours, it gets deleted from the db.
Here is a link of a PHP script that has a built in email activation required. The script is simple enough to modify. For a fee, I can modify the script to use PDO, instead of almost deprecated regular MySQL.