create_db_tables.py

from sqlmodel import SQLModel
from backend.config.database import engine
from backend.models.user import User
from backend.models.task import Task

async def create_tables():
    """Create all tables in the database"""
    async with engine.begin() as conn:
        await conn.run_sync(SQLModel.metadata.create_all)

if __name__ == "__main__":
    import asyncio
    asyncio.run(create_tables())
    print("Tables created successfully!")