import sqlite3
from config import DB_PATH


def init_db():
    conn = sqlite3.connect(DB_PATH)
    cur = conn.cursor()

    cur.execute(
        """
        CREATE TABLE IF NOT EXISTS student (
            token TEXT PRIMARY KEY,
            student_id TEXT,
            student_number TEXT,
            student_name TEXT,
            student_sex TEXT,
            dept_name TEXT,
            college_name TEXT,
            professional_name TEXT,
            school_name TEXT,
            raw_json TEXT,
            updated_at INTEGER
        )
        """
    )

    conn.commit()
    conn.close()