Add is_affiliate column to users table
Send affiliate email if is_affiliate is true
Rollback the is_affiliate column
Use referrer_id to test if a user is an affiliate or not
Add default value for referrer_id column
Allow users to be deleted