User workflow

User workflow implementation as discussed with andrew here:
http://www.concrete5.org/developers/pro-accounts/community-leaders-area/community-leaders-discussion/user-level-workflow/

Only "pending" development item is should we write migration for old users who have had the registration setting setup to "On - Activate manually". That hasn't been answered in the discussion thread above.