Idea : add a new table "site subscriptions" which links a user and a site. This would potentially replace starring a site. Difference with stars is that we remove the possibility to mark individual tickets. You can subscribe to a given site or not, basta. And it would add the notion of "primary site" which becomes the default value for a ticket's site when that user submits a new ticket.