Build User Schema for Registration & Login with Drizzle ORM🔥Setup Config, Generate & Migrate | Ep 10

Build User Schema for Registration & Login with Drizzle ORM🔥Setup Config, Generate & Migrate | Ep 10

T
Thapa Technical
Oct 6, 2025

In this video, we’ll build the User Schema for our Job Portal App using Drizzle ORM with MySQL, and perform a complete setup from start to finish — all in one video! 🚀

You’ll learn how to:
Create the User Schema for registration and login
Understand the folder structure for managing schemas
Define Drizzle config file step-by-step
Use drizzle generate and drizzle migrate commands to push changes to the database
Learn why we use TIMESTAMP for tracking data updates


📂 Source Code: https://github.com/thapatechnical/job-portal-nextjs

🔗 Useful Links:
Next.js Playlist Link: https://youtube.com/playlist?list=PLwGdqUZWnOp0lwvSBaIzzgV9X0ZiZ-42O&si=aQ_TNBNNx5L7V_bn

React.js Playlist Link: https://youtube.com/playlist?list=PLwGdqUZWnOp1Rab71vx2zMF6qpwGDB2Z1&si=sDZRxsYNetYmojKd

TypeScript Playlist Link:https://youtube.com/playlist?list=PLwGdqUZWnOp0xfHQFmlL52b_6-QZ0mnk_&si=c4jfsd5ElDC1p0A5

This video gives you a complete backend setup for your Job Portal App using modern tools like Drizzle ORM, TypeScript, and MySQL.
------------------------------------------------------------------------
🚀 Boost Your Skills with these Pre-Requisite Videos:

🔗 Best HTML Course - https://youtu.be/5ccq_nLHneE
🔗 Best CSS Course - https://youtu.be/MSICFljRcb4
🔗 JavaScript Basics Course Part 1 - https://youtu.be/13gLB6hDHR8
🔗 JavaScript Advanced Course Part 2 - https://youtu.be/YwsOCN8woA8

------------------------------------------------------------------------
💸 Build Your Own E-commerce Website for Free! - https://www.thapatechnical.com/2024/03/build-complete-ecommerce-website-using.html

------------------------------------------------------------------------
✌️ Join Us!

🚀 Become a Member: Unlock perks, free source code, and more Join Now : https://www.youtube.com/channel/UCwfaAHy4zQUb2APNOGXUCCA/join
📷 Connect on Instagram: https://www.instagram.com/thapatechnical
🗨️ Join Our Discord Server: Hang out with fellow programmers Discord Link: https://discord.gg/MdScmCsua6

------------------------------------------------------------------------

⌛TIMELINE⏳
0:00 — Explaining What is User Schema in Job Portal App
1:30 — Creating User Schema Folder Structure
2:30 — Creating User Schema for Registration & Login
4:50 — Must Watch: MySQL Data Types Explained
5:20 — Continuing User Schema with Proper Columns
11:10 — Why We Use TIMESTAMP in Our Schema
13:10 — Creating & Explaining Drizzle Config File
17:00 — Generating User Schema using Drizzle Generate Command
17:32 — Pushing Migration File to Database Server
18:00 — Recap & Next Step in Job Portal App

Timestamps