Add constants for API key types
Only select certain columns in the auth script to avoid things breaking when the table schema changes
Added API-call-specific script