Help in designing database for website using oAuth to login via facebook, twitter
Am trying to create a website which requires normal registration to the website but also requires the authentication from social media websites like facebook, twitter and linkedin. I want the users to give their authorization only once for the social media websites and be able to post repeatedly on their behalf as required until the token expires.
What should be the database table for this scenario?
Would there be a single users table with userid, username and password for the website and what about the oauth tokens for fb and twitter? How should i go about designing this database? Please help.