server/scripts/create_db.py

#!/usr/bin/env python3
from app.core.database import engine, Base
from app.models.user import User
from app.models.website import Website, WebsiteContent
from app.models.lead import Lead
from app.models.chat import ChatSession, ChatMessage

# Create all tables
Base.metadata.create_all(bind=engine)
print("✅ Database tables created successfully!")

# Print table info
from sqlalchemy import inspect
inspector = inspect(engine)
tables = inspector.get_table_names()
print(f"📊 Created tables: {tables}")