Associate a user's subscriptions with their account upon creation.
* all confirmed subscriptions
* unconfirmed subscriptions created within the last week
* delete all unconfirmed subscriptions older than a week
Mark all unconfirmed subscriptions confirmed when a user confirms their email address.