Database table creation

Question

1.00/5 (3 votes)

See more:

I am creating a database for Mobile App.
User can Login through user registration or he can login through social media.
Can someone suggest how can i create database for social media login and user registration login.

Initially i had created a table for user registration with all user details including Username and userpassword and now we want the user login through social media. Hence requesting any suggestion for table creation.

Posted 10-Aug-15 4:08am

Manjunath K G

Updated 10-Aug-15 20:40pm

v2

Add a Solution

Comments

E.F. Nijboer 10-Aug-15 11:10am

This isn't a good question. What have you tried? Where did you get stuck? First try google and try to find out for yourself. If you get stuck at some point you can come back and ask help about that specifically.

Sergey Alexandrovich Kryukov 10-Aug-15 14:42pm

What have you tried so far?
What's the problem?
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2015-08-10T10:13:00

If i understand you well, you want to enable user two ways of verification process: 1) via custom logon window, and 2) via social media (whatever it means).

Creating custom authentication method is quite obvious. You can find tons of samples on Google. Second method is bit hard to implement, because those social media must provide a way to return information about result of verification process.

I do recommend to read this:
External Authentication Services with ASP.NET Web API (C#)[^]
OWIN OAuth2 authentication via Social networks[^]

You might be interested in SSO (Single Sign On) method[^].
Basics of Single Sign on (SSO)[^]

Conclusion: No one can show you exact structure of database. It depends on many factors...