Create an `author_roles` table and populate it from sync-author

[fennifith]

Track the author roles in the database, rather than within meta.roles

This will also be used for filtering profiles from the /content/profiles endpoint to specific roles (e.g. author or partner)