import sqlite3


def init_db():
    conn = sqlite3.connect('tasks.db')
    cursor = conn.cursor()

    # Create table for tasks
    cursor.execute('''
    CREATE TABLE IF NOT EXISTS tasks (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        email TEXT NOT NULL,
        task_name TEXT NOT NULL,
        priority TEXT NOT NULL,
        assignee TEXT NOT NULL,
        description TEXT NOT NULL,
        task_start_date TEXT NOT NULL,
        task_end_date TEXT NOT NULL,
        updated_date DATETIME,
        updated_count INTEGER DEFAULT 0
    )
    ''')

    conn.commit()
    conn.close()

if __name__ == "__main__":
    init_db()