from database import get_db_connection

def create_users_table():
    connection = get_db_connection()
    cursor = connection.cursor()
    cursor.execute("""
    CREATE TABLE IF NOT EXISTS users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255),
        email VARCHAR(255) UNIQUE,
        password VARCHAR(255),
        profile_link VARCHAR(255),
        mobile VARCHAR(20),
        country_code VARCHAR(10),
        address TEXT,
        role VARCHAR(50),
        status VARCHAR(50),
        wallet_amount DECIMAL(10, 2),
        credit_balance DECIMAL(10, 2),
        app_id VARCHAR(255),
        app_secret VARCHAR(255),
        app_uuid VARCHAR(255),
        remember_token VARCHAR(255),
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        deleted_at TIMESTAMP NULL
    )
    """)
    connection.commit()
    cursor.close()
    connection.close()

if __name__ == "__main__":
    create_users_table()
    print("Users table created successfully.")