title: Database Design: Register and Verification
body: <p>Is it a good choice to have unverified users into the <code>users_table</code> or should I make a <code>temp_users_table</code> to add the unverified users?</p>
  
  <p>The first option would be to create the row on the <code>users_table</code> with a column, for instance, <code>account_activated</code> to hold a integer that defines if the account is verified or not.</p>
  
  <p>The Second option would be to have two identical tables, <code>users_table</code> and <code>temp_users_table</code>. Adding the unverified users on the last. When verified the row will be copied to the <code>users_table</code> and removerd from <code>temp_users_table</code>.</p>
  
  <p>Which one is better and why?</p>
  
  <p>Edit:</p>
  
  <p>The second table is not meant to stay there for ever, it's temporary and will only exist while the user is not activated. When the user is activated it'll be migrated to the "main" user_table.</p>
  
  <p>So:</p>
  
  <pre><code>users_table: Will have the users that have been verified.
  temp_users_table: Will have ONLY the users that are not verified.
  </code></pre>