src/streamlit_app/create_auth.py

import sqlite3

def create_auth_database():
    """Create authentication database if not exists"""
    try:
        conn = sqlite3.connect("./user_db/auth.db")
        cursor = conn.cursor()
        
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS users (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                username TEXT UNIQUE NOT NULL,
                password_hash TEXT NOT NULL,
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
            )
        """)
        
        conn.commit()
        conn.close()
        print("✅ Authentication database created successfully")
        
    except Exception as e:
        print(f"❌ Error creating auth database: {e}")

# Chạy function này
create_auth_database()