Let users sign up and sign in to your app
Finding the sign up, sign in and log out pages in Project Selector. Checking the auth tables in the database.
/account/signin
/account/signup
/account/logout
auth_users
: Tracks users in your appauth_accounts
: Tracks auth methods (email/password, Google, etc.)auth_sessions
: Database-backed user sessionsauth_verification_token
: 2FA verification tokensauth_users
(core profiles) and auth_accounts
(login methods)
auth_users
:
id
: Unique identifier for each username
: User’s display name (optional)email
: User’s email addressemailVerified
: Tracks if email has been verifiedimage
: Profile image URL (optional)auth_accounts
: Links to the auth methods for the userauth_accounts
:
id
: Unique identifier for each auth methoduserId
: Links to the user in auth_userstype
: Authentication type (e.g. “credentials” for email/password)provider
: Auth provider (e.g. “credentials”, “google”)providerAccountId
: ID from the providerrefresh_token
: OAuth refresh tokenaccess_token
: OAuth access tokenexpires_at
: Token expirationtoken_type
: Type of token (e.g. “bearer”)scope
: OAuth scopesid_token
: OAuth ID tokensession_state
: Session statepassword
: Hashed password (for credentials provider)auth_users
table or create a linked profile table with these fields that connects to auth_users
via the user’s ID. This keeps your user data organized while maintaining the core authentication tables.
Linking Data to Users: When you prompt Create to store data per user (like posts, preferences, or settings), Create automatically adds a user_id
field to those database tables. This user_id
connects each piece of data to the specific user in the auth_users
table who owns it. That lets your app later grab the data for a specific user.
/account/logout
in your app’s signed-in experience/
)/app
)/app
page > 3-dot menu > Settings > “Require account to view”/
remains public/app
redirects to sign-in/app
/account/logout
Finding the Project Settings
?error=[code]
.
It can give you a hint on what might be wrong.
Finding the error code in the URL
Can I customize the sign-in page?
Can I add social login (Google, Facebook, Twitter)?
Can I add fields beyond email?