Hello, I have my own registration system where users can create accounts, but I would also like to give them the option to use other types of logins, such as OpenID, Gmail, etc.
What would be the best way to represent something like that in the database? Something like User table id type type_id where type references an external table, and type_id the record within that table. so for my own login system it would be mylogintable id username password email for facebook maybe id fullname email for openid id uniqueurl etc... I would then use my User class to map data from the different protocols uniformely. Is there a better way to implement this? I know my discards foreign key checks, which is not ideal... - Alex