database.py

import sqlite3

def init_db():

    conn = sqlite3.connect("fitness.db")
    cur = conn.cursor()

    cur.execute("""
    CREATE TABLE IF NOT EXISTS users(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    email TEXT UNIQUE,
    goal TEXT,
    fitness_level TEXT,
    equipment TEXT
    )
    """)

    cur.execute("""
    CREATE TABLE IF NOT EXISTS workout_plans(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id INTEGER,
    goal TEXT,
    duration INTEGER
    )
    """)

    conn.commit()
    conn.close()