Whenever a user registers a free account, I problem a verification code that's later accustomed to verify the account. Once verified, the account is marked
verified=1 and also the verification code removed. Should such data such as the verification code go inside a separate table?
This really is obviously far better to keep temporary data outside of nontemporary. There's you don't need to store that type in the account table. Possess some tblVerificationCodes with FKs towards the account table, timestamps and so forth and remove (or archieve as needed) data out of this table when its likely. This is good style.
if you are planning to keep another data, like verificationDate, ipAddress, etc. you need to use another table for verification information. But when you don't intend to use data, however the "verified" column, concerning the verification, just one column could be saved within the same table,