make API usable

Commits to make the api actually usable. database has to be updated, as oauth2 brings new tables.